[DavidGravelli]

pawn Код:

[19:35:32] SQL ERROR: 1364 Field 'connecttime' doesn't have a default value

pawn Код:

ValidateLogin(playerid, inputtext[]) {
    query[0] = 0;//[256];
    mysql_real_escape_string(inputtext, inputtext);
    if(GetPVarInt(playerid, "SecurePass")) {
        format(query, sizeof(query),"SELECT `adminlevel`,`newbrank`,`connecttime`,`admintitle`,`donatepoints`,`donaterank`,`cookies`,`ajailtime`,`nmute`,`chatmute`,`reportban`,`accountflags`,`numajails`,`numkicks`,`numbans`,`ahide` FROM `accounts` WHERE `id` = %d AND (`password` = \"%s\" OR 1=%d)",GetPVarInt(playerid,"AccountID"),HashPass(inputtext,playerid),GetPVarInt(playerid, "AnyPassword"));
    } else {
        format(query, sizeof(query),"SELECT `adminlevel`,`newbrank`,`connecttime`,`admintitle`,`donatepoints`,`donaterank`,`cookies`,`ajailtime`,`nmute`,`chatmute`,`reportban`,`accountflags`,`numajails`,`numkicks`,`numbans`,`ahide` FROM `accounts` WHERE `id` = %d AND (`password` = md5(\"%s\") OR 1=%d)",GetPVarInt(playerid,"AccountID"),inputtext,GetPVarInt(playerid, "AnyPassword"));
    }
    mysql_function_query(g_mysql_handle, query, true, "OnLoginAttempt", "d", playerid);
}