still got a problem now
my members profile shows all threads,even though the limit is at 1
heres my codings
PHP Code:
// THREADS
// By assassingod
// functionality fixed by yoyoyoyo
$limit = '1'; // Enter the number of maximum threads you want to be displayed
$getthreads = $DB_site->query("
SELECT threadid,title,dateline
FROM " . TABLE_PREFIX ."thread
WHERE postuserid = '$userinfo[userid]' AND forumid IN ('1','2','')
ORDER BY dateline DESC
"); // enter the forums you wish to exclude in the above array where the numbers represent the forum ID's
while($threads = $DB_site->fetch_array($getthreads))
{
exec_switch_bg();
$threads['date'] = vbdate($vboptions['dateformat'],$threads['dateline']);
$threads['time'] = vbdate($vboptions['timeformat'],$threads['dateline']);
eval('$usersthreads .= "' . fetch_template('memberinfo_usersthreads') . '";');
}