PDA

View Full Version : Need help on running Queries


Larry@IOG
08-24-2002, 02:14 PM
Ihave the hack in my admin CP but I do not understand what I need to do really to install a new hack. Here is the directions with the hack:

Queries to run:

ALTER TABLE user ADD away tinyint(1) DEFAULT '0' not null AFTER nosessionhash

ALTER TABLE user ADD awaydate int(10) unsigned AFTER away

ALTER TABLE user ADD returndate date DEFAULT '0000-00-00' AFTER awaydate

ALTER TABLE user ADD awayreason varchar(200) AFTER returndate

Thanks for your time.

Larry Jude
www.impulseownersgroup.com

Xenon
08-24-2002, 02:16 PM
You have installed FireFlys run queries from ACP Hack?

Then just type into the inputfield one of these queries, click on run query
then just do the same with next query and so on

Larry@IOG
08-24-2002, 02:19 PM
For example I would type in this:

ALTER TABLE user ADD away tinyint(1) DEFAULT '0' not null AFTER nosessionhash
then hit the button? is it really that simple?

Larry

Xenon
08-24-2002, 02:19 PM
yes, running queries is very simple ;)

Larry@IOG
08-24-2002, 02:24 PM
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/log2377/public_html/vb/admin/query.php on line 27
Query Result - ALTER TABLE user ADD away tinyint(1) DEFAULT '0' not null AFTER nosessionhash

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/log2377/public_html/vb/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/log2377/public_html/vb/admin/query.php on line 33

K i think i screwed up on something simple

Larry

Xenon
08-24-2002, 02:29 PM
i don't know if chens hack works correct (i believe there is an updated version out by so else), is run queries through phpmyadmin

UPDATE
click on the link how to run queries, there i think you'll get much answers also ;)