vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Statistics Modifications - Cyb - Advanced Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=122986)

rchelifan 07-10-2007 04:55 AM

Fantastic hack! I installed it and I like it. I have two newbie questions:

1. Where is the Latest News thread is displayed from?
2. Since I converted my forum from phpbb which does not have "refer" information but there are people who referred in the past, is there any way for me as admin to update somewhere to get the person show on the Top Refers?

bryanb 07-11-2007 06:11 AM

Fantastic mod :up: but I'm having one minor problem. I hope you can help.

I have the "Top Thread Starters" enabled, but it is showing nothing - it's blank. I read through this thread and someone seemed to have had the same problem - he was told to ensure that the "Hourly Clean-up" was enabled in the forum scheduled tasks. Mine is. And at every hour it runs - and since I enabled "Top thread Starters" I receive this vBulletin database error:

Quote:

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
Error Number : 1064
I am database stupid. Is there an easy fix to this? Please help. Thanks!

Valter 07-11-2007 09:56 PM

"Top Thread Starters" requires MySQL version 4.0.4 or higher to work.

bryanb 07-12-2007 07:12 PM

Quote:

Originally Posted by Cybernetec (Post 1288680)
"Top Thread Starters" requires MySQL version 4.0.4 or higher to work.

Eh, I'm on 4.0.27.

Figures :(

bryanb 07-12-2007 08:05 PM

Just scheduled an upgrade to Mysql 5.0 for Monday :up:

Shazz 07-13-2007 02:27 AM

Quote:

Originally Posted by bryanb (Post 1289426)
Just scheduled an upgrade to Mysql 5.0 for Monday :up:

uggh, thats risky

fox3nova 07-13-2007 03:26 AM

I still cant use this mod in my CMPS 3.0 !!
Anyone can help me?

majorj0nny 07-13-2007 11:06 AM

Quote:

Originally Posted by fox3nova (Post 1289695)
I still cant use this mod in my CMPS 3.0 !!
Anyone can help me?

Ive just got mine working ...

be sure to add

adv_index

to the additional locations, rather than

adv_portal

I think the portal one was inncorectly mentioned somewhere in this thread that I first used.

then I added the $ thingie to the relevant point in the adv_portal template from styles manager.

I put mine just above the footer.

I had problems with my Vbadvanced homepage not linking properly for this hacks links... missing off the /forum/ part of the correct URL... this is a problem Id had before with VBA and to ix this I just went through the relevant templates in style manager for this hack and added the full URL to the start of anything using href:

hope this helps.

majorj0nny 07-13-2007 11:17 AM

ps - http://www.50klicks.com

fox3nova 07-13-2007 11:27 AM

The contents of adv_index is blank or just $cybtopstats ?


All times are GMT. The time now is 11:58 AM.

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.02419 seconds
  • Memory Usage 1,745KB
  • 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_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (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