Is this possible?

[Seto]

Hello,
Just want to check if the following is possible because I don't want to start if it isn't.
Is it possible to create an online game with RMXP through MySQL? So rather then running a sever that accesses the database then sends the information to the game client. Just connecting the database and the client. I would use a script to connect the client and database (most likely a library out there I could use in some way) then have the game write the players information to the database and retrieve information about the map like where the other players are and such. I have started on the writing and reading part but would like to know if it is even possible for the client to connect to the database.

I do understand that this method might be slow and cause a huge amount of lag lol.

Thanks to anyone who takes the time to read this and answers with out being too mean  :straightthumb:.

 

[Mundane]

Yep, it's called NetPlay Plus 2.0. It's grounded, but if you're a experienced scripter you can work it out. My suggestion is to not bother, you will most likely have a hard time working it, and fail. Don't mean to be harsh...but it's true. Instead maybe you should use vbGore, a free MMO engine.

 

[Seto]

But with Netplay you need to run the sever on your computer (or any computer) and the client connects to the sever you are running. The point of this was so that there is no need for the sever the client connects to the database with out the middle-man so to speak. I will look into your suggestions, but I have all ready started on my game and released the first part. I now want to add a online function. I have no problem with having to script it myself.

Thanks for replying so quickly  :smile:.

 

[Mundane]

This is true. I bet with some tweaking you could get it to run off of a remote MySQL database.

 

[Seto]

That is the plan  :thumb:. I have started work on a few ideas if anyone else has done something like this before I would appreciate your feedback.

 

[S S Muu]

It could be done using a DLL.
Tho like Mundane said, it probably wont work very good since it will be too slow.

 

[Seto]

I just started looking for a Dll before I checked this post. I agree it might be slow but I don't plan on doing the whole game online just a battle system and some mini games so I think it might be ok.

If anyone has a suitable Dll I would really appreciate your help or if you would like to help with with this in anyway just post here and we can work it out.

Thanks to everyone for your comments and information I think this might work.

P.S I apologize if this is off topic or in the wrong area of the forums.

 

[S S Muu]

oh then it would probably work just fine. :thumb:

It's not in the wrong forums and how could it possibly be off topic when you were the one to create the thread? :tongue:

 

[Seto]

Lol, Well I have never really used forums and I only signed up for this one today. I though it might be off topic because the tread is called "Is this possible?" and I was talking about my game and how I plan on doing the online component, although now I have said it like this it seems to be more on topic then I thought lol.

I am going to post a new thread asking for help with creating the whole system tomorrow morning. I might be able to use part of the netplay scripts and instead of sending the information to the sever send it straight to the database.

Thanks for all the posts and answers.

 

[S S Muu]

No! Don't create a new thread, continue with this one.