/** * Retrieve a folder translation object from the database * * If no $languageid is specified, the default_language set in the module's preference * will be used * * @param int $id id of the folder * @param string $languageid language of the translation to retreive * @return object SmartmediaFolder_text */ function &get($folderid, $languageid = 'none') { if ($languageid == 'none') { $smartConfig =& smartmedia_getModuleConfig(); $languageid = $smartConfig['default_language']; } $folderid = intval($folderid); if ($folderid > 0) { $criteria = new CriteriaCompo(); $criteria->add(new Criteria('folderid', $folderid)); $criteria->add(new Criteria('languageid', $languageid)); $sql = $this->_selectQuery($criteria); //echo "<br /> $sql <br />"; if (!($result = $this->_db->query($sql))) { return false; } $numrows = $this->_db->getRowsNum($result); if ($numrows == 1) { $obj = new $this->classname($this->_db->fetchArray($result)); return $obj; } } return false; }
function smartmedia_getHelpPath() { $smartConfig =& smartmedia_getModuleConfig(); switch ($smartConfig['helppath_select']) { case 'docs.xoops.org': return 'http://docs.xoops.org/help/ssectionh/index.htm'; break; case 'inside': return XOOPS_URL . "/modules/smartmedia/doc/"; break; case 'custom': return $smartConfig['helppath_custom']; break; } }
/** * Get count of clips for the admin index page * * @param string $languagesel specific language * * @return int count of clips */ function &getClipsCountFromAdmin($languagesel) { global $xoopsConfig, $xoopsDB; $smartConfig =& smartmedia_getModuleConfig(); if ($languagesel == 'all') { $where = ""; } else { $where = "WHERE clips_text.languageid = '" . $languagesel . "'"; } $sql = "SELECT COUNT(DISTINCT clips.clipid)\r\n\t\t\t\t\tFROM (\r\n\t\t\t\t\t " . $xoopsDB->prefix('smartmedia_clips') . " AS clips\r\n \t\t\t\t\tINNER JOIN " . $this->_db->prefix('smartmedia_clips_text') . " AS clips_text ON clips.clipid = clips_text.clipid\r\n\t\t\t\t\t\t)\r\n \t\t\t\t\tINNER JOIN " . $this->_db->prefix('smartmedia_folders') . " AS folders ON clips.folderid=folders.folderid\r\n \t\t\t\t\tINNER JOIN " . $this->_db->prefix('smartmedia_folders_text') . " AS folders_text ON folders.folderid = folders_text.folderid\r\n\t\t\t\t\tINNER JOIN " . $this->_db->prefix('smartmedia_folders_categories') . " AS categories\r\n\t\t\t\t\tON folders.folderid = categories.folderid\r\n\t\t\t\t \r\n " . $where; //echo "<br />$sql<br />"; if (!($result =& $this->_db->query($sql))) { return 0; } list($count) = $this->_db->fetchRow($result); return $count; }
/** * Retrieve objects from the database * * @param int $categoryid id of a category * @param object $criteria {@link CriteriaElement} conditions to be met * @param bool $category_id_as_key Should the folder ID be used as array key * @return array array of {@link SmartmediaFolder} objects */ function &getObjects($categoryid, $criteria = null, $category_id_as_key = false) { global $xoopsConfig; $smartConfig =& smartmedia_getModuleConfig(); $ret = array(); $limit = $start = 0; $sql = $this->_selectJoinQuery($categoryid, $criteria); if (isset($criteria)) { $limit = $criteria->getLimit(); $start = $criteria->getStart(); } // echo "<br />$sql<br />"; $result = $this->_db->query($sql, $limit, $start); // If no records from db, return empty array if (!$result) { return $ret; } // Add each returned record to the result array while ($myrow = $this->_db->fetchArray($result)) { $obj = new $this->classname($xoopsConfig['language'], $myrow); if (!$category_id_as_key) { $ret[$obj->getVar('folderid')] =& $obj; } else { $ret[$myrow['categoryid']][$obj->getVar('folderid')] =& $obj; } unset($obj); } return $ret; }
function toArray($content = array()) { $content['contentid'] = $this->contentid(); $content['itemurl'] = $this->getItemUrl(); $content['itemlink'] = $this->getItemLink(); $content['parentid'] = $this->parentid(); $content['weight'] = $this->weight(); if ($this->getVar('image') != 'blank.png') { $content['image_path'] = smartmedia_getImageDir('content', false) . $this->image(); } else { $content['image_path'] = false; } $smartConfig =& smartmedia_getModuleConfig(); $content['main_image_width'] = $smartConfig['main_image_width']; $content['list_image_width'] = $smartConfig['list_image_width']; $content['adminLinks'] = $this->adminLinks(); $content['title'] = $this->title(); $content['clean_title'] = $content['title']; $content['description'] = $this->description(); $content['meta_description'] = $this->meta_description(); // Hightlighting searched words $highlight = true; if ($highlight && isset($_GET['keywords'])) { $myts =& MyTextSanitizer::getInstance(); $keywords = $myts->htmlSpecialChars(trim(urldecode($_GET['keywords']))); $h = new keyhighlighter($keywords, true, 'smartmedia_highlighter'); $content['title'] = $h->highlight($content['title']); $content['description'] = $h->highlight($content['description']); } return $content; }
define("SMARTMEDIA_URL", XOOPS_URL . '/modules/' . SMARTMEDIA_DIRNAME . '/'); } if (!defined("SMARTMEDIA_ROOT_PATH")) { define("SMARTMEDIA_ROOT_PATH", XOOPS_ROOT_PATH . '/modules/' . SMARTMEDIA_DIRNAME . '/'); } if (!defined("SMARTMEDIA_IMAGES_URL")) { define("SMARTMEDIA_IMAGES_URL", SMARTMEDIA_URL . "images/"); } include_once SMARTMEDIA_ROOT_PATH . "include/functions.php"; // Creating the SmartModule object $smartModule =& smartmedia_getModuleInfo(); $myts = MyTextSanitizer::getInstance(); $smartmedia_moduleName = $myts->displayTarea($smartModule->getVar('name')); $is_smartmedia_admin = smartmedia_userIsAdmin(); // Creating the SmartModule config Object $smartConfig =& smartmedia_getModuleConfig(); include_once SMARTMEDIA_ROOT_PATH . "class/permission.php"; include_once SMARTMEDIA_ROOT_PATH . "class/category.php"; include_once SMARTMEDIA_ROOT_PATH . "class/category_text.php"; include_once SMARTMEDIA_ROOT_PATH . "class/folder.php"; include_once SMARTMEDIA_ROOT_PATH . "class/folder_text.php"; include_once SMARTMEDIA_ROOT_PATH . "class/clip.php"; include_once SMARTMEDIA_ROOT_PATH . "class/clip_text.php"; include_once SMARTMEDIA_ROOT_PATH . "class/tabs.php"; include_once SMARTMEDIA_ROOT_PATH . "class/format.php"; include_once SMARTMEDIA_ROOT_PATH . "class/keyhighlighter.class.php"; // Creating the permission handler object $smartmedia_permission_handler =& xoops_getmodulehandler('permission', SMARTMEDIA_DIRNAME); // Creating the category handler object $smartmedia_category_handler =& smartmedia_gethandler('category'); // Creating the category_text handler object