The Arcive of Official vBulletin Modifications Site.

FleaBag · #1 05-20-2002, 03:09 PM

I added the original toplist hack to my database, but now I want to remove it I'm having some trouble with the SQL... The original command I ran is below...

Quote:

INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_menu', '<normalfont><a href=toplist.php?s=$session[sessionhash]>Toplist</a> | <a href=toplist.php?s=$session[sessionhash]&action=add>Add Site</a> | <a href=toplist.php?s=$session[sessionhash]&action=edit>Edit Site</a></normalfont>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_addsite', '{htmldoctype}\r\n<html>\r\n<head><title>$bbtitle - Toplist</title>\r\n$headinclude \r\n</head> <body> $header \r\n<div align=center>$toplistmenu</div><br><form action=\"toplist.php\" method=\"post\">\r\n<table cellpadding=\"{tableouterborderwidth}\" cellspacing=\"0\" border=\"0\" bgcolor=\"{tablebordercolor}\" {tableouterextra} width=\"{contenttablewidth}\" align=\"center\"><tr><td>\r\n<table cellpadding=\"4\" cellspacing=\"{tableinnerborderwidth}\" border=\"0\" {tableinnerextra} width=\"100%\">\r\n<tr> \r\n<td bgcolor=\"{tableheadbgcolor}\" colspan=\"2\"><normalfont color=\"{tableheadtextcolor}\" class=\"thtcolor\"><b>Add Site </b></normalfont> <smallfont color=\"{tableheadtextcolor}\" class=\"thtcolor\">(All fields are required.)</smallfont></td>\r\n</tr><tr> \r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site Title:</b></normalfont></td>\r\n<td bgcolor=\"{secondaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"title\" size=\"25\" maxlength=\"50\"></td>\r\n</tr>\r\n<tr> \r\n<td bgcolor=\"{firstaltcolor}\"><normalfont><b>Site Description:</b></normalfont></td>\r\n<td bgcolor=\"{firstaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"description\" size=\"25\" maxlength=\"200\">\r\n</td>\r\n</tr><tr> \r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site URL:</b></normalfont></td>\r\n<td bgcolor=\"{secondaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"siteurl\" value=\"http://\" size=\"25\" maxlength=\"100\">\r\n</td>\r\n</tr></table></td></tr></table>\r\n<div align=\"center\">\r\n<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\">\r\n<input type=\"hidden\" name=\"action\" value=\"addsite\">\r\n<br><input type=\"submit\" class=\"bginput\" name=\"Submit\" value=\"Submit\">\r\n<input type=\"reset\" class=\"bginput\" name=\"Reset\" value=\"Reset\">\r\n</div>\r\n</form>$footer \r\n</body>\r\n</html>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_redirect_add', 'Thank you, your site has been added to the toplist.');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_error_allfields', 'All fields are required.');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_editsite_nosites', 'You have no sites in the database.');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_editsite', '{htmldoctype}\r\n<html>\r\n<head><title>$bbtitle - Toplist</title>\r\n$headinclude \r\n</head> <body> $header \r\n<div align=center>$toplistmenu</div><br>\r\n$editsitebit\r\n$footer \r\n</body>\r\n</html>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_redirect_delete', 'Your site has been deleted from the toplist.');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_redirect_edit', 'Your site info has been updated.');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplistbit_nosites', '<tr bgcolor=\"{firstaltcolor}\"> \r\n <td align=\"center\"><normalfont>1</normalfont></td>\r\n <td><normalfont><b>\r\n<a href=toplist.php?s=$session[sessionhash]&action=add>Add Your Site</a></b></normalfont><br><smallfont>Add your site to our toplist and receive tons of high quality traffic!</smallfont></td>\r\n <td align=\"center\"><normalfont>0</normalfont></td>\r\n <td align=\"center\"><normalfont>0</normalfont></td>\r\n </tr>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_editsitebit', '<form action=\"toplist.php\" method=\"post\">\r\n<table cellpadding=\"{tableouterborderwidth}\" cellspacing=\"0\" border=\"0\" bgcolor=\"{tablebordercolor}\" {tableouterextra} width=\"{contenttablewidth}\" align=\"center\"><tr><td>\r\n<table cellpadding=\"4\" cellspacing=\"{tableinnerborderwidth}\" border=\"0\" {tableinnerextra} width=\"100%\">\r\n<tr> \r\n<td bgcolor=\"{tableheadbgcolor}\" colspan=\"2\"> <normalfont color=\"{tableheadtextcolor}\" class=\"thtcolor\"><b>Edit Site</b> </normalfont><a href=toplist.php?s=$session[sessionhash]&action=delete&topid=$topid><smallfont color=\"{tableheadtextcolor}\" class=\"thtcolor\">[Delete Site]</smallfont></a></td>\r\n</tr><tr> \r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site Title:</b></normalfont></td>\r\n<td bgcolor=\"{secondaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"title\" value=\"$title\" size=\"25\" maxlength=\"50\"></td>\r\n</tr>\r\n<tr> \r\n<td bgcolor=\"{firstaltcolor}\"><normalfont><b>Site Description:</b></normalfont></td>\r\n<td bgcolor=\"{firstaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"description\" value=\"$description\" size=\"25\" maxlength=\"200\">\r\n</td>\r\n</tr> <tr> \r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site URL:</b></normalfont></td>\r\n<td bgcolor=\"{secondaltcolor}\">\r\n<input type=\"text\" class=\"bginput\" name=\"siteurl\" value=\"$siteurl\" size=\"25\" maxlength=\"100\">\r\n</td>\r\n</tr>\r\n<tr> \r\n<td bgcolor=\"{firstaltcolor}\"><normalfont><b>Today\' s Stats:</b></normalfont></td>\r\n<td bgcolor=\"{firstaltcolor}\"><normalfont>Hits In: <b>$in</b> | Hits Out: <b>$out</b></normalfont>\r\n</td>\r\n</tr>\r\n<tr> \r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><b>Vote URL:</b></normalfont></td>\r\n<td bgcolor=\"{secondaltcolor}\"><normalfont><a href=\"$bburl/toplist.php?action=in&topid=$topid\">$bburl/toplist.php?action=in&topid=$topid</a></normalfont>\r\n</td>\r\n</tr>\r\n</table></td></tr></table>\r\n<div align=\"center\">\r\n<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\">\r\n<input type=\"hidden\" name=\"action\" value=\"editsite\">\r\n<input type=\"hidden\" name=\"topid\" value=\"$topid\">\r\n<br><input type=\"submit\" class=\"bginput\" name=\"Submit\" value=\"Submit\">\r\n<input type=\"reset\" class=\"bginput\" name=\"Reset\" value=\"Reset\">\r\n</div>\r\n</form>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist', '{htmldoctype}\r\n<html>\r\n<head><title>$bbtitle - Toplist</title>\r\n$headinclude \r\n</head> <body> $header \r\n<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"right\">\r\n <tr>\r\n <td>\r\n<div align=center>$toplistmenu</div><br>\r\n<table cellpadding=\"{tableouterborderwidth}\" cellspacing=\"0\" border=\"0\" bgcolor=\"{tablebordercolor}\" {tableouterextra} width=\"{contenttablewidth}\" align=\"center\"><tr><td>\r\n <table cellpadding=\"4\" cellspacing=\"{tableinnerborderwidth}\" border=\"0\" {tableinnerextra} width=\"100%\">\r\n <tr> \r\n <td bgcolor=\"{tableheadbgcolor}\" width=\"30\"> <normalfont color=\"{tableheadtextcolor}\"><b>Rank</b></normalfont></td>\r\n <td align=center bgcolor=\"{tableheadbgcolor}\"><normalfont color=\"{tableheadtextcolor}\"><b>Site description</b></normalfont></td>\r\n <td bgcolor=\"{tableheadbgcolor}\" width=\"30\" align=center><normalfont color=\"{tableheadtextcolor}\"><b>In</b></normalfont></td>\r\n <td bgcolor=\"{tableheadbgcolor}\" width=\"30\" align=center><normalfont color=\"{tableheadtextcolor}\"><b>Out</b></normalfont></td>\r\n </tr>$toplistbit</table>\r\n</td></tr></table>\r\n</td></tr></table>\r\n$footer \r\n</body>\r\n</html>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplistbit', '<tr bgcolor=\"$bgcolor\"> \r\n <td align=\"center\"><normalfont>$rank</normalfont></td>\r\n <td><normalfont><b><a href=toplist.php?action=out&topid=$topid target=_blank>$title</a></b></normalfont><br><smallfont>$description</smallfont></td>\r\n <td align=\"center\"><normalfont>$in</normalfont></td>\r\n <td align=\"center\"><normalfont>$out</normalfont></td>\r\n </tr>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplistbit_admin_nosites', '<tr bgcolor=\"{firstaltcolor}\"> \r\n <td align=\"center\"><normalfont>No sites in the database</normalfont></td>\r\n </tr>');
INSERT INTO template (templatesetid,title,template) VALUES('1','toplist_adminbit', '<form action=\"toplist.php\" method=\"post\">\r\n <table cellpadding=\"{tableouterborderwidth}\" cellspacing=\"0\" border=\"0\" bgcolor=\"{tablebordercolor}\" {tableouterextra} width=\"{contenttablewidth}\" align=\"center\">\r\n <tr>\r\n <td> \r\n <table cellpadding=\"4\" cellspacing=\"{tableinnerborderwidth}\" border=\"0\" {tableinnerextra} width=\"100%\">\r\n <tr> \r\n <td bgcolor=\"{tableheadbgcolor}\" colspan=\"2\"> <normalfont color=\"{tableheadtextcolor}\" class=\"thtcolor\"><b>Edit \r\n Site</b> </normalfont><a href=toplist.php?s=$session[sessionhash]&action=admindelete&topid=$topid&pw=$pw><smallf ont color=\"{tableheadtextcolor}\" class=\"thtcolor\">[Delete \r\n Site]</smallfont></a></td>\r\n </tr>\r\n <tr> \r\n <td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site Title:</b></normalfont></td>\r\n <td bgcolor=\"{secondaltcolor}\"> \r\n <input type=\"text\" class=\"bginput\" name=\"title\" value=\"$title\" size=\"25\" maxlength=\"50\">\r\n </td>\r\n </tr>\r\n <tr> \r\n <td bgcolor=\"{firstaltcolor}\"><normalfont><b>Site Description:</b></normalfont></td>\r\n <td bgcolor=\"{firstaltcolor}\"> \r\n <input type=\"text\" class=\"bginput\" name=\"description\" value=\"$description\" size=\"25\" maxlength=\"200\">\r\n </td>\r\n </tr>\r\n <tr> \r\n <td bgcolor=\"{secondaltcolor}\"><normalfont><b>Site URL:</b></normalfont></td>\r\n <td bgcolor=\"{secondaltcolor}\"> \r\n <input type=\"text\" class=\"bginput\" name=\"siteurl\" value=\"$siteurl\" size=\"25\" maxlength=\"100\">\r\n </td>\r\n </tr>\r\n <tr> \r\n <td bgcolor=\"{firstaltcolor}\"><normalfont><b>Today\' s Stats:</b></normalfont></td>\r\n <td bgcolor=\"{firstaltcolor}\"><normalfont>Hits In: <b>$in</b> | Hits \r\n Out: <b>$out</b> | Current Rank: <b>$rank</b></normalfont> </td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n <div align=\"center\"> \r\n <input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\">\r\n <input type=\"hidden\" name=\"action\" value=\"admineditsite\">\r\n <input type=\"hidden\" name=\"pw\" value=\"$pw\">\r\n <input type=\"hidden\" name=\"topid\" value=\"$topid\">\r\n <input type=\"submit\" class=\"bginput\" name=\"Submit\" value=\"Submit\">\r\n <input type=\"reset\" class=\"bginput\" name=\"Reset\" value=\"Reset\">\r\n </div>\r\n</form>');

...Could anyone be so generous as to help me by suppling the command I'd need to run to remove what I've added? Thanks guys.

FleaBag · #2 05-20-2002, 03:13 PM

Ooo0oer I just pasted that and didn't realise it was as big as it is... Most of it is HTML that isn't relevant though... I think.

Admin · #3 05-20-2002, 04:16 PM

Run this query:

Code:

DELETE FROM template WHERE title IN ('toplist_menu','toplist_addsite','toplist_redirect_add','toplist_error_allfields','toplist_editsite_nosites','toplist_editsite','toplist_redirect_delete','toplist_redirect_edit','toplist_editsitebit','toplist','toplistbit','toplistbit_admin_nosites','toplist_adminbit')

FleaBag · #4 05-21-2002, 10:08 AM

FireFly to the rescue! Heh heh! Thanks once again!

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03870 seconds Memory Usage 2,212KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (4)postbit (4)postbit_onlinestatus (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!