vb.org Archive - DC Activity Statistics

Page 2 of 4

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)

- - DC Activity Statistics (https://vborg.vbsupport.ru/showthread.php?t=93857)

Dean C

08-08-2005 04:31 PM

Fixed lol. My bad.

Boofo

08-08-2005 04:33 PM

Well, I got the new file, but I got another present with it. It must be my birthday. ;)

Quote:

Database error in vBulletin 3.5.0 Release Candidate 1:
Invalid SQL:
SELECT COUNT(p.postid) AS total
,p.userid
,u.username
,u.joindate
FROM
post AS p
LEFT JOIN
user as u
ON
u.userid = p.userid
WHERE
p.dateline > 1122854400
AND
p.dateline < 1125446400
ORDER BY
total DESC
GROUP BY
userid
LIMIT
10;
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
userid
LIMIT
10' at line 17
Error Number : 1064
Date : Monday, August 8th 2005 @ 05:32:22 PM
Script : http://www.bearfacts2.com/boards/activity.php?$session[sessionurl]
Referrer :
IP Address :
Username : Boofo
Classname : vb_database

Dean C

08-08-2005 04:49 PM

Ok *crosses fingers* try again ;)

Boofo

08-08-2005 04:57 PM

Dean, Dean, Dean, what are we gonna do with you? Once again ...

It works! Great save! ;)

Want a new pic?

Boofo

08-08-2005 04:59 PM

Here you go, sir. ;)

Dean C

08-08-2005 05:04 PM

Fabolous :D Thanks for helping test Bob.

Boofo

08-08-2005 05:07 PM

Since I have to have you link in the footer of this hack, do I get my name in the credits? ;)

Dean C

08-08-2005 05:16 PM

Omg, who edited my first post ;)

Boofo

08-08-2005 05:17 PM

Special? Now I'm pickled tink. ;)

Boofo

08-08-2005 05:20 PM

Oh, and you might want to put the year after the month in the header for the box, especially if they can have other years in there. ;)

All times are GMT. The time now is 07:01 PM.

Page 2 of 4

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01221 seconds Memory Usage 1,730KB 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_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: