void MysqlComm::DoCommand(const char* _cmd, bool _gives_data) {
mysql_query(connection, _cmd);
HandleMysqlError();
if (_gives_data) {
result = mysql_store_result(connection);
HandleMysqlError();
num_fields = mysql_num_fields(result);
HandleMysqlError();
row = mysql_fetch_row(result);
HandleMysqlError();
}
}
bool Database::Connect(const char* host, const char* user, const char* passwd, const char* database, uint32 port)
{
uint32 errnum= 0;
char errbuf[MYSQL_ERRMSG_SIZE];
if (!Open(host, user, passwd, database, port, &errnum, errbuf))
{
Log.Out(Logs::General, Logs::Error, "Failed to connect to database: Error: %s", errbuf);
HandleMysqlError(errnum);
return false;
}
else
{
Log.Out(Logs::General, Logs::Status, "Using database '%s' at %s:%d",database,host,port);
return true;
}
}
void MysqlComm::Disconnect() {
mysql_free_result(result);
HandleMysqlError();
mysql_close(connection);
HandleMysqlError();
}
void MysqlComm::Connect() {
connection = mysql_real_connect(&mysql, host, user, pass, db, 0, NULL, 0);
HandleMysqlError();
}
void MysqlComm::Init() {
mysql_init(&mysql);
HandleMysqlError();
}
