편집토론문서 역사

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

1번째 줄: 1번째 줄:
−
{{#cargo_query:
+
{{#get_db_data:
−
table=ITEM_SHOP
+
db=ID
−
|fields= ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격, ITEM_SHOP_AREA18_SELL=판매여부, ITEM_SHOP_BAIJINI_SELL=판매여부, ITEM_SHOP_ARC_L1_SELL=판매여부, ITEM_SHOP_ARC_L2_SELL=판매여부, ITEM_SHOP_ARC_L3_SELL=판매여부, ITEM_SHOP_ARC_L4_SELL=판매여부, ITEM_SHOP_ARC_L5_SELL=판매여부, ITEM_SHOP_LORVILLE_SELL=판매여부, ITEM_SHOP_EVERUS_SELL=판매여부, ITEM_SHOP_HUR_L1_SELL=판매여부, ITEM_SHOP_HUR_L2_SELL=판매여부, ITEM_SHOP_HUR_L3_SELL=판매여부, ITEM_SHOP_HUR_L4_SELL=판매여부, ITEM_SHOP_HUR_L5_SELL=판매여부, ITEM_SHOP_NEW_BABBAGE_SELL=판매여부, ITEM_SHOP_TRESSLER_SELL=판매여부, ITEM_SHOP_MIC_L1_SELL=판매여부, ITEM_SHOP_MIC_L2_SELL=판매여부, ITEM_SHOP_MIC_L3_SELL=판매여부, ITEM_SHOP_MIC_L4_SELL=판매여부, ITEM_SHOP_MIC_L5_SELL=판매여부, ITEM_SHOP_ORISON_SELL=판매여부, ITEM_SHOP_OLISAR_SELL=판매여부, ITEM_SHOP_CRU_L1_SELL=판매여부, ITEM_SHOP_CRU_L2_SELL=판매여부, ITEM_SHOP_CRU_L3_SELL=판매여부, ITEM_SHOP_CRU_L4_SELL=판매여부, ITEM_SHOP_CRU_L5_SELL=판매여부, ITEM_SHOP_GRIM_SELL=판매여부, ITEM_SHOP_DAYMAR_SELL=판매여부, ITEM_SHOP_CELLIN_SELL=판매여부, ITEM_SHOP_YELA_SELL=판매여부, ITEM_SHOP_ARIAL_SELL=판매여부, ITEM_SHOP_ABERDEEN_SELL=판매여부, ITEM_SHOP_MAGDA_SELL=판매여부, ITEM_SHOP_ITA_SELL=판매여부, ITEM_SHOP_HURSTON_SELL=판매여부, ITEM_SHOP_LYRIA_SELL=판매여부, ITEM_SHOP_WALA_SELL=판매여부, ITEM_SHOP_MICROTECH_SELL=판매여부, ITEM_SHOP_CALLIOPE_SELL=판매여부, ITEM_SHOP_CLIO_SELL=판매여부, ITEM_SHOP_TERRA_SELL=판매여부, ITEM_SHOP_EUTERPE_SELL=판매여부, ITEM_SHOP_DELAMAR_SELL=판매여부
+
|from=cargo__ITEM_SHOP
−
|where= ITEM_SHOP_KOR_NAME='고철' AND NOT ITEM_SHOP_AREA18_PRICE IN (0) OR ITEM_SHOP_AREA18_SELL='O' OR ITEM_SHOP_BAIJINI_SELL='O' OR ITEM_SHOP_ARC_L1_SELL='O' OR ITEM_SHOP_ARC_L2_SELL='O' OR ITEM_SHOP_ARC_L3_SELL='O' OR ITEM_SHOP_ARC_L4_SELL='O' OR ITEM_SHOP_ARC_L5_SELL='O' OR ITEM_SHOP_LORVILLE_SELL='O' OR ITEM_SHOP_EVERUS_SELL='O' OR ITEM_SHOP_HUR_L1_SELL='O' OR ITEM_SHOP_HUR_L2_SELL='O' OR ITEM_SHOP_HUR_L3_SELL='O' OR ITEM_SHOP_HUR_L4_SELL='O' OR ITEM_SHOP_HUR_L5_SELL='O' OR ITEM_SHOP_NEW_BABBAGE_SELL='O' OR ITEM_SHOP_TRESSLER_SELL='O' OR ITEM_SHOP_MIC_L1_SELL='O' OR ITEM_SHOP_MIC_L2_SELL='O' OR ITEM_SHOP_MIC_L3_SELL='O' OR ITEM_SHOP_MIC_L4_SELL='O' OR ITEM_SHOP_MIC_L5_SELL='O' OR ITEM_SHOP_ORISON_SELL='O' OR ITEM_SHOP_OLISAR_SELL='O' OR ITEM_SHOP_CRU_L1_SELL='O' OR ITEM_SHOP_CRU_L2_SELL='O' OR ITEM_SHOP_CRU_L3_SELL='O' OR ITEM_SHOP_CRU_L4_SELL='O' OR ITEM_SHOP_CRU_L5_SELL='O' OR ITEM_SHOP_GRIM_SELL='O' OR ITEM_SHOP_DAYMAR_SELL='O' OR ITEM_SHOP_CELLIN_SELL='O' OR ITEM_SHOP_YELA_SELL='O' OR ITEM_SHOP_ARIAL_SELL='O' OR ITEM_SHOP_ABERDEEN_SELL='O' OR ITEM_SHOP_MAGDA_SELL='O' OR ITEM_SHOP_ITA_SELL='O' OR ITEM_SHOP_HURSTON_SELL='O' OR ITEM_SHOP_LYRIA_SELL='O' OR ITEM_SHOP_WALA_SELL='O' OR ITEM_SHOP_MICROTECH_SELL='O' OR ITEM_SHOP_CALLIOPE_SELL='O' OR ITEM_SHOP_CLIO_SELL='O' OR ITEM_SHOP_TERRA_SELL='O' OR ITEM_SHOP_EUTERPE_SELL='O' OR ITEM_SHOP_DELAMAR_SELL='O'
+
|where='염소'=ITEM_SHOP_KOR_NAME
−
|column widths=
+
|data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS,
−
|format=dynamic table
+
ITEM_SHOP_TYPE=ITEM_SHOP_TYPE,ITEM_SHOP_AREA18_NAME=ITEM_SHOP_AREA18_NAME,ITEM_SHOP_AREA18_CLASS=ITEM_SHOP_AREA18_CLASS,ITEM_SHOP_AREA18_PRICE=ITEM_SHOP_AREA18_PRICE,ITEM_SHOP_BAIJINI_NAME=ITEM_SHOP_BAIJINI_NAME,ITEM_SHOP_BAIJINI_CLASS=ITEM_SHOP_BAIJINI_CLASS,ITEM_SHOP_BAIJINI_PRICE=ITEM_SHOP_BAIJINI_PRICE,ITEM_SHOP_ARC_L1_NAME=ITEM_SHOP_ARC_L1_NAME,ITEM_SHOP_ARC_L1_CLASS=ITEM_SHOP_ARC_L1_CLASS,ITEM_SHOP_ARC_L1_PRICE=ITEM_SHOP_ARC_L1_PRICE,ITEM_SHOP_ARC_L2_NAME=ITEM_SHOP_ARC_L2_NAME,ITEM_SHOP_ARC_L2_CLASS=ITEM_SHOP_ARC_L2_CLASS,ITEM_SHOP_ARC_L2_PRICE=ITEM_SHOP_ARC_L2_PRICE,ITEM_SHOP_ARC_L3_NAME=ITEM_SHOP_ARC_L3_NAME,ITEM_SHOP_ARC_L3_CLASS=ITEM_SHOP_ARC_L3_CLASS,ITEM_SHOP_ARC_L3_PRICE=ITEM_SHOP_ARC_L3_PRICE,ITEM_SHOP_ARC_L4_NAME=ITEM_SHOP_ARC_L4_NAME,ITEM_SHOP_ARC_L4_CLASS=ITEM_SHOP_ARC_L4_CLASS,ITEM_SHOP_ARC_L4_PRICE=ITEM_SHOP_ARC_L4_PRICE,ITEM_SHOP_ARC_L5_NAME=ITEM_SHOP_ARC_L5_NAME,ITEM_SHOP_ARC_L5_CLASS=ITEM_SHOP_ARC_L5_CLASS,ITEM_SHOP_ARC_L5_PRICE=ITEM_SHOP_ARC_L5_PRICE,ITEM_SHOP_LORVILLE_NAME=ITEM_SHOP_LORVILLE_NAME,ITEM_SHOP_LORVILLE_CLASS=ITEM_SHOP_LORVILLE_CLASS,ITEM_SHOP_LORVILLE_PRICE=ITEM_SHOP_LORVILLE_PRICE,ITEM_SHOP_EVERUS_NAME=ITEM_SHOP_EVERUS_NAME,ITEM_SHOP_EVERUS_CLASS=ITEM_SHOP_EVERUS_CLASS,ITEM_SHOP_EVERUS_PRICE=ITEM_SHOP_EVERUS_PRICE,ITEM_SHOP_HUR_L1_NAME=ITEM_SHOP_HUR_L1_NAME,ITEM_SHOP_HUR_L1_CLASS=ITEM_SHOP_HUR_L1_CLASS,ITEM_SHOP_HUR_L1_PRICE=ITEM_SHOP_HUR_L1_PRICE,ITEM_SHOP_HUR_L2_NAME=ITEM_SHOP_HUR_L2_NAME,ITEM_SHOP_HUR_L2_CLASS=ITEM_SHOP_HUR_L2_CLASS,ITEM_SHOP_HUR_L2_PRICE=ITEM_SHOP_HUR_L2_PRICE,ITEM_SHOP_HUR_L3_NAME=ITEM_SHOP_HUR_L3_NAME,ITEM_SHOP_HUR_L3_CLASS=ITEM_SHOP_HUR_L3_CLASS,ITEM_SHOP_HUR_L3_PRICE=ITEM_SHOP_HUR_L3_PRICE,ITEM_SHOP_HUR_L4_NAME=ITEM_SHOP_HUR_L4_NAME,ITEM_SHOP_HUR_L4_CLASS=ITEM_SHOP_HUR_L4_CLASS,ITEM_SHOP_HUR_L4_PRICE=ITEM_SHOP_HUR_L4_PRICE,ITEM_SHOP_HUR_L5_NAME=ITEM_SHOP_HUR_L5_NAME,ITEM_SHOP_HUR_L5_CLASS=ITEM_SHOP_HUR_L5_CLASS,ITEM_SHOP_HUR_L5_PRICE=ITEM_SHOP_HUR_L5_PRICE,ITEM_SHOP_NEW_BABBAGE_NAME=ITEM_SHOP_NEW_BABBAGE_NAME,ITEM_SHOP_NEW_BABBAGE_CLASS=ITEM_SHOP_NEW_BABBAGE_CLASS,ITEM_SHOP_NEW_BABBAGE_PRICE=ITEM_SHOP_NEW_BABBAGE_PRICE,ITEM_SHOP_TRESSLER_NAME=ITEM_SHOP_TRESSLER_NAME,ITEM_SHOP_TRESSLER_CLASS=ITEM_SHOP_TRESSLER_CLASS,ITEM_SHOP_TRESSLER_PRICE=ITEM_SHOP_TRESSLER_PRICE,ITEM_SHOP_MIC_L1_NAME=ITEM_SHOP_MIC_L1_NAME,ITEM_SHOP_MIC_L1_CLASS=ITEM_SHOP_MIC_L1_CLASS,ITEM_SHOP_MIC_L1_PRICE=ITEM_SHOP_MIC_L1_PRICE,ITEM_SHOP_MIC_L2_NAME=ITEM_SHOP_MIC_L2_NAME,ITEM_SHOP_MIC_L2_CLASS=ITEM_SHOP_MIC_L2_CLASS,ITEM_SHOP_MIC_L2_PRICE=ITEM_SHOP_MIC_L2_PRICE,ITEM_SHOP_MIC_L3_NAME=ITEM_SHOP_MIC_L3_NAME,ITEM_SHOP_MIC_L3_CLASS=ITEM_SHOP_MIC_L3_CLASS,ITEM_SHOP_MIC_L3_PRICE=ITEM_SHOP_MIC_L3_PRICE,ITEM_SHOP_MIC_L4_NAME=ITEM_SHOP_MIC_L4_NAME,ITEM_SHOP_MIC_L4_CLASS=ITEM_SHOP_MIC_L4_CLASS,ITEM_SHOP_MIC_L4_PRICE=ITEM_SHOP_MIC_L4_PRICE,ITEM_SHOP_MIC_L5_NAME=ITEM_SHOP_MIC_L5_NAME,ITEM_SHOP_MIC_L5_CLASS=ITEM_SHOP_MIC_L5_CLASS,ITEM_SHOP_MIC_L5_PRICE=ITEM_SHOP_MIC_L5_PRICE,ITEM_SHOP_ORISON_NAME=ITEM_SHOP_ORISON_NAME,ITEM_SHOP_ORISON_CLASS=ITEM_SHOP_ORISON_CLASS,ITEM_SHOP_ORISON_PRICE=ITEM_SHOP_ORISON_PRICE,ITEM_SHOP_OLISAR_NAME=ITEM_SHOP_OLISAR_NAME,ITEM_SHOP_OLISAR_CLASS=ITEM_SHOP_OLISAR_CLASS,ITEM_SHOP_OLISAR_PRICE=ITEM_SHOP_OLISAR_PRICE,ITEM_SHOP_CRU_L1_NAME=ITEM_SHOP_CRU_L1_NAME,ITEM_SHOP_CRU_L1_CLASS=ITEM_SHOP_CRU_L1_CLASS,ITEM_SHOP_CRU_L1_PRICE=ITEM_SHOP_CRU_L1_PRICE,ITEM_SHOP_CRU_L2_NAME=ITEM_SHOP_CRU_L2_NAME,ITEM_SHOP_CRU_L2_CLASS=ITEM_SHOP_CRU_L2_CLASS,ITEM_SHOP_CRU_L2_PRICE=ITEM_SHOP_CRU_L2_PRICE,ITEM_SHOP_CRU_L3_NAME=ITEM_SHOP_CRU_L3_NAME,ITEM_SHOP_CRU_L3_CLASS=ITEM_SHOP_CRU_L3_CLASS,ITEM_SHOP_CRU_L3_PRICE=ITEM_SHOP_CRU_L3_PRICE,ITEM_SHOP_CRU_L4_NAME=ITEM_SHOP_CRU_L4_NAME,ITEM_SHOP_CRU_L4_CLASS=ITEM_SHOP_CRU_L4_CLASS,ITEM_SHOP_CRU_L4_PRICE=ITEM_SHOP_CRU_L4_PRICE,ITEM_SHOP_CRU_L5_NAME=ITEM_SHOP_CRU_L5_NAME,ITEM_SHOP_CRU_L5_CLASS=ITEM_SHOP_CRU_L5_CLASS,ITEM_SHOP_CRU_L5_PRICE=ITEM_SHOP_CRU_L5_PRICE,ITEM_SHOP_GRIM_NAME=ITEM_SHOP_GRIM_NAME,ITEM_SHOP_GRIM_PRICE=ITEM_SHOP_GRIM_PRICE, ITEM_SHOP_GRIM_CLASS=ITEM_SHOP_GRIM_CLASS,ITEM_SHOP_DAYMAR_NAME=ITEM_SHOP_DAYMAR_NAME, ITEM_SHOP_DAYMAR_PRICE= ITEM_SHOP_DAYMAR_PRICE, ITEM_SHOP_DAYMAR_CLASS= ITEM_SHOP_DAYMAR_CLASS, ITEM_SHOP_CELLIN_NAME= ITEM_SHOP_CELLIN_NAME, ITEM_SHOP_CELLIN_PRICE= ITEM_SHOP_CELLIN_PRICE, ITEM_SHOP_CELLIN_CLASS= ITEM_SHOP_CELLIN_CLASS, ITEM_SHOP_YELA_NAME= ITEM_SHOP_YELA_NAME, ITEM_SHOP_YELA_PRICE= ITEM_SHOP_YELA_PRICE, ITEM_SHOP_YELA_CLASS= ITEM_SHOP_YELA_CLASS, ITEM_SHOP_ARIAL_NAME= ITEM_SHOP_ARIAL_NAME, ITEM_SHOP_ARIAL_PRICE= ITEM_SHOP_ARIAL_PRICE, ITEM_SHOP_ARIAL_CLASS= ITEM_SHOP_ARIAL_CLASS, ITEM_SHOP_ABERDEEN_NAME= ITEM_SHOP_ABERDEEN_NAME, ITEM_SHOP_ABERDEEN_PRICE= ITEM_SHOP_ABERDEEN_PRICE, ITEM_SHOP_ABERDEEN_CLASS= ITEM_SHOP_ABERDEEN_CLASS, ITEM_SHOP_MAGDA_NAME= ITEM_SHOP_MAGDA_NAME, ITEM_SHOP_MAGDA_PRICE= ITEM_SHOP_MAGDA_PRICE, ITEM_SHOP_MAGDA_CLASS= ITEM_SHOP_MAGDA_CLASS, ITEM_SHOP_ITA_NAME= ITEM_SHOP_ITA_NAME, ITEM_SHOP_ITA_PRICE= ITEM_SHOP_ITA_PRICE, ITEM_SHOP_ITA_CLASS= ITEM_SHOP_ITA_CLASS, ITEM_SHOP_HURSTON_NAME= ITEM_SHOP_HURSTON_NAME, ITEM_SHOP_HURSTON_PRICE= ITEM_SHOP_HURSTON_PRICE, ITEM_SHOP_HURSTON_CLASS= ITEM_SHOP_HURSTON_CLASS, ITEM_SHOP_LYRIA_NAME= ITEM_SHOP_LYRIA_NAME, ITEM_SHOP_LYRIA_PRICE= ITEM_SHOP_LYRIA_PRICE, ITEM_SHOP_LYRIA_CLASS= ITEM_SHOP_LYRIA_CLASS, ITEM_SHOP_WALA_NAME= ITEM_SHOP_WALA_NAME, ITEM_SHOP_WALA_PRICE= ITEM_SHOP_WALA_PRICE, ITEM_SHOP_WALA_CLASS= ITEM_SHOP_WALA_CLASS, ITEM_SHOP_MICROTECH_NAME= ITEM_SHOP_MICROTECH_NAME, ITEM_SHOP_MICROTECH_PRICE= ITEM_SHOP_MICROTECH_PRICE, ITEM_SHOP_MICROTECH_CLASS= ITEM_SHOP_MICROTECH_CLASS, ITEM_SHOP_CALLIOPE_NAME= ITEM_SHOP_CALLIOPE_NAME, ITEM_SHOP_CALLIOPE_PRICE= ITEM_SHOP_CALLIOPE_PRICE, ITEM_SHOP_CALLIOPE_CLASS= ITEM_SHOP_CALLIOPE_CLASS, ITEM_SHOP_CLIO_NAME= ITEM_SHOP_CLIO_NAME, ITEM_SHOP_CLIO_PRICE= ITEM_SHOP_CLIO_PRICE, ITEM_SHOP_CLIO_CLASS= ITEM_SHOP_CLIO_CLASS, ITEM_SHOP_TERRA_NAME= ITEM_SHOP_TERRA_NAME, ITEM_SHOP_TERRA_PRICE= ITEM_SHOP_TERRA_PRICE, ITEM_SHOP_TERRA_CLASS= ITEM_SHOP_TERRA_CLASS, ITEM_SHOP_EUTERPE_NAME= ITEM_SHOP_EUTERPE_NAME, ITEM_SHOP_EUTERPE_PRICE= ITEM_SHOP_EUTERPE_PRICE, ITEM_SHOP_EUTERPE_CLASS= ITEM_SHOP_EUTERPE_CLASS, ITEM_SHOP_DELAMAR_NAME= ITEM_SHOP_DELAMAR_NAME, ITEM_SHOP_DELAMAR_PRICE= ITEM_SHOP_DELAMAR_PRICE, ITEM_SHOP_DELAMAR_CLASS= ITEM_SHOP_DELAMAR_CLASS}}
 +
 
 +
{{틀:아이템 정보
 +
|이름={{#external_value: ITEM_SHOP_KOR_NAME}}
 +
|원어이름 = {{#external_value: ITEM_SHOP_NAME}}
 +
|분류 = {{#external_value: ITEM_SHOP_TYPE}}
 +
}}
 +
==판매 장소==
 +
{{틀:교역품가격
 +
|NAME={{#external_value: ITEM_TRADE_NAME}}
 
}}
 
}}

2023년 2월 13일 (월) 21:05 판


오류: 지역 변수가 설정되어 있지 않습니다.
오류: 지역 변수가 설정되어 있지 않습니다.
아이템 정보
이름 오류: 지역 변수가 설정되어 있지 않습니다.
분류 -

판매 장소

  • 아크콥

결과 없음

  • 허스턴

결과 없음

  • 크루세이더

결과 없음

  • 마이크로텍

결과 없음