//Onlinehours
$wcoins['table']= "mucashshop";
$wcoins['count']= "credits";
$wcoins['login']= "memb_guid";

$credits['table']= "memb_credits";
$credits['count']= "credits";
$credits['login']= "memb___id";

$onlinehours['type']= "1";//1 = credits , 2 = zen , 3 = wcoins
$onlinehours['amount']= "100";

//Onlinehours end

echo "<a href='?op=user&u=oh'><b>Online Hours</b></a><br>";

Create PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
as
begin
set nocount on
declare @find_id varchar(10)
declare @connectstat tinyint
set @connectstat = 0
set @find_id = 'not'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id=I.memb___id
where I.memb___id = @memb___id
if(@find_id<>'not')
begin
update MEMB_STAT set ConnectStat = @ConnectStat,DisConnectTM=getdate(),OnlineHours=OnlineHours+(DATEDIFF(mi,ConnectTM,getdate()))
where memb___id=@memb___id
end
end
GO

alter table memb_stat add OnlineHours int not null default 0