Thread Count

[GeekyDesigns]

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

[yoyoyoyo]

***clicks install***

[Zachery]

Added a screen shot

[rex_b]

Nice :)

[Zachery]

Sorta suprised no one has done it before

[rex_b]

Yah I think it would be much better if that's the count we all used instead of posts.

[Guest190829]

Great mod guys!

* clicks install *

[Mike Gaidin]

Sorta suprised no one has done it before

It was, but I don't think it was released here. I had requested it.

[deathemperor]

Sorta suprised no one has done it before
they has but they didn't release here, I've seen several boards have this.

[Zachery]

they has but they didn't release here, I've seen several boards have this.
i ment released it i did it during the betas

[xmitchx]

I wont be using this as I have no need to but if I may suggest something:

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

Im not sure if thats what im about to suggest, but I suggest having a "resync thread counts" option so that the thread counts are accurate.

[Boofo]

Sorta suprised no one has done it before
Then you haven't checked my profile. I did this quite a while ago. ;)

[Boofo]

It was, but I don't think it was released here. I had requested it.
Mike, how soon we forget. ;)

[alsfeena]

It didnt work with me!!
The forum and threads are working properly but no changes only showing the posts count...?
I did it as in the instruction file and finally i upgraded whole counts of my forum

[lasto]

wots the load on this or additional queries ?

[TCattitude]

Then you haven't checked my profile. I did this quite a while ago. ;)

I was looking for this for a weeks ago, and... nothing (in hacks, betas and also the requests fortums) :rolleyes:

Thanks GeekyDesigns, great mini hack ;)

[Zachery]

Mike, how soon we forget. ;)
Yea I saw bob but your way can be insanely intensive unless i totaly missed how you were storing the data instead of calling it on every page view.

[Snatch]

if i get to this URL Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount i get this error.


Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage: 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

Datum: 17.01.2005 14:54:53
Skript: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount&perpage=1000&page=2
Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount
Benutzername: Snatch
IP-Adresse:

[Zachery]

if i get to this URL Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount i get this error.


Datenbankfehler in vBulletin 3.0.5:

Ungueltige SQL-Abfrage: 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

Datum: 17.01.2005 14:54:53
Skript: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount&perpage=1000&page=2
Referer: http://www.celebritymarkt.de/admincp/misc.php?do=threadcount
Benutzername: Snatch
IP-Adresse:

1064 is generaly dealing with memory, what version of MySQL are you running ?

[BarHopper]

/me installed

[Shack Networks]

Do we need to add anything to postbit as I am seeing nothing on my test forum

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

[Shack Networks]

Tis OK I Figured it, nice hack

I clicked Install

[Shack Networks]

I just noticed that if you delete a thread the and update the thread count it still says it has not been deleted ?

[Shack Networks]

Ahh my mistake once more, it does it Via admincp/misc.php?do=threadcount, I was using the wrong thing lol

Kewl hack

[Zachery]

Ahh my mistake once more, it does it Via admincp/misc.php?do=threadcount, I was using the wrong thing lol

Kewl hack
Right now it wont delete the threadcount if the thread gets deleted, I will fix that later

[Lethal]

Then you haven't checked my profile. I did this quite a while ago. ;)


yup, i have yours installed boofo

[TTG]

Nice and useful addition .. thanks

Clicked install https://vborg.vbsupport.ru/external/2005/01/2.gif

[Snatch]

1064 is generaly dealing with memory, what version of MySQL are you running ?


I use mysql Ver 14.7 Distrib 4.1.7, for pc-linux (i386)
what can i do to fix this error ?

[BarHopper]

d'oh how could i forget that

*cough*LMFAO*cough* :devious:

[Zachery]

I use mysql Ver 14.7 Distrib 4.1.7, for pc-linux (i386)
what can i do to fix this error ?
Upgrade to 4.1.8 and see if it fixes the problem, if it doesnt ill figure out why it isnt running. As its running fine on my 4.1.7 and php 5.0.3 + apache 2.0.52

[Snatch]

The hack is runnig but the threads count beginns from 0 :(
Update to 4.1.8 is not possible for me, is there no other was ?

[Zachery]

The hack is runnig but the threads count beginns from 0 :(
Update to 4.1.8 is not possible for me, is there no other was ?
You need to be able to run the threadcount updateer for everyones threads count to start above 0

[Zachery]

wots the load on this or additional queries ?
No additional load except when maybe rebuilding the thread count otherwise there is 0 additional pull on the database

[Rambo]

Installed =)..

Good mod! Good Job!

[Mike Gaidin]

Mike, how soon we forget. ;)

No, I didn't forget. I only recall it being released at your place and not here. :)

EDIT: I remember now that it was here also.

[Shack Networks]

No idea why but using both Firefox and IE6 the threadcount page does not get page 1 ?

Any one else having this problem ?

[Cheertobi]

Hi,

No idea why but using both Firefox and IE6 the threadcount page does not get page 1 ?

Any one else having this problem ?
jap, same problem here using IE6!

Tobias

[Cheertobi]

Hi,

No idea why but using both Firefox and IE6 the threadcount page does not get page 1 ?

Any one else having this problem ?
is there a fix for this problem?!

Regards,

Tobi

[MajorFm.com]

You sure this works ok? i have done everything exactly how you told me but some people have 0 threads when i know they have got some....

http://www.majorfm.com/forum/thread2925.html

AJ is me... i have done many threads but its shows as 0 but on post 3 it shows 10 threads for that user, i assume this is a problem with usergroups and is not working for mods etc...

Please advise

[Zachery]

You sure this works ok? i have done everything exactly how you told me but some people have 0 threads when i know they have got some....

http://www.majorfm.com/forum/thread2925.html

AJ is me... i have done many threads but its shows as 0 but on post 3 it shows 10 threads for that user, i assume this is a problem with usergroups and is not working for mods etc...

Please advise
Did you rebuild thread counters?

[MajorFm.com]

Did you rebuild thread counters?
Yes i did about 10 times just to make sure... :squareeyed:

I did "Rebuild Thread Information" in maintenence...

[MajorFm.com]

What's going wrong...?

[MajorFm.com]

However it is counting threads from when i installed the hack for some users and from day one for other users...

Please advise...

[MajorFm.com]

anyone?

[Zachery]

Don't know why it isn't working, worked in 3 of my test forums (1 without tABLE_PREFIX and two with

[MajorFm.com]

Is there any checks i can do to fix it... i have done thread count a few times, that didnt solve it..

[MajorFm.com]

Anyone? im using 3.0.3

It still doesnt count threads from day one on some users... is there a fix, what can i do, i really want this hack to work, its just what i was looking for...

[Zachery]

Is it counting your new threads? Are post & thread counts enabled in the proper forums? It ignores threadcount like postcount

[MajorFm.com]

yes it is counting the new threads and some old threads on random members but for some members its only counting new threads...

As far as i know, post and thread counts are enabled, where would i check if they are? but common sense tells me that if it wasnt enabled, the new threads would not be counted either...

[MajorFm.com]

i just installed another stats hack and the threads is displaying properly... there must be something wrong with this... please look into it, i would appreciate it!

[Zachery]

Wonder if anyone is still using it ? :D

[MajorFm.com]

Wonder if this hack will ever work for me ? :-(

[Zachery]

I don't see why its not working, or even why it wouldn't work...

[Tipi]

Go into PHPMyAdmin and run this query, or in the vB Query runner make sure to change for table prefixes if nessary

What does this mean? Can i run the query as it is, or do I have to change it. If I have to change it; How do I do that?

[Zachery]

Did you install vB with a table prefix?

If not
ALTER TABLE `user` ADD `threads` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `posts` ;

otherwise


ALTER TABLE `THETABLEPREFIXGOESRIGHTHEREINSTEADOFTHISuser` ADD `threads` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL AFTER `posts` ;

[Tipi]

I am really not sure. I did not install vB my self, but i think it was without a table prefix.. Thanks for you're reply! :)

[Zachery]

I am really not sure. I did not install vB my self, but i think it was without a table prefix.. Thanks for you're reply! :)
You can check in config.php under the setting tableprefix, if there is anything between the '' then you have one, if theres nothing, then you don't

[mholtum]

sweet
/me installs

[webrats]

it sits at page 1 for me :(

[Zachery]

it sits at page 1 for me :(

Can you be abit more specific...

[webrats]

Can you be abit more specific...
when you do the
http:///misc.php?do=threadcount
it only does the first page then it goes to
misc.php?do=threadcount&perpage=1000&page=2

and is blank kust sits an refreshes

[Zachery]

when you do the
http:///misc.php?do=threadcount
it only does the first page then it goes to
misc.php?do=threadcount&perpage=1000&page=2

and is blank kust sits an refreshes
Hmm... try cleraing your cache and starting again.

[webrats]

Hmm... try cleraing your cache and starting again.
nope still just sits there after the first 1000

[webrats]

is there a way i can just type the command in mysql and do it from shell?

[webrats]

/misc.php?do=threadcount&perpage=2000

will work but once i add the page # is screws up

[webrats]

anyone

[Marco van Herwaarden]

I don't think you can set the perpage that high

[webrats]

I don't think you can set the perpage that high
if i use the default it doesnt work
even at 10 it doesnt work

[vakvak]

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>Where are temlate postbit_legacy, postbit to put into practice

my forum No threads: not
forum/admincp/misc.php?do=threadcount i apply

[Kaishi]

installed flawlessly under 3.07

[webrats]

i still cant get it count the old threads

[Pain86]

i still cant get it count the old threads


i seem to be having the same problem... it doesnt count all the threads.. some members have 3 threads showin in their postbit when they have made more..

is there a way to fix this? :ermm:

[Zachery]

i seem to be having the same problem... it doesnt count all the threads.. some members have 3 threads showin in their postbit when they have made more..

is there a way to fix this? :ermm:
Are all the threads they made in forums that count for posts?

[Pain86]

hmm not sure what you mean? sorry.

:(

do you mean when they make a thread it just adds to their postcount?....

for example .. ive made over 500 threads but 106 thread count shows up in my postcount....

[Zachery]

hmm not sure what you mean? sorry.

:(

do you mean when they make a thread it just adds to their postcount?....

for example .. ive made over 500 threads but 106 thread count shows up in my postcount....
Are the said 500 threads you have made still in the database?

Are they in forums where posts count towards post count?

[Pain86]

yea.. all forums counts towards post count.

[Pain86]

and all the threads are in the datebase

[Pain86]

hi i got this error when updating threads..

Database error in vBulletin 3.0.7:

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

[MajorFm.com]

Im glad its not just me with these count issues... when i installed it, it actually started me off at a grand total of zero... even though i know im the top thread poster on my forum...

[Zachery]

Yes, as it should, because how the hell can a it know what you've done BEFORE you started logging them?

Thats why you rebuild the count...

[MajorFm.com]

lmao... we have rebuilded the count over 10 times as it sez in my previous posts...

[Zachery]

lmao... we have rebuilded the count over 10 times as it sez in my previous posts...
I've tested it and it works in my installations.. I really have no logical explaination why it wouldn't be working..

[MajorFm.com]

maybe a conflict with another hack would be the only explanation... :(

[mholtum]

It didnt work with me!!
The forum and threads are working properly but no changes only showing the posts count...?
I did it as in the instruction file and finally i upgraded whole counts of my forum
Nothing on mine either.. Hmm Am I missing something?

[nubian]

Nothing on mine either.. Hmm Am I missing something?
same here!
i know it says for 3.0.5 but does this work for 3.0.7?

[mkdevo]

installed on 3.0.7. works great! thanks!

[MajorFm.com]

glad its not just me with the issue... i have worn my update counter buttons out!

[mrpibbny]

I can't get it to work, either. It looks as if I've done nothing. *shrugs*

[Kirk Y]

Yeah, I'm having the same problem. I see nothing in my posbit... and when I run the update page, it just keeps going and going... never stopping. I only have 1500 threads... and if it's rebuilding at 1000 threads per page, it shouldn't be taking this long.

[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/admincp/misc.php?do=threadcount&perpage=1000&page=2
Referer: http://www.xxxxxxxx.xx/forums/admincp/misc.php?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]

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.