Blancer.com Tutorials and projects

my registered users sell digital downloads i need my registered users to be able to setup a buy one get two downloads free promotions package for the content they sell.

I have bought 5 wordpress sites that I need to install onto my server. It is one hosting plan with 5 addon domains for the installations. I have setup blank databases for the sites.

I have complete cpanel backups for the sites.

I would be very interested in updating to the newest wordpress version and keeping only the themes and content for each. I would like or each to have the same plugins and admin login details. I would like very clean installations with all of the unnecessary files and plugins removed.

Assignment 1: Table Queries Create a SQL Server database for Kudler Fine Foods Virtual Organization.

Using the SQL CREATE statement, create the following tables using the fields listed below:

Note: Supply the SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, use a listed fields as the table’s primary key or create an additional field to use as the primary key. The primary key from the Job Title table appears as the foreign key in the Employee table.

• Employee
 Employee ID
 Last name
 First name
 Address
 City
 State
 Telephone area code
 Telephone number
 Employer Information Report (EEO-1) classification
 Hire date
 Salary
 Gender
 Age
 Foreign key from Job Title table
• Job_title
 EEO-1 classification
 Job title
 Job description
 Exempt / non-exempt status

Using the SQL INSERT statement:
• Go to the Human Resources department in the Kudler Fine Foods Virtual Organization. Using information found in the Employee Files for the La Jolla and Encinitas stores, enter records into the employee table for the following employees:
 Glenn Edelman
 Eric McMullen
 Raj Slentz
 Erin Broun
 Donald Carpenter
 David Esquivez
 Nancy Sharp
• Use the information from the Kudler Fine Foods Job Classifications and Job Descriptions to enter records into the Job Title table for the following job titles:
 Accounting Clerk
 Assistant Manager
 Bagger
 Cashier
 Computer Support Specialist
 Director of Finance & Accounting
 Retail Assistant Bakery & Pastry
 Retail Assistant Butchers and Seafood Specialists
 Stocker

Check the results by selecting all of the columns from both tables. Non-Exempt employees at Kudler Fine Foods are paid an hour ly wage and are required to track their working hours.

Copy all SQL statements and tables (screen shots) into a Word document. Include a title page with your name, course and assignment # and submit the document to the Assignments link

Assignment 2: Data Changes and SQL Statements Use the database and tables from last week’s assignment to write SQL statements and enter records into the Employee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.
•
Use the database and tables from last week’s assignment to write SQL queries using Between, Like and Union. Write a SQL query that does the following:

• Joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict the data.
• Joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict the data.
• Joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.
• Joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.
• Uses the UNION of the two tables to produce a third table.

Copy each query and its results (screen shots) in a Word document and post it to the Assignments link.

Use the updated database to write the following queries, using the SQL GROUP statement:

• Select employees’ last names and group them by EEO-1 Classification.
• Select employees’ last names and group them by salary.
• Select employees’ last names and group them by salary within their EEO-1 Classification.
• Select employees’ last names and group them by salary within job titles, grouped into exempt and non-exempt.
Copy the SQL statements and the results (screen shots) in a Word document and post it to the Assignments link.

Assignment 3: SQL Reports Use the database and tables from last week’s assignment to write queries using the SQL SELECT statement.

Note: Select all of the data from both of your tables before you perform the following.

• Increase all employees’ salaries with the selected EEO-1 classification by 10%.
• Increase all employees’ salaries by 5%.
• Choose an employee from the Employee table and delete that employee.
Copy the SQL statements and the results (screen shots) in a Word document and post it to the Assignments link.
Use the database and tables from last week’s assignment to write SQL statements that do the following:

• Calculate the average salary for all employees.
• Calculate the maximum salaries for exempt and non-exempt employees.
• Calculate the maximum salary for all employees.
• Calculate the minimum salaries for exempt and non-exempt employees.
• Calculate the minimum salary for all employees.
Copy the SQL statements and the results (screen shots) in a Word document and post it to the Assignments link.

I need a website that will allow:

1. Display books / documents in PDF format.
2. Allow signup of authors and readers.
3. Readers can search books by author, category, date, style, etc.
4. Allow upload of books / stories / poems in Word / Text / JPEG format AND AUTOMATICALLY CONVERT TO PDF format (for IP protection). Must automatically create
non- copy / paste / print PDF.
5. Author’s upload form includes author name. document title, category, date, etc.
and this information is used as search fields.
6. Will have admin moderated blog integrated to site
7. Each site registration, document upload and blog comment should have Facebook LIKE button enabled.
8. Slideshow on main page
9. Admin backend CMS.

We are looking to develop a site like YIPIT.COM

We would like a programmer that possesses good API integration skills as this project will have a lot to do with interaction with other sites feeds.

Please provide a portfolio of sites you have made that would indicate you are the right fit for this project.

PHP
MSQL

Thank you.

PLEASE ONLY BID IF YOU LIVE IN THE UNITED STATES!!! THIS IS A MUST SORRY!

I need a image upload form like: photoxe.com

I am trying to take it an put it into another site. So I need to strip out everything that isn’t needed. I want the image upload features but nothing else. I bought this site so I can provide all files.

I want it to upload the large images into a directory and keep all of the fancy javascript features. That’s it. Minimal HTML and no styling.

It should use simple php/mysql and javascript. The site currently uses a CGI uploader which I would like to avoid.

Hi,

We have a Flash app which is reading an XML from an admin panel, which is running a 30mins cron job (pulling search keywords from twitter and counting them), to output to the xml.

Admin panel -> dbase -> xml file <- front end flash file

Currently the cron job is running via admin panel which was supposed to be hosted in admin server.

Flash app is on a different front end public server.

However, we need the cron job to be running on the front end side and generate the xml on front end public server because we have no access to the admin server.

The only node of communication is via the dbase which both sides can read from.

The cron cannot be a windows scheduled task and has to be some asp.net daemon script which will fire every 30mins and store data to the dbase.

Pls PM me I will send you all files to have a look.

Urgent, only bid if you can work over next few hours to finish this.

Will need you to standby also as we will send everything to client server for UAT.

Thanks