OnlineTime Problems No Work ?

[Masteru]

I just buy this Full Premium KlubZone Web OpenMu:my version is 97d+99i

this is my website and this is the modules:Website OnlineTime

this is the script i use for this modules to work:what i need to fixed to work correct ?

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 COLLATE DATABASE_DEFAULT
where I.memb___id = @memb___id
if( @Find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), TotalTime = TotalTime+(DATEDIFF(mi,ConnectTM,getdate()))
where memb___id = @memb___id
-- TIMEONLINE MOD by Speedy
end
end

GO

when i try to use this script for this modules to work show me this problems:

[MentaL]

[I Am NoLimiT]

I think you doesn't have TotalTime column on your MEMB_STAT, that's why you encountered that error.

[Masteru]

I think you doesn't have TotalTime column on your MEMB_STAT, that's why you encountered that error.

thanks for help and info add plss tutorial how to add this totaltime and to work correct

[I Am NoLimiT]

ADD A NEW COLUMN in MEMB_STAT TABLE
-----
COLUMN NAME: TotalTime
TYPE: int
NOT NULL
DEFAULT 0

[Masteru]

ADD A NEW COLUMN in MEMB_STAT TABLE
-----
COLUMN NAME: TotalTime
TYPE: int
NOT NULL
DEFAULT 0

thanks again for help yes i fixed and work now i ask the original creator of this muweb to help

[I Am NoLimiT]

Your welcome, Im glad that I helped you even a bit ;)