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

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Miscellaneous Hacks - Threads Started by User in Postbit & Profile (https://vborg.vbsupport.ru/showthread.php?t=151844)

Mudvayne 07-09-2007 10:00 PM
Threads Started by User in Postbit & Profile
 
First of all this is a fixed version of Threads Started by User in Postbit and Profile for 3.5.4 by Boofo. I would like to thanks to Boofo for giving me the permission of releasing this.
Quote:
Originally Posted by Boofo
Go for it, if it is totally tested and working
As this product is the original work of Boofo. So I’m going to use his description as well. All I did is fixed one error related to DB query & remove the MySQL version check as vBulletin 3.6.x already requires MySQL 4.3.3.

Description:
This product counts the threads started by a user and displays it in the postbit and the profile. It will also display the threads per day in the profile. The thread count is automatically updated hourly via cron job. New threads are added to the count in real time. No extra queries are run in the postbit or profile when getting the thread count, only when the cron job runs. This product has been tested on a live board with over 15,000 users and 40,000 threads and ran unnoticeably in the background in 0.3 seconds during the cron job update. This product only counts valid threads (not moderated or soft-deleted threads).

Live Demo:
Golpo Community Forum

Install Instruction:
  • Import the product-thread_count_7272
  • Edit the "postbit" & "MEMBERINFO" Template.
Update Instruction:
  • Import the product-thread_count_7272. Don't forget to allow overwrite!
Screenshots & template edit instructions are included in zip file.

dbirosel 07-10-2007 03:50 AM
Sweet bro!! I will install right now!

dbirosel 07-10-2007 03:56 AM
Actually, i am using that activity mod.

http://www.caraudiojunkyard.com/foru...html#post19637

Is it possible to replace the "Today" to "Threads"?

SCRIPT3R 07-10-2007 04:55 AM
why not inject the remaining template edits? also, why not hotlink the count totals to the actual threads/posts? i updated the previous version product to do all that and here's my postbit as an example...

Milad 07-10-2007 07:40 AM
I would like to install this hack, but I can't because I don't want to edit templates. I took a look at them, most edits can be done via the new $template_hook

I marked it as installed, and will rate it 5 of 5 if you do the edits in the plugin system.

projectego 07-10-2007 08:57 AM
Nice one! I've been looking for something like this for a while now. Cheers!

Triky 07-10-2007 09:24 AM
Installed. :)

Snake 07-10-2007 03:50 PM
Thanks for the release! :D

Endurer 07-10-2007 05:07 PM
I've been looking for this.. thank you so much :)

Installed.

Andyucs 07-10-2007 05:38 PM
i get this when the cron runs

PHP Code:
Database error in vBulletin 3.6.7:

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 
Error Number : 1064
Date         : Tuesday, July 10th 2007 @ 07:37:11 PM
Script       : 


All times are GMT. The time now is 09:57 PM.
Page 1 of 10 1 23 Last »
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.01047 seconds
  • Memory Usage 1,739KB
  • 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
  • (1)bbcode_php_printable
  • (1)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
  • (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