Jump to content
  • 0

Editing this Script?


Question

Posted

how can i add a sql log here so i can see the total online time of all playerS?

this code is from BrianL :D


poring_c01,100,100,0	script	TotalTimeOnline	910,{
mes "For your account, you have been online a total of:";
mes callsub(S_SecToTime, @login_time ? (#secs_online + (gettimetick(2)-@login_time)) : #secs_online);
close;

S_SecToTime:
set .@seconds, getarg(0);

set .@seconds, .@seconds - set(.@weeks, .@seconds / 604800)*604800;
set .@str$, .@str$ + .@weeks+((.@weeks==1) ? " week":" weeks")+", ";

set .@seconds, .@seconds - set(.@days, .@seconds / 86400)*86400;
set .@str$, .@str$ +  .@days+((.@days==1) ? " day":" days")+", ";

set .@seconds, .@seconds - set(.@hours, .@seconds / 3600)*3600;
set .@str$, .@str$ +  .@hours+((.@hours==1) ? " hour":" hours")+", ";

set .@seconds, .@seconds - set(.@mins, .@seconds / 60)*60;
set .@str$, .@str$ +  .@mins+((.@mins==1) ? " min":" mins")+", and ";

set .@str$, .@str$ +  .@seconds+((.@seconds==1) ? " second":" seconds");

return .@str$;

OnPCLoginEvent:
set @login_time, gettimetick(2);
end;
OnPCLogoutEvent:
if (@login_time)
	set #secs_online, #secs_online + (gettimetick(2)-@login_time);
end;
}

2 answers to this question

Recommended Posts

Posted

you can try this if you want....

OnWhisperGlobal:
if( query_sql("SELECT `value` FROM `global_reg_value` WHERE str='#secs_online' AND `account_id`='"+getcharid( 3,@whispervar0$ )+"'",.@Times$ ) ){
dispbottom "[ "+@whispervar0$+" Online Time : ";
dispbottom callsub(S_SecToTime,atoi( .@Times$ ));
}else{
dispbottom "Player not found / not online.";
}
end;

just put it below your script....

then pm the NPC with a player name.....

that player must be online...

  • Upvote 1

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...