Customizing SMF > Modifications and Packages

Active Members In Topic

<< < (2/31) > >>

Skipdawg:
Removed TP since I was done testing it. Issue still there.  :o

Niteblade:
*Imagines when 200 members post in a topic*

Maybe this mod should link to something on the Stats page ? "Stats for this topic .." or something similar. Else, you're gonna have like 30+ rows of members listed before anyone can actually read the topic.

snork13:

--- Quote from: Skipdawg on June 02, 2006, 12:32:10 AM ---Removed TP since I was done testing it. Issue still there.  :o

--- End quote ---

I'll look into it, try uploading an unmodded ManagePermissions.php file, then try the mod again.

-Snork13

Skipdawg:
Yea I had thought about that. But could conflict with other Mods I am toying with right now. If I clean it up fresh I may try your mod again later. Great idea though!  ;D ;)

rkirkw:
I installed your mod Active Members In Topic 1.2 and it caused some issues
I was unable to view any messages until I edited the file display.php
The problem came from the fact that my table prefixes were not smf_ but customized.
This is common on web hosting sites.

I hope this helps and that you can use it to prevent others from having the same problem in the future.

Here is what I had to edit:

    $request = db_query("
            SELECT COUNT(*) AS 'POSTCOUNT', {$db_prefix}members.ID_MEMBER, {$db_prefix}members.memberName, {$db_prefix}membergroups.onlineColor
            FROM ({$db_prefix}messages INNER JOIN {$db_prefix}members ON {$db_prefix}messages.ID_MEMBER = {$db_prefix}members.ID_MEMBER) LEFT JOIN {$db_prefix}membergroups ON {$db_prefix}members.ID_GROUP = {$db_prefix}membergroups.ID_GROUP
            WHERE ((({$db_prefix}messages.ID_TOPIC)=$topic))
            GROUP BY {$db_prefix}members.ID_MEMBER ORDER BY POSTCOUNT DESC ", __FILE__, __LINE__);

Where you previously had:

    $request = db_query("
            SELECT COUNT(*) AS 'POSTCOUNT', smf_members.ID_MEMBER, smf_members.memberName, smf_membergroups.onlineColor
            FROM (smf_messages INNER JOIN smf_members ON smf_messages.ID_MEMBER = smf_members.ID_MEMBER) LEFT JOIN smf_membergroups ON smf_members.ID_GROUP = smf_membergroups.ID_GROUP
            WHERE (((smf_messages.ID_TOPIC)=$topic))
            GROUP BY smf_members.ID_MEMBER ORDER BY POSTCOUNT DESC ", __FILE__, __LINE__);

Kirk

Navigation

[0] Message Index

[#] Next page

[*] Previous page