[INACTIVE][ADMN/INFO/DEV/WEB] SQLStats 0.1.1 - Data in an SQL Table [860]

Discussion in 'Inactive/Unsupported Plugins' started by Omri Barak, Jun 5, 2011.

  1. Offline

    Omri Barak

    SQLStats 0.1.1
    v0.1 Game data storage in a table


    Features:
    • Gets several types of player data
    • Refreshes every minute
    • Has several logging blacklists/whitelists, so you can decide what gets stored, and what doesn't
    • Stored in SQL, so most web languages can retrieve it
    • Easy to integrate into your websites

    Data stored in SQL Tables:
    id - The number that indicates when the player was logged in the database
    name - The player's name
    world - The world the player is currently in
    x - The player's North/South orientation
    z - The player's East/West orientation
    y - The player's Up/Down orientation
    health - The player's health, out of 10


    Download:
    Jar - v0.1.1
    Earlier Versions - v0.1
    Source - Github


    Settings Files:
    After the plugin is launched, it creates Five files:
    A Player Blacklist - The players listed in this file don't get logged in the databse; the id still skips a number.
    A Player Whitelist - The players listed in this file do get logged - Only one player list can be active at a time.
    A World Blacklist - The worlds listed in this file don't get logged, and don't log players in said world; the id still skips a number.
    A World Whitelist - The worlds listed in this file do get logged - Only one world list can be active at a time.
    config.yml - The file that describes the logging process. It has the database name, the SQL username, and the SQL password, all of which you might want to set. This also is the file where you enable/disable your whitelists and blacklists.


    Future Plans:
    • Retrieve more data
    • Allow players to add or remove themselves from the whitelist/blacklist
    • Allow admins/ops to change which worlds get logged
    • Hook in permissions support

    Changelog
    • v0.1.1 - Built on top of RB 860
    • v0.1 - Created the plugin
    It's not a 100% perfect plugin (Probably). If you see an error: PLEASE tell me where, and copy/paste the error. If I don't know where the error is coming from, I can't help you!
     
  2. Offline

    captainawesome7

    kahlilnc likes this.
  3. Offline

    Omri Barak

  4. Offline

    captainawesome7

    @Omri Barak I didn't say content, I said formatting. It's terrible. The fact that you put in spoilers made it terrible.
     
  5. Offline

    Omri Barak

    oh

    Better?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
  6. Offline

    Plague

    looks ok
    Oh, believe me, you haven't seen those I did :D
     
  7. Offline

    Omri Barak

    Lol

    you like the plugin?

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 16, 2016
  8. Offline

    ReaZaaa

    Works fine! Thx for it, man :D
     
  9. Offline

    Omri Barak

    I'm also doing plugin requests, of you want me to make you a plugin, just ask
     
  10. Is this running on mysql or just sqlite?
     
  11. Offline

    Omri Barak

    just mysql
     
  12. thats perfect!
     
  13. Offline

    Crimsonfox

    I'm looking for a simple plugin to track mob kills, would you be interested in adding that?

    Also it would be nice to be able to turn on/off which are logged. Something like a "WhatToLog" section in the config or alternatively a "WhatNotToLog". I like the health and location logs but not orientation. Would mean players could make their logging a little more efficient. =)
     
  14. Offline

    clitcomander

    something that tells you how long a player has been logged into the server, thats easy to use and can be accessed IN GAME not on a website or elswhere.......thats my please got can you make this plug in request.
     
  15. Offline

    DanielSivertsen

    I need a plugin that make kill death ratio :p
     
  16. Offline

    imoro

  17. Offline

    venconix

    @imoro
    This plugin is outdated, you're probably using a newer version of bukkit.
     
  18. Offline

    DemonCraft

    Looks nice, but would like to see it used on a website first.
     
  19. Offline

    Deren909

    im a noob with mysql and sql i barely even know what it is, other than a database in which plugins and programs are using to store their data. So to install a plugin that uses "mysql" this could be the database?? I'm sorry if this is a dumb question.. Thanks!

    - Der
     
  20. MySQL is a database. Look at it like a storageroom. You put all information in the same room but on different shelves. Instead of every program using their own file to store it in that could end up anywhere on the harddrive they all share the same room. (Like using one room instead than just putting things anywhere in a really really big house.)

    Plugins that says they need MySQL don't have any database by itself, you have to get that one yourself. Either by installing it om your machine or by pointing it to a hosts MySQl.
     
  21. Offline

    Deren909

    thanks for the detailed explanation. But how does this plugin fit in?
     
  22. Instead of having all the stats of everything players do put inside the game for only the game and some few other components, it put's it in the database.

    It's like instead of every person putting everything in their own place (where noone else no where it is) they all put it in the same room so everyone can find it if they just look on the right shelf. :)

    So by some php code on a webpage you could get the information from the database and put it up on a site. How it looks is also just a matter of how you code it to show.
     
  23. Offline

    Omri Barak

    Aah so many comments so late ago! I'll make a later version!!!

    ...Maybe :/
     

Share This Page