17번째 줄: 17번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP__PRICE=가격, ITEM_SHOP__SELL=판매여부
+
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_DAYMAR_PRICE=가격, ITEM_SHOP_DAYMAR_SELL=판매여부
|where= ITEM_SHOP__NAME='Brio's Breaker Yard' AND NOT ITEM_SHOP__PRICE IN (0)
+
|where= ITEM_SHOP__NAME='Brio's Breaker Yard' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0)
 
|column widths=
 
|column widths=
 
|format=dynamic table
 
|format=dynamic table
29번째 줄: 29번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP__PRICE=가격, ITEM_SHOP__SELL=판매여부
+
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_DAYMAR_PRICE=가격, ITEM_SHOP_DAYMAR_SELL=판매여부
|where= ITEM_SHOP__NAME='Bountiful Harvest Hydroponics' AND NOT ITEM_SHOP__PRICE IN (0)
+
|where= ITEM_SHOP__NAME='Bountiful Harvest Hydroponics' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0)
 
|column widths=
 
|column widths=
 
|format=dynamic table
 
|format=dynamic table
41번째 줄: 41번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP__PRICE=가격, ITEM_SHOP__SELL=판매여부
+
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_DAYMAR_PRICE=가격, ITEM_SHOP_DAYMAR_SELL=판매여부
|where= ITEM_SHOP__NAME='Nuen Waste Management' AND NOT ITEM_SHOP__PRICE IN (0)
+
|where= ITEM_SHOP__NAME='Nuen Waste Management' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0)
 
|column widths=
 
|column widths=
 
|format=dynamic table
 
|format=dynamic table
53번째 줄: 53번째 줄:
 
{{#cargo_query:
 
{{#cargo_query:
 
table=ITEM_SHOP
 
table=ITEM_SHOP
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP__PRICE=가격, ITEM_SHOP__SELL=판매여부
+
|fields= CONCAT('[[',ITEM_SHOP_KOR_NAME,']]')=이름, ITEM_SHOP_NAME=Name, ITEM_SHOP_DAYMAR_PRICE=가격, ITEM_SHOP_DAYMAR_SELL=판매여부
|where= ITEM_SHOP__NAME='ArcCorp Mining Area 141' AND NOT ITEM_SHOP__PRICE IN (0)
+
|where= ITEM_SHOP__NAME='ArcCorp Mining Area 141' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0)
 
|column widths=
 
|column widths=
 
|format=dynamic table
 
|format=dynamic table
 
}}
 
}}
 
</tabber>
 
</tabber>

2023년 2월 13일 (월) 18:54 판

상점 목록

Kudre Ore

Brio's Breaker Yard

Error: unclosed string literal.

Bountiful Harvest Hydroponics

Error 1054: Unknown column 'ITEM_SHOP__NAME' in 'where clause' (192.168.2.4:3307)

Function: CargoSQLQuery::run Query: SELECT `cargo__ITEM_SHOP`.`_pageID` AS `cargo_backlink_page_id_ITEM_SHOP`,CONCAT('',ITEM_SHOP_KOR_NAME,'') AS `이름`,`ITEM_SHOP_NAME` AS `Name`,`ITEM_SHOP_DAYMAR_PRICE` AS `가격`,`ITEM_SHOP_DAYMAR_SELL` AS `판매여부` FROM `cargo__ITEM_SHOP` WHERE ITEM_SHOP__NAME='Bountiful Harvest Hydroponics' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0) ORDER BY `cargo__ITEM_SHOP`.`_pageID`,CONCAT('',ITEM_SHOP_KOR_NAME,''),`ITEM_SHOP_NAME`,`ITEM_SHOP_DAYMAR_PRICE`,`ITEM_SHOP_DAYMAR_SELL`

Nuen Waste Management

Error 1054: Unknown column 'ITEM_SHOP__NAME' in 'where clause' (192.168.2.4:3307)

Function: CargoSQLQuery::run Query: SELECT `cargo__ITEM_SHOP`.`_pageID` AS `cargo_backlink_page_id_ITEM_SHOP`,CONCAT('',ITEM_SHOP_KOR_NAME,'') AS `이름`,`ITEM_SHOP_NAME` AS `Name`,`ITEM_SHOP_DAYMAR_PRICE` AS `가격`,`ITEM_SHOP_DAYMAR_SELL` AS `판매여부` FROM `cargo__ITEM_SHOP` WHERE ITEM_SHOP__NAME='Nuen Waste Management' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0) ORDER BY `cargo__ITEM_SHOP`.`_pageID`,CONCAT('',ITEM_SHOP_KOR_NAME,''),`ITEM_SHOP_NAME`,`ITEM_SHOP_DAYMAR_PRICE`,`ITEM_SHOP_DAYMAR_SELL`

ArcCorp Mining Area 141

Error 1054: Unknown column 'ITEM_SHOP__NAME' in 'where clause' (192.168.2.4:3307)

Function: CargoSQLQuery::run Query: SELECT `cargo__ITEM_SHOP`.`_pageID` AS `cargo_backlink_page_id_ITEM_SHOP`,CONCAT('',ITEM_SHOP_KOR_NAME,'') AS `이름`,`ITEM_SHOP_NAME` AS `Name`,`ITEM_SHOP_DAYMAR_PRICE` AS `가격`,`ITEM_SHOP_DAYMAR_SELL` AS `판매여부` FROM `cargo__ITEM_SHOP` WHERE ITEM_SHOP__NAME='ArcCorp Mining Area 141' AND NOT ITEM_SHOP_DAYMAR_PRICE IN (0) ORDER BY `cargo__ITEM_SHOP`.`_pageID`,CONCAT('',ITEM_SHOP_KOR_NAME,''),`ITEM_SHOP_NAME`,`ITEM_SHOP_DAYMAR_PRICE`,`ITEM_SHOP_DAYMAR_SELL`