vb.org Archive
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Thread Count (https://vborg.vbsupport.ru/showthread.php?t=74473)

GeekyDesigns 01-15-2005 10:00 PM
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 :)

yoyoyoyo 01-16-2005 08:20 PM
***clicks install***

Zachery 01-16-2005 08:22 PM
Added a screen shot

rex_b 01-16-2005 08:45 PM
Nice :)

Zachery 01-16-2005 08:58 PM
Sorta suprised no one has done it before

rex_b 01-16-2005 09:21 PM
Yah I think it would be much better if that's the count we all used instead of posts.

Guest190829 01-16-2005 10:44 PM
Great mod guys!

* clicks install *

Mike Gaidin 01-17-2005 12:45 AM
Quote:
Originally Posted by Zachery
Sorta suprised no one has done it before
It was, but I don't think it was released here. I had requested it.

deathemperor 01-17-2005 01:11 AM
Quote:
Originally Posted by Zachery
Sorta suprised no one has done it before
they has but they didn't release here, I've seen several boards have this.

Zachery 01-17-2005 01:31 AM
Quote:
Originally Posted by deathemperor
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 01-17-2005 03:10 AM
I wont be using this as I have no need to but if I may suggest something:

Quote:
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 01-17-2005 03:47 AM
Quote:
Originally Posted by Zachery
Sorta suprised no one has done it before
Then you haven't checked my profile. I did this quite a while ago. ;)

Boofo 01-17-2005 03:49 AM
Quote:
Originally Posted by Mike Gaidin
It was, but I don't think it was released here. I had requested it.
Mike, how soon we forget. ;)

alsfeena 01-17-2005 06:29 AM
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 01-17-2005 09:52 AM
wots the load on this or additional queries ?

TCattitude 01-17-2005 10:52 AM
Quote:
Originally Posted by Boofo
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 01-17-2005 11:38 AM
Quote:
Originally Posted by Boofo
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 01-17-2005 11:56 AM
if i get to this URL Referer: http://www.celebritymarkt.de/admincp...do=threadcount i get this error.

Code:
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 01-17-2005 12:20 PM
Quote:
Originally Posted by Snatch
if i get to this URL Referer: http://www.celebritymarkt.de/admincp...do=threadcount i get this error.

Code:
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 01-17-2005 02:29 PM
/me installed

Shack Networks 01-17-2005 03:39 PM
Do we need to add anything to postbit as I am seeing nothing on my test forum

Zachery 01-17-2005 03:42 PM
d'oh how could i forget that

for now use this

Code:
<div>
                                                $vbphrase[posts]: $post[posts]
                                        </div>
add under

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

Shack Networks 01-17-2005 03:44 PM
Tis OK I Figured it, nice hack

I clicked Install

Shack Networks 01-17-2005 03:49 PM
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 01-17-2005 03:51 PM
Ahh my mistake once more, it does it Via admincp/misc.php?do=threadcount, I was using the wrong thing lol

Kewl hack

Zachery 01-17-2005 04:19 PM
Quote:
Originally Posted by 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
Right now it wont delete the threadcount if the thread gets deleted, I will fix that later

Lethal 01-17-2005 05:40 PM
Quote:
Originally Posted by Boofo
Then you haven't checked my profile. I did this quite a while ago. ;)

yup, i have yours installed boofo

TTG 01-17-2005 06:50 PM
Nice and useful addition .. thanks

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

Snatch 01-17-2005 07:58 PM
Quote:
Originally Posted by Zachery
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 01-17-2005 08:32 PM
Quote:
Originally Posted by Zachery
d'oh how could i forget that
*cough*LMFAO*cough* :devious:

Zachery 01-17-2005 08:34 PM
Quote:
Originally Posted by Snatch
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 01-17-2005 08:43 PM
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 01-17-2005 08:59 PM
Quote:
Originally Posted by 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 ?
You need to be able to run the threadcount updateer for everyones threads count to start above 0

Zachery 01-17-2005 09:00 PM
Quote:
Originally Posted by lasto
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 01-17-2005 09:36 PM
Installed =)..

Good mod! Good Job!

Mike Gaidin 01-18-2005 01:04 AM
Quote:
Originally Posted by Boofo
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 01-18-2005 04:36 PM
No idea why but using both Firefox and IE6 the threadcount page does not get page 1 ?

Any one else having this problem ?

Cheertobi 01-18-2005 06:02 PM
Hi,

Quote:
Originally Posted by 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 ?
jap, same problem here using IE6!

Tobias

Cheertobi 01-20-2005 02:48 PM
Hi,

Quote:
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 01-31-2005 05:08 PM
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


All times are GMT. The time now is 05:33 AM.
Page 1 of 3 1 23
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01425 seconds
  • Memory Usage 1,815KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete