11.02.2012, 12:27
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;
}