[AN-net]

yeah.

heres the entire block of code for that do:

PHP Code:

if($do=="showindex")
        {
            $fjournals= $DB_site->query("SELECT
             journals.journal_id,journals.journalname,journals.journaldesc,
            journals.journalist,journals.journalist_id,journals.lastentry,
            journals.lastentry_date,journals.lastentry_id,journals.journalviews,
            journals.journal_totalrating AS totalrating,journals.journal_totalvotes AS totalvotes,COUNT(journal_entries.entry_id) AS entries
             FROM ".TABLE_PREFIX."journals
            LEFT JOIN journal_entries 
            ON (journals.journal_id=journal_entries.journal_id AND entry_active=1) 
            WHERE journals.active='1'
            GROUP BY journals.journal_id
            ");
            $check= $DB_site->num_rows($fjournals);
            if($check=="0")
            {
                $journalbits= $vbphrase['journalnojournals'];
            }
            else
            {
                while($journal= $DB_site->fetch_array($fjournals))
                {
                    //$count= $DB_site->query_first("SELECT COUNT(*) AS entries FROM ".TABLE_PREFIX."journal_entries WHERE journal_id='".$journal['journal_id']."' AND entry_active='1'");
                    if(empty($journal['totalrating']) OR empty($journal['totalvotes']))
                    {
                    $rating= "0";
                    }
                    else
                    {
                        $calcrating= $journal['totalrating']/$journal['totalvotes'];
                        $rating= round($calcrating);
                    }
                    $lastedate= vbdate($vboptions['dateformat'], $journal['lastentry_date'], 1);
                    $lastetime= vbdate($vboptions['timeformat'], $journal['lastentry_date']);
                    exec_switch_bg();
                    eval('$journalbits .= "' . fetch_template('journal_journalbits') . '";');
                }
            }
            $getlatest= $DB_site->query("SELECT journal_entries.entrytitle,journal_entries.entrydate,journal_entries.entry_id,
            journal_entries.entrytext,journal_entries.journal_id,journals.journalist,journals.journalist_id 
            FROM ".TABLE_PREFIX."journal_entries 
            LEFT JOIN ".TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id) 
            WHERE journal_entries.entry_active=1 AND journal_entries.private!=1 
            ORDER BY journal_entries.entrydate DESC
            ");
            $countlatest= $DB_site->num_rows($getlatest);
            if($countlatest>0)
            {
                while($latest= $DB_site->fetch_array($getlatest))
                {
                    $latestentrydate= vbdate($vboptions['dateformat'], $latest['entrydate'], 1);
                    $latestentrytime= vbdate($vboptions['timeformat'], $latest['entrydate']);
                    exec_switch_bg();
                    eval('$latestentrybits .= "' . fetch_template('journal_latestentrybits') . '";');
                }
            }
            else
            {
                $latestentrybits="There are no entries.";
            }
            eval('$navbar = "' . fetch_template('navbar') . '";');
            eval('print_output("' . fetch_template('JOURNAL') . '");');
        }