[Burridge]

Quote:

Originally Posted by Steamator Why the server crashes, when i create over 3 connections to the same database ?

Why would you need to connect 3 times to the same database? One connection via defines is perfectly fine.

Example, you'd make some defines, like the

pawn Код:

#define HOST_ADDR "127.0.0.1"
#define HOST_USER "usernameofdatabasehere"
#define HOST_PASS "passwordhere"
#define HOST_DATA "databasehere"

Then connect when the gamemode starts by adding the following to your OnGameModeInit.

pawn Код:

new MySQL:connection = mysql_init(LOG_ONLY_ERRORS);
mysql_connect(HOST_ADDR, HOST_USER, HOST_PASS, HOST_DATA, connection, 1);

If you wanted to connect to certain Tables within the database; example you have Accounts, Bans, Cars in one database, and you want to connect to one of those tables, you could define the tables as well, and connect to them within your code as and when you need them.

pawn Код:

#define TABLENAME1 Accounts
#define TABLENAME2 Bans
#define TABLENAME3 Cars