How do I make a Authentication Severs with SQL Server 2012?

[waseemk]

Hello! I want to make an authentication Server. Kind of like the following: [http://www.touchofdeathforums.com/smf2/index.php/topic,77593.0.html](http://www.touchofdeathforums.com/smf2/index.php/topic,77593.0.html)

>! @Rithy58:
>! > A while a go, I made something called "Authentication Server" stolen from guided by Robin.
> It is pretty much the same thing that Crystalshire and I believe also OTLR have.
> Please note that this is the "base" or unfinished version. It is meant to give you an idea on how to do it or integrated it into your project, etc.
>
> Instead of having the Server handling Client's login, why not have a different Authentication Server that do that? This open up lots of possibilities such as MySQL(Forums) Account integration, Multi-Servers, and lots of other features.
>
> So how does this work exactly?
> Well, everything is the same except the Client have a dedicated WinSocket called AuthSocket that connect to the Authentication Server. There is also the modAuth.
> In this version, I put in the base code enough for you to get started and a very dumb login check it doesn't even check, just let you go through. So when you open the Client, not only did you connect to the Server, but you also connect to the Authentication Server. When you login, the Client send the login data to the Authentication Server. The Authentication Server then check the login and response back to the Client(in this version, it just send the LoginOk packet). If the client receive an AuthSLoginOk packet, it simply tell the Client to SendLogin to Game Server and the Game Server do what it usually do(you should probably remove the Login Check).
>
> As you can see, the Authentication Server is used only during the login using its own dedicated Socket. For the rest of the time, the Client and Server use their own Socket like they usually do.
>
> Possible things you can do with this:
> Make Authentication Server check the Login Data against a remote MySQL database(like Crystalshire)
> With ^ that, you can also dump character info to the MySQL Database
> Multi-Server Selection: After login with Authentication Server, select which server to login then flagged the user as logged in with the Authentication Server
> There are so many possibilities you can do with this
>
> Oh and if you ask why not just let the Server access the MySQL database. It's because I've been told that doing so would really decrease the Server performance. The Server should be game related only while the Authentication should be for well…authenticating.
>
> Download:
> Sorry, no download. Just read the text and make one yourself. It shouldn't be hard once you understand how it work.
>
> Sincerely,
> Rithy

These are the example features I would put:

* Ability to register/login online
* View stats online
* View inventory/spells/etc online
* Possibly Play online without downloading
* Forum accounts using game account (like in Crystalshire).

These are my resources:

* A game (Duh)
* Microsoft SQL Server 2012
* A brain

Now how can I make such a server? Now I'm not asking for a fully developed system (which I would like  :cheesy:), but a basic source.

[Likestodraw]

I've been wanting one of these, too. It would make things with and between my game & website run much smoother.

[JohnPony]

Just look at the current way packets are sent back and forth between the server and client, and recreate that for the login server.

[Likestodraw]

I keep on finding that same response, and I have asked around a couple of times. I simply don't get that at all. I can work with Eclipse, and PHP/HTML, but when you start talking about packets and MYSQL, I get really confused.

[waseemk]

So anybody knows how?

[JohnPony]

Make a 2nd server that the server & client are able to connect to.

Client Login > Sends check to login server > login server checks database for username and pass > login server sends yes/no to client > client connects with the serve

Or
Server updates a players stats > sends data to the login server > login server updates database with new information