Ex.
--rallystart1hr
declare @
[Only registered and activated users can see links. Click Here To Register...]ount int
declare @
[Only registered and activated users can see links. Click Here To Register...]d int
declare @
[Only registered and activated users can see links. Click Here To Register...]point int
select @
[Only registered and activated users can see links. Click Here To Register...]ount = [play_sec]
from TCharacterLogin
where char_id = @
[Only registered and activated users can see links. Click Here To Register...]_id
select @
[Only registered and activated users can see links. Click Here To Register...]d = [char_id]
from TCharacterLogin
where play_sec >= @
[Only registered and activated users can see links. Click Here To Register...]ount
if @
[Only registered and activated users can see links. Click Here To Register...]ount >= 3600)
begin
INSERT INTO dbo.TEventItem (type, attr, stack, rank, equip_level, equip_dexterity, equip_intelligence, equip_strength, char_id) VALUES (4391040, 0x1A02001B01001901002501001701000D0100070100, 1, 0, 0, 0, 0, 0, @
[Only registered and activated users can see links. Click Here To Register...]d)
update RohanGame.dbo.TCharacterLogin set play_sec = play_sec - 3600 where char_id = @
[Only registered and activated users can see links. Click Here To Register...]d
end
--rallyend1hr