|
|
(같은 사용자의 중간 판 7개는 보이지 않습니다) |
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)== |
− | | + | {{틀:아이템가격 |
− | === 아크콥 ===
| + | |REF={{#external_value: ITEM_REF}} |
− | {{#cargo_query: | |
− | table=ITEM_SHOP
| |
− | |fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
| |
− | CONCAT('[[',ITEM_SHOP_AREA18_NAME,'|',ITEM_SHOP_AREA18_PRICE,']]')=에어리어18,
| |
− | CONCAT('[[',ITEM_SHOP_BAIJINI_NAME,'|',ITEM_SHOP_BAIJINI_PRICE,']]')=바이지니 포인트,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L1_NAME,'|',ITEM_SHOP_ARC_L1_PRICE,']]')=ARC-L1,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L2_NAME,'|',ITEM_SHOP_ARC_L2_PRICE,']]')=ARC-L2,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L3_NAME,'|',ITEM_SHOP_ARC_L3_PRICE,']]')=ARC-L3,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L4_NAME,'|',ITEM_SHOP_ARC_L4_PRICE,']]')=ARC-L4,
| |
− | CONCAT('[[',ITEM_SHOP_ARC_L5_NAME,'|',ITEM_SHOP_ARC_L5_PRICE,']]')=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,']]')=로어빌,
| |
− | CONCAT('[[',ITEM_SHOP_EVERUS_NAME,'|',ITEM_SHOP_EVERUS_PRICE ,']]')=에버러스 하버,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L1_NAME,'|',ITEM_SHOP_HUR_L1_PRICE,']]')=HUR-L1,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L2_NAME,'|',ITEM_SHOP_HUR_L2_PRICE,']]')=HUR-L2,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L3_NAME,'|',ITEM_SHOP_HUR_L3_PRICE,']]')=HUR-L3,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L4_NAME,'|',ITEM_SHOP_HUR_L4_PRICE,']]')=HUR-L4,
| |
− | CONCAT('[[',ITEM_SHOP_HUR_L5_NAME,'|',ITEM_SHOP_HUR_L5_PRICE,']]')=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,']]')=오리슨,
| |
− | CONCAT('[[',ITEM_SHOP_OLISAR_NAME,'|',ITEM_SHOP_OLISAR_PRICE,']]')=포트 올리사,
| |
− | CONCAT('[[',ITEM_SHOP_GRIM_NAME,'|',ITEM_SHOP_GRIM_PRICE,']]')=그림 헥스,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L1_NAME,'|',ITEM_SHOP_CRU_L1_PRICE,']]')=CRU-L1,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L2_NAME,'|',ITEM_SHOP_CRU_L2_PRICE,']]')=CRU-L2,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L3_NAME,'|',ITEM_SHOP_CRU_L3_PRICE,']]')=CRU-L3,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L4_NAME,'|',ITEM_SHOP_CRU_L4_PRICE,']]')=CRU-L4,
| |
− | CONCAT('[[',ITEM_SHOP_CRU_L5_NAME,'|',ITEM_SHOP_CRU_L5_PRICE,']]')=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_NEW_BABBAGE_NAME,'|',ITEM_SHOP_NEW_BABBAGE_PRICE,']]')=뉴 배비지,
| |
− | CONCAT('[[',ITEM_SHOP_TRESSLER_NAME,'|',ITEM_SHOP_TRESSLER_PRICE,']]')=포트 트레슬러,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L1_NAME,'|',ITEM_SHOP_MIC_L1_PRICE,']]')=MIC-L1,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L2_NAME,'|',ITEM_SHOP_MIC_L2_PRICE,']]')=MIC-L2,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L3_NAME,'|',ITEM_SHOP_MIC_L3_PRICE,']]')=MIC-L3,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L4_NAME,'|',ITEM_SHOP_MIC_L4_PRICE,']]')=MIC-L4,
| |
− | CONCAT('[[',ITEM_SHOP_MIC_L5_NAME,'|',ITEM_SHOP_MIC_L5_PRICE,']]')=MIC-L5
| |
− | |where=ITEM_SHOP_REF = '{{#external_value: ITEM_REF}}'
| |
− | |format=table
| |
| }} | | }} |