편집토론문서 역사

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

1번째 줄: 1번째 줄:
−
{{#get_db_data:
+
{{#cargo_query:
−
db=ID
+
table=ITEM_SHOP
−
|from=cargo__ITEM_TRADE
+
|fields= ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격, ITEM_SHOP_AREA18_SELL=판매가능
−
|where='고철'=ITEM_TRADE_KOR_NAME
+
|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'
−
|data=ITEM_TRADE_NAME=ITEM_TRADE_NAME, ITEM_TRADE_KOR_NAME=ITEM_TRADE_KOR_NAME, ITEM_TRADE_MANUFACTURER=ITEM_TRADE_MANUFACTURER, ITEM_TRADE_TYPE=ITEM_TRADE_TYPE, ITEM_TRADE_REF=ITEM_TRADE_REF
+
|column widths=
−
}}
+
|format=dynamic table
−
{{#get_db_data:
 
−
db=ID
 
−
|from=ITEM_SHOP
 
−
|where='Scrap'=ITEM_SHOP_NAME
 
−
|data=ITEM_SHOP_CLASS=ITEM_SHOP_CLASS,
 
−
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_TRADE_KOR_NAME}}
 
−
|원어이름 = {{#external_value: ITEM_TRADE_NAME}}
 
−
|분류 = {{#external_value: ITEM_TRADE_TYPE}}
 
−
}}
 
−
==인게임 설명==
 
−
 
 
−
==판매 장소==
 
−
{{틀:교역품가격
 
−
|NAME={{#external_value: ITEM_TRADE_NAME}}
 
 
}}
 
}}

2023년 2월 13일 (월) 08:14 판

Name 가격 판매가능
Name 가격 판매가능
agricium 23 O
agriculturalsupplies 0 -
altruciatoxin 0 -
altruciatoxin_unprocessed 2 O
aluminum 3 O
amioshiplague 13 O
aphorite 1,525 O
astatine 9 O
bexalite 68 O
borase 31 O
chlorine 2 O
compboard 22 O
constructionmaterials 125 O
copper 3 O
degnousroot 13 O
distilledspirits 6 O
dolivine 1,300 O
electronicsequipment 250 O
etam 0 -
fluorine 3 O
gaspingweevileggs 0 -
gold 65 O
goldenmedmon 20 O
hadanite 2,750 O
heartofthewoods 22 O
helium 0 -
hephaestanite 25 O
hydrogen 0 -
igp_atlasium 31 O
igp_beryl 24 O
igp_corundum 3 O
igp_diamond 43 O
igp_dymantium 26 O
igp_inert_materials 0 O
igp_laranite 25 O
igp_quartz 4 O
igp_titanium 4 O
iodine 0 O
iron 3 O
janalite 176,760 O
maze 0 -
medicalsupplies 19 O
neon 0 -
ore_agricium 0 -
ore_aluminum 0 -
ore_borase 0 -
ore_copper 0 -
ore_gold 0 -
ore_iron 0 -
osoianhides 0 -
partyfavors 0 -
pitambu 16 O
processedfood 2 O
prota 14 O
quantanium 223 O
rantadung 44 O
raw_beryl 0 -
raw_bexalite 0 -
raw_corundum 0 -
raw_diamond 0 -
raw_hephaestanite 0 -
raw_laranite 0 -
raw_quantainium 0 -
raw_quartz 0 -
raw_taranite 0 -
revenantpod 17 O
rmc 77 X
scrap 2 X
slam 0 -
souvenirs 10 O
special_holidaybox 500 O
special_holidayletter 500 O
stims 4 O
sunset_berry 14 O
taranite 69 O
titanium_ore 0 -
tungsten 4 O
tungsten_ore 0 -
waste 0 X
widow 0 -