Can flash do this? Interactive floor plan with DB driven status messages.

Hi! This is my first thread on Flashkit and I hope I do things right. I've tried to seek information about my questions here, but have a hard time to find it. Hopefully you can help me.

As a school project we are creating a software which we are going to sell to clients. We are going to outsource the thing, and we just create the "plan" behind the hole thing. This is our idea.

Create an interacvie floor plan with status messages, for office use. This should be presented on a screen near big office facilities to guide newcommers to the correct office. In addition we would like the office map to show if the office employee are available/busy.

We will divide the hole thing into three sectors.

1. Status client(where the office employee sets his status)

2. Server(handles the requests from the status client)

3. Screen client(shows the floormap with a green or red color over the office, to show available or busy.
I've attached a little picture for you to better understand.

We would like to create the hole thing in flash, but as none of us are developers we will need to seek some advice.

We have the following "issues".

The screen client will need to get the db data for the status of the status client. Then it should present the status as a green or red overlay on the floor plan.
The status will need to be "fresh", so it needs to be updated every 10s or so.

http://bildr.no/thumb/721956.jpeg

I hope you can help me!

Kind regards

Retry

Flash would not be able to do the "whole" thing, it will require some server-side scripting.

In regards to the "issues", I'm not exactly sure what the "issues" are?? You would set up a Timer that would check the database every 10s. Something like PHP would cycle thru each employee & check the database to see if they're busy or not busy. It returns this value to the Flash & the Flash changes the overlay depending on the returned result.

But you kind of said that yourself, so I'm not sure what the question is? :)

Could this be done in Flash? Yes
Could it be done ENTIRELY in Flash? No.

I'm looking for a job I'm 32 years old, and I could set you up the way you want it.
I'm located in Indiana.

I see the floor plan you want to know if this office is busy or not. How ever the client each office member would be using would need a simple action code to set if busy or not. If you want the office personnel to set it or if you want it set instantly when the personnel is using the program or computer ect.

It's not to hard but talking from a forum isn't going to get it done unless you have developing skills or are going to develop it yourself.

And gotoAndCrash is right you would need to use server side scripts.
say pc office one is turned on but the program client status is idle that would send a message to the main client directory service that shows the person how is looking at it who is doing what. This would be a network sending data to some type of service via website mysql or dedicated server.