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

Distance 07-10-2007 05:46 PM
Thanks, I will install once the template edits have been intergrated into the plugin system.

Distance

Mudvayne 07-12-2007 03:21 PM
@dbirosel, this hack has nothing to do with that. However edit the "texttoday.gif". That might works.

@GearTripper, as I'm using without clickable search links so I shared both. There is instructions for clickable search links as well.

@Milad, Thanks brother. I 'll work on it as soon as I finished my exams.

@Andyucs, Redownload the zip file & reimport the product. Make sure you have overwrite the product.

@Distance, I 'll try my best :). Anyway sorry for late reply. I'm on the middle of my exams.

dbirosel 07-12-2007 03:28 PM
First of all, thank you Mudvayne for answering me. About the Activity mod, it uses a counter just like how the Post Counter work. How does your counter for Threads does not relate? Isn't your hack giving us a counter of everytime a member creates a new thread it adds 1?

bacanze 07-12-2007 03:43 PM
Hope this works :)

Andyucs 07-13-2007 04:12 PM
sorted it thanks move to a better host with updated php etc runs like a dream thanks

sybakaos 07-19-2007 09:17 AM
This hack upon uninstall removes the user.threads field from the user table, bug?

Mudvayne 07-21-2007 02:58 AM
Quote:
Originally Posted by sybakaos (Post 1295511)
This hack upon uninstall removes the user.threads field from the user table, bug?
Nop.

Boofo 07-22-2007 12:59 AM
Quote:
Originally Posted by sybakaos (Post 1295511)
This hack upon uninstall removes the user.threads field from the user table, bug?
That is not a bug as this hack is what adds that field. ;)

Boofo 07-22-2007 01:03 AM
Quote:
Originally Posted by GearTripper (Post 1287285)
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...
I would be interested in seeing your edits with the prior version as I am still running 3.5.4. ;)

sybakaos 07-22-2007 08:55 AM
Quote:
Originally Posted by Boofo (Post 1297841)
That is not a bug as this hack is what adds that field. ;)
Oh, I understand it now. I used a threads counter in vb3.0.x before my vb367 upgrade which added that same field.

Chester87 07-22-2007 12:40 PM
Wondering if this hack could be modified so it will only count the threads in a particularly forum.

So it wil count like this

Posts: 2540
Threads in imageforum: 12
Threads in tekstforum: 45

How can i change this a little bit so i can make it do this??

Techno05 08-23-2007 06:11 PM
Yeah I would like to know that also

momo2 09-06-2007 04:39 AM
Installed, how can I get have it line up in one single line, so I can save space ??

Thread 2000 Posts 3000
instead of
Thread 2000
Posts 2000

momo2 09-06-2007 05:24 AM
never mind i added ur alternative, and it's all fixed, this is the best mod i have seen i have a very busy forum and, i can simply click on anyone and see all their posts or threads..

Thanks..

Mystery Man 10-10-2007 02:09 PM
Quote:
Originally Posted by Andyucs (Post 1287755)
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       : 
I'm receiving the exact same error and I've tried re uploading the xml and also made sure it was overwriteable but to no avail. I'm running 3.6.8 anybody else having this issue or better yet a way to fix it?

Mudvayne 10-10-2007 02:44 PM
Try uninstall then reinstall the hack.

Mystery Man 10-10-2007 03:36 PM
Quote:
Originally Posted by Mudvayne (Post 1356925)
Try uninstall then reinstall the hack.
Already did twice, but nothing seems to work, im quite sure ive done everything correctly. any chance this is not compatible with 3.6.8?

Mudvayne 10-14-2007 04:24 AM
I'm not using 3.6.8 yet. I will test & confirm you ASAP.

DiverTree 10-14-2007 11:39 AM
Quote:
Originally Posted by Mudvayne (Post 1359497)
I'm not using 3.6.8 yet. I will test & confirm you ASAP.
seems to work fine for me. ive got it installed on a 3.6.8, as per instructions. :)

AWJunkies 10-16-2007 08:08 PM
It shows 0 threads for me not sure what is up. DO I need to wait for it to do its cron job?

forced the corn and this is what happens:

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:

UPDATE allwheeljunkies_user AS user
SET user.threads =
(
SELECT COUNT(threadid)
FROM allwheeljunkies_thread AS thread
LEFT JOIN allwheeljunkies_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 allwheeljunkies_thread AS threa
Error Number : 1064
Date : Tuesday, October 16th 2007 @ 05:12:46 PM
Script : http://allwheeljunkies.com/admincp/c...ncron&cronid=7
Referrer : http://allwheeljunkies.com/admincp/c....php?do=modify
IP Address : 66.75.231.222
Username : AWJunkies
Classname : vb_database

mgurain 10-21-2007 11:04 AM
Quote:
Originally Posted by Milad (Post 1287374)
I would like to install this hack, but I can't because I don't want to edit templates.
Same,,

haytham 11-02-2007 10:41 AM
I am getting only the post count not threads started?? 3.6.8

haytham 11-02-2007 10:44 AM
Found it..I am using legacy not postbit. Working now. Thanks. Installed.

lasto 11-11-2007 12:07 PM
works fine this cheers m8

TJFweb 11-12-2007 01:36 PM
Hi,

Is it possible to select which forums are taken into account when tallying up the posted thread count?

I have a few spammy forums which I don't want to include in the figure.

Thanks!

Defkalion 11-17-2007 09:25 PM
I'm also looking for a hack that does this, ie lets you select which forums participate in the thread count. Anyone can help?

AngelBlue 12-06-2007 11:55 PM
Quote:
Originally Posted by database error when cron runs
Database error in vBulletin 3.6.8:

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

2impulsiv 12-07-2007 01:58 AM
Works great..

Cheers..

:)

Icy 12-08-2007 05:03 AM
I'm using it in vB 3.6.8 PL2 without having any problems. Can I have a temporary admin access to your forum so that I can check it?

Icy 12-08-2007 01:18 PM
My PHP version is 5.2.5. BTW I have tried it on my localhost with PHP 4.3.10 & got no DB error so far.


All times are GMT. The time now is 06:58 PM.
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.01997 seconds
  • Memory Usage 1,836KB
  • 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_php_printable
  • (11)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