We’re new to freelancer. Looking for highly committed, motivated, honest and skilled support. We’ll start with small projects to get acquainted, but have a large backlog of work needing a wide range of skills (MYSQL, PHP, SQlite, AS3, Flash CS5, HTML5, Jquery). We carefully set up our projects so they can be easily followed.
First project is to read an SQLite database using AS3 code, perform simple calculations and write data to an fla file. The fla is fully designed, only the coding is required. There are 10 steps to the project as described below.
We will provide fla example of how everything should work. We will also provide the SQLite database and starting AS3 code. This project will be plugged-in to a large flash desktop application (we will do the plug-in). Code must be clean and efficient.
10 Steps for this project:
1. Read an SQLite table and populate a dynamic combo-box with one of the columns (workgroup_name)
2. When a workgroup_name is selected from the combo-box, do the following for all records related to that row->id:
a. Read an SQLite table, count the users and place the total into a dynamic text field
b. Read a 2nd SQlite table, count the users and place the total into a dynamic text field, then find the latest last_updated date and place that in a dynamic text field
c. Read an SQLite table and average the values in 4 different columns, round averages for 2 sets of columns to 100 and write all 4 number results to a dynamic text field
d. Read an SQlite table using the 4 values in step c to assign a “strength” to each value and place an MC next to that value (sample code will be given for this calculation)
e. Perform an algorithm to determine the profile_string and profile_code (the algorithm will be given, only 1 more calculation must be added)
f. Write the profile_string into a dynamic text field
g. Using the profile_code bring an MC onto the stage (x,y coordinates will be given)
h. Write a datagrid with all members in a workgroup (get data from 3 different SQLite tables by matching the user_id or country_id) and code ability to sort the table by clicking on each column heading
i. For each member in the workgroup, plot an MC on the graph (how to select the MC will be given). The user name must show when the MC is rolled-over. The plotting for this graph needs to be discussed. We will start with a simple plot first and may improve it with more complexity later.