Category: MYSQL Projects

MYSQL Projects

Flex Store Clone And Custom

Flex Store Clone And Custom
I am interested to clone or install flex store with data base and easy admin access to add/edit/remove items for sell.
Cart has to collect all and guide total to paypal and possibly to other payment methods, and while submitted by the customer I want to get an e-mail with list of all ordered items.
see flex store site to clone: http://philflash.inway.fr/flex/oldflexstore/flexstore.html

I want it here: www.nisgav.com/cart/flexstore.html

I need to be able through admin to create multiple pages for different kind of groups and items.

Create Site To Survey Visitors

Create Site To Survey Visitors
I would like to create a site to survey site visitors. From an admin control panel, I want to be able to select certain survey results according to specific criteria, then calculate some simple statistics on these results (mean, median, mode). The site will also need to have some sort of ad-serving ability – preferably with the ability to geo-target ads. I also need to measure the number of impressions for each ad (and set limits, frequency etc). Although I have some HTML experience, this project will need some easy way for me to add content and new pages. If a CMS is used, it should be some thing relatively simple, popular and widely used (such as WordPress or Joomla etc).

All pages need to have Google Analytics tracking code. I will provide this code.

The survey is to ask visitors to the site where they think a certain financial market will be trading at various dates in the future. The main forecast relates to the period ending at 5:00pm in New York on the Friday of ‘next week’. For example, a person submitting a survey response on Thu 4th Feb would be giving their forecast for Fri 12th Feb (New York time). Each week on at 5:00pm on Friday (New York time), a ‘new’ survey commences. Although this feeds into the same database, each survey period will be identified by a code based on the date of the ‘weekly’ forecast. For example, if the survey is asking for forecasts for 5:00pm (New York time) on Friday 12th Feb, the code for that survey period would be 20100212 (which is YYYYMMDD), the following survey will be named 20100219.

Each week at 5:00pm New York time, the survey page should automatically update to ask people for their forecast for the relevant date – coinciding with the new survey name.

In addition to the weekly forecast, people will be asked for their forecasts for this market for the end of each of the next four quarters – e.g. 31st March, 30th June, 30th September and 31st December. There needs to be an override function to allow these dates to be changed to ensure that the date shown is not a Saturday or Sunday. If the end of a quarter is a Saturday or Sunday, the date shown should be the Friday immediately prior to the end of the quarter.

Q1 is simply the end of the ‘next’ quarter (the one nearest to the current date). The month of the Weekly forecast and Q1 forecast should never be the same. For example, survey 20100226 will become ‘live’ at 5:00:01pm New York time on Friday 19th February 2010. The date for the Q1 forecast will be 31st March 2010. The following week, when survey 20100305 becomes active, the date for Q1 will ‘roll’ to 30th June 2010. As a consequence, the date for the Q2 forecast will roll from 30th June 2010 to 30th September 2010, the date for the Q3 forecast will roll from 30th September 2010 to 31st December 2010 and the date for the Q4 forecast will roll from 31st December 2010 to 31st March 2011.

The survey will (initially) ask just 11 questions – all of them are optional.
1. Email Address
2. Name
3. Company
4. URL
5. Location
6. Category
7. Weekly forecast
8. Q1 forecast
9. Q2 forecast
10. Q3 forecast
11. Q4 forecast

In addition, each response needs to be tagged with the relevant survey number (such as 20100212) and a timestamp (YYY:MM:DD / HH:MM:SS). The server is unlikely to be in the USA, so the time stamp function and automatic roll over of the survey periods might not be accurate if they are based on survey time. It might be better to base them on a tool such as Qlock.com or similar. It might be necessary to provide a manual override or manual adjustment to account for changes in daylight saving etc.

I would like to make sure that anybody visiting the site can only provide one response per survey (eg 20100212) for Weekly, Q1, Q2, Q3 and Q4 forecasts. It would be good though if a user had the opportunity to amend a response already submitted in the current survey. Using an IP address to do this might work, so long as it did not mean that it would prevent numerous people from the same company submitting responses. I do want numerous people from the same business (bank, trading room etc) to be able to submit their responses even if they share an IP address.

It would be good if the site could remember an individuals responses to the first 6 questions – so that people do not have to re-enter these details each week. They do need to have the ability to edit them if they wish.

There should be a tool for calculating statistics based on the survey responses. This stats/admin page must hidden and only accessible with a username and password. There should be an option to download survey responses (all and filtered) as a CSV and/or a TXT file. There should also be an option to view all responses direct from the database.

Before performing analysis on the survey responses, the admin panel should provide the ability to filter the survey responses in the database. These filters should be as follows….

– There should be an option to analyse all survey responses, or to limit the analysis to a particular survey as identified by the survey name (such as 20100212).

– There should be an option to select lower and/or upper limits to the levels (the actual forecast number) of responses to the Weekly forecast, Q1 forecast, Q2 forecast, Q3 forecast and Q4 forecast. Only numbers that fall within these limits will be included in the survey analysis.

– There should be an option to select the Location of survey respondents to be included in the analysis. The default setting is ‘all’. This is probably best achieved by having a drop-down list of locations with a check-box next to each one. There should also be buttons to “Select All” or “Clear All”.

– There should be options to limit the analysis to only the responses that have included
– a valid email address
– a real name
– a company name
– a valid URL
– The default setting would be to select all responses. It might be best to use check-boxes next to each of these terms so that survey results can be filtered by any combination of these details

– There should be an option to filter survey responses by by “Category’. Default setting would be to include all Categories. There are currently about 5 Categories and one for “Other”. This will be explained in more detail.

– Once all selections are made, the admin panel should show the total number of responses that meet the selection criteria.

For the survey responses that are selected (after being filtered through the above choices), the admin panel then needs to calculate the following data for each of the forecast dates in the survey. This means, individual calculations are needed for Weekly, Q1, Q2, Q3 and Q4 survey responses. The calculations required are as follows;
– Number of filtered responses for the relevant date
– Mean (average)
– Median (middle number when all filtered responses are listed in numerical order)
– Mode (the figure that is forecast by the greatest number of survey respondents
– Closest to the mean – Which respondent was closest to the Mean? If more than one, the response with the earliest time stamp is selected.

I have made a mock-up of one idea for the survey page. If chosen, I will show this to you but I am looking for a better, more professional looking site. Being a financial site, the look needs to be professional and conservative – yet modern.

I want the survey to appear on the Homepage of my site. On this site, I also want space for an advertising banner across the top and another one (skyscraper or box) down either the left or right side of the page. After survey results are submitted, users should be taken to a thank-you page. this will also include space for advertising. Ads are likely to be either GIF or SWF but it should be possible to post other formats.

Although there is a lot of detail in the above, I believe this should be a relatively simple job for a suitably qualified person.

I look forward to your response.

Thanks,
Alex.

Fix Our Existing Website

Fix Our Existing Website
WEBSITE CORRECTIONS and REDESIGN
We are looking for an experienced programmer to REDESIGN And Fix OUR existing WEBSITE ,
i will like to know first if you can give me a sample test , to see your work , because i have bad experiences in the past , so i will like to see a example or sample test on my project before we proceed …MOST OF OUR WEBSITE IS DONE , WE JUST NEED TO FIX SOME FEATURES ,THAT THERE IS NOT FUNCTION PROPERLY , AND MAKE IT FUNCTION CORRECTLY ,BELLOW IS JUST AN EXAMPLE OF WHAT OUR WEBSITE DESCRIPTION AND FUNCTIONS ETC … ASK FOR OUR LINK ? ….we need it to work in internet explorer as well ,now only works with Firefox
We are looking for an experienced programmer who uses the latest technology stays up to date AND has a functioning example of this type of program already. If you have not already completed a project we cannot consider your bid due to time constraints.

Requirements:
Features/Version
Full Source Code license for multiple sites and right to distribute

Enhanced user experience with ability to CUSTOM design multiple promotional products with text, color and images
Free support # of months
Production mockup
Product (s) selection
Product color selection
Multiple text objects
Text colors
True Type font style selection
Administrator restrict design area
Dynamic uploading of true type fonts
Text re size
Rotate and/or curve text
Graphics gallery
Graphics gallery search based on category and subcategory
Drag and Drop onto product
Drag and Drop off of product
Distressed effect
Drop shadow effect
Stroke effect
Select design product
Add additional product with same design
Save/Load/Share Design
Integration with website
Warranty
1 year maintenance
Training
Admin end allowing editing of properties such as products. colors, content and importing of new vector files
Upgrade potential
Support hours
Bug recovery and fix
Response time
Order storage in system for reordering
Each order is stored within system along with specification of design. Specification indicates what texts were entered and which font, color and effects are used. In addition, we can generate PDF or PNG file of the design, which is attached to the order and can be also sent as receipt to your Customer.
Order can be added shopping car
Order sent to production with specifications of product (s), text, font, font size font color, font effects, font placement, graphic, graphic color, uploaded image if any
Order sent to production also includes layout file
Uploaded Customer images stored in system

HOME PAGE
we need it to work in internet explorer as well ,now only works with Firefox
*

Change logo – the size of the “e” and the tape measure is not clear.
*

Add the “TM” at the end of the name

Add a tab for retailers
*

Words below the boxes- change to a nicer font or color or background and add the words missing form page
*

CUSTOMIZED JEANS TAB(ALLREADY EXIST)
FIX BELLOW
Customize Your Jeans Customized online store modules

– Customize Your Product
– Design Your Jeans section
– input fields for measurements, select material, cut, color, accessories, etc.
– custom quote based on option selected
– save design feature
– payment option (via PayPal or other means) including confirmation number
– design preview with edit option or direct to order

– Product Catalog section
– Products Online – inventory store
– display products for sale by product category, style, color, etc. or design their own jeans or copy jeans
– product will be displayed with images in thumbnail with large view option

– Product Customization
– feature to upload customized or standard image
– instant price modification based on selections
– add design notes (i.e. select embroidery, name on zipper/back pocket, etc) or enter general comments
– save design feature or order
– order option will include login to account or create an account
– design preview with edit option or direct to order

Design Your Jeans

The process involves developing an application to design jeans and integrating it in the website. Using this application customers can design jeans by adding images, text etc. Customers will get a custom quote based on the design and the quantity ordered. Customers can save the design and order by making payments through the payment gateway.

Product Catalogue

The product catalogue section will display the product according to manufactures, product category, style, color etc.

Categories

Through this section users can navigate through the products according to various product categories like women’s, mens, kids etc.

*

Styles

Users can select products according to boot cut, straight fit etc.

*

Product

The product display section will display products according to product model, size, fabric, description etc. The product will be displayed with images in thumbnail and large view option.

*

Color

From this section users have the option to select the color for the product according to the details uploaded by the admin.

Product Customization

In the product customization section users have the option to customize products. The product customization includes the following

*

Add Image

In this section users can add images in two ways either from the clip art library provided within the website or users can upload images from his hard drive. The clip art library includes different categories of images and user can select image and upload it to the selected product.

Each image in the clip art library is set with a price so that user can view the price of the product at the time of customization.

If user is uploading products from his hard drive then the pricing is calculated according to the color in the uploaded image. So for selecting the color there is a color section in the customization part where users can select color for the uploaded image

After selecting the image users have the option to edit the images uploaded. User can choose the color, resize image, position image etc.

*

Add Text

In this section users have the option to add text to the selected product. Users have the option to select the font for the text and users can make edits like size, shape, spacing, order etc.

*

Add Design Notes

Users can enter comments from this section.

*

Save Design

After customization user ca save the design or order the design. For to save or order the design created user needs to login to the account. If the user doesn’t have an account then user needs to create a new account from there and user will get the details of the customization after login.

At the user login has the options like password retrieval, order history, view designs etc.

Design Preview

The preview of the design will be displayed in this section based on the customization done by the user. The user can make edits form this section also. At this area user can flip or rotate the design, zoom the product etc.

From this section user can finish the product and have the option to send order request.

Shopping Cart

*

Option To Add Products To Shopping Cart
*

Enter Shipping Details
*

Payment Options

This section contains the display of products in categories and subcategories. Each product listing contains its details. Registered user can select products needed and can add the products to shopping cart. Then the user can order the products by entering the shipping and payment details.

Stores

In this section user is given a map and from the map user can select the stores located at different states. Then user can click on the stores and can view the address details of the stores.

User Home

User can login to the website and can manage his account. User has the option to manage his/her profile, view the details of purchased products, option to know the status of the purchased product etc.

Order Status/History

In this section users have the option to view the order status and history of the products purchased by the user. Users can check the order status by entering the order id in the specific field.
Products Online

*

In Products online, user can view the products are displayed by category and sub category.
*

For each product user can view image, product name and price is displayed.
*

User can view list of products are displayed in a page.
*

If user clicks on the products a detailed specification of each product with image and other details.
*

For each product user will have a link to shopping cart.
*

User can add products to wish list and continue for shopping.

Customizing the Product

*

In customizing the product, user can select a product and can design.
*

In this section, users will be instructed on how to take their measurements and follow specific steps to select material, cut, color, accessories, etc.
*

Based on the designed work user will receive a custom quote.
*

User can save their designs and make payment and then receive a confirmation number.
*

For customizing user has to follow the steps as
#

In Adding image, user can add any image in the jean that the user is selected either of the users own design or select from the list.
*

In Adding Design, user can view two sections as
*

Design Notes
*

Save Design
o

In Design Notes, user can select embroidery, their name on the inside of the zipper on a back pocket, etc or shopper can enter general comments
o

In Save design, user can save or order the design. If user choose to order they required to log into their account or create an account if they do not already have an account
#

In Design preview, based on all the selections, the user can view the final design.
*

In this section user can edit and reset the design and then order the product.

Shopping Cart

*

In shopping cart, the products added in the cart are displayed in this section.
*

In this page, user can view image of selected product, the name of the product, price, quantity, total price of a product.
*

User can view “Delete” link were the user can click on it to delete the product from cart.
*

User can view order sub total is displayed at the bottom of the page.
*

Three buttons are displayed at the top of the page such as empty cart, continue shopping and check out.
*

If user clicks “Empty cart”, the products are displayed in cart are cleared from this list and if user clicks on “Continue Shopping”, user can purchase more products were shop categories page is displayed.
*

If “Check out’ button is clicked, the page is redirected to checkout page.

Checkout/ Payment

*

Once the products are conformed, user has to enter the payment details.
*

User can pay the amount through credit card and pay pal.
*

If user clicks credit card, user has to enter payment details such as

+

Credit card number
+

Credit card type
+

Credit card validity date
+

Security Code

*

The types of credit cards are master card, visa and may be Amex.

Or,

*

If user clicks Pay pal, user has to enter user name and password if it created already or if the user do not have account, user has to register in the following URL www.paypal.com
*

Once the details are entered, user checks for verification process and if the details are valid then user has to enter the shipping details.
*

All the payments are tracked.

Shipping Info

*

Shipping details has to be entered by the user after the payment verification completed.
*

User has to enter details for the following fields such as,

+

Contact Information for order
#

First name
#

Last Name
#

Telephone
#

Email
#

Re-enter Email address
+

Shipping Address for this Order
#

Address 1
#

Address 2
#

City
#

State
#

ZIP Code
#

Country

Search

*

User can view search functionality in all the pages.
*

User has to enter keyword and select category from the list.
*

Based on the entered text and selected category, user can view the results are displayed in result page.

Static pages

*

User can view the following are the static page links are displayed in all the pages.
*

The following are the footer links as

o

FAQ
o

Privacy policy
o

Terms of Services
o

Contact Us & Enquiry form
o

About us
o

Feedback form

6.
ADMIN FUNCTIONALITIES

This admin panel is categorized in to following things,

*

User Management
*

Content Management
*

Category Management
*

Products Management
*

Invoice Management
*

Newsletter Management
*

Reviews and Rating Management

USER MANAGEMENT

*

Admin can Approve or Reject the Registration of Users.
*

Admin can manage the list of Users in the Site.
*

Admin can View the list of all Users in the Site.
*

Admin can search the list of all Users in the Site.
*

Admin can Activate / Deactivate any Users in the Site.

CONTENT MANAGEMENT

*

Admin can manage the content.
*

Admin can add / delete / edit the content.
*

Admin can search for the content.
*

Admin activate / deactivate the content.
*

Admin can update dynamic pages.

CATEGORY MANAGEMENT

*

Admin can view the categories/ sub categories are displayed in this site
*

Admin can edit and update the categories / sub categories
*

Admin can delete the categories / sub categories
*

Admin can activate/ deactivate the categories / sub categories list
*

Admin can view the search result once the categories / sub categories is selected

PRODUCT MANAGEMENT

*

Admin can view the products are listed.
*

Admin can activate/ deactivate the product section
*

Admin can view the list products.
*

Admin can add/ delete the product
*

Admin can edit / update the products
*

Admin can manage all the shipping information details.

INVOICE MANAGEMENT

*

Admin can generate invoice for each product.
*

Admin can view and manage the invoices.
*

Admin can activate/ deactivate the invoices.

NEWSLETTER MANAGEMENT

*

Admin can send newsletter to the sales person
*

Admin can view the newsletters
*

Admin can manage the newsletter
*

Admin can activate/ deactivate the newsletter

REVIEWS AND RATING MANAGEMENT

*

Admin can view reviews and ratings
*

Admin can view highest rating product
*

Admin can list the number of ratings and reviews
*

Admin can activate/ deactivate reviews and ratings.

7.
TESTING

This module will involve following features.

*

Integration testing
1.

QA Release
2.

QA Testing and feedback
3.

Int Testing Bug fixes and delivery

*

User Acceptance testing
1.

Release to staging server
2.

Staging Testing and feedback
3.

User Acceptance Testing
4.

Bug fixes and Delivery

*

Security Testing

The user is provided with the following functionalities:

Home Page

*

Welcome Note
*

Register/ Login
o

Registration
o

Sign In

Users Home Page

*

My account
*

Products Online
*

Product Catalogue
*

Customizing the Products
*

Offers
*

Product Reviews and Ratings
*

Shopping cart
*

Payment
*

Shipping
*

Best Sellers/ Featured Sellers
*

News letter
*

Press Release
*

Search
*

Static Pages
o

FAQ
o

Privacy policy
o

Terms of Services
o

Contact Us & Enquiry form
o

About us
o

Feedback form
ALL THE WEBSITE IS MADE IN JOOMLA
WE NEED AN APPLICATION TO TRANSLATE OUR WEBSITE TO OTHER LANGUAGES …

i will like to know first if you can give me a sample test , to see your work , because i have bad experiences in the past , so i will like to see a example or sample test on my project before we proceed …MOST OF THE WEBSITE IS DONE , WE JUST NEED TO FIX SOME FEATURES , AND MAKE IT FUNCTION CORRECTLY ,BELLOW IS JUST AN EXAMPLE OF WHAT OUR WEBSITE DESCRIPTION AND FUNCTIONS ETC …

Let me know if you have any other question …
Thanks

Whois Server Script

Whois Server Script
I want to set up a whois server but I was told I need a whois script developed. Basically what i want the whois script to do is when someone check ANY SUBDOMAIN, it will check if the SUBDOMAIN is pinging. If it’s not pinging then it will return that subdomain is available for registration. If the subdomain is pinging then it will return that subdomain is not available for registration. I was told that this is VERY easy as whois scripts is just following the standard protocol to dispatch results. The server where I will put this will listen to port 43 for any query.

The script must be written in PHP and secure. So that means i need some sort of logging system (probably in mysql) that will log all queries made, the originating IP, url, headers, etc. This must work with any LAMP server running in suexec, suhosin, suphp and optimized to use lesser memory and cpu as much as possible

The reason i need this custom because there is no WHOIS script that works on subdomain basis. I want this script to be able to check any subdomain that it will pass to that script for checking by pinging the subdomain.

I need to input the whois url to AWBS or Ihost or AccountLab Plus or WHMCS or Blesta so I can offer subdomain registration via these billing software by having a whois server myself.

I need this ASAP within 2-3 days

Data Matching Appending Merge

Data Matching Appending Merge
I have twelve separate database marketing files. These do not all have the same fields but do have some fields in common. My goal is to compile one master database using as much of the data as possible. Accuracy is of greatest importance and I fully expect this to be a complex job. This job will not be a simple name match. It will require careful planning. On some matches it may require comparing the first few numbers of addresses and month and year of birth to another file that has the full date of birth. At time a month and year of birth and last name will be matched to another file that has last name and complete date of birth but you will also need to compare the city or zip code. As I said it is not a simple matching process. I have attached a file you can review that shows the samples of the data. Some of these are very large database as indicated in the approximate number counts.

I have a strong server you will be able to utilize to make this happen unless you prefer to use your own or own software. I can connect the data to an external drive on the server and you would need to move it as needed but because of file size it will require extensive use of the backup drive as well as the main drives.

You must have extensive experience in Data matching, appending, cleansing, deduplication, validation, and merging of data across multiple tables or data structures. The attached document shows 11 of the current databases and a 12th will be added but it is only about another million records.

To sum this up all 12 files will become one master file that includes as many data elements as possible. Some states will have data that others will not. For example there are two database, one for Oregon and one for Washington that contain data elements no other state has. Another example is there are data elements for 2/3 of the states that 1/3 do not have.

Planning is going to be a big part of this project. Please have experience in data compiling if bidding.

Thank you for your consideration.

Looking For Simple Content Sys

Looking For Simple Content Sys
i need this project to be written in Php & Mysql.
i’m looking for someone to build me a system based on the following Requirements:
-user signup/login/Password recovery
-users can change their details
-Blocked content for guests
-An option for sending Email to members

Contnet Requirements:
– add & show articles by categories and sub categories
– upload pic/rar files
– Registered users can post comments
– Add articles by adding a title, abstract, full story, Upload Image And added file.
– Easy to edit and delete.

-*-*-*-*-*-*-
Very important!!
——–
– The system must be easy to design and editing and
Easy integration in HTML pages.

– Please specify if you builld the system yourself or complete system
———

Unfortunately I can not afford a higher price than what I have now.

Thank you and good day.

A Banner Exchange Matrix

A Banner Exchange Matrix
hey,

I’ve got an idea for a very good banner exchange program which I’m thinking of producing and selling.

What it basically is, is different banner layouts, each consists of 5 banners from the other websites in the matrix displayed. Now if they place this on their site, for every 1 impression of the 5 ad banner, they will receive 2 impression of their banner on 2 other sites.

I need a script made that basically links all of these and makes it so when they copy the easy code to their site their site is away and all banner impression stats are counted.

I’ll be selling spaces on the banners and also advertising my own sites at the same time.

thanks