16.07.2014, 21:59
I gets no error when i compile it. But when i reconnect i have to register again ¤_¤
Here is the Code when the player register:
This is the code where it loads the players information.
Here is the Code when the player register:
Код:
stock RegisterPlayer(playerid, regpass[]) { new query[126], EncryptedPass[130]; WP_Hash(EncryptedPass, sizeof(EncryptedPass), regpass); format(query, sizeof(query), "INSERT INTO accounts (Name, Password, PosX, PosY, PosZ, Skin) VALUES ('%s', '%s', '1.0 2.0 3.0', '1')", GetName(playerid), EncryptedPass); mysql_query(query); LoginPlayer(playerid); return 1; }
Код:
stock LoginPlayer(playerid) { new query[126], pName[MAX_PLAYER_NAME]; GetPlayerName(playerid, pName, sizeof(pName)); format(query, sizeof(query), "SELECT * FROM players WHERE Name = '%s'", pName); mysql_query(query); mysql_store_result(); while(mysql_fetch_row_format(query,"|")) { mysql_fetch_field_row(query, "id"); PlayerInfo[playerid][ID] = strval(query); mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name"); mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password"); mysql_fetch_field_row(query, "AdminLevel"); Player[playerid][AdminLevel] = strval(query); mysql_fetch_field_row(query, "PlayerPos"); sscanf(query, "fff", Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2]); mysql_fetch_field_row(query, "Skin"); Player[playerid][Skin] = strval(query); mysql_fetch_field_row(query, "Money"); Player[playerid][Money] = strval(query); mysql_fetch_field_row(query, "Deaths"); Player[playerid][pDeaths] = strval(query); mysql_fetch_field_row(query, "Kills"); Player[playerid][pKills] = strval(query); mysql_fetch_field_row(query, "Vip"); Player[playerid][vStatus] = strval(query); } GivePlayerMoney(playerid, Player[playerid][Money]); SetSpawnInfo(playerid, 0, 1, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0); }