[SRO] Hướng dẫn Thêm Items vào shop

Fenix · 1 [SRO] Hướng dẫn Thêm Items vào shop Sat Feb 08, 2014 5:36 pm

Fenix

Game Master

Phương Châm : devGame | Diễn đàn phát triển Game Private | DevGame.Ga
Bài gửi : 1688
Coin : 30924148
Like : 8105
Tuổi : 26
Đến từ : devGame

Mỡ sro_vt_share
1- _RefPackageItem

Code:: 1 15 84037 PACKAGE_ITEM_CH_SWORD_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_SWORD_10_A SN_ITEM_CH_SWORD_10_A_TT_DESC itemchinaweaponsword_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84046 PACKAGE_ITEM_CH_BLADE_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_BLADE_10_A SN_ITEM_CH_BLADE_10_A_TT_DESC itemchinaweaponblade_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84047 PACKAGE_ITEM_CH_SPEAR_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_SPEAR_10_A SN_ITEM_CH_SPEAR_10_A_TT_DESC itemchinaweaponspear_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84048 PACKAGE_ITEM_CH_TBLADE_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_TBLADE_10_A SN_ITEM_CH_TBLADE_10_A_TT_DESC itemchinaweapontblade_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84049 PACKAGE_ITEM_CH_BOW_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_BOW_10_A SN_ITEM_CH_BOW_10_A_TT_DESC itemchinaweaponbow_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84050 PACKAGE_ITEM_CH_SHIELD_10_A 0 EXPAND_TERM_ALL SN_ITEM_CH_SHIELD_10_A SN_ITEM_CH_SHIELD_10_A_TT_DESC itemchinashieldshield_10.ddj -1 xxx -1 xxx -1 xxx -1 xxx 0 15 84051 PACKAGE_ITEM_CH_M_HEAVY_10_HA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_HA_A SN_ITEM_CH_HEAVY_10_HA_A_TT_DESC itemchinaman_itemheavy_10_ha.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84052 PACKAGE_ITEM_CH_M_HEAVY_10_CA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_CA_A SN_ITEM_CH_HEAVY_10_CA_A_TT_DESC itemchinaman_itemheavy_10_ca.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84053 PACKAGE_ITEM_CH_M_HEAVY_10_SA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_SA_A SN_ITEM_CH_HEAVY_10_SA_A_TT_DESC itemchinaman_itemheavy_10_sa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84054 PACKAGE_ITEM_CH_M_HEAVY_10_BA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_BA_A SN_ITEM_CH_HEAVY_10_BA_A_TT_DESC itemchinaman_itemheavy_10_ba.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84055 PACKAGE_ITEM_CH_M_HEAVY_10_LA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_LA_A SN_ITEM_CH_HEAVY_10_LA_A_TT_DESC itemchinaman_itemheavy_10_la.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84056 PACKAGE_ITEM_CH_M_HEAVY_10_AA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_HEAVY_10_AA_A SN_ITEM_CH_HEAVY_10_AA_A_TT_DESC itemchinaman_itemheavy_10_aa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84057 PACKAGE_ITEM_CH_M_HEAVY_10_FA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_HEAVY_10_FA_A SN_ITEM_CH_M_HEAVY_10_FA_A_TT_DESC itemchinaman_itemheavy_10_fa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 0 15 84058 PACKAGE_ITEM_CH_M_LIGHT_10_HA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_HA_A SN_ITEM_CH_M_LIGHT_10_HA_A_TT_DESC itemchinaman_itemlight_10_ha.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84059 PACKAGE_ITEM_CH_M_LIGHT_10_CA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_CA_A SN_ITEM_CH_M_LIGHT_10_CA_A_TT_DESC itemchinaman_itemlight_10_ca.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84060 PACKAGE_ITEM_CH_M_LIGHT_10_SA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_SA_A SN_ITEM_CH_M_LIGHT_10_SA_A_TT_DESC itemchinaman_itemlight_10_sa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84061 PACKAGE_ITEM_CH_M_LIGHT_10_BA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_BA_A SN_ITEM_CH_M_LIGHT_10_BA_A_TT_DESC itemchinaman_itemlight_10_ba.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84062 PACKAGE_ITEM_CH_M_LIGHT_10_LA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_LA_A SN_ITEM_CH_M_LIGHT_10_LA_A_TT_DESC itemchinaman_itemlight_10_la.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84063 PACKAGE_ITEM_CH_M_LIGHT_10_AA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_AA_A SN_ITEM_CH_M_LIGHT_10_AA_A_TT_DESC itemchinaman_itemlight_10_aa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84064 PACKAGE_ITEM_CH_M_LIGHT_10_FA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_LIGHT_10_FA_A SN_ITEM_CH_M_LIGHT_10_FA_A_TT_DESC itemchinaman_itemlight_10_fa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 0 15 84065 PACKAGE_ITEM_CH_M_CLOTHES_10_HA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_HA_A SN_ITEM_CH_M_CLOTHES_10_HA_A_TT_DESC itemchinaman_itemclothes_10_ha.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84066 PACKAGE_ITEM_CH_M_CLOTHES_10_CA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_CA_A SN_ITEM_CH_M_CLOTHES_10_CA_A_TT_DESC itemchinaman_itemclothes_10_ca.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84067 PACKAGE_ITEM_CH_M_CLOTHES_10_SA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_SA_A SN_ITEM_CH_M_CLOTHES_10_SA_A_TT_DESC itemchinaman_itemclothes_10_sa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84068 PACKAGE_ITEM_CH_M_CLOTHES_10_BA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_BA_A SN_ITEM_CH_M_CLOTHES_10_BA_A_TT_DESC itemchinaman_itemclothes_10_ba.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84069 PACKAGE_ITEM_CH_M_CLOTHES_10_LA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_LA_A SN_ITEM_CH_M_CLOTHES_10_LA_A_TT_DESC itemchinaman_itemclothes_10_la.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84070 PACKAGE_ITEM_CH_M_CLOTHES_10_AA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_AA_A SN_ITEM_CH_M_CLOTHES_10_AA_A_TT_DESC itemchinaman_itemclothes_10_aa.ddj -1 xxx -1 xxx -1 xxx -1 xxx 1 15 84071 PACKAGE_ITEM_CH_M_CLOTHES_10_FA_A 0 EXPAND_TERM_ALL SN_ITEM_CH_M_CLOTHES_10_FA_A SN_ITEM_CH_M_CLOTHES_10_FA_A_TT_DESC itemchinaman_itemclothes_10_fa.ddj -1 xxx -1 xxx -1 xxx -1 xxx

2_RefPricePolicyOfItem

Code:: 1 15 PACKAGE_ITEM_CH_BLADE_10_A 1 0 6492000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_BOW_10_A 1 0 7214000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_AA_A 1 0 2250000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_BA_A 1 0 3887000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_CA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_FA_A 1 0 2798000 -1 xxx -1 xxx -1 xxx -1 xxx 0 15 PACKAGE_ITEM_CH_M_CLOTHES_10_HA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_LA_A 1 0 3180000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_SA_A 1 0 2424000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_AA_A 1 0 2250000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_BA_A 1 0 3887000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_CA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_FA_A 1 0 2798000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_HA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_LA_A 1 0 3180000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_SA_A 1 0 2424000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_AA_A 1 0 2250000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_BA_A 1 0 3887000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_CA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_FA_A 1 0 2798000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_HA_A 1 0 2973000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_LA_A 1 0 3180000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_SA_A 1 0 2424000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_SHIELD_10_A 1 0 3607000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_SPEAR_10_A 1 0 7214000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_SWORD_10_A 1 0 6492000 -1 xxx -1 xxx -1 xxx -1 xxx 1 15 PACKAGE_ITEM_CH_TBLADE_10_A 1 0 7214000 -1 xxx -1 xxx -1 xxx -1 xxx

3- _RefScrapOfPackageItem

Code:: 1 15 PACKAGE_ITEM_CH_SWORD_10_A ITEM_CH_SWORD_10_A 0 0 117 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86689 1 15 PACKAGE_ITEM_CH_BLADE_10_A ITEM_CH_BLADE_10_A 0 0 129 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86690 1 15 PACKAGE_ITEM_CH_SPEAR_10_A ITEM_CH_SPEAR_10_A 0 0 78 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86691 1 15 PACKAGE_ITEM_CH_TBLADE_10_A ITEM_CH_TBLADE_10_A 0 0 86 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86692 1 15 PACKAGE_ITEM_CH_BOW_10_A ITEM_CH_BOW_10_A 0 0 89 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86693 1 15 PACKAGE_ITEM_CH_SHIELD_10_A ITEM_CH_SHIELD_10_A 0 0 86 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86694 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_HA_A ITEM_CH_M_HEAVY_10_HA_A 0 0 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86695 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_CA_A ITEM_CH_M_HEAVY_10_CA_A 0 0 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86696 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_SA_A ITEM_CH_M_HEAVY_10_SA_A 0 0 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86697 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_BA_A ITEM_CH_M_HEAVY_10_BA_A 0 0 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86698 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_LA_A ITEM_CH_M_HEAVY_10_LA_A 0 0 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86699 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_AA_A ITEM_CH_M_HEAVY_10_AA_A 0 0 90 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86700 1 15 PACKAGE_ITEM_CH_M_HEAVY_10_FA_A ITEM_CH_M_HEAVY_10_FA_A 0 0 91 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86701 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_HA_A ITEM_CH_M_LIGHT_10_HA_A 0 0 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86702 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_CA_A ITEM_CH_M_LIGHT_10_CA_A 0 0 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86703 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_SA_A ITEM_CH_M_LIGHT_10_SA_A 0 0 82 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86704 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_BA_A ITEM_CH_M_LIGHT_10_BA_A 0 0 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86705 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_LA_A ITEM_CH_M_LIGHT_10_LA_A 0 0 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86706 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_AA_A ITEM_CH_M_LIGHT_10_AA_A 0 0 82 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86707 1 15 PACKAGE_ITEM_CH_M_LIGHT_10_FA_A ITEM_CH_M_LIGHT_10_FA_A 0 0 83 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86708 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_HA_A ITEM_CH_M_CLOTHES_10_HA_A 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86709 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_CA_A ITEM_CH_M_CLOTHES_10_CA_A 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86710 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_SA_A ITEM_CH_M_CLOTHES_10_SA_A 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 xxx 0 xxx 0 xxx 0 xxx 86711 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 86712 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_BA_A ITEM_CH_M_CLOTHES_10_BA_A 0 0 75 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86713 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_LA_A ITEM_CH_M_CLOTHES_10_LA_A 0 0 75 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86714 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_AA_A ITEM_CH_M_CLOTHES_10_AA_A 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx -1 xxx -1 xxx 86715 1 15 PACKAGE_ITEM_CH_M_CLOTHES_10_FA_A ITEM_CH_M_CLOTHES_10_FA_A 0 0 74 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 xxx -1 xxx

Tiếp theo chay Query này Ỡ SRO_VT_SHARD:

Code:: USE [SRO_VT_SHARD_INIT] UPDATE dbo._RefPackageItem SET Service=1 WHERE CodeName128='PACKAGE_ITEM_COS_P_FLUTE' UPDATE dbo._RefPricePolicyOfItem SET Service=1 WHERE RefPackageItemCodeName='PACKAGE_ITEM_COS_P_FLUTE' UPDATE dbo._RefScrapOfPackageItem SET Service=1 WHERE RefPackageItemCodeName='PACKAGE_ITEM_COS_P_FLUTE' UPDATE dbo._RefShopGoods SET Service=1 WHERE RefPackageItemCodeName='PACKAGE_ITEM_COS_P_FLUTE'

Chúng ta dùng tools mỡ media.pk2 lấy 2 file refshopgoods.txt và refscrapofpackageitem.txt theo đường dẩn \server_dep\silkroad\textdata\
Bước 1 refshopgoods.txt:

Code:: 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

Bước 2 refscrapofpackageitem.txt:

Code:: 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

Và Import nó lại là xong ^^ chúc may mắn

Latest topics

[SRO] Hướng dẫn Thêm Items vào shop

1 [SRO] Hướng dẫn Thêm Items vào shop Sat Feb 08, 2014 5:36 pm

Fenix