Differences

This shows you the differences between two versions of the page.

--- start:rpg:items_services:common [2020/06/04 11:25]
aretis
+++ start:rpg:items_services:common [2021/05/16 17:27] (current)
aretis
@@ Line 1: / Line 1: @@
 ====== Common items and services ======
+~~NOCACHE~~
+===== Supply =====
 <datatables>
-<sql>select Name, Category, cast(Copper as varchar(10)), Silver + Gold from Common;</sql>
+<sql>select Name, Price, Description from common_items where Category="Supply";</sql>
 </datatables>
+===== Consumable =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Consumable";</sql>
+</datatables>
+===== Transport =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Supply";</sql>
+</datatables>
+===== Service =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Service";</sql>
+</datatables>
+===== Accommodation =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Accommodation";</sql>
+</datatables>
+===== Transport =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Transport";</sql>
+</datatables>
+===== Housing =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Housing";</sql>
+</datatables>
+===== Food&Drink =====
+<datatables>
+<sql>select Name, Price, Description from common_items where Category="Food&Drink";</sql>
+</datatables>