SQLApply
SQLApply
Version: 1.0
CraftBukkit Build 1.3.1-R1.0 [Tested]
Info
This plugin lets you create a php script on your website lets say on the rules page where the user inputs their Minecraft name and receives a Unique code that that they have to type in the server to become a player. This is useful as with other /apply plugins people can tell their friends the code but now the code has to match the username. The Codes are stored on a MySQL server so you must have one to use this plugin. For promoting this also uses vault.
Config
//MySQL Server info MySQL: Enabled: true Server: localhost Database: minecraft User: root Password: '0000' //Stops guests from talking Block: Chat: true //Messages Supports colors Message: ChatBlock: You are not allowed to talk as you are guest JoinMessage: Welcome follow the signs to be promoted! BroadcastSucess: true //If it broadcasts to all players BroadcastMessage: '%player% Has been promoted to player!' Groups: GuestGroup: Guest //Default group PromoteToGroup: Player //Group to promote to
MySQL
To get the database made first put your mysql info in the config and restart the server. It will create all the tables for you. Now for the tricky part the website code the unique code can be made anyway as you can make the php how you want. I will include an example that I use for my server so that you can either use it of make it better.
The first bit of code is the apply.php should look something like this. http://pastebin.com/LDfvSfkr Make sure to edit the MySql information to your servers info.
The second thing you need is to add a form to your main page such as your rules page. http://pastebin.com/4jA1v3x5 Make sure to make the link to your apply page.
Here is an example page http://pastebin.com/LPKs7RLc Edit the bits that say yoursite.com to the link that links to your apply.php on your website which you also filled in.
Commands
- /apply <Password> - Apply command for guests
- /sqlapply - sqlapply.admin
- /sqlapply reload - Reloads the config
- /sqlapply check <PlayerName> - Returns the passwords of the player
- /sqlapply promote <PlayerName> - Manually Promotes the player
- /sqlapply remove <PlayerName> - Manually removes player from the cant talk list
- /sqlapply removeexpired - Removes apply codes over 1 hour old
Changelog
Version 0.1
- Release of plugin
Hey i am trying to use your Plugin for my Server. I used the Code from your Downloadlink for the apply.php and filled in the mysql datas. But now everytime I open it it just displays an empty page. Any Idea why? Thx
Very useful plugin!
Just what I needed :)
@woutwoot
You can use java-gui to decompile it.
Nice work. I will use this for my server. However, could you send me your project folder in a .zip file so I can change your code a bit to customize it for my server? Just PM me :) and again, nice work!
hello, your apply.php wont work. Im geting an Internal Server Error