
09-09-2007, 12:40 PM
|
 |
|
|
Join Date: Jan 2003
Location: London
Posts: 5,268
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by blindMoe
Not sure if anyone already posted this but is a bug fix for viewing the groups a user is in:
(Example url: http://www.yoursite.com/forums/group...ups.php?u=1234)
In groups/viewgroups.php on line 81:
Find:
Code:
$grps_mygroups = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.leaderid, grps_setting.image_name
FROM grps
LEFT JOIN " . TABLE_PREFIX . "user ON (user.userid = grps.leaderid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps.groupid IN($grps_ids_imploded)
ORDER BY grps.title ASC
Replace with:
Code:
$grps_mygroups = $db->query_read("
SELECT grps.groupid, grps.title, grps.description, grps.approved, grps.leaderid, grps_setting.image_name
FROM grps
LEFT JOIN " . TABLE_PREFIX . "user ON (vb_user.userid = grps.leaderid)
LEFT JOIN grps_setting ON (grps_setting.groupid = grps.groupid)
WHERE grps.approved = '1' AND grps.groupid IN($grps_ids_imploded)
ORDER BY grps.title ASC
Sorry if someone already posted this but I just installed the newest version and it was still in there. Also, wasn't about to read through 123 pages to find out
blindMoe
|
a fix was posted by me a few pages back. thanks for the assistance though. it REALLY helps.
|