A view users get this error
Code:
Datenbankfehler in vBulletin 3.0.5:
Ungueltige SQL-Abfrage:
SELECT COUNT(threadid) AS threads, postuserid AS userid
FROM thread
WHERE postuserid IN ()
GROUP BY postuserid
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY postuserid' at line 3
mysql error number: 1064
Datum: 16.02.2005 22:25:32
Skript: http://www.celebritymarkt.de/showthread.php?mode=hybrid&t=10739
Referer: http://www.celebritymarkt.de/showthread.php?t=10739
Benutzername: Nicht registriert
IP-Adresse: 172.183.38.81
this is the Code in this line
Code:
$struserids = implode(",", array_values($userids));
$sthreads = $DB_site->query("
SELECT COUNT(threadid) AS threads, postuserid AS userid
FROM " . TABLE_PREFIX . "thread
WHERE postuserid IN ($struserids)
GROUP BY postuserid
");
while ($threadcount = $DB_site->fetch_array($sthreads))
{
$search[] = "{threadsstarted[$threadcount[userid]]}";
$replace[] = vb_number_format($threadcount[threads]);
unset($userids[$threadcount[userid]]);
}
foreach ($userids as $userid)
{
$search[] = "{threadsstarted[$userid]}";
$replace[] = 0;
}
$postbits = str_replace($search, $replace, $postbits);
Can you help me ?