Differences

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

--- start:rpg:items_services:common [2020/06/04 11:20] – aretis
+++ start:rpg:items_services:common [2025/11/23 13:09] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Common items and services ======
+~~NOCACHE~~
+===== Supply =====
 <datatables>
-<sql>select Name, Category, Copper, STRING(Silver) + STRING(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>