/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_finder/helpers/indexer/driver/ |
H A D | mysql.php | 49 ->select($db->quoteName('link_id') . ', ' . $db->quoteName('md5sum')) 116 …$db->quoteName('url'), $db->quoteName('route'), $db->quoteName('title'), $db->quoteName('descripti… 117 …$db->quoteName('indexdate'), $db->quoteName('published'), $db->quoteName('state'), $db->quoteName(… 118 …$db->quoteName('language'), $db->quoteName('type_id'), $db->quoteName('object'), $db->quoteName('p… 119 …$db->quoteName('publish_end_date'), $db->quoteName('start_date'), $db->quoteName('end_date'), $db-… 120 $db->quoteName('sale_price') 288 ', ' . $db->quoteName('term') . 289 ', ' . $db->quoteName('stem') . 331 ' (' . $db->quoteName('term') . 332 ', ' . $db->quoteName('stem') . [all …]
|
H A D | sqlsrv.php | 49 ->select($db->quoteName('link_id') . ', ' . $db->quoteName('md5sum')) 116 …$db->quoteName('url'), $db->quoteName('route'), $db->quoteName('title'), $db->quoteName('descripti… 117 …$db->quoteName('indexdate'), $db->quoteName('published'), $db->quoteName('state'), $db->quoteName(… 118 …$db->quoteName('language'), $db->quoteName('type_id'), $db->quoteName('object'), $db->quoteName('p… 119 …$db->quoteName('publish_end_date'), $db->quoteName('start_date'), $db->quoteName('end_date'), $db-… 120 $db->quoteName('sale_price') 287 ', ' . $db->quoteName('term') . 288 ', ' . $db->quoteName('stem') . 329 ' (' . $db->quoteName('term') . 330 ', ' . $db->quoteName('stem') . [all …]
|
H A D | postgresql.php | 44 ->select($db->quoteName('link_id') . ', ' . $db->quoteName('md5sum')) 251 ', ' . $db->quoteName('term') . 252 ', ' . $db->quoteName('stem') . 253 ', ' . $db->quoteName('common') . 254 ', ' . $db->quoteName('phrase') . 303 ' (' . $db->quoteName('term') . 304 ', ' . $db->quoteName('stem') . 305 ', ' . $db->quoteName('common') . 306 ', ' . $db->quoteName('phrase') . 307 ', ' . $db->quoteName('weight') . [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_contact/models/ |
H A D | contacts.php | 159 $db->quoteName( 175 $db->quoteName('ul.email') 180 …$db->quoteName('#__users', 'ul') . ' ON ' . $db->quoteName('ul.id') . ' = ' . $db->quoteName('a.us… 188 …$db->quoteName('#__languages', 'l') . ' ON ' . $db->quoteName('l.lang_code') . ' = ' . $db->quoteN… 195 …$db->quoteName('#__users', 'uc') . ' ON ' . $db->quoteName('uc.id') . ' = ' . $db->quoteName('a.ch… 202 …$db->quoteName('#__viewlevels', 'ag') . ' ON ' . $db->quoteName('ag.id') . ' = ' . $db->quoteName(… 209 …$db->quoteName('#__categories', 'c') . ' ON ' . $db->quoteName('c.id') . ' = ' . $db->quoteName('a… 220 …->join('INNER', $db->quoteName('#__associations', 'asso2') . ' ON ' . $db->quoteName('asso1.key') … 223 $db->quoteName('asso1.id') . ' = ' . $db->quoteName('a.id'), 289 . ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id') [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_newsfeeds/models/ |
H A D | newsfeeds.php | 165 $query->from($db->quoteName('#__newsfeeds', 'a')); 169 ->select($db->quoteName('l.image', 'language_image')) 173 $query->select($db->quoteName('uc.name', 'editor')) 191 ->from($db->quoteName('#__associations', 'asso1')) 192 …->join('INNER', $db->quoteName('#__associations', 'asso2') . ' ON ' . $db->quoteName('asso1.key') … 195 $db->quoteName('asso1.id') . ' = ' . $db->quoteName('a.id'), 278 ->from($db->quoteName('#__contentitem_tag_map')) 289 . ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id') 296 $db->quoteName('#__contentitem_tag_map', 'tagmap') 297 . ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id') [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_modules/models/ |
H A D | modules.php | 283 $query->from($db->quoteName('#__modules', 'a')); 288 …->join('LEFT', $db->quoteName('#__languages', 'l') . ' ON ' . $db->quoteName('l.lang_code') . ' = … 292 …->join('LEFT', $db->quoteName('#__users', 'uc') . ' ON ' . $db->quoteName('uc.id') . ' = ' . $db->… 296 …->join('LEFT', $db->quoteName('#__viewlevels', 'ag') . ' ON ' . $db->quoteName('ag.id') . ' = ' . … 300 …->join('LEFT', $db->quoteName('#__modules_menu', 'mm') . ' ON ' . $db->quoteName('mm.moduleid') . … 303 $query->select($db->quoteName('e.name', 'name')) 304 …->join('LEFT', $db->quoteName('#__extensions', 'e') . ' ON ' . $db->quoteName('e.element') . ' = '… 371 ->from($db->quoteName('#__modules_menu')) 372 ->where($db->quoteName('moduleid') . ' = ' . $db->quoteName('a.id')); 377 ->from($db->quoteName('#__modules_menu')) [all …]
|
/dports/www/joomla3/joomla3-3.9.24/modules/mod_tags_similar/ |
H A D | helper.php | 67 $db->quoteName('m.core_content_id'), 68 $db->quoteName('m.content_item_id'), 69 $db->quoteName('m.type_alias'), 70 'COUNT( ' . $db->quoteName('tag_id') . ') AS ' . $db->quoteName('count'), 71 $db->quoteName('ct.router'), 72 $db->quoteName('cc.core_title'), 73 $db->quoteName('cc.core_alias'), 74 $db->quoteName('cc.core_catid'), 75 $db->quoteName('cc.core_language'), 76 $db->quoteName('cc.core_params'), [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_templates/models/ |
H A D | styles.php | 119 $query->from($db->quoteName('#__template_styles', 'a')) 120 ->where($db->quoteName('a.client_id') . ' = ' . $clientId); 124 …->join('LEFT', $db->quoteName('#__menu', 'm') . ' ON ' . $db->quoteName('m.template_style_id') . '… 128 …$query->join('LEFT', $db->quoteName('#__languages', 'l') . ' ON ' . $db->quoteName('l.lang_code') … 131 $query->select($db->quoteName('extension_id', 'e_id')) 133 ->where($db->quoteName('e.enabled') . ' = 1') 152 ->where($db->quoteName('m.id') . ' IS NULL'); 160 ->from($db->quoteName('#__menu')) 161 ->where($db->quoteName('id') . ' = ' . $menuItemId); 166 ->from($db->quoteName('#__menu')) [all …]
|
/dports/www/joomla3/joomla3-3.9.24/modules/mod_tags_popular/ |
H A D | helper.php | 42 'MAX(' . $db->quoteName('tag_id') . ') AS tag_id', 44 'MAX(' . $db->quoteName('t.access') . ') AS access', 45 'MAX(' . $db->quoteName('t.alias') . ') AS alias', 46 'MAX(' . $db->quoteName('t.params') . ') AS params', 50 ->from($db->quoteName('#__contentitem_tag_map', 'm')) 54 $query->where($db->quoteName('t.published') . ' = 1 '); 82 …$query->join('INNER', $db->quoteName('#__tags', 't') . ' ON ' . $db->quoteName('tag_id') . ' = t.i… 85 $query->where($db->quoteName('m.type_alias') . ' = ' . $db->quoteName('c.core_type_alias')); 88 $query->where($db->quoteName('c.core_state') . ' = 1') 89 …->where('(' . $db->quoteName('c.core_access') . ' IN (' . $groups . ') OR ' . $db->quoteName('c.co… [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/templates/hathor/postinstall/ |
H A D | hathormessage.php | 31 ->from($db->quoteName('#__template_styles')) 33 ->where($db->quoteName('client_id') . ' = 1'); 46 ->from($db->quoteName('#__template_styles')) 48 ->where($db->quoteName('client_id') . ' = 1'); 79 ->from($db->quoteName('#__template_styles')) 81 ->where($db->quoteName('client_id') . ' = 1'); 92 ->from($db->quoteName('#__template_styles')) 94 ->where($db->quoteName('client_id') . ' = 1'); 110 ->update($db->quoteName('#__template_styles')) 113 ->where($db->quoteName('client_id') . ' = 1'); [all …]
|
/dports/www/joomla3/joomla3-3.9.24/libraries/src/Table/ |
H A D | User.php | 84 ->from($this->_db->quoteName('#__users')) 104 ->select($this->_db->quoteName('g.id')) 105 ->select($this->_db->quoteName('g.title')) 147 ->select($this->_db->quoteName('id')) 148 ->select($this->_db->quoteName('title')) 231 ->select($this->_db->quoteName('id')) 232 ->from($this->_db->quoteName('#__users')) 248 ->select($this->_db->quoteName('id')) 269 ->select($this->_db->quoteName('id')) 369 ->columns(array($this->_db->quoteName('user_id'), $this->_db->quoteName('group_id'))); [all …]
|
/dports/www/joomla3/joomla3-3.9.24/installation/model/ |
H A D | configuration.php | 274 ->select($db->quoteName('id')) 299 $db->quoteName('id'), $db->quoteName('name'), 300 $db->quoteName('username'), 301 $db->quoteName('email'), 302 $db->quoteName('password'), 303 $db->quoteName('block'), 304 $db->quoteName('sendEmail'), 305 $db->quoteName('registerDate'), 307 $db->quoteName('activation'), 308 $db->quoteName('params') [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_finder/helpers/indexer/ |
H A D | taxonomy.php | 59 ->from($db->quoteName('#__finder_taxonomy')) 60 ->where($db->quoteName('parent_id') . ' = 1') 139 ->from($db->quoteName('#__finder_taxonomy')) 208 ->select($db->quoteName('link_id')) 249 ->select($db->quoteName('title')) 250 ->from($db->quoteName('#__finder_taxonomy')) 251 ->where($db->quoteName('parent_id') . ' = 1') 252 ->where($db->quoteName('state') . ' = 1') 336 $subquery1->select($db->quoteName('t.id')) 338 …->join('LEFT', $db->quoteName('#__finder_taxonomy_map', 'm') . ' ON ' . $db->quoteName('m.node_id'… [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_privacy/models/ |
H A D | dashboard.php | 62 $db->quoteName('status'), 63 $db->quoteName('request_type'), 66 ->from($db->quoteName('#__privacy_requests')) 67 ->group($db->quoteName('status')) 68 ->group($db->quoteName('request_type')); 92 …->select($db->quoteName('id') . ', ' . $db->quoteName('published') . ', ' . $db->quoteName('langua… 93 ->from($db->quoteName('#__menu')) 94 ->where($db->quoteName('client_id') . ' = 0') 134 ->select($db->quoteName('id')) 135 ->from($db->quoteName('#__menu')) [all …]
|
H A D | consents.php | 60 $query->from($db->quoteName('#__privacy_consents', 'a')); 63 $query->select($db->quoteName('u.username', 'username')); 90 $query->where($db->quoteName('a.state') . ' = ' . (int) $state); 180 ->update($db->quoteName('#__privacy_consents')) 181 ->set($db->quoteName('state') . ' = -1') 182 ->where($db->quoteName('id') . ' IN (' . implode(',', $pks) . ')') 183 ->where($db->quoteName('state') . ' = 1'); 210 ->update($db->quoteName('#__privacy_consents')) 211 ->set($db->quoteName('state') . ' = -1') 212 ->where($db->quoteName('subject') . ' = ' . $db->quote($subject)) [all …]
|
/dports/www/joomla3/joomla3-3.9.24/libraries/src/Language/ |
H A D | Associations.php | 56 ->select($db->quoteName('c2.language')) 57 ->from($db->quoteName($tablename, 'c')) 58 …->join('INNER', $db->quoteName('#__associations', 'a') . ' ON a.id = c.' . $db->quoteName($pk) . '… 59 …->join('INNER', $db->quoteName('#__associations', 'a2') . ' ON ' . $db->quoteName('a.key') . ' = '… 60 …->join('INNER', $db->quoteName($tablename, 'c2') . ' ON a2.id = c2.' . $db->quoteName($pk) . $cate… 68 $db->quoteName('c2.' . $pk), 69 $db->quoteName('c2.' . $aliasField), 72 ) . ' AS ' . $db->quoteName($pk) 77 $query->select($db->quoteName('c2.' . $pk)); 85 …$db->quoteName('#__categories', 'ca') . ' ON ' . $db->quoteName('c2.' . $catField) . ' = ca.id AND… [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_redirect/models/ |
H A D | links.php | 144 $query->from($db->quoteName('#__redirect_links', 'a')); 155 $query->where($db->quoteName('a.published') . ' IN (0,1)'); 177 '(' . $db->quoteName('old_url') . ' LIKE ' . $search . 207 $db->quoteName('old_url'), 208 $db->quoteName('new_url'), 209 $db->quoteName('referer'), 210 $db->quoteName('comment'), 211 $db->quoteName('hits'), 212 $db->quoteName('published'), 213 $db->quoteName('created_date') [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_finder/models/ |
H A D | index.php | 178 ->select($db->quoteName('t.title', 't_title')) 179 ->from($db->quoteName('#__finder_links', 'l')) 180 …->join('INNER', $db->quoteName('#__finder_types', 't') . ' ON ' . $db->quoteName('t.id') . ' = ' .… 195 …ery->join('INNER', $db->quoteName('#__finder_taxonomy_map', 'm') . ' ON ' . $db->quoteName('m.link… 213 …$orSearchSql = $db->quoteName('l.title') . ' LIKE ' . $search . ' OR ' . $db->quoteName('l.url') .… 230 …$ordering = $db->quoteName('t.title') . ' ' . $db->escape($listDir) . ', ' . $db->quoteName('l.tit… 254 ->from($db->quoteName('#__extensions')) 255 ->where($db->quoteName('type') . ' = ' . $db->quote('plugin')) 299 ->from($db->quoteName('#__finder_links')); 355 ->delete($db->quoteName('#__finder_taxonomy')) [all …]
|
H A D | filters.php | 58 ->from($db->quoteName('#__finder_filters', 'a')); 61 $query->select($db->quoteName('uc.name', 'editor')) 62 …->join('LEFT', $db->quoteName('#__users', 'uc') . ' ON ' . $db->quoteName('uc.id') . ' = ' . $db->… 65 $query->select($db->quoteName('ua.name', 'user_name')) 66 …->join('LEFT', $db->quoteName('#__users', 'ua') . ' ON ' . $db->quoteName('ua.id') . ' = ' . $db->… 72 $query->where($db->quoteName('a.title') . ' LIKE ' . $search); 80 $query->where($db->quoteName('a.state') . ' = ' . (int) $state);
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_banners/models/ |
H A D | banners.php | 72 ->select('MAX(ordering) as ' . $db->quoteName('max') . ', catid') 118 $query->from($db->quoteName('#__banners', 'a')); 125 $query->select($db->quoteName('uc.name', 'editor')) 129 $query->select($db->quoteName('c.title', 'category_title')) 133 $query->select($db->quoteName('cl.name', 'client_name')) 134 ->select($db->quoteName('cl.purchase_type', 'client_purchase_type')) 142 $query->where($db->quoteName('a.state') . ' = ' . (int) $published); 146 $query->where($db->quoteName('a.state') . ' IN (0, 1)'); 154 $query->where($db->quoteName('a.catid') . ' = ' . (int) $categoryId); 162 $query->where($db->quoteName('a.cid') . ' = ' . (int) $clientId); [all …]
|
H A D | tracks.php | 103 ->select($db->quoteName('b.name', 'banner_name')) 104 ->select($db->quoteName('cl.name', 'client_name')) 105 ->select($db->quoteName('c.title', 'category_title')); 108 $query->from($db->quoteName('#__banner_tracks', 'a')); 111 …$query->join('LEFT', $db->quoteName('#__banners', 'b') . ' ON ' . $db->quoteName('b.id') . ' = ' .… 114 …$query->join('LEFT', $db->quoteName('#__banner_clients', 'cl') . ' ON ' . $db->quoteName('cl.id') … 117 …$query->join('LEFT', $db->quoteName('#__categories', 'c') . ' ON ' . $db->quoteName('c.id') . ' = … 206 ->delete($db->quoteName('#__banner_tracks')); 383 ->from($db->quoteName('#__categories')) 420 ->from($db->quoteName('#__banner_clients')) [all …]
|
/dports/www/joomla3/joomla3-3.9.24/libraries/src/Helper/ |
H A D | TagsHelper.php | 81 $db->quoteName('type_alias'), 82 $db->quoteName('core_content_id'), 83 $db->quoteName('content_item_id'), 84 $db->quoteName('tag_id'), 85 $db->quoteName('tag_date'), 86 $db->quoteName('type_id'), 451 …$query->join('INNER', $db->quoteName('#__tags') . ' AS t ' . ' ON ' . $db->quoteName('m.tag_id') .… 494 ->select($db->quoteName('t.id')) 498 . ' ON ' . $db->quoteName('m.tag_id') . ' = ' . $db->quoteName('t.id') 684 ->select($db->quoteName('title')) [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_content/models/ |
H A D | articles.php | 233 ->select('COUNT(' . $db->quoteName('asso1.id') . ') > 1') 234 ->from($db->quoteName('#__associations', 'asso1')) 235 …->join('INNER', $db->quoteName('#__associations', 'asso2') . ' ON ' . $db->quoteName('asso1.key') … 238 $db->quoteName('asso1.id') . ' = ' . $db->quoteName('a.id'), 375 ->from($db->quoteName('#__contentitem_tag_map')) 385 '(' . $subQuery . ') AS ' . $db->quoteName('tagmap') 386 . ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id') 393 $db->quoteName('#__contentitem_tag_map', 'tagmap') 394 . ' ON ' . $db->quoteName('tagmap.content_item_id') . ' = ' . $db->quoteName('a.id') 398 $db->quoteName('tagmap.tag_id') . ' = ' . $tag, [all …]
|
/dports/www/joomla3/joomla3-3.9.24/plugins/authentication/cookie/ |
H A D | cookie.php | 111 ->where($this->db->quoteName('time') . ' < ' . $this->db->quote(time())); 125 ->from($this->db->quoteName('#__user_keys')) 128 ->order($this->db->quoteName('time') . ' DESC'); 188 ->select($this->db->quoteName(array('id', 'username', 'password'))) 189 ->from($this->db->quoteName('#__users')) 191 ->where($this->db->quoteName('requireReset') . ' = 0'); 283 ->select($this->db->quoteName('series')) 284 ->from($this->db->quoteName('#__user_keys')) 340 ->insert($this->db->quoteName('#__user_keys')) 344 ->set($this->db->quoteName('time') . ' = ' . (time() + $lifetime)); [all …]
|
/dports/www/joomla3/joomla3-3.9.24/administrator/components/com_finder/models/fields/ |
H A D | contentmap.php | 48 ->select($db->quoteName('id')) 49 ->from($db->quoteName('#__finder_taxonomy')) 50 ->where($db->quoteName('parent_id') . ' = 1'); 53 ->select($db->quoteName('a.id')) 54 ->from($db->quoteName('#__finder_taxonomy', 'a')) 56 ->where($db->quoteName('a.parent_id') . ' NOT IN (0, 1)'); 62 ->select($db->quoteName('a.title', 'text')) 63 ->select($db->quoteName('a.id', 'value')) 64 ->select($db->quoteName('d.level')) 65 ->from($db->quoteName('#__finder_taxonomy', 'a')) [all …]
|