How many posts did a user make in which forum

[the_sisko]

What does it do?
OK, this is one off my many hack I made a long time ago, it was very bad as my sql was very bad. Today I improved it a little bit as I learned some more sql :D
Some time ago I needed to get some new mods and wanted a fast way to find out where a specific user posted most. So I created this little stats script which shows up the number of posts in very forum. I took the function from forum.php and modified it a little bit.
For better understanding see screenshot in next post.
https://vborg.vbsupport.ru/attachment.php?postid=311900

Installation

Edit /admin/user.php
Find:
<li>".makelinkcode("View the profile for $user[username]","../member.php?s=$session[sessionhash]&action=getinfo&userid=$userid",1)."</li>
under it put:
<li>".makelinkcode("Show in which forum $user[username] posted","countpost.php?s=$session[sessionhash]&userid=$userid&username=$user[username]")."</li>

Upload countposts.php
Put countposts.php in your admin folder.


You will find a new link on the CP under edit user called:
[Show in which forum USERNAME posted]

When you click on it, you will see a page which shows a statistic in which forum the user posts how many posts.



EDIT
Protection
I limited this function to the admins added under the config.php file. If you want this hack to be used be any admin just do this:
Find:
if (($action=="modify") && checklogperms($canviewadminlog,1,"<p>Page viewing restricted.</p>")) {and replace it withif ($action=="modify") {

[the_sisko]

Screenshot

[JohnWoo]

Some screenshots plz ?!

[Matt87]

Very Nice job!

[JohnWoo]

Ohh.. sorry... I`ll post before you attach it .. :) :lol:

[the_sisko]

Tested on 2.2.5 only but should work on any version above and below.

[Floris]

My members might have an interest in this being a public page. Is that possible? Or does that include some security issue? like showing forums they shouldn't see?

I'd love such an overview (public)

[Matt87]

Yes I agree... :D

[Schorsch]

public would be great !!!! :p

[N9ne]

Yeah public would be great :)

[the_sisko]

Public shouldn't be a prob, as we can use the forum permission function. My only thought about this is, on my forum which have ~55 active forums, I have ~100 queries for this page. OK its half the query size as when I go to edit forums in CP but its the CP and I don'T do this often.

So I could make this a public one as well, but remember this could make a lot load on you db.

[Erwin]

Originally posted by the_sisko
Public shouldn't be a prob, as we can use the forum permission function. My only thought about this is, on my forum which have ~55 active forums, I have ~100 queries for this page.

That is a big problem. If you make that public, anyone can bring your server to its knees by setting that page to auto-refresh using a cron job. :) So better optimize it first.

[Floris]

Originally posted by the_sisko
Public shouldn't be a prob, as we can use the forum permission function. My only thought about this is, on my forum which have ~55 active forums, I have ~100 queries for this page. OK its half the query size as when I go to edit forums in CP but its the CP and I don'T do this often.

So I could make this a public one as well, but remember this could make a lot load on you db. Since I am just a little people person with little people members and little forums .. i think it wont be a problem, not many will use it, not even on a daily base!

In my personal case i would like to have it:
admins - through back-end {everything} and public like the (super)mods.
(super)mods - can view everybody (like the admin, but only public (my (super)mods don't have back-end access
registered - can only view their own information - not others. (maybe through userCP option?)
everybody else - no access to this feature at all

And ofcourse, if a registered member can't view the moderators forum - then they shouldn't - like normal protection. but thaz all.

Just to give an impression of what I have in my head about this.

[Floris]

Originally posted by Erwin


That is a big problem. If you make that public, anyone can bring your server to its knees by setting that page to auto-refresh using a cron job. :) So better optimize it first.
A little extra code can prevent that with ease.

[Erwin]

Originally posted by xiphoid

A little extra code can prevent that with ease.

That's true. :) But having 2 queries for each forum is still too server-intensive.

[Vile]

Cool hack. Thanks :)

[Velocd]

Nice idea, I'll surely install it whether or not you plan a public release.

/me installs

[the_sisko]

Originally posted by Erwin


That's true. :) But having 2 queries for each forum is still too server-intensive.

IF you will look at the code its one query for the numbers and one for every forum. I used the function from /admin/forum.php to show a sortet list of all forums.
Don't know if there is a better and fast way to create a list of all forums and its subforums? IF so, I would like to know, to make this code better.

[Sc0rp]

thanx mate.. awesome hack :)

just one thing.. u named it countposts.php but the link goes to countpost.php... just thought I'd tell ya :p

[the_sisko]

Originally posted by Sc0rp
thanx mate.. awesome hack :)

just one thing.. u named it countposts.php but the link goes to countpost.php... just thought I'd tell ya :p

Thx m8, didn't realised that, cause my server looks for same file names and took the closest result he gets ;)

Will fix this in next update.

[Me2Be]

Great idea :)

Is there anyway to that you can put a time frame in there? Like XYZ's posts in the past 30 days?

[-=dm=-]

Hi nice hack:)
Im getting page NOT found :(
what Im doing wrong? I have vB2.2.4

thanx

EDIT:


<li>".makelinkcode("Show in which forum $user[username] posted","countpost.php?s=$session[sessionhash]&userid=$userid&username=$user[username]")."</li>


fixed :)
countpost.php =countposts.php (missing "s")

[Odysseus]

Thx Christian for this hack ... I use it now as well.
cu on scifi-forum.de ;)

[Jethro]

Cool hack sisko, we are going to install it.

Thanks for sharing.

[rjlohan]

'We' Jethro... :lol:

;)

Will have to check it out first, see what we can do about the SQL - if alot of queries are involved, could be a problem.

[over]

nice hack. might install.

[ladyfyre]

great hack :)

One question though....

Does anyone know how i could change this so that the script would only return forums in which a user has posted?? My site is set up by geographical area, with over 300 forums all told...and scrolling down trying to see where they have posted is a BIG TIME pain when many are blank.

[subu1]

Originally posted by -=dm=-
Hi nice hack:)
Im getting page NOT found :(
what Im doing wrong? I have vB2.2.4

thanx

EDIT:


<li>".makelinkcode("Show in which forum $user[username] posted","countpost.php?s=$session[sessionhash]&userid=$userid&username=$user[username]")."</li>


fixed :)
countpost.php =countposts.php (missing "s")

good morning *g*

i have the same problem, but i don't no what you tell me, oh my english *g*

*.php can not find

whats going on , please help me

thxx subu1

[Rynthar]

This is ++++ing me off, every hack I have installed wont work. I am on 2.3.0 and when I upload countposts.php and click on the link to view the posts, I get a page cannot be found. When I go to /admin/countposts.php I get that damn mysql error 1064. Help! I cant install any hacks since I get the same damn thing

[legendarysk8er]

I got the same thing, and I changed the countpost to countposts.php and it still didn't work.