vb.org Archive
Page 8 of 11 « First 67 8 910 Last »
Show 40 post(s) from this thread on one page

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)

Arngrim 07-15-2006 08:30 AM
Great MOD Boofo. I've been looking for this for a while, and after entering about ten different types of criteria and searching through a dozen pages of the Search engine...I finally found it. Though I use MySQL 4.0.27-standard. Will this be a problem in the future? It seems to be working fine for me... Cheers.

*Installed*

Edit: Aye, seems I am also receiving that E-mail that a few Users above have mentioned. The Hack works fine, though it hasn't updated my correct Thread Count, if it was supposed to do that (i.e. be retroactive). I could probably just create a bunch of 'test' topics, and then erase them, so that I bring the count to its correct level... Anyhow, here's the error in case it differs in any area:

Quote:
Database error in vBulletin 3.5.4:

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
Date : Saturday, July 15th 2006 @ 06:50:22 AM
Script : http://www.address-omitted/forums/cron.php?&rand=826012
Referrer : http://www.address-omitted/forums/usercp.php
IP Address : omitted
Username : Unregistered
Classname : vb_database

Oblivion Knight 07-25-2006 05:45 PM
Just to let you know, I had to remove this block of code in the product for it to install on 3.6.0 RC2:
Code:
$version = explode('.', mysql_get_server_info($db->connection_write));
if ($idx = strpos($version[2], '-'))
{
        $version[2] = substr($version[2], 0, $idx);
}
if ($version[0] < 4 OR ($version[0] == 4 AND $version[2] < 4))
{
        print_cp_message('This Hack requires at least mySQL 4.0.4');
}
Otherwise it spat out an error, whining about an invalid MySQL resource with mysql_get_server_info.

serhat_kk 07-30-2006 02:55 AM
Thanks Boofo but i've a problem

Threads: 1200
Posts: 1,800

how do i add "," to Threads???
thanks...:)

music legend 09-03-2006 04:07 AM
is this mod coming out for 3.6?

Valter 09-06-2006 12:03 AM
Doesn't work properly with 3.6.

I have the same problems as Arngrim and Oblivion Knight reported.

tazB.ca 09-06-2006 10:33 PM
I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...

NetRover 09-09-2006 06:22 PM
Quote:
Originally Posted by tazB.ca
I Sher Hope Someone Can Make This For 3.60,with A Option To Turn Thread Count Off For Some Forums,while Keeping Post Count On Still...
Me too, exactly. Would like my users to be able to find their thread without having to ask the team. I'm not interested in the count and would like to be able to turn it off.

Snake 09-09-2006 07:52 PM
Weird. It's working just fine on my forums.

snowlion 09-12-2006 01:33 AM
Quote:
Originally Posted by Snake
Weird. It's working just fine on my forums.
can you post your customized for this hack to work with 3.6.0

Snake 09-12-2006 12:45 PM
Quote:
Originally Posted by snowlion
can you post your customized for this hack to work with 3.6.0
Look in the previous page, the post by Oblivion. That should do it. ;)


All times are GMT. The time now is 10:11 PM.
Page 8 of 11 « First 67 8 910 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.01574 seconds
  • Memory Usage 1,746KB
  • 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_code_printable
  • (4)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