Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

oscanta

Archived
  • Posts

    8
  • Joined

  • Last visited

Everything posted by oscanta

  1. Good morning, everyone! I'm using Osc Affiliate but both side by side admin client that the counting of clicks each franchisee is done by counting the clicks coming from the clicks by the staff of both the robot. I think "more just" the counting of clicks coming from the just the franchisee. xxxxxxxxxxxx 10/11/2008 Startpage Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2) xx.x.114.173 http://www.xxxxxxxxxxxxxxxxx.com/ xxxxxxxxxxxx10/11/2008 Startpage Mozilla/5.0 (compatible; ScoutJet; http://www.scoutjet.com/ +) xx.xxx.180.132 xxxxxxxxxxx 09/11/2008 Startpage Mozilla/5.0 (compatible; Googlebot/2.1; + http://www.google.com/bot.html) xx.xxx.71.4 I think, from my ignorance that the solution can be found doing count only those with the franchisee url Someone has already solved this problem? If you like? The text was translated automatically because I do not know the English language and I do not know even if long after the argument has already been treated.
  2. Carryover afloat this post just to see if anyone uses osc affiliates, and if no one uses it? If you used the counting of total clicks (robot + url affiliate) rather than only those coming from the dell'affiato not a problem? Thank you for any answers Translated text automatically
  3. Good morning, everyone! I'm using Osc Affiliate but both side by side admin client that the counting of clicks each franchisee is done by counting the clicks coming from the clicks by the staff of both the robot. I think "more just" the counting of clicks coming from the just the franchisee. xxxxxxxxxxxx 10/11/2008 Startpage Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.2) xx.x.114.173 http://www.xxxxxxxxxxxxxxxxx.com/ xxxxxxxxxxxx10/11/2008 Startpage Mozilla/5.0 (compatible; ScoutJet; http://www.scoutjet.com/ +) xx.xxx.180.132 xxxxxxxxxxx 09/11/2008 Startpage Mozilla/5.0 (compatible; Googlebot/2.1; + http://www.google.com/bot.html) xx.xxx.71.4 I think, from my ignorance that the solution can be found doing count only those with the franchisee url Someone has already solved this problem? If you like? I attach the code file admin / affiliate_clicks.php and thank you for any "suggestions" Translated text automatically <?php /* $Id: affiliate_clicks.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 ($HTTP_GET_VARS['acID'] > 0) { $affiliate_clickthroughs_raw = "select ac.*, pd.products_name, a.affiliate_firstname, a.affiliate_lastname from " . TABLE_AFFILIATE_CLICKTHROUGHS . " ac left join " . TABLE_PRODUCTS . " p on (p.products_id = ac.affiliate_products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on (pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "') left join " . TABLE_AFFILIATE . " a on (a.affiliate_id = ac.affiliate_id) where a.affiliate_id = '" . $HTTP_GET_VARS['acID'] . "' ORDER BY ac.affiliate_clientdate desc"; // "select * from " . TABLE_AFFILIATE_CLICKTHROUGHS . " where affiliate_id ='" . $HTTP_GET_VARS['acID'] . "' order by date desc"; $affiliate_clickthroughs_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $affiliate_clickthroughs_raw, $affiliate_clickthroughs_numrows); } else { $affiliate_clickthroughs_raw = "select ac.*, pd.products_name, a.affiliate_firstname, a.affiliate_lastname from " . TABLE_AFFILIATE_CLICKTHROUGHS . " ac left join " . TABLE_PRODUCTS . " p on (p.products_id = ac.affiliate_products_id) left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on (pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "') left join " . TABLE_AFFILIATE . " a on (a.affiliate_id = ac.affiliate_id) ORDER BY ac.affiliate_clientdate desc"; $affiliate_clickthroughs_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $affiliate_clickthroughs_raw, $affiliate_clickthroughs_numrows); } ?> <!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; ?>"> <title><?php echo TITLE; ?></title> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="2" cellpadding="2"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> <!-- 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="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> <?php if ($HTTP_GET_VARS['acID'] > 0) { ?> <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_AFFILIATE_STATISTICS, tep_get_all_get_params(array('action'))) . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> <?php } else { ?> <td class="pageHeading" align="right"><?php echo '<a href="' . tep_href_link(FILENAME_AFFILIATE_SUMMARY, '') . '">' . tep_image_button('button_back.gif', IMAGE_BACK) . '</a>'; ?></td> <?php } ?> </tr> </table></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_AFFILIATE_USERNAME .'/<br>' . TABLE_HEADING_IPADDRESS; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_ENTRY_DATE .'/<br>' . TABLE_HEADING_REFERRAL_URL; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CLICKED_PRODUCT; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_BROWSER; ?></td> </tr> <?php if ($affiliate_clickthroughs_numrows > 0) { $affiliate_clickthroughs_values = tep_db_query($affiliate_clickthroughs_raw); $number_of_clickthroughs = '0'; while ($affiliate_clickthroughs = tep_db_fetch_array($affiliate_clickthroughs_values)) { $number_of_clickthroughs++; if ( ($number_of_clickthroughs / 2) == floor($number_of_clickthroughs / 2) ) { echo ' <tr class="productListing-even">'; } else { echo ' <tr class="productListing-odd">'; } ?> <td class="dataTableContent"><?php echo $affiliate_clickthroughs['affiliate_firstname'] . " " . $affiliate_clickthroughs['affiliate_lastname']; ?></td> <td class="dataTableContent" align="center"><?php echo tep_date_short($affiliate_clickthroughs['affiliate_clientdate']); ?></td> <?php if ($affiliate_clickthroughs['affiliate_products_id'] > 0) $link_to = '<a href="' . tep_catalog_href_link(FILENAME_CATALOG_PRODUCT_INFO, 'products_id=' . $affiliate_clickthroughs['affiliate_products_id']) . '" target="_blank">' . $affiliate_clickthroughs['products_name'] . '</a>'; else $link_to = "Startpage"; ?> <td class="dataTableContent"><?php echo $link_to; ?></td> <td class="dataTableContent" align="center"><?php echo $affiliate_clickthroughs['affiliate_clientbrowser']; ?></td> </tr> <tr> <td class="dataTableContent"><?php echo $affiliate_clickthroughs['affiliate_clientip']; ?></td> <td class="dataTableContent" colspan="3"><?php echo $affiliate_clickthroughs['affiliate_clientreferer']; ?></td> </tr> <tr> <td class="dataTableContent" colspan="4"><?php echo tep_draw_separator('pixel_black.gif', '100%', '1'); ?></td> </tr> <?php } } else { ?> <tr class="productListing-odd"> <td colspan="7" class="smallText"><?php echo TEXT_NO_CLICKS; ?></td> </tr> <?php } ?> <tr> <td class="smallText" colspan="7"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $affiliate_clickthroughs_split->display_count($affiliate_clickthroughs_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_CLICKS); ?></td> <td class="smallText" align="right"><?php echo $affiliate_clickthroughs_split->display_links($affiliate_clickthroughs_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page'], tep_get_all_get_params(array('page', 'oID', 'action'))); ?></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> </tr> </table></td> <!-- body_text_eof //--> </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');?>
  4. How to modify this query for MySql 5? $print_catalog_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.". PDF_ALT_IMAGE .", p.products_model, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, s.expires_date, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = '" . $products_id . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'");
  5. I have installed PDF data-sheet maker with Mysql 5 it show an error 1054 - Unknown column 'p.products_id' in 'on clause'select p.products_id, pd.products_name, pd.products_description, p.products_image, p.products_model, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.products_status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, s.expires_date, m.manufacturers_name from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id where p.products_id = '' and p.products_id = pd.products_id and pd.language_id = '4'[TEP STOP]--------------------------------------- Help me
×
×
  • Create New...