pawn Код:
new query[256];
mysql_format(MySQL, query, 256, "SELECT * FROM `users` WHERE `name` = '%s';", PlayerLoginInfo[playerid][PlayerRegisterName]);
new Cache:result = mysql_query(MySQL, query, true);
if(cache_num_rows())
{
SendInfoText(playerid, "Registration Failure", "There is already an account with this nickname, please, choose a different name and try again!", 6000);
return cache_delete(result);
}
cache_delete(result);
#if defined SHA256_PassHash
new HashedPass[32];
SHA256_PassHash(PlayerLoginInfo[playerid][PlayerRegisterRePassword], "ztah", HashedPass, sizeof HashedPass);
mysql_format(MySQL, query, 256, "INSERT INTO `users` VALUES (NULL, '%s', '%s', '%s', '0', '0', '0', '0', '0', '0', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');", PlayerLoginInfo[playerid][PlayerRegisterName], HashedPass, PlayerLoginInfo[playerid][PlayerRegisterMail]);
mysql_tquery(MySQL, query, "OnPlayerRegister", "i", playerid);
#else
mysql_format(MySQL, query, 256, "INSERT INTO `users` VALUES (NULL, '%s', '%s', '%s', '0', '0', '0', '0', '0', '0', '100', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1');", PlayerLoginInfo[playerid][PlayerRegisterName], PlayerLoginInfo[playerid][PlayerRegisterRePassword], PlayerLoginInfo[playerid][PlayerRegisterMail]);
mysql_tquery(MySQL, query, "OnPlayerRegister", "i", playerid);
#endif