14.06.2010, 15:06
Quote:
|
Originally Posted by ludow12
I am trying to make an OnPlayerLogin but when I /login, the data not load... but I have the SendClientMessage "You are now connected" correctly.
This is my code, I use R4 VS9 version of this plugin. Код:
public OnPlayerLogin(playerid,password[])
{
new query[256];
new sendername[MAX_PLAYER_NAME];
GetPlayerName(playerid, sendername, sizeof(sendername));
mysql_real_escape_string(password,password);
format(query,sizeof(query),"SELECT * FROM %s WHERE Name = '%s' AND Password = md5('%s') LIMIT 1", TABLENAME, sendername, password);
mysql_query(query);
mysql_store_result(ConnexionBDD);
if(mysql_retrieve_row(ConnexionBDD))
{
new field[11];
mysql_store_result(ConnexionBDD);
mysql_fetch_field_row(field, "Level"); PlayerInfo[playerid][pLevel] = strval(field);
mysql_fetch_field_row(field, "AdminLevel"); PlayerInfo[playerid][pAdmin] = strval(field);
mysql_fetch_field_row(field, "DonateRank"); PlayerInfo[playerid][pDonateRank] = strval(field);
mysql_fetch_field_row(field, "Char"); PlayerInfo[playerid][pChar] = strval(field);
mysql_fetch_field_row(field, "Bank"); PlayerInfo[playerid][pAccount] = strval(field);
mysql_fetch_field_row(field, "Leader"); PlayerInfo[playerid][pLeader] = strval(field);
mysql_fetch_field_row(field, "Member"); PlayerInfo[playerid][pMember] = strval(field);
mysql_fetch_field_row(field, "Rank"); PlayerInfo[playerid][pRank] = strval(field);
mysql_fetch_field_row(field, "Job"); PlayerInfo[playerid][pJob] = strval(field);
mysql_fetch_field_row(field, "Kills"); PlayerInfo[playerid][pKills] = strval(field);
mysql_fetch_field_row(field, "Deaths"); PlayerInfo[playerid][pDeaths] = strval(field);
mysql_fetch_field_row(field, "PhoneBook"); PlayerInfo[playerid][pPhoneBook] = strval(field);
mysql_fetch_field_row(field, "PhoneNr"); PlayerInfo[playerid][pPnumber] = strval(field);
mysql_fetch_field_row(field, "Drugs"); PlayerInfo[playerid][pDrugs] = strval(field);
mysql_fetch_field_row(field, "Warnings"); PlayerInfo[playerid][pWarns] = strval(field);
mysql_fetch_field_row(field, "WarnReason1"); strmid(PlayerInfo[playerid][pWarnReason1], field, 0, strlen(field)-1, 255);
mysql_fetch_field_row(field, "WarnReason2"); strmid(PlayerInfo[playerid][pWarnReason2], field, 0, strlen(field)-1, 255);
mysql_fetch_field_row(field, "WarnReason3"); strmid(PlayerInfo[playerid][pWarnReason3], field, 0, strlen(field)-1, 255);
SendClientMessage(playerid, COLOR_RED, "You are now connected.");
gPlayerLogged[playerid] = 1;
SpawnPlayer(playerid);
}
else
{
SendClientMessage(playerid, COLOR_WHITE, " Wrong password.");
}
mysql_free_result(ConnexionBDD);
return 1;
}
|
What says your mysql_log file?