عايز كل اللى فى الجيم يروحو جنجان
كود بلغة HTML:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
عايز تشيل الاسلحة السوس و الرسايل 150% الكويست من عند البوشن _RefCharDefault_Quest
Make 1->0
كود بلغة HTML:
1 1 3 QEV_ALL_BASIC_1 5
1 2 3 QEV_ALL_BASIC_2 8
1 3 3 QEV_ALL_BASIC_3 10
1 4 3 QEV_ALL_BASIC_4 16
1 5 3 QEV_ALL_BASIC_5 20
1 6 3 QEV_ALL_BASIC_6 24
1 7 3 QEV_ALL_BASIC_7 30
1 8 3 QEV_ALL_BASIC_8 32
1 9 3 QEV_ALL_BASIC_9 40
1 10 3 QEV_ALL_BASIC_10 42
1 11 3 QEV_ALL_BASIC_11 50
1 12 3 QEV_ALL_BASIC_12 60
1 13 3 QEV_ALL_BASIC_0 1
Reset Chines Skill
كود بلغة HTML:
SET @CharName = 'CharName' --Your Char Name
SET @GiveSP = '10000000' --Write the amount of Skill Point
SET @CharID = (SELECT CharID FROM _Char WHERE CharName16 = @CharName) --Do not change
-- edit by omarahmed500 --
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by omarahmed500 --
--- Do Not Change Here ---
--- made by omarahmed500 for S4a ---
DELETE [dbo].[_CharSkill]
WHERE [CharID] = @CharID and [SkillID] > '2' and SkillID<'40'
DELETE [dbo].[_CharSkill]
WHERE [CharID] = @CharID and [SkillID] > '40' and SkillID<'70'
DELETE [dbo].[_CharSkill]
WHERE [CharID] = @CharID and [SkillID] > '70'
UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'
WHERE CharID= @CharID
UPDATE [dbo].[_Char]
SET RemainSkillPoint= @GiveSP
WHERE CharName16 = @CharName
GO
Reset EU skill
كود بلغة HTML:
update _ClientConfig
set Data = '0'
where CharID = @CharID
-- edit by omarahmed500 --
--- Do Not Change Here ---
--- made by omarahmed500 for S4a ---
DELETE [dbo].[_CharSkill]
WHERE [CharID] = @CharID and [SkillID] > '2'
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID
,'8421'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID
,'8419'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'8420'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'9354'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'9355'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'9944'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'10625'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'11162'
,'1')
INSERT INTO [dbo].[_CharSkill]
([CharID]
,[SkillID]
,[Enable])
VALUES
(@CharID,
'11526'
,'1')
UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'
WHERE CharID= @CharID
UPDATE [dbo].[_Char]
SET RemainSkillPoint= @GiveSP
WHERE CharName16 = @CharName
GO
for all char
كود بلغة HTML:
USE [SRO_VT_SHARD]
GO
--Made by omarahmed500 for silkroad4arab
-- edit by omarahmed500 --
update _ClientConfig
set Data = '0'
-- edit by omarahmed500 --
DELETE FROM [dbo].[_CharSkill]
WHERE SKillID NOT LIKE '1' and SKillID NOT LIKE '2' and SKillID NOT LIKE '40'
and SKillID NOT LIKE '70' and SKillID NOT LIKE '8421' and SKillID NOT LIKE '8419'
and SKillID NOT LIKE '8420' and SKillID NOT LIKE '9354' and SKillID NOT LIKE '9355'
and SKillID NOT LIKE '9944' and SKillID NOT LIKE '10625' and SKillID NOT LIKE '11162'
and SKillID NOT LIKE '11526'
GO
UPDATE [dbo].[_CharSkillMastery]
SET
[Level] = '0'
For delete Mobs
كود PHP:
JUPITER - Jupiter
SD - DESERT OF ALEX
DELTA - Alexandria
Eu - Constantinople
Ca - Central Asia (Samarkand)
Pharaoh - HOLY TEMPLE
KingsValley - ALEX DOWN
TEMPLE - JOB CAVE ALEXANDRIA
]
كود PHP:
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[ID] [nchar](10) NULL
) ON [PRIMARY]
GO
INSERT INTO Region (ID)
select
_RefRegion.wRegionID
from
_RefRegion
where
/* Set JUPITER name here like 'JUPITER'*/
_RefRegion.ContinentName like 'JUPITER'
GO
delete FROM Tab_RefNest
WHERE EXISTS (SELECT ID FROM Region WHERE ID = nRegionDBID)
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
Fix PET2 Skill In DataBase(new Pets)
كود بلغة HTML:
Update _RefSkill
Set Service = 1
Where Basic_Code like ('%%P2SKIL%%')
/* */
كود بلغة HTML:
Update _RefSkill
Set Param16 = 0, Param17 = 0, Param18 = 0, Param19 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
كود بلغة HTML:
Update _RefSkill
Set Param11 = 0, Param12 = 0, Param13 = 0, Param15 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
كود بلغة HTML:
Update _RefSkill
Set Param14 = 0, Param15 = 0, Param16 = 0, Param17 = 0
Where Basic_Code like ('%%P2SKIL%%')
/* */
كود بلغة HTML:
Update _RefSkill
Set Service = 0
Where ID BETWEEN 33726 And 33739
/* */
كود بلغة HTML:
Update _RefSkill
Set Service = 0
Where ID BETWEEN 33581 And 33586
/* */
Query Delete Select Item From All Game
كود بلغة HTML:
USE [SRO_VT_SHARD]
Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM_COS_P_RABBIT_SCROLL' ]
5Page Inventory (Work 100%) Without Bug
كود PHP:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as
begin tran
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0,0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
end
commit tran
return @COS_ID
Jop Exp
كود PHP:
USE [SRO_VT_SHARD] --By Evo--
DECLARE @Rate INT
SET @Rate = '100' -- Rate here
UPDATE [dbo].[_RefLevel]
SET
[JobExp_Trader] = [JobExp_Trader]/@Rate
,
[JobExp_Robber] = [JobExp_Robber]/@Rate
,
[JobExp_Hunter] = [JobExp_Hunter]/@Rate
WHERE [Lvl] BETWEEN 1 and 7
SELECT
*
FROM _RefLevel
WHERE Lvl BETWEEN 1 AND 140;
عايز تزود او تقلل وقت ال FGW
كود PHP:
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_2'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_3'
SELECT * FROM dbo._RefObjCommon where CodeName128 like 'ITEM_ETC_TELEPORT_HOLE_WRECK_100_110_LEVEL_4'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35901'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35902'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35903'
UPDATE[dbo].[_RefObjCommon]set DecayTime='10800' where ID='35904'
تزود عدد الموبس
الصورعفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
كود PHP:
USE SRO_VT_SHARD_INIT
UPDATE Tab_RefNest SET dwmaxtotalcount=dwmaxtotalcount*2
WHERE dwTacticsID NOT BETWEEN 41000 AND 43860
AND dwTacticsID NOT BETWEEN 32100 AND 32800
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount=1
WHERE dwdelaytimemax=21600;
Magic pop D12
1. Deg 12 SoX Weapon EU / CH
كود PHP:
/* Aktiviert die Deg12 SoX Waffen CH EU im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'
where RefItemID = '7490' or
RefItemID = '7491' or
RefItemID = '4083' or
RefItemID = '4085' or
RefItemID = '4084' or
RefItemID = '4157' or
RefItemID = '4156' or
RefItemID = '4155' or
RefItemID = '4191' or
RefItemID = '4193' or
RefItemID = '4192' or
RefItemID = '4121' or
RefItemID = '4119' or
RefItemID = '4120' or
RefItemID = '4228' or
RefItemID = '4229' or
RefItemID = '4227' or
RefItemID = '11615' or
RefItemID = '11616' or
RefItemID = '11614' or
RefItemID = '11292' or
RefItemID = '11291' or
RefItemID = '11327' or
RefItemID = '11326' or
RefItemID = '11290' or
RefItemID = '11328' or
RefItemID = '11544' or
RefItemID = '11543' or
RefItemID = '11542' or
RefItemID = '11470' or
RefItemID = '11471' or
RefItemID = '11472' or
RefItemID = '11399' or
RefItemID = '11398' or
RefItemID = '11400' or
RefItemID = '11254' or
RefItemID = '11255' or
RefItemID = '11256' or
RefItemID = '11506' or
RefItemID = '11507' or
RefItemID = '11508' or
RefItemID = '11435' or
RefItemID = '11434' or
RefItemID = '11436' or
RefItemID = '11364' or
RefItemID = '11363' or
RefItemID = '11362'
Deg12 SoX Equip EU
كود PHP:
/* Aktiviert die Deg12 SoX Rüstungen EU im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'
where RefItemID = '12928' or
RefItemID = '13000' or
RefItemID = '13036' or
RefItemID = '13072' or
RefItemID = '13144' or
RefItemID = '13108' or
RefItemID = '12676' or
RefItemID = '12748' or
RefItemID = '12784' or
RefItemID = '12820' or
RefItemID = '12892' or
RefItemID = '12856' or
RefItemID = '12424' or
RefItemID = '12496' or
RefItemID = '12532' or
RefItemID = '12568' or
RefItemID = '12640' or
RefItemID = '12604' or
RefItemID = '14440' or
RefItemID = '14512' or
RefItemID = '14548' or
RefItemID = '14584' or
RefItemID = '14656' or
RefItemID = '14620' or
RefItemID = '14188' or
RefItemID = '14260' or
RefItemID = '14296' or
RefItemID = '14332' or
RefItemID = '14404' or
RefItemID = '14368' or
RefItemID = '13936' or
RefItemID = '14008' or
RefItemID = '14044' or
RefItemID = '14080' or
RefItemID = '14152' or
RefItemID = '14116' or
RefItemID = '12929' or
RefItemID = '13001' or
RefItemID = '13037' or
RefItemID = '13073' or
RefItemID = '13145' or
RefItemID = '13109' or
RefItemID = '12677' or
RefItemID = '12749' or
RefItemID = '12785' or
RefItemID = '12821' or
RefItemID = '12893' or
RefItemID = '12857' or
RefItemID = '12425' or
RefItemID = '12497' or
RefItemID = '12533' or
RefItemID = '12569' or
RefItemID = '12641' or
RefItemID = '12605' or
RefItemID = '14441' or
RefItemID = '14513' or
RefItemID = '14549' or
RefItemID = '14585' or
RefItemID = '14657' or
RefItemID = '14621' or
RefItemID = '14189' or
RefItemID = '14261' or
RefItemID = '14297' or
RefItemID = '14333' or
RefItemID = '14405' or
RefItemID = '14369' or
RefItemID = '13937' or
RefItemID = '14009' or
RefItemID = '14045' or
RefItemID = '14081' or
RefItemID = '14153' or
RefItemID = '14117' or
RefItemID = '12930' or
RefItemID = '13002' or
RefItemID = '13038' or
RefItemID = '13074' or
RefItemID = '13146' or
RefItemID = '13110' or
RefItemID = '12678' or
RefItemID = '12750' or
RefItemID = '12786' or
RefItemID = '12822' or
RefItemID = '12894' or
RefItemID = '12858' or
RefItemID = '12426' or
RefItemID = '12498' or
RefItemID = '12534' or
RefItemID = '12570' or
RefItemID = '12642' or
RefItemID = '12606' or
RefItemID = '14442' or
RefItemID = '14514' or
RefItemID = '14550' or
RefItemID = '14586' or
RefItemID = '14658' or
RefItemID = '14622' or
RefItemID = '14190' or
RefItemID = '14262' or
RefItemID = '14298' or
RefItemID = '14334' or
RefItemID = '14406' or
RefItemID = '14370' or
RefItemID = '13938' or
RefItemID = '14010' or
RefItemID = '14046' or
RefItemID = '14082' or
RefItemID = '14154' or
RefItemID = '14118'
3. Deg12 SoX Equip CH
كود PHP:
/* Aktiviert die Deg12 SoX Rüstungen CH im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'
where RefItemID = '4767' or
RefItemID = '4839' or
RefItemID = '4875' or
RefItemID = '4911' or
RefItemID = '4983' or
RefItemID = '4947' or
RefItemID = '4515' or
RefItemID = '4587' or
RefItemID = '4623' or
RefItemID = '4659' or
RefItemID = '4731' or
RefItemID = '4695' or
RefItemID = '4263' or
RefItemID = '4335' or
RefItemID = '4371' or
RefItemID = '4407' or
RefItemID = '4479' or
RefItemID = '4443' or
RefItemID = '5523' or
RefItemID = '5595' or
RefItemID = '5631' or
RefItemID = '5667' or
RefItemID = '5739' or
RefItemID = '5703' or
RefItemID = '5271' or
RefItemID = '5343' or
RefItemID = '5379' or
RefItemID = '5415' or
RefItemID = '5487' or
RefItemID = '5451' or
RefItemID = '5019' or
RefItemID = '5091' or
RefItemID = '5127' or
RefItemID = '5163' or
RefItemID = '5235' or
RefItemID = '5199' or
RefItemID = '4768' or
RefItemID = '4840' or
RefItemID = '4876' or
RefItemID = '4912' or
RefItemID = '4984' or
RefItemID = '4948' or
RefItemID = '4516' or
RefItemID = '4588' or
RefItemID = '4624' or
RefItemID = '4660' or
RefItemID = '4732' or
RefItemID = '4696' or
RefItemID = '4264' or
RefItemID = '4336' or
RefItemID = '4372' or
RefItemID = '4408' or
RefItemID = '4480' or
RefItemID = '4444' or
RefItemID = '5524' or
RefItemID = '5596' or
RefItemID = '5632' or
RefItemID = '5668' or
RefItemID = '5740' or
RefItemID = '5704' or
RefItemID = '5272' or
RefItemID = '5344' or
RefItemID = '5380' or
RefItemID = '5416' or
RefItemID = '5488' or
RefItemID = '5452' or
RefItemID = '5020' or
RefItemID = '5092' or
RefItemID = '5128' or
RefItemID = '5164' or
RefItemID = '5236' or
RefItemID = '5200' or
RefItemID = '4769' or
RefItemID = '4841' or
RefItemID = '4877' or
RefItemID = '4913' or
RefItemID = '4985' or
RefItemID = '4949' or
RefItemID = '4517' or
RefItemID = '4589' or
RefItemID = '4625' or
RefItemID = '4661' or
RefItemID = '4733' or
RefItemID = '4697' or
RefItemID = '4265' or
RefItemID = '4337' or
RefItemID = '4373' or
RefItemID = '4409' or
RefItemID = '4481' or
RefItemID = '4445' or
RefItemID = '5525' or
RefItemID = '5597' or
RefItemID = '5633' or
RefItemID = '5669' or
RefItemID = '5741' or
RefItemID = '5705' or
RefItemID = '5273' or
RefItemID = '5345' or
RefItemID = '5381' or
RefItemID = '5417' or
RefItemID = '5489' or
RefItemID = '5453' or
RefItemID = '5021' or
RefItemID = '5093' or
RefItemID = '5129' or
RefItemID = '5165' or
RefItemID = '5237' or
RefItemID = '5201'
4. Deg12 SoX Accesorries
كود PHP:
/* Aktiviert den Deg12 SoX Schmuck CH im Magic Pop */
update [SRO_VT_SHARD].[dbo].[_RefGachaItemSet]
set Service = '1'
where RefItemID = '14800' or
RefItemID = '14836' or
RefItemID = '14872' or
RefItemID = '5847' or
RefItemID = '5811' or
RefItemID = '5775' or
RefItemID = '14801' or
RefItemID = '14837' or
RefItemID = '14873' or
RefItemID = '5848' or
RefItemID = '5812' or
RefItemID = '5776' or
RefItemID = '14802' or
RefItemID = '14838' or
RefItemID = '14874' or
RefItemID = '5849' or
RefItemID = '5813' or
RefItemID = '5777'
Media side
كود PHP:
1 3 1 1 1 200 UIIT_CTL_WK_CH_ARMOR 221 UIIT_CTL_WK_CH_ARMOR_CLOTHES_1 12
1 3 1 1 2 200 UIIT_CTL_WK_CH_ARMOR 222 UIIT_CTL_WK_CH_ARMOR_CLOTHES_2 12
1 3 1 1 3 200 UIIT_CTL_WK_CH_ARMOR 223 UIIT_CTL_WK_CH_ARMOR_CLOTHES_3 12
1 3 1 1 4 200 UIIT_CTL_WK_CH_ARMOR 224 UIIT_CTL_WK_CH_ARMOR_CLOTHES_4 12
1 3 1 1 5 200 UIIT_CTL_WK_CH_ARMOR 225 UIIT_CTL_WK_CH_ARMOR_CLOTHES_5 12
1 3 1 1 6 200 UIIT_CTL_WK_CH_ARMOR 226 UIIT_CTL_WK_CH_ARMOR_CLOTHES_6 12
1 3 1 2 1 200 UIIT_CTL_WK_CH_ARMOR 211 UIIT_CTL_WK_CH_ARMOR_LIGHT_1 12
1 3 1 2 2 200 UIIT_CTL_WK_CH_ARMOR 212 UIIT_CTL_WK_CH_ARMOR_LIGHT_2 12
1 3 1 2 3 200 UIIT_CTL_WK_CH_ARMOR 213 UIIT_CTL_WK_CH_ARMOR_LIGHT_3 12
1 3 1 2 4 200 UIIT_CTL_WK_CH_ARMOR 214 UIIT_CTL_WK_CH_ARMOR_LIGHT_4 12
1 3 1 2 5 200 UIIT_CTL_WK_CH_ARMOR 215 UIIT_CTL_WK_CH_ARMOR_LIGHT_5 12
1 3 1 2 6 200 UIIT_CTL_WK_CH_ARMOR 216 UIIT_CTL_WK_CH_ARMOR_LIGHT_6 12
1 3 1 3 1 200 UIIT_CTL_WK_CH_ARMOR 201 UIIT_CTL_WK_CH_ARMOR_HEAVY_1 12
1 3 1 3 2 200 UIIT_CTL_WK_CH_ARMOR 202 UIIT_CTL_WK_CH_ARMOR_HEAVY_2 12
1 3 1 3 3 200 UIIT_CTL_WK_CH_ARMOR 203 UIIT_CTL_WK_CH_ARMOR_HEAVY_3 12
1 3 1 3 4 200 UIIT_CTL_WK_CH_ARMOR 204 UIIT_CTL_WK_CH_ARMOR_HEAVY_4 12
1 3 1 3 5 200 UIIT_CTL_WK_CH_ARMOR 205 UIIT_CTL_WK_CH_ARMOR_HEAVY_5 12
1 3 1 3 6 200 UIIT_CTL_WK_CH_ARMOR 206 UIIT_CTL_WK_CH_ARMOR_HEAVY_6 12
1 3 1 4 1 100 UIIT_CTL_WK_CH_WEAPON 106 UIIT_CTL_WK_CH_WEAPON_SHIELD 12
1 3 1 4 2 400 UIIT_CTL_WK_EU_WEAPON 410 UIIT_CTL_WK_EU_WEAPON_SHIELD 12
1 3 1 5 1 300 UIIT_CTL_WK_CH_ACCESSORY 302 UIIT_CTL_WK_CH_ACCESSORY_EARRING 12
1 3 1 5 2 300 UIIT_CTL_WK_CH_ACCESSORY 301 UIIT_CTL_WK_CH_ACCESSORY_NECKLACE 12
1 3 1 5 3 300 UIIT_CTL_WK_CH_ACCESSORY 303 UIIT_CTL_WK_CH_ACCESSORY_RING 12
1 3 1 6 2 100 UIIT_CTL_WK_CH_WEAPON 101 UIIT_CTL_WK_CH_WEAPON_SWORD 12
1 3 1 6 3 100 UIIT_CTL_WK_CH_WEAPON 102 UIIT_CTL_WK_CH_WEAPON_BLADE 12
1 3 1 6 4 100 UIIT_CTL_WK_CH_WEAPON 103 UIIT_CTL_WK_CH_WEAPON_SPEAR 12
1 3 1 6 5 100 UIIT_CTL_WK_CH_WEAPON 104 UIIT_CTL_WK_CH_WEAPON_TBLADE 12
1 3 1 6 6 100 UIIT_CTL_WK_CH_WEAPON 105 UIIT_CTL_WK_CH_WEAPON_BOW 12
1 3 1 6 7 400 UIIT_CTL_WK_EU_WEAPON 401 UIIT_CTL_WK_EU_WEAPON_SWORD 12
1 3 1 6 8 400 UIIT_CTL_WK_EU_WEAPON 402 UIIT_CTL_WK_EU_WEAPON_TSWORD 12
1 3 1 6 9 400 UIIT_CTL_WK_EU_WEAPON 403 UIIT_CTL_WK_EU_WEAPON_DUALAXE 12
1 3 1 6 10 400 UIIT_CTL_WK_EU_WEAPON 404 UIIT_CTL_WK_EU_WEAPON_WROD 12
1 3 1 6 11 400 UIIT_CTL_WK_EU_WEAPON 406 UIIT_CTL_WK_EU_WEAPON_TSTAFF 12
1 3 1 6 12 400 UIIT_CTL_WK_EU_WEAPON 407 UIIT_CTL_WK_EU_WEAPON_CROSSBOW 12
1 3 1 6 13 400 UIIT_CTL_WK_EU_WEAPON 408 UIIT_CTL_WK_EU_WEAPON_DAGGER 12
1 3 1 6 14 400 UIIT_CTL_WK_EU_WEAPON 409 UIIT_CTL_WK_EU_WEAPON_HARP 12
1 3 1 6 15 400 UIIT_CTL_WK_EU_WEAPON 405 UIIT_CTL_WK_EU_WEAPON_CROD 12
1 3 1 9 1 500 UIIT_CTL_WK_EU_ARMOR 521 UIIT_CTL_WK_EU_ARMOR_ROBE_1 12
1 3 1 9 2 500 UIIT_CTL_WK_EU_ARMOR 522 UIIT_CTL_WK_EU_ARMOR_ROBE_2 12
1 3 1 9 3 500 UIIT_CTL_WK_EU_ARMOR 523 UIIT_CTL_WK_EU_ARMOR_ROBE_3 12
1 3 1 9 4 500 UIIT_CTL_WK_EU_ARMOR 524 UIIT_CTL_WK_EU_ARMOR_ROBE_4 12
1 3 1 9 5 500 UIIT_CTL_WK_EU_ARMOR 525 UIIT_CTL_WK_EU_ARMOR_ROBE_5 12
1 3 1 9 6 500 UIIT_CTL_WK_EU_ARMOR 526 UIIT_CTL_WK_EU_ARMOR_ROBE_6 12
1 3 1 10 1 500 UIIT_CTL_WK_EU_ARMOR 511 UIIT_CTL_WK_EU_ARMOR_LIGHT_1 12
1 3 1 10 2 500 UIIT_CTL_WK_EU_ARMOR 512 UIIT_CTL_WK_EU_ARMOR_LIGHT_2 12
1 3 1 10 3 500 UIIT_CTL_WK_EU_ARMOR 513 UIIT_CTL_WK_EU_ARMOR_LIGHT_3 12
1 3 1 10 4 500 UIIT_CTL_WK_EU_ARMOR 514 UIIT_CTL_WK_EU_ARMOR_LIGHT_4 12
1 3 1 10 5 500 UIIT_CTL_WK_EU_ARMOR 515 UIIT_CTL_WK_EU_ARMOR_LIGHT_5 12
1 3 1 10 6 500 UIIT_CTL_WK_EU_ARMOR 516 UIIT_CTL_WK_EU_ARMOR_LIGHT_6 12
1 3 1 11 1 500 UIIT_CTL_WK_EU_ARMOR 501 UIIT_CTL_WK_EU_ARMOR_HEAVY_1 12
1 3 1 11 2 500 UIIT_CTL_WK_EU_ARMOR 502 UIIT_CTL_WK_EU_ARMOR_HEAVY_2 12
1 3 1 11 3 500 UIIT_CTL_WK_EU_ARMOR 503 UIIT_CTL_WK_EU_ARMOR_HEAVY_3 12
1 3 1 11 4 500 UIIT_CTL_WK_EU_ARMOR 504 UIIT_CTL_WK_EU_ARMOR_HEAVY_4 12
1 3 1 11 5 500 UIIT_CTL_WK_EU_ARMOR 505 UIIT_CTL_WK_EU_ARMOR_HEAVY_5 12
1 3 1 11 6 500 UIIT_CTL_WK_EU_ARMOR 506 UIIT_CTL_WK_EU_ARMOR_HEAVY_6 12
1 3 1 12 1 600 UIIT_CTL_WK_EU_ACCESSORY 602 UIIT_CTL_WK_EU_ACCESSORY_EARRING 12
1 3 1 12 2 600 UIIT_CTL_WK_EU_ACCESSORY 601 UIIT_CTL_WK_EU_ACCESSORY_NECKLACE 12
1 3 1 12 3 600 UIIT_CTL_WK_EU_ACCESSORY 603 UIIT_CTL_WK_EU_ACCESSORY_RING 12
1 3 1 13 1 700 UIIT_CTL_WK_ETC_ETC 704 UIIT_CTL_WK_AVATAR_HAT 0
1 3 1 13 2 700 UIIT_CTL_WK_ETC_ETC 705 UIIT_CTL_WK_AVATAR_DRESS 0
1 3 1 13 3 700 UIIT_CTL_WK_ETC_ETC 706 UIIT_CTL_WK_AVATAR_ATTACH 0
1 3 1 13 4 700 UIIT_CTL_WK_ETC_ETC 701 UIIT_CTL_WK_AVATAR_FLAG 0
1 3 1 14 1 700 UIIT_CTL_WK_ETC_ETC 707 UIIT_CTL_WK_ETC_ETC 0
1 3 3 10 4 700 UIIT_CTL_WK_ETC_ETC 703 UIIT_CTL_WK_ALCHEMY_ELIXIR 0
1 3 3 11 7 700 UIIT_CTL_WK_ETC_ETC 702 UIIT_CTL_WK_ALCHEMY_MAGICSTONE 12
change inventorysize by character
كود PHP:
USE [SRO_VT_SHARD_INIT]
GO
Declare @CharName Varchar (64)
Set @CharName = 'Put Chr name here'
UPDATE dbo._Char
--change 77 to any number you want for make 3 inv put number 109
SET InventorySize= 77
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Merchant Rate
كود PHP:
DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewStack = 9999 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
-- Price / SellPrice
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401
UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672
UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672
-- MaxStack
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888
UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160
-- Price
UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'
16-12-2012, 04:09 PM
العرض الشجري