Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
start:rpg:items_services:common [2021/05/15 21:22] aretis |
start:rpg:items_services:common [2021/05/16 17:27] (current) aretis |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Common items and services ====== | ====== Common items and services ====== | ||
| + | ~~NOCACHE~~ | ||
| ===== Supply ===== | ===== Supply ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Supply", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Supply";</sql> |
| </datatables> | </datatables> | ||
| ===== Consumable ===== | ===== Consumable ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Consumable", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Consumable";</sql> |
| </datatables> | </datatables> | ||
| ===== Transport ===== | ===== Transport ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Supply", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Supply";</sql> |
| </datatables> | </datatables> | ||
| ===== Service ===== | ===== Service ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Service", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Service";</sql> |
| </datatables> | </datatables> | ||
| ===== Accommodation ===== | ===== Accommodation ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Accommodation", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Accommodation";</sql> |
| </datatables> | </datatables> | ||
| ===== Transport ===== | ===== Transport ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Transport", Price from common_items;</sql> | + | <sql>select Name, Price, Description from common_items where Category="Transport";</sql> |
| </datatables> | </datatables> | ||
| ===== Housing ===== | ===== Housing ===== | ||
| <datatables> | <datatables> | ||
| - | <sql>select Name, Category="Housing", Price from common_items;</sql> | + | <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> | </datatables> | ||