Anasayfa
Giriş yap
Mesaj Sayısı
tarafından Merhabalar..
USER_DATA 'da scaldimi adında Column Olusturuyoruz. int 4 Olacak...
Bu Kodu LOAD_USER_DATA Prosedüründe
USER_DATA 'da scaldimi adında Column Olusturuyoruz. int 4 Olacak...
- Kod:
select @account = strAccountID from account_char where strCharID1 = @id or strCharID2 = @id or strCharID3 = @id
select @premium = count(strAccountID) from premium_service where strAccountID = @account
select @scdenetim = scaldimi from USERDATA where strUserID = @id
if @scdenetim = '0' and @premium > 0
begin
update itemler set dwid = '800013000' where dwid = '0' and sira > 13 and sira <43 and strUserId = @id
update itemler set dwid = '800010000' where dwid = '0' and sira > 13 and sira <43 and strUserId = @id
end
declare @itemvarmi int
select @itemvarmi = count(StrUserID) from itemler where StrUserID = @id
if @itemvarmi > 1
begin
exec itemleri_encode @id
end
Bu Kodu LOAD_USER_DATA Prosedüründe
- Kod:
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
