Guest Posted April 9, 2005 Share Posted April 9, 2005 Has anyone else received this error when signing up for affiliate program??? Any help would be greatly appreciated. 1044 - Access denied for user: 'mydomain_p_os1@localhost' to database 'mydomain_p_os1' LOCK TABLES affiliate_affiliate WRITE Thanks Group One Sales Muddparts.com Quote Link to comment Share on other sites More sharing options...
henri Posted April 10, 2005 Author Share Posted April 10, 2005 read the thread... Quote Link to comment Share on other sites More sharing options...
MR.T Posted April 11, 2005 Share Posted April 11, 2005 (edited) Hi Thanks for a great contribution. :thumbsup: I have now read through all the pages in this thread :sweating:, but I did't find any answers to the following questions: Recuring Sales: Will the affiliate system count recuring sales in the durationtime of the cookie? If not - this would be a nice adon to the settings. Accept all urls: It seems like the clicks only counts for clicks coming from the registered url by the affiliate. It would be nice to override this on individual basis so that some affiliates could work on a broader perspective with the affiliate system. For instance also having affiliatelinks in Newsletters, en Emails and when buying keywords at Google. Adding more urls: Could it be possible to let the affiliate add more urls than just one? Countig Sales from not registered urls: If a click comes from an url not registered by an affiliate - does the sale show up at the given affiliate account, and will he get the comission? Sug : Rotation between all GEs of same size It would be nice to have a function for setting up a rotation for all GEs (Graphical Elements) with the same size. Ther should then be an extra field to fill in on each banner (size), and the the affiliate could choose the size and have a rotation. Textlink - a more easy way to create: It would be nice if it was easier to add textlinks for the affiliate. It should be an opportunity to add their own words, like for instance PC, and then genereate the textlink. Prob: Just adding ?ref=x will not work For instance http://www.divestore.com/specials.php?ref=6 will not show up as a click, but maybe that has to do with refering url. How to specify specific rates for specific products I saw a question earlyer in this thread about this, but I did not find the answer. With or without www Does the system care if the affiliate registeres for instance www.vg.no and the click comes from vg.no. If this is not a problem then great, but if it is a problem, then a solution is the sugestion above regarding more urls pr affiliate or the ability to completely disable the urlcheck for some affiliates (or all of them). Showing comision with decimals How can I set up the system to show the comission with 2 decimals. Now it doesn't show decimals at all. Email when new affiliate registeres: Another suggestion I found earlyer in this thread. Have this been set up yet? It would be great to have. Again - thanks for a great contribution. :wub: /MR.T Edit : misspellings Edited April 11, 2005 by MR.T Quote Link to comment Share on other sites More sharing options...
henri Posted April 12, 2005 Author Share Posted April 12, 2005 To alle questions yes, except: Sug : Rotation between all GEs of same sizeIt would be nice to have a function for setting up a rotation for all GEs (Graphical Elements) with the same size. Ther should then be an extra field to fill in on each banner (size), and the the affiliate could choose the size and have a rotation. Nice idea, not done yet. Textlink - a more easy way to create:Prob: Just adding ?ref=x will not work ref= should work, ALL links with ref= are counted. If you want other textlinks just build them. How to specify specific rates for specific productsI saw a question earlyer in this thread about this, but I did not find the answer. I haven't implemented this yet. Would increase the difficulty of the setup of the contri. And as a lot of people have problems with the simple setup, just forget it for now. How to do it: add a affiliate commision field to the products, get this field into the products array in the classes shopping_cart and orders. -> then you can use it in affiliate_checkout_process to use you calculation. Email when new affiliate registeres: Shouldn't be a problem to add a tep_mail function to the signup page ;) Quote Link to comment Share on other sites More sharing options...
Dhananjaya Posted April 12, 2005 Share Posted April 12, 2005 In the installation instructions (INSTALL_ENG.TXT) for osCAffiliate v2.02 the following is given: ADMIN ALTERATIONS In index.php in the admin directory find line 13 approx require('includes/application_top.php'); and on a new line add the following code after it: require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); I'm no expert so it may be that this makes total sense but it just doesn't seem right to me so I thought I would post it and ask: Is this right? Anyway it hasn't caused anything to not work yet as far as I know. Quote I have moved on from oscommerce to magento and no longer monitoring this site. Link to comment Share on other sites More sharing options...
MR.T Posted April 12, 2005 Share Posted April 12, 2005 Hi again Henri Thanks for a swift answer. Just to clarify (since you said yes to all questions exept the one you comented ;)) : Does it only count click for the registered url? How can I override the url check for specific affiliates? How can the affiliate add more than one url? How do I set up the comission to be shown with 2 decimals? /MR.T Quote Link to comment Share on other sites More sharing options...
SnyderHealth Posted April 12, 2005 Share Posted April 12, 2005 Recuring Sales:Will the affiliate system count recuring sales in the durationtime of the cookie? If not - this would be a nice adon to the settings. When someone hits your site with their proper ref code, a cookie will be placed on their computer which expires after the duration you set in the admin panel. So, if you have a cookie duration of two weeks, the cookie will have an expiry date of two weeks, causing any return to your store to credit the aff ref that placed the cookie for that customer. Accept all urls:It seems like the clicks only counts for clicks coming from the registered url by the affiliate. It would be nice to override this on individual basis so that some affiliates could work on a broader perspective with the affiliate system. For instance also having affiliatelinks in Newsletters, en Emails and when buying keywords at Google. It does not matter where the inbound link comes from. This has nothing to do with the affiliate registered url. Technically, an affiliate doesn't even need a web site, if they can place their coded links on forums, e-mails, or PPC ads. (I would advise against allowing affiliates to take out PPC ads linking to your site... they would then be competing with you for customers that you might have gotten anyway on your own). Adding more urls:Could it be possible to let the affiliate add more urls than just one? Irrelevant... see above. Countig Sales from not registered urls:If a click comes from an url not registered by an affiliate - does the sale show up at the given affiliate account, and will he get the comission? ANY inbound links to your site with the proper ref code will trigger a cookie to be created on that visitors computer with your ref # and the cookie duration (set by you in the admin panel). It does not matter from where the visitor came from, as long as the address they arrived to your site at contains an affiliate ref code. Sug : Rotation between all GEs of same sizeIt would be nice to have a function for setting up a rotation for all GEs (Graphical Elements) with the same size. Ther should then be an extra field to fill in on each banner (size), and the the affiliate could choose the size and have a rotation.[/b] This can be done with a small java script that uses the RANDOM function, which can be placed on the affiliates site. But, this is something that most people wouldn't understand, nor know how to implement. On my main site (SnyderHealth.com) I have several things that randomly rotate (using JS functions), so that every time your refresh the main page you get different stuff. Textlink - a more easy way to create:It would be nice if it was easier to add textlinks for the affiliate. It should be an opportunity to add their own words, like for instance PC, and then genereate the textlink. It is assumed that ANYONE having their own web site has an inkling of knowledge on how to utilize the text links created by your shop. They can use their own images, their own words, their own text to hyperlink back to your page, etc. It doesn't matter what element brings them to your site, as long as their ref code is in their hyperlink. You can't spen your time teaching others on how to make a web site. :blink: How to specify specific rates for specific productsI saw a question earlyer in this thread about this, but I did not find the answer. Cannot be done with this contribution as it is. With or without wwwDoes the system care if the affiliate registeres for instance www.vg.no and the click comes from vg.no. If this is not a problem then great, but if it is a problem, then a solution is the sugestion above regarding more urls pr affiliate or the ability to completely disable the urlcheck for some affiliates (or all of them). Does not matter where the link comes from. You have repeated this question several times already. See above. Showing comision with decimalsHow can I set up the system to show the comission with 2 decimals. Now it doesn't show decimals at all. Whaddya mean? Email when new affiliate registeres:Another suggestion I found earlyer in this thread. Have this been set up yet? It would be great to have. This contribution DOES e-mail the new affiliates when they register. The text for this e-mail can be found in catalog/includes/languages/english/affiliate_signup.php Have fun. This is a GREAT contribution. Not only will it hopefully generate more sales for you, but it also will generate more backwards links to your site (hopefully bumping up your page rank as well) Quote Link to comment Share on other sites More sharing options...
MR.T Posted April 12, 2005 Share Posted April 12, 2005 Thanks for clearing up my questions ;) I have integrated this contribution: http://www.oscommerce.com/community/contri...infobox+outside If you look at http://www.dykkesiden.com/forum you will see it working up in the right corner. I would like to have this infobox outside to be used by the affiliates. I use the following iframe to call it outside of OSC: <iframe src=http://www.divestore.com/infobox_outside.php width="140" height="480" frameborder="0">Din nettleser st?tter ikke Iframe</iframe> Is it enough to change the Iframe to: <iframe src=http://www.divestore.com/infobox_outside.php?ref=1 width="140" height="480" frameborder="0">Din nettleser st?tter ikke Iframe</iframe> /MR.T Quote Link to comment Share on other sites More sharing options...
craiglove Posted April 13, 2005 Share Posted April 13, 2005 All the rest seems to be just the Category Banners Add-On and all its bug fixes. Oh, and a few language files additions. <{POST_SNAPBACK}> Gidday guys, I have just installed 2.03 version hoping to fix the banner problem. the link with the affiliate shows up and when clicked goes to the correct place. the picture give the "X" as if the URL is incorrect. help much appreciated. Craig Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted April 13, 2005 Share Posted April 13, 2005 Email when new affiliate registers: Another suggestion I found earlier in this thread. Have this been set up yet? It would be great to have. MEANING, it will e-mail the ADMIN, not just the new affiliate when they sign up. This way, the Admin will know when they have new sign ups. Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
craiglove Posted April 13, 2005 Share Posted April 13, 2005 Hi popthetop, This is what i was meaning with the "X" banner images not showing up (images attached) not sure if its a file or database thing? Quote Link to comment Share on other sites More sharing options...
Guest Posted April 17, 2005 Share Posted April 17, 2005 Go to http://www.popthetop.com/catalog/index.php - I have v2.03 installed. <{POST_SNAPBACK}> Scott: Love the site. What did you use to change left column to arrows and not drop down menu? I also use 2.03 and am having some problems if you want to message me i would appreciate that. [email protected] Quote Link to comment Share on other sites More sharing options...
PopTheTop Posted April 18, 2005 Share Posted April 18, 2005 (edited) Scott: Love the site. What did you use to change left column to arrows and not drop down menu? I also use 2.03 and am having some problems if you want to message me i would appreciate that. [email protected] <{POST_SNAPBACK}> 1st off, get read for some heave SPAM in the near future for posting your e-mail address in the forums. You should never do that. 2nd, I use Admin DHTML Menus V2.0 for the Admin side from http://www.oscommerce.com/community/contributions,1140 and New DHTML Categories Menu v1.11 from http://www.oscommerce.com/community/contributions,2844 Edited April 18, 2005 by PopTheTop Quote L8r, PopTheTop Published osC Contributions: - eCheck Payment Module v3.1 - Reviews in Product Display v2.0 - Fancier Invoice & Packingslip v6.1 - Admin Notes / Customer Notes v2.2 - Customer Zip & State Validation v2.2 - Search Box with Dropdown Category Menu v1.0 Pop your camper's top today! It's a popup thing... You wouldn't understand Link to comment Share on other sites More sharing options...
MikeOz Posted April 20, 2005 Share Posted April 20, 2005 Hello all, I have read many reports of error 1064 but none seem to reflect my exact error, it is as follows: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1 select p.* , s.affiliate_payment_status_name from affiliate_payment p , affiliate_payment_status s where s.affiliate_payment_status_id = '0' and p.affiliate_payment_status = s.affiliate_payment_status_id and s.affiliate_language_id = '1' order by p.affiliate_payment_id DESC limit -20, 20 Just wondering if anyone can suggest a fix. Thanks, MikeOz Quote Link to comment Share on other sites More sharing options...
Rob123 Posted April 20, 2005 Share Posted April 20, 2005 Hello all, I have read many reports of error 1064 but none seem to reflect my exact error, it is as follows: Just wondering if anyone can suggest a fix. Thanks, MikeOz <{POST_SNAPBACK}> This is an issue that is not directly related to this contribution. The solution is within the link below. http://www.oscommerce.com/community/bugs,1605 Robert Quote Link to comment Share on other sites More sharing options...
mondeo79 Posted April 22, 2005 Share Posted April 22, 2005 I have been having problems with the OSC affiliate contribution where it was registering affiliate clicks but not sales. I have now managed to isolate the problem to being caused only when the payment method is NoChex - I have set up a temporary version of my site and if the payment is COD or cheque etc then the sale registers against the affiliate properly but if its NoChex it doesnt! The sale goes through ok but it never shows up on the affiliate sales report. Is anyone who is using the affiliate contribution and NoChex able to help? At the moment I am getting clicks from affiliates but they arent getting recognised for the sales which may be a good thing short term but it MUST be sorted otherwise I will lose them! Thanks Jay Quote Link to comment Share on other sites More sharing options...
craiglove Posted April 22, 2005 Share Posted April 22, 2005 Hi Jason, Yes there are a few bugs with OSC_Affiliate.. just wondering if someone can share there working version with OScommerce 2.2, most versions are under 2.0 or 1.9 etc.. im still getting banner issues, Quote Link to comment Share on other sites More sharing options...
MikeOz Posted April 23, 2005 Share Posted April 23, 2005 Thanx Robert! Quote Link to comment Share on other sites More sharing options...
kingbono Posted May 3, 2005 Share Posted May 3, 2005 I have been using this contrib to show the profitability of the marketing I am doing...newsletters/keywords/link echchange, etc. It works rather well. I want to create one affilate per campaign, lets say google, and then use the banner_id to list the keywords? I don't want to set up a new affilate for each new word. Any ideas for a quick mod to make this or the same results happen? Quote Link to comment Share on other sites More sharing options...
henri Posted May 3, 2005 Author Share Posted May 3, 2005 Should work with the banner_id. The script doesn't checks if the banner exists. So if you made a list: banner_id - keyword 100001 keyword1 100002 keyword2 and then give google links with ref and affiliate_banner_id it should fill the database. For a complete online solution you have to code some more scripts. Quote Link to comment Share on other sites More sharing options...
Hobbes_TheReal Posted May 5, 2005 Share Posted May 5, 2005 Hello together :) i have installed 2.03 and all fixes for today. all works fine solong, but one add on makes me trouble. 10 Sep 2004 - update to multilingual news Author: Nejat Philip Eryigit I have installed this, and when i look at the affiliate_news.php im now only see this :( 1054 - Unknown column 'status' in 'where clause' SELECT * from affiliate_news WHERE status = 1 ORDER BY date_added DESC LIMIT 5 [TEP STOP] Who i can fix that problem, and can anyone tell me, we i have setup the configure files for that add on ? Greets and thanks in advance Hobbes Quote Link to comment Share on other sites More sharing options...
craiglove Posted May 5, 2005 Share Posted May 5, 2005 Hello together :) i have installed 2.03 and all fixes for today. all works fine solong, but one add on makes me trouble. 10 Sep 2004 - update to multilingual news Author: Nejat Philip Eryigit I have installed this, and when i look at the affiliate_news.php im now only see this :( 1054 - Unknown column 'status' in 'where clause' SELECT * from affiliate_news WHERE status = 1 ORDER BY date_added DESC LIMIT 5 [TEP STOP] Who i can fix that problem, and can anyone tell me, we i have setup the configure files for that add on ? Greets and thanks in advance Hobbes <{POST_SNAPBACK}> Thats probley because there is nothing to sort, instert a new item...ie: Welcome:: Please check regually for here for the latest news: PS: are your banner images working? Quote Link to comment Share on other sites More sharing options...
Hobbes_TheReal Posted May 5, 2005 Share Posted May 5, 2005 Thanks for answering :) i have found the error, i have missed one file, now all ok :) But can anyone post instructions for the 2 configure files ? I dunno what i have to do with that :( Cheers Hobbes Quote Link to comment Share on other sites More sharing options...
Hobbes_TheReal Posted May 5, 2005 Share Posted May 5, 2005 (edited) Btw, have anyone the files in his affiliates programm : affiliate_help19 - 20 - 21.php ? I have look over any zip?s now, bot not that files i found into :( Cheers Hobbes Edited May 5, 2005 by Hobbes_TheReal Quote Link to comment Share on other sites More sharing options...
Hobbes_TheReal Posted May 6, 2005 Share Posted May 6, 2005 Hello all, :) have anyone the build cat banner installed on his shop ? i have the problem, that when i create a banner for a cat, i don?t see the image for :( here the code from the affiliates_banners_build_cat.php <?php /* $Id: affiliate_banners_build.php,v 2.00 2003/10/12 OSC-Affiliate Contribution based on: osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 - 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); if (!tep_session_is_registered('affiliate_id')) { $navigation->set_snapshot(); tep_redirect(tep_href_link(FILENAME_AFFILIATE, '', 'SSL')); } require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_AFFILIATE_BANNERS_BUILD_CAT); $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD_CAT)); $affiliate_banners_values = tep_db_query("select * from " . TABLE_AFFILIATE_BANNERS . " order by affiliate_banners_title"); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <?php // BOF: WebMakers.com Changed: Header Tag Controller v1.0 if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) { require(DIR_WS_INCLUDES . 'header_tags.php'); } else { ?> <title><?php echo TITLE; ?></title> <?php } if (DISPLAY_DHTML_MENU == 'CoolMenu') { echo '<script LANGUAGE="JavaScript1.2" SRC="includes/coolMenu.js"></SCRIPT>'; } // EOF: WebMakers.com Changed: Header Tag Controller v1.0 ?> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,re sizable=yes,copyhistory=no,width=600,height=300,screenX=150,screenY=150,top=150,l eft=150') } //--></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <?php if (DISPLAY_DHTML_MENU == 'CoolMenu') { require(DIR_WS_INCLUDES . 'coolmenu.php'); } ?> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" height="28" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td align="right"><?php echo tep_image(DIR_WS_IMAGES . 'affiliate_links.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> <tr> <td colspan=2 class="main"><?php echo TEXT_INFORMATION; ?></td> </tr> </table> </td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table width="95%" align="center" border="0" cellpadding="4" cellspacing="0"><td> <tr> <td class="infoBoxHeading" align="center"><?php echo TEXT_AFFILIATE_INDIVIDUAL_BANNER . ' ' . $affiliate_banners['affiliate_banners_title']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="smallText" align="center"><?php echo TEXT_AFFILIATE_INDIVIDUAL_BANNER_INFO . tep_draw_form('individual_banner', tep_href_link(FILENAME_AFFILIATE_BANNERS_BUILD_CAT) ) . "\n" . tep_draw_input_field('individual_banner_id', '', 'size="5"') . " " . tep_image_submit('button_affiliate_build_a_link.gif', IMAGE_BUTTON_BUILD_A_LINK); ?></form></td> </tr> <tr> <td class="smallText" align="center"><?php echo '<a href="javascript:popupWindow(\'' . tep_href_link(FILENAME_AFFILIATE_VALIDCATS) . '\')"><b>' . TEXT_AFFILIATE_VALIDPRODUCTS . '</b></a>'; ?> <?php echo TEXT_AFFILIATE_INDIVIDUAL_BANNER_VIEW;?><br><?php echo TEXT_AFFILIATE_INDIVIDUAL_BANNER_HELP;?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php if (tep_not_null($HTTP_POST_VARS['individual_banner_id']) || tep_not_null($HTTP_GET_VARS['individual_banner_id'])) { if (tep_not_null($HTTP_POST_VARS['individual_banner_id'])) $individual_banner_id = $HTTP_POST_VARS['individual_banner_id']; if ($HTTP_GET_VARS['individual_banner_id']) $individual_banner_id = $HTTP_GET_VARS['individual_banner_id']; $affiliate_pbanners_values = tep_db_query("select c.categories_image, cd.categories_name from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . $individual_banner_id . "' and cd.categories_id = '" . $individual_banner_id . "' and cd.language_id = '" . $languages_id . "'"); if ($affiliate_pbanners = tep_db_fetch_array($affiliate_pbanners_values)) { switch (AFFILIATE_KIND_OF_BANNERS) { case 1: $link = '<a href="' . HTTPS_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank"><img src="' . HTTPS_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $affiliate_pbanners['affiliate_banners_image'] . '" border="0" alt="' . $affiliate_pbanners['categories_name'] . '"></a>'; $link1 = '<a href="' . HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank"><img src="' . HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . $affiliate_pbanners['affiliate_banners_image'] . '" border="0" alt="' . $affiliate_pbanners['categories_name'] . '"></a>'; $link2 = '<a href="' . HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank">' . $affiliate_pbanners['categories_name'] . '</a>'; break; case 2: // Link to Products $link = '<a href="' . HTTPS_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank"><img src="' . HTTPS_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_SHOW_BANNER . '?ref=' . $affiliate_id . '&affiliate_pbanner_id=' . $individual_banner_id . '" border="0" alt="' . $affiliate_pbanners['categories_name'] . '"></a>'; $link1 = '<a href="' . HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank"><img src="' . HTTP_SERVER . DIR_WS_CATALOG . FILENAME_AFFILIATE_SHOW_BANNER . '?ref=' . $affiliate_id . '&affiliate_pbanner_id=' . $individual_banner_id . '" border="0" alt="' . $affiliate_pbanners['categories_name'] . '"></a>'; $link2 = '<a href="' . HTTP_SERVER . DIR_WS_HTTP_CATALOG . FILENAME_DEFAULT . '?cPath=' . $individual_banner_id . '&ref=' . $affiliate_id . '&affiliate_banner_id=1" target="_blank">' . $affiliate_pbanners['categories_name'] . '</a>'; break; } } ?> <tr> <td><table width="100%" align="center" border="0" cellpadding="4" cellspacing="0" class="infoBoxContents"> <tr> <td class="infoBoxHeading" align="center"><?php echo TEXT_AFFILIATE_NAME; ?> <?php echo $affiliate_pbanners['categories_name']; ?></td> </tr> <tr> <td class="smallText" align="center"><?php echo $link; ?></td> </tr> <tr> <td class="smallText" align="center"><?php echo TEXT_AFFILIATE_INFO; ?></td> </tr> <tr> <td class="smallText" align="center"> <textarea cols="60" rows="4" class="boxText"><?php echo $link1; ?></textarea> </td> </tr> <tr> <td> <td> </tr> <tr> <td class="smallText" align="center"><b>Text Version:</b> <?php echo $link2; ?></td> </tr> <tr> <td class="smallText" align="center"><?php echo TEXT_AFFILIATE_INFO; ?></td> </tr> <tr> <td class="smallText" align="center"> <textarea cols="60" rows="3" class="boxText"><?php echo $link2; ?></textarea> </td> </tr> </table> <?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?> <?php } ?> </td></tr> </td> </tr></table> </td> </tr> </table></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> I hope anyone can help me.. Thanks in advance Hobbes 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.