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
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 02:18 PM.

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.04508 seconds
  • Memory Usage 2,363KB
  • 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)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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