عاوز اعرف الكويري دي بتاع ايه ؟؟
 

السلام عليكم بعد اذنكم عاوز اعرف الكويري دي بتاع ايه ؟؟؟

USE [SRO_VT_LEGENDKNIGHT]
GO
/****** Object: StoredProcedure [dbo].[_GMMaker] Script Date: 8/9/2021 4:21:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* Maxing shit and skills for gms or test chars*/

ALTER PROCEDURE [dbo].[_GMMaker]
@charname varchar(64)

as

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





begin
update SRO_VT_SHARD.dbo._CharSkillMastery
set level = '100' where CharID=@charID
end


begin

update SRO_VT_SHARD.dbo._Char
set Strength = 30000, Intellect = 30000, MaxLevel =100, CurLevel = 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'
Where CharID = @CharID


end

رد: عاوز اعرف الكويري دي بتاع ايه ؟؟
 

بيعدل lvl وبيفتح skills وبيدي items وجولد

رد: عاوز اعرف الكويري دي بتاع ايه ؟؟
 

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'

رد: عاوز اعرف الكويري دي بتاع ايه ؟؟
 

شكرا يامحترم

رد: عاوز اعرف الكويري دي بتاع ايه ؟؟
 

تسلم ياصاحبي