diff --git a/inc/plugins/inplaytracker.php b/inc/plugins/inplaytracker.php index a854d4128c121f83338df9b0c9c7edf32b5f84de..65b369bf31b29ee8d1c005c1f8cba5bd4900dea1 100644 --- a/inc/plugins/inplaytracker.php +++ b/inc/plugins/inplaytracker.php @@ -1296,7 +1296,7 @@ function inplaytracker_profile() { $last_inplaypost = $db->fetch_field($db->query("SELECT ".TABLE_PREFIX."posts.dateline FROM ".TABLE_PREFIX."posts LEFT JOIN ".TABLE_PREFIX."threads on ".TABLE_PREFIX."threads.tid = ".TABLE_PREFIX."posts.tid LEFT JOIN ".TABLE_PREFIX."forums on ".TABLE_PREFIX."forums.fid = ".TABLE_PREFIX."threads.fid - WHERE ".TABLE_PREFIX."posts.username = '$memprofile[username]' + WHERE ".TABLE_PREFIX."posts.uid = '$memprofile[uid]' AND (".TABLE_PREFIX."forums.parentlist LIKE '$ipforum,%' OR ".TABLE_PREFIX."forums.parentlist LIKE '%,$archiv%') AND ".TABLE_PREFIX."posts.visible = '1'"), "dateline"); @@ -1306,7 +1306,7 @@ function inplaytracker_profile() { $inplayposts = $db->fetch_field($db->query("SELECT COUNT(*) AS inplayposts FROM ".TABLE_PREFIX."posts LEFT JOIN ".TABLE_PREFIX."threads on ".TABLE_PREFIX."threads.tid = ".TABLE_PREFIX."posts.tid LEFT JOIN ".TABLE_PREFIX."forums on ".TABLE_PREFIX."forums.fid = ".TABLE_PREFIX."threads.fid - WHERE ".TABLE_PREFIX."posts.username = '$memprofile[username]' + WHERE ".TABLE_PREFIX."posts.uid = '$memprofile[uid]' AND (".TABLE_PREFIX."forums.parentlist LIKE '$ipforum,%' OR ".TABLE_PREFIX."forums.parentlist LIKE '%,$archiv%') AND ".TABLE_PREFIX."posts.visible = '1'"), "inplayposts");