Accounts in MySQL?

[PhatPanda]

Hi, I'm new here so i hope i'm putting this in the right forum. If not I apologize to the Admin(s). I've done a search on this but turned up nothing. I was wondering if there was any way to store the account information for the server in a MySQL Database? I was poking around the account scripts and i see it's writing an xml file, also i was looking at the myrunuo scripts too and saw you could use a database for that. I don't have any C# experience or i'd take a crack at it myself. But if anyone knows how, or even some general info i'd really appreciate it. Thanks in advance

[mordero]

Just curious, but why exactly do you want to store the accounts in a database?

[PhatPanda]

no reason really, except i had a though to have a signup form on my website and after someone submitted the form and confirmed their e-mail i wanted their account to be inserted so they would be able to play right away

[septor]

By default the server automatically creates an account if it doesn't exist.

[mordero]

Originally Posted by septor

By default the server automatically creates an account if it doesn't exist.

Yeah and it can limit the number of accounts for IP addresses

[TheOutkastDev]

Originally Posted by mordero

Yeah and it can limit the number of accounts for IP addresses

But it doesn't let you submit additional information such as contact info, or use php/asp based account activation before the account can be created.

[Nochte]

You could probably get your php or asp script to update the accounts XML file directly, instead of converting everything to database.

[mordero]

Originally Posted by TheOutkastDev

But it doesn't let you submit additional information such as contact info, or use php/asp based account activation before the account can be created.

Yeah, but if he wants people to quickly be able to sign in, then you could always create a gump that requires that information before allowing them to play.

[mordero]

Originally Posted by Nochte

You could probably get your php or asp script to update the accounts XML file directly, instead of converting everything to database.

That wouldnt quite work though, because once the server is started, it loads all of the accounts and holds them. The only time it accesses the XML file again is to save it. So what he would need to do is to invoke the server to create this account some way. Perhaps another XML file that contains basic information that the server checks every 5 minutes or so would do the trick. It would need to contain at least a username and password, then the server could check this file and set up an account based on this information, which shouldnt be too hard.

[septor]

Originally Posted by TheOutkastDev

But it doesn't let you submit additional information such as contact info, or use php/asp based account activation before the account can be created.

How do accounts get activated if they aren't automatically created? I've seen servers with web forms that need filed out before your account is created. There's no amount of reasons that could be conjured up that would warrant the need for a MySQL database to store the accounts.

[viront]

replying to the original post,
This is only a suggestion since I haven't tried this but I believe you could create a C# script that uses MySQLDriverCS to read from your database then use this Account object in AccountHandler.cs

private static Account CreateAccount( NetState state, string un, string pw )

that way you have a script that deals with adding accounts and your database!

I'm sure there are many ways but I've already spent 30 min of work time looking into : /

Let me know how it goes and I'll try and give you a hand! (or maybe you will teach me something, either way its win win :P).

[Malaperth]

Well, I have seen a script here that does that (or something near), but can't for the life of me remember what forum it was in. I think it was in either programming or 3rd party program support though.

[viront]

linky

This guys was working on it awhile ago... this should at least give you an idea of how to do this.

[PhatPanda]

thanks for all the input, sorry i've been away from the comp for awhile. i'll let ya know what i get