Filtering Thread By Thread Author

[RateU]

It seems the URL lead to your download attachment (.rar file). Try to change the query like this:

PHP Code:

1 2 3 4 5 6 7 8 9 10

$query = $db->query(' SELECT t.*, f.name, a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename FROM '.TABLE_PREFIX.'threads t LEFT JOIN '.TABLE_PREFIX.'xtattachments a ON (a.tid=t.tid) LEFT JOIN '.TABLE_PREFIX.'forums f ON (f.fid=t.fid) WHERE t.visible=1 AND t.uid='.intval($memprofile['uid']).' AND t.closed NOT LIKE "moved|%" AND a.thumbs!="" AND t.fid IN ('.implode(',', $mnxtigp_fid_array).')'.$mnxtigp_unviewwhere.' GROUP BY a.tid '.$mnxtigp_lr.' LIMIT 0,'.intval($mybb->settings['mnxtigp_num']).' ');

---