vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - Threads Started by User in Postbit and Profile (https://vborg.vbsupport.ru/showthread.php?t=115136)

futuredood 06-17-2006 01:54 AM

hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

Boofo 06-17-2006 05:05 AM

Quote:

Originally Posted by futuredood
hey boofo, i installed this successfully, except nowhere does it show us how to set up the cron.. can you add that to the instructions? thanks.

Nope, can't give you any instructions, sorry. ;)

That's because it uses a hook and does it all automatically. ;)

futuredood 06-17-2006 05:26 AM

haha great! what i did was i uploaded it, and only put the code in my memberinfo template (i only want it to show up in the profile).

is that the reason it's not working for me? i didn't want it to show up in the postbit templates. if it hasn't been updating, maybe it has to be with my server settings.

Boofo 06-17-2006 05:50 AM

Make sure the threads it isn't counting aren't in forums where you have the postcount turned off. It will update new threads immediately and adjust it when the cron runs.

futuredood 06-17-2006 06:22 AM

ah, i caught the problem. i posted a new thread and it counted fine, but old threads aren't counted. i tried running some maintenance scripts, like updating post counts but that didn't do the trick. was their a step i missed?

Boofo 06-17-2006 06:58 PM

All the threads that the member has started are counted when you first install the hack and when the cron runs.

futuredood 06-20-2006 12:31 AM

hm didn't seem to work when i reinstalled and overwrote the original file. it's ok though since i'm installing this on a new forum.

Tyegurl 06-26-2006 01:00 AM

darn i need mysql 4.0.4...:(

futuredood 06-26-2006 11:17 AM

threads seem to be counted correctly, but this error is e-mailed to me about once a night. i read someone else received this error too.. it'd be nice to know that everything was running smooth, though.:

Database error in vBulletin 3.5.4:
Quote:

Invalid SQL:

UPDATE user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN forum AS forum ON forum.forumid = thread.forumid
WHERE visible = 1
AND (forum.options & 4096)
AND user.userid=postuserid
);

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 'SELECT COUNT(threadid)
FROM thread AS thread
LEFT JOIN f
Error Number : 1064

barca4ever 07-13-2006 10:08 PM

I have a user has posted 2 threads, so he's thread's count is 2 which is correct, But when I soft-deleted his 2 threads, his thread's count still showing 2 !!!


All times are GMT. The time now is 03:41 PM.

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.01279 seconds
  • Memory Usage 1,734KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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