Kryptronic Software Support Forum

<?php 

// +------------------------------------------------------------------+
// |                                                            [KHXC]|
// | This package is based on ClickCartPro 6 by Kryptronic.  The      |
// | following copyright information was delivied in the original     |
// | version of this file as delivered by Kryptronic:                 |
// |                                                                  |
// | Copyright 1999-2006 Kryptronic, Inc. All rights reserved.        |
// |                                                                  |
// | All Kryptronic software is copyrighted, trademarked, developed   |
// | and licensed by Kryptronic, Inc. All Kryptronic software is      |
// | distributed under license.                                       |
// |                                                                  |
// | View the license agreement for more information.  Installation   |
// | of this software package indicates acceptance of the license     |
// | agreement.                                                       |
// |                                                                  |
// | Author:            Nick Hendler, Webmaster, Kryptronic, Inc.     |
// | Author Email:      support@kryptronic.com                        |
// +------------------------------------------------------------------+

// +------------------------------------------------------------------+
// |                                                            [KHXC]|
// | This package is a modified version of the original code          |
// | which is distributed by Greenbarn Consultants, LTD.              |
// |                                                                  |
// | This distribution of Kryptronic Software product is trademarked, | 
// | distributed and supported by GreenBarnWeb (Greenbarn Consultants |
// | Ltd.).                                                           |
// +------------------------------------------------------------------+

// +------------------------------------------------------------------+
// | Class Definition                                           [KHXC]|
// +------------------------------------------------------------------+

class GBU_femenus extends GBU {

var $class   = 'GBU_femenus';
var $version = '6.0.2';
var $cerror;

var $KHXC_DB;
var $KHXC_Display;

var $app;

// +------------------------------------------------------------------+
// | Constructor Function                                       [KHXC]|
// +------------------------------------------------------------------+

function GBU_femenus () {

// +--
// | This is the class constructor function.
// +--

if ($this->debug) {$this->debugger("constructor: Accessed.");}

// +--
// | Determine the application we're running under and set the $app
// | class var to that app.
// +--

$this->app = $this->app_id(__FILE__);

if ($this->debug) {$this->debugger("constructor: Determined application id as '{$this->app}'");}

// +--
// | Quick object load: KHXC_Display
// +--

$this->KHXC_Display =& $this->quick_object('KHXC_Display','khxc');

if ($this->IsError($this->KHXC_Display)) {$this->cerror = $this->KHXC_Display; return;}

// +--
// | Quick object load: KHXC_DB
// +--

$this->KHXC_DB =& $this->quick_object('KHXC_DB','khxc','KHXC_DB_1');

if ($this->IsError($this->KHXC_DB)) {$this->cerror = $this->KHXC_DB; return;}

// +--
// | Return $this.
// +--

return;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenusdo                                              |
// +------------------------------------------------------------------+

function femenusdo ($id = '') {

// +--
// | This function executes a frontend menus request.  We cache our
// | menu list here so as to reduce calls to the db.  We're be called
// | at least twice for most displays.
// +--

global $menus_cache;

// +--
// | Load info from the db if $menus_cache is empty.  Just return
// | on errors.  We don't want to blow everything up.
// +--

if (empty($menus_cache)) {

     // +--
     // | Load info from the database.
     // +--

     $table = $this->app . '_femenus';

     $sql  = "SELECT name, namespace, menugroup FROM {$table} WHERE ";
     $sql .= "menudisp=" . $this->KHXC_DB->quote(1);

     $result = $this->KHXC_DB->sql_do(array('table' => $table,
                                            'sql'   => $sql,
                                            'order' => array('menuorder' => 'ASC')));

     if ($this->IsError($result)) {return 1;}
     if (empty($result))          {return 1;}

     $menus_cache = $result;

     if ($this->debug) {$this->debugger("femenusdo: Loaded frontend menus into cache.");}

} // End of if statement.

// +--
// | Display the requested menu(s).
// +--

foreach ($menus_cache as $num => $row) {

     if ($row['menugroup'] == $id) {

          $this->globals('khxc_app.femenus_name',$row['name']);

          $result = $this->exec_namespace(array('app'       => $this->app,
                                                'namespace' => $row['namespace'],
                                                'type'      => '*'));

     } // End of if statement.

} // End of foreach statement.

if ($this->debug) {$this->debugger("femenusdo: Completed running frontend menus for the KHXC with id '{$id}'.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenupopular                                          |
// +------------------------------------------------------------------+

function femenupopular () {

// +--
// | This function prints the frontend popular pages menu.
// +--

$sql  = "SELECT namespace, reference, dispname FROM khxc_statsns WHERE";
$sql .= " interface=" . $this->KHXC_DB->quote('FrontEnd') . " AND app=";
$sql .= $this->KHXC_DB->quote($this->app);

$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,
                                       'table'  => 'khxc_statsns',
                                       'order'  => array('hitcount' => 'DESC'),
                                       'count'  => 5,
                                       'offset' => 0));

if ($this->IsError($result)) {return 1;}
if (empty($result))          {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $params = array();

     if (!(empty($row['reference']))) {$params = array('ref' => $row['reference']);}

     $menu_array[] = array('text'      => $row['dispname'],
                           'app'       => $this->app,
                           'namespace' => $row['namespace'],
                           'params'    => $params);

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the application popular menu.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenurecent                                           |
// +------------------------------------------------------------------+

function femenurecent () {

// +--
// | This function prints the frontend recent pages menu.
// +--

///// RJZwebmaster spadedlady added DISTINCT to sql call below, added
////  sql call line for namespace, and increased count to 8 from 5.
$sql  = "SELECT DISTINCT namespace, reference, dispname FROM khxc_stats WHERE";

$sql .= " interface=" . $this->KHXC_DB->quote('FrontEnd');

$sql .= " AND namespace=" .  $this->KHXC_DB->quote('prodshow');

$sql .= " AND sessionid=" .  $this->KHXC_DB->quote($this->globals('khxc_session.sid'));

$sql .= " AND disprecback=" .  $this->KHXC_DB->quote(1) . " AND app=";

$sql .= $this->KHXC_DB->quote($this->app);



$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,

                                       'table'  => 'khxc_stats',

                                       'order'  => array('time' => 'DESC'),

                                       'count'  => 5,

                                       'offset' => 0));

///// RJZ webmaster spadedlady added DISTINCT to sql call above, added
////  sql call line for namespace, and increased count to 8 from 5.

if ($this->IsError($result)) {return 1;}

if (empty($result))          {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $params = array();

     if (!(empty($row['reference']))) {$params = array('ref' => $row['reference']);}

     $menu_array[] = array('text'      => $row['dispname'],
                           'app'       => $this->app,
                           'namespace' => $row['namespace'],
                           'params'    => $params);

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the application recent menu.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenucurrency                                         |
// +------------------------------------------------------------------+

function femenucurrency () {

// +--
// | This function prints the frontend currency changer menu if there
// | is at least one active ecommerce application avaialble and we're
// | using the currency conversion system.
// +--

$curr_active = $this->globals('khxc_settings.khxc.curractive');

if (empty($curr_active)) {return 1;}

// +--
// | Load our currency selection items.
// +--

$sql  = "SELECT selectname, selectvalue FROM khxc_selectcustom WHERE";
$sql .= " selectid=" . $this->KHXC_DB->quote($this->app . '.currency');

$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,
                                       'table'  => 'khxc_selectcustom',
                                       'order'  => array('selectname' => 'DESC')));

if ($this->IsError($result)) {return 1;}
if (empty($result))          {return 1;}

// +--
// | Build the currency array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $currency[$row['selectvalue']] = $row['selectname'];

} // End of foreach statement.

// +--
// | Globalize the currency array.
// +--

$this->globals('khxc_app.currency_array',$currency);

// +--
// | Print the currency selector menu include.
// +--

$this->KHXC_Display->include_file($this->app,'femenucurrency.php');

if ($this->debug) {$this->debugger("menupages: Printed the application currency menu.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenuaccount                                          |
// +------------------------------------------------------------------+

function femenuaccount () {

// +--
// | This function prints the frontend account menu.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$result = $this->exec_namespace(array('app'       => $this->app,
                                      'namespace' => 'accountmenu',
                                      'type'      => '*'));

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the application account menu.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: femenuinactive                                         |
// +------------------------------------------------------------------+

function femenuinactive () {

// +--
// | This function prints the frontend inactive apps menu.
// +--

// +--
// | Get display names for apps not equal to this app.
// +--

$all_apps     = $this->globals('khxc.app_all_cache');
$app_inactive = array();

foreach ($all_apps as $num => $row) {

     if (($row['id'] != 'khxc') && ($row['id'] != $this->app)) {

          $app_inactive[$row['id']] = $row['fedispname'];

     } // End of if statement.

} // End of foreach statement.

// +--
// | Return if we didn't find any.
// +--

if (empty($app_inactive)) {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($app_inactive as $id => $name) {

     $menu_array[] = array('text'      => $name,
                           'app'       => $id,
                           'namespace' => '',
                           'params'    => array());

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the KHXC inactive apps menu.");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: menustore                                              |
// +------------------------------------------------------------------+

function menustore () {

// +--
// | This function prints the online store menu.
// +--

$table = $this->app . '_storemenu';

$sql  = "SELECT name, namespace FROM {$table} WHERE menudisp=";
$sql .= $this->KHXC_DB->quote(1);

$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,
                                       'table'  => $table,
                                       'order'  => array('menuorder' => 'ASC')));

if ($this->IsError($result)) {return 1;}
if (empty($result))          {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $menu_array[] = array('text'      => $row['name'],
                           'app'       => $this->app,
                           'namespace' => $row['namespace'],
                           'params'    => array());

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the GBU store menu.  App: {$this->app}");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: menucategories                                         |
// +------------------------------------------------------------------+

function menucategories () {

// +--
// | This function prints the categories menu.
// +--

$table = $this->app . '_cat';

$sql  = "SELECT id, name FROM {$table} WHERE splashdisp=";
$sql .= $this->KHXC_DB->quote(1) . " AND ";

// +--
// | Handle visibility.
// +--

$usergroup = $this->globals('khxc_user.usergroup');

if (empty($usergroup)) {
 
     $sql .= 'catview=' . $this->KHXC_DB->quote('A');

} else {

     $sql .= '((catview=' . $this->KHXC_DB->quote('A') . ') OR ';
     $sql .= '(catview=' . $this->KHXC_DB->quote('L') . ' AND ';
     $sql .= '(catviewg LIKE ' . $this->KHXC_DB->quote_like($usergroup . ',', 'SUFFIX') . ' OR ';
     $sql .= 'catviewg LIKE ' . $this->KHXC_DB->quote_like(','  . $usergroup, 'PREFIX') . ' OR ';
     $sql .= 'catviewg LIKE ' . $this->KHXC_DB->quote_like(', '  . $usergroup, 'PREFIX') . ' OR ';
     $sql .= 'catviewg LIKE ' . $this->KHXC_DB->quote_like(','  . $usergroup . ',', 'WRAP') . ' OR ';
     $sql .= 'catviewg LIKE ' . $this->KHXC_DB->quote_like(', '  . $usergroup . ',', 'WRAP') . ' OR ';
     $sql .= 'catviewg='       . $this->KHXC_DB->quote($usergroup) . ')))';

} // End of if statement.

// +--
// | Execute the query.
// +--

$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,
                                       'table'  => $table,
                                       'order'  => array('sortorder' => 'ASC')));

if ($this->IsError($result)) {return 1;}
if (empty($result))          {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $menu_array[] = array('text'      => $row['name'],
                           'app'       => $this->app,
                           'namespace' => 'catshow',
                           'params'    => array('ref' => $row['id']));

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the GBU categories menu.  App: {$this->app}");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | Function: menucustom                                             |
// +------------------------------------------------------------------+

function menucustom () {

// +--
// | This function prints the custom menu.
// +--

$table = $this->app . '_custommenu';

$sql  = "SELECT name, namespace, reference FROM {$table} WHERE menudisp=";
$sql .= $this->KHXC_DB->quote(1);

$result = $this->KHXC_DB->sql_do(array('sql'    => $sql,
                                       'table'  => $table,
                                       'order'  => array('menuorder' => 'ASC')));

if ($this->IsError($result)) {return 1;}
if (empty($result))          {return 1;}

// +--
// | Build the menu array.
// +--

$menu_array = array();

foreach ($result as $num => $row) {

     $params = array();

     if ($row['reference'] != '') {$params = array('ref' => $row['reference']);}

     $menu_array[] = array('text'      => $row['name'],
                           'app'       => $this->app,
                           'namespace' => $row['namespace'],
                           'params'    => $params);

} // End of foreach statement.

// +--
// | Globalize the menu array.
// +--

$this->globals('khxc_app.femenu_array',$menu_array);

// +--
// | Print the generic frontend menu includes and log that we were here.
// +--

$this->KHXC_Display->include_file($this->app,'femenuhead.php');

$this->KHXC_Display->include_file($this->app,'femenugeneric.php');

$this->KHXC_Display->include_file($this->app,'femenufoot.php');

if ($this->debug) {$this->debugger("menupages: Printed the CCP store menu.  App: {$this->app}");}

// +--
// | Return true.
// +--

return 1;

} // End of function.

// +------------------------------------------------------------------+
// | End of Class                                               [KHXC]|
// +------------------------------------------------------------------+

} // End of class.

// +------------------------------------------------------------------+
// | End Of File                                                [KHXC]|
// +------------------------------------------------------------------+

?>