CMySQLHandler::Query(INSERT INTO `Players` (RegID, Name, IP, Pass, RegDate, LastOn, Money, Score, Kills, Deaths, Chatcolor, IDcolor, Bank, MyTitle, MyText, Saved_X, Saved_Y, Saved_Z, Saved_A, OnHours, OnMinutes, OnSeconds, AdminLvl, Warns, Banned, AllowGoto, AllowPM, Posts, Tests, Skin, Vip) VALUES(0, \'assff\', \'31.46.156.179\', \'golden15\', \'2013.02.25/10.44.51.\', \'2013.02.25/10.44.51.\', \'0\', \'0\', \'0\', \'0\', \'{ffffff}\', \'{ff0000}\', \'0\', \'NoTitle\', \'NoText\', \'0.0\', \'0.0\', \'0.0\', \'0.0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\',\'0\')) - An error has occured. (Error ID: 1136, Column count doesn\'t match value count at row 1)[/quote]Registerplayer : stock RegisterPlayer( playerid, password[] ){ new iRegID, szFieldsName[ 512 + 1 ], szValues[ 512 + 1 ]; getdate( year, month, day ); gettime( hour, minute, second ); GetPlayerIp( playerid, szIP, sizeof( szIP ) ); format( szFieldsName, sizeof( szFieldsName ), \"RegID, Name, IP, Pass, RegDate, LastOn, Money, Score, Kills, Deaths, Chatcolor, IDcolor, Bank, MyTitle, MyText, Saved_X, Saved_Y, Saved_Z, Saved_A, OnHours, OnMinutes, OnSeconds, AdminLvl, Warns, Banned, AllowGoto, AllowPM, Posts, Tests, Skin, Vip\" ); format( szValues, sizeof( szValues ), \"0, \'%s\', \'%s\', \'%s\', \'%02d.%02d.%02d/%02d.%02d.%02d.\', \'%02d.%02d.%02d/%02d.%02d.%02d.\', \'0\', \'0\', \'0\', \'0\', \'{ffffff}\', \'{ff0000}\', \'0\', \'NoTitle\', \'NoText\', \'0.0\', \'0.0\', \'0.0\', \'0.0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\',\'0\'\", szName( playerid ), szIP, password, year, month, day, hour, minute, second, year, month, day, hour, minute, second ); format( szQuery, sizeof( szQuery ), \"INSERT INTO `Players` (%s) VALUES(%s)\", szFieldsName, szValues ); mysql_query( szQuery ); iRegID = mysql_insert_id( ); SetPVarInt( playerid, \"RegID\", iRegID ); SetPVarInt( playerid, \"Logged\", 1 ); format( szFormat, sizeof( szFormat ), \"{ffb300}-> NLP <-: {ff0000}%s(%d) {0dff00}Regisztrált a szerverre. Összes regisztrált felhasználó száma: {ff0000}%d.\", szName( playerid ), playerid, iRegID ); SendClientMessageToAll( COLOR_BLUE, szFormat ); format( szFormat, sizeof( szFormat ), \"{0dff00}|- NLP: Sikeresen regisztráltál. Felhasználód jelszava: {ff0000}%s, {0dff00}Felhasználód azonosítója: {ff0000}%d.\", password, iRegID ); SendClientMessage( playerid, COLOR_GREEN, szFormat ); SetGVarInt( \"Registrations\", GetGVarInt( \"Registrations\" ) + 1 ); return 1;}
stock RegisterPlayer( playerid, password[] ){ new iRegID, szFieldsName[ 512 + 1 ], szValues[ 512 + 1 ]; getdate( year, month, day ); gettime( hour, minute, second ); GetPlayerIp( playerid, szIP, sizeof( szIP ) ); format( szFieldsName, sizeof( szFieldsName ), \"RegID, Name, IP, Pass, RegDate, LastOn, Money, Score, Kills, Deaths, Chatcolor, IDcolor, Bank, MyTitle, MyText, Saved_X, Saved_Y, Saved_Z, Saved_A, OnHours, OnMinutes, OnSeconds, AdminLvl, Warns, Banned, AllowGoto, AllowPM, Posts, Tests, Skin, Vip\" ); format( szValues, sizeof( szValues ), \"0, \'%s\', \'%s\', \'%s\', \'%02d.%02d.%02d/%02d.%02d.%02d.\', \'%02d.%02d.%02d/%02d.%02d.%02d.\', \'0\', \'0\', \'0\', \'0\', \'{ffffff}\', \'{ff0000}\', \'0\', \'NoTitle\', \'NoText\', \'0.0\', \'0.0\', \'0.0\', \'0.0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\',\'0\'\", szName( playerid ), szIP, password, year, month, day, hour, minute, second, year, month, day, hour, minute, second ); format( szQuery, sizeof( szQuery ), \"INSERT INTO `Players` (%s) VALUES(%s)\", szFieldsName, szValues ); mysql_query( szQuery ); iRegID = mysql_insert_id( ); SetPVarInt( playerid, \"RegID\", iRegID ); SetPVarInt( playerid, \"Logged\", 1 ); format( szFormat, sizeof( szFormat ), \"{ffb300}-> NLP <-: {ff0000}%s(%d) {0dff00}Regisztrált a szerverre. Összes regisztrált felhasználó száma: {ff0000}%d.\", szName( playerid ), playerid, iRegID ); SendClientMessageToAll( COLOR_BLUE, szFormat ); format( szFormat, sizeof( szFormat ), \"{0dff00}|- NLP: Sikeresen regisztráltál. Felhasználód jelszava: {ff0000}%s, {0dff00}Felhasználód azonosítója: {ff0000}%d.\", password, iRegID ); SendClientMessage( playerid, COLOR_GREEN, szFormat ); SetGVarInt( \"Registrations\", GetGVarInt( \"Registrations\" ) + 1 ); return 1;}