The database is now functioning inside my system. It is still doing the same thing as it was outside the system but it is in the system and that is the first step accomplished to getting it retrieving the data when you click on the 3D object.

I have managed to get a database working outside of the actual system. You can simply look at the name of the item of furniture in the database and the description of the item. You can go through the rows in the daatabase using next and previous buttons. The next step now is to try and implement it into the system and modify it so that when the user clicks on a 3D object in the sprite it will bring up the name, description and price of the object. I will also try to implement an image of the object.

The game is now working fine online but I am finding out that it seems to be crashing some browsers. I am presuming that the reason is because of the shockwave player that is installed as I came across similar issues when I was doing research for this project and the issue was resolved when i upgraded my shockwave player. I will do more research on this at a later stage.

Had a meeting with Michael today and we had a look at ways to connect to a database and the best way seems to be using an extra for director known as the Arca database. I have downloaded and installed this extra and have installed it into director. I am now doing some research on it and trying to get it to work with my system.

So far I have been unable to modify the script to perform the actions that I want. I have however managed to solve a minor problem I was having. When I was exporting the bathroom and kitchen scenes som of the surrounding walls were not being exported and the reason which I figured out this was happening was because all of the wall segments were named wall and therefore only one was exported.

After some research and looking at different examples of dragging sprites i am now trying to modify the draggable behaviour which is available in the Director library. It functions to the point where it will drag the whole scene around when the left mouse button is pressed down. however I would like it to select the objects in my scene rather than the scene itself.

I have now completed the first draft of my final report and will continue working on the project now. I am currently trying to make the objects draggable around the world and i am trying to interact with a database.

I have now mapped the functions that I had with the left and right mouse buttons to the q and w keys it was a simple matter of finding out what numbers relate to q and w. For example the number 124 refers to when the right arrow key is pressed and the number 12 and 13 refer to the keys q and w.

The camera navigation is also working now however there is a problem that i will have to overcome as I have gotten rid of the left mouse down function as that is what is used to select the objects so the main rotation is the right mouse down function and unfortunatley that will not work on the internet when the game is published. This should only be a mere setback as changing the function to another key shouldn't prove to be too difficult.

I have got the navigation of rooms working with the selection of the objects. I have also improved the navigation. I used to have it simply going to the next room and the previous room but now it goes to a specific marker. I tried this before and it didn't work but I managed to solve the problem which turned out to be rather basic. the problem was that i never changed the flash properties of the buttons to AlwaysPass instead of NeverPass. The rest of it all works on a basis of set markers and pause frames.

I have managed to select different objects in the room and have the name of the object selected returned to the user. I have it working with two of the previously stated picking methods. With ModelUnderLoc it selects the object the the user has clicked on and with ModelsUnderLoc it selects the object clicked on but also all the objects that are under the object that was clicked on. The next step that I will try and resolve is to get what I have working now working with what i previously had done which is moving from room to room and the camera navigation through the room.

Successfully managed to single out different objects inside of the sitting room scene. Object just simply rotates in a continuous 360 degrees but it is the first step to getting done what I want. In order to this I had to attach the objects together in 3DS Max instead of simply grouping them like I was doing.

after looking at the 5 different ways of picking I have decided that the most suited one for what I am looking for is ModelsUnderLoc.

Picking lingo is the way forward. it allows you to enable objects in a 3D cast member to respond to and recieve mouse clicks.
There are 5 Lingo functions used to create picking:

	modelUnderLoc
	modelsUnderLoc
	modelUnderRay
	spriteSpacetoWorldSpace
	worldSpaceToSpriteSpace

aftert trying a few techniques and doing a bit more research I have found out that selecting models (picking) refers to clicking on models in a 3D cast member. Because models are objects that exist
within a 3D cast member and a 3D sprite, they are not normally sensitive to mouse clicks. Normally, only the entire sprite is sensitive to mouse clicks. to overcome this i will have to create scripts to select the sprites and determine which sprite has been clicked on. this has to be done by using cast members or camera methods

started working on getting the sprites in the rooms to be able to be moved around by the user. what i am after finding out after doing this is that 3DS Max 9 no longer supports the exporting of .hke files which are what i nedd to import into director with the w3d files. i also found out that adobe director 11.5 the latest release of director does not support havoc anymore and instead uses AGEIA PhysX. so what im presented with now is that i have to abandon my idea of using the havoc engine and try to program it using lingo.

tried to resolve the problem but to no avail. created final rooms which i am happy with. inserted them into director and changed the navigation to make it more neat and user friendly. will do more work on trying to get it online and get it interacting with a database

trying to publish movie onto the website. slight problem. in the publish settings there is no area where it asks me what version i want to publish for shockwave. getting an error whwn i try to view the movie. "the page that you are trying to open contains a movie that is referenced to an incorrect version of the shockwave player". tried changing html code to both shockwave 8.5 and 10 but to no avail