لو سمحت عايز

[DevilSro]

لو سمحت عايز اعرف
1- ازاى اعمل اخر + فى الجيم بتاعتى مثلا +12 محدش يطلع غير كده باس طبعا ال GM 250 زى ما هوا
2- عايز اضيف الفيجور فى ال NPC

[iLead]

Vigor (http://silkroad4arab.com/vb/showthread.php?t=518660)

Alchemy (http://silkroad4arab.com/vb/showthread.php?t=457330)

[DevilSro]

عايز ال vigor query على طول

[DevilSro]

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 27 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_KT_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 24 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_EU_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 28 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CH_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 28 -1 xxx -1 xxx -1 xxx -1 xxx
1 15 STORE_CA_POTION_TAB1 PACKAGE_ITEM_ETC_ALL_SPOTION_01 26 -1 xxx -1 xxx -1 xxx -1 xxx


اسم ملفات الميديا اه لو سمحت

[iLead]

RefPriceOfPolicyOfItem

RefScrapOfPackegeItem

RefShopGoods

RefPackegeItem

[DevilSro]

سوال احط داه كدا من غير مغير فى اى رقم او اى حاجه

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

[DevilSro]

_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

86685 رقم اه داه


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

86767
وى داه وى غرهم

[DevilSro]

كولو تمام باس دلوقتى لما اشتى 1 vigor عادى لما اشترى اكتر من 1 يعنى 50 كده DC

[DevilSro]

فين الحل يا Lion باشا

[komnda]

1- add vigor in npc
1-
vigor
اولا الاضافات فى sql
Table Name : _RefPackageItem
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 itemetcall_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
**ddj File location in worng because PHP Code removes \ So Change it to item\etc\all_spotion_01.ddj
Table Name : _RefPricePolicyOfItem
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
Table Name : _RefScrapOfPackageItem
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
Table Name : _RefShopGoods
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
In Media Now..


refpackageitem.txt :
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 itemetcall_spotion_01.ddj -1 xxx -1 xxx -1 xxx -1 xxx
**ddj File location is item\etc\all_spotion_01.ddj with \
refpricepolicyofitem.txt :
1 15 PACKAGE_ITEM_ETC_ALL_SPOTION_01 1 0 20000 -1 xxx -1 xxx -1 xxx -1 xxx
refscrapofpackageitem.txt :
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
refshopgoods.txt :
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

2-
اخر + ممكن حضرتك تشوف الموضوع الدهوالك المشرف او الموضوع ده
http://www.silkroad4arab.com/vb/showthread.php?t=499060
وممكن تعمل لنفسك الاول +250 بعد كده اعمل ماكس بلص
عاوز الماكس بلص هتروح على
SRO_VT_SHARD>Stored Porocedures>System Stored Porocedures>_ADD_ITEM_EXTERN
بعد كدا دور على Optlevl وحوط الماكس بلص
__
وده برنامج سهل بدل الشرح الفوق http://www.silkroad4arab.com/vb/showthread.php?t=491260
___
وبالنسبه للمشكله حضرتك ممكن تخلى maxstack كدا عالى وشوف
MaxStock
SQL / SRO_VT_SHARD / TABLES / RefObjItem
MaxStock خليها الرقم اللى انت عايزو

[DevilSro]

والله المكس 50 vigor يعنى اعمل اه تانى