SQL house problem
#6

Hello.
I think this is what you want.

PHP код:
forward OnHousesLoaded();
public 
OnHousesLoaded()
{
    if(!
cache_get_row_count()) returnprint("No houses were loaded.");
    else
    {
        new    
houses cache_get_row_count();
        
printf("%d houses Loaded!",houses);
        new 
PropertyString[250];
        for(new 
housesi++)
        {
            
HouseInfo[i+1][hID] = cache_get_field_content_int(i,"ID");
            
cache_get_field_content(i,"Owner",HouseInfo[i+1][hOwner],sql,129);
            
HouseInfo[i+1][hPrice]=cache_get_field_content_int(i,"Price");
            
cache_get_field_content(i,"Name",HouseInfo[i+1][hDiscription],sql,129);
            
HouseInfo[i+1][hInteriorX]=cache_get_field_content_float(i,"InteriorX");
            
HouseInfo[i+1][hInteriorY]=cache_get_field_content_float(i,"InteriorY");
            
HouseInfo[i+1][hInteriorZ]=cache_get_field_content_float(i,"InteriorZ");
            
HouseInfo[i+1][hExteriorX]=cache_get_field_content_float(i,"ExteriorX");
            
HouseInfo[i+1][hExteriorY]=cache_get_field_content_float(i,"ExteriorY");
            
HouseInfo[i+1][hExteriorZ]=cache_get_field_content_float(i,"ExteriorZ");
            
HouseInfo[i+1][hOwned]=cache_get_field_content_int(i,"Owned");
            
HouseInfo[i+1][hRentabil]=cache_get_field_content_int(i,"Rentabil");
            
HouseInfo[i+1][hRentPrice]=cache_get_field_content_int(i,"RentPrice");
            
HouseInfo[i+1][hLevel]=cache_get_field_content_int(i,"Level");
            if(
HouseInfo[i+1][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+1][hID],HouseInfo[i+1][hDiscription],HouseInfo[i+1][hPrice],HouseInfo[i+1][hLevel]);
                
HouseLabel[i+1] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i+1][hExteriorX], HouseInfo[i+1][hExteriorY], HouseInfo[i+1][hExteriorZ],40,0);
                
printf("%d loaded ",HouseInfo[i+1][hID]);
            }
            else if(
HouseInfo[i+1][hOwned] == 1)
            {
                if(
HouseInfo[i+1][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+1][hDiscription],HouseInfo[i+1][hID],HouseInfo[i+1][hOwner],HouseInfo[i+1][hRentPrice],HouseInfo[i+1][hLevel]);
                    
HouseLabel[i+1] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i+1][hExteriorX], HouseInfo[i+1][hExteriorY], HouseInfo[i+1][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+1][hDiscription],HouseInfo[i+1][hID],HouseInfo[i+1][hOwner], HouseInfo[i+1][hLevel]);
                    
HouseLabel[i+1] = Create3DTextLabel(PropertyString ,0x09FF00FF,HouseInfo[i+1][hExteriorX], HouseInfo[i+1][hExteriorY], HouseInfo[i+1][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)