houses are not loading from database properly[REP +]
#1

pawn Код:
stock LoadProperty()
    {
    mysql_query("SELECT * FROM `houses` ORDER BY `houses`.`hid` ASC");
    mysql_store_result();
    new query[256];
    if(mysql_num_rows() > 0)
    {
    for(new idx = 0; idx < mysql_num_rows(); idx++)
    {
    mysql_fetch_row(query);
    sscanf(query,"p<|>ids[32]ffffffds[20]dds[64]d",
    HouseInfo[idx][hid],
    HouseInfo[idx][hOwned],
    HouseInfo[idx][hOwner],
    HouseInfo[idx][hEntrancex],
    HouseInfo[idx][hEntrancey],
    HouseInfo[idx][hEntrancez],
    HouseInfo[idx][hExitx],
    HouseInfo[idx][hExity],
    HouseInfo[idx][hExitz],
    HouseInfo[idx][hHealthx],
    HouseInfo[idx][hHealthy],
    HouseInfo[idx][hHealthz],
    HouseInfo[idx][hArmourx],
    HouseInfo[idx][hArmoury],
    HouseInfo[idx][hArmourz],
    HouseInfo[idx][hValue],
    HouseInfo[idx][hHel],
    HouseInfo[idx][hArm],
    HouseInfo[idx][hInt],
    HouseInfo[idx][hLock],
    HouseInfo[idx][hRooms],
    HouseInfo[idx][hRent],
    HouseInfo[idx][hRentabil],
    HouseInfo[idx][hTakings],
    HouseInfo[idx][hSetted],
    HouseInfo[idx][hLevel],
    HouseInfo[idx][hWorld],
    HouseInfo[idx][hDrugs],
    HouseInfo[idx][hMaterials],
    HouseInfo[idx][hWeapon1],
    HouseInfo[idx][hAmmo1],
    HouseInfo[idx][hWeapon2],
    HouseInfo[idx][hAmmo2],
    HouseInfo[idx][hWeapon3],
    HouseInfo[idx][hAmmo3],
    HouseInfo[idx][hWeapon4],
    HouseInfo[idx][hAmmo4],
    HouseInfo[idx][hWeapon5],
    HouseInfo[idx][hAmmo5],
    HouseInfo[idx][hWeapon6],
    HouseInfo[idx][hAmmo6],
    HouseInfo[idx][hMessage]);
    MAXHOUSES++;
    }
    }
    mysql_free_result(),
    printf("\nHouses From Database Loaded"),
    printf("\nInfo:Houses From Database:%d\n",MAXHOUSES);
    return 1;
}
Houses aren't loading from database properly
I know that I have mistake in this line
pawn Код:
sscanf(query,"p<|>ids[32]ffffffds[20]dds[64]d",
but I don't know how to fix it
Reply


Messages In This Thread
houses are not loading from database properly[REP +] - by rati555 - 10.02.2012, 16:21
Re: houses are not loading from database properly[REP +] - by MP2 - 10.02.2012, 16:23
Re: houses are not loading from database properly[REP +] - by rati555 - 10.02.2012, 16:35
Re : houses are not loading from database properly[REP +] - by OGL0C - 10.02.2012, 16:37
Re: houses are not loading from database properly[REP +] - by rati555 - 10.02.2012, 16:58

Forum Jump:


Users browsing this thread: 1 Guest(s)