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

1번째 줄: 1번째 줄:
<tabber>
 
|-|전체=
 
 
{{#cargo_query:
 
{{#cargo_query:
table=ITEM_SHOP
+
table=ITEM_ETC
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,  
+
|fields=CONCAT('[[',ITEM_TRADE_KOR_NAME,']]')=이름, ITEM_TRADE_NAME=NAME, ITEM_TRADE_TYPE=타입, ITEM_TRADE_MANUFACTURER=제조사
|where= ITEM_SHOP_AREA18_NAME='Cubby Blast' AND NOT ITEM_SHOP_AREA18_PRICE IN (0)
 
|column widths=
 
 
|format=dynamic table
 
|format=dynamic table
 +
|column widths=90px,90px,30px,40px
 
}}
 
}}
|-|총기=
 
{{#cargo_query:
 
table=ITEM_SHOP
 
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,
 
|where=ITEM_SHOP_AREA18_NAME='Cubby Blast' AND ITEM_SHOP_TYPE='WeaponPersonal' AND NOT ITEM_SHOP_AREA18_PRICE IN (0)
 
|column widths=
 
|format=dynamic table
 
}}
 
|-|부착물=
 
{{#cargo_query:
 
table=ITEM_SHOP
 
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,
 
|where=ITEM_SHOP_AREA18_NAME='Cubby Blast' AND ITEM_SHOP_TYPE='WeaponAttachment' AND NOT ITEM_SHOP_AREA18_PRICE IN (0)
 
|column widths=
 
|format=dynamic table
 
}}
 
|-|방어구=
 
{{#cargo_query:
 
table=ITEM_SHOP
 
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_AREA18_PRICE=가격,
 
|where=ITEM_SHOP_AREA18_NAME='Cubby Blast' AND ITEM_SHOP_TYPE='Char_Clothing_Torso_0' OR ITEM_SHOP_TYPE='Char_Clothing_Legs' OR  ITEM_SHOP_TYPE='Char_Clothing_Feet' OR ITEM_SHOP_TYPE='Char_Armor_Helmet' OR ITEM_SHOP_TYPE='Char_Clothing_Torso_1' OR ITEM_SHOP_TYPE='Char_Armor_Undersuit' OR ITEM_SHOP_TYPE='Char_Armor_Legs' OR ITEM_SHOP_TYPE='Char_Armor_Torso' OR ITEM_SHOP_TYPE='Char_Clothing_Hands' OR ITEM_SHOP_TYPE='Char_Armor_Arms' OR ITEM_SHOP_TYPE='Char_Armor_Backpack' AND NOT ITEM_SHOP_AREA18_PRICE IN (0)
 
|column widths=
 
|format=dynamic table
 
}}
 
</tabber>
 

2023년 2월 12일 (일) 22:56 판

오류: 지정된 데이터베이스 테이블 중 어느 곳에서도 "ITEM_TRADE_NAME" 필드를 찾을 수 없습니다.