편집토론문서 역사

"TEST DB ACCESS"의 두 판 사이의 차이

1번째 줄: 1번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
−
|fields=CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME =Name,ITEM_SHOP_AREA18_PRICE =에어리어18,ITEM_SHOP_BAIJINI_PRICE=바이지니포인트,ITEM_SHOP_ARC_L1_PRICE =ARC-L1,ITEM_SHOP_ARC_L2_PRICE =ARC-L2,ITEM_SHOP_ARC_L3_PRICE =ARC-L3,ITEM_SHOP_ARC_L4_PRICE =ARC-L4,ITEM_SHOP_ARC_L5_PRICE =ARC-L5
+
|fields=CONCAT('[[',ITEM_SHOP_KOR_NAME ,']]')=이름, ITEM_SHOP_NAME =Name,
−
|where=ITEM_SHOP_REF ='e27da687-b025-4b82-97d5-58ce5c6e3181'
+
CONCAT('[[ITEM_SHOP_ORISON_NAME|',ITEM_SHOP_AREA18_PRICE,' aUEC',']]')=에어리어18,
−
|format=dynamic table
+
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: }}'
 +
|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: }}'
 +
|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: }}'
 +
|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: }}'
 +
|format=table
 
}}
 
}}

2022년 9월 12일 (월) 05:10 판

결과 없음


결과 없음


결과 없음

결과 없음