MySQL Varibles Returning Problem
#2

Can't get why did you use the split function to get only the player's IP, a query is enaugh, by the way
pawn Код:
new
    query[128],
    name[24],
    escpname[24],
    IP[16];
GetPlayerName(playerid, name, sizeof name);
GetPlayerIp(playerid, IP, sizeof IP);
mysql_real_escape_string(name, escpname);
format(query, sizeof(query), "SELECT * FROM `users` WHERE `Name` = '%s' AND `IP` = '%s'", escpname, IP);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0) {
    //Player is auto ip logined
}
Reply


Messages In This Thread
MySQL Varibles Returning Problem - by Kyle - 13.04.2011, 10:47
Re: MySQL Varibles Returning Problem - by Alby Fire - 13.04.2011, 11:35
Re: MySQL Varibles Returning Problem - by JaTochNietDan - 13.04.2011, 13:54
Re: MySQL Varibles Returning Problem - by Alby Fire - 13.04.2011, 15:51
Re: MySQL Varibles Returning Problem - by JaTochNietDan - 13.04.2011, 17:08
Re: MySQL Varibles Returning Problem - by Calgon - 13.04.2011, 17:47
Re: MySQL Varibles Returning Problem - by JaTochNietDan - 13.04.2011, 17:52
Re: MySQL Varibles Returning Problem - by Calgon - 13.04.2011, 18:07
Re: MySQL Varibles Returning Problem - by Carrot - 13.04.2011, 18:16

Forum Jump:


Users browsing this thread: 2 Guest(s)