MySQL Help?
#1

I am wanting to Load Houses from my MySQL Database but this aint working for what I have now;

pawn Код:
forward LoadHouse();
public LoadHouse()
{
    //new file[128];
    for(new h = 0; h<MAX_HOUSES; h++)
    {
        format(Query, sizeof(Query), "SELECT * FROM Houses WHERE EntX = '%f', EntY = '%f', EntZ = '%f', IntX = '%f', IntY = '%f', IntZ = '%f', Interior = '%d', Owned = '%d'", HouseInfo[h][hEnterX], HouseInfo[h][hEnterY], HouseInfo[h][hEnterZ], HouseInfo[h][hExitX], HouseInfo[h][hExitY], HouseInfo[h][hExitZ], HouseInfo[h][hInt], HouseInfo[h][hOwned]);
        mysql_query(Query);
        CreatePickup(1239, 1, HouseInfo[h][hEnterX], HouseInfo[h][hEnterY], HouseInfo[h][hEnterZ], 0);
        //format(file, sizeof(file), "Houses/%d.ini", h);
        /*if(dini_Exists(file))
        {
            HouseInfo[h][hEnterX] = dini_Float(file, "EnterX");
            HouseInfo[h][hEnterY] = dini_Float(file, "EnterY");
            HouseInfo[h][hEnterZ] = dini_Float(file, "EnterZ");
            HouseInfo[h][hExitX] = dini_Float(file, "ExitX");
            HouseInfo[h][hExitY] = dini_Float(file, "ExitY");
            HouseInfo[h][hExitZ] = dini_Float(file, "ExitZ");
            HouseInfo[h][hInt] = dini_Int(file, "Interior");
            CreatePickup(1273, 1, HouseInfo[h][hEnterX], HouseInfo[h][hEnterY], HouseInfo[h][hEnterZ], 0);
        }*/

    }
    print("Debug: Loaded Houses!");
    return 1;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)