|
|
(같은 사용자의 중간 판 11개는 보이지 않습니다) |
9번째 줄: |
9번째 줄: |
| {{#get_db_data: | | {{#get_db_data: |
| db=ID | | db=ID |
− | |from=SHIP_MISSILE_RACK | + | |from=cargo__SHIP_MISSILE_RACK |
| |where='{{#external_value:ITEM_JSON_CLASS}}'=SHIP_MISSILE_RACK_CLASS_NAME | | |where='{{#external_value:ITEM_JSON_CLASS}}'=SHIP_MISSILE_RACK_CLASS_NAME |
| |data=SHIP_MISSILE_RACK_NAME=SHIP_MISSILE_RACK_NAME, SHIP_MISSILE_RACK_SIZE=SHIP_MISSILE_RACK_SIZE, SHIP_MISSILE_RACK_GRADE=SHIP_MISSILE_RACK_GRADE, SHIP_MISSILE_RACK_MANUFACTURER=SHIP_MISSILE_RACK_MANUFACTURER,SHIP_MISSILE_RACK_CLASS=SHIP_MISSILE_RACK_CLASS, | | |data=SHIP_MISSILE_RACK_NAME=SHIP_MISSILE_RACK_NAME, SHIP_MISSILE_RACK_SIZE=SHIP_MISSILE_RACK_SIZE, SHIP_MISSILE_RACK_GRADE=SHIP_MISSILE_RACK_GRADE, SHIP_MISSILE_RACK_MANUFACTURER=SHIP_MISSILE_RACK_MANUFACTURER,SHIP_MISSILE_RACK_CLASS=SHIP_MISSILE_RACK_CLASS, |
17번째 줄: |
17번째 줄: |
| {{#get_db_data: | | {{#get_db_data: |
| db=ID | | db=ID |
− | |from=ITEM_SHOP | + | |from=cargo__ITEM_SHOP |
| |where='{{#external_value:ITEM_SHOP_CLASS}}'=ITEM_SHOP_CLASS | | |where='{{#external_value:ITEM_SHOP_CLASS}}'=ITEM_SHOP_CLASS |
| |data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS, | | |data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS, |
45번째 줄: |
45번째 줄: |
| | | |
| ==판매 장소(aUEC)== | | ==판매 장소(aUEC)== |
− | === 아크콥 ===
| + | {{틀:아이템가격 |
− | {{#cargo_query:
| + | |REF={{#external_value: ITEM_REF}} |
− | table=ITEM_SHOP
| |
− | |fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
| |
− | CONCAT('[[',ITEM_SHOP_ORISON_NAME,'|',ITEM_SHOP_AREA18_PRICE,' aUEC',']]')=에어리어18,
| |
− | CONCAT('[[',ITEM_SHOP_OLISAR_NAME,'|',ITEM_SHOP_BAIJINI_PRICE,' aUEC',']]')=바이지니포인트,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L1_NAME,'|',ITEM_SHOP_ARC_L1_PRICE,' aUEC',']]')=ARC-L1,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L2_NAME,'|',ITEM_SHOP_ARC_L2_PRICE,' aUEC',']]')=ARC-L2,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L3_NAME,'|',ITEM_SHOP_ARC_L3_PRICE,' aUEC',']]')=ARC-L3,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L4_NAME,'|',ITEM_SHOP_ARC_L4_PRICE,' aUEC',']]')=ARC-L4,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L5_NAME,'|',ITEM_SHOP_ARC_L5_PRICE,' aUEC',']]')=ARC-L5
| |
− | |where=ITEM_SHOP_REF = '{{#external_value: ITEM_REF}}'
| |
− | |format=table
| |
− | }}
| |
− | | |
− | | |
− | ===허스턴===
| |
− | {{#cargo_query: | |
− | table=ITEM_SHOP
| |
− | |fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
| |
− | CONCAT('[[',ITEM_SHOP_LORVILLE_NAME,'|',ITEM_SHOP_LORVILLE_PRICE,' aUEC',']]')=로어빌,
| |
− | CONCAT('[[',ITEM_SHOP_EVERUS_NAME,'|',ITEM_SHOP_EVERUS_PRICE ,' aUEC',']]')=에버러스 하버,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L1_NAME,'|',ITEM_SHOP_HUR_L1_PRICE,' aUEC',']]')=HUR-L1,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L2_NAME,'|',ITEM_SHOP_HUR_L2_PRICE,' aUEC',']]')=HUR-L2,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L3_NAME,'|',ITEM_SHOP_HUR_L3_PRICE,' aUEC',']]')=HUR-L3,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L4_NAME,'|',ITEM_SHOP_HUR_L4_PRICE,' aUEC',']]')=HUR-L4,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L5_NAME,'|',ITEM_SHOP_HUR_L5_PRICE,' aUEC',']]')=HUR-L5
| |
− | |where=ITEM_SHOP_REF = '{{#external_value: ITEM_REF}}'
| |
− | |format=table
| |
− | }}
| |
− | | |
− | | |
− | ===크루세이더===
| |
− | {{#cargo_query:
| |
− | table=ITEM_SHOP
| |
− | |fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
| |
− | CONCAT('[[',ITEM_SHOP_ORISON_NAME,'|',ITEM_SHOP_ORISON_PRICE,' aUEC',']]')=오리슨,
| |
− | CONCAT('[[',ITEM_SHOP_OLISAR_NAME,'|',ITEM_SHOP_OLISAR_PRICE,' aUEC',']]')=포트 올리사,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L1_NAME,'|',ITEM_SHOP_CRU_L1_PRICE,' aUEC',']]')=CRU-L1,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L2_NAME,'|',ITEM_SHOP_CRU_L2_PRICE,' aUEC',']]')=CRU-L2,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L3_NAME,'|',ITEM_SHOP_CRU_L3_PRICE,' aUEC',']]')=CRU-L3,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L4_NAME,'|',ITEM_SHOP_CRU_L4_PRICE,' aUEC',']]')=CRU-L4,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L5_NAME,'|',ITEM_SHOP_CRU_L5_PRICE,' aUEC',']]')=CRU-L5
| |
− | |where=ITEM_SHOP_REF = '{{#external_value: ITEM_REF}}'
| |
− | |format=table
| |
− | }}
| |
− | | |
− | ===마이크로텍===
| |
− | {{#cargo_query:
| |
− | table=ITEM_SHOP
| |
− | |fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
| |
− | CONCAT('[[',ITEM_SHOP_ORISON_NAME,'|',ITEM_SHOP_NEW_BABBAGE_PRICE,' aUEC',']]')=오리슨,
| |
− | CONCAT('[[',ITEM_SHOP_TRESSLER_NAME,'|',ITEM_SHOP_TRESSLER_PRICE,' aUEC',']]')=포트 올리사,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L1_NAME,'|',ITEM_SHOP_MIC_L1_PRICE,' aUEC',']]')=MIC-L1,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L2_NAME,'|',ITEM_SHOP_MIC_L2_PRICE,' aUEC',']]')=MIC-L2,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L3_NAME,'|',ITEM_SHOP_MIC_L3_PRICE,' aUEC',']]')=MIC-L3,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L4_NAME,'|',ITEM_SHOP_MIC_L4_PRICE,' aUEC',']]')=MIC-L4,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L5_NAME,'|',ITEM_SHOP_MIC_L5_PRICE,' aUEC',']]')=MIC-L5
| |
− | |where=ITEM_SHOP_REF = '{{#external_value: ITEM_REF}}'
| |
− | |format=table
| |
| }} | | }} |