Erro job cspoints por tempo Online
Galera to tentando usar essa job para ganha CSPoints por tempo online....
Código PHP:
DECLARE @ConnectStat tinyint
DECLARE @memb___id varchar (10)
DECLARE @Vip int
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat= '1'
SELECT @memb___id=memb___id,@Vip = Vip FROM memb_info WHERE Vip= '0'
update memb_info set CSPoints = CSPoints + 1 where memb___id=@memb___id
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat= '1'
SELECT @memb___id=memb___id,@Vip = Vip FROM memb_info WHERE Vip= '1'
update memb_info set CSPoints = CSPoints + 2 where memb___id=@memb___id
SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat= '1'
SELECT @memb___id=memb___id,@Vip = Vip FROM memb_info WHERE Vip = '2'
update memb_info set CSPoints = CSPoints + 3 where memb___id=@memb___id
Ganha certinho o CSPoints mais não salva na DB, depois que reloga o char volta pra 0 alguém pode me ajudar?