$sql = "SELECT `id` FROM `".$prefix."_shoutbox_shouts` WHERE `timestamp`=''";
$sql = "SELECT `id` FROM `".$prefix."_shoutbox_shouts` WHERE `timestamp`=''";
$resultTS = $db->sql_query($sql);
$resultTS = dbquery($sql);
$TSrows = $db->sql_numrows($resultTS);
$TSrows = dbnumrows($resultTS);
$db->sql_freeresult($resultTS);
dbfree($resultTS);
if ($TSrows > 0) {
if ($TSrows > 0) {
echo "<br /><br /><strong>NOTE:</strong> The prune feature only works on shouts that use the new unix timestamp format. You currently have <strong>$TSrows</strong> shouts that are using the old format. Please run the conversion tool that came in the Shout_Box.zip to update your shouts.";
echo "<br /><br /><strong>NOTE:</strong> The prune feature only works on shouts that use the new unix timestamp format. You currently have <strong>$TSrows</strong> shouts that are using the old format. Please run the conversion tool that came in the Shout_Box.zip to update your shouts.";
}
}
CloseTable();
CloseTable();
echo "<br />";
echo "<br />";
OpenTable();
OpenTable();
$sql = "SELECT `name`, `comment` FROM `".$prefix."_shoutbox_sticky` WHERE `stickySlot`=0";
$sql = "SELECT `name`, `comment` FROM `".$prefix."_shoutbox_sticky` WHERE `stickySlot`=0";
$stickyResult = $db->sql_query($sql);
$stickyResult = dbquery($sql);
$stickyRow0 = $db->sql_fetchrow($stickyResult);
$stickyRow0 = dbrow($stickyResult);
$db->sql_freeresult($stickyResult);
dbfree($stickyResult);
$sql = "SELECT `name`, `comment` FROM `".$prefix."_shoutbox_sticky` WHERE `stickySlot`=1";
$sql = "SELECT `name`, `comment` FROM `".$prefix."_shoutbox_sticky` WHERE `stickySlot`=1";