MySQL Database.

[hahec]

Hello all. Could someone explain what MySQL Database actually is/is for. Ty.

[Castillo]

https://wiki.multitheftauto.com/wiki/Mysql

[drk]

You can store data in MySQL, like saving player settings instead of saving in the account.

Example:

local connection = mysql_query("CREATE TABLE IF NOT EXISTS Settings ( player TEXT, money NUMBER )") 
  
addEventHandler('onPlayerJoin',root, 
  function() 
     local name = getPlayerName(source) 
       local select = mysql_query("SELECT money WHERE player = '"..name.."'") 
        if #select == 0 then 
             result = mysql_query("INSERT INTO Settings VALUES ( player = '"..name.."', money = '"..tonumber(0).."' )") 
             outputChatBox('New in the server? Good! Your money is 0. If you have any problem contact administrators!',source,255,255,255,false) 
        else 
             outputChatBox('Your money is: $'..select[1]['money'],source,255,255,255,false) 
     end 
end) 

[Castillo]

I suggest you to use the new DB functions instead, as far as I know, they are better, and easier to use (at least for me).

https://wiki.multitheftauto.com/wiki/DbConnect

[hahec]

Ok tnx both. So i will have to use DB functions for login system? and things like that? or am i wrong?

[drk]

You can, but you can use MTA default account system too.

[Castillo]

Yes, you can create a MySQL login system with the DB functions.

[hahec]

Hmm...i see. So i've made that login GUI from wiki. Introduction to the GUI. So could you make a tip to make that login Working? tnx.

[Castillo]

There are examples in the wiki, just read them and learn how to do it.

[drk]

And start learning this too: http://www.lua-users.org/wiki/TutorialDirectory

[hahec]

Okay. TY VERY MUCH!

[drk]

No problem dude

[Agon]

What is difference between using MySQL and player account in order to save player data?

[drk]

Using MySQL you save the data in a data base like web-servers mysql.

Using player account it will save in registry.db or internal.db ( I don't remember ). Then, you can lose it if you reinstall the server or delete any configuration server, but if you use MySQL you will only need to connect to the database

[Agon]

Using MySQL you save the data in a data base like web-servers mysql.

Using player account it will save in registry.db or internal.db ( I don't remember ). Then, you can lose it if you reinstall the server or delete any configuration server, but if you use MySQL you will only need to connect to the database

oh thank you

[drk]

No problem. I'm here to help