SQL house problem
#1

I am working at an house system and i have a small problem.
well , in the database i have 3 houses which have id 1,2,3
when the server loads the index loads them like 0,1,2
if i increase the index the server loads only 1,2
is there any way of making id 1 ingame to be id 1 in database ?
Codes:
PHP код:
forward OnHousesLoaded();
public 
OnHousesLoaded()
{
    if(!
cache_get_row_count()) return print("No houses were loaded."); 
    else
    {
        new 
houses cache_get_row_count();
        
printf("%d houses Loaded!",houses);
        new 
PropertyString[250];
        for(new 
housesi++)
        {
            
HouseInfo[i][hID] = cache_get_field_content_int(i,"ID");
            
cache_get_field_content(i,"Owner",HouseInfo[i][hOwner],sql,129);
            
HouseInfo[i][hPrice] = cache_get_field_content_int(i,"Price");
            
cache_get_field_content(i,"Name",HouseInfo[i][hDiscription],sql,129);
            
HouseInfo[i][hInteriorX] = cache_get_field_content_float(i,"InteriorX");
            
HouseInfo[i][hInteriorY] = cache_get_field_content_float(i,"InteriorY");
            
HouseInfo[i][hInteriorZ] = cache_get_field_content_float(i,"InteriorZ");
            
HouseInfo[i][hExteriorX] = cache_get_field_content_float(i,"ExteriorX");
            
HouseInfo[i][hExteriorY] = cache_get_field_content_float(i,"ExteriorY");
            
HouseInfo[i][hExteriorZ] = cache_get_field_content_float(i,"ExteriorZ");
            
HouseInfo[i][hOwned] = cache_get_field_content_int(i,"Owned");
            
HouseInfo[i][hRentabil] = cache_get_field_content_int(i,"Rentabil");
            
HouseInfo[i][hRentPrice] = cache_get_field_content_int(i,"RentPrice");
            
HouseInfo[i][hLevel] = cache_get_field_content_int(i,"Level");
            if(
HouseInfo[i][hOwned] == 0)
            {
                
format(PropertyStringsizeof(PropertyString),"{347235}House {FFFFFF}%d \n{347235}Aceasta casa este de vanzare ! \nDescriere: {FFFFFF}%s \n{347235}Pret: {FFFFFF}$%d \n{347235}Level: {FFFFFF}%d \n{347235}to buy this house type /buyhouse",HouseInfo[i][hID],HouseInfo[i][hDiscription],HouseInfo[i][hPrice],HouseInfo[i][hLevel]);
                
HouseLabel[i] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i][hExteriorX], HouseInfo[i][hExteriorY], HouseInfo[i][hExteriorZ],40,0);
                
printf("%d loaded ",HouseInfo[i][hID]);
            }
            else if(
HouseInfo[i][hOwned] == 1)
            {
                if(
HouseInfo[i][hRentabil] == 1)
                {
                    
format(PropertyStringsizeof(PropertyString),"{FFFFFF}%s\n {347235}House {FFFFFF}%d \n{347235}Aceasta casa ii apartine lui  {FFFFFF}%s \n{347235}Rent: {FFFFFF}$%d \n{347235}Level: {FFFFFF}%d \n{347235}to rent a room type /rentroom",HouseInfo[i][hDiscription],HouseInfo[i][hID],HouseInfo[i][hOwner],HouseInfo[i][hRentPrice],HouseInfo[i][hLevel]);
                    
HouseLabel[i] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i][hExteriorX], HouseInfo[i][hExteriorY], HouseInfo[i][hExteriorZ],40,0);
                }
                else
                {
                    
format(PropertyStringsizeof(PropertyString),"{FFFFFF}Descriere :%s\n {347235}House {FFFFFF}%d \n{347235}Aceasta casa ii apartine lui {FFFFFF}%s \n{347235}Level: {FFFFFF}%d",HouseInfo[i][hDiscription],HouseInfo[i][hID],HouseInfo[i][hOwner], HouseInfo[i][hLevel]);
                    
HouseLabel[i] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i][hExteriorX], HouseInfo[i][hExteriorY], HouseInfo[i][hExteriorZ],40,0);
                }
            }
        }
    } 
    return 
1;

Reply


Messages In This Thread
SQL house problem - by TheDarkBlade - 30.09.2016, 18:57
Re: SQL house problem - by MEW273 - 30.09.2016, 19:32
Re: SQL house problem - by TheDarkBlade - 30.09.2016, 20:13
Re: SQL house problem - by TheDarkBlade - 01.10.2016, 05:33
Re: SQL house problem - by TheDarkBlade - 01.10.2016, 10:22
Re: SQL house problem - by Mencent - 01.10.2016, 11:28
Re: SQL house problem - by TheDarkBlade - 01.10.2016, 18:02
Re: SQL house problem - by TheDarkBlade - 01.10.2016, 20:30
Re: SQL house problem - by Ner0x96 - 01.10.2016, 20:31

Forum Jump:


Users browsing this thread: 1 Guest(s)