[Noles2197]

How can I make it save these coordinates using SQLite and then load them back when the game mode restarts? I'd also want it to assign each pickup created a number.

pawn Code:

CMD:house(playerid, params[]){
    if(Bit16_Get(g_Admin,playerid) == 5) { // If the player is an admin
        new Float:x,Float:y,Float:z;
        GetPlayerPos(playerid,x,y,z);
        CreateDynamicPickup(1273,1,x,y,z);
        new query[128];
        format(query,sizeof(query),"INSERT INTO houses (X,Y,Z) VALUES (%f,%f,%f)",x,y,z);
        db_query(houses,query);
    }
    return 1;
}