How Did You Hear About Us? Referrals Mod [Support Thread]

[AmandaGero]

HMM, IT DID NOT UPLOAD

I HAD TO REMOVE THE INSTRUCTIONS AND SQL FLE FOR THE SIZE TO BE SMALL ENOUGH TO UPLOAD HERE, BUT THOSE FILES REMAIN THE SAME.

INSTALL.SQL

DROP TABLE IF EXISTS sources;
CREATE TABLE sources (
  sources_id int NOT NULL auto_increment,
  sources_name varchar(64) NOT NULL,
  PRIMARY KEY (sources_id),
  KEY IDX_SOURCES_NAME (sources_name)
);

INSERT INTO sources VALUES (1, 'Google');
INSERT INTO sources VALUES (2, 'Yahoo!');
INSERT INTO sources VALUES (3, 'AOL');
INSERT INTO sources VALUES (4, 'MSN');
INSERT INTO sources VALUES (5, 'ZenCart');

DROP TABLE IF EXISTS sources_other;
CREATE TABLE sources_other (
  customers_id int NOT NULL default '0',
  sources_other_name varchar(64) NOT NULL,
  PRIMARY KEY (customers_id)
);

ALTER TABLE customers_info ADD customers_info_source_id int NOT NULL AFTER customers_info_date_account_last_modified;


INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Display "Other" Referral option', 'DISPLAY_REFERRAL_OTHER', 'true', 'Display "Other - please specify" with text box in referral source in account creation', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Require Referral', 'REFERRAL_REQUIRED', 'true', 'Require the Referral Source in account creation', '5', '6', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

README

Instructions for installing How Did You Hear About Us Version 1.3.9F

================= IMPORTANT =====================
Please BACKUP your store and database before 
attempting any of these changes.
I will not be held responsible!

Core files that are modified are:
admin/customers.php
admin/orders.php
admin/includes/languages/english/customers.php
includes/modules/create_account.php
includes/templates/YOUR TEMPLATE/templates/tpl_modules_create_account.php

=================================================

1. This version is compatible with ZenCart Version 1.3.9f - The Updateto 1.3.9a was done by JT Website Design 
	The update from 1.3.7/8 was 
   done by Judy Gunderson at http://zencart-ecommerce-website-design.com
   The update from 1.3.1 to 1.3.6_beta was done by CES. For support please see
   the zen-cart forum http://www.zen-cart.com/forum/showthread.php?t=35623
   Contact ranger_lp########################## for versions that are compatible w/1.2.x.
   This contribution was converted to ZenCart from the original osCommerce
   contribution (See below).

2. Unpack the zip file to a temporary directory on your hard drive. All of the
   files are stored in separate directory structures and all files are based on
   ZenCart Release 1.3.9f(e.g. admin and includes).
   
3. Copy the contents of the `how_did_you_hear_about_us_1.3.9f` directory to your
   Zen Cart installation except for the `install_referrals.sql` file and this 
   installation file. If you are using any overrides in ZenCart that include the
   files in the this contribution, use an application such as Beyond Compare or
   WinDiff to compare your files and resolve any differences.
   There is one file:
   (\includes\templates\template_default\templates\tpl_modules_create_account.php)
    which should be put in your template override folder i.e.
    (\includes\templates\YOUR-TEMPLATE\templates\tpl_modules_create_account.php)

4. Run the SQL file install_referrals.sql on your database. You can use the 
   Install SQL Patches in the ZenCart Admin Panel under Tools -> Install SQL
   Patches or you can use phpmyadmin for this purpose.

5. Enjoy your newly installed contribution!


How to Use How Did You Hear About Us Version 1.3.9f

This contrib creates a drop-down box populated by admin entered
(Admin->Extra->Referral) referral sources that prompts the customer where they 
found out about the site. Admin can also make this required or not 
(Admin->Configuration->Customer Details). Also includes ability to control 
whether or not an "Other" appears in the dropdown and if so, displays an 
additional text input box (Admin->Configuration->My Store).

Information is then stored in customers_info table for reports and data mining.
Reports are displayed in Admin->Extra->Referral Sources. If you double click on 
`Other` a list of all the write in sources from customers will appear with the 
dates that they were entered.

Disclaimer
----------
This program is free software; you can redistribute it and/or modify it
under the terms of the GNU General Public License as published by the
Free Software Foundation; either version 2 of the License, or (at your
option) any later version.

This program is distributed in the hope that it will be useful, but
WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
General Public License for more details.

You should have received a copy of the GNU General Public License
(LICENSE) along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,
USA.

Authors
-------
Thanks to Ryan Hobbs for the original osCommerce contribution and Keith W (homewetbar) who added functionality to the osCommerce 1.5 version of this contribution.