Place for questions and answers for all newcomers and new coders. This is a free for all forum, no question is too stupid and to noob.


Postby Dabouh » Thu Oct 11, 2018 10:36 am

Hi all,

As i said i am working on RTS, it is a kind of Lord of Ultima from EA if some of you remember this; and it has been remake by Crown of the Gods.

Today i am wondering, if it is a good idea to use PHP with Mysql to make the back end.

I found with PHP/Mysql that it was possible to use cron table and events in Mysql DB to update the data of the players,
for example i can raise the amount of ressources when the players are not online, and i can create some combats events even if the players are also not online.

My concern is about the speed of the database, what happens if there are 100 players at the same time, this will still work ? or will i have a deny system ?

I know that there is node.j with socket.io can be used with mongodb, i started a little to see how that works, but it is a lot of work (again) to understand all this.

What do you think about ?


User avatar
Posts: 3
Joined: Wed Oct 03, 2018 5:13 am
Has thanked: 0 time
Been thanked: 0 time


Postby hallsofvallhalla » Sun Oct 14, 2018 8:56 pm

MySQL can definitely handle a lot of connections. I would not worry about it too much unless you plan on thousands of thousands of players. When you get there you can afford to change it.

So are you using js with ajax then to make it real time?
User avatar
Site Admin
Posts: 11998
Images: 13
Joined: Wed Apr 22, 2009 6:29 pm
Location: mobile, al
Has thanked: 11 times
Been thanked: 164 times
Blog: View Blog (3)


Postby KaL » Wed Oct 17, 2018 11:17 pm

Don’t reinvent the wheel. Try out my engine:
It has all the module you need to build your game.
If not I can make them.


Text Based MMO (MYSQL system)

Sorry for the landing page, someone keep deleting
My image.

Username: admin
Password: admin

Username: player
Password: player

If you like the engine DM me.
Posts: 344
Joined: Mon Jan 13, 2014 12:44 am
Has thanked: 14 times
Been thanked: 14 times


Postby Dabouh » Fri Oct 19, 2018 5:06 pm


Ok thx for the answer hallsofvallhalla.

Yes i use ajax to send javascript variables json format to php.

I saw what you did Kal, it is a nice game, it look like ultima II, long time ago.

What i am doing is very different, there is no animation, i am making a wargame, i don t use a hero system, there are armies and castles, it is economic and military strategical.

I use hexagon system map.

But i will be very please to receive some advices and help during the contruction of the code.

I think there will be a first beta version in the end of november.

thx Dabouh
User avatar
Posts: 3
Joined: Wed Oct 03, 2018 5:13 am
Has thanked: 0 time
Been thanked: 0 time

Return to Beginner Help and Support

Who is online

Users browsing this forum: No registered users and 1 guest