Öncelikle Benim Aujardım Özel Diyenler Olabilir:
Aujardı Açın Bu Kodu Aratıp Bulun
Kod:
0042555C 75 1E JNZ SHORT 0042557C
Ve
Kod:
0042555C EB 1E JMP SHORT 0042557C
Olarak Değiştrin
Bu Daha Önce Verilmişdi Ama Uygulanması Gereken SQL Kodu Yanlışdı
SQL Kodu Hata Düzeltilmiş Halde:
Kod:
ALTER PROCEDURE [dbo].[LOAD_USER_DATA]
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
BEGIN
DECLARE @PosX int, @PosZ int, @PosY int, @Zone tinyint
SELECT @Zone = Zone, @PosX = px, @PosZ = pz, @PosY = py FROM USERDATA WHERE strUserId = @id
-- If the zone is Moradon...
IF @Zone = 21
BEGIN
-- Use old Moradon co-ordinates (* 100)
-- I'm not using the new map but you can change the co-ordinates here.
SET @PosX = 81700
SET @PosY = 0 -- If we're higher or lower (depth-wise), we set this. Otherwise, it remains 0.
SET @PosZ = 43200
END
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, @PosX, @PosZ, @PosY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
END
Yukarıdaki Kodu SQL Query Analyzera Yapıştırıp F5 E Basın
Aujardı Açın Bu Kodu Aratıp Bulun
Kod:
0042555C 75 1E JNZ SHORT 0042557C
Ve
Kod:
0042555C EB 1E JMP SHORT 0042557C
Olarak Değiştrin
Bu Daha Önce Verilmişdi Ama Uygulanması Gereken SQL Kodu Yanlışdı
SQL Kodu Hata Düzeltilmiş Halde:
Kod:
ALTER PROCEDURE [dbo].[LOAD_USER_DATA]
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
BEGIN
DECLARE @PosX int, @PosZ int, @PosY int, @Zone tinyint
SELECT @Zone = Zone, @PosX = px, @PosZ = pz, @PosY = py FROM USERDATA WHERE strUserId = @id
-- If the zone is Moradon...
IF @Zone = 21
BEGIN
-- Use old Moradon co-ordinates (* 100)
-- I'm not using the new map but you can change the co-ordinates here.
SET @PosX = 81700
SET @PosY = 0 -- If we're higher or lower (depth-wise), we set this. Otherwise, it remains 0.
SET @PosZ = 43200
END
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, @PosX, @PosZ, @PosY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly FROM USERDATA WHERE strUserId = @id
SET @nRet = @@RowCount
END
Yukarıdaki Kodu SQL Query Analyzera Yapıştırıp F5 E Basın