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.

[Generics]

thx for the help

Hy want to used this in specifie forum ...

I Try this :

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

It's writting 1 everytime

Some one can show me ?

[Justice]

wow, I just installed this in less than two minutes and it works perfectly.

what's the catch??

[MApI]

Hi, great hack, but there's a way to put this info into the left column (where the name, avatar, date of registration) instead the user CP ?

thx. in adv. bye.

[afterlab]

Hey tube.. Anyway you can make this appear in the postbit template as well?

Nice hack, worked without a problem.

[MApI]

instead the user CP ?

or in add obv. thx again, MAp|

[MApI]

Ehm ... no answers= no ways to do it ?

cya

Originally posted by afterlab
Hey tube.. Anyway you can make this appear in the postbit template as well?

Nice hack, worked without a problem.

i agree, i installed it flawlessly, but would like to know how to get it to show up in the postbit template too

[Narkan]

Here I am, thanx for this little/great hack, but I would like to see the Started Threads: entry in the postbits template under the Posts: one too...
I tried to do it by myself but got no success
Can someone explain me how to do that?

(P.S. I just can't code PhP/MySQL but I tried to add an entry in the postbits template saying "Threads Started: $starts" and "Threads Started: $startcount[starts]" but it didn't work either way )

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