[Marcuse]

PHP код:

enum friendsEnum{
    bool: online,
    imePrijatelja[25], //Friend name
    serverid,
    dbid
}
new Friends[MAX_PLAYERS][MAX_FRIENDS][friendsEnum]; 


That function is called before OnAccountLoad (Before the query anyway)

PHP код:

hook OnPlayerConnect(playerid){
    new q[128];
    ResetPlayerVariables(playerid);
    mysql_format(con, q, sizeof(q),"SELECT `Id`, `Password`, `Banned` FROM `Players` WHERE `Username` = '%e' LIMIT 1", ImeIgraca(playerid));
    mysql_tquery(con, q, "OnAccountCheck", "i", playerid);
    CleanChat(playerid, 20);
    return true;
} 


PHP код:

protected OnAccountLoad(playerid)
{
    LoadPlayerTextDraws(playerid);
    PData[playerid][Id]         =     cache_get_field_content_int(0, "Id");
    cache_get_field_content(0, "Email", PData[playerid][Email], con, 150);
    PData[playerid][Sex]         =     cache_get_field_content_int(0, "Sex");
    cache_get_field_content(0, "Country", PData[playerid][Country], con, 40);
    PData[playerid][Admin]        =     cache_get_field_content_int(0, "Admin");
    PData[playerid][GameMaster]    =     cache_get_field_content_int(0, "GM");
    PData[playerid][StaffCode]    =     cache_get_field_content_int(0, "SCode");
    cache_get_field_content(0, "Banned", PData[playerid][Banned], con, 255);
    PData[playerid][Level]    =     cache_get_field_content_int(0, "Level");
    PData[playerid][Exp]    =     cache_get_field_content_int(0, "Exp");
    PData[playerid][Skin]    =     cache_get_field_content_int(0, "Skin");
    PData[playerid][Money]    =     cache_get_field_content_int(0, "Money");
    PData[playerid][Bank]    =     cache_get_field_content_int(0, "Bank");
    loadFriendsForPlayer(playerid);
    alertFriendsOnConnection(playerid);
    SetPlayerSpawn(playerid);
    return true;
} 


PHP код:

stock ResetPlayerVariables(playerid){
    setUpFriendVars(playerid);
    format(PData[playerid][Password], 150, "");
    format(PData[playerid][Email], 100, "");
    PData[playerid][LoginErrors] = 0;
    PData[playerid][StaffCodeErrors] = 0;
    PData[playerid][Id] = 0;
    PData[playerid][Sex] = 0;
    PData[playerid][Admin] = 0;
    PData[playerid][GameMaster] = 0;
    PData[playerid][StaffCode] = 0;
    PData[playerid][Level] = 0;
    PData[playerid][Exp] = 0;
    PData[playerid][Money] = 0;
    PData[playerid][Bank] = 0;
    PData[playerid][Skin] = 0;
    PData[playerid][StaffLogged] = false;
    PData[playerid][StaffDuty] = false;
    format(PData[playerid][Banned], 255, "");
    ResetFriendRequest(playerid);
    return true;
}