how to undo a query
 

i ran some queries and i dont like the hack. how do i undo those queries?

i assume i just run another query?

these are the ones which need to be undone:

ALTER TABLE forum ADD sponsorname VARCHAR(50) not null AFTER cancontainthreads;

ALTER TABLE forum ADD sponsorimage VARCHAR(200) not null AFTER sponsorname;

ALTER TABLE forum ADD sponsorurl VARCHAR(255) not null AFTER sponsorimage;

ALTER TABLE forum ADD sponsorviews MEDIUMINT(10) not null default '0' AFTER sponsorurl;

ALTER TABLE forum ADD sponsorclicks MEDIUMINT(10) not null default '0' AFTER sponsorviews;

[SQL]
ALTER TABLE 'forum' DROP 'sponsorname'
[/SQL]

[SQL]
ALTER TABLE 'forum' DROP 'sponsorimage'
[/SQL]

[SQL]
ALTER TABLE 'forum' DROP 'sponsorurl'
[/SQL]

[SQL]
ALTER TABLE 'forum' DROP 'sponsorviews'
[/SQL]

[SQL]
ALTER TABLE 'forum' DROP 'sponsorclicks'
[/SQL]

:( it does this for all of them

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: ALTER TABLE 'forum' DROP 'sponsorname'
mysql error: You have an error in your SQL syntax near ''forum' DROP 'sponsorname'' at line 1

mysql error number: 1064

Date: Saturday 16th of August 2003 12:57:27 PM
Script: http://www.anabolic-alchemy.com/admin/query.php
Referer: http://209.67.24.185/admin/query.php?t=0&

btw im using the hack from here which lets me do queries from admin cp. think that might be my problem?

Use the same queries, but don't put in the ' symbol and add a ; at the end.

eg. like this:

ALTER TABLE forum DROP sponsorname;

does this mean it did it?

result:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/anabolic-alchemy.com/httpdocs/admin/query.php on line 27
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/anabolic-alchemy.com/httpdocs/admin/query.php on line 29
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/psa/home/vhosts/anabolic-alchemy.com/httpdocs/admin/query.php on line 33

Query Result - ALTER TABLE forum DROP sponsorname;