Просмотр поста

function LastNotes($switch = 'F', $lmt = 5) {
    if (($switch == 'F') && $lmt > 0) {
        if ($switch == 'F')
            $sql = "SELECT COUNT(*) FROM forum WHERE type = 't'";
    
        $total = mysql_result(mysql_query($sql), 0);
        if ($total) {
            if ($switch == 'F') {
               $sql = "SELECT forum.id, forum.text, users.name FROM forum JOIN users ON forum.user_id = users.id AND type = 't' ORDER BY time DESC LIMIT $lmt";
            
                } 

            $res = mysql_query($sql) or die (mysql_error());
            $i = 0;
            while ($row = mysql_fetch_assoc($res)) {
 $idtopic = $row['id'];
             $sqlimg1 = "SELECT cms_forum_files.filename FROM cms_forum_files JOIN forum ON cms_forum_files.topic = '. $idtopic.' AND type = 'm' Limit 1 ";
        $resimg1 = mysql_query($sqlimg1);
        $rowimg1 = mysql_fetch_assoc($resimg1);
       $aspimg1 = $rowimg1['filename'];

                if ($switch == 'F') {$out = '<div class="phdr">Forumdagi so`ngi mavzular</div>';
                    $out .= ($i % 2 ? '<div class="list2">' : '<div class="list1">') 
                         .'<div><img src="' . $set['homeurl'] . '/files/forums/attach/'.$aspimg1.' " class="img-responsive" alt="screen" /></div>'    
                      .'<a href="/forum/?id='. $row['id'] .'">'. $row['text'] .'</a>&nbsp;(' . $row['name'] . ')</div>';
                } 
                $i++;
            }
        }


    } 
    return $out;  
}