01.03.2014, 05:35
(
Последний раз редактировалось Baines; 02.03.2014 в 02:31.
)
Hey guys,
I have recently tried to make an account system with MySQL but it kinda doesn't work. Things are not loaded from the database and are not stored in there. Anyone who could help?
My code:
I have recently tried to make an account system with MySQL but it kinda doesn't work. Things are not loaded from the database and are not stored in there. Anyone who could help?
My code:
Код:
stock LoginPlayer(playerid) { new query[126], pName[MAX_PLAYER_NAME]; GetPlayerName(playerid, pName, MAX_PLAYER_NAME); format(query, sizeof(query), "SELECT * FROM accounts WHERE PlayerName = '%s'", pName); mysql_query(query); mysql_store_result(); if(mysql_retrieve_row()) { mysql_fetch_field_row(stringresult, "PlayerX"); pInfo[playerid][pPos][0] = floatstr(stringresult); mysql_fetch_field_row(stringresult, "PlayerY"); pInfo[playerid][pPos][1] = floatstr(stringresult); mysql_fetch_field_row(stringresult, "PlayerZ"); pInfo[playerid][pPos][2] = floatstr(stringresult); mysql_fetch_field_row(stringresult, "PlayerName"); pInfo[playerid][pPos][0] = strval(stringresult); mysql_fetch_field_row(stringresult, "Password"); pInfo[playerid][pPos][0] = strval(stringresult); mysql_fetch_field_row(stringresult, "Skin"); pInfo[playerid][pPos][0] = strval(stringresult); mysql_fetch_field_row(stringresult, "AdminLevel"); pInfo[playerid][pAdmin] = strval(stringresult); } printf("Player %d (%s) has been loaded.", playerid, pName); SendClientMessage(playerid, COLOR_1BLUE, "You have successfully loged in, please wait while we load your character!"); SetSpawnInfo(playerid, 1, pInfo[playerid][pSkin], pInfo[playerid][pPos][0], pInfo[playerid][pPos][1], pInfo[playerid][pPos][2], 0.0, 0, 0, 0, 0, 0, 0); SetPlayerColor(playerid, -1); SpawnPlayer(playerid); SetCameraBehindPlayer(playerid); } stock savePlayer(playerid) { new query[255], pName[MAX_PLAYER_NAME]; GetPlayerName(playerid, pName, MAX_PLAYER_NAME); GetPlayerPos(playerid, pInfo[playerid][pPos][0], pInfo[playerid][pPos][1], pInfo[playerid][pPos][2]); format(query, sizeof(query), "UPDATE accounts SET PlayerX = '%f', PlayerY = '%f', PlayerZ = '%f', Skin = '%i', AdminLevel = '%i' WHERE PlayerName = '%s'", pInfo[playerid][pPos][0], pInfo[playerid][pPos][1], pInfo[playerid][pPos][2], pInfo[playerid][pSkin], pName); mysql_query(query); printf("Player %d (%s) has been saved.", playerid, pName); }