CREATE PROCEDURE [dbo].[LOAD_USER_DATA]
@AccountID char(21),
@strUserId 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 @strUserID = @charid1 or @strUserID = @charid2 or @strUserID = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END
DECLARE @oda int
DECLARE @odabdw int
DECLARE @zone int
select @zone=zone from USERDATA where strUserId=@strUserId
select @odabdw=count(*) from BRATE_BDWZ where status=6 and zoneNo=@zone
if @odabdw=0 begin
select @odabdw=count(*) from BRATE_JRZ where status=6 and zoneNo=@zone
end
if @zone in(3,4,5,6,7,8,9,10,13,14,15,16,225,226,227,228,229,230,231,232,233,234,235,236,245,246,247,248,249,250,251,252,253,254,255) and @odabdw=0 begin
update USERDATA set zone=21 where strUserId=@strUserId
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 = @strUserID
-- # Automatic Today Loyalty Restarter Stat # --
DECLARE @HourForLT tinyint
DECLARE @MinuteForLT tinyint
SET @HourForLT = DATEPART(HOUR,GETDATE())
SET @MinuteForLT = DATEPART(MINUTE,GETDATE())
IF (@HourForLT = 0) AND (@MinuteForLT = 0)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 0) AND (@MinuteForLT = 5)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 0) AND (@MinuteForLT = 10)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 0)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 5)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
ELSE IF (@HourForLT = 12) AND (@MinuteForLT = 10)
BEGIN
UPDATE USERDATA SET Loyaltytoday = 0 WHERE Loyaltytoday != 0
END
-- # Today Ladder Rank Start # --
UPDATE USERDATA SET LoyaltyTodayNow = LoyaltyMonthly FROM USERDATA WHERE strUserId = @strUserId
UPDATE USERDATA SET LoyaltyToday = 0 FROM USERDATA WHERE strUserId = @strUserId
-- # Today Ladder Rank End # --
-- # Automatic Today Loyalty Restarter End # --
insert into _MESAJSISTEMI values('+pm 13 %s Önemli:Bdw Kayit npcsi kaldirildi.Artik Chatten kayit olucaksiniz.',@strUserId,0)
insert into _MESAJSISTEMI values('+pm 7 %s 1vs1 isteği yollamak için .vs Nick Bahis yazınız. Max Bahis: 100 NP',@strUserId,0)
insert into _MESAJSISTEMI values('+pm 7 %s Şikayet ve isteklerinizi Forumdan Yapin! Forum.HomekoTR.NET ! ',@strUserId,0)
insert into _MESAJSISTEMI values('+pm 7 %s BDW Kayıt: ".bdwkayit" JR Kayıt: ".jrkayit" (Chatten yazacağınız metin)',@strUserId,0)
SET @nRet = @@RowCount
GOCREATE PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT
AS
EXEC UMG_COIN_RECOVERY @id
-- # Humanlar İçin # --
update USERDATA set Zone = '2', PX = '159609', PZ = '42089', PY= '1569' where StrUserID = @id and Zone = '156' and Nation = '2'
-- # Karuslar İçin
update USERDATA set Zone = '1', PX = '44600', PZ = '163100', PY = '1240' where StrUserID = @id and Zone = '156' and Nation = '1'
declare @charId varchar(21),
@fame2 Int,
@kayIt2 Int,
@devreden varchar(21),
@alan varchar(21)
select @alan = alan from clandevret where alan = @id or devreden = @id
select @devreden = devreden from clandevret where alan = @id or devreden = @id
select @fame2 = vIcefame from clandevret where devreden = @id
select @charId = strcharId1 from account_char where straccountId = @accountId
select @kayIt2 = kayIt from clandevret where devreden = @id or alan = @id
If @kayIt2 = 0
begIn
update userdata set fame = @fame2 where struserId = @devreden
update userdata set fame = 1 where struserId = @alan
update clandevret set kayIt = 1 where devreden = @id or alan = @id
update knights set chief = @alan where chief = @devreden
update knights set vicechief_1 = @devreden where vicechief_1 = @alan
update knights set vicechief_2 = @devreden where vicechief_2 = @alan
update knights set vicechief_3 = @devreden where vicechief_3 = @alan
end
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
DECLARE @dupeyakala varchar(21)
select @dupeyakala = count(Userid) FROM gokhan WHERE Userid = @id
if @dupeyakala > 0
begin
Set @nRet = 0
end
exec rundupecheck @id
-- KoMaster--
DECLARE @Health int,
@Exp int
select @Health = Hp, @Exp = Exp from USERDATA where strUserId = @id
if (@Health < 1 and @Exp < 0)
BEGIN
update USERDATA set Hp = '1', Exp = '1', strSkill = '<<<<<<<<<<' WHERE strUserId = @id
END
DECLARE @itemaldimi int
select @itemaldimi = [level] FROM USERDATA WHERE StrUserID = @id
if @itemaldimi = '1'
begin
exec baslangicitem @id
update userdata set [level] = '1' where strUserID = @id
end
UPDATE USERDATA set Authority = 255 where Class in(106,108,110,112,206,208,210,212) and Level < 58 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, 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
GOload_user_data toplosu yok ben göremedim
