Date: 06/08/07 (MySQL Communtiy)    Keywords: php, mysql, sql, web, apache

I have what is probably an easy question, but I've been Googling and don't quite know where to go.

I write and test MySQL queries on a virtual Apache server on my PC before transferring it to the live server on a website. At the moment, I write the MySQL through a command-line interface, which makes it very difficult (almost impossible) to go back and edit the query if I need to change things or have made mistakes. It seems to take much longer to develop things than it should!

At work, I use Teradata SQL and we have a nice graphical interface where we can type in SQL, edit it easily, save SQL to re-use and all those good things. It's much easier to develop in and also easier to copy and paste the query into other files, such as Excel or PHP.

Can anyone recommend a good equivalent program for MySQL?

Source: http://community.livejournal.com/mysql/114511.html

Date: 06/08/07 (Mozilla)    Keywords: xml, web

I'm trying to add firefox functionality to get my AJAX control working on my website. This is the page in question. The error I'm getting is xmlobj has no document properties. Does anyone know where I went wrong?

I've included the code below for your info.


function changeListFF()
{
var plat = document.getElementById("platform")
var lett = document.getElementById("letters")
var alpha = new Array('#', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');

for(i = 0; i <= alpha.length; i++)
{
if(((plat.value == "Megadrive") || (plat.value == "MegaCD")) && (lett.value == alpha[i]))
{
checkList()

if(plat.value == "Megadrive")
{
var xmlDoc=document.implementation.createDocument("", "", null);
xmlDoc.async="false"
xmlDoc.load("megadrive.xml")
var xmlobj = xmlDoc.documentElement;
}
else if(plat.value == "MegaCD")
{
var xmlDoc=document.implementation.createDocument("", "", null);
xmlDoc.async="false"
xmlDoc.load("megacd.xml")
var xmlobj = xmlDoc.documentElement;
}

for(j = 0; j < xmlobj.childNodes.length; j++)
{
if(xmlobj.childNodes(j).tagName == alpha[i])
{
var data = xmlobj.childNodes(j).firstChild.text
var optionElement = document.createElement('option')
var gameElement = document.getElementById("game")
optionElement.text = data
gameElement.add(optionElement)
}
}
totNum()
}
}
}


Thanks very much!

Source: http://community.livejournal.com/mozilla/390062.html

Date: 06/08/07 (Security)    Keywords: web

Patch for Messenger addresses zero-day exploits that take advantage of vulnerabilities in its Webcam ActiveX controls.

Source: http://news.zdnet.com/2100-1009_22-6189627.html

Date: 06/09/07 (Web Development)    Keywords: web, shopping

So I would like to add shopping carts to my web packages. How should I do this? Do people let customers choose the one they want or use a specific one for clients then buy additional licenses when requested?

Or do most code their own and offer them that way?

thanks in advance!

Source: http://community.livejournal.com/webdev/413290.html

Date: 06/09/07 (Java Web)    Keywords: web

I am looking at Tata Indicom Broadband connection (unlimited 1Mbps plan) as a backup broadband connection in Kolkata. Browsing the web I found several pretty negative experiences with Tata Indicom Broadband connection (provided below). Here is a review of experiences with Tata Indicom Broadband connection; must-read if you are considering Tata Indicom broadband for home [...]

Source: http://blog.taragana.com/index.php/archive/tata-indicom-broadband-connection-review/

Date: 06/10/07 (Java Web)    Keywords: web

We received over 1 million visitors as early as Feburary 2007 and with over 12 million page hits. We have been observing steady growth throughout the year so far. Monthly Statistics for February 2007 Total Hits 12903959 Total Files 11648688 Total Pages 6077448 Total Visits 1046646 Total KBytes 117331848 Total Unique URLs 79051 Total Unique Referrers 50723 Total Unique User Agents 17339 Page statistics compiled by Webalizer. This year we are working harder than [...]

Source: http://blog.taragana.com/index.php/archive/milestone-1-million-visitors-in-february-2007/

Date: 06/11/07 (Web Development)    Keywords: web

For all you web developers who have been agonizing over whether your stuff works right in Safari: Safari 3 beta is now available for Windows! I haven't yet downloaded it or tried it out, and I can't yet vouch for whether everything works exactly the same. But at least it's progress.

Source: http://community.livejournal.com/webdev/414671.html

Date: 06/12/07 (Web Technology)    Keywords: web

The search giant says it is scaling back how long it keeps personally identifiable data accumulated from its Web users.

Source: http://news.zdnet.com/2100-9588_22-6190329.html

Date: 06/13/07 (Java Web)    Keywords: browser, java, web

Java applets had taken a beating in the past. Now it appears applets are making a resurgence lately with some quality applet based products. But the real question is how much Java support in browsers it can count on today. Refreshingly Java is still supported on 97.92 % of the browsers based on our web [...]

Source: http://blog.taragana.com/index.php/archive/applets-20-java-flash-support-in-browsers/

Date: 06/13/07 (Java Web)    Keywords: web

Angsuman’s Translator Plugin Pro & Gold collects and display useful statistics on the functionality of the plugin as well as the intelligent caching engine. The statistics is available from Translator Plugin Pro Options panel in Basic tab and in Advanced -> Cache Management tab. It is also available for display on your web pages as [...]

Source: http://blog.taragana.com/index.php/archive/angsumans-translator-plugin-pro-gold-statistics/

Date: 06/13/07 (PHP Community)    Keywords: php, security, web

Windows 2003 server with the latest updates
PHP v5.2.0

I have the following setup:

In...

D:\FTPRoot\Data

there are logons names in there which is linked to their account, i.e. when they log on via FTP, they go straight to their directory, i.e.

D:\FTPRoot\Data\USERNAME

Each directory have the security set to their own account, i.e.

USERNAME (SERVER\USERNAME)

Recently, one of the user did something naughty and wrote an code where they can see someone else's directory and put some ranmdom generated files in there. The code in question is;

&opFile = "./../username1/hello" . & random . ".txt";

Obviously I'm not going to post the full code but this should be a start.

As you can see, the user managed to wrote some files in someone else's directory, even that their security setup doesn't allow it, which I suspect is part of a 'system' account. However under the "D" drive, there is no "SYSTEM" account in there, it has been totally removed. The only thing left are

Administrator
CREATOR OWNERS

and the D:\FTPRoot\Data has the security setup as:

Administrator
CREATOR OWNERS
FTP User Admin (FTP admin acess for webmasters)
IIS_WPG
Internet Guest Account

In php.ini I also have these line:

disable_functions = "phpinfo, passthru, system, popen, escapeshellarg, escapeshellcmd"

But it is not working.

So, what am I missing and how do I stop these pesky user from doing this?

Many thanks

Source: http://community.livejournal.com/php/571097.html

Date: 06/13/07 (WebDesign)    Keywords: web

hi there, im creating a website for my biology class in dreamwever, wich i dont quite get and i cant realy find the tuts online to help me. i know about flash, but i cant seem to aply it to dreamweaver. for instance, i dont know how to upload a button you did on flash. and hoe to put a link in it... and how can i put up a news scroling journal like thing, so i can edit it online?
thanks and heres the link, tough its always changing as im just trying to work things out at the moment.

:)

Source: http://community.livejournal.com/webdesign/1264642.html

Date: 06/13/07 (WebDesign)    Keywords: web, yahoo

whats a simple way of getting that sunbeam effect over a background like above? is there a fireworks shortcut or anything? (image taken from a Yahoo newsletter email)

ALSO... FYI cool firefox add-on for web developers here: https://addons.mozilla.org/en-US/firefox/addon/60

Source: http://community.livejournal.com/webdesign/1264196.html

Date: 06/14/07 (WebDesign)    Keywords: asp, web

The person's website I'm working on wants a top banner/image that will partially slide through a series of images. Eg. http://www.rapidascent.com.au/asp/AnacondaEventChooser.asp (on the left, not the right sliding logos).

I only know of two ways to do this:
- Flash
- GIF

The question I have is:
- the demographic for the site is apparently "older" and in regional areas (dial up), would Flash kill their computers in terms of requiring Macromedia and etc?
- Would the GIF file be too big for their dial up?

Any suggestions on other ways I can do it?

Thanks.

Source: http://community.livejournal.com/webdesign/1265212.html

Date: 06/14/07 (Web Technology)    Keywords: web

You may have to surrender what's in your RAM if sued. Legal experts say decision may cost businesses big bucks and threaten Web privacy.

Source: http://news.zdnet.com/2100-9588_22-6190900.html

Date: 06/14/07 (Java Web)    Keywords: web

Weblog tools collection has announced a WordPress plugins competition. The competition began on 1st June (2007) and will last till the end of July. We are sponsoring a copy Angsuman’s Translator Plugin Pro as prize for the competition to help foster quality WordPress plugin development. Here is your chance to develop a cool WordPress [...]

Source: http://blog.taragana.com/index.php/archive/how-to-get-free-copy-of-translator-plugin-pro/

Date: 06/14/07 (PHP Community)    Keywords: web

I am one of 4 developers that maintain about 60+ websites of varying size and complexity... Generally things are okay, but recently in the last month we changed the passwords for one of the centralized DB servers and its naturally causing some problems. So I was wondering how other people handle updating en mass, individual websites when something mission critical like the DB credential changes.

Source: http://community.livejournal.com/php/572210.html

Date: 06/15/07 (WebDesign)    Keywords: html, web

Hi all...



I have been composing HTML emails for a company I do work for through Constant Contact for a long time. Since I've embroiled myself in the world of HTML email, I'd like to be able to send them myself.



This has turned me onto the fact that very few email clients actually allow you to compose HTML email. Wikipedia tells me Thunderbird will let you, but bizarrely, whenever I try to download Thunderbird and open it, everything freezes and I have to force quit or force restart.



I'm on a Mac. A few Macs, actually. Primarily I'm using OS 10.3.9. Can anyone suggest an email client to me (or tell me what the heck is up with Thunderbird)?



Thanks!



x-posted to webdesign

Source: http://community.livejournal.com/webdesign/1266401.html

Date: 06/15/07 (Mozilla)    Keywords: web

I'm currently using Firefox ver. 2.0.0.4.

I love FF and have never had any problems until now. I don't have any add-ons, and nothing that I know of has changed recently. I do recall a recent minor FF update, but I can't recall exactly when it was. Everything is running fine except for one webpage that I visit regularly. She recently changed it to a new location and at first I could see it fine, but suddenly (in the past several days) none of the graphics will show up, not even a placeholder for the graphics. I can view it fine in IE7.

Any thoughts?

the site is - http://greys.faithful-departed.net/

Source: http://community.livejournal.com/mozilla/390554.html

Date: 06/15/07 (Computer Geeks)    Keywords: web

Hi there...

I just recently got a new HP laptop and I cannot figure out how to use the camera/web cam that is included in the laptop. Help?

Thanks.

Source: http://community.livejournal.com/computergeeks/1080944.html