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.

[JJR512]

I just checked my installation of this hack by reinstalling it. It still doesn't work. In fact, before I reinstalled it, my threads started count was 23 (which is, of course, very very wrong), and now, after reinstalling it, it is 0. Before I reinstalled it, though, I updated forum info and updated thread info. So either updating the counters, or reinstalling it, made my thread started count go back to 0.

I'm telling you all this because I hope it will help you figure out what's wrong.

[tubedogg]

wtf???????

I am so confused. There is *no* reason that any of that should affect it. It counts the number of threads you are listed as having started in the database. I really don't understand...

OK I just did a test install on my vGI board. It appears to be working, although the number of threads are small anyway because there hasn't been much activity on that board yet.
I then updated counters, and the numbers remained the same.

There's got to be some other reason.

One thing to try - remove

  if ($starts == ""):
	  $starts = "0";
  endif;

from the code you added to member.php.

[JJR512]

I did that, and it still said 0 for everyone I checked, including myself. But since I reinstalled it, there were no new threads, only replies. So I started a test thread and checked again. This time it said I had started 1 thread.

[tubedogg]

Something's wrong here. It doesn't count based a date, it just does a scan of the thread table, meaning it should count from the day you installed your board, no matter when you installed the hack.

Try replacing the query with this

  $startcount = $DB_site->query_first("SELECT COUNT(postuserid) AS starts FROM thread WHERE postuserid='$userinfo[userid]' AND open!='10'");

[JJR512]

Still says 1 for me.

[tubedogg]

Can you run that query via telnet on your DB please?

I really do not understand what's going on here.

[JJR512]

Telnet is such a pain in the ass for me to do, I have to tell it what IP I'm using right now (dialup), because it's really SSH, and wait 10 minutes, etc. But I can do it if I have to.

I'd prefer to do it by phpMyAdmin, if possible.

Either way, could you tell me what exactly to type in?

[JJR512]

Nevermind, I just ran this query by phpMyAdmin...

SELECT COUNT(postuserid) AS starts FROM thread WHERE postuserid='$userinfo[userid]' AND open!='10'

The number it came back with was 7208. According to my main vB page, I have 7231 total threads.

[tubedogg]

Sorry - I couldn't get to the vB site just now. Weird..

Anyway try this query (and phpMyAdmin is fine)

SELECT COUNT(postuserid) AS starts FROM thread WHERE postuserid='YOURUSERIDHERE' AND open!='10'

and put in your user id where it says YOURUSERIDHERE

[JJR512]

I tried removing the AND open!='10' from the hack code in member.php, and this time, my thread start count was 2. Just to make sure, I put it back in, and it went back to 1.