PDA

View Full Version : MySQL Connect


KamilPolska
04/07/2018, 12:09 AM
How to connect MySQL StrickenKid?

new MySQL:connection;

MySQL_Connect()
{
connection = mysql_init(LOG_ONLY_ERRORS, 1);
mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DATA, connection, 1);

if() // What to add?
{
// Connect MySQL
}
else
{
// No connect MySQL
}
return 1;
}

kovac
04/07/2018, 12:17 AM
// :: MySQL Database
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_PASS ""
#define MYSQL_DATABASE "server"

new MySQL: Database;

// OnGameModeInit
new MySQLOpt: option_id = mysql_init_options();
mysql_set_option(option_id, AUTO_RECONNECT, true); // We will set that option to automatically reconnect on timeouts.
Database = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DATABASE, option_id);
if(Database == MYSQL_INVALID_HANDLE || mysql_errno(Database) != 0) // Checking if the database connection is invalid to shutdown.
{
print("Connection to MySQL database has failed. Shutting down the server.");
printf("[DEBUG] Host: %s, User: %s, Password: %s, Database: %s", MYSQL_HOST, MYSQL_USER, MYSQL_PASS, MYSQL_DATABASE);
SendRconCommand("exit");
return 1;
}