Transform online hours in cash shop points

can we just go through to the some servers and get the console HTML, and make it as PHP or somewhat language to reconfigure?

i don't know if it is recommend or right to do but, it that possible to translate F12 CONSOLE into codes etc, demo testing like DREAM_WEAVER or JSQuery? etc? just asking mates. thank you

Hey mate its a great job, but as I can change the points for zen?

please help me :D

Code:

---

CREATE PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]
@memb___id varchar(10)
 AS
Begin   
set nocount on
    Declare  @Find_id varchar(10)   
    Declare @Connectstat tinyint
        declare @OnLineHours real
        declare @cspoints int
    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       
        SELECT @cspoints= CSPoints FROM MEMB_INFO where memb___id = @memb___id
        update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = @cspoints/10+(DATEDIFF(hh,ConnectTM,getdate()))
        where memb___id = @memb___id
        SELECT  @OnLineHours =OnlineHours FROM MEMB_STAT WHERE memb___id = @memb___id


UPDATE [dbo].[MEMB_INFO]
SET CSPoints= CSPoints +  @OnLineHours * 10)
WHERE memb___id = @memb___id

end
end
GO

---

is this code correct for 10 CSPoints/h, i have the CSPoints in MEMB_INFO
===========================

Code:

---

SELECT @cspoints= CSPoints FROM MEMB_INFO where memb___id = @memb___id
        update MEMB_STAT set ConnectStat = @Connectstat, DisConnectTM = getdate(), OnlineHours = @cspoints/10+(DATEDIFF(hh,ConnectTM,getdate()))

---

isnt this gives accounts credits/10+online hours? so i have 5k cspoints and i will get for 1h 5000/10+1? lel?

how to config for 5 CSPoints/h?
=================
and can someone give a sql script for "OnlineHours" cuz i create if but i cannot unbind the "allow nulls"
i use SQL 2000

Column_name: OnlineHours, MEMB_STAT
Type: int
Allow Nulls: unchecked <-i cant uncheck it, says MEMB_STAT doesnt allow nulls
Default value: 0 <- done have this ??