Blancer.com Tutorials and projects

Develop the SQL statements to insert records into the database. You should ensure that the data in the database is sufficient to allow for each of the reports requested by Ms Smith to be tested. You need to show a minimum of three insert queries for each database table that you have created. Some tables will obviously require more to ensure that all of the required data is in the database (i.e., the packages table, program table, etc). To submit this task, create a comment heading called INSERT STATEMENTS in an SQL document. Add your INSERT statements for each table after this heading. Keep in mind that you will need to insert data into the tables in the same order that the tables were created. This will minimize and integrity constraint errors you might encounter. Keep in mind also that any values being inserted into a field defined as a foreign key field must first exist in a previous tables primary key field.

just launched a online penny auction and in need to get traffic to site.also do a email blast campaign.open to any suggestions,etc.thxs

Hi,
I need developers who can do the clone for bestwebgallery.com

I also need additional functions below:

– member signin / signup
– member can save sites in their bookmark page
– mauli-language support: English / Japanese / Chinese Traditional / Chinese Simplified
– member page will allow member to input their bio information
– search function (search for designer by studio, category, design works, tags etc)
– discussion board

I will be providing the front end HTML + CSS + graphics etc.

developers must build the backend in such a way that is :
– easy for me to update/ edit contents
– easy to publish + add screen shots + thumbnails
– easy for me to manage the submissions + discussions + member etc

I’m open for any kind of CMS technology (wordpress, joomla etc), but please do make sure providing me reason for those technology you choose to develop.

bidder please do provide your past works which best represent your skill level.

I will be going to have a few other design/art related sites similar to this, and I’m looking for developers who can work together for long term.

* please note: must sign the nondisclosure document.

Best,
Albert

Basically, I need something to draw data from 2 different sources and join them to make a post in wordpress.

I will have a website for one city, and then I will give you a link like this.

http://www.hotelscombined.com/City/Gosford.htm

I need it then to go through each hotel, for example.

http://www.hotelscombined.com/Hotel/Quality_Inn_The_Willows_Gosford.htm

and take all the data.

Then look where it says ‘Guest Rating 4.5 Stars’ and view reviews from hotelclub.

Follow the link to here.

http://www.hotelclub.com/DirectHotel.asp?ncl=&id=7691&lc=EN

And click the Guest Reviews tab.

“You will find reviews like this.

The room was spacious but fittings were tired and worn from original quality. The light above the TV bench did not work and one bedside lamp was missing half the fitting which included the light. The location was easy to find and traffic noise was minimal. Reception staff were pleasant. I would probably consider this motel again if needing accommodation in the area.

Review by: Wendy Croker
Date stayed: 15-04-2010”

I then need the script to turn that into a wordpress comment, for the above hotel.

Let me know what you guys think. If you do a job, long term work is available. I run many websites, and my average weekly spend in outsourcing is well over $1,000.

Budget- $50-250 payment paypal

Twitter wait and reply application:

Account creator
– An account creator and email activator to validate the accounts. All I need is 1 email account for all my twitter accounts because say my email is money (a.t) g mail and I register an account with it. Next time I could register with money+1 (a.t) g mail If you need an idea on how to construct on here is an example tweetfollowing.com
( Also if its possible when accounts are created to have the application have the back round and logo that would be great)

Wait and reply module
– Will reply to users that tweet my target keyword or phrase. Make sure mutiple users are able to run at the same time.

– Must use the simple and advanced twitter search (optional to me)
http://search.twitter.com/advanced

– Multiple twitter accounts manager. (unlimited accounts allowed to be added)

– Proxy support for twitter accounts.

– Custom reply delay where I am allowed to control (wait between 0 and 2 minutes to reply).

– If the tweets buildup on search so that its 10 minutes behind make the script skip the old tweets and reply to the new ones. (let this feature be customizable with the ability to turn on/off and adjust time)

– If an account becomes suspended or over the status limit let the application logout of the account and log into the next available account not being used. If the account is suspended make sure the application removes it from the list of accounts.

– Please no bugs. I would like this to run smooth on auto pilot and does not take a lot of ram memory on my computer.

—-
My objective is to have 8-12 wait and reply’s running at the same time on autopilot. Desktop or web script is acceptable.

IF THE APPLICATION NEEDS TO BE UPDATED CAN I CONTACT YOU FOR UPDATES AND IF THERE IS A FEE WHAT CAN I EXPECT ?

I need the attached image recreated into vector format – prefer eps. Item was originally made with various clip art images in excel believe it or not, and I have original xls file, and color corrected 4-color bitmap. Font is “African”

Please show copies of your previous work.

I expect to close the bidding early.

On a site there is a list of 3286 SEO companies (in alle countries on that site) I want to send them all an email using there contact form. If the form does not exist give me the email and I will send the email myself.

Its the same email send with my contact details. The list is this one http://bit.ly/cArqsR but does not provide diret links. So copy company name in google add seo behind it and usually no 1 in the results.