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.