webdeva Posted March 19, 2003 Share Posted March 19, 2003 I can not get this mod to build a link? Wonder what I did wrong. PLease help webdeva Quote Link to comment Share on other sites More sharing options...
Overdog Posted March 19, 2003 Share Posted March 19, 2003 By the by I am the ISP :wink: I have my own Pipe yippie !! and own the servers ! anywayz I did as you requested and you where right that fixed the notice error's I tweaked the PHP.ini ! I am wondering if you would be so kind as to address my previous posts :wink: If you could post the (HOW TO )on changing the the code From (is_upload) to Tep_Copy would be very cool !!! I am new to php and learning so very much ! I am not sure where or what I need to change to get the Banners to upload .. :D ALso I have the same issue as other posts in this thread and I really have not seen a fix posted .. when banner is set to 1 I can see banner and all is well except when I try to link directly to a product using the product ID the image is broken. I looked at the code it generated it looked too me as if it was getting the filename for the pic as the product name and no extension was added to that name . AKA product name brokin image but the file name for the pic = image.jpg :shock: Also when banner set to 2 image broken cannot get this to work :( This is a very cool contrib I really want this to work ! and if you have the time I can hook you up with some free music ! thank so much for this contrib it rocks! Quote Link to comment Share on other sites More sharing options...
henri Posted March 19, 2003 Author Share Posted March 19, 2003 I am wondering if you would be so kind as to address my previous posts :wink: If you could post the (HOW TO )on changing the the code From (is_upload) to Tep_Copy would be very cool !!! I didn't have the time too look at it yet. (It stands on the todo list now) Look at the code (and the code of the OSC-Bannermanager and find out yourself) Also when banner set to 2 image broken cannot get this to work :( This is a very cool contrib I really want this to work ! and if you have the time I can hook you up with some free music ! thank so much for this contrib it rocks! Should be answered a lot of time (here and the faq) activate debug mode, open Bannerlink in a new browserwindow you see a table with debuginfo -> Now you should know whats wrong Fix it, deactivate debugmode Quote Link to comment Share on other sites More sharing options...
Overdog Posted March 19, 2003 Share Posted March 19, 2003 <a href="http://www.overdog.com/product_info.php?ref=3&products_id=66&affiliate_banner_id=1" target="_blank"><img src="http://www.overdog.com/images/" border="0" alt="Saviamantra"></a> no extension and wrong file name .... this is what th url code looks like when I try too link to a product with banner set to 1 the image name for Saviamantra = estrla.jpg :shock: not sure what's up with that also the preview image is broken ... I will do as you requested and agian thanks for your time ! Quote Link to comment Share on other sites More sharing options...
Overdog Posted March 19, 2003 Share Posted March 19, 2003 Do you see anything wrong ? Check the pathes! (catalog/includes/configure.php) absolute path to picture: x:/xxxx/images/testbanner.jpg build with: DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG . DIR_WS_IMAGES . $banner DIR_FS_DOCUMENT_ROOT x:/xxxx DIR_WS_CATALOG / DIR_WS_IMAGES images/ $banner testbanner.jpg SQL-Query used: select affiliate_banners_image, affiliate_products_id from affiliate_banners where affiliate_banners_id = '15' and affiliate_status = 1 Try to find error: SQL-Query: Got Result Locating Pic x:/xxxxx/images/testbanner.jpg success Quote Link to comment Share on other sites More sharing options...
henri Posted March 19, 2003 Author Share Posted March 19, 2003 success means it should work with banner set to 2 (can be a problm with your webserver, the whole thing is tested with Linux Apache only) Quote Link to comment Share on other sites More sharing options...
henri Posted March 19, 2003 Author Share Posted March 19, 2003 I can not get this mod to build a link? Wonder what I did wrong. I don't know ;) Whats going wrong? Quote Link to comment Share on other sites More sharing options...
Overdog Posted March 19, 2003 Share Posted March 19, 2003 just wondering if you have any thoughts on this I am using ISAPI.dll instead of the CGI and its PHP 4.3.1 :? dam windows anyway I must go too the dark side very soon Luke use the force 8) thanks again soon to jion the dark side ! hmm well I guess I could be your test subject for windows yes :D Thanks John Quote Link to comment Share on other sites More sharing options...
valley Posted March 23, 2003 Share Posted March 23, 2003 As you can imagine I am fairly new to this The instruction says MySQL ALTERATIONS Insert the new tables found in the affiliate.sql file into your osCommerce catalog database. Currently phpMyAdmin can: a.. create and drop databases b.. create, copy, drop and alter tables c.. delete, edit and add fields d.. execute any SQL-statement, even batch-queries e.. manage keys on fields f.. load text files into tables g.. create (*) and read dumps of tables h.. export (*) and import data to CSV values i.. administer multiple servers and single databases j.. communicate in more than 20 different languages I had a look and canot figure out how to add my new tables. THe original database was copied by the OScommerce installation routine and there are no menu in the OS admin to add tables to the existing database Could you please let me know how this can be done ? Quote Link to comment Share on other sites More sharing options...
Farrukh Posted March 26, 2003 Share Posted March 26, 2003 Hiya i have found this mod to be extremely useful. Really nice work henri I would like to ask, that does the cookie's lifetime have to be set in Seconds ? Quote Link to comment Share on other sites More sharing options...
kooyan Posted March 26, 2003 Share Posted March 26, 2003 If you would look on the explanation on the right side, this would answer your question, too. Sometimes reading helps a lot :wink: How long does the click count (seconds) if customer comes back. HTH Stefan Quote Link to comment Share on other sites More sharing options...
jeana Posted March 26, 2003 Share Posted March 26, 2003 I've installed and created a tets affiliate member, but cannot login...I type in the login an dpassword and it keeps just refreshing the page when I hit continue. I have made sure that the cookies are turned on, but still no go. Any ideas? I'm sure its something simple I'm just overlooking.... :shock: Quote Link to comment Share on other sites More sharing options...
Guest Posted March 31, 2003 Share Posted March 31, 2003 Ive installed this module but after entering a dummy name and info and wanting to enter or view the availbe banners, no show. please view this yourself for testing propuses. username is [email protected] password is 2131010 my shop url is http://www.urbachshop.ch This is were the image is stored. https://secure.webland.ch/urbachshop/cgi-bi...ages/banner.gif All I want to no if there is any info in this forum about this problem Thanks Steven Quote Link to comment Share on other sites More sharing options...
Paul_w Posted April 2, 2003 Share Posted April 2, 2003 Thanks for this great contribution, I have set it up and am testing now. Everything seems to work ok.... however I have a question, why is tax being added to Affiliate payments? Is there anyway to turn this off? In the UK I can see absolutely no reason why we should add VAT to the affiliate payment? I have my shop set up to add tax to all product prices, is this the reason tax is being added to affiliate payments? Thanks - Paul Quote Link to comment Share on other sites More sharing options...
henri Posted April 3, 2003 Author Share Posted April 3, 2003 Cause you have to? Or are you allowed to write invoices without VAT? From amazon UK: We will pay you referral fees (including VAT, if any, on presentation of a valid VAT invoice) on a quarterly basis. But in admin/affiliate_configure: define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates // you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1 Put this to a 0 tax rate. Quote Link to comment Share on other sites More sharing options...
Paul_w Posted April 3, 2003 Share Posted April 3, 2003 Cause you have to?Or are you allowed to write invoices without VAT? From amazon UK: We will pay you referral fees (including VAT, if any, on presentation of a valid VAT invoice) on a quarterly basis. But in admin/affiliate_configure: define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates // you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1 Put this to a 0 tax rate. Thanks for the reply, I have looked into this properly today, as I just cannot understand why you would pay VAT on a payment to an affiliate. I spoke to the Customs & Excise in the UK and it seems that you only have to pay VAT to an affiliate if they are registered for VAT and can prove that, hence the amazon requirement for a valid VAT invoice. I believe that on my site approx 99% of future affiliates will not be VAT registered and this would probably be the case for most people. So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them. Thanks for the solution provided, however as a suggestion I would say that the best way to implement this in the contribution would be to make the default set-up not apply Tax, and to be able to add VAT/Tax to affiliate payments on an individual basis. Quote Link to comment Share on other sites More sharing options...
Paul_w Posted April 3, 2003 Share Posted April 3, 2003 I have found a small bug in the affiliate_summary file. The conversion percentage for sales to clickthroughs shown is not right, eg: 2 sales and 4 clickthroughs shows a percentage of 0.5%, this should be 50%. To correct this change the following code: if ($affiliate_clickthroughs > 0) { $affiliate_conversions = tep_round($affiliate_transactions / $affiliate_clickthroughs, 6) . "%"; } TO if ($affiliate_clickthroughs > 0) { $affiliate_conversions = tep_round(($affiliate_transactions / $affiliate_clickthroughs)*100, 6) . "%"; } Quote Link to comment Share on other sites More sharing options...
Priest Posted April 4, 2003 Share Posted April 4, 2003 So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them. How do I disable Tax Payments with affiliate payments? I live in New York, USA and I don't understand why we'd pay taxes to the affiliates. :shock: Where does it get the tax information? How much tax would it know to add? I think it's just best I disable this. How? Thanks, Priest Quote Link to comment Share on other sites More sharing options...
Paul_w Posted April 4, 2003 Share Posted April 4, 2003 So I am going to disable Tax payments with affiliate payments. In the eventuality that I have an affiliate that is VAT registered I will have to manually alter the database records for that affiliate to pay VAT to them. How do I disable Tax Payments with affiliate payments? I live in New York, USA and I don't understand why we'd pay taxes to the affiliates. :shock: Henri just explained how to do this a couple of posts back! But in admin/affiliate_configure: define ('AFFILIATE_TAX_ID','1'); // Tax Rates used for billing the affiliates // you get this from the URl (tID) when you select you Tax Rate at the admin: tax_rates.php?tID=1 Put this to a 0 tax rate. Quote Link to comment Share on other sites More sharing options...
Priest Posted April 5, 2003 Share Posted April 5, 2003 define ('AFFILIATE_DELETE_CLICKTHROUGHS','false'); // (days / false) To keep the clickthrough report small you can set the days after which they are deleted (when calling affiliate_summary in the admin) define ('AFFILIATE_DELETE_AFFILIATE_BANNER_HISTORY','false'); // (days / false) To keep the table AFFILIATE_BANNER_HISTORY small you can set the days after which they are deleted (when calling affiliate_summary in the admin) How do I change this then? If I want the reports to be deleted after 30 days, would this be right: define ('AFFILIATE_DELETE_CLICKTHROUGHS','30 / true'); // (days / false) To keep the clickthrough report small you can set the days after which they are deleted (when calling affiliate_summary in the admin) define ('AFFILIATE_DELETE_AFFILIATE_BANNER_HISTORY','30 / true'); // (days / false) To keep the table AFFILIATE_BANNER_HISTORY small you can set the days after which they are deleted (when calling affiliate_summary in the admin) ?? Sorry if this seems like a stupid question. Maybe I'm just not reading this right. Priest Quote Link to comment Share on other sites More sharing options...
envy2000 Posted April 7, 2003 Share Posted April 7, 2003 just did an install of OSC-Affiliate 1.01, and i am getting Warning: Division by zero /includes/functions/html_output.php on line 115 error. help!!!! Quote Link to comment Share on other sites More sharing options...
envy2000 Posted April 7, 2003 Share Posted April 7, 2003 i found the problem. it was a review image that was non existant. it's strange, because i never had a probelem before the install. Quote Link to comment Share on other sites More sharing options...
Priest Posted April 8, 2003 Share Posted April 8, 2003 define ('AFFILIATE_DELETE_CLICKTHROUGHS','false'); // (days / false) To keep the clickthrough report small you can set the days after which they are deleted (when calling affiliate_summary in the admin) define ('AFFILIATE_DELETE_AFFILIATE_BANNER_HISTORY','false'); // (days / false) To keep the table AFFILIATE_BANNER_HISTORY small you can set the days after which they are deleted (when calling affiliate_summary in the admin) How do I change this then? If I want the reports to be deleted after 30 days, would this be right: define ('AFFILIATE_DELETE_CLICKTHROUGHS','30 / true'); // (days / false) To keep the clickthrough report small you can set the days after which they are deleted (when calling affiliate_summary in the admin) define ('AFFILIATE_DELETE_AFFILIATE_BANNER_HISTORY','30 / true'); // (days / false) To keep the table AFFILIATE_BANNER_HISTORY small you can set the days after which they are deleted (when calling affiliate_summary in the admin) Ok, obvisouly that didn't work. What is the correct code for wanting these reports to delete after 30 days? Quote Link to comment Share on other sites More sharing options...
Theodorb Posted April 8, 2003 Share Posted April 8, 2003 I am wondering if there is a way to turn the affliate program into a multi-level affiliate program where affiliates who signup other affiliates get a percentage of their secondary affiliates sales?? TY Theo. Quote Share your knowlege and you learn even more ! Link to comment Share on other sites More sharing options...
henri Posted April 8, 2003 Author Share Posted April 8, 2003 define ('AFFILIATE_DELETE_CLICKTHROUGHS','30'); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.