3 Mayıs 2009 Pazar

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 ...

Hiç yorum yok: