[Help] Record Online Script

[BlackEye]

Hi all! Can someone release here RECORD ONLINE SCRIPT for WEB!?

[MentaL]

[vaiben]

yep,wud be nice

[DarkFuture]

Use SQL soted procedures, use WZ_ConnectMember or smth for must online counting, allways when someone is joining server, procedure check how many people is online and then if it`s higher as last record, update it

[BlackEye]

I know,but can someone release script or php?

[DarkFuture]

You can`t create SQL script?
That`s not hard or You don`t known SQL language?

EDIT:

CREATE PROCEDURE WZ_CONNECT_MEMB
@memb___id varchar(10),
@ServerName  varchar(50),
@IP varchar(20)    
 AS
Begin    
set nocount on
    Declare  @find_id varchar(10)    
    Declare  @ConnectStat tinyint
    Set @find_id = 'NOT'
    Set @ConnectStat = 1

    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        
        insert into MEMB_STAT (memb___id,ConnectStat,ServerName,IP,ConnectTM)
        values(@memb___id,  @ConnectStat, @ServerName, @IP, getdate())
    end
    else        
        update MEMB_STAT set ConnectStat = @ConnectStat,
                     ServerName = @ServerName,IP = @IP,
                     ConnectTM = getdate()
            where memb___id = @memb___id
    end
--Record script start
Declare @online_record int
Declare @max_online_record int
Select count(*) From MEMB_STAT as @online_record Where ConnectStat = '1'
Select MaxOnlineRecord From RecordTable as @max_online_record
if (@max_online_record < @online_record)
begin
Update RecordTable
Set MaxOnlineRecord = @online_record
end
--Record script end
GO 

5min work
now only check syntax and create table for Record data :P
Credits: me

[BlackEye]

Thanks! :D
P.S:
Vienkarsi slinkums nemties :)

[DarkFuture]

As You say :P

[BlackEye]

Heh! Don't work! Can't create procedure! :D

[DarkFuture]

...
now only check syntax and create table for Record data :P
....

That`s not 100% worked (melnraksts)
Later I create and check script