Files or MySQL
#1

Hi guys!

QUESTION

If you have to choose between saving your logs(new users,chat,bans etc..) to your scriptfiles or to your MySQL database, what would you choose? And why?

All answers are appreciated!!!


Regards!
Reply
#2

MySQL 100%.
Reply
#3

Both. System logs to file, all other logs (player actions and whatnot) to the database. That way if the database can't be contacted all the relevant things are logged to file.
Reply
#4

Both. I use files for logs and server data and SQL for saving dynamic data, eg users, vehicles and bans.

Why? Logs are good for just recording data that probably will never need to be seen again, like the chatlog. SQL is good for storing dynamic data that needs to be read from and updated regularly, hence its use for userdata and other dynamic systems. Also SQL can be used on your website as well, for example players could log in to your website using their in game username, because the website would have access to the same database as the game server.
Reply
#5

Nice!

Anybody else wanna answer?
Reply
#6

I haven't tried saving logs in a MySQL database, so dunno how that would work.
But i would definitely save stats in MySQL, it's way more organised than having hundreds of different files.
Reply
#7

Your answer, ******, is very, how should I say, inspiring.

If you read between the lines, you can surely see that you want from me to create something unique, something that isn't already done. We are all tired of seeing same stuff over and over again. If we think, plan and create by our head and hands, we wouldn't need others help. Thank you , Alex(Is it Alex?), for reminding me that!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)