Hello, it would be great if there would be a plugin that connects to a database and runs a query, displayed on a command, like this: command1: command: /topkills query: "SELECT * FROM pvpstats WHERE name='%player%' ORDER BY kills LIMIT 0, 10" variable: name: row_name kills: row_kills deaths: row_deaths message: "Hello, %player%, here is the top kills: %name% - %row_kills% kills, %row_deaths% deaths" And when /topkills is executed: DJoe - 55 kills, 12 deaths. SomeOtherPlayer - 32 kills, 57 deaths. CoolPlayer - 28 kills, 17 deaths. etc Can this be acomplished? it would be really useful to create commands like /stats customized by you But i do not want a plugin that shows me top kills, i want a plugin that allows me to create a query and make my own command
I am not going to take advantage of this plugin because I am busy with the grand exchange, I can only tell you that you can't use the standard sql query's anymore in java, you need to make getters and setters. Do you know how to write a little plugin, if you know that you can make this by yourself easily if you wanna make a try.
jokie666 I do not know how to write a plugin, otherwise i wouldn't be posting here asking for help, and i will start , but i do not know. This plugin would be very useful if someone did it.
MySQL, it would be nice if i could create my own query, and display the result, the commands could be /cq command1 or something like this, but it would be great to make my querys on commands like /tops or /stats. And this plugin would be really useful for everyone.
D.Joe Config will be like this: Code: url: jdbc:<server url here>:<port here> user: <username for database> password: <password for database, leave blank for none> Commands: Command1: query: '<your select statement>' message: 'Hello, %colomn name1% kills and %colomn name 2% deaths'
timtower and the player will be %player%? Code: url: jdbc:<server url here>:<port here> user: <username for database> password: <password for database, leave blank for none> Commands: kills: query: 'SELECT * FROM stats WHERE user=\'%player%\'' message: 'You have, %kills% kills ' Will this be correct?
timtower works, but i made this Code: Commands: topkills: query: SELECT * FROM Stats_kill WHERE type='Player' ORDER BY amount DESC firstmessage: Hmm message: '%player%: %amount%' but the command /topkills does not work Edit: it works with /mysql topkills, and it displays Code: Hmm bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 bobscanfy: 190 Couldn't fetch data rows
timtower Instead of displaying all resulted columns in a query, it displays only the first for more how much i asked SELECT * FROM Stats_kill WHERE type='Player' ORDER BY amount DESC LIMIT 0, 5 will result Bobscanfly: 190 Bobscanfly: 190 Bobscanfly: 190 Bobscanfly: 190 Bobscanfly: 190 , instead of resulting Bobscanfly: 190 Sabyn: 88 YaziRainbow: 75 Darber: 70 Midnight: 69 Also, please add a plugin reload feature
timtower scoreboard can be put in the middle? if so, you could make a scoreboard with the data withdrawn from mysql, and it would be awesome
D.Joe Put more spacebars in the message? And won't add scoreboard support, would require continues updates. You have a plugin that puts the score in the database already, they have the values stored in the plugin already. Ask that developer to add scoreboard support.