[KingPersona]

Quote:

Originally Posted by Vince Код: [13:10:00] Saving trunk info [13:10:11] Kicking 5.0.45.1 because they didn't logon to the game. [13:10:37] Trunk info saved That is a 37 second gap. I hope you're using threaded queries?

, in Trunk Info Saved Code :

pawn Код:

}
    printf("Trunk info saved");
}

forward LoadTrunk();
public LoadTrunk()
{
    new arrCoords[13][15];
    new row[256];
    new string[128];
    new idx;
    printf("Loading trunk info");
    while (idx < sizeof(CarInfo))
    {
        format(string, sizeof(string), "SELECT * FROM `trunk` WHERE `ID`=%d", idx);
        mysql_query_ex(string);
        mysql_store_result();
        if(mysql_num_rows() > 0)
        {
            mysql_fetch_row(row);
            split(row, arrCoords, '|');
            mysql_free_result();
            vehTrunk[idx][1] = strval(arrCoords[1]);
            vehTrunkAmmo[idx][1] = strval(arrCoords[2]);
            vehTrunk[idx][2] = strval(arrCoords[3]);
            vehTrunkAmmo[idx][2] = strval(arrCoords[4]);
            vehTrunk[idx][3] = strval(arrCoords[5]);
            vehTrunkAmmo[idx][3] = strval(arrCoords[6]);
            vehTrunk[idx][4] = strval(arrCoords[7]);
            vehTrunkAmmo[idx][4] = strval(arrCoords[8]);
            vehTrunkCounter[idx] = strval(arrCoords[9]);
            vehTrunkArmour[idx] = floatstr(arrCoords[10]);
            vehTrunkMisc[idx][0] = strval(arrCoords[11]);
            vehTrunkMisc[idx][1] = strval(arrCoords[12]);
        }
        mysql_free_result();
        idx++;
    }
    printf("Trunk info loaded.");
    return 1;
}

Saving Trunk Info :

pawn Код:

forward SaveTrunk();
public SaveTrunk()
{
    new idx;
    idx = 0;
    new coordsstring[512];
    printf("Saving trunk info");
    while (idx < sizeof(CarInfo))
    {
        format(coordsstring, sizeof(coordsstring), "UPDATE `trunk` SET `VehTrunk1`=%d,`VehTrunkAmmo1`=%d,`VehTrunk2`=%d,`VehTrunkAmmo2`=%d,`VehTrunk3`=%d,`VehTrunkAmmo3`=%d,`VehTrunk4`=%d,`VehTrunkAmmo4`=%d,`vehTrunkCounter`=%d,`vehTrunkArmour`=%f,`vehTrunkMisc1`=%d,`vehTrunkMisc2`=%d WHERE ID=%d",
        vehTrunk[idx][1],
        vehTrunkAmmo[idx][1],
        vehTrunk[idx][2],
        vehTrunkAmmo[idx][2],
        vehTrunk[idx][3],
        vehTrunkAmmo[idx][3],
        vehTrunk[idx][4],
        vehTrunkAmmo[idx][4],
        vehTrunkCounter[idx],
        vehTrunkArmour[idx],
        vehTrunkMisc[idx][0],
        vehTrunkMisc[idx][1],
        idx);
        mysql_query_ex(coordsstring);
        /*format(coordsstring, sizeof(coordsstring), "INSERT INTO `Trunk` (`VehTrunk1`,`VehTrunkAmmo1`,`VehTrunk2`,`VehTrunkAmmo2`,`VehTrunk3`,`VehTrunkAmmo3`,`VehTrunk4`,`VehTrunkAmmo4`,`vehTrunkCounter`,`vehTrunkArmour`,`vehTrunkMisc1`,`vehTrunkMisc2`) VALUES (%d,%d,%d,%d,%d,%d,%d,%d,%d,%f,%d,%d)",
        vehTrunk[idx][1],
        vehTrunkAmmo[idx][1],
        vehTrunk[idx][2],
        vehTrunkAmmo[idx][2],
        vehTrunk[idx][3],
        vehTrunkAmmo[idx][3],
        vehTrunk[idx][4],
        vehTrunkAmmo[idx][4],
        vehTrunkCounter[idx],
        vehTrunkArmour[idx],
        vehTrunkMisc[idx][0],
        vehTrunkMisc[idx][1]);
        mysql_query_ex(coordsstring);*/
        idx++;
    }
    printf("Trunk info saved");
}

forward LoadTrunk();
public LoadTrunk()
{
    new arrCoords[13][15];
    new row[256];
    new string[128];
    new idx;
    printf("Loading trunk info");
    while (idx < sizeof(CarInfo))
    {
        format(string, sizeof(string), "SELECT * FROM `trunk` WHERE `ID`=%d", idx);
        mysql_query_ex(string);
        mysql_store_result();
        if(mysql_num_rows() > 0)
        {
            mysql_fetch_row(row);
            split(row, arrCoords, '|');
            mysql_free_result();
            vehTrunk[idx][1] = strval(arrCoords[1]);
            vehTrunkAmmo[idx][1] = strval(arrCoords[2]);
            vehTrunk[idx][2] = strval(arrCoords[3]);
            vehTrunkAmmo[idx][2] = strval(arrCoords[4]);
            vehTrunk[idx][3] = strval(arrCoords[5]);
            vehTrunkAmmo[idx][3] = strval(arrCoords[6]);
            vehTrunk[idx][4] = strval(arrCoords[7]);
            vehTrunkAmmo[idx][4] = strval(arrCoords[8]);
            vehTrunkCounter[idx] = strval(arrCoords[9]);
            vehTrunkArmour[idx] = floatstr(arrCoords[10]);
            vehTrunkMisc[idx][0] = strval(arrCoords[11]);
            vehTrunkMisc[idx][1] = strval(arrCoords[12]);
        }
        mysql_free_result();
        idx++;
    }
    printf("Trunk info loaded.");
    return 1;
}