Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

shaggydog97

Archived
  • Posts

    9
  • Joined

  • Last visited

Posts posted by shaggydog97

  1. I seem to have a conflict with the contrib Access with Level Account (v. 2.2a) for the Admin Area of osCommerce (MS2). When selecting any reports from the admin page I am redirected to my admin login sereen. The contrib Access with Level Account appends a varible osCAdminID=long_session_string to every admin page request. But the supertracker.php uses <option value="supertracker.php?report=refer"> and so on, so when the session dosn't see this osCAdminID varible I am kicked back to my login screen. I assume this is what is happening, but I am completly at a loss as how to fix it...Any ideas?

     

    I fixed it by editing the following code in catalog/admin/supertracker.php after line 125 :

    Replace:

    <option value=""><?php echo TABLE_TEXT_MENU_TEXTE; ?></option>
    
    <option value="supertracker.php?report=refer"><?php echo TEXT_TOP_REFERRERS; ?></option>
    
    <option value="supertracker.php?report=success_refer"><?php echo TEXT_TOP_SALES;?></option>
    
    <option value="supertracker.php?special=geo"><?php echo TEXT_VISITORS;?></option>								
    
    <option value="supertracker.php?special=keywords"><?php echo TEXT_SEARCH_KEYWORDS;?></option>
    
    <option value="supertracker.php?special=keywords_last24"><?php echo TEXT_SEARCH_KEYWORDS_24;?></option>			
    <option value="supertracker.php?special=keywords_last72"><?php echo TEXT_SEARCH_KEYWORDS_3;?></option>			
    <option value="supertracker.php?special=keywords_lastweek"><?php echo TEXT_SEARCH_KEYWORDS_7;?></option>		<option value="supertracker.php?special=keywords_lastmonth"><?php echo TEXT_SEARCH_KEYWORDS_30;?></option>		<option value="supertracker.php?report=exit"><?php echo TEXT_TOP_EXIT_PAGES;?></option>
    
    <option value="supertracker.php?report=exit_added"><?php echo TEXT_TOP_EXIT_PAGES_NO_SALE;?></option>
    
    <option value="supertracker.php?report=ave_clicks"><?php echo TEXT_AVERAGE_CLICKS;?></option>						<option value="supertracker.php?report=ave_time"><?php echo TEXT_AVERAGE_TIME_SPENT;?></option>					<option value="supertracker.php?special=prod_coverage"><?php echo TEXT_PRODUCTS_VIEWED_REPORT;?></option>	 <!-- modifed by azer//-->	
    
    <option value="supertracker.php?special=last_ten"><?php echo TEXT_LAST_TEN_VISITORS;?></option>
    
    <?php if (SUPERTRACKER_USE_PPC) {?>						
    
    <option value="supertracker.php?special=ppc_summary"><?php echo TEXT_PPC_REFERRAL;?></option>

     

    With This:

     

    	
    <div class="supertracker_text">	
    <?php echo TABLE_TEXT_MENU_DESC_TEXTE; ?> <form name="report_select"><select name="report_selector" onchange="page_redirect(this)">							
    <option value=""><?php echo TABLE_TEXT_MENU_TEXTE; ?></option>
    <?php //Begin compatibility with Admin Level Access
    ?>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=refer' ?>"><?php echo TEXT_TOP_REFERRERS; ?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=success_refer' ?>">
    <?php echo TEXT_TOP_SALES;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=geo' ?>"><?php echo TEXT_VISITORS;?></option>								
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords' ?>"><?php echo TEXT_SEARCH_KEYWORDS;?></option>							
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_last24' ?>"><?php echo TEXT_SEARCH_KEYWORDS_24;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_last72' ?>"><?php echo TEXT_SEARCH_KEYWORDS_3;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_lastweek' ?>"><?php echo TEXT_SEARCH_KEYWORDS_7;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_lastmonth' ?>"><?php echo TEXT_SEARCH_KEYWORDS_30;?></option>													
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=exit' ?>"><?php echo TEXT_TOP_EXIT_PAGES;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=exit_added' ?>"><?php echo TEXT_TOP_EXIT_PAGES_NO_SALE;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=ave_clicks' ?>"><?php echo TEXT_AVERAGE_CLICKS;?></option>								
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=ave_time' ?>"><?php echo TEXT_AVERAGE_TIME_SPENT;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=prod_coverage' ?>"><?php echo TEXT_PRODUCTS_VIEWED_REPORT;?></option>	 <!-- modifed by azer//-->	
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=last_ten' ?>"><?php echo TEXT_LAST_TEN_VISITORS;?></option>
    <?php if (SUPERTRACKER_USE_PPC) {?>													
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=ppc_summary' ?>"><?php echo TEXT_PPC_REFERRAL;?></option>
    <?php //End compatibility with Admin Level Access
    ?>

  2. Has anybody got the Supertracker contrib working with admin access? The supertracker.php page is not keeping my osCAdminID so I get redirected to a login page every time I try to look at a report... Any ideas?

     

    I fixed it by editing the following code in catalog/admin/supertracker.php after line 125 :

    Replace:

    <option value=""><?php echo TABLE_TEXT_MENU_TEXTE; ?></option>
    
    <option value="supertracker.php?report=refer"><?php echo TEXT_TOP_REFERRERS; ?></option>
    
    <option value="supertracker.php?report=success_refer"><?php echo TEXT_TOP_SALES;?></option>
    
    <option value="supertracker.php?special=geo"><?php echo TEXT_VISITORS;?></option>								
    
    <option value="supertracker.php?special=keywords"><?php echo TEXT_SEARCH_KEYWORDS;?></option>
    
    <option value="supertracker.php?special=keywords_last24"><?php echo TEXT_SEARCH_KEYWORDS_24;?></option>			
    <option value="supertracker.php?special=keywords_last72"><?php echo TEXT_SEARCH_KEYWORDS_3;?></option>			
    <option value="supertracker.php?special=keywords_lastweek"><?php echo TEXT_SEARCH_KEYWORDS_7;?></option>		<option value="supertracker.php?special=keywords_lastmonth"><?php echo TEXT_SEARCH_KEYWORDS_30;?></option>		<option value="supertracker.php?report=exit"><?php echo TEXT_TOP_EXIT_PAGES;?></option>
    
    <option value="supertracker.php?report=exit_added"><?php echo TEXT_TOP_EXIT_PAGES_NO_SALE;?></option>
    
    <option value="supertracker.php?report=ave_clicks"><?php echo TEXT_AVERAGE_CLICKS;?></option>						<option value="supertracker.php?report=ave_time"><?php echo TEXT_AVERAGE_TIME_SPENT;?></option>					<option value="supertracker.php?special=prod_coverage"><?php echo TEXT_PRODUCTS_VIEWED_REPORT;?></option>	 <!-- modifed by azer//-->	
    
    <option value="supertracker.php?special=last_ten"><?php echo TEXT_LAST_TEN_VISITORS;?></option>
    
    <?php if (SUPERTRACKER_USE_PPC) {?>						
    
    <option value="supertracker.php?special=ppc_summary"><?php echo TEXT_PPC_REFERRAL;?></option>

     

    With This:

     

    	
    <div class="supertracker_text">	
    <?php echo TABLE_TEXT_MENU_DESC_TEXTE; ?> <form name="report_select"><select name="report_selector" onchange="page_redirect(this)">							
    <option value=""><?php echo TABLE_TEXT_MENU_TEXTE; ?></option>
    <?php //Begin compatibility with Admin Level Access
    ?>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=refer' ?>"><?php echo TEXT_TOP_REFERRERS; ?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=success_refer' ?>">
    <?php echo TEXT_TOP_SALES;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=geo' ?>"><?php echo TEXT_VISITORS;?></option>								
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords' ?>"><?php echo TEXT_SEARCH_KEYWORDS;?></option>							
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_last24' ?>"><?php echo TEXT_SEARCH_KEYWORDS_24;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_last72' ?>"><?php echo TEXT_SEARCH_KEYWORDS_3;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_lastweek' ?>"><?php echo TEXT_SEARCH_KEYWORDS_7;?></option>										
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=keywords_lastmonth' ?>"><?php echo TEXT_SEARCH_KEYWORDS_30;?></option>													
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=exit' ?>"><?php echo TEXT_TOP_EXIT_PAGES;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=exit_added' ?>"><?php echo TEXT_TOP_EXIT_PAGES_NO_SALE;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=ave_clicks' ?>"><?php echo TEXT_AVERAGE_CLICKS;?></option>								
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&report=ave_time' ?>"><?php echo TEXT_AVERAGE_TIME_SPENT;?></option>
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=prod_coverage' ?>"><?php echo TEXT_PRODUCTS_VIEWED_REPORT;?></option>	 <!-- modifed by azer//-->	
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=last_ten' ?>"><?php echo TEXT_LAST_TEN_VISITORS;?></option>
    <?php if (SUPERTRACKER_USE_PPC) {?>													
    <option value="<?php echo $PHP_SELF . '?osCAdminID=' . $osCAdminID . '&special=ppc_summary' ?>"><?php echo TEXT_PPC_REFERRAL;?></option>
    <?php //End compatibility with Admin Level Access
    ?>

  3. I seem to have a conflict with the contrib Access with Level Account (v. 2.2a) for the Admin Area of osCommerce (MS2). When selecting any reports from the admin page I am redirected to my admin login sereen. The contrib Access with Level Account appends a varible osCAdminID=long_session_string to every admin page request. But the supertracker.php uses <option value="supertracker.php?report=refer"> and so on, so when the session dosn't see this osCAdminID varible I am kicked back to my login screen. I assume this is what is happening, but I am completly at a loss as how to fix it...Any ideas?

  4. 1054 - Unknown column 'p.products_id' in 'on clause'
    
    select count(distinct p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '17'
    
    [TEP STOP]

     

    Just installed totalB2B 1.2e on a fresh MS2 install and I am getting this when I click on any of the lowest level categories. This is my second attempt at this contrib, with same results. What am I missing?

×
×
  • Create New...