Code:
$sql = $db->query_first("SELECT count(*) as totalpost FROM " .
TABLE_PREFIX . "post as p LEFT JOIN " . TABLE_PREFIX . "thread as t
ON (p.threadid = t.threadid) WHERE p.parentid > 0
AND p.dateline >= $maxtime
AND t.forumid IN ($fids)
AND p.userid = " . $vbulletin->userinfo['userid'] . "
");
if ($sql['totalpost'] >= $result['maxpost']) {
I'd love to see
Quote:
You may only make {1} replies every {2} hours. Please come back in about {3} hours.
|
Shouldnt be to hard to get this information out of this query, but I dont know how. Any ideas?