Customizing SMF > Modifications and Packages

Active Members In Topic

<< < (3/31) > >>

Vinspire:
I installed this mod but didnt see any different in the mod ....

Anyway, what is the mod suppose to do ?

Show the no. of post the member have made in the thread ?

snork13:

--- Quote from: rkirkw on June 07, 2006, 03:00:52 PM ---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

--- End quote ---

oh, thanks for reminding me. I was a bad boy hard coding and actual fixed, but uploaded the wrong 1.2 version. So i will release 1.3 soon to fix the database prefix, along with a few new features as well!

-Snork13

PrizeLive.com:

--- Quote from: snork13 on June 09, 2006, 02:51:01 PM ---oh, thanks for reminding me. I was a bad boy hard coding and actual fixed, but uploaded the wrong 1.2 version. So i will release 1.3 soon to fix the database prefix, along with a few new features as well!

-Snork13

--- End quote ---

soiunds good, looking forward to it!!

do you have an estimated date available?

Jay T:
Snork very nice as always.

I do have one request if it is possible. I like the way VB has it. The amount of replies is a link that will popup this list. This info is sometimes good to have. The way VB has it is it just a little cleaner. Can this be done?

Here is a s/s to help explain

Vinspire:

--- Quote from: Jay T on June 24, 2006, 04:30:09 PM ---Snork very nice as always.

I do have one request if it is possible. I like the way VB has it. The amount of replies is a link that will popup this list. This info is sometimes good to have. The way VB has it is it just a little cleaner. Can this be done?

Here is a s/s to help explain


--- End quote ---

I second this. Even IPB have this and it is very useful ... Can someone pls create this mod ? Thanks :)

Navigation

[0] Message Index

[#] Next page

[*] Previous page