LoadHouses( )
{
	new string[ 128 ], i = 1, pField[ 128 ];
	mysql_query( "SELECT * FROM `Houses`" );
	mysql_store_result( );

	new sqlrows = mysql_num_rows( );
	if ( !sqlrows )
	{
	    print( "--- There are 0 houses in the database! ---" );
		mysql_store_result( );
		return 1;
	}
	else
	{
		while( mysql_fetch_row_format( pField, "|" ) )
		{
		    if ( hID == MAX_HOUSES ) break;
		    
		    Itter_Add(houses, hID);
		    
		    sscanf( pField, "p<|>is[25]iiiiiffffffi", H_DATA[ hID ][ HouseID ], H_DATA[ hID ][ Name ], H_DATA[ hID ][ Cost ], H_DATA[ hID ][ Sell ],
			H_DATA[ hID ][ Interior ], H_DATA[ hID ][ Locked ], H_DATA[ hID ][ Virtualworld ], H_DATA[ hID ][ InteriorX ], H_DATA[ hID ][ InteriorY ], H_DATA[ hID ][ InteriorZ ],
			H_DATA[ hID ][ iconx ], H_DATA[ hID ][ icony ], H_DATA[ hID ][ iconz ], H_DATA[ hID ][ Rent ] );
			
			if ( strcmp( H_DATA[ hID ][ Name ], "ForSale", true ) == 0 )
				HousePickup[ hID ] = CreateDynamicPickup( 1273, 23, H_DATA[ hID ][ iconx ], H_DATA[ hID ][ icony ], H_DATA[ hID ][ iconz ] );	//not bought
			else
				HousePickup[ hID ] = CreateDynamicPickup( 1272, 23, H_DATA[ hID ][ iconx ], H_DATA[ hID ][ icony ], H_DATA[ hID ][ iconz ] );	//bought

			format( string, sizeof( string ), "{FF9900}Owned by\n{00FF00}%s", H_DATA[ hID ][ Name ] );
			housei[ hID ] = CreateDynamic3DTextLabel( string, 0x00808088, H_DATA[ hID ][ iconx ], H_DATA[ hID ][ icony ], H_DATA[ hID ][ iconz ], 30.0 );
			i++;
		}
	}
	printf( "%d houses loaded", i );
	return 1;
}