List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT COUNT(*) FROM " . icms::$xoopsDB->prefix("users") . " WHERE uid='" . $to_userid . "'" | 1 |
|
| "Select group to which activation mail will be sent" | 1 |
|
| "Update User" | 1 |
|
| "Update Group" | 1 |
|
| "Delete Group" | 1 |
|
| 'Show blocks visible in %s' | 1 |
|
| "Select your main language. If you activated the multilanguage, you can choice a language. And if you set in the multilanguage the language of your browser, than ImpressCMS will ignore this option." | 1 |
|
| "Select the level of strictness for username filtering" | 1 |
|
| "Select yes to customise session related values." | 1 |
|
| "Select group to which new user notification mail will be sent" | 1 |
|
| "Select activation type of newly registered users" | 1 |
|
| 'Select yes to display disclaimer in registration page' | 1 |
|
| 'Select Modules allowed to use this mimetype.' | 1 |
|
| 'Select yes to accept new user registration' | 1 |
|
| 'Select yes to turn your site off so that only users in selected groups have access to the site. ' | 1 |
|
| 'Select groups that are allowed to access while the site is turned off.' | 1 |
|
| "Show user and date in search results" | 1 |
|
| "Show modules with no match in search results" | 1 |
|
| "Select the default Editor for all the site." | 1 |
|
| "Select the selectable editors by the modules (If the module has a configuration to select the editor.)" | 1 |
|
| "Select the default page to be displayed to the user in Content Manager. Leave blank to have Content Manager default to the most recently created page." | 1 |
|
| "Select yes to display the Content Manager navigation menu." | 1 |
|
| "Select yes to display related pages links on Content Manager pages." | 1 |
|
| "Delete User" | 1 |
|
| "Select 'Yes' to enable this task." | 1 |
|
| "Select yes to show in the page informations about the poster and publish of the page." | 1 |
|
| "SELECT COUNT(*) FROM " . icms::$xoopsDB->prefix("xoopscomments") . " WHERE com_status=1" | 1 |
|
| 'SELECT pass FROM %s WHERE loginname = %s' | 1 |
|
| 'SELECT pass FROM %s WHERE login_name = %s' | 1 |
|
| 'SELECT pass FROM %s WHERE uname = %s' | 1 |
|
| 'SELECT version();' | 1 |
|
| 'SHOW TABLES FROM `' . env('DB_NAME') . "` LIKE '" . $this->name( ) . "'" | 1 |
|
| 'SHOW COLUMNS FROM ' . $this->name( ) | 1 |
|
| 'INSERT INTO %s VALUES %s' | 1 |
|
| 'UPDATE ' . $this->name( ) . ' SET ' . $set_clause | 1 |
|
| 'DELETE FROM ' . $this->table | 1 |
|
| 'Select a filter' | 1 |
|
| "SELECT COUNT(*) FROM " . icms::$xoopsDB->prefix("users") . " WHERE level=0" | 1 |
|
| 'Select a filter:' | 1 |
|
| "DELETE FROM %s WHERE (level = '0' AND user_regdate < '%s')" | 1 |
|
| 'Show only' | 1 |
|
| 'Update module' | 1 |
|
| "Update all" | 1 |
|
| "Select a file to upload: " | 1 |
|
| "Show admin groups" | 1 |
|
| "Select social bookmark providers to show" | 1 |
|
| 'Select groups for image manager use:<br /><br /><span style="font-weight: normal;">These are groups allowed to use the image manager for selecting images but not uploading. Webmaster has automatic access.</span>' | 1 |
|
| 'Select groups allowed to upload images:<br /><br /><span style="font-weight: normal;">Typical usage is for moderator and admin groups.</span>' | 1 |
|
| 'Delete Image Category' | 1 |
|
| "Show poster and published info?" | 1 |
|
| "Select yes to the value of menu title instead of the id in the url of the page." | 1 |
|
| 'SELECT enc_type FROM %s WHERE login_name = %s' | 1 |
|
| "SELECT uid FROM " . icms::$xoopsDB->prefix('users') . "" | 1 |
|
| "UPDATE %s SET code = %s, smile_url = %s, emotion = %s, display = %d WHERE id = '%d'" | 1 |
|
| "UPDATE %s SET code = %s, emotion = %s, display = '%d' WHERE id = '%d'" | 1 |
|
| "DELETE FROM %s WHERE id = '%u'" | 1 |
|
| "UPDATE " . icms::$xoopsDB->prefix('users') . " SET user_avatar='blank.gif' WHERE uid='" . $user_id . "'" | 1 |
|
| "UPDATE " . icms::$xoopsDB->prefix('users') . " SET user_avatar='blank.gif' WHERE user_avatar='" . $file . "'" | 1 |
|
| "SELECT * FROM " . $db->prefix("smiles") | 1 |
|
| "SELECT * FROM " . $db->prefix("smiles") . " WHERE id = '" . (int) $id . "'" | 1 |
|
| "SELECT COUNT(*) AS total FROM " . icms::$xoopsDB->prefix($table['table_name']) . ' ' . $criteria->renderWhere( ) | 1 |
|
| "UPDATE " . icms::$xoopsDB->prefix("users") . " SET posts = '" . (int) $total_posts . "' WHERE uid = '" . (int) $id . "'" | 1 |
|
| 'SELECT conf_id FROM `' . $this->prefix('config') . '` WHERE conf_name = \'debug_mode\' LIMIT 1' | 1 |
|
| "UPDATE " . $db->prefix('smiles') . " SET display='" . (int) $smiledisplay . "' WHERE id ='" . $smileid . "'" | 1 |
|
| 'SELECT COUNT(*) FROM `' . $usersTable . '`;' | 1 |
|
| 'SELECT COUNT(*) FROM `' . $dbm->prefix('block_module_link') . '`;' | 1 |
|
| 'SELECT bid, side, template FROM ' . $dbm->prefix('newblocks') | 1 |
|
| "SELECT * FROM " . icms::$xoopsDB->prefix("users") | 1 |
|
| "SELECT COUNT(DISTINCT " . (empty($alias) ? "" : $alias . ".") . "uid) FROM " . $subquery | 1 |
|
| "SELECT `$field` FROM `$table`" | 1 |
|
| "SELECT uname, email FROM " . $db->prefix('users') . " WHERE email = '" . @htmlspecialchars($email, ENT_QUOTES, _CHARSET) . "'" | 1 |
|
| 'SELECT invite_to, invite_date, register_id, extra_info FROM %s WHERE invite_code = %s AND register_id = 0' | 1 |
|
| 'UPDATE ' . icms::$xoopsDB->prefix('invites') . ' SET view_date = %d WHERE invite_code = %s AND register_id = 0' | 1 |
|
| 'SELECT invite_to, invite_date FROM %s WHERE invite_code = %s AND register_id = 0' | 1 |
|
| "INSERT INTO %s (id, code, smile_url, emotion, display) VALUES ('%d', %s, %s, %s, '%d')" | 1 |
|
| "UPDATE " . icms::$xoopsDB->prefix('users') . " SET level='1' WHERE uid='" . (int) $uid . "'" | 1 |
|
| 'Select yes to CAPTCHA (anti-spam) up on registration form.' | 1 |
|
| "Select allowed plugins to be used" | 1 |
|
| 'Select yes to add CAPTCHA (anti-spam) to the comments form, in order to avoid spamming.' | 1 |
|
| " Select an image to use in the top left corner of the admin panel. <br /><i>To select or send an image, at least one image category must be present in system > images</i> " | 1 |
|
| " Select an image to use in the top right corner of the admin panel. <br /><i>To select or send an image, at least one image category must be present in system > images</i> " | 1 |
|
| "Select which font will be used to generate the email address protection.<br /><i>This option only applies if 'Protect email addresses against SPAM?' is set to Yes.</i>" | 1 |
|
| "Show account images from members are hosted by <a href='http://www.gravatar.com/' target='_blank'>Gravatar</a>, a free avatar service. ImpressCMS will automatically display any Gravatar-hosted image linked to the email address from the members." | 1 |
|
| "Show ImpressCMS Project drop down menu?" | 1 |
|
| "Select NO to not show the drop down menu and YES to show it." | 1 |
|
| "Select groups which are not requiring a captcha. These groups will never see the captcha field." | 1 |
|
| 'Select the style of the paginations links.' | 1 |
|
| "Select the desired Module or Page for your start page by each group." | 1 |
|
| "Select plugin to be used for geshi" | 1 |
|
| "SELECT AVG(rate), COUNT(ratingid) FROM " . $this->table . " WHERE itemid=$itemid AND dirname='$dirname' AND item='$item' GROUP BY itemid" | 1 |
|
| "Select type of highlighter for the codes" | 1 |
|
| "Select 'yes' to enable the HTML Purifier filters, disabling this could leave your site vulnerable to attack if you allow your HTML content" | 1 |
|
| "Select the default Editor for editing source codes." | 1 |
|
| 'Select which plugins are used and available to be used throughout your site.' | 1 |
|
| "SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM " . icms::$xoopsDB->prefix("groups_users_link") . " l LEFT JOIN " . icms::$xoopsDB->prefix("users") . " u ON l.uid=u.uid LEFT JOIN " . icms::$xoopsDB->prefix("groups") . " g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid" | 1 |
|
| "SELECT types " . "FROM " . $this->table . " WHERE (mimetypeid='" | 1 |
|
| 'SELECT mimetypeid, dirname, types FROM ' . $this->table | 1 |
|
| "SELECT rank_image FROM " . $this->table | 1 |
|
| 'SELECT MIN(sat_interval) INTV FROM ' . $this->db->prefix('system_autotasks') . ' WHERE sat_enabled = TRUE LIMIT 1' | 1 |
|
| 'SELECT * FROM ' . $this->table . ' AS ' . $this->_itemname . ' INNER JOIN ' . $this->db->prefix('users') . ' AS user ON ' . $this->_itemname . '.uid=user.uid' | 1 |
|
| 'SELECT enc_type FROM %s WHERE uname = %s' | 1 |
|
| 'SELECT enc_type FROM %s WHERE loginname = %s' | 1 |
|
| 'SELECT COUNT(*) FROM %s WHERE email = %s' | 1 |
|
| "DELETE FROM %s WHERE avatar_id = '%u'" | 1 |
|
| "UPDATE %s SET module_id = '-1' WHERE module_id = '%u'" | 1 |
|
| 'SELECT tpl_source FROM ' . $this->handler->db->prefix('tplsource') . " WHERE tpl_id='" . $this->getVar('tpl_id') . "'" | 1 |
|
| "UPDATE %s SET read_msg = '1' WHERE msg_id = '%u'" | 1 |
|
| 'SELECT DISTINCT c.* FROM ' . $this->table . ' c LEFT JOIN ' . $this->db->prefix('group_permission') . ' l ON l.gperm_itemid=c.imgcat_id' | 1 |
|
| 'SELECT COUNT(*) FROM ' . $this->table . ' i LEFT JOIN ' . $this->db->prefix('group_permission') . ' l ON l.gperm_itemid=i.imgcat_id' | 1 |
|
| "UPDATE %s SET level = '-1', pass = '%s' WHERE uid = '%u'" | 1 |
|
| "UPDATE %s SET level= '-1', pass = %s" | 1 |
|
| 'SELECT uname, email FROM ' . $handler->table . " WHERE email = '" . (!empty($email) ? htmlspecialchars($email, ENT_QUOTES, _CHARSET) : '') . "'" | 1 |
|
| 'SELECT ' . ($usereal ? 'name' : 'uname') . ' FROM ' . $this->table . " WHERE userid = '" . $userid . "'" | 1 |
|
| 'SELECT a.*, COUNT(u.user_id) AS count FROM ' . $this->table . ' a LEFT JOIN ' . $this->db->prefix('avatar_user_link') . ' u ON u.avatar_id=a.avatar_id' | 1 |
|
| "DELETE FROM %s WHERE (module_id = '%u') AND (block_id = '%u')" | 1 |
|
| "DELETE FROM %s WHERE user_id = '%u'" | 1 |
|
| "INSERT INTO %s (avatar_id, user_id) VALUES ('%u', '%u')" | 1 |
|
| 'SELECT user_id FROM ' . $this->db->prefix('avatar_user_link') . " WHERE avatar_id='" . (int) $avatar->getVar('avatar_id') . "'" | 1 |
|
| "DELETE FROM %s WHERE imgset_id = '%u'" | 1 |
|
| 'SELECT DISTINCT i.* FROM %s i LEFT JOIN %s l ON l.imgset_id=i.imgset_id' | 1 |
|
| "INSERT INTO %s (imgset_id, tplset_name) VALUES ('%u', %s)" | 1 |
|
| "DELETE FROM %s WHERE imgset_id = '%u' AND tplset_name = %s" | 1 |
|
| 'SELECT * FROM ' . $this->db->prefix("newblocks") . "" . $where_query | 1 |
|
| 'SELECT * FROM ' . $this->db->prefix('newblocks') . $where_query | 1 |
|
| 'SELECT bid FROM ' . $this->db->prefix('newblocks') . $where_query | 1 |
|
| "UPDATE %s SET visible = '0' WHERE bid = '%u'" | 1 |
|
| "SELECT block_id FROM %s WHERE module_id != '%u' AND block_id = '%u'" | 1 |
|
| 'SELECT DISTINCT gperm_itemid FROM ' . $this->db->prefix('group_permission') . " WHERE gperm_name = 'block_read' AND gperm_modid = '1'" | 1 |
|
| "SHOW VARIABLES LIKE 'collation%'" | 1 |
|
| 'SELECT COUNT(*) FROM %s WHERE uname = %s' | 1 |
|
| "UPDATE %s SET user_avatar = %s WHERE uid = '%u'" | 1 |
|
| 'INSERT INTO ' . icms::$xoopsDB->prefix('invites') . ' (invite_code, from_id, invite_to, invite_date, extra_info) VALUES (%s, %d, %s, %d, %s)' | 1 |
|
| "SELECT * FROM " . icms::$xoopsDB->prefix("autosearch_list") . " s INNER JOIN " . icms::$xoopsDB->prefix("autosearch_cat") . " c ON s.cat_id = c.cid WHERE name LIKE '%" . $queryString . "%' ORDER BY cat_id LIMIT 8" | 1 |
|
| 'SELECT COUNT(*) FROM `' . $dbm->prefix('users') . '`;' | 1 |
|
| "SELECT * FROM " . icms::$xoopsDB->prefix("smiles") | 1 |
|
| "SHOW CHARSET" | 1 |
|
| 'SHOW COLLATION WHERE Charset=:cht' | 1 |
|
| "SHOW VARIABLES like 'character%'" | 1 |
|
| "Select another language not listed here." | 1 |
|
| "SELECT block_id FROM %s WHERE module_id = '%u'" | 1 |
|
| "Show my site" | 1 |
|
| 'Select modules to be installed' | 1 |
|
| 'Select modules visible to visitors' | 1 |
|
| 'INSERT INTO' | 1 |
|
| 'INSERT INTO `%s`(%s) VALUES' | 1 |
|
| 'SELECT 1 FROM ' . $this->db->prefix($table) | 1 |
|
| 'SELECT * FROM ' . icms::$xoopsDB->prefix('smiles') | 1 |
|
| 'DELETE FROM %s WHERE tplset_name = %s' | 1 |
|
| "DELETE FROM %s WHERE gperm_name = 'module_admin' AND gperm_itemid = '%u'" | 1 |
|
| "DELETE FROM %s WHERE gperm_name = 'module_read' AND gperm_itemid = '%u'" | 1 |
|
| 'SELECT module_id, page_id FROM ' . $this->db->prefix('block_module_link') . " WHERE block_id='" . (int) $obj->getVar('bid') . "'" | 1 |
|
| 'UPDATE ' . icms::$xoopsDB->prefix('invites') . ' SET register_id = %d WHERE invite_code = %s AND register_id = 0' | 1 |
|
| "SELECT salt FROM %s WHERE uname = %s" | 1 |
|
| ' SELECT COUNT(DISTINCT u.uid) ' . ' FROM ' . \icms::$xoopsDB->prefix('users') . ' AS u' . ' LEFT JOIN ' . \icms::$xoopsDB->prefix('groups_users_link') . ' AS m ON m.uid = u.uid' . " WHERE 1 = '1'" | 1 |
|
| 'DELETE FROM `' . $this->table . '` ' | 1 |
|
| 'DELETE FROM `' . $this->table . '` ' . $criteria->renderWhere(true) | 1 |
|
| 'UPDATE `%s` SET counter=:counter WHERE `%s`=:id' | 1 |
|
| 'SELECT ' . $this->id . ', ' . $title . ' FROM ' . $this->table . ' WHERE ' . $this->pid . "='0'" | 1 |
|
| 'SELECT uid, uname FROM ' . icms::$xoopsDB->prefix('users') . ' ORDER BY uname ASC' | 1 |
|
| 'SELECT loginname, email FROM ' . \icms::$xoopsDB->prefix('users') . " WHERE email = '" . @htmlspecialchars($email, ENT_QUOTES, _CHARSET) . "'" | 1 |
|
| 'SELECT login_name, email FROM ' . \icms::$xoopsDB->prefix('users') . " WHERE email = '" . @htmlspecialchars($email, ENT_QUOTES, _CHARSET) . "'" | 1 |
|
| " SELECT DISTINCT {$select} " . ' FROM ' . \icms::$xoopsDB->prefix('users') . ' AS u' . ' LEFT JOIN ' . \icms::$xoopsDB->prefix('groups_users_link') . ' AS m ON m.uid = u.uid' . " WHERE 1 = '1'" | 1 |
|
| 'SELECT COUNT(gperm_id) as total FROM ' . \icms::$xoopsDB->prefix('group_permission') . ' WHERE gperm_groupid=' . $group | 1 |
|
| 'SELECT ' . $field . 'COUNT(*) FROM ' . $this->table . ' AS ' . $this->_itemname | 1 |
|
| 'SELECT bid, name FROM ' . $db->prefix('newblocks') . ' WHERE mid=:mid AND func_num=:func_num AND show_func=:show_func AND func_file=:func_file' | 1 |
|
| 'UPDATE ' . $db->prefix(newblocks) . ' SET name=:name, edit_func=:edit_func, content=:content, template=:template, last_modified=:last_modified WHERE bid=:bid' | 1 |
|
| 'INSERT INTO ' . $db->prefix('block_module_link') . ' (block_id, module_id, page_id) VALUES (:bid, :mid, :pid);' | 1 |
|
| 'INSERT INTO `%s` (block_id, module_id, page_id) VALUES(%d, %d, %d);' | 1 |
|
| "SELECT pass_expired FROM %s WHERE loginname = %s" | 1 |
|
| "SELECT pass_expired FROM %s WHERE login_name = %s" | 1 |
|
| "SELECT pass_expired FROM %s WHERE uname = %s" | 1 |
|
| "SELECT salt FROM %s WHERE loginname = %s" | 1 |
|
| "SELECT salt FROM %s WHERE login_name = %s" | 1 |
|
| 'SELECT block_id, module_id, page_id FROM ' . $this->db->prefix('block_module_link') . ' WHERE block_id IN (' . implode(',', array_keys($ret)) . ') ORDER BY block_id' | 1 |
|
| 'UPDATE `' . $this->table . '` SET `' . $fieldname . '`=:fieldvalue' | 1 |
|
| 'SELECT COUNT(*)' | 1 |
|
| 'SELECT *' | 1 |
|
| 'SELECT DISTINCT(bid) from ' . $this->db->prefix('newblocks') | 1 |
|
| 'SELECT DISTINCT(p.gperm_itemid) from ' . $this->db->prefix('group_permission') . ' p, ' . $this->db->prefix('groups') . " g WHERE g.groupid=p.gperm_groupid AND p.gperm_name='block_read'" | 1 |
|
| "DELETE FROM %s WHERE block_id = '%u'" | 1 |
|
| "INSERT INTO " . $this->db->prefix('block_module_link') . " (block_id, module_id, page_id) VALUES ('" . (int) $obj->getVar("bid") . "', '" . (int) $mid . "', '" . (int) $pageid . "')" | 1 |
|
| 'INSERT INTO ' . $this->db->prefix('block_module_link') . " (block_id, module_id, page_id) VALUES ('" . (int) $obj->getVar("bid") . "', '" . (int) $mid . "', '" . (int) $pageid . "')" | 1 |
|
| 'SELECT rank_image FROM ' . $this->table | 1 |
|
| 'DELETE FROM %s WHERE image_id = %d' | 1 |
|
| 'SELECT i.*, b.image_body FROM ' . $this->table . ' i LEFT JOIN ' . $this->imagebody_handler->table . ' b ON b.image_id=i.image_id' | 1 |
|
| 'SELECT categoryid, parentid FROM ' . $this->table . ' AS ' . $this->_itemname . ' ORDER BY parentid' | 1 |
|
| 'SELECT tpl_source FROM ' . $this->table . " WHERE tpl_id='" . $tplfile->getVar('tpl_id') . "'" | 1 |
|
| 'SELECT tpl_module, COUNT(tpl_id) AS count FROM ' . $this->db->prefix('tplfile') . " WHERE tpl_tplset='" . $tplset . "' GROUP BY tpl_module" | 1 |
|
| 'SELECT groupid FROM ' . icms::$xoopsDB->prefix('groups_users_link') . " WHERE uid='" . (int) $uid . "'" | 1 |
|
| 'SELECT uid FROM ' . icms::$xoopsDB->prefix('groups_users_link') . " WHERE groupid='" . (int) $groupid . "'" | 1 |
|
| 'SELECT ' | 1 |
|
| 'SELECT ' . $this->getFields(true, true) . ' FROM `' . $this->table . '` AS ' . $this->_itemname | 1 |
|
| 'SELECT ' . (is_array($keyName) ? implode(', ', $keyName) : $keyName) | 1 |
|
| 'INSERT INTO `' . $this->table . '` (`' | 1 |
|
| 'UPDATE `' . $this->table . '` SET ' . "\r\n" | 1 |
|
| 'UPDATE `' . $this->table . '` SET' | 1 |
|
| 'UPDATE `' . $this->keyName . '` SET `' . $field . '` = `' . $field . '` ' . $math_func . ' ' . $value | 1 |
|
| 'SELECT ' . $this->pid . ', ' . $title . ' FROM ' . $this->table . ' WHERE ' . $this->id . '="' . $sel_id . '"' | 2 |
|
| 'SELECT ' . $this->pid . ' FROM ' . $this->table . ' WHERE ' . $this->id . '="' . $sel_id . '"' | 2 |
|
| 'SELECT ' . $this->id . ' FROM ' . $this->table . ' WHERE ' . $this->pid . '="' . $sel_id . '"' | 2 |
|
| "UPDATE %s SET pass = '%s', pass_expired = '%u' WHERE uid = '%u'" | 2 |
|
| 'SELECT b.* FROM ' . $this->db->prefix('newblocks') . ' b, ' . $this->db->prefix('block_module_link') . ' m WHERE m.block_id=b.bid' | 2 |
|
| 'SELECT * FROM ' . $this->table . ' WHERE ' . $this->pid . '="' . $sel_id . '"' | 3 |
|