[MafiaOink]

Quote:

Originally Posted by Blackaslan Код: funcion getGroupColor(id) { new color = -256; mysql_format(idConexion, consulta, sizeof(consulta), "SELECT Color FROM Clanes WHERE Id=%d", id); new Cache:result = mysql_query(idConexion, consulta); if(cache_get_row_count(idConexion) > 0) { color = cache_get_row_int(0, 0, idConexion); } cache_delete(result, idConexion); return color; } funcion setGroupColor(id, color) { mysql_format(idConexion, consulta, sizeof(consulta), "UPDATE Clanes SET Color=%d WHERE Id=%d", color, id); mysql_query(idConexion, consulta, false); } But I can not create a new clan and in the logs this appears: Also I can not put as default Color "0" Because then I Can't change the color......

First off:
I really suggest you not to use getGroupColor every time, you should save it onto a variable and edit it as it goes, rather than loading it every time using mysql_query as it freezes the whole script while waiting for the query to execute.

Secondly,
you are inserting a new row in the table `Clanes` but you have not specified the `Color` value, and you didn't define a default value in the table structure so that is why it is firing an error, as the mysql server does not know which value to input,

This is how you should structure that column:

pawn Код:

`Color` int(11) NOT NULL DEFAULT '-256'