Update Flash file and link to MSSQL (II)

**Currently looking for Jaipur (India) based coders only.** This is a repost but with some more work carried out since the original project posting. The last coder did not complete the project and did not provide the .fla file (their employee left and took the file), but we do have more files (and own the copyright) since the original project posting was. These should make the development of a new .fla file by you far easier: The [login to view URL] attached is from the original fla file which we need updating. The main reason for the need to update the attached flash file is that there is a newer naming system but also that there are now many more sub-branches and genetic markers discovered. You will be required to edit these sub-branches (seen when you click on any 'Continue' button), add the additional branch structures and genetic markers to the flash file. The 'backbone' tree also needs updating and textual content linked to a database needs to be displayed. ## Deliverables I have included the transcript of the past coder so that you can see where the files were used in context. The [login to view URL] attached is from the original fla file which we need updating. The main reason for the need to update the attached flash file is that there is a newer naming system but also that there are now many more sub-branches and genetic markers discovered. You will be required to edit these sub-branches (seen when you click on any 'Continue' button), add the additional branch structures and genetic markers to the flash file. The 'backbone' tree also needs updating and textual content linked to a database needs to be displayed. The full tree can be viewed in [login to view URL] Alter the image of the backbone tree to reflect the newer one ([login to view URL]) Notice that the order of the groups have been changed slightly, additional branching added, and two additional groups have been added (S and T). The S and T groups should be coloured black and grey respectively (which we'll probably alter later). Notice that an alteration of the backbone tree needs to be made in several places i) the compressed/flat version on the purple and green tabs ii) in the green 'Y-haplogroup tree'. The compressed/flat versions have 'hotspots'. That is, in the purple tab rolling over the groups shows the different pie-charts on the map. And on the green tab, clicking a group will display the path to get to that group. Note that the paths have letters and numbers associated with them - both on the basic tree and also the detailed branches (seen when you click 'Continue' on each group. These are genetic markers required to be in a particular group. Because of newly discovered markers, there are now many markers that have to fit on the tree, often in the same position (which means the display gets crowded). E.g. group E has about 18 different markers for it (you can see this on the main tree ([login to view URL]) It isn't possible to display all of them on the pages and so small flyout boxes (like a javascript tooltip) should be used that display the extra information. If there are 3 or more markers at the same position (i.e. identical markers), 2 markers should be displayed together with the small flyout box to display the rest of the markers. The width of the swf file is to be increased to 1100px but this is to include an additional column of text on the right-hand side. When someone hovers over a group letter on the compressed tree, the age of the group (in thousands of years), and some additional information appear on the right hand side. This occur if it is the purple or green tab. The textual marker information needs to come from an MSSQL table which you will need to create and connect to using classic ASP. When the user hovers over a marker (or set of markers) as above, then textual information (as above) is displayed in the right-hand side. This would include the age of the marker and some background text about geographical origins. Again, this data will be held in an MSSQL table - the fields of which you will have to create. The textual information window on the right-hand side column should be vertically scrollable to account for longer pieces of text. The scrollbars should look the same as in some of the 'Continue' sub-branch sections. The 'header' i.e. version reference, instructions and company name can all be spaced out along the top to take into account the wider, 1100px graphic. The purple and green colour blocks can also be widened to the right. Note that the look and feel should be close to the original, and NOT what the past coder had provided. * * *This broadcast message was sent to all bidders on Thursday Sep 3, 2009 2:03:02 PM: Hello all, thank you for bidding. One of the bidders was from a city I will be moving to in a few weeks time and so I have chosen to work with them - the project is a little complicated and would benefit from working face-to-face for a bit. But if it doesn't work out then I may re-contact you at a later date.