Commands

Here is the plugin.yml section for the commands:

commands:
  select:
    description: Selects a single record from the database.
    usage: /select [*]/[fieldList] from [tableName] where [keyValue]
    permission: ChestDataBase.select
    permission-message: You don't have permission to run this command.
  update:
    description: Updates a single record in the database.
    usage: /update [tableName] [field=value&field2=value2...] where [keyValue]
    permission: ChestDataBase.update
    permission-message: You don't have permission to run this command.
  delete:
    description: Deletes a single record in the database.
    usage: /delete [tableName] where [keyValue]
    permission: ChestDataBase.delete
    permission-message: You don't have permission to run this command.

At the moment you can only select single rows from the database and only by the key for that table. For the default Players table that comes with the mod the player name is the key. Examples (table/field names as well as keywords are case-insensitive):

/select * from Players where malachi1616

/select Money,Bit1,Bit2 from Players where malachi1616

/update Players Money=1000&Bit1=true where malachi1616

/delete Players where malachi1616


Comments

Posts Quoted:
Reply
Clear All Quotes