Author: Blancer

Mysql Database Fixes Asap
I have a database that gathers checked out orders from a website that needs to be completed it is 90% done , it does recognize checked out order compared to previewed orders , it has multi admin levels , its for a essay writing company, basically how it works it the writers log in and get their own log in and password , then they simply grab the checked out orders that come in once done writing the essays then they simply upload it to the database where the proofers can come in and proof the essays out. Also there is a writing manager admin and a regional manager , and just Admin , and a proofing manager admin , all have dif access , all this is all ready done in the database . Right now i have a guy working on it but he needs little more help. All this is all ready done in the database but we are just basically making the database more user friendly. I paid a guy all ready to get it to this point but now i need another to wrap it up and help this guy whos working on finish it up. Larry the guy who is working on it now is basically cleaning up the code to make it easier for the next person to do the database and try to get my user friendly fixes done to it but is taking to long. I have 4 sites that need to be connected to the database. The database need to be in each site so the sites dont link out to another site for SEO purposes i dont want any of my 4 sites linking out to any sites. Please list bid amounts that would cover 2 to 3 weeks of work. Must be able to start asap. I want to finish this project.

PROGRAMMER NOTES FROM WHAT HE DID

‘ve included the “initial” requests jordan made to me about what he wanted done.

I went through and I’m fairly certain I have all the trivial changes completed.

in a nut shell here are the issues(reiterated in detail in the readme)

-the guy did the quick develop based on as I understand it a poor set of specs which were misunderstood. …

there are 213 files, to produce what should be capably accomplished in at least half that.

as an example: there are 2 inbox setups, one for customers(which the previous developer called orders,, i.e it is an inbox for the order, not an inbox for a user) and one for a staff member

… there is a language issue … he used inbox to denote email, and list of inboxes/inboxlist to denote “inbox” as we normally would think of it.

so the code is a hard to read due to the language barrier, and b hard to follow because he apparently hard coded as much as he could get away with.

some of the “relatively” simple and typical things one would do to make the overall architecture standard he DID NOT do. so there is not a user type, and he uses a pseudo-global $staffId to house the staffID or the customer ID depending on which logged in… etc.. and there may be other things I haven’t stumbled across or was too scared to appreciate.

I have done a LOT of programming but I am only slightly familiar with mySQL, (love the crash course) so I have tried to avoid messing with any of the queries and have been focusing on refactoring each page configuration down to a single page so that the changes can be universalized (somewhere between 3 and 10 different pages to view orders depending on what the “user” was intended to see as opposed to one page with flags from a databaseImage removed by sender.)

and somehow by consolidating the left menu pane i broke the login!(yeah i feel stupid, i uploaded all the old archive code and tried again and it is all the same less one line(which shouldn’t do anything?!) so yeah frustrating.

_________

What I need done I have on seperate email and attached images as well for updates to make the database more user friendly.

*Make email system handle 1000 emails a week
*Make reply button work in email system
*Make new menu for writers , proofers , writing Managers , regional managers , proofing managers , so that when they grab an order it till go to my order menu so they know what they have grabbed
*Make payroll system work auto link it to the writers paypal account
*Any more minor fixes needed I might add for 2-3 weeks.

I need this done asap am willing to pay good money for this to be done right. Budget is 1000-2000US to get this done.

Coldfusion/mysql Website. 2
Fantasy Football Website

This website should be coded in Coldfusion with a MySQL 5.x. I already have a theme, the layout and css written for this site. The site will allow users to create accounts in which they can then view reports based on the stored data. The users will purchase the rights to own an account via a PayPal pre-coded button which will be installed at a later time. The site will include 3 forms, one to capture the users new account info, and one that will email one of our experts directly, and a page that allows the owner to enter the players on their team. The site template has already been selected, so the designer will be responsible more for functionality than look and feel. Upon a users registration/sign-in, the home page will then give the user a more custom look based on the information stored in the user table. At this point the user will then be able to look at different reports via PDF’s and results of coded queries. Outside of the a couple of swapped images to give the user a custom feel, an email form and the one time original user info form, the site will be highly static. It will simply allow the user to look over information stored in our database(handled by imbedded queries, sorts), and reports created and uploaded by me.

The query driven pages will display the upcoming week projections and the upcoming year projections for Quarterback, Running Back, Wide Receiver, Tight End, Kicker and Team Defense. These results pages must give the user the ability to sort the data by the requested categories. There will be a query page that gives the user an optimal starting lineup by using his players that he has entered and comparing them to the current weeks projections. There will be a query page that displays updated player news based on the players the user has entered as his. Please note this is AMERICAN FOOTBALL (NFL) NOT SOCCER, not that it matters for this project, but just so you understand. Thank you.

Only submit an offer if you are familiar with Coldfusion, MySQL 5.x, working with a windows based server, upon acceptance of an offer i will email you a zip file with all the information and screen shots that you will need to complete the task.