Category: MYSQL Projects

MYSQL Projects

Updates To Existing Website

Updates To Existing Website
These updates are strictly for the programmer maborak. Please, no one else submit a bid. They will be deleted either way.

Private Image/NSFW checkbox before uploading images. Also user (that uploaded the image) and administrator can change this in File Manager and View page. Something like this:
http://any-image.com/images/11889432193526448331.jpg Has an option to select all as NSFW or Public. Default is public

User management for administrators. Add, delete, change groups, number of images each user has uploaded, how many total views a user’s images have, total bandwidth, & total image size, ect.

Get Edit & Delete buttons to work in the File Manager.

Forgot password link for login page.

Page for top ten images of the day (based on view count). Resets at midnight.

Change page title on view page to the name of the image for better SEO.

Social Network App For Iphone

Social Network App For Iphone
I’m looking for an iPhone App to be developed for the iPhone.

This project will require connecting to a mysql database from the iPhone to store and retrieve information including user and session management.

It also requires interfacing with the facebook api so knowledge of the facebook api is needed. It will also interface with the twitter api but that can come at a later stage.

Here are some prototype screenshots to give you an idea of what the app will be like:
http://thinkcoupons.ca/iphone-screenshots.pdf

More details and specs will be provided to candidates via private messages and to the winning bid.

Opengts Installation/config

Opengts Installation/config
Hi,
we’re looking for someone preferably with previous experience in installing and confiuring the opengts opensource GPS tracking software.
for more information about the opengts GPS tracking software please visit:http://opengts.sourceforge.net

what we need exactly is some support for configuring the opengts particulary setting up the connection to mysql server as we already have the basic opengts installed in a window remote server but we’re having some trouble to connect to mysql gts database from tomcat.
we also need to add some new tracking devices currentely 1 to 3 devices this will invlove the modification of the template server in the opengts to parse received data and insert it into the SQL database and support the new devices wich all of them sends messages to the server using a socket-based communication protocol,the required skills for editing and adding new devices are:[Java, TCP/UDP socket communication, multi-threading, bitwise manipulation, general client/server protocols].

If you have the required skills to do the job please feel free to bid on the project or contact us for further information.

Web2print B2b Solution

Web2print B2b Solution
Need a web2print programming and a new website design like vistaprint.com,http://iprint.com, http://www.digitalroom.com. Customers will have the capability to:
1) Select a pre-made template (could be business cards, letter head, flyers, etc)
2) customer upload own file for printing and preview proof before sent (PDF)
3) Be able to modify or customize pre-design templates
4) Be able to do all editing with real time preview before order
5) Show be light vistaprint.com as much as possible with its functionality.
6) This programme must be search engine friendly
7) Multi Language (French and English)
8) 2 Online Payment options
9) Enter in his corporate account to have his pre-selected template
Admin should be able to:
————————
1) Add templates with ease.
2) The project the customer completed should be PRINT ready – ie, CMYK output of PDF or other CMYK formats.
3) Admin should be able to print multiple business cards per page
4) Should be able to process credit card and or paypal payment 🙂
5) Customize the layout with ease.
6) Should be able to integrate not only business cards, but other print products such as Banner, Offset print digital print,Postcards, Flyers, etc.
7) Should be able to add pre-made template

Its more for B2B application for large corporation that have many repetitive print with same kind of changes every time…

Would be happy to work with the right programmer to get the right product.

Thanks

Mysql Database Fixes Asap

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

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.

Database Finalize Mysql Expert

Database Finalize Mysql Expert
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.

Ajax Div Forward & Back

Ajax Div Forward & Back
I have a AJAX driven div which gets certain information from a MYSQL database. I want to save the AJAX commands in the browser cache/cookie(not sure where), the commands can be recalled by a back and forth button sitting inside/outside the DIV whichh will call back the last commands(content) very similar to how browser’s have Forward and Back buttons to go to past viewed pages. Need instructions on how to use cache saved commands. Is this even possible?

Please only bid if you can do this. No spammers please.

Psd To Xhtml/css And Web Form

Psd To Xhtml/css And Web Form
I need the two PSD files (attached) converted to high quality, well-formed XHTML/CSS.

I also need the “innerPage.psd” to include a simple web form (specs to be provided) to gather RSVP info and populate a mySQL DB. After populating DB (full form validation; check for duplicates; etc) it should show a “Thank You” page.

Threaded Mysql C Api App. Bug

Threaded Mysql C Api App. Bug
We have a constant running Linux application with 2 threads, a (query)producer and (query)consumer. Every 2-3 days a crash occurs. Here is the gdb backtrace of the core file:

#0 0x006bf910 in my_malloc () from /usr/lib/mysql/libmysqlclient_r.so.15
#1 0x006c2caa in memdup_root () from /usr/lib/mysql/libmysqlclient_r.so.15
#2 0x006e6b23 in unpack_fields () from /usr/lib/mysql/libmysqlclient_r.so.15
#3 0x006e70b3 in mysql_read_default_options () from /usr/lib/mysql/libmysqlclient_r.so.15
#4 0x006e54f4 in mysql_free_result () from /usr/lib/mysql/libmysqlclient_r.so.15
#5 0x080d8698 in MYSQL_OBJ::Exec (this=0x899abe0,
qry=0x89a2fb8 “SELECT * FROM conntbl WHERE (id1=’57783′ AND id2=’41508′) OR (id1=’41508′ AND id2=’57783′)”)
at ce.cpp:4704
#6 0x080db4ae in MYSQL_OBJ::RunNextQuery_ifLastResult_isProcessed (this=0x899abe0) at ce.cpp:4493
#7 0x080f0c4c in SqlThread (ptr=0x80fa2bf) at xs.cpp:53
#8 0x00c8d73b in __pthread_initialize_minimal_internal () from /lib/libpthread.so.0
#9 0x00c0bcfe in tdestroy_recurse () from /lib/libc.so.6

We need a threadprogramming/mysql api expert, who helps us to remove this bug.

Programming Project 1270832783

Programming Project 1270832783
Okay programmers listen up,

I’m about to open my business and we need a website set up.

This website will consist of two open source sites. The CMS will be Php-Fusion, and the shopping cart will be Zen-Cart.

We will need to integrate their databases so customers can login to both sites with the same account info.

We would like both admin back ends merged into one if its possible.

We will need a add-on build into Php-Fusion; It will be a Computer Repair Tracking System:

Computer Repair Tracking Functions:

Admin:

Add a Computer to the tracking system, info would include; Tracking number, Date started, Computer manufacture, Problem Reported, Solution, Repair status (Pending, In Progress, Delayed, Canceled, Compete), Date stopped

Display Page:

Search Field (for searching for tracking numbers) Display a list of the latest 40 per page, Tracking number, Date started, Computer manufacture, Repair status (Pending, In Progress, Delayed, Canceled, Compete), Date Compete/Canceled
Clicking the Tracking number will pull up a more detailed page displaying Tracking number, Date started, Computer manufacture, Problem Reported, Solution, Repair status (Pending, In Progress, Delayed, Canceled, Compete), Date Compete/Canceled (Also, PDF Print Option)

Please do not ask me about my budget, just bid the amount you would need.

Please include -234546- into your PM or Bid message to show that you have read the projects requirements.

ALSO!!!!!
If you feel that you would want to replace the open source scripts that I have picked with another, please explain why you would like to use that one over the one I have chosen.

Thank you.

Install Fatfree Crm (ror)

Install Fatfree Crm (ror)
Hello,

We are looking for someone to install FatFree CRM on our web server. FatFree is open-source CRM developed using Ruby On Rails.

More information on FatFree CRM can be found here:

http://fatfreecrm.com/
http://github.com/michaeldv/fat_free_crm

We are looking for a company to install this web application on a Site5 shared server that is already running Ruby (1.8.7) and Rails (2.3.5).

In addition to running the app on our server you will need to perform two other simple functions:

– Import data from our existing CRM system (to be supplied as a CSV file) using this plugin: http://github.com/michaeldv/crm_highrise_importer.

– Install the “Dropbox” plugin to sync the CRM system with our email. This plugin can be found here: http://github.com/pranab/crm_email

No customization to FatFree will be necessary at this stage. We are simply looking for you to install the application and it’s already existing plugins.

Thanks!