• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    迪恩网络公众号

PHP FSSJ3Helper类代码示例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

本文整理汇总了PHP中FSSJ3Helper的典型用法代码示例。如果您正苦于以下问题:PHP FSSJ3Helper类的具体用法?PHP FSSJ3Helper怎么用?PHP FSSJ3Helper使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。



在下文中一共展示了FSSJ3Helper类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT a.*, u.name, u.username FROM #__fss_announce as a ';
     $query .= ' LEFT JOIN #__users as u ON a.author = u.id ';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     $order = "";
     if ($this->lists['order']) {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'];
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     if (FSSAdminHelper::$filter_lang) {
         $where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";
     }
     if (FSSAdminHelper::$filter_access) {
         $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:27,代码来源:announces.php


示例2: array

 function &getAnnounce()
 {
     $db = JFactory::getDBO();
     $announceid = FSS_Input::getInt('announceid', 0);
     $query = "SELECT * FROM #__fss_announce";
     $where = array();
     $where[] = "id = '" . FSSJ3Helper::getEscaped($db, $announceid) . "'";
     if (FSS_Permission::auth("core.edit", "com_fss.announce")) {
     } else {
         if (FSS_Permission::auth("core.edit.own", "com_fss.announce")) {
             $where[] = " ( published = 1 OR author = {$this->content->userid} ) ";
         } else {
             $where[] = "published = 1";
         }
     }
     $db = JFactory::getDBO();
     $where[] = 'language in (' . $db->Quote(JFactory::getLanguage()->getTag()) . ',' . $db->Quote('*') . ')';
     $user = JFactory::getUser();
     $where[] = 'access IN (' . implode(',', $user->getAuthorisedViewLevels()) . ')';
     if (count($where) > 0) {
         $query .= " WHERE " . implode(" AND ", $where);
     }
     $db->setQuery($query);
     $rows = $db->loadAssoc();
     return $rows;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:26,代码来源:announce.php


示例3: _buildQuery

    function _buildQuery()
    {
        if (!empty($this->_query)) {
            return $this->_query;
        }
        $db = JFactory::getDBO();
        $query = 'SELECT u.id, u.username, u.name, u.email, g.title as lf1, gm.group_id as gid FROM #__users as u 
				LEFT JOIN #__user_usergroup_map as gm ON u.id = gm.user_id
				LEFT JOIN #__usergroups as g ON gm.group_id = g.id';
        $where = array();
        if ($this->lists['search']) {
            $search = array();
            $search[] = '(LOWER( u.username ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
            $search[] = '(LOWER( u.name ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
            $search[] = '(LOWER( u.email ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
            $where[] = " ( " . implode(" OR ", $search) . " ) ";
        }
        $order = "";
        if ($this->lists['order']) {
            $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . '';
        }
        if ($this->lists['gid'] != '') {
            $where[] = 'gm.group_id = "' . $this->lists['gid'] . '"';
        }
        if (JRequest::getVar('tpl') == 'fuser') {
            $query .= " LEFT JOIN #__fss_users AS fssu ON u.id = fssu.user_id";
            $where[] = "(rules = '' OR rules IS NULL)";
        }
        $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
        $query .= $where . " GROUP BY username " . $order;
        $this->_query = $query;
        return $query;
    }
开发者ID:vstorm83,项目名称:propertease,代码行数:33,代码来源:listusers.php


示例4: display

 function display($tpl = null)
 {
     $db = JFactory::getDBO();
     $test = FSS_Input::getInt('test');
     if ($test > 0) {
         error_reporting(E_ALL);
         ini_set('display_errors', 1);
         $qry = "SELECT * FROM #__fss_cron WHERE id = " . FSSJ3Helper::getEscaped($db, $test);
     } else {
         $qry = "SELECT * FROM #__fss_cron WHERE published = 1 AND ((UNIX_TIMESTAMP() - lastrun) - (`interval` * 60)) > 0";
     }
     $db->setQuery($qry);
     $rows = $db->loadObjectList();
     if (!$rows) {
         exit;
     }
     foreach ($rows as $row) {
         $db->setQuery("UPDATE #__fss_cron SET lastrun=UNIX_TIMESTAMP() WHERE id='{$row->id}' LIMIT 1");
         $db->query();
         $class = "FSSCron" . $row->class;
         $file = strtolower($row->class) . ".php";
         $path = JPATH_SITE . DS . 'components' . DS . 'com_fss' . DS . 'cron' . DS;
         if (file_exists($path . $file)) {
             require_once $path . $file;
             $inst = new $class();
             $inst->Execute($this->ParseParams($row->params));
             if ($test > 0) {
                 echo "<pre>" . $inst->_log . "</pre>";
             } else {
                 $inst->SaveLog();
             }
         }
     }
     exit;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:35,代码来源:view.html.php


示例5: save

 function save()
 {
     // if we are saving, then save
     $saveid = FSS_Input::getInt('saveid', -1);
     if ($saveid != -1) {
         $description = FSS_Input::getString('description');
         $is_personal = FSS_Input::getInt('personal');
         $content = FSS_Input::getHTML('content');
         $params = array();
         if ($is_personal) {
             $params['userid'] = JFactory::getUser()->id;
         }
         $params = json_encode($params);
         if ($saveid == 0) {
             $qry = "INSERT INTO #__fss_ticket_fragments (description, params, content, type) VALUES (";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $description) . "',";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $params) . "',";
             $qry .= "'" . FSSJ3Helper::getEscaped($db, $content) . "', 1)";
             $db = JFactory::getDBO();
             $db->setQuery($qry);
             $db->Query();
         } else {
             $qry = "UPDATE #__fss_ticket_fragments SET description = '" . FSSJ3Helper::getEscaped($db, $description) . "', ";
             $qry .= "params = '" . FSSJ3Helper::getEscaped($db, $params) . "', ";
             $qry .= "content = '" . FSSJ3Helper::getEscaped($db, $content) . "' WHERE id = " . FSSJ3Helper::getEscaped($db, $saveid);
             $db = JFactory::getDBO();
             $db->setQuery($qry);
             $db->Query();
         }
     }
     $mainframe = JFactory::getApplication();
     $link = JRoute::_('index.php?option=com_fss&view=admin_support&layout=signature&tmpl=component', false);
     $mainframe->redirect($link);
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:34,代码来源:task.signature.php


示例6: stdClass

 function &getData()
 {
     if (empty($this->_data)) {
         $query = ' SELECT * FROM #__fss_comments ' . '  WHERE id = ' . FSSJ3Helper::getEscaped($this->_db, $this->_id);
         $this->_db->setQuery($query);
         $this->_data = $this->_db->loadObject();
     }
     if (!$this->_data) {
         $this->_data = new stdClass();
         $this->_data->id = 0;
         $this->_data->ident = 5;
         // ##NOT_TEST_START##
         $this->_data->ident = 0;
         // ##NOT_TEST_END##
         $this->_data->itemid = 0;
         $this->_data->body = null;
         $this->_data->email = null;
         $this->_data->name = null;
         $this->_data->website = null;
         $this->_data->published = 1;
         $current_date = new JDate();
         if (FSSJ3Helper::IsJ3()) {
             $mySQL_conform_date = $current_date->toSql();
         } else {
             $mySQL_conform_date = $current_date->toMySQL();
         }
         $this->_data->created = $mySQL_conform_date;
     }
     return $this->_data;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:30,代码来源:test.php


示例7: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT c.id, c.title, c.ordering as ordering, c.published, c.description, c.image, c.inkb, c.insupport, c.intest, c.access, c.translation, c.category, c.subcat FROM #__fss_prod as c ';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     if ($this->lists['order'] == 'c.ordering') {
         $order = ' ORDER BY c.ordering ' . $this->lists['order_Dir'];
     } else {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', c.ordering';
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     /*if (FSSAdminHelper::$filter_lang)	
     		$where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";*/
     if (FSSAdminHelper::$filter_access) {
         $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:26,代码来源:prods.php


示例8: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT t.id as id,t.body as body, t.email as email, t.name as name, t.website as website, t.published as published, ';
     $query .= ' t.created as added, ident, itemid FROM #__fss_comments as t';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( t.name ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search']) . '%', false) . ' OR ' . 'LOWER( t.body ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search']) . '%', false) . ')';
     }
     $order = "";
     if ($this->lists['order'] == 'added') {
         $order = ' ORDER BY added ' . FSSJ3Helper::getEscaped($db, $this->lists['order_Dir']);
     } else {
         if ($this->lists['order']) {
             $order = ' ORDER BY ' . FSSJ3Helper::getEscaped($db, $this->lists['order']) . ' ' . FSSJ3Helper::getEscaped($db, $this->lists['order_Dir']) . '';
         }
     }
     if ($this->lists['prod_id'] > 0) {
         $where[] = 'p.id = ' . FSSJ3Helper::getEscaped($db, $this->lists['prod_id']);
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 't.published = ' . FSSJ3Helper::getEscaped($db, $this->lists['ispublished']);
     }
     $ident = JRequest::getVar('ident', '');
     if ($ident > 0) {
         $where[] = 'ident = ' . FSSJ3Helper::getEscaped($db, $ident);
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:31,代码来源:tests.php


示例9: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT * FROM #__fss_faq_cat ';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     if ($this->lists['order'] == 'ordering') {
         $order = ' ORDER BY ordering ' . $this->lists['order_Dir'];
     } else {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', ordering';
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     if (FSSAdminHelper::$filter_lang) {
         $where[] = "language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";
     }
     if (FSSAdminHelper::$filter_access) {
         $where[] = "access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:27,代码来源:faqcats.php


示例10: display_edit

 function display_edit()
 {
     $editid = FSS_Input::getInt('sigid');
     if ($editid > 0) {
         $db = JFactory::getDBO();
         $qry = "SELECT * FROM #__fss_ticket_fragments WHERE id = " . FSSJ3Helper::getEscaped($db, $editid);
         $db->setQuery($qry);
         $this->sig_item = $db->loadObject();
         $this->sig_item->params = json_decode($this->sig_item->params, true);
         if (is_string($this->sig_item->params)) {
             $this->sig_item->params = array();
         }
         $this->sig_item->personal = 0;
         $userid = JFactory::getUser()->id;
         if (isset($this->sig_item->params['userid'])) {
             if ($this->sig_item->params['userid'] > 0 && $userid != $this->sig_item->params['userid']) {
                 $mainframe = JFactory::getApplication();
                 $link = JRoute::_('index.php?option=com_fss&view=admin_support&layout=signature&tmpl=component');
                 $mainframe->redirect($link);
             }
             $this->sig_item->personal = 1;
         }
     } else {
         $this->sig_item = new stdClass();
         $this->sig_item->id = 0;
         $this->sig_item->description = "";
         $this->sig_item->content = "";
         $this->sig_item->personal = 1;
     }
     return $this->_display("edit");
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:31,代码来源:layout.signature.php


示例11: stdClass

 function &getData()
 {
     if (empty($this->_data)) {
         $query = ' SELECT * FROM #__fss_prod ' . '  WHERE id = ' . FSSJ3Helper::getEscaped($this->_db, $this->_id);
         $this->_db->setQuery($query);
         $this->_data = $this->_db->loadObject();
     }
     if (!$this->_data) {
         $this->_data = new stdClass();
         $this->_data->id = 0;
         $this->_data->title = null;
         $this->_data->description = null;
         $this->_data->ordering = 0;
         $this->_data->image = null;
         $this->_data->extratext = null;
         $this->_data->inkb = 1;
         $this->_data->insupport = 1;
         $this->_data->intest = 1;
         $this->_data->published = 1;
         $this->published = 1;
         $this->_data->access = 1;
         $this->_data->translation = "";
     }
     return $this->_data;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:25,代码来源:prod.php


示例12: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT k.id, k.title, k.body, k.ordering, k.published, c.title as cattitle, f.filecount, k.rating, k.ratingdetail, k.allprods, k.created, k.modified, k.views, k.access, k.language FROM #__fss_kb_art as k LEFT JOIN #__fss_kb_cat as c ';
     $query .= ' ON k.kb_cat_id = c.id ';
     $query .= ' LEFT JOIN (SELECT count(*) as filecount, kb_art_id FROM #__fss_kb_attach GROUP BY kb_art_id) as f ON k.id = f.kb_art_id ';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( k.title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     if ($this->lists['order'] == 'k.ordering') {
         $order = ' ORDER BY k.ordering ' . $this->lists['order_Dir'];
     } else {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', k.ordering';
     }
     if ($this->lists['kb_cat_id'] > 0) {
         $where[] = 'kb_cat_id = ' . $this->lists['kb_cat_id'];
     }
     if ($this->lists['prod_id'] > 0) {
         $where[] = "allprods = 1 OR k.id IN (SELECT kb_art_id FROM #__fss_kb_art_prod WHERE prod_id = '{$this->lists['prod_id']}')";
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'k.published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     if (FSSAdminHelper::$filter_lang) {
         $where[] = "k.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";
     }
     if (FSSAdminHelper::$filter_access) {
         $where[] = "k.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:35,代码来源:kbarts.php


示例13: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT * FROM #__fss_help_text ';
     $where = array();
     if ($this->lists['search']) {
         $search = array();
         $search[] = '(LOWER( description ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
         $search[] = '(LOWER( message ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
         $search[] = '(LOWER( identifier ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
         $where[] = " ( " . implode(" OR ", $search) . " ) ";
     }
     if ($this->lists['group'] != "") {
         $where[] = "`group` = '" . $db->escape($this->lists['group']) . "'";
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'published = ' . $this->lists['ispublished'];
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $order_ok = array("group", "description", "identifier", "message", "published");
     if (!in_array($this->lists['order'], $order_ok)) {
         $this->lists['order'] = "`group`, `description`";
     }
     if ($this->lists['order'] == "group") {
         $this->lists['order'] = "`group`";
     }
     $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'];
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:30,代码来源:helptexts.php


示例14: stdClass

 function &getData()
 {
     if (empty($this->_data)) {
         $query = ' SELECT * FROM #__fss_main_menu ' . '  WHERE id = ' . FSSJ3Helper::getEscaped($this->_db, $this->_id);
         $this->_db->setQuery($query);
         $this->_data = $this->_db->loadObject();
     }
     if (!$this->_data) {
         $this->_data = new stdClass();
         $this->_data->id = 0;
         $this->_data->title = null;
         $this->_data->description = null;
         $this->_data->icon = null;
         $this->_data->ordering = 0;
         $this->_data->itemtype = 7;
         $this->_data->link = "";
         $this->_data->itemid = 0;
         $this->_data->published = 1;
         $this->_data->access = 1;
         $this->_data->language = "*";
         $this->_data->target = '';
         $this->_data->translation = '';
         $this->published = 1;
     }
     return $this->_data;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:26,代码来源:mainmenu.php


示例15: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT c.id, c.title, c.ordering, c.published, c.description, c.image, c.parcatid, pc.title as parcattitle, c.access, c.language FROM #__fss_kb_cat as c ';
     $query .= " LEFT JOIN #__fss_kb_cat as pc on c.parcatid = pc.id ";
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( c.title ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     if ($this->lists['order'] == 'c.ordering') {
         $order = ' ORDER BY c.ordering ' . $this->lists['order_Dir'];
     } else {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', c.ordering';
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'c.published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     if (FSSAdminHelper::$filter_lang) {
         $where[] = "c.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";
     }
     if (FSSAdminHelper::$filter_access) {
         $where[] = "c.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:28,代码来源:kbcats.php


示例16: _buildQuery

 function _buildQuery()
 {
     $db = JFactory::getDBO();
     $query = ' SELECT f.id as id, question, answer, f.ordering as ordering, f.published as published, c.title as title, f.featured, f.access, f.language FROM #__fss_faq_faq as f LEFT JOIN #__fss_faq_cat as c ';
     $query .= ' ON f.faq_cat_id = c.id ';
     $where = array();
     if ($this->lists['search']) {
         $where[] = '(LOWER( question ) LIKE ' . $db->Quote('%' . FSSJ3Helper::getEscaped($db, $this->lists['search'], true) . '%', false) . ')';
     }
     if ($this->lists['order'] == 'f.ordering') {
         $order = ' ORDER BY f.ordering ' . $this->lists['order_Dir'];
     } else {
         $order = ' ORDER BY ' . $this->lists['order'] . ' ' . $this->lists['order_Dir'] . ', f.ordering';
     }
     if ($this->lists['faq_cat_id'] > 0) {
         $where[] = 'faq_cat_id = ' . $this->lists['faq_cat_id'];
     }
     if ($this->lists['ispublished'] > -1) {
         $where[] = 'f.published = ' . $this->lists['ispublished'];
     }
     FSSAdminHelper::LA_GetFilterState();
     if (FSSAdminHelper::$filter_lang) {
         $where[] = "f.language = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_lang) . "'";
     }
     if (FSSAdminHelper::$filter_access) {
         $where[] = "f.access = '" . FSSJ3Helper::getEscaped($db, FSSAdminHelper::$filter_access) . "'";
     }
     $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : '';
     $query .= $where . $order;
     //echo $query . "<br>";
     return $query;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:32,代码来源:faqs.php


示例17: loadResultArray

 static function loadResultArray(&$db)
 {
     if (FSSJ3Helper::IsJ3()) {
         return $db->loadColumn(0);
     } else {
         return $db->loadResultArray();
     }
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:8,代码来源:j3helper.php


示例18: AddMembership

 function AddMembership($userids, $groupid)
 {
     $db = JFactory::getDBO();
     foreach ($userids as $userid) {
         $qry = "REPLACE INTO #__fss_ticket_group_members (group_id, user_id) VALUES ('" . FSSJ3Helper::getEscaped($db, $groupid) . "', '" . FSSJ3Helper::getEscaped($db, $userid) . "')";
         $db->setQuery($qry);
         $db->query($qry);
     }
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:9,代码来源:listuser.php


示例19:

 function &getProduct()
 {
     $db = JFactory::getDBO();
     $prodid = FSS_Input::getInt('prodid');
     $query = "SELECT * FROM #__fss_prod WHERE id = '" . FSSJ3Helper::getEscaped($db, $prodid) . "'";
     $db->setQuery($query);
     $rows = $db->loadAssoc();
     return $rows;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:9,代码来源:test.php


示例20:

 function &getData()
 {
     if (empty($this->_data)) {
         $query = ' SELECT * FROM #__fss_emails ' . '  WHERE id = ' . FSSJ3Helper::getEscaped($this->_db, $this->_id);
         $this->_db->setQuery($query);
         $this->_data = $this->_db->loadObject();
     }
     return $this->_data;
 }
开发者ID:vstorm83,项目名称:propertease,代码行数:9,代码来源:email.php



注:本文中的FSSJ3Helper类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
PHP FSSRoute类代码示例发布时间:2022-05-23
下一篇:
PHP FSFile类代码示例发布时间:2022-05-23
热门推荐
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap