[Mattakil]

I got the saving part down(finally!) I moved on to my next thing to save/load which is my factions, they are dynamically created with a command. When you create the faction, the info saves to the table, but my stock won't execute it, and I fucked something up cause it wont print the Query!

pawn Код:

stock LoadFaction(ID)
    {
    new Query[600], string[100], DBResult: Result;
    format(Query, sizeof(Query), "SELECT * FROM `FACTIONS` WHERE `ID` = %d", ID);
    Result = db_query(survival, Query);
    if(db_num_rows(Result))
        {
        new Field[30];
        db_get_field_assoc(Result, "NAME", Field, 30);
        FactionInfo[ID][fName] = Field;
        db_get_field_assoc(Result, "ID", Field, 30);
        FactionInfo[ID][fID] = strval(Field);
        db_get_field_assoc(Result, "INTX", Field, 30);
        FactionInfo[ID][fHQintX] = strval(Field);
        db_get_field_assoc(Result, "INTY", Field, 30);
        FactionInfo[ID][fHQintY] = strval(Field);
        db_get_field_assoc(Result, "INTZ", Field, 30);
        FactionInfo[ID][fHQintZ] = strval(Field);
        db_get_field_assoc(Result, "EXTX", Field, 30);
        FactionInfo[ID][fHQextX] = strval(Field);
        db_get_field_assoc(Result, "EXTY", Field, 30);
        FactionInfo[ID][fHQextY] = strval(Field);
        db_get_field_assoc(Result, "EXTZ", Field, 30);
        FactionInfo[ID][fHQextZ] = strval(Field);
        db_get_field_assoc(Result, "VW", Field, 30);
        FactionInfo[ID][fHQVW] = strval(Field);
        db_get_field_assoc(Result, "INT", Field, 30);
        FactionInfo[ID][fHQint] = strval(Field);
        db_get_field_assoc(Result, "CREATED", Field, 30);
        FactionInfo[ID][fCreated] = strval(Field);
        return 1;
        }
    db_free_result(Result);
    print(Query);
    format(string, sizeof(string), "Faction ID %d loaded successfully", ID);
    print(string);
    return 1;
    }

pawn Код:

stock LoadAllFactions()
{
    for(new i = 0; i < 10; i++)
    {
        if(FactionInfo[i][fCreated] == 1)
        {
            LoadFaction(i);
        }
    }
}