User has started X threads

This one is a request from JJR512. It shows, in the user's publicly-accesible profile (member.php?action=getinfo), how many threads that user has started.



Hack version: 0.0.2

For version: 2.0.0 Final

Files needed: memberadd.txt, getinfoadd.txt

Files to edit: member.php

Templates to edit: getinfo

Instructions
1] Open memberadd.txt from the zip file in a text editor.

2] In member.php, find (around line 1193)

     eval("\$birthday = \"".gettemplate("getinfo_birthday")."\";");
  }

Directly below this, add the contents of memberadd.txt

3] Upload member.php to your web server.

4] Open getinfoadd.txt from the zip file in a text editor.

4] In the template getinfo, find

<tr bgcolor="#F1F1F1"><td>
<normalfont><B>Total Posts:</B></normalfont></td>
<td><normalfont>$userinfo[posts] ($postsperday posts per day)</normalfont>
</td></tr>

Directly below this, add the contents of the getinfoadd.txt file.

5] Save the template.

6]To test it out, go to http://path/to/your/forums/member.ph...tinfo&userid=5

Instructions are also included in the zip file (threadsstarted.txt).

FEEDBACK WANTED! Likes/dislikes/modification requests all accepted.

Please DO NOT conact me via AIM, ICQ, PM, or email about this hack. Post your question/problem here and I will try to help you.

[Neo]

how would you exculde surton forums?

Originally posted by Cruz

// Find out how many threads this user has started
  $startcount1 = $DB_site->query_first("Select COUNT(postuserid) AS starts from thread where forumid='3' AND postusername='$userinfo[username]' AND open!='10'");
  $startcount2 = $DB_site->query_first("Select COUNT(postuserid) AS starts2 from thread where forumid='16' AND postusername='$userinfo[username]' AND open!='10'");
  $startcount3 = $DB_site->query_first("Select COUNT(postuserid) AS starts3 from thread where forumid='14' AND postusername='$userinfo[username]' AND open!='10'");
  $starts=$startcount1[starts]+$startcount2[starts2]+$startcount3[starts3];
  // end Find threads

that will work
you were resetting the variable $startcount with every different select query.

Do i put this code in the postbit template then???

thanks

[Cruz]

no...the way I did it was to place it in the members.php -> because i had it add a few fields to the display stuff...
then you can put the $startcount1 wherever.
here is code i am using:

  // Find out how many game  reviews this user has made
  $gstartcount = $DB_site->query_first("SELECT COUNT(title) AS starts FROM thread WHERE postusername='$userinfo[username]' AND forumid='16'");
  $gamestarts = $gstartcount[starts];
  // end Find threads
 // Find out how many media clips this user has posted
  $mstartcount = $DB_site->query_first("SELECT COUNT(title) AS starts FROM thread WHERE postusername='$userinfo[username]' AND forumid='25'");
  $mediastarts = $mstartcount[starts];
  // end Find threads

  // Find out how many missions this user has made
  $mistartcount = $DB_site->query_first("SELECT COUNT(title) AS starts FROM thread WHERE postusername='$userinfo[username]' AND forumid='26'");
  $mixedstarts = $mistartcount[starts];
  // end Find threads

thanks

Nice work

But how can i display the threads in Members?

[Admin]

First you need to enter your username here, yuppie.

[Lesane]

Originally posted by Gutspiller
This hack has a problem with users names that have a ' in the name. Take a look at the help FireFly gave to fix the problem in this thread: http://www.vbulletin.com/forum/showt...072#post167266

That thread is gone, no permission

Can you post the fix here? or firefly?

[LanciaStratos]

This doesn't work with 2.2.0, does it?

[MApI]

My work very well with 2.21. I'm just lookin' for the variable that shows started threads in postbit template too.

cya

[Gutspiller]

nevermind.