Re: [PHP-API / MYSQL DATABASE] WarZ / Infestation - Rewritten
With MSSQL 2008 you constantly have a service & server running (MSSQL). So you can't use it "on the fly". You need to download a 384 MB big Server and then install it which takes couple of minutes (~38 Minutes on my last test). After that you need to install an ASP.NET compatible server. For example IIS.
IIS is in my opinion a big pile of poop like MSSQL. It's not secure.
Not easy to setup and a pain in the butt to uninstall.
With MySQL you can have portable MySQL Servers. The only thing you need is one EXE file and 2 config files. And you're good to go.
PHP is in the most cases preinstalled with WAMP / XAMPP or another Apache Server stack. So no hassle to install, easy to configure and the best part:
Secure..
EDIT [
Biggest part:
Oh did I mentioned the potential of Linux servers? Why? Because MySQL and Apache2 with PHP can be installed and run under linux ]
sudo apt-get install apache2 php5 libapache2-mod-php5 mysql-server mysql-client && service apache2 restart
<-- Apache2 server with PHP and MySQL
-> DONE
No wine emulation for the API backend (MSSQL can't be run on wine
.)
Also the response time of the pages:
MSSQL & ASP.NET: 768ms
MySQL & PHP: 268ms
So WAY faster..
Hope you understood this correctly
EDIT:
For the regular things:
You must be registered to see links
&
You must be registered to see links
For MySQL & PHP API:
You must be registered to see links
<-- It's all you need bro
. No install, only extraction and FINISHED
btw:
I'm planning on releasing my FULLY MySQL reworked server. So like this:
before:
GameServer -> ASP.NET API Page -> MSSQL -> ASP.NET Output
Client -> ASP.NET API Page -> MSSQL -> ASP.NET Output
PHP API:
GameServer -> PHP API Page -> PHP Output
Client -> PHP API Page -> PHP Output
reworked server:
GameServer -> MySQL
Client -> GameServer -> MySQL
No crappy web-page required.
EDIT # 2:
I've added a little bit of extra security which you can later disable by setting:
$_CONF['extendedSecurity'] = false;
Information about Extra security:
- Auto logout after 24 hours and not on a server