편집토론문서 역사

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

1번째 줄: 1번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
−
|fields= ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격, ITEM_SHOP_AREA18_SELL=판매가능
+
|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=판매여부
 
|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='고철' 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'
 
|column widths=
 
|column widths=
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}

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

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