[Oblivion Knight]

Originally Posted by sabret00the

the t-string error could've been fixed by doing this

PHP Code:

    $journal_recent_entries = $DB_site->query("SELECT j.enabled, u.username, e.journalid, e.title, e.entry, e.mood, e.np, e.timestamp, e.userid
                                FROM journal_entry e, journal j, user u
                                WHERE
                                e.userid = u.userid AND e.userid = j.userid
                                AND e.private = 0 AND j.enabled = 1
                                ORDER BY e.timestamp DESC
                                LIMIT $vboptions[journals_recentdisplaylimit]"); 


Yeah, I tried that originally and got the same MySQL error..
However, I wasn't sure if that would work in the first place or not. Now I know it would.. =)

$vboptions['journals_recentdisplaylimit'] doesn't seem to be pulling the value from the database when used in the journal.php file though.. Is there something else I need to add to get it to work?