User Forum Activeness Hack v1.0

Yet another hack by g-force2k2 (yeah i know aren't we all gettign sick of it by now )

Edit: Download the latest attachment [ Here ]

Thanks bunches to Neo for the fix

well this one wasn't requested but i myself was trying to plain around with mysql and all and i came up with a new hack

What does this hack do?
// +++++++++++++++++++++
Simply shows what forum the user is most active in and the percentage of his posts in that forum compared to overall

What to do?
// +++++++++++++++++++++
File Modifications (2)
Template Modifications (1)
Templates to Add (1)

It's a fairly easy hack to install maybe 1-2 minutes max but i like how it looks shows on the getinfo template when viewing another member's profile... simple yet wicked

Instructions in the .php file attached below just open in a text editor

Notice i didn't include this on the postbit template because it would up the query count by a fair amount so i figured the getinfo would be suffice... If you like this hack i'd be greatful if you clicked install... regards and enjoy

g-force2k2

[Velocd]

Nice hack G-force, I will probably install this one.

Originally posted by JohnWoo
2g-force2k2 :
can you try create a little addon to this huck... You can see it in a attach! Sorry fo russian ... but it will by great!

I'm guessing by your screenshot (since I can't read Russian) you want it to display the top 5 most active spots that user visits, plus the percents? That it looks like. This could probably be done seperate in a pop-up window, or you could just implement it somewhere in getinfo.

How about that G-force, it wouldn't be too hard, right? Just while loop- fetch_array it and the results should come out similar to that

[Mathieu]

thx for this i'll install him when i've got a little time

[Boofo]

Ok, g-force2k2, here I go. Can it be made to be able to only be viewed by Admins and Supermods and maybe mods in the profile view? And from a template again? (I don't have anything show up in the profile if it has a zero value or no value associated with it).

[assassingod]

Very nice I'll defintely install this when I get back home

Like Boofo's question, Can it only be viewed by Admins/Super mods?? Thanks

[Boofo]

g-force2k2, is the 12% supposed to be for that forum only or for total posts on the site? And I'm still trying to get to to only show to Admins, Supermods and mods.

Also, I have a private forum for coding hacks that only Me and one other person are allowed in and I know that I have more than 26 posts in there and it does not show that here. And ideas on this one?

Posts: 206 (1.71 posts per day | 39.62% of total posts)

Member Forum Activeness: Boofo is most active in General Forum
Accounting for a total of 26 Posts which is 12 % of Boofo's total posts!

The guy below has posted 90+% of his total posts in the Staff forum and it says only 1 at 0%? What is wrong with this picture?

Posts: 111 (1.83 posts per day | 21.35% of total posts)

Forum Activeness: XXXXXX is most active in Staff Lounge accounting for a total of 1 Post which is 0 % of Madman's total posts!

[g-force2k2]

Velocd... Johnwoo i'll work on such a hack shortly... Boofo for the staff restriction just find:

PHP Code:

    if(empty($t_post[ppforum])) { 


replace it with:

PHP Code:

    if((empty($t_post[ppforum])) OR ($bbuserinfo[usergroupid] != 5 OR $bbuserinfo[usergroup] != 6 OR $bbuserinfo[usergroupid] != 7)) { 


Also about the private forums i guess it does take into account the restrictions... As for the 0% Boofo its because its floor which means its rounded to the nearest whole number...

regards...

g-force2k2

[Boofo]

Is there any way to get it to include all forums, private or not? And maybe have it do like a 1.32 % instead of just rounding it to the nearest whole number?

Originally posted by g-force2k2
Also about the private forums i guess it does take into account the restrictions... As for the 0% Boofo its because its floor which means its rounded to the nearest whole number...

regards...

g-force2k2

[g-force2k2]

Originally posted by Boofo
Is there any way to get it to include all forums, private or not?

i'll have a look just have to wait til i get out of college then i'll do some checks and stuff... i didn't really intend for the hack to bypass private forums but it did so know i'll have to backtrack regards...

g-force2k2

[Boofo]

I just checked and the code you gave me makes it so no one can see it now, not even the Admin of Supermods or mods. Also, it does show private forums, because the staff forum is private but the other private forum it doesn't show and that is where the user has most of his messages.

BTW: Are you talking about "until you get out of college" for the year or just for today?

[Neo]

Fixed code error. This will now work.

find

PHP Code:

    SELECT COUNT(postid) AS ppforum, thread.forumid AS forumid
    FROM post
    LEFT JOIN thread ON thread.threadid = post.threadid
    WHERE userid = '$userinfo[userid]'
    GROUP BY (forumid)
    DESC LIMIT 1"); 


replace with

PHP Code:

    SELECT COUNT(postid) AS ppforum, thread.forumid AS forumid
    FROM post
    LEFT JOIN thread ON thread.threadid = post.threadid
    WHERE userid = '$userinfo[userid]'
    GROUP BY (forumid)
    ORDER BY ppforum
    DESC LIMIT 1"); 


I added by ORDER BY so that it will give you the higest post number instead of the forumid T_T