Database Connections

Discussion in 'Archived: Plugin Requests' started by tstom0, Jan 9, 2014.

  1. Offline

    tstom0

    Plugin category: Database Connections

    What I want:
    Basically (I don't know whether this is basic) when a player uses the command /register it generates a random string of numbers which is then stored in a database along with the players name. The plugin would need to be capable of first reading the database and checking whether a row with the players name is already present and if so it would narrate to the player the already existing random string. There would also have to be a third field labelled verified, which is a Boolean and if set to true would narrate to the user "You are already verified". And if the database is clear of entries with that name it would narrate the code to the user.

    So fields:
    player_name (varchar 20)
    register_code (int 10)
    verified

    Example:
    tstom0
    3934645476
    false

    Messages:
    Doesn't have entry in database: You have successfully generated a register code. Your code is (code that was just created). Go to (website url) to register!
    Entry already present in database, verify field = false: It appears you have already generated a register code. Your code is (code retrieved from database). Go to (website url) to register!
    Entry present in database, verify field = true: You have already registered! Contact an admin if you believe this to be an error.

    It would be amazing to have a config that allowed not only the setting of database information but also the website address and the messages that the user sees.

    The database would need to be mySQL and I can write or help with the SQL queries if need be!

    This will be used when a user needs to create an account on the website with the player needing to register on the minecraft server to verify their account.

    The permission node would also be useful in ensuring that new players can't register for a certain time period.

    Ideas for commands: /register

    Ideas for permissions: player.register

    Thanks for reading if you got this far!
     
  2. Offline

    xBlackLightx

    tstom0 Do you have a website set up that you can write your own HTML on?
     
  3. Offline

    timtower Administrator Administrator Moderator

    PHP*
     
    tstom0 likes this.
  4. Offline

    dturner699

    You could use a config file to do this, make it add config slots, etc. But idk about the boolean part :p
     
  5. Offline

    xBlackLightx

    timtower True, my bad. tstom0 What I mean is that I would have to write not only a plugin, but I would also need to write a PHP script to connect to the database on the website side of things. I can, and don't mind doing it, but I need to know if you can make your own HTML/PHP pages. For example, if you use something like Enjin, I don't think it'd be possible for me to do it, but in that case, enjin has its own minecraft plugin that is probably capable of doing that.
     
  6. Offline

    timtower Administrator Administrator Moderator

    xBlackLightx Plugin requests, PHP is not something that we need to look after
     
  7. Offline

    xBlackLightx

    True, but hey, I'm bored and so I figure I can help the guy out. He obviously knows at least a bit about SQL so maybe he can do the website side. If not, I don't mind helping him at all.
     
    tstom0 and timtower like this.
  8. Offline

    Fluxanoia

    Couldn't you just use the player name? Considering they're all unique...
     
  9. Offline

    tstom0

    xBlackLightx I can do all the website scripts I just need a plugin to write to the database and I write all my own pages.

    Fluxanoia I suppose so But the whole point is to make sure the account is linked and verified. Using just the name someone could randomly register as another person on the chance that that player has done /register but has not completed the registration yet. With a code that only the player knows, this eliminates that possibility.

    dturner699 Doesn't necessarily have to be a boolean, just a string like false or true would do :)
     
  10. Offline

    timtower Administrator Administrator Moderator

    tstom0 Other option ( no need for a plugin ) login with minecraft username and password
     
  11. Offline

    tstom0

    timtower I don't really think players would be content in entering their minecraft account details into a website with little to no reputation haha
     
  12. Offline

    timtower Administrator Administrator Moderator

    tstom0 My players are doing it :p Do need to mention that I don't store passwords and that it is the only way to get on my server
     
  13. Offline

    tstom0

    timtower I would prefer only players who have been on the server to be able to register. That way I can implement more features into the site that cater to players such as achievements etc
     
    timtower likes this.
  14. Offline

    xBlackLightx

    tstom0 I am moving into my college dorm today, so I may be pretty busy the next couple days, but I will try to work on it as much as I can. If someone else wants to create it that has a little more time on their hands, and could get it done sooner, I wouldn't mind at all. If not, I'll do my best to finish it within a reasonable time frame, but it's going to be at least 5-7 days I would guess.
     
    tstom0 likes this.
  15. Offline

    tstom0

  16. Offline

    tstom0

Share This Page