[Danijel.]

What is wrong with this code?!?! I have been trying for an hour to get it work.

Code:

stock LoadPlayerHouse(houseid)
{
	new PropertyString[256], DBResult: Result, Field[22], Query[350];
       	
	format(Query, sizeof(Query), "SELECT * FROM HOUSES WHERE ID = %d", houseid);
	Result = db_query(Database, Query);
	if(db_num_rows(Result) == 1)
	{
 		printf("\n\nHouse ID: %d" ,houseid);
  		    
   		db_get_field_assoc(Result, "NAME", Field, 30);
    	format(HouseInfo[houseid][hName], MAX_PLAYER_NAME, "%s", Field);
  		    
	    printf("\nVlasnik: %s", HouseInfo[houseid][hName]);
  		    
		db_get_field_assoc(Result, "FOR_SELL", Field, 30);
		PlayerInfo[houseid][hSellable] = strval(Field);
			
		printf("Kuca na prodaju = %d", PlayerInfo[houseid][hSellable]);
			
		db_get_field_assoc(Result, "SELL_PRICE", Field, 30);
		PlayerInfo[houseid][hSell] = strval(Field);
			
		printf("Cijena: $%d ", PlayerInfo[houseid][hSell]);
			
		db_get_field_assoc(Result, "RENT_PRICE", Field, 30);
		PlayerInfo[houseid][hRent] = strval(Field);
		db_get_field_assoc(Result, "HOUSE_LEVEL", Field, 30);
		PlayerInfo[houseid][hLevel] = strval(Field);
		db_get_field_assoc(Result, "X", Field, 30);
		PlayerInfo[houseid][hExitX] = strval(Field);
		db_get_field_assoc(Result, "Y", Field, 30);
		PlayerInfo[houseid][hExitY] = strval(Field);
		db_get_field_assoc(Result, "Z", Field, 30);
		PlayerInfo[houseid][hExitZ] = strval(Field);
			
		printf("Koordinate:  %f   %f   %f  ", PlayerInfo[houseid][hExitX], PlayerInfo[houseid][hExitY], PlayerInfo[houseid][hExitZ]);
			
		db_get_field_assoc(Result, "VW", Field, 30);
		PlayerInfo[houseid][hVirtualWorld] = strval(Field);
		db_get_field_assoc(Result, "STATUS", Field, 30);
		PlayerInfo[houseid][hLocked] = strval(Field);

       	if(HouseInfo[houseid][hSellable] == 1)
		{
		    print("Na prodaju");
			format(PropertyString,sizeof(PropertyString),"Kuca na prodaju!\nVlasnik: %s \n ID: %d \n Cijena: $%d \n Level: %d",HouseInfo[houseid][hName],houseid, HouseInfo[houseid][hSell], HouseInfo[houseid][hLevel]);
warning 213: tag mismatch -------> HouseInfo[houseid][hLabel] = Create3DTextLabel(PropertyString ,0x00FF00AA,HouseInfo[houseid][hExitX], HouseInfo[houseid][hExitY], HouseInfo[houseid][hExitZ],25.0, 0, 1);
			HouseInfo[houseid][hPickup] = CreateDynamicPickup(1273, 1, HouseInfo[houseid][hExitX], HouseInfo[houseid][hExitY], HouseInfo[houseid][hExitZ]);
		}
		else
		{
			format(PropertyString,sizeof(PropertyString),"Vlasnik: %s \n ID: %d \n Rent: $%d",HouseInfo[houseid][hName],houseid, HouseInfo[houseid][hRent]);
warning 213: tag mismatch -------> HouseInfo[houseid][hLabel] = Create3DTextLabel(PropertyString ,0x00FFFFAA,HouseInfo[houseid][hExitX], HouseInfo[houseid][hExitY], HouseInfo[houseid][hExitZ],25.0, 0, 1);
			HouseInfo[houseid][hPickup] = CreateDynamicPickup(1272, 1, HouseInfo[houseid][hExitX], HouseInfo[houseid][hExitY], HouseInfo[houseid][hExitZ]);
		}
	}
 	db_free_result(Result);
	return true;
}

The textraws and pickups are not created and there is something wrong with variable values.



EDIT: FIXED!!!!