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?