#include <a_samp>
#include <sscanf2>
#include <zcmd>
#include <mysql>

#undef MAX_PLAYERS
#define MAX_PLAYERS     5

main() {}

enum E_PLAYER
{
        pUID,
        pName[24],
        pCash,
        Float:pHealth,
        Float:pArmor,
        pSkin,
        Float:pPosX,
        Float:pPosY,
        Float:pPosZ
}

new PlayerCache[MAX_PLAYERS][E_PLAYER];

public OnGameModeInit()
{
        mysql_init(LOG_ONLY_ERRORS);
        mysql_connect("db4free.net", "ardo", "xx", "sampardo");

        AddPlayerClass(0,144.1138,-83.7225,1.5781,49.8798,0,0,0,0,0,0);
        return 1;
}

public OnPlayerConnect(playerid)
{
        new name[MAX_PLAYER_NAME];
        GetPlayerName(playerid, name, MAX_PLAYER_NAME);

        new query[128];
        new data[128];

        format(query, sizeof(query), "SELECT * FROM members WHERE name = '%s'", name);
        mysql_query(query);

        mysql_store_result();
        print(data);
        if(mysql_fetch_row(data, "|"))
        {
                sscanf(data, "p<|>ds[24]ddddfff",
                        PlayerCache[playerid][pUID],
                        PlayerCache[playerid][pName],
                        PlayerCache[playerid][pCash],
                        PlayerCache[playerid][pHealth],
                        PlayerCache[playerid][pArmor],
                        PlayerCache[playerid][pSkin],
                        PlayerCache[playerid][pPosX],
                        PlayerCache[playerid][pPosY],
                        PlayerCache[playerid][pPosZ] );
        } else {
                print("Nie znaleziono konta!");
        }




        mysql_free_result();
        return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
        SetSpawnInfo(playerid, 0, PlayerCache[playerid][pSkin], PlayerCache[playerid][pPosX], PlayerCache[playerid][pPosY], PlayerCache[playerid][pPosZ], 0.0, 0, 0, 0, 0, 0, 0);
        SpawnPlayer(playerid);
        return 1;
}

public OnPlayerSpawn(playerid)
{
        GivePlayerMoney(playerid, PlayerCache[playerid][pCash]);
        SetPlayerHealth(playerid, PlayerCache[playerid][pHealth]);
        SetPlayerArmour(playerid, PlayerCache[playerid][pArmor]);

        SetPlayerPos(playerid, PlayerCache[playerid][pPosX], PlayerCache[playerid][pPosY], PlayerCache[playerid][pPosZ]);

        SendClientMessage(playerid, 0xFFFF00FF, "Witaj na serwerze");
        return 1;
}

 CMD:print(playerid, params[])
 {
        print("test");
        return 1;
 }