vb.org Archive - Forum Statistics in FORUMDISPLAY

Page 2 of 5

Last »

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)

- - Forum Statistics in FORUMDISPLAY (https://vborg.vbsupport.ru/showthread.php?t=60075)

Gio Takahashi

01-11-2004 06:59 PM

har har.

Oh. the "Total Views" seems to be the total views of the last thread created. Isn't it supposed to be the total views in this forum?

VBDev

01-11-2004 07:07 PM

Quote:

Originally Posted by Gio Takahashi

har har.

Oh. the "Total Views" seems to be the total views of the last thread created. Isn't it supposed to be the total views in this forum?

I had this problem in one forum when I did it, in other forums, it seems to work correctly

I think I had an idea, I'll take a look and try to repair it ;)

VBDev

01-11-2004 07:35 PM

@Gio : modify in the forumdisplay.php :

Code:

$sujets=$DB_site->query_first("SELECT postusername, SUM(views) AS vues FROM  " . TABLE_PREFIX . "thread WHERE forumid=$forumid GROUP BY postusername ORDER BY dateline DESC");

with

Code:

$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues

FROM " . TABLE_PREFIX . "thread

WHERE forumid =2

GROUP BY forumid

ORDER BY dateline DESC");

I'll update my archive

sypher_again

01-11-2004 07:47 PM

Super taff les mecs ;) vive vbdev vous allez tout dechirer j'en suis sur ^^ / very good taff

MGM	01-11-2004 08:23 PM

sweet..... i added this to my vB2 board, I'll be sure to use this on vB3

/me clicks Install

MGM out

eXtremeTim

01-11-2004 08:31 PM

Quote:

Originally Posted by VBDev

@Gio : modify in the forumdisplay.php :

Code:

$sujets=$DB_site->query_first("SELECT postusername, SUM(views) AS vues FROM  " . TABLE_PREFIX . "thread WHERE forumid=$forumid GROUP BY postusername ORDER BY dateline DESC");

with

Code:

$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues

FROM " . TABLE_PREFIX . "thread

WHERE forumid =2

GROUP BY forumid

ORDER BY dateline DESC");

I'll update my archive

One problem all the forums would show the thread views amount for forum id number 2 in that new sql query you posted above.

nuke	01-11-2004 09:21 PM

Hmm Sorry Error

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /var/www/web2/html/vb/forumdisplay.php on line 823

vB RC 2???

g-force2k2

01-12-2004 04:46 AM

Quote:

Originally Posted by eXtremeTim

One problem all the forums would show the thread views amount for forum id number 2 in that new sql query you posted above.

If you updated the sql query you will get this error. Just change the code from his recent fix:

PHP Code:


		
			
WHERE forumid =2

to:

PHP Code:


		
			
WHERE forumid = $forumid

Regards,
g-force2k2

VBDev

01-12-2004 04:51 AM

The zip was updated

Thx for the report of bugs :)

Vb-Hispano

01-12-2004 07:14 AM

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/httpd/vhosts/juegos21.org/httpdocs/foros/forumdisplay.php on line 812

is error ???

All times are GMT. The time now is 05:47 AM.

Page 2 of 5

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01151 seconds Memory Usage 1,739KB 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_code_printable (2)bbcode_php_printable (3)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: