[ 1310 ] 17xx Maradonda Dogma

tarafından **Hello EMO** Paz Kas. 15, 2009 4:23 am

Kod:: CREATE PROCEDURE [dbo].[LOAD_USER_DATA] @AccountID char(21), @id char(21), @nRet smallint OUTPUT AS -- inserted by samma 2003.07.10 DECLARE @PosX int, @PosY int, @PosZ int, @Zone tinyint, @charid1 char(21), @charid2 char(21), @charid3 char(21), @exp1 int, @exp2 int, @exp3 int, @char1 varchar(21), @char2 varchar(21), @char3 varchar(21), @Level tinyint BEGIN SET @nRet = 0 SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @id NOT IN(@charid1, @charid2, @charid3) BEGIN RETURN END --17xx Moradon SELECT @Zone = Zone, @PosX = pz, @PosY = py, @PosZ = pz FROM USERDATA WHERE strUserId = @id IF @Zone = 21 BEGIN SET @PosX = 81700 SET @PosY = 0 SET @PosZ = 43200 END --Oto Master --UPDATE USERDATA SET Class = Class + 1 WHERE strUserId = @id AND Level > 59 AND Class IN(105, 107, 109, 111, 205, 207, 209, 211) --Oto Moradon 61,62,71,72 UPDATE USERDATA SET Zone = 21 WHERE Zone IN(61, 62, 71, 72) AND strUserId = @id 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 GO

load_user_data procducerine ekle

tarafından **Hello EMO** Ptsi Kas. 23, 2009 7:57 am

normaliii

Kod:: CREATE PROCEDURE [dbo].[LOAD_USER_DATA] @AccountID char(21), @id char(21), @nRet smallint OUTPUT AS -- inserted by samma 2003.07.10 DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21), @exp1 int, @exp2 int, @exp3 int, @char1 varchar(21), @char2 varchar(21), @char3 varchar(21), @Level tinyint BEGIN SET @nRet = 0 SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @id NOT IN(@charid1, @charid2, @charid3) BEGIN RETURN 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, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly FROM USERDATA WHERE strUserId = @id SET @nRet = @@RowCount END GO

tarafından **Hello EMO** Çarş. Kas. 25, 2009 10:15 am

Kod:: CREATE PROCEDURE [dbo].[LOAD_USER_DATA] @AccountID char(21), @Id char(21), @nRet smallInt OUTPUT AS -- Inserted by samma 2003.07.10 DECLARE @PosX Int, @PosY Int, @PosZ Int, @Zone tInyInt, @charId1 char(21), @charId2 char(21), @charId3 char(21), @exp1 Int, @exp2 Int, @exp3 Int, @char1 varchar(21), @char2 varchar(21), @char3 varchar(21), @Level tInyInt BEGIN SET @nRet = 0 SELECT @charId1 = strCharID1, @charId2 = strCharID2, @charId3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID IF @Id NOT IN(@charId1, @charId2, @charId3) BEGIN RETURN END --17xx Moradon SELECT @Zone = Zone, @PosX = pz, @PosY = py, @PosZ = pz FROM USERDATA WHERE strUserId = @Id IF @Zone = 21 BEGIN SET @PosX = 81700 SET @PosY = 0 SET @PosZ = 43200 END --Oto Master --UPDATE USERDATA SET Class = Class + 1 WHERE strUserId = @Id AND Level > 59 AND Class IN(105, 107, 109, 111, 205, 207, 209, 211) --Oto Moradon 61,62,71,72 UPDATE USERDATA SET Zone = 21 WHERE Zone IN(61, 62, 71, 72) AND strUserId = @Id 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 GO

Geri: [ 1310 ] 17xx Maradonda Dogma