Anasayfa
Giriş yap
Mesaj Sayısı
tarafından Bu SOrunsuz Eger Karakter Secerken Dc oluyorsanız bunun load user data proc unu bununla degiştiriniz.
- Kod:
[color=#000000][color=#0000bb]CREATE PROCEDURE [/color][color=#007700][[/color][color=#0000bb]dbo[/color][color=#007700]].[[/color][color=#0000bb]LOAD_USER_DATA[/color][color=#007700]]
@[/color][color=#0000bb]AccountID char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),
@[/color][color=#0000bb]id char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]),
@[/color][color=#0000bb]nRet smallint OUTPUT
[/color][color=#007700]AS
-- [/color][color=#0000bb]Procedure Edited By MoNaRcH
[/color][color=#007700]DECLARE @[/color][color=#0000bb]charid1 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]charid2 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]charid3 char[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]exp1 int[/color][color=#007700], @[/color][color=#0000bb]exp2 int[/color][color=#007700], @[/color][color=#0000bb]exp3 int[/color][color=#007700], @[/color][color=#0000bb]char1 varchar[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]char2 varchar[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]char3 varchar[/color][color=#007700]([/color][color=#0000bb]21[/color][color=#007700]), @[/color][color=#0000bb]Level tinyint
BEGIN
SET [/color][color=#007700]@[/color][color=#0000bb]nRet [/color][color=#007700]= [/color][color=#0000bb]0
SELECT [/color][color=#007700]@[/color][color=#0000bb]charid1 [/color][color=#007700]= [/color][color=#0000bb]strCharID1[/color][color=#007700], @[/color][color=#0000bb]charid2 [/color][color=#007700]= [/color][color=#0000bb]strCharID2[/color][color=#007700], @[/color][color=#0000bb]charid3 [/color][color=#007700]= [/color][color=#0000bb]strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID [/color][color=#007700]= @[/color][color=#0000bb]AccountID
[/color][color=#007700]IF @[/color][color=#0000bb]id NOT IN[/color][color=#007700](@[/color][color=#0000bb]charid1[/color][color=#007700], @[/color][color=#0000bb]charid2[/color][color=#007700], @[/color][color=#0000bb]charid3[/color][color=#007700])
[/color][color=#0000bb]BEGIN
[/color][color=#007700]RETURN
[/color][color=#0000bb]END
BEGIN
[/color][color=#007700]DECLARE @[/color][color=#0000bb]PosX int[/color][color=#007700], @[/color][color=#0000bb]PosZ int[/color][color=#007700], @[/color][color=#0000bb]PosY int[/color][color=#007700], @[/color][color=#0000bb]Zone tinyint
SELECT [/color][color=#007700]@[/color][color=#0000bb]Zone [/color][color=#007700]= [/color][color=#0000bb]Zone[/color][color=#007700], @[/color][color=#0000bb]PosX [/color][color=#007700]= [/color][color=#0000bb]px[/color][color=#007700], @[/color][color=#0000bb]PosZ [/color][color=#007700]= [/color][color=#0000bb]pz[/color][color=#007700], @[/color][color=#0000bb]PosY [/color][color=#007700]= [/color][color=#0000bb]py FROM USERDATA WHERE strUserId [/color][color=#007700]= @[/color][color=#0000bb]id
END
SELECT Nation[/color][color=#007700], [/color][color=#0000bb]Race[/color][color=#007700], Class, [/color][color=#0000bb]HairColor[/color][color=#007700], [/color][color=#0000bb]Rank[/color][color=#007700], [/color][color=#0000bb]Title[/color][color=#007700], [[/color][color=#0000bb]Level[/color][color=#007700]], [[/color][color=#0000bb]Exp[/color][color=#007700]], [/color][color=#0000bb]Loyalty[/color][color=#007700], [/color][color=#0000bb]Face[/color][color=#007700], [/color][color=#0000bb]City[/color][color=#007700], [/color][color=#0000bb]Knights[/color][color=#007700], [/color][color=#0000bb]Fame[/color][color=#007700], [/color][color=#0000bb]Hp[/color][color=#007700], [/color][color=#0000bb]Mp[/color][color=#007700], [/color][color=#0000bb]Sp[/color][color=#007700], [/color][color=#0000bb]Strong[/color][color=#007700], [/color][color=#0000bb]Sta[/color][color=#007700], [/color][color=#0000bb]Dex[/color][color=#007700], [/color][color=#0000bb]Intel[/color][color=#007700], [/color][color=#0000bb]Cha[/color][color=#007700], [/color][color=#0000bb]Authority[/color][color=#007700], [/color][color=#0000bb]Points[/color][color=#007700], [/color][color=#0000bb]Gold[/color][color=#007700], [[/color][color=#0000bb]Zone[/color][color=#007700]], [/color][color=#0000bb]Bind[/color][color=#007700], [/color][color=#0000bb]PX[/color][color=#007700], [/color][color=#0000bb]PZ[/color][color=#007700], [/color][color=#0000bb]PY[/color][color=#007700], [/color][color=#0000bb]dwTime[/color][color=#007700], [/color][color=#0000bb]strSkill[/color][color=#007700], [/color][color=#0000bb]strItem[/color][color=#007700],[/color][color=#0000bb]strSerial[/color][color=#007700], [/color][color=#0000bb]sQuestCount[/color][color=#007700], [/color][color=#0000bb]strQuest[/color][color=#007700], [/color][color=#0000bb]MannerPoint[/color][color=#007700], [/color][color=#0000bb]LoyaltyMonthly FROM USERDATA WHERE strUserId [/color][color=#007700]= @[/color][color=#0000bb]id
SET [/color][color=#007700]@[/color][color=#0000bb]nRet [/color][color=#007700]= @@[/color][color=#0000bb]RowCount
END
GO [/color][/color]