The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
Is there a query I can run to fix my forumdisplay and showthread.
I was trying to install a hack it messed that part of my database up. Thanks! |
#2
|
||||
|
||||
![]()
Without knowing the original query, there ain't much we can do.
|
#3
|
||||
|
||||
![]()
this is what happened
// ###################### Start install db ####################### if ($action=="db") { echo "<p>Resetting TABLE BBcode ..."; echo "<p>Templates and Files imported correctly!</p>"; doformheader("$installer","changetemp"); $DB_site->query("DROP TABLE IF EXISTS bbcode"); $DB_site->query("CREATE TABLE bbcode ( bbcodeid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment, bbcodetag varchar(200) NOT NULL, bbcodereplacement varchar(200) NOT NULL, bbcodeexample varchar(200) NOT NULL, bbcodeexplanation mediumtext NOT NULL, twoparams smallint(6) DEFAULT '0' NOT NULL, PRIMARY KEY (bbcodeid) )"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'b', '<b>\\\\4</b>', 'Bold', 'The [b] tag allows you to write text bold', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'i', '<i>\\\\4</i>', 'Italics', 'The [i] tag allows you to write text in italics', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'email', '<a href=\"mailto:\\\\4\">\\\\4</a>', 'support@hisquad.net', 'The [email] tag allows you to include email addresses.', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'email', '<a href=\"mailto:\\\\5\">\\\\7</a>', 'HiSquad Support', 'This email tag allows you to include your own text in an email field.', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'fl', '<embed src=\"\\\\5\" \\\\7 type=application/x-shockwave-flash></embed>', '[fl=http://www.hisquad.net/banner/hisquad.swf] width=\"330\" height=\"50\" [/fl]', 'flash', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'size', '<font size=\"\\\\5\">\\\\7</font>', 'Size 1', 'The [size] tag allows you to control the size of the font.', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'quote', '<blockquote><smallfont>quote:</smallfont><hr>\\\\4<hr></blockquote>', ' Quote:
$DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'u', '<u>\\\\4</u>', 'Underline', 'The [u] tag allows you to underline text.', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'color', '<font color=\"\\\\5\">\\\\7</font>', 'Red!', 'The [color] tag allows you to specify the font color.', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'font', '<font face=\"\\\\5\">\\\\7</font>', 'Test', 'You can change the font of your text.', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'glow', '<font style=\"filter:glow(color=\\\\5\,strength=4);heigh t=1px\">\\\\7</font>','[glow=red]Glow[/glow]', 'glow', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'shadow', '<font style=\"filter:shadow(color=\\\\5\,direction=225); height=1px\">\\\\7</font>','[shadow=red]Shadow[/shadow]', 'shadow', 1)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'blur', '<table style=\"filter:blur(add=0,dirction=45,strength=3)\ ">\\\\4</table>', '[blur]Blur[/blur]', 'blur', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'hide', '<span style=\"background-color:#293952\"><font color=\"#293952\">\\\\4</span></font>', '[hide]Hide Text[/hide]', 'hide', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'web', '<iframe width=550 height=400 src=\"\\\\4\"></iframe>', '[web]http://www.hisquad.net[/web] ', 'web', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'icq', '<font size=1 color=#003366>ICQ:<a href=\"http://wwp.icq.com/scripts/search.dll?to=\\\\4\">\\\\4<img src=\"http://wwp.icq.com/scripts/online.dll?icq={param}&img=5\" border=0></a></font>', '[icq]102832316[/icq]', 'ICQ', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'waver', '<bgsound src=\"\\\\4\" loop=\"infinite\">', '[waver]http://www.hisquad.net/hoopstar/001.wav[/waver]', 'waver', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'moved', '<marquee direction=\"down\" scrollamount=\"3\">\\\\4</marquee>', '[moved] To down[/moved]', '',0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'moveup', '<marquee direction=\"up\" scrollamount=\"3\">\\\\4</marquee>', '[moveup]To Up[/moveup]', '',0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'movel', '<marquee direction=\"left\">\\\\4</marquee>', '[movel] To Left[/movel]', '',0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'mover', '<marquee direction=\"right\">\\\\4</marquee>', '[mover]To Right [/mover]', '', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'j', '<p align=\"justify\">\\\\4</p>', '[j] Justify [/j]', 'Justify', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'r', '<p align=\"right\">\\\\4</p>', '[r] Right [/r]', 'Right', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'c', '<p align=\"center\">\\\\4</p>', '[c] center[/c]', 'center', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'l', '<p align=\"left\">\\\\4</p>', '[l] Lift [/l]', 'Lift', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'sound', '<param name=\"BACKGROUNDCOLOR\" <br /><embed src=\"\\\\4\" align=\"baseline\" border=\"0\" width=\"275\" height=\"40\" type=\"audio/x-pn-realaudio-plugin\" console=\"Clip1\" controls=\"ControlPanel\" autostart=\"true\">\n<b', '[sound]http://media.islamway.com/arabic/images/quran/khayyat/001.ram[/sound]', 'sound', 0)"); $DB_site->query("INSERT INTO bbcode VALUES ( NULL, 'video', '<div align=\"center\"><embed src=\"\\\\5\" \\\\7></div> ', '[video=http://www.hisquad.net/HiSquad.mpag] width=\"400\" height=\"400\" [/video] ', 'video', 1)"); $path="./vbcode_buttons.style"; $stylefile = $path; $styletext=readfromfile($stylefile); @unlink($stylefile); $stylebits=explode("|||",$styletext); list($devnul,$styleversion)=each($stylebits); list($devnul,$style[title])=each($stylebits); list($devnul,$replacementset[title])=each($stylebits); list($devnul,$templateset[title])=each($stylebits); $style[styleid]=-1; $style[userselect]=0; $style[replacementsetid]=-1; $style[templatesetid]=-1; list($devnull,$numtemplates)=each($stylebits); $counter=0; while ($counter++<$numtemplates) { list($devnull,$title)=each($stylebits); list($devnull,$template)=each($stylebits); if (trim($title)!="") { $DB_site->query("DELETE FROM template WHERE title= '$title' "); $DB_site->query("INSERT INTO template (templatesetid,title,template) VALUES ($style[templatesetid],'".addslashes($title)."','".addslashes($template) ."')"); } } doformfooter("Next Step =>",""); } I tried to intall a toolbar Thanks for checking this out!! it seems like my newreply has been affected too this is the error I get Database error in vBulletin 2.3.5: Invalid SQL: SELECT bbcodetag,bbcodereplacement,twoparams FROM bbcode mysql error: Table 'kocontent.bbcode' doesn't exist mysql error number: 1146 Date: Tuesday 13th of December 2005 03:21:37 AM Script: http://rapchoice.com/forums/forums/s...&threadid=3478 Referer: http://www.rapchoice.com/forums/foru...s=&forumid=161 Repair Report: This type of error cannot be automatically repaired. .......................... I tried to create the bbcode table and this is what I got SQL query: CREATE TABLE bbcode( bbcodeid smallint( 5 ) unsigned DEFAULT '0' NOT NULL AUTO_INCREMENT , bbcodetag varchar( 200 ) NOT NULL , bbcodereplacement varchar( 200 ) NOT NULL , bbcodeexample varchar( 200 ) NOT NULL , bbcodeexplanation mediumtext NOT NULL , twoparams smallint( 6 ) DEFAULT '0' NOT NULL , PRIMARY KEY ( bbcodeid ) ) MySQL said: #1067 - Invalid default value for 'bbcodeid' ------------ What default value will work for this? ------------- CREATE TABLE bbcode ( bbcodeid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment, bbcodetag varchar(200) NOT NULL, bbcodereplacement varchar(200) NOT NULL, bbcodeexample varchar(200) NOT NULL, bbcodeexplanation mediumtext NOT NULL, twoparams smallint(6) DEFAULT '0' NOT NULL, PRIMARY KEY (bbcodeid) ) ---------------- from the orginal installation I found this ^^ query |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|