vb.org Archive
Page 3 of 3 12 3
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Most Active User Hack (https://vborg.vbsupport.ru/showthread.php?t=71806)

MauriceReed 02-10-2005 05:32 PM
just installed this one mate, but as a total n00b, how do i create the 2 .php files??

monthly.php and weekly.php??

any help would be appreciated.
btw..install went fine....all SQL queries went ok, and displays on forum index fine......just with 2 blank columns tho, due to the 2 .php files not being installed.;)

MauriceReed 02-11-2005 05:12 PM
anyone??

shabbirbhimani 02-22-2005 06:15 AM
Quote:
Originally Posted by MauriceReed
just installed this one mate, but as a total n00b, how do i create the 2 .php files??

monthly.php and weekly.php??

any help would be appreciated.
btw..install went fine....all SQL queries went ok, and displays on forum index fine......just with 2 blank columns tho, due to the 2 .php files not being installed.;)
Sorry but I was outstation.

The 2 php files can be created in any Editor like Notepad or VI.

Thanks
Shabbir Bhimani

taffy056 03-10-2005 10:30 PM
Hi,

I was getting the same error message as post number 14, but after I put the query in the following post I get this error on the forumhome, can you suggest a fix to this.

Thanks


PHP Code:
Database error in vBulletin 3.0.7:
Invalid SQL: SELECT userid, username, count(username) as posts FROM post as post where dateline >  group by username ORDER BY posts DESC
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 'group by username ORDER BY posts DESC' at line 1

mysql error number: 1064 

shabbirbhimani 03-11-2005 02:27 AM
Quote:
Originally Posted by taffy056
Hi,

I was getting the same error message as post number 14, but after I put the query in the following post I get this error on the forumhome, can you suggest a fix to this.

Thanks


PHP Code:
Database error in vBulletin 3.0.7:
Invalid SQL: SELECT userid, username, count(username) as posts FROM post as post where dateline >  group by username ORDER BY posts DESC
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 'group by username ORDER BY posts DESC' at line 1

mysql error number: 1064 
possible reason for your error can be the prefix that you have given when installing the vB. Use that prefix in all the tables but here in post table you are not prefixing it. I hope this should solve the problem but if not you can post again.

Also if you want much faster response you can use my site also.. url in sig.

Startinfresh 03-20-2005 02:07 AM
Got a question :)

Is there any way that you can make it so that only Admin and Super Mods can view this?

Another question, timestamp table has me stumped. Anyone care to help out ;)

Startinfresh 03-20-2005 02:08 AM
is timestamp table the same as a template???

Startinfresh 03-20-2005 02:29 AM
Ok, I got the timestamp table ;)

JagFan 04-15-2005 09:55 PM
Installed. Thanks!


All times are GMT. The time now is 05:51 PM.
Page 3 of 3 12 3
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.02243 seconds
  • Memory Usage 1,741KB
  • 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
  • (2)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
  • (9)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