Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Reload this Page Query Problems
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-29-2005, 05:50 PM
King Kovifor's Avatar
King Kovifor King Kovifor is offline
 
Join Date: Nov 2004
Location: PA
Posts: 3,872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Query Problems
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=\\\"javascriptarent.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=\"javascriptarent.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.
Reply With Quote
  #2  
Old 07-29-2005, 06:03 PM
sabret00the's Avatar
sabret00the sabret00the is offline
 
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
it's saying the template already exists, delete the other one of the same name first.
Reply With Quote
  #3  
Old 07-29-2005, 06:04 PM
King Kovifor's Avatar
King Kovifor King Kovifor is offline
 
Join Date: Nov 2004
Location: PA
Posts: 3,872
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I can't that's the problem. It's a [customize] link. Or can you delete the templates another way?
Reply With Quote
  #4  
Old 07-29-2005, 08:19 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 09:17 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04153 seconds
  • Memory Usage 2,272KB
  • 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)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