SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id = @charid1 or @id = @charid2 or @id = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END
-- Fixed oto master by Trayhoper
DECLARE @class char(21),@levelim int
set @class = (select class from userdata where struserid = @id)
Select @levelim = [Level] FROM USERDATA WHERE strUserID = @id
if @class = 105 AND @levelim > 59
begin
update userdata set class = 106 where struserid = @id
end
if @class = 107 AND @levelim > 59
begin
update userdata set class = 108 where struserid = @id
end
if @class = 109 AND @levelim > 59
begin
update userdata set class = 110 where struserid = @id
end
if @class = 111 AND @levelim > 59
begin
update userdata set class = 112 where struserid = @id
end
if @class = 205 AND @levelim > 59
begin
update userdata set class = 206 where struserid = @id
end
if @class = 207 AND @levelim > 59
begin
update userdata set class = 208 where struserid = @id
end
if @class = 209 AND @levelim > 59
begin
update userdata set class = 210 where struserid = @id
end
if @class = 211 AND @levelim > 59
begin
update userdata set class = 212 where struserid = @id
end
-- Thales tarafından yazılmıştır, değiştiren ve silen kendinin ne olduğunu biliyor zaten.
DECLARE @Health int,
@Exp int
select @Exp = Exp from USERDATA where strUserId = @id
if (@Exp < 0)
BEGIN
update USERDATA set Exp = '500000000' WHERE strUserId = @id
END
exec rundupecheck @id
exec RunDupeCheckInn @id
exec rundupecheck2 @id
exec statduzelt @id
update userdata set UserStatus = '0'
DECLARE @itemaldimi int
select @itemaldimi = [level] FROM USERDATA WHERE StrUserID = @id
if @itemaldimi = '1'
begin
exec baslangicitem @id
update userdata set [level] = '1' ,[strSkill] = '', [Points] = '' where strUserID = @id
end
DECLARE @zoneduzenle int
select @zoneduzenle = Zone FROM USERDATA WHERE StrUserID = @id
if @zoneduzenle = 101 or @zoneduzenle = 102
begin
update userdata set Zone = '21' where StrUserID = @id
end
--ßu Kadar :D ßy TUTATIS
update userdata set Hp = '1' where StrUserID = @id and Hp = '0'
DECLARE @dupeyakala int
select @dupeyakala = count(Userid) FROM gokhan WHERE Userid = @id
if @dupeyakala > 0
begin
exec itemleribul @id
update itemler set dwid = '0' where dwid = (select dupeitem from gokhan where Userid = @id) and StrUserID = @id
delete from gokhan where Userid = @id
exec itemleriencode @id
end
update userdata set exp = '1050000000'
update userdata set level = '59'
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
DECLARE @speedhack varchar(250)
select @speedhack = strHackToolName from HACKTOOL_USERLOG where strCharID = @id
if @speedhack='Something that resembles Speedhack has been detected on this PC. (Code = 10303)'
begin
Set @nRet = 0
end
if @id='Shlt' or @id ='DammKengKar'
BEGIN
INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END
RETURN
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
