I need an interface to a server side database which will be client based (ie Flash) and embedded into a Web based .Aspx page as found at www.fullbe.com.
The application will read the database, return XML into Flash and Flash will render the information. The Flash application will show a line representation of the relationships. The data consists of the number of people a person follows in twitter. Hence the xml feed will read as follows:
The table structures are then
FollowerID int identity(1,1) primary key,
FolloweeID int identity(1,1) primary key
FFID int identity(1,1) primary key
The data is then displayed in a line radial form similar to the following display:
[url removed, login to view]
Note: the mouseover, drag operations are NOT required. The Flash program will just draw lines from the center of the movieclip to the individual people names who are being followed (followees). So if a person follows 10 people in Twitter, he will have his name at the center and then 10 lines radially drawn to the 10 names of the followees. The spacing between the lines will be equal. So the 360 degrees in a circle will be divided and then simple geometric work will calculate the position on the cirle, eg 36 degrees for each name to separate, ie cos(angle) * radius = height, radius can be fixed at 200 pixels but entered as a parameter from the xml, eg <circle size=200/>
When the user clicks on the name on the circle the program will link to the following:
[url removed, login to view] where name is the actual followee name taken from the XML.
.NET and 3.5 should be used and Flash CS4 with Actionscript.
Summary: the User will be able to see all the people his follows in a diagram and then click on a followee name to link to the pages on fullbe which use that name. You can assume the data about followee is already available and no code is required for that.
The coding style in Flash Actionscript needs to be clear as the editor is not that easy for the Actionscript, and written to allow easy maintanence and addition of new functions. Final code to be source code in Flash, and .NET 3.5.