
Originally Posted by
gigok
TODO:
1. Kamu cobain yang ini dulu :
=================================================
CREATE proc ProcUpdateUserLevel
@UID int,
@game_level smallint,
@game_point smallint
as
update PangYa_User_Statistics set game_level= @game_level, game_point = @game_point*3
where UID = @UID
GO
2. Kalo kurang puasss...cobain yang ini dh
================================================
goto ProcUpdateUserStatic and edit
game_point = @game_point * x,
but i use
game_point = @game_point + 1 * 1000,
3. Kalo dah puas boleh tambah lagi dah...
===============================================
CREATE proc ProcUpdateUserLevel
@UID int,
@game_level smallint,
@game_point smallint
as
declare @mul smallint SET @mul='3'
update PangYa_User_Statistics set game_level= @game_level, game_point = @game_point*@mul
where UID = @UID
GO
================================================
Itu dulu deh..ntar klo ada yang buat naekin pangrate,gw hubungi lo ya......c yaw
SIMPLE PLAN INDONESIA