ChestShopDB
ChestShopDB records ChestShop shop information into either a MySQL or an SQLite database.
Please note: While it is needed for ChestShopDB to function, ChestShop is NOT bundled with ChestShopDB. Grab Chestshop here.
Table Structure
The current data recorded for shops is as follows:| Field | Data Type | Description |
|---|---|---|
| owner | varchar(16) | The shop owner's name. |
| adminShop | boolean | Whether the shop is an Admin shop or not. |
| itemId | int | The data value of the traded item. |
| stock | int | The remaining stock left in the shop's chest. |
| buyPrice | double | The price that the player has to <big>pay</big>. |
| sellPrice | double | The price that the player will <big>receive</big>. |
| quantity | int | The quantity that the shop buys and/or sells. |
| world | varchar(50) | The world that the shop's <big>sign</big> resides in. |
| x | double | The x coordinate of the shop's <big>sign</big>. |
| y | double | The y coordinate of the shop's <big>sign</big>. |
| z | double | The z coordinate of the shop's <big>sign</big>. |
Source
The source can be viewed here.
Comments
-
_ForgeUser6904466 Owner
-
View User Profile
-
Send Message
Posted Jan 10, 2014@Prawny
Couldn't the table just be altered to include the new column? SQL queries using a date/time stamp won't return rows where that value is null, so it would essentially be the same as having two tables only more efficient.
-
View User Profile
-
Send Message
Posted Jan 4, 2014@wyatt94
You can, as each transaction is recorded, however they aren't stored with a timestamp... I could add one if you need it, but it would need a new table to be created due to the new date/time field.
-
View User Profile
-
Send Message
Posted Dec 23, 2013Can I use this to search all chestshop transactions? I want to track what players are buying and selling.