Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

trstone

Archived
  • Posts

    7
  • Joined

  • Last visited

Posts posted by trstone

  1. Hello everyone,

     

    I have been attempting to install this module and seem to be stuck. I have installed the latest core shopping cart. I then went through the entire osC Affiliate contribution page and discovered that v2.8 was the last fully updated version of this module and started installing it according to the instruction in the INSTALL_ENG.txt file within the zipped download. I got down to the following part before I got stuck:

     

     

    #######################################################################
    ###########################################
    
    
    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();
    
    
    In index.php in the admin directory find line 50 approx
    
    array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))),
    
    and on a new line add the following code after it:
    
                  array('title' => BOX_HEADING_AFFILIATE,
                        'image' => 'affiliate.gif',
                        'href' => tep_href_link(FILENAME_AFFILIATE_SUMMARY, 'selected_box=affiliate'),
                        'children' => array(array('title' => BOX_AFFILIATE, 'link' => tep_href_link(FILENAME_AFFILIATE, 'selected_box=affiliate')),
                                            array('title' => BOX_AFFILIATE_BANNERS, 'link' => tep_href_link(FILENAME_AFFILIATE_BANNERS, 'selected_box=affiliate')))),
    
    
    In index.php in the admin directory find line 106 approx
    
                   <td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2">
    
    
    and replace that line with the following code :
    
                   <td width="160" valign="top"><table border="0" width="160" height="390" cellspacing="0" cellpadding="2">
    
    
    
    In index.php in the admin directory find lines 167 to 173 approx
    
     $contents[] = array('params' => 'class="infoBox"',
                         'text'  => BOX_ENTRY_CUSTOMERS . ' ' . $customers['count'] . '<br>' .
                                    BOX_ENTRY_PRODUCTS . ' ' . $products['count'] . '<br>' .
                                    BOX_ENTRY_REVIEWS . ' ' . $reviews['count']);
    
     $box = new box;
     echo $box->menuBox($heading, $contents);
    
     echo '<br>';
    
    and on a new line add the following code after it:
    
    
    $affiliate_sales_raw = "select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from " . TABLE_AFFILIATE_SALES . " ";
    $affiliate_sales_query= tep_db_query($affiliate_sales_raw);
    $affiliate_sales= tep_db_fetch_array($affiliate_sales_query);
    
    $affiliate_clickthroughs_raw = "select count(*) as count from " . TABLE_AFFILIATE_CLICKTHROUGHS . " ";
    $affiliate_clickthroughs_query=tep_db_query($affiliate_clickthroughs_raw);
    $affiliate_clickthroughs= tep_db_fetch_array($affiliate_clickthroughs_query);
    $affiliate_clickthroughs=$affiliate_clickthroughs['count'];
    
    $affiliate_transactions=$affiliate_sales['count'];
    if ($affiliate_transactions>0) {
    $affiliate_conversions = tep_round($affiliate_transactions/$affiliate_clickthroughs,6)."%";
    }
    else $affiliate_conversions="n/a";
    
    $affiliate_amount=$affiliate_sales['total'];
    if ($affiliate_transactions>0) {
    $affiliate_average=tep_round($affiliate_amount/$affiliate_transactions,2);
    }
    else {
    $affiliate_average="n/a";
    }
    $affiliate_commission=$affiliate_sales['payment'];
    
    $affiliates_raw = "select count(*) as count from " . TABLE_AFFILIATE . "";
    $affiliates_raw_query=tep_db_query($affiliates_raw);
    $affiliates_raw = tep_db_fetch_array($affiliates_raw_query);
    $affiliate_number= $affiliates_raw['count'];
    
    
     $heading = array();
     $contents = array();
    
     $heading[] = array('params' => 'class="menuBoxHeading"',
                        'text'  => BOX_TITLE_AFFILIATES);
    
     $contents[] = array('params' => 'class="infoBox"',
                         'text'  => BOX_ENTRY_AFFILIATES . ' ' . $affiliate_number . '<br>' .
                                    BOX_ENTRY_CONVERSION . ' ' . $affiliate_conversions . '<br>' .
                                    BOX_ENTRY_COMMISSION . ' ' . $currencies->display_price($affiliate_commission, ''));
    
     $box = new box;
     echo $box->menuBox($heading, $contents);
    
     echo '<br>';
    
    ################################################################################
    ##################################

     

     

     

    You see the index.php file on and/or around line 50 doesn't have the following code:

    -------

    array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))),

    -------

     

    on and/or around line 106 doesn't have the following code:

    -------

    <td width="140" valign="top"><table border="0" width="140" height="390" cellspacing="0" cellpadding="2">

    -------

     

    and lines 167 to 173 could not be part of this file because index.php only has 125 lines of code.

     

    So if someone would please advise me on what to do about this challenge and advise me on how to finish installing this module it would be greatly appreciated.

     

    Thank you,

    Tom

×
×
  • Create New...