############# scheduled del #######################
$bestthreaddel = $db->query_read("
     SELECT threadid, stampid, stampdays, stamptime, stampby
     FROM " . TABLE_PREFIX . "thread
     WHERE stampdays > '0'
     ");

while ($bestthreads = $db->fetch_array($bestthreaddel))
{
     if($bestthreads['stampdays'] > 0 AND $bestthreads['stamptime'] < TIMENOW-(86400*$bestthreads['stampdays']))
     {
          $db->query_write("
          UPDATE " . TABLE_PREFIX . "thread
          SET stampid = '0', stampdays = '0', stamptime = '0', stampby = ''
          WHERE threadid = " . $bestthreads['threadid'] . "
          LIMIT 1
          ");
     }
}
##################################
$lastrow = $db->query("SELECT threadid,title,postusername,postuserid," . TABLE_PREFIX . "thread.lastpost,replycount,views,forumid,lastposter," . TABLE_PREFIX . "user.userid FROM " . TABLE_PREFIX . "thread LEFT JOIN " . TABLE_PREFIX . "user ON(" . TABLE_PREFIX . "thread.lastposter=" . TABLE_PREFIX . "user.username) WHERE stampid=2 ORDER BY lastpost DESC LIMIT " . $vbulletin->options[stamps_maxthreads] . "");

$bar='';
$count_td = 0;
$lastthreadscount = $db->num_rows($lastrow);
while ($lastthreads = $db->fetch_array($lastrow))
{
       $full_title = $lastthreads[title];
       if($vbulletin->options[stamps_maxchar] > 0 and strlen($lastthreads[title]) > $vbulletin->options[stamps_maxchar])
       {
                      $lastthreads[title] = substr($lastthreads[title], 0, $vbulletin->options[stamps_maxchar]) . " ... ";
       }
       $userpermission = $vbulletin->userinfo['forumpermissions']["$lastthreads[forumid]"];


        if (($userpermission & $vbulletin->bf_ugp_forumpermissions['canview']) and ($vbulletin->forumcache[$lastthreads[forumid]]['options'] & $vbulletin->bf_misc_forumoptions['active']))
       {

                if($vbulletin->options['style_of_best_threads'] == '0')
                {

                    $bar .= '
<td align="center" valign="middle" nowrap>
                <FONT COLOR="555555">&nbsp&nbsp|&nbsp&nbsp</FONT>
</td>
<td align="center" valign="middle" nowrap>
<table>
        <tr>
                <td align="center" valign="middle" nowrap>
                        <a href="showthread.php?t='.$lastthreads[threadid].'" title="' . $vbphrase[thread] .': ' . $full_title . '  ' . $vbphrase[thread_starter] .': '.$lastthreads[postusername].'" target=_blank>'.$lastthreads[title].'</a>
                </td>
        </tr>
        <tr>
                <td align="center" valign="middle" nowrap>
                <smallfont>' . $vbphrase[last_post_by] .': <a title="' . $vbphrase[replies] .': '.$lastthreads[replycount].'&nbsp;&nbsp;&nbsp;' . $vbphrase[views] .': '.$lastthreads[views].'" href="member.php?u='.$lastthreads[userid].'"  target=_blank>'.$lastthreads[lastposter].'</a></smallfont>
                </td>
        </tr>
</table>
</td>
';


                }
        elseif($vbulletin->options['style_of_best_threads'] == '1')
        {

                      $bar .= '<br>
                                                       <table class="tborder" cellpadding="4" cellspacing="1" border="0" width="95%">
                                                                         <tr>
                                                                                        <td class="tcat" align="center" width="40%">' . $vbphrase[thread] .'</td>
                                                                                        <td class="tcat" align="center" width="15%">' . $vbphrase[thread_starter] .'</td>
                                                                                        <td class="tcat" align="center" width="10%">' . $vbphrase[replies] .'</td>
                                                                                        <td class="tcat" align="center" width="10%">' . $vbphrase[views] .'</td>
                                                                                        <td class="tcat" align="center" width="100%">' . $vbphrase[last_post] .'</td>
                                                                         </tr>
                                                                         <tr>
                                                                                        <td class="alt2" align="right"><b><a href="showthread.php?t='.$lastthreads[threadid].'" title="' . $full_title . '" target=_blank>'.$lastthreads[title].'</a></b></td>
                                                                                        <td class="alt2" align="center"><a href="member.php?u='.$lastthreads[postuserid].'"  target=_blank>'.$lastthreads[postusername].'</a></td>
                                                                                        <td class="alt2" align="center">'.$lastthreads[replycount].'</td>
                                                                                        <td class="alt2" align="center">'.$lastthreads[views].'</td>
                                                                                        <td class="alt2" align="center" nowrap>' . $vbphrase[last_post_by] .': <a href="member.php?find=lastposter&amp;t=' . $lastthreads[threadid] . '" target="_blank">' . $lastthreads[lastposter] . '</a> <a href="showthread.php?' .$session[sessionurl] . 'goto=lastpost&amp;t=' . $lastthreads[threadid] . '" target="_blank"><img class="inlineimg" src="' . $stylevar[imgdir_button] . '/lastpost.gif" alt="' . $vbphrase[go_to_last_post] . '" border="0" /></a>
                                                                                        </td>
                                                                         </tr>
                                                                         </table>';

        }
                elseif($vbulletin->options['style_of_best_threads'] == '2')
                {

                        if(($count_td % 2) == 0)
                        {
                                $bar .='<tr><td class="smallfont" width="50%"><a href="showthread.php?t='.$lastthreads[threadid].'" title="' . $vbphrase[thread] .': ' . $full_title . '  ' . $vbphrase[thread_starter] .': '.$lastthreads[postusername].'" target="_blank">'.$lastthreads[title].'</a></td>';
                                $count_td +=1;
                                continue;
                        }

                        if(($count_td % 2) == 1)
                        {
                                $bar .= '<td class="smallfont" width="50%"><a href="showthread.php?t='.$lastthreads[threadid].'" title="' . $vbphrase[thread] .': ' . $full_title . '  ' . $vbphrase[thread_starter] .': '.$lastthreads[postusername].'" target="_blank">'.$lastthreads[title].'</a></td></tr>';
                                $count_td =0;
                        }


                 }
        }
} // End While

if($lastthreadscount>0)
{
                 if($vbulletin->options['style_of_best_threads'] == '0')
         {

                 $lastbestthreads = '<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
                                                                         <tr valign=middle>
                                                                                  <td class="tcat" align="center" width="99" valign="middle" nowrap>'.$vbphrase[best_threads].'</td>
                                                                                  <td class="alt1" valign=middle width="100%" align=center>
                                                                                 <marquee  dir="ltr" nowrap id="m1" trueSpeed scrollAmount="' . $vbulletin->options[stamps_speed] . '" scrollDelay="60" direction="right" loop=INFINITE valign="middle"  ALIGN="center" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>
                                                                                 <table>
                                                                                 <tr dir="rtl">
                                                                                         '.$bar.'
                                                                                 </tr>
                                                                                 </table></marquee></td></tr></table>';

         }
         elseif($vbulletin->options['style_of_best_threads'] == '1')
         {
                 $lastbestthreads = '<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
                                                                         <tr valign=middle>
                                                                     <td class="tcat" align="center" width="99" valign="middle" nowrap><normalfont>'.$vbphrase[best_threads].'</normalfont></td>
                                                                                 <td class="alt1" valign=middle width="100%" align=center>
                                                                                 <MARQUEE onmouseover=\'this.stop()\' onmouseout=\'this.start()\' scrollAmount="' . $vbulletin->options[stamps_speed] . '" scrollDelay=60 direction=up width="100%" height=60 style="text-align: center">
                                                                                 '.$bar.'</marquee></td></tr></table>';

         }
         elseif($vbulletin->options['style_of_best_threads'] == '2')
         {
                         $lastbestthreads = '    <table cellpadding="5" cellspacing="0" border="0" width="100%" >
                                                  <tr>
                                                  <td class="tcat" width="100%" align="center">
                                                  '.$vbphrase[best_threads].'
                                                  </td>
                                                  </tr>
                                                  </table>
                                                 <table class="smallfont" cellpadding="2" cellspacing="0" border="0" width="100%" align="center" >
                                                 '.$bar.'
                                                 </table>';
         }
$lastbestthreads .= '<br/><br/>';
}