Car system pradžia :)

/*

                    Mašinų sistemos pradžia
                           MySQL R5/6
                         Y_CMD
                    (c) Bičas - 2014-06-20

*/

#include <a_samp>
#include <a_mysql>
#include <YSI\y_commands>

enum pINFO
{
    Car
}

enum cINFO
{
    Savininkas[MAX_PLAYER_NAME],
    Modelis,
    Spalva1,
    Spalva2,
    Float:PosX,
    Float:PosY,
    Float:PosZ,
    Float:PosA
}

new
    pInfo[MAX_PLAYERS][pINFO],
    cInfo[MAX_PLAYERS][cINFO]
;

public OnPlayerConnect(playerid)
{
    LoadVehicle(playerid);
    return true;
}

public OnPlayerDisconnect(playerid)
{
    SaveVehicle(playerid);
    return true;
}

stock GetPlayerNameA(playerid) // By bičas
{
    new
        Name[MAX_PLAYER_NAME]
    ;
    GetPlayerName(playerid, Name);
    return Name;
}

stock SaveVehicle(playerid)
{
    new
        Query[128],
        pos[4]
    ;
    GetVehiclePos(pInfo[playerid][Car], pos[0], pos[1], pos[2]);
    GetVehicleZAngle(pInfo[playerid][Car], pos[3]);
    format(Query, sizeof(Query), "UPDATE `masinos` SET Modelis = '%d', Spalva1 = '%d', Spalva2 = '%d', X = '%f', Y = '%f', Z = '%f', A = '%f' WHERE Savininkas = '%s'",
    cInfo[playerid][Modelis], cInfo[playerid][Spalva1], cInfo[playerid][spalva2], pos[0], pos[1], pos[2], pos[3], GetPlayerNameA(playerid));
    mysql_query(Query);
}

stock LoadVehicle(playerid)
{
    new
        Query[128],
        Fetch[64]
    ;
    format(Query, sizeof(Query), "SELECT * FROM `masinos` WHERE Savininkas = '%s' LIMIT 1", GetPlayerNameA(playerid));
    mysql_query(Query);
    mysql_store_result();
    mysql_retrieve_row();
    mysql_fetch_field_row(cInfo[playerid][Savininkas], "Savininkas");
    mysql_fetch_field_row(fetch, "Modelis"); cInfo[playerid][Modelis] = strval(fetch);
    mysql_fetch_field_row(fetch, "Spalva1"); cInfo[playerid][Spalva1] = strval(fetch);
    mysql_fetch_field_row(fetch, "Spalva2"); cInfo[playerid][Spalva2] = strval(fetch);
    mysql_fetch_field_row(fetch, "X"); cInfo[playerid][PosX] = strval(fetch);
    mysql_fetch_field_row(fetch, "Y"); cInfo[playerid][PosY] = strval(fetch);
    mysql_fetch_field_row(fetch, "Z"); cInfo[playerid][PosZ] = strval(fetch);
    mysql_fetch_field_row(fetch, "A"); cInfo[playerid][PosA] = strval(fetch);
    pInfo[playerid][Car] = CreateVehicle(cInfo[playerid][Modelis], cInfo[playerid][PosX], cInfo[playerid][PosY], cInfo[playerid][PosZ], cInfo[playerid][PosA], cInfo[playerid][Spalva1], cInfo[playerid][Spalva2], -1);
    mysql_free_result();
}

CMD:buycar(playerid, params[])
{
    #pragma unused params
    new
        Query[128]
    ;
    format(Query, sizeof(Query), "INSERT INTO `masinos` (Savininkas, Modelis, Spalva1, Spalva2) VALUES ('%s', '%d', '%d', '%d')", GetPlayerNameA(playerid), 411, 0, 0);
    LoadVehicle(playerid);
    return true;
}