Category: MYSQL Projects

Php Web Programmer Required
Skills required:
1. Forms validation
2. PHP API experience
3. Parsing/crawling
4. MYSQL

We would rather deal with a company than an individual. Also, we will need to keep up with progress daily and be allowed FTP access to your work. We will escrow money before project begins.

PLEASE READ THE SPECS BELOW AND BE SURE YOU UNDERSTAND THE REQUIREMENTS. ONCE THIS FIRST SECTION IS COMPLETE WE WILL REQUIRE EXTRA MODULES.

Section requirements for writers.

1. A signup form which would include name, email, PayPal email, telephone number, (drop down country), website description e.g. categories, Drop down age of (blog, website) <1yr, 1yr, 2yr etc, type drop down custom website, blogger, wordpress, Joomla etc etc, drop down (own domain, sub domain, third party domain and text box to enter domain/sub domain . All submissions to go to mysql database and also aweber. All forms must use form verification and protect against sql injection.
2. A spider/crawler/parser to check the writer’s sites to find keywords.
3. A way for the writers to be able to see relevant/matched projects and a way to select which ones they want to do. The chosen project will then be changed to pending and the writer will have 4 hours to complete this project, if the project is not completed after 4 hours the status of the project will be changed to open once more.
4. A form for writers to submit their articles this form will be integrated with Copyscape’s API to ensure all writers submitted articles are unique, there will need to be a stop so if the article doesn’t make a score of x (determined by the copyscape API) then the submit will not work and an ajax message will tell them the article is not unique enough. This form will also have a textbox where the writer can submit the url where the article resides. The date of submission should also be recorded
5. A spider to check once a month to see if the articles are being left up, if article is not left up a section in admin should show this.
6. A way to pay the writers, pay monthly once they have X amount in the kitty, this will be set up using PayPal bulk pay api so this part can be done solely from the website with no manual logging into paypal required.
7. A FAQ page where we can add faq’s by writers

Section requirements for link buyers.

1. A signup form which would include name, email, PayPal email, telephone number, country, website url description e.g. categories, age, type. All submissions to go to mysql database and also aweber.
2. A section where the link buyer would buy credits to use to pay the writers, this would use PayPal.
3. A form where the link buyer could add kw’s/keyphrases to be used in the anchor text
4. A form where the link buyer could add some information about what the article would be about.
5. An email goes to writers to tell them another project has been posted.
6. A section where the link buyer could see all the past, transactions.
7. A section where the link buyer could see all the past/pending projects by date submitted by writers.
8. A ticket system that the link buyers can use to submit any complaints?

Section requirements for admins.

1. A report to see how many writers and link buyers there are.
2. A reports system that will allow admin’s to see all transactions and trouble tickets.
3. A reports system to check on open/pending/closed articles, with option to check on newest oldest etc
4. A system using PayPal’s bulk pay for admin to pay writers that have earned over X amount at the end of every month, this also deducts the paid amount from the system and show it’s been paid so we can check on a report.

Horse Racing Component Joomla
Looking for a component developed for Joomla to allow manual data entry that our horse racing handicapper can input the same variable categories daily in the administrator for each horse race of each track for users to download per day the .PDF tip sheets.
The basic Joomla instalation and template has been set up at
www.racingwinbet.com.

I am looking for further development and integration of a custom component, member account authentication capability, and secure payment integration with merchant account and other listed functionality described below:

Projects Details and Website Description

Functionaly Needed

Provide a daily tip sheet (Home Work) to the Horse Racing industry. Daily tip sheet will be distributed online at website address: www.racingwinbet.com. The website will inform visitors of the handicapping service offered, as well allow a customer to sign up and purchase daily or monthly access. After payment received from a credit card purchase using a secure transaction portal, a download of the daily tip sheets will be available on a secured webpage.

The target clientele will be horse racing enthusiasts that place bets on horse races. The daily tip sheet will provide hours of handicapping insight for a small fee for the time savings.

Content Management System to be integrated with: Joomla 1.5

Project Specifications Overview:

A component developed for the joomla cms that is based on a form with multiple custom named inputs of data. Multiple data variables will be collected on this form. Each variable will be manually input using the joomla administrator. The form will then publish displaying the data in a chart with a row for descriptions of variables followed by a row for each horse listed. A column will display the variable data of each item collected on the form in the order collected from left to right.

There will be 3 different charts per race that will be comprised of the following categories:

– Betting Line
– Pace Line
– Input Data

This form will be used for the data entry of each race, and for each track in the U.S. of the following day’s races. The three sections will be displayed for each race of each track daily. The daily tip sheet will be available to download in a one page adobe .PDF (print ready) document for each individual race or compiled with all tip sheets for each race of a particular track. The .PDF document will also display in a pop up window for immediate viewing.

The organization should be automatic based on a selection during the race manual input. A track name will be available for all tracks in the U.S. to associate the race with the appropriate track in a drop down box. A second drop down will be available to select the race number of that race as associated for each particular track.

New Membership sign up page
Form to gather account details and a link to the credit card transaction gateway for payment processing and deposit in to bank account. After payment is received account login is automatically emailed to users email provided during signup and downloads will be available once logged in.

Membership Authentication and Login

Basic Form: username and password
Link: new accounts
Link: forgot login

User Secured login page will provide a List of tracks names that each link to a separate page to display the download links for the selected track, also for each individual race.

Download access will be based on purchase selection of daily access or monthly access.
If a monthly access is selected user will have unlimited access for the month starting from the day the monthly payment is received. If the daily selection is made user will have access for 24 hours and will only allow that days tips sheets for download. At the end of the billing month or the 24 hrs after the account user is activated the account will be redirected to a new window when additional attempt to login is made. At this window the user will need to make additional payment for continued access.

Clone Gamersaloon
i got the website design already!!!!!

I would like a cl-one of www.gamersaloon.com . I want users to have their own profiles which can be modified to their likening. I want users to be able to deposit and withdraw money easily using paypal. Users should be able to rate each others after there matches and their results should be available on their profile. Money should automatically be paid to the winner when the result is recorded. Ideally I would like this site make using a content management system like drupal or joomla.

I GOT JOOMLA ALREADY INSTALL

Key features:
Money/Credit System
Admin area
User Profiles
professional look
easy to update

Vb Software + Admin Area
Hello.

I need you to make me a software in VB. The software formulas are extremely simple (easy calculations) and it would need to have a drop down menu included.
One detail that’s very important is that people can install and use the software in any computer (pc or mac), no matter what operating system they’re using. I honestly don’t know if VB is the best solution but I’ve used this kind of software before and it used to work well…

The software should have an installation wizard and before it creates a desktop icon, it should ask for a username and password. When someone buys it from me, he gets an email with his info as well as I get this info directly in my admin area. In this admin area, I should be able to manually add, delete or change any details about my members.

The software would need to have some “design” matching the website.

In sum, you have to:
– create a VB software (with easy calculations and a drop down menu), with an installation wizard and password protected;
– create my admin area (where I can add, delete or change every user info).

Please only bid if you can do the entire project. Please show me samples of similar projects you did on the past.

Thank you.

Travian Online Status Script
I am interested in a script simillar or identical to these two:
http://www.scriptlance.com/projects/1189027104.shtml
http://www.scriptlance.com/projects/1191339052.shtml

I repost their description.

Me and my “clan” plays a free online game, travian.com (Travian).

I want a script that will view the “activity” status (which is given by the game/Travian) of those within my “clan”/”alliance” and create reports based on their status, which I wish the script to check every 10 minutes. However, to “see” or access this status listing (which is a constant URL by the way) I need to be logged in. So, naturally, I assume this script would have to “log in” to the website/game using my login information. This scares me a little, as I believe then this login information would have to be stored on my webspace, so I would appreciate if this could be made secure so that not anyone can “phish” this information from my webspace.

The file I have attached is a print screen of the online status I can see in the clan. Take note of the dot images beside everyones name.
blue = online
green = was online in the past 24h
yellow = was online in the past 3 days
red = was online in the past 7 days
grey = wasn’t online in the past 7 days

My main concern is only whether it’s a blue or green dot anyway, so I suppose any other image file name is irrelevent.

What I want your script to do is login under my username and password every 10 minutes and “record” in a small MySQL database what their percentage activity is in a 24 hour period. Since the script should be checking every 10 minutes, it will check the players status 144 times in a 24 hour period (there are 1440 minutes in 24 hours, but it is checking only every 10 minutes, so 1440 / 10 is 144).

Lets assume the player is active (ie. b1.gif) 30 times out of the 144 times your script checks the online status of the players. The HTML output of your script would display that player as having an activity of 20%, because that player was active 30 times out of the 144 times their status was “checked”, which would be they were “active” 20% of the times. So your script should record in the MySQL database how many TOTAL times the player was checked to get an OVERALL activity percentage -and- should record how many times they have been checked for the “new day”. User my webservers clock to determine when a “24 hour period” is done/over with.

Things I want to see in the statistics:
% online time every day, player/s and total clan
amount of players online at a time and list on who it was

The output of your script does not have to the pretty, however, it should be formatted so that it is readable/ledgible with ease (ie. it doesnt need fancy pictures or colors, just make it ledgible). The output should be alphabetized by the players name since the members in the clan can change, then it would be great if the script can read there names and record online stats to it.

Osc Flash Shirt Customizer F 2
I need the following changes made to my flash t-shirt customizer module. You should be proficient in flash, php, and oscommerce to do this.

Can be viewed here:
http://www.mysite.com/customize.php?products_id=93

And a standard product page can be viewed here:
http://www.mysite.com/product_info.php?cPath=23&products_id=93

1. When the users click on “View Image”, we open a new popup with a non-editable version of the same designer application, recreate the current design, zoom in till the maximum area and show them to client. We also update the shopping cart to have a hyperlink to the new “view image” change. Hyperlink will be when the customer clicks on the image of the t-shirt from the shopping cart.

2. I would like the shopping cart hyperlink for the product name (the text, not the image) to allow the customer to view the customizer again with all the designing options they made. This will allow them to go back and make necessary changes to the design. Now, I know that when they do that again and they buy that design it will then create another new product in the shopping cart. Maybe we can have a check to see if they want to edit the existing design or buy a new design from it.

3. Debug the Text Tool tab in the customizer. When the customer clicks, we see part of the ‘Remove Text’ button at the bottom is cut off.

4. Fix the Color Tool option on images. Currently it only works on text. Also I would like the ability of the customer to change the color on more than one area of the selected image. So, we have a single .png image with transparent background, a yellow sun, and a green tree. I would like the customer to be able to change the color of any of these using the color tool.

5. Would like an ‘Undo’ button, so the customer can revert back to the last setting change they made. And, a make a ‘Clear All Changes’ link or button, where we can revert back to the default design for that product.

6. We need to make the Add Image tab to display all of the images currently displayed on the shirt. If the customer uploads one or more images, then it will be shown here too.

7. We need to improve the scrolling function of all effected tabs. Currently the customer has to click and hold on the up or down arrow to slowly scroll. We need to add a scroll bar so that the customer can scroll up and down quicker.

8. Take the image design that is currently selected and have it be the image that is place on the shirt when the customer clicked ‘customize’ from product_info.php. For example we have this link: http://www.mysite.com/product_info.php?cPath=23&products_id=93 . We will make the ‘default design’ be the one assigned to the product already. You will see a field on the products table that says ‘default design’ where you can get this image location. Now, if the customer clicks any of the other design options after that and then clicks on customize then we will take that image as the default image on the shirt instead.

9. On the Choose item tab, after we choose a particular item we see some sizes available that are not correct. We need to get the info from the db so that the correct sizes will display that I have setup from admin.

10. We need to add-to the information that is currently showing in the shopping cart. We can add these, the size: size if any, color: color if any, text: example text if any, image: image name (w/hyperlink). Also we made the name be for example Descendents “Milo Goes To College” T-Shirt, but if we selected another product such as lady’s t-shirt, ringet t-shirt, cap, etc..then we want to change this title to reflect the correct product type name, instead of saying T-shirt.

11. Add new field to the products table called ‘customize_link’. We will make values be 0 or 1. If we use 1 as the value on the product, we will show the button located here: http://www.mysite.com/includes/languages/english/images/buttons/button_customize.gif whos hyperlink directs to customize.php for that product. It will be located directly below the image of the t-shirt switcher on product_info.php. If the value is 0, then we will not show the button or link to the customizer. We will then remove the link to the customizer on all products next to the Reviews button.

I will give you my site domain once you review my requirements and bid on my project accordingly.

Oscommerce Stock By Attribut 2
I have an oscommerce store and I need to add a feature in the admin section to track stock by attribute combinations. Here is the scenario. I print t-shirts and I do not stock actual pre-printed shirts but instead the blank shirts they are printed on. So, I will need to stock for instance size xlarge-white, large-white, small-white, small-red, etc etc. All individually. I have attributes in my shop for the size and the color seperately, which is the way I want to keep it. What I need the coder to do is make a way for me to add a certain stock amount for different attribute combinations in my shop and when it gets too low I will get the stock level email/alert.

ATTENTION: I do not need the osc mod QTPro. This module is for adding stock on a per product basis. I need to add stock to different attribute combinations that are global to the whole store, so that I won’t have to make stock on every product I make. I stock blank t-shirts and all of my products in my store will have pretty much the same attribute sets. Whenever a customer buys a specific product with the attributes combination (for example color:white / size:large) the stock will be deducted in the store for that particular combo (not for the product).

Fixing Errors
The job would be to fix the errors on my cre loaded 6.3 shop. you must know your way around the cre loaded shop. i have been let down by a programer who corrupted my site. he was supposed to seo my site but all he did was give the site errors. please dont bid if you can not fix the problem. The error message is this..

Fatal error: Corrupted encoded data detected in /homepages/38/d264884424/htdocs/sublimefurniture/includes/m1_common_functions.php on line 0

thanks
mark

Social Network Script
I NEED YOU TO COMPLETE THIS PROJECT WITHIN ONE WEEK. No exceptions

I need someone to create a social network script that organizes groups by U.S. city and state.

Your script will provide a hierarchy system so that each group has a leader that has admin control over its local members. The state leader will have admin control over the local leaders and all local members of that state. A nation leader (me) will be the ultimate admin and have admin control over every state leader, local leader, and every local member.

Local members can only socialize with other local members in their city. Local admin call only socialize down and up to the state leader. State leaders can socialize to all below them, and up to the Nation leader.

Members can search other local members by profile descriptions (education, career, industry, skills, hobby, name).
State can search anyone in their state. nation can search anyone.

You will arrange the member profiles per my request. It will be very similar to Facebook and LinkedIn. Be prepared to make add all of the profile features of Facebook and linkein, with same messaging, photos, personal info. No wall comments.
Each members friend list will be all of the friends in their local group. For local leader, it is all local members plus state leader. For State admin, it is all state members but Nation Admin. For Nation leader, it is everyone.

Leaders will be able to send out mass messages to everyone below them.

There will be a message board specific for each city and a message board for the nation.

There will be a place for State and Admin leaders to embed youtube videos and arrange by category.

Each local, state and nation admin will be able to rank each inferior member – Rank 1 – 10. To be explained later.

There will be a calendar that local, state, and nation admin can modify. Only local members will see local events. All state members can see state admin listed events. All members will see Nation admin added events. Click on date/event and you get more details.

You will create a video chat room where up-to 10 people can be on video chat, and everyone one else who joins >10 – 100000 people can view the chat and can text message the room.

There will be a local video chat room, state video chatroom, and nation video chatroom. The leader/admin of each will control the chatroom and can boot members, mute all members but himself, etc.

Prospective members should be able to go to homepage and see map of U.S. then click on State, then click on name of city and find local group, and join local group. You will add every city in the U.S.

When someone joins, the local admin will get a message stating that member joined. There should be auto email for all new members.
Log on, username, pass, forgot user, forgot pass should be part of this.

Same admin functions as most social network scripts for sale including phpfox.

Anything that you use must be legally usable for my website. You must have the rights to use them.

I NEED YOU TO COMPLETE YOUR PROJECT WITHIN ONE WEEK. No exceptions.

You will upload everything that is necessary to my server in order to make it work. You will show me your work on your server first.

I will pay by escrow after it is uploaded and all bugs are fixed.

You will need to customize the scripts according to my descriptions. I will give you more specific details before you start.

Appraisal Site Clone
Need a custom CMS system created that’s as mix of PHPFox and Central Desktop.

Site closest to in comparison: appraisalfirewall.com

Needs to have three sections, one for lender, one for appraiser, and admin backend. Needs to have the following:

LENDER SIDE:
Ability to invite appraiser to join site
Chart of appraisers and their turnaround times, activeness
Add/delete appraiser
Search for appraisers according to city, county, or radius
Add a job that needs appraising that will automatically go and search for appraisers within that area in chronological order.

APPRAISER:
Jobs will automatically go to appraiser in chronological order according to areas serviced.
Has 24 hours to accept appraisal before it moves to next appraiser on list.
Profile feature, edit info and add in license info, etc.
Invite lenders to join feature
Past appraisals/jobs are stored, categorized by active, completed, and pending – is searchable by location, address, etc.
Edit/set price for different forms/jobs
Add sub profiles for workers in company. Only main admin can accept/decline jobs. Sub profiles can only work on jobs and nothing else.

SITE FEATURES:
Rewards program to redeem points (points according to how many people accept invite to join)
Poll
Monthly invoicing and payment gateway
View past statements and payments
Donation page

ADMIN BACKEND (Much like PHPFox)
Add/delete users
Mass e-mails to members
View current activities, messaging
Invite to join

Please give estimates.

Membership Website
I require a small 4 or 5 paage website with CMS for an online UK horse Racing tipster site.
members would register and receive three tips per day by email through a bulk email system. members pay £22.00 per month or £120 per 6 month or £240 per year through paypal account system. reminders sent to members when fees due again
Members register online with members only page which also has the daily tips.
7 day free trial.
Good royalty free horse racing images and copyright free text.
Table of results page for the daily horses

Website Structure Assistance
I need help with my current website setup.

Right now I have one client company I am working with on this site with just one of their sales teams. I produce one web page for them a week. It contains one critique video. It also has a link to a download of my comments from the video and a link to a training page. My training page lessons have 4 videos and downloads and a quiz.

With this product I would produce around 50 pages with videos per year. That would be for just one team at just one company. Some companies may have 4 or more teams. That comes to 200 pages a year for one company. If this works I could have over 50 companies. That could be 10,000 pages per year. I need a website structure that can scale out to that size and yet be small in the very beginning. Right now I have a wordpress site hosted by bluehost.com.

The way I see it I have 3 options (But I am not a IT person there may be a 4th or 5th option)

1) I thought of having sub domains for each company so it would be easy to keep all their growing pages separate. Someone told me I could install a separate wordpress program and point it to the sub domain with my hosting company.
2) I could just make a separate website for each company critique pages and link the sites to a hub site that would contain my training lessons. I’ll eventually have well over 100 training pages.
3) I could have just one big site. They say there are ways of organizing it so it will work.
My concern is I don’t want to have a website confusing mess on my hands especially in the beginning when I’m doing most everything myself (and not being a technical person). I need to organize it in a way that I can logically grow maybe in stages.

Can you tell me in general terms how you would suggest to do this and is this something you could set up for me?

Windows/php Applications
Dear programmers,

Good day to you all! I paid for a 17 years old programmer 8 years ago to write similar application but I lost the application after few months using it due to my PC went haywire. Hence I am now tend to pay for a programmer to write the same thing, or maybe an ENHANCED version.

Basically, this application is more or less works like a hitbot supported by unique proxy IP which allows me to send unlimited hits to certain links. Please find below are what I wanted:

1) Must be able to excute on Windows XP or Vista, and maybe Windows 7 as well.

2) In the settings panel, I am unable to enter the destination links (unlimited links), IE remain open’s time and interval time.

3) Once it is executed, it will automatically execute IE and running as per configured in (2).

Optionally, you may write similar server’s side script (prefer PHP) so that it can run on my UNIX server without opening my PC 24 hours to run the windows software. If you choose server side script, then the interval time function can be ignored, and substitute it with hour or maybe daily hits to be sent. I need it to be supported by MySQL as well if needed.

Remarks:
1) These are simply my ideas. You are a programmer and you are professional, so it could be a plus if you are able to suggest me much effective ways.

2) Please provide as much as valid proxy IP. If possible, please mention how may IP you can provide together with the application or script.

3) Delivery day: within 5 days

4) Payment term: 50% upon confirmation, 50% upon delivery. (after you have showing me the working version) OR negotiable.

5) Payment method: Paypal only

Thanks a lot……….

Seo & Blogger & Webmaster
First of all, no copy and paste bids and that means no copy and paste bids.

Budget we are setting is on 3 monthly basis to start with paid in portions every month

If you actually bothered to read the posting and job below you will insert word”ARCACIA” in your bid.
Should you fail to do so, you will be rejected without even reading your bids

To be considered, you would need to address the job appropriately in point form addressing all the aspects of the job stated below.

We are looking for an experienced SEO guru to take on the task of promoting the site.

You will have proven experience and skills to do the job yourself rather then using some software.

You will be required to provide weekly reports on positions for all Google sites.We do want site to be high ranked across all major search engines not only Google.

Current statistic, site is ranked 2 by Google and 3 keywords used are positioned at 6,8 and 9. We want to maintain the position and try to move up to top 5 search results

We also have our own blog, which you would need to update 2-3 times per week(nothing major, more for ranking purposes)

Your webmaster skills would be needed to the perform the following and also to make some minor changes which would include backing up the date, some other changes, the usual webmaster duties.

• Website have good meta tags but need to update with targeted keywords. Some pages don’t have meta tags

• Website don’t have much Back links so need to make good back links through Link Building, Directory Submission, Social Bookmaking, Article Marketing, Edu site blog commenting, Press Release etc.

• Need to create basic files for sitemap, urllist.txt, info.txt and robots.txt.

• Website already verified in Google Webmaster Tool.

• Website needs verification in Yahoo Search Explore.

• Website needs verification in MSN Webmaster tool.

• Need to make account on Twitter, Facebook a nd Myspace for social network marketing.

• Product list in Froogle.com through Google base. Through this way google will index our each products and through froogle we can increase the sale.
-There are 56 images in site and out of this 37 images are not having alt tags, so will need to alter that
-Upload file to make perm redirects.
-Analise and adjust all meta tags, site headings and anything else that needs adjusting

You will also be available on skype or msn for communication and once again no more time wasters
Individuals rather then company’s preferred.
PS. Very important. we have reached current ranking and positioning by doing approx 30-40 hours per month, so if you even considering to bid with 100+ hours, PLEASE do not waste our time

Website Hotel
Website for booking hotels best bet is to look at the attachments and see exactly what is required.