MyBB-Plugins/Inplaytracker-2.0 Changeset - a20c948a34ca

Changeset - a20c948a34ca

Parent rev.

Child rev.

[Not reviewed]

0 1 0

Chel Sea (chain) - 6 years ago 2019-01-21 01:33:51
chain@rpgfiction.net

use uid instead of username, fixes problems with escaping

1 file changed with 2 insertions and 2 deletions:

inc/plugins/inplaytracker.php

0 comments (0 inline, 0 general)

inc/plugins/inplaytracker.php

➞

Show inline comments

@@ @@ -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");

0 comments (0 inline, 0 general)