How many posts did a user make in which forum

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
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:

PHP Code:

  <li>".makelinkcode("View the profile for $user[username]","../member.php?s=$session[sessionhash]&action=getinfo&userid=$userid",1)."</li> 


under it put:

PHP Code:

  <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:

PHP Code:

if (($action=="modify") && checklogperms($canviewadminlog,1,"<p>Page viewing restricted.</p>")) { 


and replace it with

PHP Code:

if ($action=="modify") { 


[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:

PHP Code:

<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

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:

PHP Code:

<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.