EasyScripting System V2.0 sa-mp.de

/*
@autor whitetiiger
@time 12.07.2016 9:48Uhr
@table houses
@version 1.0
@ext OnFactionFinish()
*/
#define MAX_FACTION [Hier Maximale Anzahl eintragen]


enum faction_data
{
    bool:fdActive,
    fdId,
    fdUser_id,
    Float:fdPosX,
    Float:fdPosY,
    Float:fdPosZ,
    Float:fdPrice,

}
new FactionData[MAX_FACTION][faction_data];



stock LoadAllFaction()
{
    new query[128];
    format(query, 128, "SELECT * FROM houses");
    mysql_tquery(Handle, query, "OnLoadAllFaction", "");
    return 1;
}

forward OnLoadAllFaction();
public OnLoadAllFaction()
{
    new rows, fields;
    cache_get_data(rows, fields, Handle);
    for(new i = 0; i < rows; i++)
    {
        new factionid = GetFreeFactionID();
        if(factionid == -1) return -1;
        FactionData[factionid][fdId] = cache_get_field_content_int(i, "id", Handle);
        FactionData[factionid][fdUser_id] = cache_get_field_content_int(i, "user_id", Handle);
        FactionData[factionid][fdPosX] = cache_get_field_content_float(i,"posX",Handle);
        FactionData[factionid][fdPosY] = cache_get_field_content_float(i,"posY",Handle);
        FactionData[factionid][fdPosZ] = cache_get_field_content_float(i,"posZ",Handle);
        FactionData[factionid][fdPrice] = cache_get_field_content_float(i,"price",Handle);
        OnFactionFinish(factionid);
    }
    return 1;
}

stock LoadFactionByID(Id)
{
    new query[128];
    format(query, 128, "SELECT * FROM houses WHERE id = '%d'",Id);
    mysql_tquery(Handle, query, "OnLoadFactionByID", "");
    return 1;
}

forward OnLoadFactionByID();
public OnLoadFactionByID()
{
    new factionid = GetFreeFactionID();
    if(factionid == -1) return -1;

    FactionData[factionid][fdId] = cache_get_field_content_int(0, "id", Handle);
    FactionData[factionid][fdUser_id] = cache_get_field_content_int(0, "user_id", Handle);
    FactionData[factionid][fdPosX] = cache_get_field_content_float(0,"posX",Handle);
    FactionData[factionid][fdPosY] = cache_get_field_content_float(0,"posY",Handle);
    FactionData[factionid][fdPosZ] = cache_get_field_content_float(0,"posZ",Handle);
    FactionData[factionid][fdPrice] = cache_get_field_content_float(0,"price",Handle);
    OnFactionFinish(factionid);
    return 1;
}

stock OnFactionFinish(factionid)
{
    FactionData[factionid][fdActive] = true;
    return 1;
}

stock ReloadFactionByID(factionid)
{
    DestroyFaction(factionid);
    LoadFactionByID(FactionData[factionid][fdId]);
    return 1;
}

stock CreateFaction() Hier Parameter anpassen!
{
    new factionid = GetFreeFactionID(), Float:Pos[3];
    if(factionid == -1) return -1;
    GetPlayerPos(playerid, Pos[0], Pos[1], Pos[2]);
    new query[128]; Länge anpassen!
    format(query, sizeof(query), "INSERT INTO `houses`(`user_id`, `posX`, `posY`, `posZ`, `price`) VALUES ('%d', '%f', '%f', '%f', '%f')",value);
    mysql_tquery(Handle, query, "OnCreateFaction", "");
    return factionid;
}

forward OnCreateFaction();
public OnCreateFaction()
{
    LoadFactionByID(cache_insert_id());
    return 1;
}
stock SaveFaction(factionid)
{
    new query[177];
    format(query,sizeof(query),"UPDATE `houses` SET  `user_id` = '%d',  `posX` = '%f',  `posY` = '%f',  `posZ` = '%f',  `price` = '%f' WHERE id='%d'", FactionData[factionid][fdUser_id],  FactionData[factionid][fdPosX],  FactionData[factionid][fdPosY],  FactionData[factionid][fdPosZ],  FactionData[factionid][fdPrice], FactionData[factionid][fdId]);
    mysql_tquery(Handle, query, "", "");
    return 1;
}


stock DeleteFaction(factionid)
{
    if(FactionData[factionid][fdActive] == false) return -2;
    new query[128];
    format(query, 128, "DELETE FROM `houses` WHERE id = '%d'",FactionData[factionid][fdId]);
    mysql_tquery(Handle, query, "", "");
    FactionData[factionid][fdActive] = false;
    return 1;
}

stock DestroyFaction(factionid)
{
    if(FactionData[factionid][fdActive] == false) return -2;
    FactionData[factionid][fdActive] = false;
    return 1;
}

stock GetFreeFactionID()
{
    for(new factionid=0; factionid<MAX_FACTION; factionid++)
    {
        if(FactionData[factionid][fdActive] == true) continue;
        return factionid;
    }
    return -1;
}

stock GetFactionCount()
{
    new count = 0;
    for(new factionid=0; factionid<MAX_FACTION; factionid++)
    {
        if(FactionData[factionid][fdActive] == false) continue;
        count ++;
    }
    return count;
}

stock getNearstFaction(playerid) {
    new x = -1, Float: distanz[2];
    for(new factionid; factionid <MAX_FACTION; factionid++) {
        distanz[0] = GetPlayerDistanceFromPoint(playerid, FactionData[factionid][fdPosX], FactionData[factionid][fdPosY], FactionData[factionid][fdPosZ]);
        if(FactionData[factionid][fdActive] == true && distanz[0] < distanz[1]) x = factionid, distanz[1] = distanz[0];
    }
    return x;
}

stock GetFactionID(dbID)
{
    for(new factionid=0; factionid <MAX_FACTION; factionid++)
    {
        if(FactionData[factionid][fdActive] == false) continue;
        if(dbID != FactionData[factionid][fdId]) continue;
        return factionid;
    }
    return -1;
}