83 ve 90 Level EbenezerLer

83 VE 90 LvL ebenezerlerini paylaşıyorum

Linkler:
83evel EBebezer İÇn TIkla

Buda 90 level Ebenezer İÇin TIkla

FAYDALANIPTA MESAJ YAZMAYAN AJDAR OLSUN

KENDİM EDİTLEDİM VE UPLOADLADIM ONDAN BUNDAN ALDIN DEMEYİN


Stat Ve Skil Point Procedurleri ''KANKATAMER VE SHELLX DEN ALINTIDIR''

BU 83 LEVELİNKİ:

Kod:

CREATE PROCEDURE tamer
@id char(100)
AS
declare @lwl char(10)
select @lwl = level from userdata where struserid = @id

if @lwl = '80'
begin
update userdata set points = points + 3 where struserid = @id and exp = '500000000'
update userdata set level = '81' where struserid = @id and exp = '500000000'
update userdata set exp = '0' where struserid = @id and exp = '500000000'
end

if @lwl = '81'
begin
update userdata set points = points + 3 where struserid = @id and exp = '500000000'
update userdata set level = '82' where struserid = @id and exp = '500000000'
update userdata set exp = '0' where struserid = @id and exp = '500000000'
end

if @lwl = '82'
begin
update userdata set points = points + 3 where struserid = @id and exp = '500000000'
update userdata set level = '83' where struserid = @id and exp = '500000000'
update userdata set exp = '0' where struserid = @id and exp = '500000000'
end
GO

Load_user_data procedurunu açın

Bunu BUlun

Kod:

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id

tam üstüne bunu yapıştırın tamamdır

Kod:

exec tamer @id

BUDA 90 LWL İN Kİ

Kod:

CREATE PROCEDURE level90
@id char(100)
AS
declare @lwl char(10)
select @lwl = level from userdata where struserid = @id

if @lwl = '80'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '81' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end

if @lwl = '81'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '82' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '82'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '83' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '83'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '84' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '84'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '85' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '85'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '86' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '86'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '87' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
---made in shellx---
if @lwl = '87'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '88' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end

if @lwl = '88'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '89' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end

if @lwl = '89'
begin
update userdata set points = points + 3  where struserid = @id and exp = '1900000000'
update userdata set level = '90' where struserid = @id and exp = '1900000000'
update userdata set exp = '0' where struserid = @id and exp = '1900000000'
end
GO

lOAD user data procedurunu açın
Bunu bulun

Kod:

SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id

tam üstüne bunu yapıştırın

Kod:

exec level90 @id

BUNLARI YAPINCA

level_up tablosunu açın 80 den 90 a kadar yada 80 den 83 kadar ki expleri editleyin




Ko-cuce den alıntıdır ...