[Edvin]

Hi all !

I have a problem with function "LoadHouses( )" ...
Here is the code:

Код:

mysql_store_result( );
            
            gsString[ 0 ] = EOS;
            new
                Field[ 128 ],
                X
			;

			if ( mysql_num_rows( ) == 0 )
			{
			    print( "--- There are 0 houses in the database! ---" );
				mysql_free_result( );
				return 1;
			}
			else
			{
				while( mysql_retrieve_row( ) )
				{
				    mysql_fetch_field_row( Field, "HouseID" ); 		X = strval( Field );
				    mysql_fetch_field_row( Field, "Name" ); 		format( H_DATA[ i ][ Name ], 25, "%s", Field );
					mysql_fetch_field_row( Field, "Cost" ); 		H_DATA[ X ][ Cost ] 		= strval( Field );
				    mysql_fetch_field_row( Field, "Sell" ); 		H_DATA[ X ][ Sell ] 		= strval( Field );
				    mysql_fetch_field_row( Field, "Interior" ); 	H_DATA[ X ][ Interior ] 	= strval( Field );
				    mysql_fetch_field_row( Field, "Locked" ); 		H_DATA[ X ][ Locked ] 		= strval( Field );
				    mysql_fetch_field_row( Field, "VirtualWorld" ); H_DATA[ X ][ Virtualworld ] = strval( Field );
				    mysql_fetch_field_row( Field, "IntX" ); 		H_DATA[ X ][ InteriorX ] 	= floatstr( Field );
				    mysql_fetch_field_row( Field, "IntY" ); 		H_DATA[ X ][ InteriorY ] 	= floatstr( Field );
				    mysql_fetch_field_row( Field, "IntZ" );			H_DATA[ X ][ InteriorZ ] 	= floatstr( Field );
					mysql_fetch_field_row( Field, "HouseX" ); 		H_DATA[ X ][ iconx ] 		= floatstr( Field );
					mysql_fetch_field_row( Field, "HouseY" ); 		H_DATA[ X ][ icony ] 		= floatstr( Field );
					mysql_fetch_field_row( Field, "HouseZ" ); 		H_DATA[ X ][ iconz ] 		= floatstr( Field );
					mysql_fetch_field_row( Field, "Rent" ); 		H_DATA[ X ][ Rent ] 		= strval( Field );

					if ( strcmp( H_DATA[ X ][ Name ], "ForSale", true ) == 0 )
						HousePickup[ X ] = CreateDynamicPickup( 1273, 23, H_DATA[ X ][ iconx ], H_DATA[ X ][ icony ], H_DATA[ X ][ iconz ] );	//not bought
					else
						HousePickup[ X ] = CreateDynamicPickup( 1272, 23, H_DATA[ X ][ iconx ], H_DATA[ X ][ icony ], H_DATA[ X ][ iconz ] );	//bought

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

all work fine, it print "1201 houses loaded" in console, but when i enter the game, the 3DTexts and Pickups don't appear ... what is the problem ?

PS> Sorry for bad code identitation

[Edvin]

Bump Up!

Anyone? ... please help me