20.09.2014, 15:55
How convert this code to MySQL R39?:
pawn Код:
public CheckAccount(sqlplayersname[])
{
new query[128];
new escstr[MAX_PLAYER_NAME];
mysql_real_escape_string(sqlplayersname, escstr);
format(query, sizeof(query), "SELECT id FROM srp_players_stats WHERE LOWER(Name) = LOWER('%s') LIMIT 1", escstr);
MySQLCheckConnection();
mysql_query(query);
mysql_store_result();
if (mysql_num_rows() == 0)
{
mysql_free_result();
return 0;
}
else
{
new strid[32];
new intid;
mysql_fetch_row(strid);
intid = strval(strid);
mysql_free_result();
return intid;
}
}

