Mysql Query

Mysql Query
I am looking for a Mysql expert to check my Mysql query and find out why it is not working. There must be some kind of syntax error but I can’t fi9nd it. Attached it the actual file and a file with the current query and new query. This should be a slam dunk 5 minute job for someone

Product Customization Design

Product Customization Design
Summary: Allow an end user to select product (up to 10 products), select color, select special feature (special service, rush order), select or upload multiple artworks, a special instruction field, quantity, calculate estimated total cost, and submit the design (uploaded artwork, design, color code defined) to the administrator for quote/confirmation. The administrator have a backend system (MySQL or MSSQL)that generate a confirmation number for the saved design and ability to change quantity, update pricing, or change feature to reflect the actual pricing (if the end user messed up). The system will link to a UPS rate tool to determine the actual shipping cost with the determined total product weight. The customer will receive an email with the link to either back to the design site, enter in the confirmation number to complete the order with payment gateway linked to Payflow Pro, or a link directly to the payment gateway to pay for the order, and after payment the order will be marked as Paid.

The system must consist of the option to override online payment if we choose not to use it for specific order, instead an end user may pay by mail-in checks or net 30 days. (Mark as paid option)

Specific Details:
1) A backend system to add/update/remove product, colors, special feature, and cost calculations.
2) A customer portal to allow customer to register, enter contact, billing and shipping information, save their order, and view status of the order.
3) A backend system that allow the administrator to update the order status (tracking#) for the customer to review
4) Clipart color can be changed using a predetermined color chart.
5) Clipart are to categorized (based on directory layout?)
6) Uploaded artwork provide the end user a comment field to define the colors from a predetermined color chart.
7) All artwork must be cropped at the edge of the product.
8) A text editor to add custom text
9) All item in the design can be resize, rotate, and layered.
10) All artwork including uploaded artwork can become transparent (remove white).
11) Special service option or/and allow the customer to upload additional document like Excel spreadsheet, word docs along with a comment / instruction field along with the order.
12) Option for Re-ordering the same design with ability to modify quantity, or re-loading design and modifying previously placed order.

Codeigniter Membership

Codeigniter Membership
LIST ONLY CODEIGNITER WEBSITE REFERENCES.
Don’t just send me a list of websites. All bids that do this will be automatically rejected.

NO UPFRONT PAYMENTS
Payment is broken down into modules, as each is completed uploaded to my server, tested and approved, money is released.

SERVE AS TECHNICAL LEAD
Integrate work from other providers into membership module.

$100 BONUS if you keep to deadlines and finish on time.

Provider must have extensive Code Igniter experience. Provider will complete current membership functions that are either not complete, fix existing bugs and create new codes as stated in Membership MSWord document. The site is built on Codeigniter 2.0 with Web 2.0 and be viewable on Window IE and Mozilla and Macintosh. Detailed document for Regular Membership and jpgs of page layouts will be shared with the provider chosen.

Membership has 4 levels – 3 paid, 1 free. There are payment calculations (member fee upgrade or downgrade), there are reward points for various activities, limitations to features depending on memberlevel, recurring billing for member fees. Payment gateway is authorize.net. Members can create groups, do mass mailing, upload multiple photos and videos which needs to be converted to .flv files and dynamic delivery, and much more.

There is use of FFMPEG with videos and provider is expected to install and configure it for membership.

There are other providers working on different modules of the website and provider will need to share codeigniter codes with those providers so that they interface properly with membership. For example, membership level, status needs to be validated in other modules prior to granting access to privileges, recording of purchases and reward points needs to be recorded in members’ accounts.

Thanks for your attention.

Centos Admin + Mysql Recovery

Centos Admin + Mysql Recovery
There was an issue on a server of ours, I don’t know all of the exact details, but one of our databases is not showing all tables, only about half of the tables are available.

This job is for a sysadmin who can use CentOS and SSH to try and recover lost database tables. Also, we’ll want to setup the new database and site on a new server that is ready.

Thank you, this is job is for right now.

Auto Remotesite Backup Script

Auto Remotesite Backup Script
hello

i need a backup script. It should be able to fetch phpmyadmin mysql database & the ftp folders i mention in the script. I have hosting at Dreamhost. The files should be pulled into another ftp i mention

How it should work

1) Backup Mysql databases & FTP Files ( all folders or selected folders) i mention in a config file
2) Transfer it to a remote FTP ( Another FTP)
3) It would be cool if it will be saved as a single .zip or.rar file
4) Can be AUto setup to do this automatically peroidically (per week)

I need the script made & if you need host panel access come on teamviewer

available by any messenger. Payement by paypal

Website Gallery With Bio Clone

Website Gallery With Bio Clone
I would like a clone of this website www.definebabe.com. I believe this site is written in php or html but I’m open to other languages, however I prefer php. I want a secure admin with full control of the website. I due want some changes. I would like to change how the pictures appear. If you take a look at www.fancybox.net this is how I want the pic to appear from the sets. If we could darken the background the better. To make myself clear the picture that blow up from small to big in another page I want them to pop up. In the page with the individuals info i need the sites featuring moved and space to add a shore bio on each individual person. As I stated before I want a clone so everything that this site provides banners, search, a through z I want a clone as they might say.

I will not put a price because it might be a lot of work so I don’t want to under estimate. Give me a quote and if it fits my budget we can work out a deal.

Will need a database written in mysql for all info. Unless you know of something else we can use.

Adult Website 4in1

Adult Website 4in1
Hi I’m looking for a great team with great feedback to design an adult website for me.

its 4 websites all linked together. I will be selling sex toys so I will need database and admin to upload pictures and text with a log-in for members as well as payment gateway.

A website for gay chat with lesbian chat, and website for 3x videos all with chat rooms.

only those with exceptional feedback will get the job!

Oscommerice Designer & Writer

Oscommerice Designer & Writer
We have OsCommerice Site as www.rackave.com ,
looking for a team or company for long term partner.

*Web graphic
*Back-end add on.
*Products discription writer
*Policy writer

*Google adword writing
*SEO, static html…
*Marketting, Landing page.

We pay by case.
We can pay 10% ~ 15% in front to star the job, as long as delivery on time.

Please send your proforlos.