MySQL R39 (+reps)
#3

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;
    }
}
Reply


Messages In This Thread
MySQL R39 (+reps) - by Baltimore - 20.09.2014, 14:04
Re: MySQL R39 (+reps) - by Vince - 20.09.2014, 14:28
Re: MySQL R39 (+reps) - by Baltimore - 20.09.2014, 15:55
Re: MySQL R39 (+reps) - by Ox1gEN - 20.09.2014, 16:17
Re: MySQL R39 (+reps) - by Stinged - 20.09.2014, 16:18
Re: MySQL R39 (+reps) - by Baltimore - 20.09.2014, 20:44
Re: MySQL R39 (+reps) - by Baltimore - 21.09.2014, 18:51
Re: MySQL R39 (+reps) - by Ox1gEN - 22.09.2014, 05:16

Forum Jump:


Users browsing this thread: 1 Guest(s)