Thread Count

This is a small hack that will add a thread count to the postbit, but it makes it avaible to any varible that gets the whole user table, such as $bbuserinfo and $userinfo.

Included is an update function that will allow you to update the threads counts for any reason.

Shouldn't take more than 5 min to install

It was tested on two dev boards, there shouldn't be any issues.

Thanks to Matt and Chris Padfield

[mrpibbny]

I have 2,600 threads, that isn't the problem. I wish I was better at this stuff. :ninja:

[tanyeri24]

also works under 3.5.0 ?

[MajorFm.com]

Was the ever a fix for this? we cant all be wrong...?

[hotwheels]

I just installed it tonite on 3.07 and it worked perfectly....

Join Date: Jul 2005
hotwheels's Garage
Location: Cheyenne, Wyoming
Last Seen: 1 Minute Ago (04:34 AM)
Posts: 8,079
Threads: 1205
Time spent in forums: 2 Weeks 2 Days 14 hours 16 minutes 44 seconds
Average time: 2 hours 24 minutes 11 seconds

when you guy's are running the update counter, are you going mysite.com/forum/admincp/misc.php?do=threadcount ? I ran it this way and it has you log in, then it does an automatic update. Mine was forums/admincp but it worked.

hotwheels

here is a random member i checked, just to see if it is working:

Join Date: Oct 2005
1993SE's Garage
Location: Laramie, Wy
Last Seen: 18 Minutes Ago (04:28 AM)
Posts: 510
Threads: 28
Time spent in forums: 1 Day 23 hours 50 minutes 19 seconds
Average time: 56 minutes 57 seconds

[PIKenPIK]

same probs here on VB 3.07.
like the others same DB error:

Invalid SQL: SELECT userid FROM user ORDER BY userid DESC LIMIT -1000, 1000
mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-1000, 1000' at line 1

mysql error number: 1064

Date: Friday 30th of December 2005 08:53:55 PM
Script: http://www.www.xxxxxxxx.xx/forums/ad...ge=1000&page=2
Referer: http://www.xxxxxxxx.xx/forums/adminc...do=threadcount
Username: PIKenPIK
IP Address: XXXXXXXXXXX

First page seems to go well, starting with the 2nd 1.000 threads doesn't work.

Changing in misc.php: $perpage = 1000 into $perpage = 250 gives the same ...

I'm sure it's no memory prob ..... I've done major hacks and 20.000 members on the forum (done lots of maintenance with +1.000 "things" without problems) ...

Can this be fixed?

Really need the hack for further (promotion)plans.

XXX
PnP

//edit: i don't have a table prefix. (so that's not the prob).

[b00k]

Originally Posted by Zachery

d'oh how could i forget that

for now use this

<div>
						$vbphrase[posts]: $post[posts]
					</div>

add under

<div>
						$vbphrase[threads]: $post[threads]
					</div>

for those unsure, add this to your postbit_template. Once you do this and run the update it wil start counting NEW THREADS.

[sybakaos]

Those having problems with thread updates (misc.php step) set

$perpage = 1000;

To the number of threads you have. For example, I have a forums with 140k threads. I changed the code to:

$perpage = 140000;

This is -not- a fix for this hack but a way to omit the (possible) faulty code for forums over 1000 threads..

Enjoy!

[mrpibbny]

I get the following error when I access the last instruction -

Database error in vBulletin 3.0.8:

Invalid SQL: UPDATE user SET threads = 0 WHERE userid = 180
mysql error: Unknown column 'threads' in 'field list'

mysql error number: 1054

Date: Saturday 03rd of June 2006 03:06:41 PM
Script: http://c0h0rt.org/forum/admincp/misc.php?do=threadcount
Referer:
Username: stackzilla
IP Address: 24.195.194.67

Any thoughts as to what I did wrong?

[4Prometheus]

Where is INSTALL?

Thank you very much for taking the time and trouble to share a working hack.

Happy Holidays!

Peace.