Changeset 15796 for trunk/inc

Timestamp:

12/27/11 00:35:39 (5 months ago)

Author:

Alexander Trofimov

Message:

Menu

File:

• trunk/inc/classes/BxDolMenuQuery.php (modified) (2 diffs)

trunk/inc/classes/BxDolMenuQuery.php

@@ -24 +24 @@
     static public function getMenuObject ($sObject) {
         $oDb = BxDolDb::getInstance();
-        $sQuery = $oDb->prepare("SELECT * FROM `sys_objects_menu` WHERE `object` = ?", $sObject);
+        $sQuery = $oDb->prepare("SELECT `o`.*, `t`.`template` FROM `sys_objects_menu` AS `o` INNER JOIN `sys_menu_templates` AS `t` ON (`t`.`id` = `o`.`template_id`) WHERE `o`.`object` = ?", $sObject);
         $aObject = $oDb->getRow($sQuery);        
         if (!$aObject || !is_array($aObject)) 
@@ -34 +34 @@
 
     public function getMenuItems() {
-        $sQuery = $this->prepare("SELECT * FROM `sys_menu` WHERE `set_name` = ?", $this->_aObject['set_name']);
+        $sQuery = $this->prepare("SELECT * FROM `sys_menu_items` WHERE `set_name` = ?", $this->_aObject['set_name']);
         return $this->getAll($sQuery);
     }