MVdW Placeholders - MySQL Placeholders

Aug 4, 2018
MVdW Placeholders - MySQL Placeholders
  • Since 10/01/2015 there are mysql placeholders. These are custom placeholder queries. They are meant if you want to load something from the database.

    placeholder_mysql.yml
    Code (Text):
    ## --------------------------------------- ##
    ## MySQL Placeholders
    ## --------------------------------------- ##

    ## Do not edit this config version
    config: 1

    # Placeholders under this list will have the prefix {mysql_.....}
    placeholders:
      example: # {mysql_example}
        # Description of the placeholder. Used for help message
        description: 'This is an example placeholder with MySQL queries'
        # Hostname of the database
        hostname: 'localhost'
        # Port of the database
        port: 3306
        # MySQL database
        database: 'minecraft'
        username: 'root'
        password: ''
        # A select query used to get 1 row and 1 column result
        query: "SELECT amount FROM MoneyTable WHERE player = '{playeruuid}'"
    Default the "Example" placeholder will be commented out. The query can contain any placeholder.

    For some explaining about this feature: https://www.spigotmc.org/threads/feather-board-mysql.83735/#post-921546
  • Loading...
  • Loading...