Log in

View Full Version : What is an SQL QUERY?

mbracing
08-14-2005, 07:18 PM
I am trying to install this away message program, and the first step, it says...

================================================== ========
RUN THE FOLLOWING SQL QUERY
================================================== ========
ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL

================================================== ========



What is that?
Andreas
08-14-2005, 07:28 PM
A SQL Query :)

ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
TTG
08-14-2005, 07:28 PM
your forum is based on sql tables .. you need to run a query to update / change / add to the table structure in order to make a hack work sometimes.

You can either do this in your admincp >> Maintenance >> Execute sql query or run it in phpmyadmin.
mbracing
08-14-2005, 07:48 PM
A SQL Query :)

ALTER TABLE `user` ADD `awaystatus` INT( 1 ) UNSIGNED DEFAULT '0' NOT NULL ,
ADD `awaymessage` VARCHAR( 200 ) NOT NULL ,
ADD `awaysince` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL
ok im very confussed now, i clicked the link you gave me, and pressed download, and it brings me to this page with purple highlighting on it. How do i download PHPmyadmin???