Konu Yazar
orhankral
Gavşo
- Tem
- 224
- 2
1310 db ler için usko maradon SMD,Ajuard,prodüce
RapidShare: 1-CLICK Web hosting - Easy Filehosting
[ Rar Pass : orhankral ]
Q Analyzr Kodu
RapidShare: 1-CLICK Web hosting - Easy Filehosting
[ Rar Pass : orhankral ]
Q Analyzr Kodu
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
