Not added to mysql

[Ni3ls]

Hi all,

I want to make a banlist using mysql

guidbanplayer(admin, reason, id, guid)
{   
	maps\mp\gametypes\_mysql::asyncQuery("INSERT INTO ban_guid_sd (guid, name, reason, admin) VALUES (" + guid + ", " + maps\mp\gametypes\_mysql::stripString(self.name) + "," + maps\mp\gametypes\_mysql::stripString(reason) + "," + maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"]) + ")");
	printf("GUID ban added to database2!\n");
	printf("guid "+guid+ "\n");
	printf("name "+maps\mp\gametypes\_mysql::stripString(self.name)+ "\n");
	printf("reason "+maps\mp\gametypes\_mysql::stripString(reason)+ "\n");
	printf("admin "+maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"])+ "\n");

}

the table name is ban_guid_sd
the printf are shown correct

However, the record is not added to the table.
Im connected to the database

initMySQL(host, user, pass, db, port)
{
    mysql = mysql_init();
    ret = mysql_real_connect(mysql, host, user, pass, db, port);
    if(!ret)
    {
        printf("errno=" + mysql_errno(mysql) + " error= " + mysql_error(mysql) + "\n");
        mysql_close(mysql);
        return undefined;
    }
	else 
		printf("Connected to database!\n");
    return mysql;
}

I see the message "Connected to database"

What is wrong?

[IzNoGoD]

Init your async mysql, not just your mysql.

Also: put ' around your strings.

[Ni3ls]

Init your async mysql, not just your mysql.

Also: put ' around your strings.

Already done

initAsyncMySQL(host, user, pass, db, port)
{
    mysql_async_initializer(host, user, pass, db, port, 4);
    level.mysqlAsync = [];
    thread loopAsyncMySQL();
}

And do you mean this?

maps\mp\gametypes\_mysql::asyncQuery("INSERT INTO ban_guid_sd ('guid', 'name', 'reason', 'admin') VALUES (" + guid + ", " + maps\mp\gametypes\_mysql::stripString(self.name) + "," + maps\mp\gametypes\_mysql::stripString(reason) + "," + maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"]) + ")");

[IzNoGoD]

no, like this

maps\mp\gametypes\_mysql::asyncQuery("INSERT INTO ban_guid_sd (guid, name, reason, admin) VALUES ('" + guid + "', '" + maps\mp\gametypes\_mysql::stripString(self.name) + "', '" + maps\mp\gametypes\_mysql::stripString(reason) + "', '" + maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"]) + "')");

[Ni3ls]

Working with iznogods fix!

[Ni3ls]

	maps\mp\gametypes\_mysql::asyncQuery("INSERT INTO sd_bans_ip (ip, name, reason, admin) VALUES ('" + ip + "', '" + maps\mp\gametypes\_mysql::stripString(self.name) + "', '" + maps\mp\gametypes\_mysql::stripString(reason) + "', '" + maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"]) + "')");

	printf("IP ban added to database sd_bans_ip!\n");
	printf("ip "+ip+ "\n");
	printf("name "+maps\mp\gametypes\_mysql::stripString(self.name)+ "\n");
	printf("reason "+maps\mp\gametypes\_mysql::stripString(reason)+ "\n");
	printf("admin "+maps\mp\gametypes\_mysql::stripString(admin.pers["loginname"])+ "\n");

It doesnt work with IP?
Everything is printed correctly.
IP in mysql is int(11)
rest are strings

[Paho]

I'm use varchar(16)

sql = "INSERT INTO `sd_bans_ip` (`IP`) VALUES ('" + self getIP() + "')";
mysql_query(level.mysql, sql);

[Mitch]

It doesnt work with IP?
Everything is printed correctly.
IP in mysql is int(11)
rest are strings

libcod processes the IP like this:

		snprintf(tmp, 64, "%d.%d.%d.%d", ip_a, ip_b, ip_c, ip_d);
stackPushString(tmp); 
	

[IzNoGoD]

You should use INET_ATON('" + stripstring(self getip()) + "')"

[Ni3ls]

You should use INET_ATON('" + stripstring(self getip()) + "')"

And how do I check if an IP is banned?