![[Paylaşım] 1351 & 1453 Max 70 Level Procedure 11799266115352909643](https://2img.net/h/hizliupload.com/img/11799266115352909643.png)
Anasayfa
Latest images
![[ - KoPvP-City / Site Sahibi - ]](https://2img.net/h/www.hizliupload.com/img/73208841549281992712.png "[ - KoPvP-City / Site Sahibi - ]")
![[Paylaşım] 1351 & 1453 Max 70 Level Procedure 41886997910176512190](https://2img.net/h/www.hizliupload.com/img/41886997910176512190.png)
![[Paylaşım] 1351 & 1453 Max 70 Level Procedure 39916603645653072848](https://2img.net/h/www.hizliupload.com/img/39916603645653072848.png)
![[Paylaşım] 1351 & 1453 Max 70 Level Procedure Empty](https://2img.net/i/empty.gif)
tarafından Bugün Size sağlam bi 1453 prosedürü buldum ![[Paylaşım] 1351 & 1453 Max 70 Level Procedure Smile](https://2img.net/h/www.pvp-kenti.com/images/smilies/smile.png)
Kendim yapmadım Çin forumlarında gezerken buldum
Paylaşımlara devam google user ;
Kendim yapmadım Çin forumlarında gezerken buldum Paylaşımlara devam google user ;
- Kod:
USE [KN_online]
GO
/****** Object: StoredProcedure [dbo].[EXPFIX] Script Date: 09/18/2008 09:44:26 - Created By Zenocide ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[EXPFIX]
@AccountID varchar(21)
AS
DECLARE @char1 varchar(21), @char2 varchar(21), @char3 varchar(21), @exp1 int, @exp2 int, @exp3 int, @Level1 tinyint, @Level2 tinyint, @Level3 tinyint
select @char1 = strcharid1 from account_char where straccountid = @accountid
select @char2 = strcharid2 from account_char where straccountid = @accountid
select @char3 = strcharid3 from account_char where straccountid = @accountid
select @exp1 = exp from userdata where struserid = @char1
select @exp2 = exp from userdata where struserid = @char2
select @exp3 = exp from userdata where struserid = @char3
select @level1 = [Level] from USERDATA where struserid = @char1
select @level2 = [Level] from USERDATA where struserid = @char2
select @level3 = [Level] from USERDATA where struserid = @char3
if @level1 = 70
if @exp1 > 1
begin
update userdata set Exp = 1 where struserid = @char1
update userdata set [Level] = 70 where struserid = @char1
end
if @level2 = 70
if @exp2 > 1
begin
update userdata set Exp = 1 where struserid = @char2
update userdata set [Level] = 70 where struserid = @char2
end
if @level3 = 70
if @exp3 > 1
begin
update userdata set Exp = 1 where struserid = @char3
update userdata set [Level] = 70 where struserid = @char3
end
if @level1 = 71
if @exp1 > 1
begin
Update userdata set level = 70, strskill = 'z' , dex = 5, strong = 5, sta = 5, cha = 5, intel = 5 where struserid = @char1
update userdata set Exp = 1 where struserid = @char1
end
if @level2 = 71
if @exp2 > 1
begin
Update userdata set level = 70, strskill = 'z' , dex = 5, strong = 5, sta = 5, cha = 5, intel = 5 where struserid = @char2
update userdata set Exp = 1 where struserid = @char2
end
if @level3 = 71
if @exp3 > 1
begin
Update userdata set level = 70, strskill = 'z' , dex = 5, strong = 5, sta = 5, cha = 5, intel = 5 where struserid = @char3
update userdata set Exp = 1 where struserid = @char3
end