Archive

Posts Tagged ‘columns’

Shopping Cart/inventory Script

February 3rd, 2012 Comments off

I am trying to create an online store. My distributor gives me access to their FTP server to download their inventory in an ASCII format (file attached). I need to have a script written that will:

1. Connect to their FTP server and download the inventory file 2. Convert ASCII inventory file to a .CSV file 3. Re-arrange the columns the vender has into a different order so it can be properly imported in the correct columns in my shopping cart. 4. Upload the converted file with the columns re-ar…

Create New Columns In A Php Table

January 25th, 2012 Comments off

I have an information table built in php/mysql. I need to have a link that will create a new column in the table so that the administrator can create a new column for the table to add new information.

I would need a bid and samples of your work.

Excel Data Sheet

November 13th, 2011 Comments off

I wish to create a simple excel sheet / form that will enable us to add a list of customers whether manually or in bulk.

When the customer name is inserted into the first cell of the row, the remainder of the row will become visible and have 7 input parameters on the subsequent columns. Two of the columns are simple radio / option buttons and the other 5 columns will be simple pull down lists.

They key is the conditional non visibility of the cells until the customer name has been input.

Add Sorting Options For Columns In WordPress Theme

October 16th, 2011 Comments off

I have a WordPress theme that displayed posts in a tabular column format. I need a sorting function added to the columns that display numbers from custom fields. I also need one additional custom field added for this purpose.

The theme will need to be modified slight to account for the new sorting buttons, and the new column that will be added with one additional custom field.

More details as needed privately.

Seperate Line Of Text Data Into 3 Columns In Excel File.

October 10th, 2011 Comments off

I have text documents I need converted into 3 column excel or csv files. I have attached 1 sample text file. I need you to write me a basic php script that would read these files and spit them out into excel or csv files looking like that attached one.

Categories: Conversion, Data, Excel, PHP Tags: , , , , , ,

Modify Some Tables 2

August 16th, 2011 Comments off

In the deals table we have five columns

name, description, private_note, coupon_conditions, coupon_highlights

and when you enter a deal from the admin panel, the above mentioned columns get filled, and they store information for english language. Now in the deals table we have five columns for the deal entered in the another language, which are:

name_por, description_por, private_note_por, coupon_conditions_por, coupon_highlights_por

now when you enter a deal in the other Language from the admin panel these columns remain empty. the only columns that get information from the admin panel are for english language.

that’s why when you enter a deal from the admin panel, you see everything when you are in english language but when you switch to Portuguese language you get empty result in these columns.

Modify Some Tables

August 13th, 2011 Comments off

In the deals table we have five columns

name, description, private_note, coupon_conditions, coupon_highlights

and when you enter a deal from the admin panel, the above mentioned columns get filled, and they store information for english language. Now in the deals table we have five columns for the deal entered in the another language, which are:

name_por, description_por, private_note_por, coupon_conditions_por, coupon_highlights_por

now when you enter a deal in the other Language from the admin panel these columns remain empty. the only columns that get information from the admin panel are for english language.

that’s why when you enter a deal from the admin panel, you see everything when you are in english language but when you switch to Portuguese language you get empty result in these columns.

Create Two Columns For Data In Php

July 6th, 2011 Comments off

This should be very easy, an hours work at the very most. Please make sure your bid reflects that.

All I want is for the data on these two pages to de diplayed in two columns rather than one. Also I want the text to appear under the boxes rather than to the side of them.

http://www.carsindoha.com/showrooms.php

http://www.carsindoha.com/car_rental.php

Php Script To Delete Columns From A Csv File

June 30th, 2011 Comments off

I have to edit the attached CSV file products.csv using a PHP script.

I will run as a cron.

You will write a script that will:

1) Delete columns 2, 3, 4, 5, 6, 10

2) This will keep columns 1, 7, 8, 9 (SKU, Price, Stock, and Active)

3) Save the file in UTF-8 format using the new name edit_products.csv

Domain Name Availability Checker Addons – For Alos

June 18th, 2011 Comments off

THIS PROJECT IS FOR PROGRAMMER ALOS ONLY – DON’T BID ON THIS IF YOU’RE NOT ALOS.

Here is exactly what I’d like to see added:

For the “Pending Delete” & “Pending Renewal” columns, I need the following information for each domain:

domainname.com (or whatever it’s extension is)
updated date
creation date
expiration date

Ideally, I’d like to see 4 separated columns within each of the pending delete & pending renewal columns, and the data would appear with a vertical scroll bar instead of a horizontal one.

So it would end up looking like this in both the Pending Delete & Pending Renewal columns (the vertical bar character wouldn’t be there, that is where the column separator would appear within the main column itself):

Domain | Updated Date | Creation Date | Expiration Date
Domain | Updated Date | Creation Date | Expiration Date
Domain | Updated Date | Creation Date | Expiration Date
etc, etc, etc.

You’ll probably need a horizontal scroll bar to fit the above columns into each of the pending delete & pending renewal columns, and that’s fine, but the data it is retrieving should appear vertically, stacked one on top of the other so as more data comes in, you’d need to scroll the vertical scroll bar further and further to see it. Right now, the data comes in horizontally.

They would be separated columns, so there would be no delimiter. However, when you go to save the results to a file using the save button next to either the “pending delete” or “pending renewal” columns, it should save the data in a comma delimited .txt file.

Lastly, if you could make a radio button that says “TLD Attached” so when I import a file using the “Upload” button, if the words already have .com, .net, .org etc, etc, attached to them, it won’t re-append another .com or .net, etc to the word/domain it is checking.

The way it works right now, I can only import words with no .com,.net, etc after them, and the program appends the TLD (top level domain) to the end of the word.

I’ve attached a .txt file with 37k lines, and it contains all 4 types of domains (available, unavailable, pending delete & pending renewal).

You don’t need to let the entire file run, but I’ve attached it so you can see what I mean by the data needing to appear vertically & not horizontally in the pending renewal & pending delete columns if you let it run for just a few minutes.

Add Columns And Insert Server Superglobal Variables

June 17th, 2011 Comments off

I need some of the superglobal server variables to insert in my db
when the script is loaded.

Small Website Changes Needed

April 22nd, 2011 Comments off

I have two newspaper style websites (one is 2 columns and one is 3 columns)

I simply need the columns pushed down.

Message me for more details.

Cheers

Optimize Html Code To Be Consistent Across Browsers

April 14th, 2011 Comments off

This is a very simple project. Single HTML page.
The issue is that IE 8 displays three columns layout instead of two (adding one blank column on the right) all other browsers display correctly two columns.
We need the current code rewritten to display two columns.
See attached description and screen shots.
Please only change HTML code and make no changes to CSS and images.
You may use a one simple table instead of many nested ones.
Clean and formated HTML code with a few comments is expected.
We expect you to complete this project within an hour or two.
If you are ready to do it now we are ready to accept it now.

Please specify when you will deliver in EST.

Thanks and good luck.

Spreadsheet Data Entry

April 10th, 2011 Comments off

I need a form that users can use to enter data into a Excel 2003 spreadsheet in a consistent way. Excel’s “Data Form” would work, but I need drop down menus.

My Excel spreadsheet data is organized in several columns. Each row represents a sales prospect. The ~20 columns include… product, part number, customer name, projected sale 2011, 2012, etc., price 2011, 2012, etc.

For ~7 of the columns, I need the form to force users to select entries from a drop down menu.. The rest of the columns just need to be restricted by type (e.g. text entry, currency entry, numeric entry).

Move Content In Website Html And Css

April 4th, 2011 Comments off

I need to finish up a new theme I’m making for my site. The theme has a white content box with a shadow on the right and bottom. Currently the content is displayed below the white box. I need to have the content of the pages go into the white box. You can see how it looks here: http://visionarysociety.net/index.php/temp/new. On that page, the words test are displaying correctly. It is no problem to add that manually. But I have not been able to get the content displayed below to go into the box correctly. The tricky thing is that the content has two columns. When I move the code there, one of the columns seems to stay below the box. Both columns should be within the box.

The CMS I am using is Expression Engine. To make the changes, you can go directly to the code, by signing into pinpartnership.org/pinsys with Username guest and Password Scriptlance. To find the templates you will need, go to Site, Visionary Society, Templates, and then select the template group temp. Most of your work will be in the template new, but also possibly site2 or site3.

Let me know if you have any questions.

Thanks,
Geoff

Categories: CMS, Content, CSS, HTML, PHP, Template Tags: , , , , , ,

Simple WordPress Template 2

March 21st, 2010 Comments off

Template must support two column or three column layout with user being able to switch layout in the admin are
If two columns, user can choose content to be on left or right
If three columns, user can choose content to be on left, middle, or right
User must be able to specify width of each column and content column, as well as the padding between columns
Content must be displayed before columns in resulting html using css and div layouts (i.e. use holy-grail style layout – see http://matthewjamestaylor.com/blog/ultimate-3-column-holy-grail-pixels.htm)
Site must use two css files, one called layout which contains only the layout and one called default which contains the font and color definitions

Simple WordPress Template

February 28th, 2010 Comments off

Template must support two column or three column layout with user being able to switch layout in the admin are
If two columns, user can choose content to be on left or right
If three columns, user can choose content to be on left, middle, or right
User must be able to specify width of each column and content column, as well as the padding between columns
Content must be displayed before columns in resulting html using css and div layouts (i.e. use holy-grail style layout – see http://matthewjamestaylor.com/blog/ultimate-3-column-holy-grail-pixels.htm)
Site must use two css files, one called layout which contains only the layout and one called default which contains the font and color definitions

Electronic Notepad

February 26th, 2010 Comments off

We require an electronic notepad where we can keep a note of oil trading activity. Before now, we have kept a manual note on paper but this is not a neat solution and information can be missed when times are busy.

It should be a web based type platform with check boxes, data entry columns, access for users outside my organisation to specific data sets, the ability to export data to Excel and the ability for me to add/modify headings in the 6 columns of data I require. It needs to be a simple solution with maximum use of hotkeys/shortcuts to avoid typing or using the mouse on a dropdown menu etc so that data can be entered quickly. I will record information under 6 columns. (buy/sell, volume of trade, Month, Commodity sold, Price, Broker). I want the page to be visible to me and 3 colleagues online whilst I wish to be able to let other users (such as brokers) log in and see only the transactions which they were part of. They will then click a checkbox to acknowledge that they have reviewed the information.

Electronic Notepad

February 24th, 2010 Comments off

We require an electronic notepad where we can keep a note of oil trading activity. Before now, we have kept a manual note on paper but this is not a neat solution and information can be missed when times are busy.

It should be a web based type platform with check boxes, data entry columns, access for users outside my organisation to specific data sets, the ability to export data to Excel and the ability for me to add/modify headings in the 6 columns of data I require. It needs to be a simple solution with maximum use of hotkeys/shortcuts to avoid typing or using the mouse on a dropdown menu etc so that data can be entered quickly. I will record information under 6 columns. (buy/sell, volume of trade, Month, Commodity sold, Price, Broker). I want the page to be visible to me and 3 colleagues online whilst I wish to be able to let other users (such as brokers) log in and see only the transactions which they were part of. They will then click a checkbox to acknowledge that they have reviewed the information.

Right Side Columns

February 19th, 2010 Comments off

I would like to create a page that features two right side columns that are only visible if your resolution is wide enough.

The main section of the page is to be 1024px wide and center justified at all times!!! No scrollbars at the bottom if the right hand columns don’t fit the screen.

The two right hand columns will fit the space between the right hand side of the main section and the right hand side of the screen. The first column is to be visible for a 1280px. resolution and the second if the resolution is 1600px

Hope this makes sense. I’ve attached a picture (not to scale!) of what I’m looking for.

PLEASE ASK ANY AND ALL QUESTION BEFORE! USERS WITH NO FEEDBACK WILL NOT BE SELECTED UNLESS A DEMO IS SHOWN FIRST!!

Gift Voucher Engine

February 11th, 2010 Comments off

IN A NUTSHELL:
Web-based PHP engine that manipulates a mysql table file via forms.

TABLE STRUCTURE:
NAME: Clients
COLUMNS: ID, companyName, firstName, lastName, username, password, bannerID, address, phoneNumber, contactEmail, availableCredit, usedCredit

NAME: Vouchers (see vouchers jpg attached for details)
COLUMNS: ID, clientID(associated with ID in clientTable), uniqueCode, dollarAmount, employeeID, status, creditLeft, sentYN

NAME: Employees
COLUMNS: ID, username, password(see employee jpg attached for all columns and formatting)

The following functionality must be provided:
1. Log into portal using client username and password. Display banner with listing of vouchers purchased.
2. Button and functionality to add sum to total credit (do not give ability to remove credit)
3. Button and functionality to add gift voucher. This should be done at the table view as in the voucher view screenshot. A few notes on this:
—- Button to re/generate random code for voucher
—- Choose whether the item has been shipped aka assign shipping status (select box)
—- Assign voucher to person from a predefined employee table in the database (select box)
- Provide way to view vouchers for particular client and sort according to all fields as seen in jpg
- Delete UN-SHIPPED AND UN-USED voucher
- Mimic design in screen-shots as much as possible

DELIVERABLE
- Include mysql script to create initial empty tables.
- All source code is to be submitted via zip file.
- Code functionality must be loosely documented.

Deadline is Monday February 15th, 900h CST. Payment will be made on Monday provided all requirements have been met.

Table Columns Show/hide Switch

February 4th, 2010 Comments off

I have a web page with a table generated from a database consisting of 6 columns, all holding values from a given recordset.

One of the columns should, however, be structured as a “multi-column”, being able to hold 9 different values, but only one of these should be visible at a time.(The values are different statistics applying to each recordset: today, yesterday, this week, last week, this month, last month, this year, last year, overall)

The content of this “multi-column” is controlled by the user, who will be able to toggle between these 9 sets of data from a dropdown (select) on top of the page. When selecting a new value in the dropdown, the content of the multi-column should change accordingly, with all other columns unchanged.

Please notice that the number of rows is unknown (varying from user to user) and that the script should be able to handle 200+ rows without making scripting too heavy.

We imagine that all multicolumn data is preloaded upon page load, and thus can be called immediately from the dropdown, which is preferred to ie. ajax calls to the database upon each change of the dropdown.

We imagine that the solution make use of javascript or jquery, and will be as lightweight in both scripting and html as possible, ie. that each cell is not supposed to be defined in the javascript and that the entire table is not loaded 9 times upon pageload.

Restaurant Website

December 23rd, 2009 Comments off

We need to build a dynamic web site for a restaurant. We need design and functionality for this project.
The main page will have the logo of the restaurant on the top left corner and a flash animation on top, the menu will be on the left side below the logo.
There will be a section for news, special events and special offers on the main page.
The menu items will be:
Home, Food Menu, Wines, Map and Directions, Contact Us
The Food Menu page will show all the menu options and will allow users to search food items based on the name, type of food, price, ingredients or wine.
Ability to create the menu on the fly as a pdf.
The Wines page will allow users to search wines by name, type, region, bodega, grape, distributor, points, retailprice and food.
The Map and Directions page will show a Google map.
We also need a version of the Wine page to do searches on a touch screen, this means that the buttons and drop down menus will be larger on this page.

We also need an admin section to perform the following functionalities:
- Login
- Food page: to enter and maintain the different food items for the menu.
Columns: FoodId, Category, subcategory, Name, description, type, ingredients, retail price, SmallPicture, LargePicture
- Wines page: to enter and maintain the different types of wines.
Columns: WineID, Name, description, Type, Region, Bodega, Distributor, Country, Points, Location, Grape, cost, retailPrice, SmallPicture, LargePicture
- Pair page, this page is to pair food with wines.
Columns: PairID, FoodID, WineID
- Bodegas page, to enter information about the bodegas.
Columns: BodegaID, name, description, country, mainurl, videourl
- Regions: to enter information about the Regions.
Columns: RegionID, Name, Description
- Distributors page:
Columns: DistID, Name, Description, address, contact1, contact2, contact3, tel1, tel2, tel3, fax1, fax2
- Types page, to enter the different wine types.
Columns: TypeID, Name, Description
- Products page, to enter other products like canned products, delicatessens, gift baskets, deli products etc.
Columns: Product ID, category, subcategory, name, description, price, etc
- Users page, to create and assign user privileges

The admin section will have two types of users:
Super Admin: will have access to all screens with read, update and insert privileges.
Admin, will have access to all screens with read and update privileges only.

The look and feel of the Wine search will be like Amazon, it will have a list of wines with a small picture of the product and some description. The user will be able to drill down to see and read more information about the wine.
We need ajax to load sections of the page.
The same person/team selected will develop the design and functionality.
We’ll provide logo and some pictures. The flash animation will show 4 or 5 different pictures with some text fading between pictures. The flash animation will show on the main page only.
We need an option to display a short list of the menu or the wines, showing the name and the price and text only, no images.

WordPress Edit

November 29th, 2009 Comments off

I have installed a wordpress site and theme at http://www.explicitshades.com/wp/ that shows only 3 columns of sunglasses but I need there to be five columns. As a result of adding 2 more columns I need the thumbnails default size to become relative squares NOT the wide rectangles that they currently are.

Lastly I want the thumbnail images (sunglasses) on the main page to be hotlinked to the full post page the same way the title is. So if you click the thumbnail or the title you go to the same place.

Simple Auto Click Bot

October 13th, 2009 Comments off

Hi,

I need a programmer to clone a very simple piece of software in C or C++. If you can also build a Mac OS X version, let me know.

Download the software here:
http://bit.ly/1bXwbM
(the graphics and text are not desired. only need the text boxes and OK button for functionality!)

The user enters 2 numbers (columns/rows), clicks OK to minimize and then presses “SPACE BAR” to begin the auto cursor/clicking.
The software simply moves in the selected columns/rows and auto clicks.

The software MUST perform the same way as the original.

The clone must also include these features:
1) Press “ESCAPE” to cancel any auto cursor/clicking.
2) Remember the columns/rows number values when user quits and relaunches software. (system memory/preferences/registry)

Please let me know if you have any questions prior to bidding.

Categories: C/C++ Tags: , , , , , ,

Php Parse Text Data Into Mysql

September 19th, 2009 Comments off

I need a php script to take data from a text file and parse them into a mySQL database. The original file starts with 9 rows that will not be parsed. The 10th row is the title and rows 11 to ??? will contain the data. There are 8 columns (Code#,Description,Price,Discount,Extend,Cost,Profit,Sold) but I really only need 4 columns parsed (Code#,Description,Price,Sold). The first column in the mySQL database will contain the date (found in row 8). Columns 2-5 will be parsed from the 4 columns from the text file (Code#,Description,Price,Sold).

I have attached a copy of the file. We will run this script every day with new data to populate the database. The script should let you browse to pick which file you want to parse.

We will also need a php script to query the database and display the info. The script should let you pick a date range and a “sort by” option. It should then display all data for the date range with the columns being (Date range,Code#,Description,Price,Sold) and the rows being each row of the database that is in the selected date range.

Unfortunately, I will not be willing to give you access to our database (bad experience in the past), however, you can try it on your database to make sure it works before giving us the 2 php scripts.

The programmer that can get it done the fastest for the lowest price gets the job. I prefer to have this done within 24 hrs.

Categories: MySQL, PHP Tags: , , , , , ,

Blogger Code

September 18th, 2009 Comments off

Very simple, have a blog and I want some code edits done.

BLOGGER.COM

Header : instead of the decription box with my header name, I want an image (you can just put blank image and I will change url) the size of 900px

Simple Web Based Spreadsheet

September 6th, 2009 Comments off

This project would involve taking simple csv files with 8 columns and displaying it on a web browser. Datagrid functionality required:
1) Basic sort – numeric and alphabetic ascending / descending
2) Basic Filtering e.g. display only columns with numbers greater than x.
3) Ability to sum columns with numerical entries and display total.
4) Ability to output the spreadsheet as an excel file.
5) Ability to click on a spreadsheet data value and link to an external web site.

The back end must be in java. Javascript would be highly preferred for the front end.

Clickbank Affiliate Add On

August 25th, 2009 Comments off

I would like to add an affiliate program to my site. First,
let me give you an overview of how the program would work:

I’m providing a service in which I have tested and reviewed
5 of the top ClickBank products. Members who join my site
and upgrade, will be able to plug their ClickBank Nickname
into the system which will create their own personal
affiliate url. These members will then advertise their
personal affiliate url.

Whenever someone purchases from one of the 5 products on
their site, Clickbank will credit the sale to them. As our
system will automatically insert their ClickBank Nickname
into the ClickBank referral url for any of the 5 products
listed on my site.

So, here is what I need done:

1) SIGN-UP PAGE

The following fields should appear on the sign-up page

First Name Last Name Contact Email Address Password
Confirm Password ClickBank Nickname

(NOTE: Please include the checkbox and the Term of Service
link which will be linked to the terms.php A member must
complete All fields and check the checkbox before the system
will allow him to sign up.)

This sign-up page should look like the sign-up page on my
other site located at:
http://www.myguaranteedvisitors.com/user_new.php

Once the member clicks the submit button, he should be taken
to the thanks.php with the following message:

“Thank You For Joining!

An activation Link was just sent to your e-mail address.
Please click on the link in that e-mail to activate your
account. Note: If your activation e-mail is not in your
inbox, please check your bulk or junk e-mail box. If you do
not receive your activation e-mail within 15 minutes, go to
the login page above, click on the “Re-send Activation
Email” link, enter your e-mail address, click the
“Submit” button and the system will re-send your
activation e-mail link.

Thanks Again For Joining!”

The member will then receive the following activation email:

Subject: First Name, Please Activate Your Account!

Body: “First Name, thank you for Joining The Top5BusinessOpportunities.com!

Your ClickBank Nickname is:
Your Password is:
To activate your account you have to open the following link:

ACTIVATION LINK GOES HERE

Click it or copy-paste it to your browser’s query string.

Again, Thanks For Joining!.

Regards,

Admin, TheTop5BusinessOpportunities.com”

Once the member clicks on the activation link, he is taken
to the Log In page where he can now log in.

2) LOG IN PAGE

The log In page will consist of the following fields and
links:

ClickBank Nickname: Password:

Forgot Password | Re-send Activation Email

You can visit the following page to see what the Log In page
should look like:
http://www.myguaranteedvisitors.com/login.php

If a member forgets his password, he can click on the
“Forgot Password” link and enter either is ClickBank
Nickname of Email address and hit the submit button. Once he
clicks the Submit button, the following message should
appear: “Your Password Details Sent Successfully. Please
check your email inbox.”

The email for the Forgot Password should be:

Subject: First Name, Here Are Your Password Details!

Body: Hi First Name, Below are your log in details:

Your ClickBank Nickname is:

Your Password is:

Thanks,

Admin, TheTop5BusinessOpportunities.com

If a member does not receive his Activation Email, he can
click on the “Re-send Activation Email” link, enter his
email address and click the Submit button. Once he clicks
the Submit button, the following message should appear:
“Your Activation Link Sent Successfully. Please check your
email inbox or your Bulk email box. “

The email for the Re-send Activation Email should be the
same as the initial Activation email except the Subject
should read: “First Name, Please Activate Your Account!
(RE-SEND)”

3) MEMBER’S AREA

(Note: You can log into my traffic account to see how the
member’s area should look.

Url: http://www.myguaranteedvisitors.com/login.php

User ID#:
Password:

a) In the Member’s area, the following links should appear
in the header:

Member’s Home | Profile – Delete Acct. | Upgrade Account | Contact Us | Log
Out

Member’s Home page should look like this:

Your Upgrade Status is : INACTIVE (Note when a member first
join, his Upgrade Status will be defaulted at INACTIVE. Once
he purchases a subscription, his Upgrade Status will
change to ACTIVE).

Your affiliate url is:
http://www.thetop5businessopportunities.com/?aff=clickbank_nickname
Once you have upgraded your account, promote your affiliate url above to get
sales.

Hi First Name, welcome to your member’s area. In order to
get started, please follow the steps below.

1) Click on the Upgrade Account link above to purchase a 30
day subscription. The cost of the subscription is (The
Upgrade price will be inserted here) per month. You will be
billed (The Upgrade price will be inserted here) every 30
days until you cancel your subscription.

In order to cancel your subscription, simply log into your
PayPal account and cancel the subscription. If you cancel
your subscription before the subscription is set to expired,
we cannot issue any refunds on any unused days left on the
subscription. Additionally, your Upgrade Status will be set
to INACTIVE on the date the subscription is canceled.

Once your Upgrade Status is set to INACTIVE, you will not be
able to make any sales as the Admin default member’s link
and the Admin default ClickBank Nickname will be inserted on
your page.

2) Once you have completed your purchase on PayPal’s site,
you’ll be re-directed to our Thank You page. All you have
to do is click on the Member’s Home link above and your
Upgrade Status should now read: ACTIVE. If not, send us an
email and we will manually set your Upgrade Status to
ACTIVE.

3) Once your Upgrade Status is set to ACTIVE, you can now
add your 4 member’s link. Just click on the “Add Member’s
Link” below and add your personal links.

4) Once you have added your 4 personal member’s links, you
can now start advertising your affiliate url above. If you
should have any questions, click on the Contact Us link
above and send us an email.

////Below are the columns for the Top sites table. I’ll be
adding 5 top sites so the sites should be numbered 1 through 5

Top Site# | Program Name | Impressions | Clicks | Click-Thru Rate | Re-set
Stats

Note: When a member clicks on the “Re-set Stats” button,
that will zero out the Impressions, Clicks and Click-Thru
Rate fields. Also, I’ll be adding the Program Names from
the Admin Control Panel.

////Below are the columns for the Member’s personal links
table. The members will be able to add up to 4 links. So
the Member links should be numbered 1 through 4.

Member Link# | Description | Url | Edit | Delete

Click here to add Member’s link

When a member clicks on the “Click here to add member
link” above, he should be taken to a page with the
following fields: (Please see the following page
http://www.myguaranteedvisitors.com/site_new.php in the
member’s area to see how this page should be set up.)

ADD MEMBER LINKS

Link Description: (Note: The Max characters for this field
is 30 characters) Link Url:

Submit | Cancel

Whenever a member clicks on the Submit or Cancel button to
Add, Edit or Delete a link, he should be taken back to the
member’s home page.

b) The Profile – Delete Acct page should look like this
(Please visit the following page
http://www.myguaranteedvisitors.com/user_edit.php to see
how this page should be set up.)

USER PROFILE

- First Name
- Last Name
- Contact Email
- Password
- ClickBank Nickname

Submit Button goes here.

DELETE ACCT.

To delete your account, send us an email by clicking on the
Submit button below.

- ClickBank Nickname
- Full Name
- Email Address
- Subject: Please Delete my Top5businessOpportunities Account!

Comments(Optional)

Note: The only field that should be editable is the Comments
field. Also, the ClickBank Nickname, Full Name and Email
Address should appear in the body of the email.

c) The Upgrade Account page should look like this:

When a member clicks on the Upgrade Account link, he should
taken to a page that has the PayPal’s pay button on it.
Once he clicks on the PayPal’s pay button, he should be
taken to PayPal’s payment page and the purchase item
should read: “Top 5 30 Day Subscription For Member: (His
ClickBank Nickname should be inserted here).

Once the member completes his transaction, he should be
re-directed to our thankyou.php page. This is where you
will need to set up the IPN (Note: the IPN url should be
http://www.thetop5businessopportunities.com/notify.php).
If the transaction comes back as status COMPLETED, then
the system should automatically set the member’s Upgrade
Status to ACTIVE. If the transaction comes back anything else,
the system should set the member’s Upgrade Status to INACTIVE.

If a member uses an E-check, the system should set the
member’s Upgrade status to INACTIVE and I should receive
an email stating that I have received an E-check. If the
E-check comes back as cleared or completed, the system
should set the member’s Upgrade Status to ACTIVE and I
should receive another email stating the status of the
E-check. If the E-check does not come back as Cleared, then
the system should set the member’s Upgrade Status to:
INACTIVE. (Note: You can check out my IPN file the
notify.php to see how the IPN and E-check messages are set
up).

Now whenever a member’s Upgrade status is set to: ACTIVE,
his ClickBank Nickname is automatically inserted into the 5
top sites on his affiliate page and he can also add his 4
personal member links. If a member’s Upgrade Status is set
to INACTIVE, his ClickBank Nickname is NOT inserted into
the 5 top sites on his page and he Cannot add his 4 personal
member links. Instead, my admin default ClickBank Nickname
will be inserted and my 4 personal links will be inserted on
his affiliate page. Note: I will add my ClickBank Nickname
and personal links in the Admin Control Panel.

d) The Contact Us page should look like this (Note: to see
what the Contact Us page should look like, please visit the
following page in the member’s area:
http://www.myguaranteedvisitors.com/contact_us.php

- ClickBank Nickname
- Full Name
- Email Address
- Subject: TheTop5BusinessOpportunities Member’s Help
Request!

- Comments:

Note: The member’s ClickBank Nickname, Full Name and Email
address should appear in the body of the email.

e) Log Out

When a member clicks on this link, he should be re-directed
to the index page

4) ADMIN CONTROL PANEL

The Admin Control Panel should look like this (Note: Please
visit the following page
http://www.myguaranteedvisitors.com/admin/login.php to log
into my admin control panel.

Username:

Password:

The following links should appear at the top of the Admin
Control panel.

a) Site Setting link

The following fields should appear on this page:

- Admin ClickBank Nickname (This is my ClickBank Nickname
and will be inserted on all member’s page whose Upgrade
Status is INACTIVE.

- Subscription Price

- Admin PayPal Email Address

- Admin Contact Email Address

- Records Per Admin Page

- Paypal IPN security code

- Site Title

////Below are the fields for the Admin default Member’s
links table. These are the Admin Default member’s links and
will be inserted on all member’s affiliate pages whose
Upgrade Status is INACTIVE. There will be 4 links. So the
Admin default Member links should be numbered 1 through 4.
NOTE: If a member has an Upgrade Status of ACTIVE and he
only adds a couple of links or no links at all, then the
Admin default links will be added on his affiliate page
wherever there is an empty slot. Also, the admin default
link numbers will correspond to the member’s personal link
numbers.

Admin Default Link# 1 | Description | Url | Delete button

Admin Default Link# 2 | Description | Url | Delete button

Admin Default Link# 3 | Description | Url | Delete button

Admin Default Link# 4 | Description | Url | Delete button

Update Button goes here

Note: The member links will be shown on the member’s
affiliate page in the lower part of the header. Please
visit the index page at:
http://www.thetop5businessopportunities.com to see what I
mean. The first 4 links will be the member’s links or the
Admin Default links and the 5th link will be the Contact Us
link.

b) Password Setting link Please see the following page in
http://www.myguaranteedvisitors.com/admin/password_settings
the Admin Control Panel for details: .php

c) Add Top 5 Sites link

Below is how the Add Top 5 Sites page should look

Top Site# 1 | Program Name | Vendor Name | Delete (Note:
Since the Top Site#1 is linked to a banner on the member’s
affiliate page, you can omit the Title and Description for
the Top Site# 1.

Top Site# 2 | Program Name | Title | Description | Vendor Name | Delete

Top Site# 3 | Program Name | Title | Description | Vendor Name | Delete

Top Site# 4 | Program Name | Title | Description | Vendor Name | Delete

Top Site# 5 | Program Name | Title | Description | Vendor Name | Delete

Update Button goes here

The Program name will only be shown in the member’s area
under the Top Sites table. The Title and the Description
will be shown on the member’s affiliate page under the
respective Top Site#.

Note: A typical ClickBank affiliate url looks like this:
http://wespac59.sixfigprog.hop.clickbank.net

Where it says wespac59 is where the member’s ClickBank
Nickname will be inserted. Where it says sixfigprog is
where the Vendor Name will be inserted. This url with the
member’s ClickBank Nickname and the Vendor Name will be
inserted under the respective Top Site# where it says
“Click here to visit site” on the member’s affiliate
page.

Note: The Top Site# 1 will be shown linked to the banner at
the top of the member’s affiliate page. Top Sites #’s 2,
3, 4 and 5 will be shown on the bottom of the member’s
affiliate page. Please visit the index page at:
http://www.thetop5businessopportunities.com to see what I
mean.

d) User Management link (Note: Please visit the following
http://www.myguaranteedvisitors.com/admin/user_ctrl.php?act
page to see how this page should look: =search

Below are the links and fields:

- Status Links (All, Active, Inactive, Confirmed and Un-Confirmed)

- Page Links

- Total Users

Below are the columns for the member data table

- ClickBank Nickname

- Email Address

- First Name

- Last Name

- Account Status (if the member has activated his account
then it should read CONFIRMED. If the member has not
activated his account, then it should read UN-CONFIRMED.)

- Upgrade Status (If a member has paid for a subscription
this should read ACTIVE. If he has not paid for a
subscription then these should read INACTIVE.)

I should be able to click on the member’s email address and
be taken to that individual member’s record. Please visit
http://www.myguaranteedvisitors.com/admin/user_info_approve
the following page to see what I mean: .php?ud=8

The following fields should appear on this page:

- Member’s ClickBank Nickname

- Sign Up IP

- Sign Up Time

- Upgrade Status

- First Name

- Last Name

- Password

- Email

- Account Status

The Update and Delete button goes here. (Note: whenever I
delete a member’s record, all data in the database
relating to this member should be deleted as well.)

Note: I should be able to edit all the fields above except
the Sign Up IP and the Sign Up Time fields.

At the bottom of this page should be a email contact form.
This is where I will send an email to an individual member.
Below are the fields:

- E-mail User (the member’s ClickBank Nickname will be inserted here)

- Subject:

- Message:

Substitutions (Email Message Body / Title field):

{CLICKBANK_NICKNAME} Member’s clickbank nickname
{FIRSTNAME} User’s firstname
{LASTNAME} User’s lastname
{EMAIL} User’s email
{BASEURL} http://www.thetop5businessopportunities.com
{SITETITLE} TheTop5BusinessOpportunities.com

Email User (member’s ClickBank Nickname) button goes here.

e) E-mail Members link (Note: please visit the following
page to see how this page should be set up:
http://www.myguaranteedvisitors.com/admin/user_mailer.php)

- Status (All, ACTIVE, INACTIVE, CONFIRMED and UN-CONFIRMED)
I should be able to select the status of the members I
would like to email.

- Message Type:

- Subject:

- Message:

Substitutions (Email Message Body / Title field):

{CLICKBANK_NICKNAME} Member’s clickbank nickname
{FIRSTNAME} User’s firstname
{LASTNAME} User’s lastname
{EMAIL} User’s email
{BASEURL} http://www.thetop5businessopportunities.com
{SITETITLE} TheTop5BusinessOpportunities.com

Send button goes here

f) Log Out link

g) ClickBank Nickname and Email Address search

Just below the Admin Control links and on every page there
should be 2 search boxes as follow

- Find ClickBank Nickname
- Find Email Address

Whenever I enter the member’s ClickBank Nickname or his
Email Address and click the button, I should be taken to
his individual record page. Please visit the follow page to
http://www.myguaranteedvisitors.com/admin/user_info_approve
see what I mean: .php?ud=8

h) Sales Page

Create a page named salespage.php. This will be the page
that I will advertise to get people to sign up. I will add
my own content to this page. This page will have the
following links just below the header: Note: These link will
appear ONLY on the sales.php page.

- Home

- Bookmark

- F.A.Q.

- Terms

- About Us

- Contact Us

- Join

- Member Login

i) Index Page

The Admin default member’s links will always appear in the
header of the index page. Also, the Admin ClickBank Nickname
will always appear in Top Sites#’s 1, 2, 3, 4 and 5 of the index
page.

Note: On the member’s affiliate page and on the
Index page just below the member’s link and to the far
left, put the following link: “Existing Members Click Here
To Log In”. When a member clicks on this link, he should
be taken to the member’s Log In page.

Categories: MySQL, PHP Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

Macro2export Columns To Excel

August 24th, 2009 Comments off

I need some one to write a macro to export specific columns from excel to a .csv file and ignore the other columns. The current spreadsheet has 54 columns and I need to export 20.
Please use the words “green bug” in your reply so I know you read what I am asking for.

Coupon Book And Order For Site

August 17th, 2009 Comments off

Need to be done today via online, quick and fast job.
$100. You must do it today and finish it.

I already have site, I already have an admin panel, I can edit restaurants too and delete them etc., but I need these functions to be added. I have the forms etc., This will not take more than 4-6 hrs and should not if you can program. I work on a budget. Do not bid if you do not see budget.

-Coupon book can be view via restaurant page. Manage by admin and owner that created them/add/delete/modify
-order by looking directly at menu online via restaurant page. Click on each item, type in how many of the item and calculate
choose delivery or takeout. Order is then pending status, waiting for restaurant to approve or reject.
-Need a select all button for my admin panel.
-Need to add users to admin panel/delete accoutn/change info etc.,

Orders will not use any type of payment online or any system. Just a form so restaurant can accept or reject and orders are kept in database for viewing/sorting/etc, calculate # orders by month, # rejected, average order cost etc.,

Additional For order, restaurant will input tax% (5% or 10% etc.,) base on order (including name/address) and if it is takeout or delivery restaurant will input that number once it is reject or approve.

Total order is then automatically calculated.
Each order needs to be verify by user submitting order by email verification.
Coupons to have 3 fields:
Call it “Coupon Offer, Restrictions/Terms, Other Details)
Offer could be

Coupon Book And Order For Site

August 17th, 2009 Comments off

Need to be done today via online, quick and fast job.
$100. You must do it today and finish it.

I already have site, I already have an admin panel, I can edit restaurants too and delete them etc., but I need these functions to be added. I have the forms etc., This will not take more than 4-6 hrs and should not if you can program. I work on a budget. Do not bid if you do not see budget.

-Coupon book can be view via restaurant page. Manage by admin and owner that created them/add/delete/modify
-order by looking directly at menu online via restaurant page. Click on each item, type in how many of the item and calculate
choose delivery or takeout. Order is then pending status, waiting for restaurant to approve or reject.
-Need a select all button for my admin panel.
-Need to add users to admin panel/delete accoutn/change info etc.,

Orders will not use any type of payment online or any system. Just a form so restaurant can accept or reject and orders are kept in database for viewing/sorting/etc, calculate # orders by month, # rejected, average order cost etc.,

Additional For order, restaurant will input tax% (5% or 10% etc.,) base on order (including name/address) and if it is takeout or delivery restaurant will input that number once it is reject or approve.

Total order is then automatically calculated.
Each order needs to be verify by user submitting order by email verification.
Coupons to have 3 fields:
Call it “Coupon Offer, Restrictions/Terms, Other Details)
Offer could be

Macro 2export Columns To Excel

August 13th, 2009 Comments off

I need some one to write a macro to export specific columns from excel to a .csv file and ignore the other columns. The current spreadsheet has 54 columns and I need to export 20.
Please use the words “green bug” in your reply so I know you read what I am asking for.

Email From Excel

August 9th, 2009 Comments off

I need a macro or a program integrated in MicroSoft Excel which can perform the following function: To send an email (using Outlook) to an specific email including some data from the specific row when a condition is reached.

a.- The condition is a parameter (example 0 or 1 in a given column). When the macro or program is run, on each row where the given column has the

Magento Header Modifications

July 24th, 2009 Comments off

I need somebody to modify the header to reposition a few items, and change a few stuff around in the banner within Magento.

Attached Magento_current.jpg is what we have now, and Magento_final.jpg is what I need the top portion to look like.

I also need to fix the columns to 5 columns instead of 3 columns for the Grid view

**Required to have Google Talk

E-commerce Telecom Site

July 24th, 2009 Comments off

Hello,

I decided to re-post this project now as “featured” as I did not have interesting bids

Images : http://www.partenium.com/appelgratos/2/jpg.zip
xhtml : http://www.partenium.com/appelgratos/2/apples-php-28jun09.zip

Project :

It is a service that offers telecom services to users.

The website will require user to subscribe, pay and then use their credit to call people abroad.

I only need you to make the website, all the telecom part is on another server and I will send you precise mysql commands to get information from this server.

You can see the screen capture of the design on :
and the xhtml on :

appelsgratos2 :
Admin will be able to add/edit/remove destination and prices (3 prices per destination) from administration panel.
The countries will be listed in alphabetical order.

INSCRIPTION : This is the login and registration (step1) page. User can login using the header or when he is trying to access a page that requires to be loggued (Mon compte =>

My acount, Recharger => Add credit, D

Attendance Spreadsheet

July 10th, 2009 Comments off

REQUEST #1
I need an excel macro with coding that shows me each punch in and punch out for an employee and totals the amount of hours and minutes that the employee has worked for the day.
I’ll try to break the current process I use into separate steps, so that you can more easily follow the logic and create the code.

E-commerce Telecom Website

July 9th, 2009 Comments off

Images : http://www.partenium.com/appelgratos/2/jpg.zip
xhtml : http://www.partenium.com/appelgratos/2/apples-php-28jun09.zip

Project :

It is a service that offers telecom services to users.

The website will require user to subscribe, pay and then use their credit to call people abroad.

I only need you to make the website, all the telecom part is on another server and I will send you precise mysql commands to get information from this server.

You can see the screen capture of the design on :
and the xhtml on :

appelsgratos2 :
Admin will be able to add/edit/remove destination and prices (3 prices per destination) from administration panel.
The countries will be listed in alphabetical order.

INSCRIPTION : This is the login and registration (step1) page. User can login using the header or when he is trying to access a page that requires to be loggued (Mon compte =>

My acount, Recharger => Add credit, D

Oscommerce – Small Updates

June 28th, 2009 Comments off

1) Order Editor attributes fix:
The order editor works fine in all cases, except when adding new products with attributes to the order or when changing quantities of attributes in the orders. The master quantities are subtracted from the site’s stock, but the attributes (site is using QTpro) are not subtracted. This needs to be fixed.
Note that the order editor is using Ajax too.

2) Quick Full Updater fix:
I have a custom made bulk products updater script that shows only columns that I selected when I search for a product, but after I click submit it refresh the page and show all the columns regardless to my previous selection. Minor annoyance, and probably a minor fix needed, but would like this behavior to be fixed.

3) Customers/Orders per product report:
I have the customers per product report, using Ajax search suggest for the products’ names. I need to change the results displayed.
I want to make the report show a sortable list of orders where the selected product exists. The table should show: order number, customer name, , purchase date, quantity sold (of the selected product, take into account the attributes too of course). All columns must be sortable (ASC or DESC).
Most of the script is done already, so the work should be quite simple.

4) Login redirection to last location after admin session expire:
The title says it all. I need the admin login screen to redirect to the last visited page when logging in after being logged out by the session timeout.

5) catalog/create_account.php email fix:
Actually it is login.php on my server, as the files were combined into 1.
When a new customer register – all the new registration details are sent to the store owner, except for the state that is kept blank, that’s probably because of the country/state selector mod that’s installed on this page. I need this fixed so that the email will include the state too.

6) Disallow specific payment methods to customers from certain countries:
I want to make catalog/create_account.php (actually login.php) to automatically set (upon registration) some unallowed payment types for customers from specific countries I choose.
I should be able to select the unallowed payments and the countries from the admin.

7) Send emails to customers-from enhancement:
I want to improve the send emails script (in the admin) to have a dropdown that allows me to choose only customer from certain country/countries to send email to.

Programmer will have full ftp access and osc admin access to a mirrored development server and is required to properly comment ALL changes he makes and send email with complete change logs when each job is successfully done.

Roulette Tracker

June 27th, 2009 Comments off

The tracker should have 37 buttons, each of those buttons with a number on it (the european roulette wheel numbers 0 – 37)

It should then also have an “undo last” button (which would undo whatever the last entry was)

When I push one of the numbered buttons, it should show the results in 4 different columns.

All the columns should display results in a Marquee type fashion.

The first column would be numbers, second column Red and Black (displayed as R B, Third column Even and Odd (displayed as E O and finally the fourth column would be High and Low (displayed as H L).

The program does not need a save feature, an export data feature, an import spins feature or anything “fancy”. It is just simply a tracker.

The only column that needs to have numbers in it is the numbers column. The other columns would show the results of the number pushed with the appropriate defining letter and displaying it on either the left or right hand side of it’s window.

I have attached a picture of what I would like the finished product to be at least similar to.

Bear