Mohammed2015
14-06-2015, 03:12 AM
بسم الله الرحمن الرحيم
موضوعنا انهارده موضوع مهم جدا
اعمل الاداتا بيز بتاعتك بنفسك وكل ال Query الي ممكن تحتاجها
اول حاجه حتقولي انا نفسي احط الدجري 12 و دجري 13
اقولك ماشي مفيش غير انك تفتح ال New Query Windows
وتحط فيها الكود ده
كود:
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620
وتغير اسم الداتا لو الداتا بتاعتك غير SRO_VT_SHARD
حتلاقي الداتا فيها دجري 12 و 13
وطبعا الكلينت انتا حتتسرف فيه
ملحوظه : الداتا سؤاء دجري 11 او 12 او 13 او 20 مش حتأثر ع السيرفر
نرجع لموضوعنا
تاني حاجه اضافة ال 120 Level Skill In Database
حتفتح New Query وتضيف ال حاجات دي
كود:
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
ومبروك عليك كدا ال سكيلات لفل 120
ثالثا
الجهاز عندك رامات 2 والوحوش بتنزل او اليونيك ويختفي علطول
حتستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/3
لو جهازك 4 GB Memeroy Ram
ختستخدم Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2
خصلت دي
عايز تظبط مواعيد اليونيك عندك ف الداتا
استخدم
Query
ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
ف مشكله ف الوحوش مش بتنزل عندك
حتنزل الملف ده
http://www.mediafire.com/?59gcagxprgibken
وبعدين تحطه ف
C:\
واستخدم ال Query ده ومبروك عليك اتحلت المشكله دي
كود:
DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest]
USE [SRO_VT_SHARD]
GO
BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t')
عندك اي حاجه جديده وعايز تضيفها
حط الاكواد ف ملف ف قرص C:\
واستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
BULK INSERT _RefObjCommon FROM 'C:\_RefObjCommon.txt' WITH (FIELDTERMINATOR = '\t')
RefObjcommon
حتغيرها للي عايزه طبعا
عايز تمسح حكاية الجيلد تستني ليه 3 ايام علشان تدهل تاني
اتفضل
استخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
/******By Jangan and Wismo ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
حتضيف افاتار وناوي تعرف اخر ID عندك ف Objcommon +Obj Item
استخدم ده ومتتعبش نفسك لانه ممكن يكون مش مرتب
Query
كود:
USE SRO_VT_SHARD
DECLARE @CommonID INT
DECLARE @ItemLinkID INT
SET @CommonID = (SELECT ID FROM _RefObJCommon WHERE ID = (SELECT MAX(ID) FROM _RefObJCommon))+1
SET @ItemLinkID = (SELECT ID FROM _RefObJItem WHERE ID = (SELECT MAX(ID) FROM _RefObJItem))+1
print 'Common ID you have to use: '+cast(@CommonID as varchar(15))
print 'Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))
نسبة نجاح ال Magic Pop
عندك ضعيفه وعايز تعليها
مفيش مانع استخدم ده احج
و عند SetRate=10
حط الرقم الي نفسك فيه
Query
كود:
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
ال F1 اول اربع اماكن فيها بايظين مفيش اي مشاكل استخدم ده ومبروك عليك
كود:
DELETE FROM _CharQuest WHERE QuestID = 1
INSERT INTO _CharQuest
SELECT CharID, QuestID = 1, [Status] = 1,AchievementCount = 0, StartTime = GETDATE()-4460, EndTime = GETDATE()-4460, QuestData1 = 0, QuestData2 = 0
FROM _Char
WHERE not exists (SELECT CharID, QuestID FROM _CharQuest WHERE QuestID = 1)
واعمل ده ف الداتا برده لو لسه المشكله
Open RefCharDefult_Quest table.
كود PHP:
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
0 14 0 QTUTORIAL_CH 1
0 15 3 QEVENT_GUIDE 1
NULL NULL NULL NULL NULL
Look at this line:
Code:
0 15 3 QEVENT_GUIDE 1
You need to enable this quest.
Code:
1 15 3 QEVENT_GUIDE 1
afl mbrooook
العدد المسموح للاليكسر فوق بعضها ضعيف عندك
استخدم Query ده
كود:
use SRO_VT_SHARD
UPDATE dbo._RefObjItem
SET MaxStack = 50
WHERE ID BETWEEN 3679 AND 3682
لو لسه المشكله موضجوده كلمني وانا اقولك تعملها ازاي ف الكلينت
عايز تشيل ال alchemy-material من ال Drop
اي خناقات استخدم Query ده يا برنس ومبروك عليك
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6679 AND 5414
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6082 AND 6371
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 10501 AND 10527
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 11499 AND 11668
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 12554 AND 12569
عايز تضيف الولف عند ال Npc Stable
ضيف دول ف الداتا
كود:
Update _RefPackageItem
SET Service = 1
WHERE CodeName128 = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefPricePolicyOfItem
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefScrapOfPackageItem
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefShopGoods
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
ودول ف الميديا
كود:
refshopgoods.txt :
1 15 STORE_CA_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_WC_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
refscrapofpackageitem.txt :
1 15 PACKAGE_ITEM_COS_P_FLUTE ITEM_COS_P_FLUTE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 29952
refpricepolicyofitem.txt :
1 15 PACKAGE_ITEM_COS_P_FLUTE 1 0 2000000 -1 xxx -1 xxx -1 xxx -1 xxx
refpackageitem.txt :
1 15 24822 PACKAGE_ITEM_COS_P_FLUTE 0 EXPAND_TERM_ALL SN_ITEM_COS_P_FLUTE SN_ITEM_COS_P_FLUTE_TT_DESC coscos_p_flute.ddj -1 xxx -1 xxx -1 xxx -1 xxx
Mbroooook
عايز تضيف ال Vigor عند بتاع البوشن
ضيف دول بس
كود:
Database
----------------
Packageitem.dbo
1 15 84037 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC item\etc\all_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
----------------
_RefPriceofpolicy
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
----------------
_RefScarp
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 ITEM_ETC_ALL_SPOTION_01 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86685
----------------
_RefShop
1 15 STORE_CA_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 23 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_WC_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx
_________________________________
_________________________________
Media
-------------------------
packageitem
1 15 84114 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC item\etc\all_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
----------------
price
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
----------------
scarp
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 ITEM_ETC_ALL_SPOTION_01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86767
----------------
shop
1 15 STORE_WC_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 23 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CA_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx
By Mr_Jackie
نفسك اي حد يسجل عندك ينزل ب معاه سيلك اوتوماتيك ومن غير مواقع ولا اي حاجه
استخدم ده في New Query ل الداتا SRO_VT_ACCOUNT
كود:
USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK
(JID,
silk_own,
silk_gift,
silk_point)
SELECT JID,
'0',
'0',
'0'
FROM TB_User
WHERE not exists (select * from SK_Silk
WHERE SK_SILK.JID = TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+10
غير 10 للرقم الي عايزه
عايز تتحكم ف ال Sox Drop Rate
حط ده في Query وكبر دمــــــــــــاعك
كود:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
set rate=10
حتغيرها للي عايزه
عايز تضيف عندك ال Lucky Powder d12
استخدم دول وعيش يا برنس
كود:
RefPackgeItem
1 15 yourDBID PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 0 EXPAND_TERM_ALL SN_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 SN_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12_TT_DESC itemetcarchemy_reinforce_prob_up_a.ddj -1 XXX -1 xxx -1 xxx -1 xxx
RefPricePolicyOfItem
1 15 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 1 0 77438 -1 xxx -1 xxx -1 xxx -1 xxx
RefScrapOfPackageItem
1 15 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx yourDBID
RefShopGoods (Which NPC you want the Lucky Powder D12 to be added), in this example I chose NPC Grocery Alex
1 15 STORE_SD_ACCESSORY_EU_TAB3 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 19 -1 xxx -1 xxx -1 xxx -1 xxx
عايز تتحكم ف ال Job
كود:
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%'
الاسعار واللفل وده كله من هنا فوق حتغيره وتحط قدامه الرقم المناسب
منقول
http://*************/vb3/showthread.php?t=81
موضوعنا انهارده موضوع مهم جدا
اعمل الاداتا بيز بتاعتك بنفسك وكل ال Query الي ممكن تحتاجها
اول حاجه حتقولي انا نفسي احط الدجري 12 و دجري 13
اقولك ماشي مفيش غير انك تفتح ال New Query Windows
وتحط فيها الكود ده
كود:
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620
وتغير اسم الداتا لو الداتا بتاعتك غير SRO_VT_SHARD
حتلاقي الداتا فيها دجري 12 و 13
وطبعا الكلينت انتا حتتسرف فيه
ملحوظه : الداتا سؤاء دجري 11 او 12 او 13 او 20 مش حتأثر ع السيرفر
نرجع لموضوعنا
تاني حاجه اضافة ال 120 Level Skill In Database
حتفتح New Query وتضيف ال حاجات دي
كود:
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
ومبروك عليك كدا ال سكيلات لفل 120
ثالثا
الجهاز عندك رامات 2 والوحوش بتنزل او اليونيك ويختفي علطول
حتستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/3
لو جهازك 4 GB Memeroy Ram
ختستخدم Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2
خصلت دي
عايز تظبط مواعيد اليونيك عندك ف الداتا
استخدم
Query
ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
ف مشكله ف الوحوش مش بتنزل عندك
حتنزل الملف ده
http://www.mediafire.com/?59gcagxprgibken
وبعدين تحطه ف
C:\
واستخدم ال Query ده ومبروك عليك اتحلت المشكله دي
كود:
DELETE FROM [SRO_VT_SHARD ].[dbo].[Tab_RefNest]
USE [SRO_VT_SHARD]
GO
BULK INSERT Tab_RefNest FROM 'C:\RefNEst.txt' WITH (FIELDTERMINATOR = '\t')
عندك اي حاجه جديده وعايز تضيفها
حط الاكواد ف ملف ف قرص C:\
واستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
BULK INSERT _RefObjCommon FROM 'C:\_RefObjCommon.txt' WITH (FIELDTERMINATOR = '\t')
RefObjcommon
حتغيرها للي عايزه طبعا
عايز تمسح حكاية الجيلد تستني ليه 3 ايام علشان تدهل تاني
اتفضل
استخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
/******By Jangan and Wismo ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0
--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)
return -3
return @NewJobID
حتضيف افاتار وناوي تعرف اخر ID عندك ف Objcommon +Obj Item
استخدم ده ومتتعبش نفسك لانه ممكن يكون مش مرتب
Query
كود:
USE SRO_VT_SHARD
DECLARE @CommonID INT
DECLARE @ItemLinkID INT
SET @CommonID = (SELECT ID FROM _RefObJCommon WHERE ID = (SELECT MAX(ID) FROM _RefObJCommon))+1
SET @ItemLinkID = (SELECT ID FROM _RefObJItem WHERE ID = (SELECT MAX(ID) FROM _RefObJItem))+1
print 'Common ID you have to use: '+cast(@CommonID as varchar(15))
print 'Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))
نسبة نجاح ال Magic Pop
عندك ضعيفه وعايز تعليها
مفيش مانع استخدم ده احج
و عند SetRate=10
حط الرقم الي نفسك فيه
Query
كود:
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
ال F1 اول اربع اماكن فيها بايظين مفيش اي مشاكل استخدم ده ومبروك عليك
كود:
DELETE FROM _CharQuest WHERE QuestID = 1
INSERT INTO _CharQuest
SELECT CharID, QuestID = 1, [Status] = 1,AchievementCount = 0, StartTime = GETDATE()-4460, EndTime = GETDATE()-4460, QuestData1 = 0, QuestData2 = 0
FROM _Char
WHERE not exists (SELECT CharID, QuestID FROM _CharQuest WHERE QuestID = 1)
واعمل ده ف الداتا برده لو لسه المشكله
Open RefCharDefult_Quest table.
كود PHP:
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
0 14 0 QTUTORIAL_CH 1
0 15 3 QEVENT_GUIDE 1
NULL NULL NULL NULL NULL
Look at this line:
Code:
0 15 3 QEVENT_GUIDE 1
You need to enable this quest.
Code:
1 15 3 QEVENT_GUIDE 1
afl mbrooook
العدد المسموح للاليكسر فوق بعضها ضعيف عندك
استخدم Query ده
كود:
use SRO_VT_SHARD
UPDATE dbo._RefObjItem
SET MaxStack = 50
WHERE ID BETWEEN 3679 AND 3682
لو لسه المشكله موضجوده كلمني وانا اقولك تعملها ازاي ف الكلينت
عايز تشيل ال alchemy-material من ال Drop
اي خناقات استخدم Query ده يا برنس ومبروك عليك
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6679 AND 5414
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6082 AND 6371
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 10501 AND 10527
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 11499 AND 11668
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 12554 AND 12569
عايز تضيف الولف عند ال Npc Stable
ضيف دول ف الداتا
كود:
Update _RefPackageItem
SET Service = 1
WHERE CodeName128 = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefPricePolicyOfItem
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefScrapOfPackageItem
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
كود:
Update _RefShopGoods
SET Service = 1
WHERE RefPackageItemCodeName = 'PACKAGE_ITEM_COS_P_FLUTE'
ودول ف الميديا
كود:
refshopgoods.txt :
1 15 STORE_CA_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_WC_STABLE_TAB3 PACKAGE_ITEM_COS_P_FLUTE 0 -1 xxx -1 xxx -1 xxx -1 xxx
refscrapofpackageitem.txt :
1 15 PACKAGE_ITEM_COS_P_FLUTE ITEM_COS_P_FLUTE 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 29952
refpricepolicyofitem.txt :
1 15 PACKAGE_ITEM_COS_P_FLUTE 1 0 2000000 -1 xxx -1 xxx -1 xxx -1 xxx
refpackageitem.txt :
1 15 24822 PACKAGE_ITEM_COS_P_FLUTE 0 EXPAND_TERM_ALL SN_ITEM_COS_P_FLUTE SN_ITEM_COS_P_FLUTE_TT_DESC coscos_p_flute.ddj -1 xxx -1 xxx -1 xxx -1 xxx
Mbroooook
عايز تضيف ال Vigor عند بتاع البوشن
ضيف دول بس
كود:
Database
----------------
Packageitem.dbo
1 15 84037 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC item\etc\all_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
----------------
_RefPriceofpolicy
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
----------------
_RefScarp
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 ITEM_ETC_ALL_SPOTION_01 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86685
----------------
_RefShop
1 15 STORE_CA_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 23 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_WC_POTION_TAB1 PACKAGEITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx
_________________________________
_________________________________
Media
-------------------------
packageitem
1 15 84114 PACKAGE_ITEM_ETC_ALL_SPOTION_01 0 EXPAND_TERM_ALL SN_ITEM_ETC_ALL_SPOTION_01 SN_ITEM_ETC_ALL_SPOTION_01_TT_DESC item\etc\all_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
----------------
price
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
----------------
scarp
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 ITEM_ETC_ALL_SPOTION_01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86767
----------------
shop
1 15 STORE_WC_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 23 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CA_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 25 -1 xxx -1 xxx -1 xxx -1 xxx
By Mr_Jackie
نفسك اي حد يسجل عندك ينزل ب معاه سيلك اوتوماتيك ومن غير مواقع ولا اي حاجه
استخدم ده في New Query ل الداتا SRO_VT_ACCOUNT
كود:
USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK
(JID,
silk_own,
silk_gift,
silk_point)
SELECT JID,
'0',
'0',
'0'
FROM TB_User
WHERE not exists (select * from SK_Silk
WHERE SK_SILK.JID = TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+10
غير 10 للرقم الي عايزه
عايز تتحكم ف ال Sox Drop Rate
حط ده في Query وكبر دمــــــــــــاعك
كود:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 -- Here we set the multiplier value! Default: 10
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE
set rate=10
حتغيرها للي عايزه
عايز تضيف عندك ال Lucky Powder d12
استخدم دول وعيش يا برنس
كود:
RefPackgeItem
1 15 yourDBID PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 0 EXPAND_TERM_ALL SN_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 SN_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12_TT_DESC itemetcarchemy_reinforce_prob_up_a.ddj -1 XXX -1 xxx -1 xxx -1 xxx
RefPricePolicyOfItem
1 15 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 1 0 77438 -1 xxx -1 xxx -1 xxx -1 xxx
RefScrapOfPackageItem
1 15 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx yourDBID
RefShopGoods (Which NPC you want the Lucky Powder D12 to be added), in this example I chose NPC Grocery Alex
1 15 STORE_SD_ACCESSORY_EU_TAB3 PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_12 19 -1 xxx -1 xxx -1 xxx -1 xxx
عايز تتحكم ف ال Job
كود:
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%'
الاسعار واللفل وده كله من هنا فوق حتغيره وتحط قدامه الرقم المناسب
منقول
http://*************/vb3/showthread.php?t=81