vb.org Archive - help finish this code

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

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - help finish this code (https://vborg.vbsupport.ru/showthread.php?t=33451)

squawell

12-24-2001 01:31 AM

i use this code in member.php but it can't work ~

is it something wrong??

PHP Code:


		
			
//top views user

$fileviews=$DB_site->query_first('SELECT count(*) AS profileviews FROM user');

$totalprofileviews=$fileviews['profileviews']

$ppfileviews=$DB_site->query_first("SELECT count(*) AS profileviews FROM user WHERE postuserid='$userinfo[userid]'");

$userproviews=$ppfileviews['profileviews']

$totalpercentviews = round(($userproviews / $totalprofileviews) * 100,2);

//end top views user

squawell

12-25-2001 07:00 AM

any idea??

Admin

12-27-2001 06:13 AM

Code:

//top views user

$fileviews=$DB_site->query_first('SELECT [high]SUM[/high]([high]profileviews[/high]) AS profileviews FROM user');

$totalprofileviews=$fileviews['profileviews']

$ppfileviews=$DB_site->query_first("SELECT [high]SUM[/high]([high]profileviews[/high]) AS profileviews FROM user WHERE [high]userid[/high]='$userinfo[userid]'");

$userproviews=$ppfileviews['profileviews']

$totalpercentviews = round(($userproviews / $totalprofileviews) * 100,2);

//end top views user

squawell

12-27-2001 07:08 AM

FireFly thank ur help!!

but it still cann't work!!

it show up this message:Parse error

i put that code above this code,is it right??

PHP Code:


		
			
$jointime = (time() - $userinfo[joindate]) / 86400; // Days Joined

Admin

12-27-2001 07:11 AM

Ah yes, you are missing a ; after these two:

Code:

$totalprofileviews=$fileviews['profileviews']

sorry, didn't check for these errors.

squawell

12-27-2001 07:14 AM

oh~~~~:D

i see!!

thankz ur help FireFly!! i think it will be work now~~~

All times are GMT. The time now is 02:31 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00978 seconds Memory Usage 1,721KB 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_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: