PDA

View Full Version : Query Problems

King Kovifor
07-29-2005, 05:50 PM
Now this error... After that one... How do I reverse it?:

Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO template (styleid, title, template, template_un, dateline, username, version) VALUES (
'-1',
'shoutbox_archive',
'$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title>$vboptions[bbtitle] - $vbphrase[shoutbox]</title>
$headinclude
<script language=\\\"javascript\\\">
<!--
function validate(theform)
{
if (theform.pagetext == \\\"\\\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>

</head>
<body>

$header
$navbar

$pagenav

<table cellpadding=\\\"2\\\" cellspacing=\\\"0\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<tr valign=\\\"top\\\">
<td width=\\\"60%\\\">


<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr>
<td class=\\\"tcat\\\">
$vbphrase[shouts]
</td>
</tr>
</thead>
<tbody>
$shoutbits</tbody>
</table>

</td>
<td width=\\\"40%\\\">

<form action=\\\"shoutbox.php\\\" method=\\\"post\\\" onsubmit=\\\"return validate(this);\\\" name=\\\"vbform\\\">
<input type=\\\"hidden\\\" name=\\\"s\\\" value=\\\"$session[sessionhash]\\\" />
<input type=\\\"hidden\\\" name=\\\"do\\\" value=\\\"insert\\\" />
<input type=\\\"hidden\\\" name=\\\"goto\\\" value=\\\"archive\\\" />

<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr>
<td class=\\\"tcat\\\" colspan=\\\"2\\\">
<a style=\\\"float:$stylevar[right]\\\" href=\\\"#top\\\" onclick=\\\"return toggle_collapse(\'shoutstats\')\\\"><img id=\\\"collapseimg_shoutstats\\\" src=\\\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_shoutstats].gif\\\" alt=\\\"\\\" border=\\\"0\\\" /></a>
<strong>$vbphrase[shoutbox_statistics]</strong>
</td>
</tr>
</thead>
<tbody id=\\\"collapseobj_shoutstats\\\" style=\\\"$vbcollapse[collapseobj_shoutstats]\\\">
<tr>
<td class=\\\"alt1\\\" align=\\\"left\\\" width=\\\"50%\\\">
<div class=\\\"smallfont\\\"><strong>$vbphrase[total_shouts]</strong></div>
</td>
<td class=\\\"alt1\\\" align=\\\"right\\\" width=\\\"50%\\\">
$total[total]
</td>
</tr>
<tr>
<td class=\\\"alt2\\\" align=\\\"left\\\" width=\\\"50%\\\">
<div class=\\\"smallfont\\\"><strong>$vbphrase[total_shouts_today]</strong></div>
</td>
<td class=\\\"alt2\\\" align=\\\"right\\\" width=\\\"50%\\\">
$shoutstoday
</td>
</tr>
<tr>
<td class=\\\"alt1\\\" align=\\\"left\\\" width=\\\"50%\\\">
<div class=\\\"smallfont\\\"><strong>$vbphrase[total_shouts_in_24_hours]</strong></div>
</td>
<td class=\\\"alt1\\\" align=\\\"right\\\" width=\\\"50%\\\">
$shouts24
</td>
</tr>
<tr>
<td class=\\\"alt2\\\" align=\\\"left\\\" width=\\\"50%\\\">
<div class=\\\"smallfont\\\"><strong>$vbphrase[your_shouts]</strong></div>
</td>
<td class=\\\"alt2\\\" align=\\\"right\\\" width=\\\"50%\\\">
$yourshouts
</td>
</tr>
</tbody>
\" . ((($permissions[\'shoutboxpermissions\'] & CANADDSHOUT)) ? (\"
<thead>
<tr>
<td class=\\\"tcat\\\" colspan=\\\"2\\\">
<a style=\\\"float:$stylevar[right]\\\" href=\\\"#top\\\" onclick=\\\"return toggle_collapse(\'newshout\')\\\"><img id=\\\"collapseimg_newshout\\\" src=\\\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newshout].gif\\\" alt=\\\"\\\" border=\\\"0\\\" /></a>
<strong>$vbphrase[shout]</strong>
</td>
</tr>
</thead>
<tbody id=\\\"collapseobj_newshout\\\" style=\\\"$vbcollapse[collapseobj_newshout]\\\">
<tr>
<td class=\\\"alt1\\\" align=\\\"center\\\" colspan=\\\"2\\\">
<!-- clientscript -->
<script type=\\\"text/javascript\\\" src=\\\"clientscript/vbulletin_editor.js\\\"></script>
<script type=\\\"text/javascript\\\" src=\\\"clientscript/vbulletin_stdedit.js\\\"></script>
<script type=\\\"text/javascript\\\">
<!--
function vbcode_init_small()
{
if (editor_loaded)
{
return;
}

theform = document.forms.vbform;
}
var smiliewindow_x = 240;
var smiliewindow_y = 280;
//-->
</script>
<!-- / end clientscript -->
<textarea name=\\\"message\\\" id=\\\"message\\\" rows=\\\"5\\\" cols=\\\"30\\\"></textarea>
<br /><input type=\\\"submit\\\" value=\\\"$vbphrase[shout]\\\" class=\\\"button\\\" /> <input type=\\\"button\\\" value=\\\"$vbphrase[smilies]\\\" class=\\\"button\\\" onclick=\\\"open_smilie_window(smiliewindow_x, smiliewindow_y, 0, \'0\'); return false\\\" />
<!-- initialization script -->
<script type=\\\"text/javascript\\\">
<!--
vbcode_init_small();
//-->
</script>
<!-- / end initialization script -->
</td>
</tr>
</tbody>
\") : (\"\")).\"
<thead>
<tr>
<td class=\\\"tcat\\\" colspan=\\\"2\\\">
<a style=\\\"float:$stylevar[right]\\\" href=\\\"#top\\\" onclick=\\\"return toggle_collapse(\'topshouters\')\\\"><img id=\\\"collapseimg_topshouters\\\" src=\\\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_topshouters].gif\\\" alt=\\\"\\\" border=\\\"0\\\" /></a>
<strong>$vbphrase[top_shouters]</strong>
</td>
</tr>
</thead>
<tbody id=\\\"collapseobj_topshouters\\\" style=\\\"$vbcollapse[collapseobj_topshouters]\\\">
$topshouters
</tbody>
</table>

</form>

</td>
</tr>
</table>

$pagenav

$footer

</body>
</html>',
'$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title>$vboptions[bbtitle] - $vbphrase[shoutbox]</title>
$headinclude
<script language=\"javascript\">
<!--
function validate(theform)
{
if (theform.pagetext == \"\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>

</head>
<body>

$header
$navbar

$pagenav

<table cellpadding=\"2\" cellspacing=\"0\" border=\"0\" width=\"100%\" align=\"center\">
<tr valign=\"top\">
<td width=\"60%\">


<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr>
<td class=\"tcat\">
$vbphrase[shouts]
</td>
</tr>
</thead>
<tbody>
$shoutbits</tbody>
</table>

</td>
<td width=\"40%\">

<form action=\"shoutbox.php\" method=\"post\" onsubmit=\"return validate(this);\" name=\"vbform\">
<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\" />
<input type=\"hidden\" name=\"do\" value=\"insert\" />
<input type=\"hidden\" name=\"goto\" value=\"archive\" />

<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr>
<td class=\"tcat\" colspan=\"2\">
<a style=\"float:$stylevar[right]\" href=\"#top\" onclick=\"return toggle_collapse(\'shoutstats\')\"><img id=\"collapseimg_shoutstats\" src=\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_shoutstats].gif\" alt=\"\" border=\"0\" /></a>
<strong>$vbphrase[shoutbox_statistics]</strong>
</td>
</tr>
</thead>
<tbody id=\"collapseobj_shoutstats\" style=\"$vbcollapse[collapseobj_shoutstats]\">
<tr>
<td class=\"alt1\" align=\"left\" width=\"50%\">
<div class=\"smallfont\"><strong>$vbphrase[total_shouts]</strong></div>
</td>
<td class=\"alt1\" align=\"right\" width=\"50%\">
$total[total]
</td>
</tr>
<tr>
<td class=\"alt2\" align=\"left\" width=\"50%\">
<div class=\"smallfont\"><strong>$vbphrase[total_shouts_today]</strong></div>
</td>
<td class=\"alt2\" align=\"right\" width=\"50%\">
$shoutstoday
</td>
</tr>
<tr>
<td class=\"alt1\" align=\"left\" width=\"50%\">
<div class=\"smallfont\"><strong>$vbphrase[total_shouts_in_24_hours]</strong></div>
</td>
<td class=\"alt1\" align=\"right\" width=\"50%\">
$shouts24
</td>
</tr>
<tr>
<td class=\"alt2\" align=\"left\" width=\"50%\">
<div class=\"smallfont\"><strong>$vbphrase[your_shouts]</strong></div>
</td>
<td class=\"alt2\" align=\"right\" width=\"50%\">
$yourshouts
</td>
</tr>
</tbody>
<if condition=\"($permissions[\'shoutboxpermissions\'] & CANADDSHOUT)\">
<thead>
<tr>
<td class=\"tcat\" colspan=\"2\">
<a style=\"float:$stylevar[right]\" href=\"#top\" onclick=\"return toggle_collapse(\'newshout\')\"><img id=\"collapseimg_newshout\" src=\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_newshout].gif\" alt=\"\" border=\"0\" /></a>
<strong>$vbphrase[shout]</strong>
</td>
</tr>
</thead>
<tbody id=\"collapseobj_newshout\" style=\"$vbcollapse[collapseobj_newshout]\">
<tr>
<td class=\"alt1\" align=\"center\" colspan=\"2\">
<!-- clientscript -->
<script type=\"text/javascript\" src=\"clientscript/vbulletin_editor.js\"></script>
<script type=\"text/javascript\" src=\"clientscript/vbulletin_stdedit.js\"></script>
<script type=\"text/javascript\">
<!--
function vbcode_init_small()
{
if (editor_loaded)
{
return;
}

theform = document.forms.vbform;
}
var smiliewindow_x = 240;
var smiliewindow_y = 280;
//-->
</script>
<!-- / end clientscript -->
<textarea name=\"message\" id=\"message\" rows=\"5\" cols=\"30\"></textarea>
<br /><input type=\"submit\" value=\"$vbphrase[shout]\" class=\"button\" /> <input type=\"button\" value=\"$vbphrase[smilies]\" class=\"button\" onclick=\"open_smilie_window(smiliewindow_x, smiliewindow_y, 0, \'0\'); return false\" />
<!-- initialization script -->
<script type=\"text/javascript\">
<!--
vbcode_init_small();
//-->
</script>
<!-- / end initialization script -->
</td>
</tr>
</tbody>
</if>
<thead>
<tr>
<td class=\"tcat\" colspan=\"2\">
<a style=\"float:$stylevar[right]\" href=\"#top\" onclick=\"return toggle_collapse(\'topshouters\')\"><img id=\"collapseimg_topshouters\" src=\"$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_topshouters].gif\" alt=\"\" border=\"0\" /></a>
<strong>$vbphrase[top_shouters]</strong>
</td>
</tr>
</thead>
<tbody id=\"collapseobj_topshouters\" style=\"$vbcollapse[collapseobj_topshouters]\">
$topshouters
</tbody>
</table>

</form>

</td>
</tr>
</table>

$pagenav

$footer

</body>
</html>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_archive_message',
' <tr>
<td class=\\\"thead\\\">
<a name=\\\"shout$shout[shoutid]\\\"></a>
<table width=\\\"100%\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" border=\\\"0\\\">
<tr>
<td width=\\\"40%\\\" align=\\\"left\\\" style=\\\"font-size:12px\\\">
<b>$shout[username]</b>
</td>
<td width=\\\"60%\\\" align=\\\"right\\\" style=\\\"font-size:12px\\\">
<b>$shout[date] <span class=\\\"time\\\">$shout[time]</span></b>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=\\\"alt2\\\" style=\\\"font-size:10px\\\">
$shout[pagetext]
\" . ((($permissions[\'shoutboxpermissions\'] & CANEDITOTHERSHOUT) OR (($permissions[\'shoutboxpermissions\'] & CANEDITSHOUT) AND $bbuserinfo[\'userid\'] == $shout[\'userid\'])) ? (\"<div align=\\\"$stylevar[right]\\\">[<a href=\\\"shoutbox.php?$session[sessionurl]do=edit&amp;shoutid=$shout[shoutid]\\\">$vbphrase[edit]</a>]</div>\") : (\"\")).\"
</td>
</tr>
',
' <tr>
<td class=\"thead\">
<a name=\"shout$shout[shoutid]\"></a>
<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td width=\"40%\" align=\"left\" style=\"font-size:12px\">
<b>$shout[username]</b>
</td>
<td width=\"60%\" align=\"right\" style=\"font-size:12px\">
<b>$shout[date] <span class=\"time\">$shout[time]</span></b>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=\"alt2\" style=\"font-size:10px\">
$shout[pagetext]
<if condition=\"($permissions[\'shoutboxpermissions\'] & CANEDITOTHERSHOUT) OR (($permissions[\'shoutboxpermissions\'] & CANEDITSHOUT) AND $bbuserinfo[\'userid\'] == $shout[\'userid\'])\"><div align=\"$stylevar[right]\">[<a href=\"shoutbox.php?$session[sessionurl]do=edit&amp;shoutid=$shout[shoutid]\">$vbphrase[edit]</a>]</div></if>
</td>
</tr>
',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_archive_message_me',
' <tr>
<td class=\\\"thead\\\">
<a name=\\\"shout$shout[shoutid]\\\"></a>
<table width=\\\"100%\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" border=\\\"0\\\">
<tr>
<td width=\\\"40%\\\" align=\\\"left\\\" style=\\\"font-size:12px\\\">
<strong>$shout[username]</strong>
</td>
<td width=\\\"60%\\\" align=\\\"right\\\" style=\\\"font-size:12px\\\">
<strong>$shout[date] <span class=\\\"time\\\">$shout[time]</span></strong>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=\\\"alt2\\\" style=\\\"font-size:10px\\\">
<div class=\\\"highlight\\\">*$shout[username] $shout[pagetext]*</div>
\" . ((($permissions[\'shoutboxpermissions\'] & CANEDITOTHERSHOUT) OR (($permissions[\'shoutboxpermissions\'] & CANEDITSHOUT) AND $bbuserinfo[\'userid\'] == $shout[\'userid\'])) ? (\"<div align=\\\"$stylevar[right]\\\">[<a href=\\\"shoutbox.php?$session[sessionurl]do=edit&amp;shoutid=$shout[shoutid]\\\">$vbphrase[edit]</a>]</div>\") : (\"\")).\"
</td>
</tr>
',
' <tr>
<td class=\"thead\">
<a name=\"shout$shout[shoutid]\"></a>
<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td width=\"40%\" align=\"left\" style=\"font-size:12px\">
<strong>$shout[username]</strong>
</td>
<td width=\"60%\" align=\"right\" style=\"font-size:12px\">
<strong>$shout[date] <span class=\"time\">$shout[time]</span></strong>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class=\"alt2\" style=\"font-size:10px\">
<div class=\"highlight\">*$shout[username] $shout[pagetext]*</div>
<if condition=\"($permissions[\'shoutboxpermissions\'] & CANEDITOTHERSHOUT) OR (($permissions[\'shoutboxpermissions\'] & CANEDITSHOUT) AND $bbuserinfo[\'userid\'] == $shout[\'userid\'])\"><div align=\"$stylevar[right]\">[<a href=\"shoutbox.php?$session[sessionurl]do=edit&amp;shoutid=$shout[shoutid]\">$vbphrase[edit]</a>]</div></if>
</td>
</tr>
',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_archive_topbit',
' <tr>
<td class=\\\"alt2\\\" align=\\\"left\\\" width=\\\"50%\\\" nowrap=\\\"nowrap\\\">
<div class=\\\"smallfont\\\"><strong>$top[username]</strong></div>
</td>
<td class=\\\"alt2\\\" align=\\\"right\\\" width=\\\"50%\\\">
$top[total]
</td>
</tr>
',
' <tr>
<td class=\"alt2\" align=\"left\" width=\"50%\" nowrap=\"nowrap\">
<div class=\"smallfont\"><strong>$top[username]</strong></div>
</td>
<td class=\"alt2\" align=\"right\" width=\"50%\">
$top[total]
</td>
</tr>
',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_editmessage',
'$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title>$vboptions[bbtitle] - $vbphrase[edit_shout]</title>
$headinclude
<script language=\\\"javascript\\\">
<!--
function validate(theform)
{
if (theform.pagetext == \\\"\\\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>

</head>
<body>

$header
$navbar

<form action=\\\"shoutbox.php\\\" method=\\\"post\\\" onsubmit=\\\"return validate(this);\\\" name=\\\"shoutform\\\">
<input type=\\\"hidden\\\" name=\\\"s\\\" value=\\\"$session[sessionhash]\\\" />
<input type=\\\"hidden\\\" name=\\\"do\\\" value=\\\"drop\\\" />
<input type=\\\"hidden\\\" name=\\\"shoutid\\\" value=\\\"$shout[shoutid]\\\" />

<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<tbody>
<tr>
<td class=\\\"alt1\\\" width=\\\"100%\\\">
$vbphrase[do_you_want_to_delete_shout]
</td>
<td class=\\\"alt2\\\">
<input type=\\\"submit\\\" value=\\\"$vbphrase[delete_shout]\\\" class=\\\"button\\\" />
</td>
</tr>
</tbody>
</table>

</form>

<br />

<form action=\\\"shoutbox.php\\\" method=\\\"post\\\" onsubmit=\\\"return validate(this);\\\" name=\\\"vbform\\\">
<input type=\\\"hidden\\\" name=\\\"s\\\" value=\\\"$session[sessionhash]\\\" />
<input type=\\\"hidden\\\" name=\\\"do\\\" value=\\\"update\\\" />
<input type=\\\"hidden\\\" name=\\\"shoutid\\\" value=\\\"$shout[shoutid]\\\" />

<table class=\\\"tborder\\\" cellpadding=\\\"$stylevar[cellpadding]\\\" cellspacing=\\\"$stylevar[cellspacing]\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<thead>
<tr>
<td class=\\\"tcat\\\">
<strong>$vbphrase[edit_shout]</strong>
</td>
</tr>
</thead>
<tbody>
<tr>
<td class=\\\"panelsurround\\\" align=\\\"center\\\">
<div class=\\\"panel\\\">
<div style=\\\"width:$stylevar[formwidth]\\\" align=\\\"$stylevar[left]\\\">
<!-- message area -->
<!-- clientscript -->
<script type=\\\"text/javascript\\\" src=\\\"clientscript/vbulletin_editor.js\\\"></script>
<script type=\\\"text/javascript\\\" src=\\\"clientscript/vbulletin_stdedit.js\\\"></script>
<script type=\\\"text/javascript\\\">
<!--
function vbcode_init_small()
{
if (editor_loaded)
{
return;
}

theform = document.forms.vbform;
}
var smiliewindow_x = 240;
var smiliewindow_y = 280;
//-->
</script>
<!-- / end clientscript -->
<div class=\\\"smallfont\\\">$vbphrase[shout]:</div>
<table cellpadding=\\\"0\\\" cellspacing=\\\"0\\\" border=\\\"0\\\">
<tr valign=\\\"top\\\">
<td width=\\\"23%\\\">
$smiliebox
</td>
<td width=\\\"2%\\\">&nbsp;</td>
<td width=\\\"75%\\\">
<textarea name=\\\"message\\\" rows=\\\"20\\\" cols=\\\"60\\\" wrap=\\\"virtual\\\" style=\\\"width:$stylevar[messagewidth]; height:250px\\\" tabindex=\\\"1\\\">$shout[pagetext]</textarea>
</td>
</tr>
</table>
<!-- initialization script -->
<script type=\\\"text/javascript\\\">
<!--
vbcode_init_small();
//-->
</script>
<!-- / initialization script -->
<!-- / end message area -->
</div>
</div>
<div style=\\\"margin-top:$stylevar[cellpadding]px\\\">
<input type=\\\"submit\\\" class=\\\"button\\\" name=\\\"sbutton\\\" value=\\\"$vbphrase[update_shout]\\\" accesskey=\\\"s\\\" tabindex=\\\"1\\\" />
</div>
</td>
</tr>
</tbody>
</table>

</form>

$footer

</body>
</html>',
'$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title>$vboptions[bbtitle] - $vbphrase[edit_shout]</title>
$headinclude
<script language=\"javascript\">
<!--
function validate(theform)
{
if (theform.pagetext == \"\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>

</head>
<body>

$header
$navbar

<form action=\"shoutbox.php\" method=\"post\" onsubmit=\"return validate(this);\" name=\"shoutform\">
<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\" />
<input type=\"hidden\" name=\"do\" value=\"drop\" />
<input type=\"hidden\" name=\"shoutid\" value=\"$shout[shoutid]\" />

<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<tbody>
<tr>
<td class=\"alt1\" width=\"100%\">
$vbphrase[do_you_want_to_delete_shout]
</td>
<td class=\"alt2\">
<input type=\"submit\" value=\"$vbphrase[delete_shout]\" class=\"button\" />
</td>
</tr>
</tbody>
</table>

</form>

<br />

<form action=\"shoutbox.php\" method=\"post\" onsubmit=\"return validate(this);\" name=\"vbform\">
<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\" />
<input type=\"hidden\" name=\"do\" value=\"update\" />
<input type=\"hidden\" name=\"shoutid\" value=\"$shout[shoutid]\" />

<table class=\"tborder\" cellpadding=\"$stylevar[cellpadding]\" cellspacing=\"$stylevar[cellspacing]\" border=\"0\" width=\"100%\" align=\"center\">
<thead>
<tr>
<td class=\"tcat\">
<strong>$vbphrase[edit_shout]</strong>
</td>
</tr>
</thead>
<tbody>
<tr>
<td class=\"panelsurround\" align=\"center\">
<div class=\"panel\">
<div style=\"width:$stylevar[formwidth]\" align=\"$stylevar[left]\">
<!-- message area -->
<!-- clientscript -->
<script type=\"text/javascript\" src=\"clientscript/vbulletin_editor.js\"></script>
<script type=\"text/javascript\" src=\"clientscript/vbulletin_stdedit.js\"></script>
<script type=\"text/javascript\">
<!--
function vbcode_init_small()
{
if (editor_loaded)
{
return;
}

theform = document.forms.vbform;
}
var smiliewindow_x = 240;
var smiliewindow_y = 280;
//-->
</script>
<!-- / end clientscript -->
<div class=\"smallfont\">$vbphrase[shout]:</div>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr valign=\"top\">
<td width=\"23%\">
$smiliebox
</td>
<td width=\"2%\">&nbsp;</td>
<td width=\"75%\">
<textarea name=\"message\" rows=\"20\" cols=\"60\" wrap=\"virtual\" style=\"width:$stylevar[messagewidth]; height:250px\" tabindex=\"1\">$shout[pagetext]</textarea>
</td>
</tr>
</table>
<!-- initialization script -->
<script type=\"text/javascript\">
<!--
vbcode_init_small();
//-->
</script>
<!-- / initialization script -->
<!-- / end message area -->
</div>
</div>
<div style=\"margin-top:$stylevar[cellpadding]px\">
<input type=\"submit\" class=\"button\" name=\"sbutton\" value=\"$vbphrase[update_shout]\" accesskey=\"s\" tabindex=\"1\" />
</div>
</td>
</tr>
</tbody>
</table>

</form>

$footer

</body>
</html>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_iframe',
'<!DOCTYPE html PUBLIC \\\"-//W3C//DTD XHTML 1.0 Frameset//EN\\\" \\\"http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd\\\">
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title></title>

</head>
\" . ((($permissions[\'shoutboxpermissions\'] & CANREADSHOUTS)) ? (\"
\" . ((($permissions[\'shoutboxpermissions\'] & CANADDSHOUT)) ? (\"
<frameset rows=\\\"35,*\\\" framespacing=\\\"0\\\" frameborder=\\\"0\\\" border=\\\"0\\\">

<frame name=\\\"addnew\\\" id=\\\"addnew\\\" src=\\\"shoutbox.php?$session[sessionurl]do=addnew\\\" scrolling=\\\"no\\\" marginwidth=\\\"0\\\" marginheight=\\\"0\\\" noresize=\\\"noresize\\\" frameborder=\\\"0\\\">
<frame name=\\\"shouts\\\" id=\\\"shouts\\\" src=\\\"shoutbox.php?$session[sessionurl]do=main\\\" scrolling=\\\"yes\\\" marginwidth=\\\"5\\\" marginheight=\\\"5\\\" noresize=\\\"noresize\\\" frameborder=\\\"0\\\">

</frameset>
\") : (\"
<frameset rows=\\\"*\\\" framespacing=\\\"0\\\" frameborder=\\\"0\\\" border=\\\"0\\\">

<frame name=\\\"shouts\\\" id=\\\"shouts\\\" src=\\\"shoutbox.php?$session[sessionurl]do=main\\\" scrolling=\\\"yes\\\" marginwidth=\\\"5\\\" marginheight=\\\"5\\\" noresize=\\\"noresize\\\" frameborder=\\\"0\\\">

</frameset>
\")).\"
\") : (\"\")).\"
</html>',
'<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Frameset//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd\">
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title></title>

</head>
<if condition=\"($permissions[\'shoutboxpermissions\'] & CANREADSHOUTS)\">
<if condition=\"($permissions[\'shoutboxpermissions\'] & CANADDSHOUT)\">
<frameset rows=\"35,*\" framespacing=\"0\" frameborder=\"0\" border=\"0\">

<frame name=\"addnew\" id=\"addnew\" src=\"shoutbox.php?$session[sessionurl]do=addnew\" scrolling=\"no\" marginwidth=\"0\" marginheight=\"0\" noresize=\"noresize\" frameborder=\"0\">
<frame name=\"shouts\" id=\"shouts\" src=\"shoutbox.php?$session[sessionurl]do=main\" scrolling=\"yes\" marginwidth=\"5\" marginheight=\"5\" noresize=\"noresize\" frameborder=\"0\">

</frameset>
<else />
<frameset rows=\"*\" framespacing=\"0\" frameborder=\"0\" border=\"0\">

<frame name=\"shouts\" id=\"shouts\" src=\"shoutbox.php?$session[sessionurl]do=main\" scrolling=\"yes\" marginwidth=\"5\" marginheight=\"5\" noresize=\"noresize\" frameborder=\"0\">

</frameset>
</if>
</if>
</html>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_main',
'$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title></title>
$headinclude

</head>
<body class=\\\"alt1\\\">

<table width=\\\"100%\\\" cellpadding=\\\"2\\\" cellspacing=\\\"0\\\" border=\\\"0\\\" align=\\\"center\\\">
$shoutbits</table>

</body>
</html>',
'$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title></title>
$headinclude

</head>
<body class=\"alt1\">

<table width=\"100%\" cellpadding=\"2\" cellspacing=\"0\" border=\"0\" align=\"center\">
$shoutbits</table>

</body>
</html>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_main_message',
' <tr valign=\\\"top\\\">
<td nowrap=\\\"nowrap\\\">
<div class=\\\"smallfont\\\">[$shout[date] <span class=\\\"time\\\">$shout[time]</span>] <strong>$shout[username]:</strong></div>
</td>
<td width=\\\"100%\\\">
<div class=\\\"smallfont\\\">$shout[pagetext]</div>
</td>
</tr>
',
' <tr valign=\"top\">
<td nowrap=\"nowrap\">
<div class=\"smallfont\">[$shout[date] <span class=\"time\">$shout[time]</span>] <strong>$shout[username]:</strong></div>
</td>
<td width=\"100%\">
<div class=\"smallfont\">$shout[pagetext]</div>
</td>
</tr>
',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_main_message_me',
' <tr valign=\\\"top\\\">
<td nowrap=\\\"nowrap\\\">
<div class=\\\"smallfont\\\">[$shout[date] <span class=\\\"time\\\">$shout[time]</span>] <strong>$shout[username]:</strong></div>
</td>
<td width=\\\"100%\\\">
<div class=\\\"smallfont\\\"><div class=\\\"highlight\\\">*$shout[username] $shout[pagetext]*</div></div>
</td>
</tr>
',
' <tr valign=\"top\">
<td nowrap=\"nowrap\">
<div class=\"smallfont\">[$shout[date] <span class=\"time\">$shout[time]</span>] <strong>$shout[username]:</strong></div>
</td>
<td width=\"100%\">
<div class=\"smallfont\"><div class=\"highlight\">*$shout[username] $shout[pagetext]*</div></div>
</td>
</tr>
',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_newmessage',
'$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title></title>
$headinclude
<script language=\\\"javascript\\\">
<!--
function validate(theform)
{
if (theform.message == \\\"\\\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>
$refresh

</head>
<body class=\\\"alt1\\\">

<form action=\\\"shoutbox.php\\\" method=\\\"post\\\" onsubmit=\\\"return validate(this);\\\" name=\\\"shoutform\\\">
<input type=\\\"hidden\\\" name=\\\"s\\\" value=\\\"$session[sessionhash]\\\" />
<input type=\\\"hidden\\\" name=\\\"do\\\" value=\\\"insert\\\" />

<table cellpadding=\\\"0\\\" cellspacing=\\\"3\\\" border=\\\"0\\\" width=\\\"100%\\\" align=\\\"center\\\">
<tbody>
<tr>
<td width=\\\"100%\\\">
<input type=\\\"text\\\" name=\\\"message\\\" value=\\\"\\\" size=\\\"70\\\" />
<input type=\\\"submit\\\" value=\\\"$vbphrase[shout]\\\" class=\\\"button\\\" />
</td>
<td align=\\\"right\\\" nowrap=\\\"nowrap\\\">
<div class=\\\"smallfont\\\">
<a href=\\\"javascript:parent.location = parent.location;\\\">$vbphrase[refresh]</a> | <a href=\\\"shoutbox.php?$session[sessionurl]do=archive\\\" target=\\\"_blank\\\">$vbphrase[archive]</a>
</div>
</td>
</tr>
</tbody>
</table>

</form>

</body>
</html>',
'$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title></title>
$headinclude
<script language=\"javascript\">
<!--
function validate(theform)
{
if (theform.message == \"\")
{
alert(\'$vbphrase[you_must_enter_a_shout]\');
return false;
}
else
{
return true;
}
}
//-->
</script>
$refresh

</head>
<body class=\"alt1\">

<form action=\"shoutbox.php\" method=\"post\" onsubmit=\"return validate(this);\" name=\"shoutform\">
<input type=\"hidden\" name=\"s\" value=\"$session[sessionhash]\" />
<input type=\"hidden\" name=\"do\" value=\"insert\" />

<table cellpadding=\"0\" cellspacing=\"3\" border=\"0\" width=\"100%\" align=\"center\">
<tbody>
<tr>
<td width=\"100%\">
<input type=\"text\" name=\"message\" value=\"\" size=\"70\" />
<input type=\"submit\" value=\"$vbphrase[shout]\" class=\"button\" />
</td>
<td align=\"right\" nowrap=\"nowrap\">
<div class=\"smallfont\">
<a href=\"javascript:parent.location = parent.location;\">$vbphrase[refresh]</a> | <a href=\"shoutbox.php?$session[sessionurl]do=archive\" target=\"_blank\">$vbphrase[archive]</a>
</div>
</td>
</tr>
</tbody>
</table>

</form>

</body>
</html>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_newmessage_refresh',
'<script language=\\\"javascript\\\">
<!--
parent.shouts.location = parent.shouts.location;
//-->
</script>',
'<script language=\"javascript\">
<!--
parent.shouts.location = parent.shouts.location;
//-->
</script>',
1122662695,
'BV',
'3.0.7'
), (
'-1',
'shoutbox_shouterror',
'$stylevar[htmldoctype]
<html dir=\\\"$stylevar[textdirection]\\\" lang=\\\"$stylevar[languagecode]\\\">
<head>

<title></title>
$headinclude

</head>
<body class=\\\"alt1\\\" style=\\\"margin: 3px;\\\">

$errortext

</body>
</html>',
'$stylevar[htmldoctype]
<html dir=\"$stylevar[textdirection]\" lang=\"$stylevar[languagecode]\">
<head>

<title></title>
$headinclude

</head>
<body class=\"alt1\" style=\"margin: 3px;\">

$errortext

</body>
</html>',
1122662695,
'BV',
'3.0.7'
)
mysql error: Duplicate entry 'shoutbox_archive--1' for key 2

mysql error number: 1062

Date: Friday 29th of July 2005 07:44:55 PM

I got that query problem.
sabret00the
07-29-2005, 06:03 PM
it's saying the template already exists, delete the other one of the same name first.
King Kovifor
07-29-2005, 06:04 PM
I can't that's the problem. It's a [customize] link. Or can you delete the templates another way?
Marco van Herwaarden
07-29-2005, 08:19 PM
Looks like you're trying to install a shoutbox hack, please post your problem in the hack thread for the fastest support on this.

PS Next time please use code-tags around source.