01.01.2016, 22:18
Alright, so. Everything saves fine into my database.
But whenever it loads the data from the database everything goes well except the variables.
In my log it shows which things it got from the database like the level, money, job, skin etc.
But it doesn't set the player level to the value it got from the database or the money or anything really.
Here is my SavePlayer.
Here is my OnAccountLoad.
And this is what triggers the OnAccountLoad.
This is the log.
My level is set to 117, my money to 110, and my skin to 97 instead of 60..
But whenever it loads the data from the database everything goes well except the variables.
In my log it shows which things it got from the database like the level, money, job, skin etc.
But it doesn't set the player level to the value it got from the database or the money or anything really.
Here is my SavePlayer.
Код:
stock SavePlayer(playerid)
{
new query[1024], aName[MAX_PLAYER_NAME];
GetPlayerName(playerid, aName, sizeof(aName));
mysql_format(mysql, query, sizeof(query), "UPDATE accounts SET AdminLevel = '%d', Age = '%d', Gender = '%d', Skin = '%d', Money = '%d', Level = '%d', Job = '%d', Materials = '%d', Drugs ='%d' WHERE ID = '%d'", pInfo[playerid][pAdminLevel], pInfo[playerid][pAge], pInfo[playerid][pGender], GetPlayerSkin(playerid), GetPlayerMoney(playerid), GetPlayerScore(playerid), pInfo[playerid][pJob], pInfo[playerid][pMaterials], pInfo[playerid][pDrugs], pInfo[playerid][pID]);
mysql_tquery(mysql, query);
printf("Player ID %d (%s) has been saved", playerid, GetName(playerid));
}
Код:
public OnAccountLoad(playerid)
{
pInfo[playerid][pAdminLevel] = cache_get_field_content_int(0, "AdminLevel");
pInfo[playerid][pSkin] = cache_get_field_content_int(0, "Skin");
pInfo[playerid][pAge] = cache_get_field_content_int(0, "Age");
pInfo[playerid][pGender] = cache_get_field_content_int(0, "Gender");
pInfo[playerid][pMoney] = cache_get_field_content_int(0, "Money");
pInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level");
pInfo[playerid][pJob] = cache_get_field_content_int(0, "Job");
pInfo[playerid][pMaterials] = cache_get_field_content_int(0, "Materials");
pInfo[playerid][pDrugs] = cache_get_field_content_int(0, "Drugs");
cache_get_field_content(playerid,"Email",pInfo[playerid][pEmail],mysql,256);
SetPlayerColor(playerid, COLOR_WHITE);
GivePlayerMoney(playerid, pInfo[playerid][pMoney]);
SetPlayerScore(playerid, pInfo[playerid][pLevel]);
SetPlayerSkin(playerid, pInfo[playerid][pSkin]);
SetSpawnInfo(playerid, 0, pInfo[playerid][pSkin], 1799.9459, -1867.2007, 13.5705, 2.0529, 0, 0, 0, 0, 0, 0);
SpawnPlayer(playerid);
if(pInfo[playerid][pAdminLevel] > 0)
{
new string[256], string2[256], aName[MAX_PLAYER_NAME];
format(string, sizeof(string), "You have logged in as a level %d admin.", pInfo[playerid][pAdminLevel]);
SendClientMessage(playerid, -1, string);
GetPlayerName(playerid, aName, sizeof(aName));
format(string2, sizeof(string2), "(+) Admin %s has just logged in!", aName);
AdminChat(string2, COLOR_ADMIN);
}
SendClientMessage(playerid, -1, "Successfully logged in");
return 1;
}
Код:
case DIALOG_LOGIN:
{
if(!response) Kick(playerid);
new hpass[129];
new query[100];
WP_Hash(hpass, 129, inputtext);
if(!strcmp(hpass, pInfo[playerid][pPassword]))
{
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", GetName(playerid));
mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);
}
else
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "MaxZone: Login", "Welcome\n\nPlease enter your password.", "Login", "Quit");
SendClientMessage(playerid, -1, "You have entered the wrong password.");
}
}
Код:
[00:06:52] [DEBUG] Calling callback "OnAccountLoad".. [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "AdminLevel", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "AdminLevel", data: "2" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Skin", data: "60" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Age", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Age", data: "16" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Gender", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Gender", data: "1" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Money", data: "75000" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Level", data: "1" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Job", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Job", data: "0" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Materials", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Materials", data: "0" [00:06:52] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Drugs", connection: 1 [00:06:52] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Drugs", data: "0"
