MySQL Problem : mysql_fetch_field_row
#2

do it like this
pawn Код:
public OnPlayerConnect(playerid)
{
    new P_Name[MAX_PLAYER_NAME],String[128];
    GetPlayerName(playerid,P_Name,sizeof(P_Name));
    //Mysql
    format(String, sizeof(String), "SELECT IP FROM `p_data` WHERE username = '%s' LIMIT 1", P_Name);
    mysql_query(String);
    /*new query_run = mysql_query(String);
    if(!query_run) return SendClientMessage(playerid,C_WHITE,"Qeury Failed!");
    else
    SendClientMessage(playerid,C_WHITE,"Qeury Run!");*/

    mysql_store_result();
    if(mysql_num_rows() == 0)
    {
        format(String,sizeof(String),"Welcome %s, This account is not registerd use /register to register your account.",P_Name);
        SendClientMessage(playerid,C_YGREEN,String);
        //Account Registration on PlayerConnect
        //ShowPlayerDialog(playerid,D_REGISTER,3,"Account Registration","Your Account is not Registered in oue data. \nPlease Type a Password To Register.","Register","Cancel");
    }
    else
    {
        new ip[15];
        mysql_fetch_field_row(ip,"IP");
        format(String,sizeof(String),"Welcome back %s ....\nPlease Type password to login.\nIP: %s",P_Name,ip);
        ShowPlayerDialog(playerid,D_LOGIN,3,"Account Login",String,"Login","Cancel");
    }
    mysql_free_result();
    return 1;
}
Reply


Messages In This Thread
MySQL Problem : mysql_fetch_field_row - by Shabi RoxX - 11.02.2012, 12:14
Re: MySQL Problem : mysql_fetch_field_row - by Tanush123 - 11.02.2012, 12:27

Forum Jump:


Users browsing this thread: 1 Guest(s)