Community Add-Ons

Very small correction to a substr function call - increasing length to ten to get full date showing correctly.

Full Package here.

Files changed from last version:

Upload FilesIf modifying Files-only NEW Filescatalogadminstats_referral_sources.php

Upload FilesIf on clean osC versioncatalogadminstats_referral_sources.php

This is a small fix to the 1.5 version of this contrib.

CHANGED:
* Fixed code to optionally have a text field only referral box on create_account.php (it didn't work as it was written. See OPTIONAL in the install steps).
* Added missing stats_referral_sources.php to admin/languages/english/ folder in the "NEW" files folder.

Full Package

Version 1.5 included some complete files for easy installation. It appears these were not updated to reflect security updates that have happened to osCommerce since the release. Version 1.6 simply includes those changes and no others.

The complete files have been updated. If you used the manual patching route, or applied the oscommerce security updates /after/ installing 1.5, you should not be affected.

Also, the file "security.diff" is included in the standard "patch" format, detailing exactly what changed between versions 1.5 and 1.6. (Unfortunately, because of how the patch was generated, it is reversed. )

I can provide no direct support for this release-- using the forum link mentioned in the instructions file is recommended.

This is an update to the referral sources report that is part of the 1.4 release.

This adds the following
1) date selection
2) drill down capability on individual referral codes

CHANGED:
* Updated backend reporting to include more useful data such as referral dates.
* Included code to optionally just have a text field only referral box on create_account.php (see OPTIONAL in the install steps).

These are spanish language files for "How Did You Hear About Us". To use them, you will need to install the full package below first.

Aquí os dejo la traduccion al espanol del "How Did You Hear About Us" para instalarlo antes debéis haber instalado la versión completa 1.4 ya que en este comprimido sólo van los ficheros de lenguaje que afectan al idioma espanol.

english language file missing so i put it in

These are german language files for "How Did You Hear About Us". To use them, you will need to install the full package below first.

Deutsche Sprachdateien für "How Did You Hear About Us". Um dieses Paket zu installieren, müssen Sie zunächst das volle Paket weiter unten installieren.

#######################################################

How Did You Hear About Us 1.4 FULL Contribution

Official Forum Support Thread:
http://forums.oscommerce.com/index.php?showtopic=96806

ALERT: [ PAY ATTENTION]

THE ORGINAL DIRECTIONS ARE LEFT INTACT THAT RYAN HOBBS CREATED
FOR ARCHIVE PURPOSES

!!The Directions by TCwho start when you see this:

------------------###############---------------------
Instructions below provided by: TCwho
http://forums.oscommerce.com/index.php?showuser=48693

I decided to provide these etc etc...


UPDATE:

1. Instructions have been updated
2. MySQL instructions have been restored back to seperate file
**Some where confused as to where the MySQL was**
**When it comes time to add MySQL Query you have to options:
A. Copy<>paste code below into PhpMyAdmin
B. Import mysql file into PhpMyAdmin
3. Forum Support Thread Link added
4. Added Fix provided by Ryan Hobbs for 'Other Sources' still
left in the Database even after Customer was deleted
**update was added to Clean-Install Upload as well as
Instructions update below
5. There was a mistake in the instructions for catalog/create_account.php
**Has been fixed below** I apologize for my error

#########################################################

Instructions below provided by: TCwho
http://forums.oscommerce.com/index.php?showuser=48693

I decided to provide these instructions for those that did not have
a clean vanilla installation of osC. All of the downloads provided below only contain the files to upload(which isnt a problem if you have a clean osC site)...I have a modified version of osC....
so any line numbers given are just to help you find the code to look for.

Thanks to Ryan Hobbs for a Great Contribution.

Don't show option in catalog if no sources exist
Added option to automatically populate "Other" textbox based upon referral_id

Added the missing line

define('FILENAME_REFERRALS', 'referrals.php'); // rmh referrals]

{11/28/2004} All credit goes to original authors and other contributors.

v1.2 - 08/10/04
Referral Report Bug fixes
Display Referrer for customer
Create Account SQL Bug fixes

Updated to fix sql bugs

Forgot to update a portion of the sql file after initial change was made to table `sources_other`

SHOULD BE:
==========

CREATE TABLE sources_other (
customers_id int NOT NULL,
sources_other_name varchar(64) NOT NULL,
PRIMARY KEY (customers_id),
);

{vs. PRIMARY KEY (sources_other_customers_id), }

SQL FILE ONLY.

Creates a drop-down box populated by admin entered referral sources that prompts the
customer where they found out about the site.

Admin can also make this required or not.

Also includes ability to control whether or not an "Other" appears in the dropdown and if so, displays an additional text input box.

Information is then stored in customers_info table and two new tables (sources, sources_other) for 1 included report and data mining.