how to undo a query

[clamcrusher]

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;

[assassingod]

ALTER TABLE 'forum' DROP 'sponsorname'



ALTER TABLE 'forum' DROP 'sponsorimage'



ALTER TABLE 'forum' DROP 'sponsorurl'



ALTER TABLE 'forum' DROP 'sponsorviews'



ALTER TABLE 'forum' DROP 'sponsorclicks'

[clamcrusher]

:( 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&

[clamcrusher]

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

[Erwin]

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;

[clamcrusher]

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;