declare @charID INT
بيجيب رقم الشخصية الهيتعمل فيها الهيعمل فيها ايديت
set @charID = (select CharID from SRO_VT_SHARD.dbo._Char where CharName16 = @charname)
بيمسح كل اسكلات الشخصيه
begin
delete from SRO_VT_SHARD.dbo._CharSkill where CharID = @charID
end
بيضيف اسكلات الشخصية علي حسب هو مفتوح عنده اي ماستري
begin
INSERT INTO SRO_VT_SHARD.dbo._CharSkill (charid, SkillID, [enable])
select @charID, S.ID, 1
from SRO_VT_SHARD.dbo._refskill S
where (ReqCommon_MasteryLevel1<100)
AND Basic_Code LIKE '%SKILL_CH_SWORD%'
and Basic_Code not like '%GSKILL%'
OR Basic_Code LIKE '%SKILL_CH_SPEAR%'
AND Basic_Code not like '%GSKILL%'
and (ReqCommon_MasteryLevel1<100)
OR Basic_Code LIKE '%SKILL_CH_FIRE%'
AND Basic_Code not like '%GSKILL%'
and (ReqCommon_MasteryLevel1<100)
OR Basic_Code LIKE '%SKILL_CH_COLD%'
AND Basic_Code not like '%GSKILL%'
and (ReqCommon_MasteryLevel1<100)
OR Basic_Code LIKE '%SKILL_CH_WATER%'
AND Basic_Code not like '%GSKILL%'
and (ReqCommon_MasteryLevel1<100)
OR Basic_Code LIKE '%SKILL_CH_LIGHT%'
AND Basic_Code not like '%GSKILL%'
and (ReqCommon_MasteryLevel1<100)
OR Basic_Code LIKE '%SKILL_CH_BOW%'
and (ReqCommon_MasteryLevel1<100)
and Basic_Code not like '%GSKILL%'
and s.ID not between '3100' and '3108'
and s.ID not between '20469' and '29679'
order by s.ID
end
بيفتح الماستري لحد لفل 100 في الشخصية المحدده
begin
update SRO_VT_SHARD.dbo._CharSkillMastery
set level = '100' where CharID=@charID
end
بيخلي الاكونت جي ام بس ده شغال مع فلتر معين
begin
update SRO_VT_ACCOUNT.dbo.TB_User
set sec_content =12, sec_primary=12
from SRO_VT_ACCOUNT.dbo.TB_User
inner join SRO_VT_ACCOUNT.dbo.SR_ShardCharNames
on SRO_VT_ACCOUNT.dbo.SR_ShardCharNames.UserJID=SRO_V T_ACCOUNT.dbo.TB_User.JID
where SRO_VT_ACCOUNT.dbo.SR_ShardCharNames.CharName = @charname
end
بيديك شوية ايتيمز
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @Charname, ITEM_ETC_AVATAR_M_GM_UNIFORM, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_ETC_AVATAR_W_GM_UNIFORM, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_SHIELD_10_B_RARE, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_SWORD_10_B_RARE, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_BLADE_10_B_RARE, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_TBLADE_10_B_RARE, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_BOW_10_B_RARE, 0, 15
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @charname, ITEM_CH_SPEAR_10_B_RARE, 0, 15
end
begin
بيزود الجولد
update SRO_VT_SHARD.dbo._Char
set RemainGold = '99000000000' where CharID = @charID
end
begin
بيزود كلمة جي ام للاكونت
Update SRO_VT_SHARD.dbo._Char
Set CharName16 =
('[GM]' +CharName16)
Where CharID = @CharID
end
begin
بيطلعه من الجيلد لو هو في جيلد
Update SRO_VT_SHARD.dbo._Char
Set GuildID = '0'