Contributions
osC Affiliate
This is the completed Alpha release of osC Affiliate 1.0.
Please note that this module is an Alpha, and while it works it does not yet meet the osCommerce standards.
This module has been designed to allow easy future upgrades without impacting to much on the osC core files.
Only partial intergration has been completed at this stage with full intergration and extra features planned for a future release.
For a list of features and things still to be completed please refer to the discussion forums.
Enjoy.
Expand All / Collapse All
This is "module" for index page for the Admin section.
Install instructions:
Place/Update the affiliate_summary.php in the catalog/admin/includes/modules/index/ folder
This is not a complete package and needs OSCAffiliate2.8 as well.
Only 1 file attached.
Demo: http://mnkedition.oscommerce-packages.com/admin/
Infobox para afiliados para gerar receita extra para seu website. Fácil instalação e tutorial passo a passo.
If a customer is already logged in, retrieve his information he has already entered and place them into the correct fields.
Saves the customer time and is a few lines of code added to the top of the file affiliate_signup.php
Takes 10 minutes.
Affiliate Box does not appear unless affiliate is logged in.
Affiliate Box Login, Info, and FAQ moved into footer.
Instructions for this mod only. Rest of the contribution will need to be downloaded and installed first.
I have tried oscaffiliate till 8 tiers and it works great.
Having just installed OSCAffiliate2.8 on a brand new version of 2.2rc1 I have a solution for the index.php code changes as listed. rc1 uses a "modular" index page for the Admin section, so the code changes need to be in a new file of their own, as included.
Install instructions:
New file:
Place the affiliate_summary.php in the catalogadminincludesmodulesindex folder
Make all other changes as per the modified instruction text file as included in this fix.
I have included the missing New News gif for the Affiliate News Admin page. Upload this to catalogadminincludeslanguagesenglishimagesbuttons to fix the missing image.
This is not a complete package and needs OSCAffiliate2.8 as well.
just replace your old file with my new "catalog/includes/languages/english/affiliate_signup.php" file.
The informations that comes via mail was like that" Your Affiliate ID is: Your Affiliate Username is: Your Password is: Link to your
account: " . This is the bug.
I fix it nor it works good
SMALL UPDATE for the BUG of "Missing affiliate_category_id Dhananjaya 6 Dec 2007"
----->UPDATE YOUR AFFILIATE.SQL FILE<-----
DROP TABLE IF EXISTS affiliate_banners;
CREATE TABLE affiliate_banners (
affiliate_banners_id int(11) NOT NULL auto_increment,
affiliate_banners_title varchar(64) NOT NULL default '',
affiliate_products_id int(11) NOT NULL default '0',
affiliate_category_id` int(11) NOT NULL default '0',
affiliate_banners_image varchar(64) NOT NULL default '',
affiliate_banners_group varchar(10) NOT NULL default '',
affiliate_banners_html_text text,
affiliate_expires_impressions int(7) default '0',
affiliate_expires_date datetime default NULL,
affiliate_date_scheduled datetime default NULL,
affiliate_date_added datetime NOT NULL default '0000-00-00 00:00:00',
affiliate_date_status_change datetime default NULL,
affiliate_status int(1) NOT NULL default '1',
PRIMARY KEY (affiliate_banners_id)
);
-with bug and not need "affiliate_category_id (bug-->`<--) int(11) NOT NULL default '0',"
for fix just delete this line.
----->TO RUN CORRECT QUERY FILE<------
in affiliate.sql file you can see created affiliate_category_id.
find this line (arround line 214)--
|
v
ALTER TABLE `affiliate_banners` ADD `affiliate_category_id` INT DEFAULT '0' NOT NULL AFTER `affiliate_products_id` ;
In zip file added correct affiliate sql query.
osCAffiliate v2.8 with last all fixes.
Last full package with 2 Updates and 3 fixes...
Has been attached updated_and_fixed_by_faaliyet.txt file.
For some reason myself and others in the forums seems to have installations of osc affiliate that want a affiliate_category_id field in the affiliate banners table but the sql file didn't have it so we get errors like 1054 - Unknown column 'affiliate_category_id' when we try to create a banner.
This sql file has the missing field.
This is just the sql file.
If you don't want to replace your affiliate tables then just run this instead. It will only replace the banner table:
DROP TABLE IF EXISTS affiliate_banners;
CREATE TABLE affiliate_banners (
affiliate_banners_id int(11) NOT NULL auto_increment,
affiliate_banners_title varchar(64) NOT NULL default '',
affiliate_products_id int(11) NOT NULL default '0',
affiliate_category_id` int(11) NOT NULL default '0',
affiliate_banners_image varchar(64) NOT NULL default '',
affiliate_banners_group varchar(10) NOT NULL default '',
affiliate_banners_html_text text,
affiliate_expires_impressions int(7) default '0',
affiliate_expires_date datetime default NULL,
affiliate_date_scheduled datetime default NULL,
affiliate_date_added datetime NOT NULL default '0000-00-00 00:00:00',
affiliate_date_status_change datetime default NULL,
affiliate_status int(1) NOT NULL default '1',
PRIMARY KEY (affiliate_banners_id)
);
I think I'm using 2.7 and I think it is needed for 2.7 but I don't know for sure.
Back up your files first!
To combine the two, open /includes/modules/payment/paypal_ipn.ph.
*********************************************
Find this code around line 76:
function confirmation() {
global $cartID, $cart_PayPal_IPN_ID, $customer_id, $languages_id, $insert_id, $order, $order_total_modules;
directly below add this code:
global $affiliate_ref, $affiliate_clientdate, $affiliate_clientbrowser, $affiliate_clientip, $affiliate_clickthroughs_id, $HTTP_SESSION_VARS;
*********************************************
Find this code around line 245:
tep_session_register('cart_PayPal_IPN_ID');
$cart_PayPal_IPN_ID = $cartID . '-' . $insert_id;
}
}
return false;
}
and change to:
tep_session_register('cart_PayPal_IPN_ID');
$cart_PayPal_IPN_ID = $cartID . '-' . $insert_id;
}
}
// Include OSC-AFFILIATE
require(DIR_WS_INCLUDES . 'affiliate_checkout_process.php');
return false;
}
*********************************************
FIX for minor display bug in Mozilla Firefox.
Description of bug:
The display bug happens whenever a user calls to view the listing of products or categories, generated by the Affiliate Programm. For instance, in the ADMIN pannel, when creating a BANNER, there is a link that says:
Click Here: to view available products.
When you "click here", a popup widow shows up a list of the catalog products. In Firefox, the Product Numbers show up as follow:
 01
 02
 03
etc.
(01,02,03 being the product numbers)
In Internet Explorer, only the product number show up.
This bug can be annoying because your Afiliates also have access to the product listings when they wish to create Affiliate Links from their Affiliate menu. If they use the product numbers with the " " in their Affiliate code, it just won't work.
Added english language support.
Italian Translation files for osCAffiliate v.2.7
It is not a full package, only italian files.
Other note in the readme file. Thanks.
Add two line at the file affiliate_signup.php:
$a_confirmation = tep_db_prepare_input($HTTP_POST_VARS['a_confirmation']);
$a_agb = tep_db_prepare_input($HTTP_POST_VARS['a_agb']);
Dieses Programm ist nur auf Deutsch und ist sofort Einsatz bereit, es muß nur die Sprache angepaßt werden.
Dieses Programm ist nur auf Deutsch und ist sofort Einsatz bereit, es muß nur die Sprache angepaßt werden.
it works now!
This is a complete English package. I didn't update the German Files.
See BUG_FIXES.txt for the fixes.
Here is some fix for this contribution.
There is still a few major bugs to resolve "for me anyway" on this great contribution who I think is not quite finished.
Also here is a tread (not sure if it is the only one) but it still active, you will find a few answers there.
http://forums.oscommerce.com/index.php?showtopic=28975&st=1860
This is just an update of a few files (English and French) that had errors or else.
This is NOT the COMPLETE package.
CL
Annule et remplace la V2.6 précédente car manquait des lignes traduites coté admin.
Traduction complète du coté Admin
Ajout de osCAffiliate_Affiliate_Box_Fix
define manquant corrigé
Rectification + ajout des traductions coté boutique
Solution complète.
Visible sur http://demo.e-central.fr/catalog/
-----------------------------------------
Add Admin pannel translation
Add osCAffiliate_Affiliate_Box_Fix
Add define code
Upgraded translation
Full package upgraded, fixed & translated.
You can see it on http://demo.e-central.fr/catalog/
This is a full package for french.
This contains all the pieces of code people have added since the last full release.
This is a full package for english.
If you found that you can't registered an affiliate account. See here. It might have some bug in affiliate_signup.php
$a_confirmation = tep_db_prepare_input($HTTP_POST_VARS['a_confirmation']);
$a_agb = tep_db_prepare_input($HTTP_POST_VARS['a_agb']);
This two lines of code is to capture the parameters from the affiliate signup form. As i noticed that the affiliate_signup.php doesn't pass this password confirmation and term&uses checkbox value. After i add this 2 line of code. It can successfully signup an affiliate account. yeah!
I had attach the compete affiliate_signup.php which had fixed this problem.
i was root'n around and found an upgrade_eng.txt file in ver 2.02
maybe this will help
i'm planning on upgrading shortly, so wish me luck!
Shawn
It was very annoying that I was unable to sort affiliates in admin and with high volume of affiliates, it become far from being well-arranged.
This new file replaces affiliate_affiliates.php and when uploaded, you'll be able to sort affiliates either by their id, first or last name.
This is not a full package but two nice arrows are also included.
Just upload two images, replace your affiliate_affiliates.php and you're done in 10s! Enjoy and share!
It annoyed me that whenever I clicked on
the box heading for the Affiliate box in
Admin that it was linked to the Affiliate
entry for the Configuration box. The normal
procedure for the box heading had not been
followed.
This is now corrected and the Configuration
for the Affiliate system only appears under
the Configuration Box, and when you click
on the Affiliate Box heading you only get
the files listed there, with the default being
Affiliate Summary.
File included:
admin/includes/boxes/affiliate.php
Rhea (Vger)
When deleting a payment, the payment and payment history were deleted but the billing status against the actual sales records were not being resetted.
To fix this in admin/affiliate_payment look for:
tep_db_query("delete from " . TABLE_AFFILIATE_PAYMENT_STATUS_HISTORY . " where affiliate_payment_id = '" . tep_db_input($pID) . "'");
and add right after:
tep_db_query("update " . TABLE_AFFILIATE_SALES . " SET affiliate_billing_status = '0' where affiliate_payment_id = '" . tep_db_input($pID) . "'");
Only affiliate_payment.php file included
Hi for those of you that use osc Affiliate with the mod for
Column Controller w admin V2.1
http://www.oscommerce.com/community/contributions,1009
Here's a txt file to help
HTH,
Ally
------------in catalog/affiliate_details.php
Found an error and removed 2x"" from 'onSubmit="return check_form();"'
Just a basic modification to include some terms and conditions (english only, sorry) to help you get started. Extract file (affiliate_terms.php) to
/yourcataloglocation/includes/languages/english/
and tailor to suit your needs!
This is an edition that is become the traditional Chinese character by English translation...
Translate the edition V2.5a...
Note on how to set up 2 tier program correctly with osCAffiliate v2.5a - 8/5/2005
I was advised to set my affiliate program up with 2 tier since that is what the larger affiliate directories require. The 1 tier program was working well for me but I had not tested the 2 tier feature. I had to make one adjustment to get it to work correctly.
Os aportamos desde nuestra comunidad la traducción de este modulo al español, tanto el texto como las imagenes.
Nos podeis visitar en http://www.gptproject.org , para indicarnos cualquier error o colaborar con nuestro proyecto.
In admin/includes/affiliate_application_top.php
add :
define('FILENAME_AFFILIATE_VALIDCATS', 'affiliate_validcats.php');
Updated the last package to include a fix for affiliate_news.php in the admin language section
and added button image that was missing from the admin section.
Where is the upgrade file??
This has no new additions, but contains all the pieces of code people have added since the last full release. This is a full package for english.
Heyo all,
Repacked for right directory´s and translation
was not correct, now it is :)
Install Instructions included.
i have look around and found that help files not.
so i have made myself. Don´t look of my bad english,
but you can translate the english entries in affiliate_english yourself, that it fit the english language for you.
Have a great day...
Hobbes
Heyo all,
i have look around and found that help files not.
so i have made myself. Don´t look of my bad english,
but you can translate the english entries in affiliate_english yourself, that it fit the english language for you.
Have a great day...
Hobbes
There as an imporper referrence that was not making the link. It has been corrected. Download this file for the code snipet to add to your product information page.
Add this little gif to /catalog/admin/images/categories/
Add this:
define('FILENAME_CATEGORIES_INFO', 'index.php');
to catalog/includes/filenames.php
error |
bierzonatura |
21 Jan 2005 |
|
error en el archivo admin/includes/languages/espanol/affiliate_clicks.php
en la linea 28 sustituir toda la linea por define('TEXT_NO_CLICKS', 'No hay cliks grabados');
Traducion al español de la contribucion para poner un programa de afiliados.
***Solo tiene los archivos de language***
If you experience a "build a category link" error, when invalid link buid contains "FILENAME_CATEGORIES_INFO" text -
Find
DIR_WS_CATALOG . FILENAME_CATEGORIES_INFO
line in affiliate_banners_build_cat.php file and change it to
DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT
It should work then.
Optional, if you are using NIMMIT_SEF-V0.4 contribution -
Find
ref=' . $affiliate_id . '&cPath=' . $individual_banner_id
and change it to
cPath=' . $individual_banner_id . '&ref=' . $affiliate_id
file included, but please backup first.
I got the pics to show you how it generate the banner product.
1.The Build A Link Feature is to complicated
2.You can insert a link for the affiliate in the product_info.php:
See it live in action at the site below:
http://www.fabulousite.com/cybershop/product_info.php?products_id=22
Note: The Affiliate need to login to their account first.
And then they would click on any products they like to generate.
See demo1.jpg and demo2.jpg and you will know what was I am talking about.
Update for the news system of affiliate contribution:
News for each language installled was not supported. Now, I closed the gap.
New:
- You can edit each language news
- You can delete the news for a specific language
- It is possible to display news only to customers of certain languages
Note: Don't forgot to backup first! All old news will be deleted. To save your news into the new system, use sql-querries in the correct sequence or ask someone for help.
1.The Build A Link Feature is to complicated
2.You can insert a link for the affiliate in the product_info.php:
See it live in action at the site below:
http://www.fabulousite.com/cybershop/product_info.php?products_id=22
If you already install all the features then just add the script below for one easy step.
Otherwise you need to download full pack vesion > 13 Oct 2003 - osCAffiliate v2.02
Install:
catalog/product_info.php
By: Sam Nheik @ www.fabulousite.com
Have any questing feel free to email me at the link below:
http://www.fabulousite.com/cybershop/contact_us.php
FYI |
Howdy |
3 Sep 2004 |
|
No file attached!
Just FYI, there is another issue when you have your shop in a sub folder, such as domain.com/shop
You will need to edit your files accordingly so that the affiliate program knows that you are not installed in the root area.
This is what caused ME the biggest problem.
This mod will fix the problem of banners not showing on your site, I noticed that the image was beeing pulled from a HTTPS address but my store is not a HTTPS its a HTTP not encripted, with a quick mod to the file it now pulls the image from the correct address making your images show. Please remember to back up all files first. I will not be held responsible for any cock-ups!!! Have fun.
Adds the ability to create and manage CATEGORY banners just like PRODUCT banners as Admin to osC Affiliate 2.0xx. Counts clicks and so on.
Affiliates can also build Category links the same as Product links.
Includes a Category number and names pop-up in both admin and catalog for affiliates.
Should be a complete package, follow the instructions in CAT BANNERS README.txt
Nur für Deutsch eine kleine Korrektur der Partner-Signup-eMail:
Datei: /catalog/includes/languages/german/affiliate_signup.php
Suche in Zeile 34
define('MAIL_AFFILIATE_LINK', 'Hierkönnen Sie sich einloggen: <a href="https://sslsites.de/sanoverde.de/affiliate_affiliate.php">Login Sanoverde Partnerprogramm</a>');
und ersetze durch deine Link-Adresse, z.B.
define('MAIL_AFFILIATE_LINK', 'Hierkönnen Sie sich einloggen: <a href="http://IhreDomain.de/catalog/affiliate_affiliate.php">Login IHR Partnerprogramm</a>');
the email sent to the new affiliate will be in a much nicer format and errors are eliminated from the address
German language files re-added
Bugfix to SQL_changelog.txt
Includes missing index.ALT.php file :)
This is a LOADED version of the osCAffiliate module that Henri and Myself have been developing.
This release takes all the issues and bugs raised in the forums discussion at
http://forums.oscommerce.com/index.php?showtopic=28975
It includes numerous new functions and improvements, along with a redesigned affiliate interface.
Details are provided for both upgrades and new installs.
NOTE: This release is built on the osCommerce 2.2 Milestone 2 release and does not support CVS versions. The module will probably work with newer snapshots but no support is given.
For bug reports (THIS RELEASE ONLY) please refer them to my bug tracker at http://bugs.snowtech.com.au
for discussion on the mod take your pick:
http://forums.snowtech.com.au/index.php?board=13;subid=17;subid2=13;subid3=osCommerce Modules
or
http://forums.oscommerce.com/index.php?showtopic=28975
enjoy :)
This is just a quick handy little code mod to display a brief summary of your affiliate program on the index page of the admin.
Only one file needs editing in this mod :)
Displays
Number of Affiliates
Conversion Rate
Commission Paid or due.
Update to the Affiliate Text link making page. Simply overwrite the files with the ones included in the .zip.
BACKUP first though. Author accepts zero responsibility.
THIS MODULE IS AN ADDON DESIGNED FOR THE MILESTONE 1.01 RELEASE OF OSCAFFILIATE.
The module is an addon that expands the affiliate centre and breaks the banners down into four seperate groups:
Banners
Products
Build a Link
Text Links
While this has been developed for the 1.01 release of osCAffiliate it should work on most earlier versions.
If you find this mod helpful feel free to make a donation via PayPal or Paymate to the
"Save The Snowman Foundation" ....(info@snowtech.com.au)
If you find any bugs please report to info@snowtech.com.au - or via the Snowtech Script Development forums at http://forums.snowtech.com.au
Steve Kemp
Snowtech Services
http://www.snowtech.com.au
The mod formerly titled oscaffiliate_mall has been renamed to affiliate_branding and may now be found at:
http://www.oscommerce.com/community/contributions,1188/page,2
Thank you.
Change to affiliate_application_top.php so that the passed "ref" parameter takes precedence over the "affiliate_id" cookie. This fixes the problem where affiliate references were "sticky."
Change to affiliate_application_top.php so that the passed "ref" parameter takes precedence over the "affiliate_id" cookie. This fixes the problem where affiliate references were "sticky."
Fixed typo in includes/modules/also_purchased_products.php
Thanks to henri for pointing it out.
Fixed typo in includes/modules/also_purchased_products.php
Thanks to henri for pointing it out.
This module extends osC Affiliate by
allowing each affiliate to have their
own branded storefront with customizable
header image and inventory.
This module extends osC Affiliate by
allowing each affiliate to have their
own branded storefront with customizable
header image and inventory.
For updates look at:
https://sourceforge.net/projects/oscaffiliate/
VS 1.0 (for MS1)
- it's most likely 100% codingstyle compatible to Milestone 1
- should work with older Snashots
- a lot of bugfixes
- introduced taxes for the affiliate provisions
- changed the affiliate_signup Page (catalog-part) to match OSC-Standard
- added possibility to pay the affiliates by bank, check, paypal (setable in Admin)
- moved some variables to admin
- ... (and i forget to update the changelog file...)
There is an update.txt file in which (i hope all) the database changes are listed. To update execute them via phpmyadmin.
Special thx to Thomas Plänkers from the developer team who looked over the whole code.
If you like it, you find a way to DONATE :wink: at the end of the Readme's
Lets call it working beta.
It's based on Steves Affiliate, and Steve's working with it to improve it.
Check
https://sourceforge.net/projects/oscaffiliate/
for the bewest versions!
Ok you have all been waiting patiently well here it is in all its unfinished glory...
YES IT IS BUGGY....NO ITS NOT FINISHED....NO I DONT RECOMMEND THAT YOU USE IT!!!
Well then why contribute it???
This contribution is a preview release of 2.0 It has been packaged up so that those of you that are skilled and knowledgable can sort out bugs, make suggestions and contributions etc...
IF YOU DONT KNOW MUCH ABOUT PHP I DONT RECCOMMEND YOU USE THIS VERSION...
Once the bugs are ironed out and i finish the admin functions then a nice celan bug free version will be posted.
THANKS TO:
Everyone who has helpded test this module and encouraged me so far...
If you find this mod helpful feel free to make a donation via PayPal to the
"Save The Snowman Foundation" ....(info@snowtech.com.au)
If you find any bugs please report to info@snowtech.com.au - or via the Snowtech Script Development forums at http://forums.snowtech.com.au
This is the completed Alpha release of osC Affiliate 1.0.
Please note that this module is an Alpha, and while it works it does not yet meet the osCommerce standards.
This module has been designed to allow easy future upgrades without impacting to much on the osC core files.
Only partial intergration has been completed at this stage with full intergration and extra features planned for a future release.
For a list of features and things still to be completed please refer to the discussion forums.
Please report any bugs or issues on the forums or at http://forums.snowtech.com.au
Enjoy.
Note: Contributions are used at own risk.