Differences

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

--- start:rpg:items_services:common [2021/05/15 21: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="Supply", Price from common_items;</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, Category="Supply", Price from common_items;</sql>
+<sql>select Name, Price, Description from common_items where Category="Supply";</sql>
 </datatables>
-===== Housin =====
+===== Service =====
 <datatables>
-<sql>select Name, Category="Housing", Price from common_items;</sql>
+<sql>select Name, Price, Description from common_items where Category="Service";</sql>
 </datatables>
 ===== Accommodation =====
 <datatables>
-<sql>select Name, Category="Accommodation", Price from common_items;</sql>
+<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>