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.