I am trying to modify the Latest Forum Topics block on mYvBindex page... I'd like to add another variable to WHERE clause, but no matter how I change it, i do not see any changes. ok. here is the original code:
PHP Code:
$threads=$DB_site->query("SELECT threadid,title,replycount,
postusername,postuserid,dateline,views"
.iif($showthreadicon, ',thread.iconid','')."
FROM thread WHERE open='1' AND open<>10
$iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");
I'd like to say this:
PHP Code:
$threads=$DB_site->query("SELECT threadid,title,replycount,
postusername,postuserid,dateline,views"
.iif($showthreadicon, ',thread.iconid','')."
FROM thread WHERE open='1' AND open<>10 AND forumid!='54'
$iforumperms ORDER BY lastpost DESC LIMIT $maxlatethreads");
i have no idea what i'm doing wrong. nothing changes on the display... please help. i'm starting to feel retarded