| Delivery |
10-07-2012 12:49 AM |
حصريـــا أضخم موضوع ف السيرفر الخاص Make Your Database WithYour Self
http://img844.imageshack.us/img844/5805/basmla.png
حصريا اضخم موضوع ف السيرفر الخاص Make Your Database With Your Self
.........................................
اولا احب اشكر كل الناس الي ساعدت ف الموضوع ده وشاركت فيه
وانا اخدت مها حاجتها ويا رب الموضوع يعجبكم
موضوعنا انهارده موضوع مهم جدا
اعمل الاداتا بيز بتاعتك بنفسك وكل ال Query الي ممكن تحتاجها
يا تري حنبدأ ازاي
انا حبدأ شرح مثال علي الداتا بتاعت موسي لانها كلين وكويسه خالص
ومفهاش يج وكده
http://www.al-wed.com/pic-vb/116.gif
اول حاجه حتقولي انا نفسي احط الدجري 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 مش حتأثر ع السيرفر
نرجع لموضوعنا
http://www.al-wed.com/pic-vb/116.gif
تاني حاجه اضافة ال 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
http://www.al-wed.com/pic-vb/116.gif
ثالثا
الجهاز عندك رامات 2 والوحوش بتنزل او اليونيك ويختفي علطول
حتستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/3
http://www.al-wed.com/pic-vb/116.gif
لو جهازك 4 GB Memeroy Ram
ختستخدم Query ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = dwmaxtotalcount/2
خصلت دي
http://www.al-wed.com/pic-vb/116.gif
عايز تظبط مواعيد اليونيك عندك ف الداتا
استخدم
Query
ده
كود:
USE [SRO_VT_SHARD]
GO
UPDATE dbo.Tab_RefNest SET dwmaxtotalcount = 1 where dwdelaytimemax = '21600' ;
http://www.al-wed.com/pic-vb/116.gif
ف مشكله ف الوحوش مش بتنزل عندك
حتنزل الملف ده
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')
http://www.al-wed.com/pic-vb/116.gif
عندك اي حاجه جديده وعايز تضيفها
حط الاكواد ف ملف ف قرص C:\
واستخدم ال Query ده
كود:
USE [SRO_VT_SHARD]
GO
BULK INSERT _RefObjCommon FROM 'C:\_RefObjCommon.txt' WITH (FIELDTERMINATOR = '\t')
RefObjcommon
حتغيرها للي عايزه طبعا
http://www.al-wed.com/pic-vb/116.gif
عايز تمسح حكاية الجيلد تستني ليه 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,Data2,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,Data2,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
http://www.al-wed.com/pic-vb/116.gif
حتضيف افاتار وناوي تعرف اخر 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))
http://www.al-wed.com/pic-vb/116.gif
نسبة نجاح ال 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
http://www.al-wed.com/pic-vb/116.gif
ال 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
http://www.al-wed.com/pic-vb/116.gif
http://www.al-wed.com/pic-vb/116.gif
العدد المسموح للاليكسر فوق بعضها ضعيف عندك
استخدم Query ده
كود:
use SRO_VT_SHARD
UPDATE dbo._RefObjItem
SET MaxStack = 50
WHERE ID BETWEEN 3679 AND 3682
لو لسه المشكله موضجوده كلمني وانا اقولك تعملها ازاي ف الكلينت
http://www.al-wed.com/pic-vb/116.gif
عايز تشيل ال 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
http://www.al-wed.com/pic-vb/116.gif
عايز تضيف الولف عند ال 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
http://www.al-wed.com/pic-vb/116.gif
عايز تضيف ال 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
http://www.al-wed.com/pic-vb/116.gif
نفسك اي حد يسجل عندك ينزل ب معاه سيلك اوتوماتيك ومن غير مواقع ولا اي حاجه
استخدم ده في 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 للرقم الي عايزه
http://www.al-wed.com/pic-vb/116.gif
عايز تتحكم ف ال 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
حتغيرها للي عايزه
http://www.al-wed.com/pic-vb/116.gif
عايز تضيف عندك ال 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
http://www.al-wed.com/pic-vb/116.gif
عايز تتحكم ف ال 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://www.al-wed.com/pic-vb/116.gif
لينكات مهمة لاحدث الايتمز والافاتارات
مشروحه وصور ليها كمان
Avatar's
How To add Phoenix Avatar last Isro Avatar
How To Add Demon Shitan Avatar Dress
How To Add Demon Shitan Avatar Dress
Vampire Wing Dress Onlu On Silkroad4arab by Me
طريقة اضافة افاتار بالتفصيل المممممممممممل
How to add Death Assassin Avatar
_______________________________
_______________________________
Items
كيفية اضافة الــــــــــــJaguar Pet لسيرفرك الخاص
حصريا عندنا وبس How To Edit Weapons Glow
Advance Elixer +250 For Any Dgree
ADD Dgree 12th To Your Npc By ME
ازاي تغير الـــــــImage Code وتحط الي عايزه
_________________________
_________________________
Programs
بعض الاضافات للسيرفر الخاص بك
اجمد GM helper
RefShop Convertor For Package code By Me
برنامج لتسهيل السرفر بدل smc المعقد
برنامج IpInput+الشرح التفصيلي وكيفية الاستخدام مع الميديا
حصريا Collection Of Most Helpfull Pk2 Edit Tools
________________________
________________________
Learn
(بسم اللة الرحمن الرحيم)انشاء اللة ده موضوع عن نسبيت نجاح ال Alchamy
█◄حصريا شرح تغيير الـ MaxStack لـ Hp,Mp And Elixirs►█
فقط على Silkroad4Arab ارض الحصريات بلص 255
how to remove ( 0 ) Notice
Evil MANGYANG Unique Lv 100
╝█╚♠ قبل ما تحمل كلينت علشان تاخد منه فايل تعالا هنا♠╝█ا
حصريــــــــــــــــــــا طريقة تغير شكل الانشر من شرحي التام
___________________
___________________
وان شاء الله الموضوع متجدد علطول واي حاجه جديده حضيفها هنا
ارجو بقي التثبيت لاني تعبيت بجد فيه ومن زمان عايز اعمله بس كنت بجمع بقي
|
