List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "INSERT INTO activitiesattendees SET activityId = " . $this->id | 1 |
|
| "SELECT ThreadVisibility FROM forums_threads WHERE id = " . intval($IdThread) | 1 |
|
| 'SELECT `id` FROM `mod_user_apps` WHERE `name` = \'' . $this->dao->escape($appName) . '\'' | 1 |
|
| 'UPDATE `mod_user_rights` SET `has_implied` = 1 WHERE `id` = ?' | 1 |
|
| 'INSERT INTO `mod_user_implications` (`right_id`, `implies_id`) VALUES (?, ?)' | 1 |
|
| ' SELECT `right_id` FROM `mod_user_implications` WHERE `right_id` = ' . (int) $rightId . ' AND `implies_id` = ' . (int) $impliesId | 1 |
|
| ' INSERT INTO `mod_user_grouprights` (`group_id`, `right_id`) VALUES ( ' . (int) $groupId . ', ' . (int) $rightId . ' )' | 1 |
|
| ' SELECT `group_id` FROM `mod_user_grouprights` WHERE `group_id` = ' . (int) $groupId . ' AND `right_id` = ' . (int) $rightId . ' ' | 1 |
|
| ' INSERT INTO `mod_user_authgroups` (`id`, `name`) VALUES ( ' . $this->dao->nextId('mod_user_authgroups') . ', \'' . $this->dao->escape($group) . '\' )' | 1 |
|
| ' INSERT INTO `mod_user_apps` (`id`, `name`) VALUES ( ' . $this->dao->nextId('mod_user_apps') . ', \'' . $this->dao->escape($name) . '\' )' | 1 |
|
| "SELECT FOUND_ROWS() AS `found_rows`" | 1 |
|
| "SELECT SQL_CALC_FOUND_ROWS `forums_threads`.`id`, `forums_threads`.`id` as IdThread, `forums_threads`.`title`, `forums_threads`.`IdTitle`, `forums_threads`.`IdGroup`, `forums_threads`.`replies`, `forums_threads`.`stickyvalue`, `groups`.`Name` as `GroupName`, `ThreadVisibility`, `ThreadDeleted`, `forums_threads`.`views`, `first`.`id` AS `first_postid`, `first`.`idWriter` AS `first_authorid`, UNIX_TIMESTAMP(`first`.`create_time`) AS `first_create_time`, UNIX_TIMESTAMP(`last`.`create_time`) AS `last_create_time`, `last`.`id` AS `last_postid`, `last`.`idWriter` AS `last_authorid`, UNIX_TIMESTAMP(`last`.`create_time`) AS `last_create_time`," | 1 |
|
| "SELECT COUNT(*) AS `number` FROM `forums_threads` WHERE 1 " . $wherethread | 1 |
|
| "SELECT IdGroup FROM membersgroups WHERE IdMember=" . $this->session->get("IdMember") . " AND Status = 'In'" | 1 |
|
| "SELECT PostVisibility FROM forums_posts WHERE id = " . intval($IdPost) | 1 |
|
| "select members_threads_subscribed.id as IdSubscribe,IdThread,IdSubscriber from members_threads_subscribed where IdThread=%d and IdSubscriber=%d" | 1 |
|
| 'INSERT INTO `mod_user_auth` (`id`, `name`) VALUES (?, ?)' | 1 |
|
| "select members_groups_subscribed.id as IdSubscribe,IdThread,IdSubscriber from members_groups_subscribed where IdGroup=%d and IdSubscriber=%d" | 1 |
|
| " INSERT INTO posts_notificationqueue ( `IdMember`, `IdPost`, `Status`, `created`, `Type`, `TableSubscription`, `IdSubscription` ) VALUES " | 1 |
|
| " INSERT INTO posts_notificationqueue ( `IdMember`, `IdPost`, `Status`, `created`, `Type`, `TableSubscription`, `IdSubscription` ) VALUES " | 1 |
|
| "select groups.id as IdGroup,Name,count(*) as cnt from groups,membersgroups,members WHERE membersgroups.IdGroup=groups.id and members.id=membersgroups.IdMember and members.Status in ('Active','ActiveHidden') and members.id=" . $this->session->get('IdMember') . " and membersgroups.Status='In' group by groups.id order by groups.id " | 1 |
|
| "select groups.id as IdGroup,Name,count(*) as cnt from groups,membersgroups WHERE membersgroups.IdGroup=groups.id group by groups.id order by Name " | 1 |
|
| "select id as IdLanguage,Name,EnglishName,ShortCode,WordCode from languages where id>0" . " AND IsWrittenLanguage = 1" | 1 |
|
| "select id as IdLanguage,Name,EnglishName,ShortCode,WordCode from languages where id=" . ($IdLanguage) . " AND IsWrittenLanguage = 1" | 1 |
|
| "select `IdContent` from `forums_posts` where `id`=" . $this->messageId | 1 |
|
| "select forum_trads.IdLanguage,UNIX_TIMESTAMP(forum_trads.created) as trad_created, UNIX_TIMESTAMP(forum_trads.updated) as trad_updated, forum_trads.Sentence,IdOwner,IdTranslator,languages.ShortCode,languages.EnglishName,mTranslator.Username as TranslatorUsername ,mOwner.Username as OwnerUsername from forum_trads,languages,members as mOwner,members as mTranslator where languages.id=forum_trads.IdLanguage and forum_trads.IdTrad=" . $row->IdContent . " and mTranslator.id=IdTranslator and mOwner.id=IdOwner order by forum_trads.id asc" | 1 |
|
| "SELECT `forums_posts`.`id` AS `postid`,`forums_posts`.`id` as IdPost, UNIX_TIMESTAMP(`create_time`) AS `posttime`, `message`, `OwnerCanStillEdit`,`IdContent`, `forums_threads`.`id` AS `threadid`, `forums_threads`.`title`, `ThreadVisibility`, `ThreadDeleted`, `PostVisibility`, `PostDeleted`, `ThreadDeleted`, `forums_threads`.`IdTitle`,`forums_threads`.`IdGroup`, `IdWriter`, `members`.`Username` AS `OwnerUsername`, `groups`.`Name` AS `GroupName`, `geonames`.`country` FROM (forums_posts, members, forums_threads, addresses) LEFT JOIN `groups` ON (`forums_threads`.`IdGroup` = `groups`.`id`) LEFT JOIN `geonames` ON (addresses.IdCity = geonames.geonameId) WHERE `forums_posts`.`IdWriter` = %d AND `forums_posts`.`IdWriter` = `members`.`id` AND `forums_posts`.`threadid` = `forums_threads`.`id` AND addresses.IdMember = members.id AND addresses.rank = 0 AND ($this->PublicThreadVisibility) AND ($this->PublicPostVisibility) AND ($this->PostGroupsRestriction) ORDER BY `posttime` DESC" | 1 |
|
| "INSERT INTO members_threads_subscribed(IdThread,IdSubscriber,UnSubscribeKey,notificationsEnabled) VALUES(" . $IdThread . "," . $this->session->get("IdMember") . ",'" . $this->dao->escape($key) . "', 1)" | 1 |
|
| "select forum_trads.IdLanguage,UNIX_TIMESTAMP(forum_trads.created) as trad_created, UNIX_TIMESTAMP(forum_trads.updated) as trad_updated, forum_trads.Sentence,IdOwner,IdTranslator,languages.ShortCode,languages.EnglishName,mTranslator.Username as TranslatorUsername ,mOwner.Username as OwnerUsername from forum_trads,languages,members as mOwner, members as mTranslator where languages.id=forum_trads.IdLanguage and forum_trads.IdTrad=" . $row->IdContent . " and mOwner.id=IdOwner and mTranslator.id=IdTranslator order by forum_trads.id asc" | 1 |
|
| " UPDATE `forums_threads` SET `views` = (`views` + 1) WHERE `id` = '$this->threadid' LIMIT 1 " | 1 |
|
| "select forum_trads.IdLanguage,UNIX_TIMESTAMP(forum_trads.created) as trad_created, UNIX_TIMESTAMP(forum_trads.updated) as trad_updated, forum_trads.Sentence,IdOwner,IdTranslator,languages.ShortCode,languages.EnglishName,mTranslator.Username as TranslatorUsername ,mOwner.Username as OwnerUsername from forum_trads,languages,members as mOwner, members as mTranslator where languages.id=forum_trads.IdLanguage and forum_trads.IdTrad=" . $row->IdContent . " and mOwner.id=IdOwner and mTranslator.id=IdTranslator order by forum_trads.id asc" | 1 |
|
| 'SELECT `id` FROM `mod_user_auth` WHERE `name` = \'' . $this->dao->escape($authName) . '\'' | 1 |
|
| ' INSERT INTO `mod_user_rights` (`id`, `app_id`, `name`, `has_implied`, `level`) VALUES ( ' . $this->dao->nextId('mod_user_rights') . ', ' . (int) $appId . ', \'' . $right['name'] . '\', 0, ' . (int) $level . ' )' | 1 |
|
| " INSERT INTO `forums_threads` ( `title`, `first_postid`, `last_postid`, `IdFirstLanguageUsed`,`IdGroup`,`ThreadVisibility`) VALUES (?, ?, ?, ?, ?, ?) " | 1 |
|
| ' SELECT SQL_CACHE Scope as Scope, Level FROM ' . $this->nomtablevolunteer . ', ' . $this->nomtable . ' WHERE IdMember=' . $IdMember . ' AND ' . $this->nomtable . '.id=' . $this->nomtablevolunteer . '.' . $this->IdName . ' AND ' . $this->nomtable . '.Name=\'' . $Name . '\'' | 1 |
|
| " SELECT SQL_CACHE name FROM geonames_cache WHERE fcode = 'PPL' AND geonameId = $placeID LIMIT 1 " | 1 |
|
| " SELECT SQL_CACHE geonameId AS id FROM geonames_cache WHERE name = '$placeNameEscaped' AND fcode = 'PPL' " | 1 |
|
| " SELECT SQL_CACHE geonameId AS id, name FROM geonames_cache WHERE fcode LIKE 'PCL%' ORDER BY name " | 1 |
|
| "
DELETE FROM `geonamesalternatenames` WHERE alternatenameid = '" . $this->dao->escape($delete[0]) . "' AND geonameId = '" . $this->dao->escape($delete[1]) . "'" | 1 |
|
| "
DELETE FROM `geonames` WHERE geonameId = '" . $this->dao->escape($delete[0]) . "'" | 1 |
|
| "delete from online where IdMember=" . $this->session->get('IdMember') | 1 |
|
| ' UPDATE `user` SET `auth_id`=' . (int) $authId . ', `pw`=\'' . $this->dao->escape($pwenc) . '\' WHERE `handle`=\'' . $this->dao->escape($handle) . '\' ' | 1 |
|
| "SELECT memberspreferences.Value,ShortCode FROM memberspreferences,languages WHERE IdMember=" . $this->session->get('IdMember') . " AND IdPreference=1 AND memberspreferences.Value=languages.id" | 1 |
|
| "UPDATE members SET LogCount=LogCount+1,LastLogin=now(),NbRemindWithoutLogingIn=0 WHERE id=" . $this->session->get('IdMember') | 1 |
|
| "SELECT * FROM members WHERE Username='" . $handle . "'" | 1 |
|
| "UPDATE members SET Status='Active' WHERE members.id=" . $m->id . " AND Status='OutOfRemind'" | 1 |
|
| "select password('" . $this->dao->escape($password) . "') as PassMysqlEncrypted" | 1 |
|
| "SELECT id,Status,Username,PassWord FROM members WHERE Username='" . $Username . "'" | 1 |
|
| ' SELECT SQL_CACHE Level FROM ' . $this->nomtablevolunteer . ' WHERE IdMember=' . $this->session->get('IdMember') | 1 |
|
| " SELECT DISTINCT memberstrads.IdLanguage, languages.ShortCode FROM memberstrads, languages WHERE memberstrads.IdLanguage = languages.id AND IdOwner = $idMember " | 1 |
|
| 'SELECT `id` FROM `mod_user_authgroups` WHERE `name` = \'' . $this->dao->escape($group) . '\'' | 1 |
|
| 'UPDATE `' . $this->tableName . '` SET `lastlogin` = NOW() WHERE `id` = ?' | 1 |
|
| 'SELECT DefaultValue ' . 'FROM preferences ' . "WHERE preferences.codeName='$preference_name' " | 1 |
|
| 'SELECT memberspreferences.Value as value ' . 'FROM preferences,memberspreferences ' . "WHERE memberspreferences.IdMember='$this->_userId' " . "AND preferences.codeName='$preference_name' " . 'AND memberspreferences.IdMember=preferences.id' | 1 |
|
| 'SELECT DefaultValue ' . 'FROM preferences ' . "WHERE preferences.id='$preference_id' " | 1 |
|
| 'SELECT memberspreferences.Value as value ' . 'FROM preferences,memberspreferences ' . "WHERE memberspreferences.IdMember='$this->_userId' " . "AND preferences.id='$preference_id' " . "AND memberspreferences.IdMember='$preference_id'" | 1 |
|
| 'SELECT ' . 'FROM memberspublicprofiles ' . "WHERE IdMember='$_userId' " | 1 |
|
| 'SELECT ' . $select_string . ' ' . 'FROM members ' . "WHERE id='$this->_userId' " | 1 |
|
| 'SELECT `id` FROM `user` WHERE `handle` = \'' . $this->_username . '\'' | 1 |
|
| 'SELECT `Username` FROM `members` WHERE `id` = \'' . $c->escape($userId) . '\'' | 1 |
|
| 'SELECT SQL_CACHE Username ' . 'FROM members ' . "WHERE id='$userId' " | 1 |
|
| 'SELECT SQL_CACHE id ' . 'FROM members ' . "WHERE Username='$username' " | 1 |
|
| "SELECT username FROM members WHERE id = " . intval($user_id) | 1 |
|
| ' SELECT r.`id` AS id, r.`name` AS name, r.`level` AS level, a.`id` AS app_id, a.`name` AS app_name FROM `mod_user_rights` AS r LEFT JOIN `mod_user_apps` AS a ON a.`id` = r.`app_id` WHERE r.`name` = \'' . $this->dao->escape($right['name']) . '\' AND a.`name` = \'' . $this->dao->escape($right['app']) . '\' ' | 1 |
|
| ' SELECT r.`id` AS id, r.`name` AS name, r.`level` AS level, a.`id` AS app_id, a.`name` AS app_name FROM `mod_user_rights` AS r LEFT JOIN `mod_user_apps` AS a ON a.`id` = r.`app_id` WHERE r.`name` = \'' . $this->dao->escape($right['name']) . '\' AND a.`name` IS NULL ' | 1 |
|
| "UPDATE `forums_posts` SET `threadId` = ? WHERE `Id` = ?" | 1 |
|
| " INSERT INTO `forums_posts` ( `create_time`, `message`,`IdWriter`,`IdFirstLanguageUsed`,`PostVisibility`) VALUES (NOW(), ?, ?, ?, ?) " | 1 |
|
| '
SELECT SQL_CACHE created FROM `words` WHERE `IdLanguage`=0 and `code`=\'' . $wordcode . '\'' | 1 |
|
| "select `IdContent` FROM `forums_posts` WHERE `id`=" . $IdPost | 1 |
|
| "update forums_posts set message='" . $this->dao->escape($this->cleanupText($vars['topic_text'])) . "' where id=" . $this->messageId | 1 |
|
| "UPDATE `forums_posts` SET `message` = '%s', `last_edittime` = NOW(), `last_editorid` = '%d', `edit_count` = `edit_count` + 1 WHERE `id` = '%d'" | 1 |
|
| "SELECT message,forums_posts.threadid, `PostVisibility`, OwnerCanStillEdit,IdWriter,forums_posts.IdFirstLanguageUsed as post_IdFirstLanguageUsed,forums_threads.IdFirstLanguageUsed as thread_IdFirstLanguageUsed,forums_posts.id,IdWriter,IdContent,forums_threads.IdTitle,forums_threads.first_postid from `forums_posts`,`forums_threads` WHERE forums_posts.threadid=forums_threads.id and forums_posts.id = " . $this->messageId | 1 |
|
| "update forum_trads set Sentence='" . $Sentence . "',IdLanguage=" . $IdLanguage . ",IdTranslator=" . $this->session->get("IdMember") . " where id=" . $id | 1 |
|
| "select * from forum_trads where id=" . $id | 1 |
|
| "SELECT `Name` FROM `groups` WHERE `id` = " . (int) $this->IdGroup | 1 |
|
| " INSERT INTO memberspreferences( created, IdPreference, IdMember, Value ) VALUES( now(), " . $preference->id . "," . $this->session->get('IdMember') . ", '" . $this->ShowMyGroupsTopicsOnly . "' )" | 1 |
|
| " UPDATE memberspreferences SET Value='" . $this->dao->escape($this->ForumOrderList) . "' WHERE id= " . $row->id | 1 |
|
| " INSERT INTO memberspreferences (`created`, `updated`, `IdPreference`, `IdMember`, `Value`) VALUES (NOW(), `created`, " . $idPreference . ", " . $idMember . ", '" . $this->dao->escape($this->ForumOrderList) . "' ) " | 1 |
|
| "SELECT mp.value, mp.id FROM memberspreferences mp WHERE mp.IdMember = " . $idMember . " AND mp.IdPreference = " . $idPreference | 1 |
|
| "SELECT id FROM preferences WHERE codename ='PreferenceForumOrderListAsc'" | 1 |
|
| "SELECT IdGroup FROM membersgroups WHERE IdMember = " . $this->session->get("IdMember") . " AND Status = 'In'" | 1 |
|
| "SELECT `IdLanguage` FROM `forum_trads` WHERE `IdTrad`=" . $IdTrad . " order by id asc limit 1" | 1 |
|
| "SELECT IdLanguage FROM `forum_trads` WHERE `IdTrad`=" . $IdTrad . " and `IdLanguage`=" . $this->session->get("IdLanguage") | 1 |
|
| ' INSERT INTO `donations` ( `IdMember`,`Email`,`StatusPrivate`,`created`,`Amount`,`Money`,`IdCountry`,`namegiven`,`referencepaypal`,`membercomment`,`SystemComment` ) VALUES (' . $IdMember . ',"' . $receiver_email . '","showamountonly",now(),' . $payment_amount . ',"' . $payment_currency . '",' . $IdCountry . ',"' . $keyarray["first_name"] . ' ' . $keyarray["last_name"] . '","' . $referencepaypal . '","","Via paypal' . ' ' . $keyarray["payment_status"] . ' ' . $memo . '") ' | 1 |
|
| "update forums_threads set IdGroup=" . $groupId . ",title='" . $this->dao->escape($this->cleanupText($vars['topic_title'])) . "' where forums_threads.id=" . $rBefore->threadid | 1 |
|
| ' SELECT * FROM donations WHERE IdMember=' . $IdMember . ' AND referencepaypal LIKE "%' . $referencepaypal . '%"' | 1 |
|
| "select languages.Name as Name,words.ShortCode from words,languages where words.code='BroadCast_Body_" . $OneLetter->Name . "' and languages.id=words.IdLanguage" | 1 |
|
| "select * from broadcast where Status='Triggered' and type='Normal' order by created desc" | 1 |
|
| "select count(*) as cnt from broadcastmessages where IdBroadCast=" . $BroadCast->id . " and Status='ToSend'" | 1 |
|
| "select count(*) as cnt from broadcastmessages where IdBroadCast=" . $BroadCast->id . " and Status='Send'" | 1 |
|
| "select languages.Name as Name,words.ShortCode,words.Sentence from words,languages where words.code='BroadCast_Body_" . $LetterName . "' and languages.id=words.IdLanguage" | 1 |
|
| "select * from broadcast where Name='" . $this->dao->escape($LetterName) . "'" | 1 |
|
| " SELECT SQL_CACHE l.Name AS Name, l.ShortCode AS ShortCode, l.WordCode AS WordCode, l.id AS id FROM languages AS l " | 1 |
|
| "UPDATE `hosting_eagerness_slider` SET `member_id` = {$member->id}, `endDate` = '{$hesEnddate}', `step` = {$step}, `remaining` = {$duration}, `current` = {$current}, `initialized` = NOW(), `updated` = NOW() WHERE `id` = {$hesId}" | 1 |
|
| "SELECT COUNT(*) FROM activities AS a, activitiesattendees AS aa WHERE a.id = aa.activityId AND aa.attendeeId = " . $member->id | 1 |
|
| "DELETE FROM `hosting_eagerness_slider` WHERE `member_id` = {$member->id}" | 1 |
|
| "SELECT `id`, DATE_FORMAT(`enddate`, '%Y-%m-%d') AS `enddate`, `step` FROM `hosting_eagerness_slider` WHERE `member_id` = " . $member->id | 1 |
|
| " DELETE FROM memberslanguageslevel WHERE IdMember = :memberId " | 1 |
|
| " DELETE FROM memberstrads WHERE IdOwner = :memberId AND IdTrad IN ( '" . implode("', '", $tradIds) . "' ) " | 1 |
|
| "update forums_posts set PostVisibility='" . $vars['PostVisibility'] . "' where id=" . $this->messageId | 1 |
|
| " UPDATE `forums_threads` SET `title` = '%s' WHERE `id` = '%d' " | 1 |
|
| " UPDATE `forums_threads` SET `last_postid` = '$postid', `replies` = `replies` + 1 WHERE `id` = '$this->threadid' " | 1 |
|
| "select forum_trads.*,EnglishName,ShortCode,forum_trads.id as IdForumTrads from forum_trads,languages where IdLanguage=languages.id and IdTrad=" . $DataPost->Post->IdContent . " order by forum_trads.created asc" | 1 |
|
| " INSERT INTO `forums_posts` ( `threadid`, `create_time`, `message`,`IdWriter`,`IdFirstLanguageUsed`,`PostVisibility`) VALUES ('%d', NOW(), '%s','%d',%d,'%s') " | 1 |
|
| " UPDATE `forums_threads` SET `replies` = (`replies` - 1) $lastpostupdate WHERE `id` = '$topicinfo->threadid' " | 1 |
|
| " SELECT `forums_posts`.`id` AS `postid` FROM `forums_posts` WHERE `threadid` = '$topicinfo->threadid' ORDER BY `create_time` DESC LIMIT 1 " | 1 |
|
| " DELETE FROM `forums_posts` WHERE `id` = '$this->messageId' " | 1 |
|
| " UPDATE `forums_threads` SET `last_postid` = NULL WHERE `id` = '$topicinfo->threadid' " | 1 |
|
| " DELETE FROM `forums_threads` WHERE `id` = '$topicinfo->threadid' " | 1 |
|
| " DELETE FROM `forums_posts` WHERE `threadid` = '$topicinfo->threadid' " | 1 |
|
| " UPDATE `forums_threads` SET `first_postid` = NULL, `last_postid` = NULL WHERE `id` = '$topicinfo->threadid' " | 1 |
|
| "update forums_posts set OwnerCanStillEdit='" . $OwnerCanStillEdit . "',PostVisibility='" . $PostVisibility . "',PostDeleted='" . $PostDeleted . "' where id=" . $IdPost | 1 |
|
| "update forums_posts set OwnerCanStillEdit=" . $OwnerCanStillEdit . " where id=" . $IdPost | 1 |
|
| "update forums_threads set " | 1 |
|
| "update thread" | 1 |
|
| "select forum_trads.*,EnglishName,ShortCode,forum_trads.id as IdForumTrads from forum_trads,languages where IdLanguage=languages.id and IdTrad=" . $DataPost->Thread->IdTitle . " order by forum_trads.created asc" | 1 |
|
| "select * from forums_threads where id=" . $DataPost->Post->threadid | 1 |
|
| " SELECT * FROM membersgroups WHERE IdMember = " . $member->id . " AND IdGroup = " . $IdGroup | 1 |
|
| "select IdWriter,forums_threads.id as IdThread,forums_threads.IdTitle,forums_threads.IdFirstLanguageUsed as thread_IdFirstLanguageUsed from forums_threads,forums_posts where forums_threads.first_postid=forums_posts.id and forums_threads.id=" . $threadid | 1 |
|
| "SELECT IdGroup FROM forums_posts fp, forums_threads ft WHERE fp.id = " . $this->dao->escape($IdPost) . " AND fp.threadId = ft.id" | 1 |
|
| "select forums_posts.*,members.Status as memberstatus,members.UserName as UserNamePoster from forums_posts,members where forums_posts.id=" . $IdPost . " and IdWriter=members.id" | 1 |
|
| "select count(*) as cnt from reports_to_moderators,members where members.id=IdReporter " | 1 |
|
| "select reports_to_moderators.*,Username from reports_to_moderators,members where members.id=IdReporter " | 1 |
|
| "select * from reports_to_moderators where IdPost=" . $IdPost . " and IdReporter=" . $IdWriter | 1 |
|
| "select IdReporter from reports_to_moderators where IdPost=" . $IdPost . " and IdReporter=" . $IdReporter | 1 |
|
| "select reports_to_moderators.*,Username from reports_to_moderators,members where IdPost=" . $IdPost . " and members.id=IdReporter" | 1 |
|
| " insert into reports_to_moderators(PostComment,created,IdPost,IdReporter,Status) values('" . $this->dao->escape($PostComment) . "',now()," . $IdPost . "," . $this->session->get("IdMember") . ",'" . $Status . "')" | 1 |
|
| "update reports_to_moderators set LastWhoSpoke='Member',PostComment='" . $this->dao->escape($PostComment) . "',Status='" . $this->dao->escape($Status) . "'" . " where IdPost=" . $IdPost . " and IdReporter=" . $IdReporter | 1 |
|
| "update reports_to_moderators set LastWhoSpoke='Moderator',PostComment='" . $this->dao->escape($PostComment) . "',IdModerator=" . $this->session->get("IdMember") . ",Status='" . $this->dao->escape($Status) . "',Type='" . $this->dao->escape($Type) . "',IdModerator=" . $this->session->get('IdMember') . " where IdPost=" . $IdPost . " and IdReporter=" . $IdReporter | 1 |
|
| "select reports_to_moderators.* from reports_to_moderators where IdPost=" . $IdPost . " and IdReporter=" . $IdReporter | 1 |
|
| "select threadid from forums_posts where id=" . $IdPost | 1 |
|
| 'UPDATE forums_threads SET ThreadVisibility = "' . $vars['ThreadVisibility'] . '" WHERE forums_threads.id=' . $rBefore->IdThread | 1 |
|
| "update forums_threads set title='" . $this->dao->escape($this->cleanupText($vars['topic_title'])) . "' where forums_threads.id=" . $rBefore->IdThread | 1 |
|
| '
SELECT SQL_CACHE count(*) as cnt FROM `words` WHERE `IdLanguage`=0 and `code` like \'NewsTitle_%\'' | 1 |
|
| "select SQL_CACHE Value from memberspreferences,preferences where preferences.codeName='$namepref' and memberspreferences.IdPreference=preferences.id and IdMember=" . $IdMember | 1 |
|
| " DELETE FROM " . $cryptedTable . " WHERE id IN ( '" . implode("', '", $cryptedIds) . "' ) " | 1 |
|
| " UPDATE members m, geonames g SET m.latitude = g.latitude, m.longitude = g.longitude WHERE m.IdCity = g.geonameID " | 1 |
|
| "SELECT f.* FROM faq f LEFT JOIN faqcategories fc ON f.idCategory = fc.id WHERE fc.id = :categoryId AND f.Active = 'Active' ORDER BY f.SortOrder" | 1 |
|
| ' DELETE FROM `geonamesalternatenames` WHERE alternatenameid = :alternate_id AND geonameid = :geoname_id ' | 1 |
|
| ' DELETE FROM `geonames` WHERE geonameid = :geoname_id ' | 1 |
|
| 'Update the geonames data with the latest additions (no deletions!).' | 1 |
|
| 'Update FAQ ' . $faq->getQAndA( ) | 1 |
|
| 'Update Page' | 1 |
|
| " SELECT distinct p.code , COALESCE(pi_lang.shortcode,pi_dflt.shortcode) AS shortcode , COALESCE(pi_lang.domain,pi_dflt.domain) AS domain , COALESCE(pi_lang.Sentence,pi_dflt.Sentence) AS sentence , COALESCE(pi_lang.created,pi_dflt.created) AS created FROM words AS p LEFT OUTER JOIN words AS pi_dflt ON pi_dflt.code = p.code AND pi_dflt.shortcode = 'en' AND (pi_dflt.isArchived IS NULL OR pi_dflt.isArchived = 0) AND (pi_dflt.donottranslate = 'No') LEFT OUTER JOIN words AS pi_lang ON pi_lang.code = p.code AND pi_lang.shortcode = '{$locale}' AND (pi_lang.isArchived IS NULL OR pi_lang.isArchived = 0) " | 1 |
|
| 'SELECT ' | 1 |
|
| ' SELECT lm.id, lm.text, lm.created FROM login_messages lm LEFT JOIN `login_messages_acknowledged` lma ON lm.id = lma.messageId AND lma.memberId = :memberId WHERE lma.messageId IS NULL AND (lm.created > (NOW() - INTERVAL 1 MONTH)) ORDER BY lm.created ASC ' | 1 |
|
| ' SELECT a FROM App:Activity a ORDER BY a.id DESC ' | 1 |
|
| 'SELECT LAST_INSERT_ID() AS id' | 1 |
|
| 'UPDATE `' . $name . '` SET `id` = LAST_INSERT_ID(`id` + 1)' | 1 |
|
| 'INSERT INTO `' . $name . '` (`id`) VALUES (0)' | 1 |
|
| "DELETE FROM `preferences` WHERE `codeName` = 'PreferenceHtmlMails'" | 1 |
|
| "
SELECT SQL_CACHE COUNT(*) AS count FROM members WHERE Status = 'Pending' " | 1 |
|
| "INSERT INTO `preferences` (`id`, `position`, `codeName`, `codeDescription`, `Description`, `created`, `DefaultValue`, `PossibleValues`, `EvalString`, `Status`) VALUES (NULL, '51', 'PreferenceHtmlMails', 'PreferenceHtmlMailsDesc', 'This allows the member to choose the format of the messages send by bewelcome.org. Defaults to HTML', CURRENT_TIMESTAMP, 'Yes', 'Yes;No', '', 'Normal');" | 1 |
|
| "INSERT INTO `login_messages` (`id`, `text`) VALUES (NULL, 'BeWelcome has just been updated please check the community news')" | 1 |
|
| "UPDATE messages SET WhenFirstRead = '0000-00-00 00:00:00' WHERE WhenFirstRead IS NULL" | 1 |
|
| "UPDATE messages SET WhenFirstRead = NULL WHERE WhenFirstRead = '0000-00-00 00:00:00'" | 1 |
|
| " UPDATE `membersgroups` SET `notificationsEnabled` = 0 WHERE `IacceptMassMailFromThisGroup` = 'yes' " | 1 |
|
| "UPDATE `polls` SET `Status` = 'Close' where `Status` = ''" | 1 |
|
| "UPDATE `polls` SET `Status` = 'Closed' where `Status` = ''" | 1 |
|
| ' DELETE FROM gallery_items_to_gallery WHERE NOT EXISTS ( SELECT * FROM gallery_items WHERE gallery_items.id = gallery_items_to_gallery.item_id_foreign) ' | 1 |
|
| " DELETE FROM rights WHERE Name = 'NewMembersBeWelcome'" | 1 |
|
| " INSERT INTO rights SET Name = 'NewMembersBeWelcome', Description = 'Members with that right have access to the New Members BeWelcome Tool. Level = 1, Scope = \"All\"'" | 1 |
|
| 'INSERT INTO groups_trads ( group_id, trad_id) SELECT g.id, mt.id FROM groups g, memberstrads mt where g.IdDescription = mt.IdTrad' | 1 |
|
| 'UPDATE members SET ' | 1 |
|
| "SELECT * FROM cryptedfields WHERE id IN (" . $row['FirstName'] . ", " . $row['SecondName'] . ", " . $row['LastName'] . ", " . $row['Email'] . ")" | 1 |
|
| "SELECT id, FirstName, SecondName, LastName, Email fROM members WHERE Status IN ('Active', 'OutOfRemind', 'Banned', 'ChoiceInactive', 'Pending', 'SuspendedBeta', 'MailToConfirm') and EmailText is null ORDER BY Id" | 1 |
|
| 'Update statistics ' | 1 |
|
| "
SELECT SQL_CACHE COUNT(*) AS count FROM members, geonames_countries, geonames_cache WHERE Status = 'Pending' AND members.IdCity = geonames_cache.geonameid AND geonames_countries.iso_alpha2 = geonames_cache.fk_countrycode AND ( geonames_countries.name IN ($scope) OR geonames_countries.iso_alpha2 IN ($scope) ) " | 1 |
|
| 'INSERT INTO polls_translations ( poll_id, translation_id) SELECT p.id, t.id FROM polls p, translations t where p.Title = t.IdTrad' | 1 |
|
| "UPDATE `{$this->getTableName( )}` SET {$set_string} WHERE {$where}" | 1 |
|
| "UPDATE user SET email = '" . $row['email'] . "' WHERE handle = 'member-" . $row['id'] . "';\n" | 1 |
|
| "SELECT id, email as emailaddress, firstname as first, secondname as second, lastname as last from members" | 1 |
|
| "
SELECT * FROM messages m" | 1 |
|
| '
SELECT id picid, user_id_foreign id, `file` name, mimetype, width, height FROM gallery_items ' . $this->getStartingPointText($startId) . ' ORDER BY picid ASC ' . $this->getLimitText($limit) | 1 |
|
| '
SELECT id picid,Picture name FROM groups WHERE NOT Picture="" ORDER BY id ' . $this->getLimitText($limit) | 1 |
|
| '
SELECT id picid,id name FROM members WHERE id IN ( SELECT DISTINCT idmember FROM membersphotos ' . $this->getStartingPointText($startId) . ') ORDER BY picid ' . $this->getLimitText($limit) | 1 |
|
| "DELETE FROM words WHERE code = :newCode" | 1 |
|
| "INSERT INTO words (code, shortcode, sentence, created, updated, donottranslate, idLanguage, description, idMember, TranslationPriority, isArchived, majorUpdate, domain) SELECT :newCode, shortcode, sentence, created, updated, donottranslate, idLanguage, description, idMember, TranslationPriority, isArchived, majorUpdate, domain FROM words WHERE code = :oldCode" | 1 |
|
| "UPDATE words SET code = :newCode WHERE code = :oldCode" | 1 |
|
| "DELETE FROM words WHERE code = " . $code | 1 |
|
| " UPDATE `words` SET `isarchived` = NULL WHERE `code` = " . $code | 1 |
|
| " UPDATE `words` SET `isarchived` = 1 WHERE `code` = " . $code | 1 |
|
| "INSERT INTO words SET code = " . $code . ", Shortcode = 'en', sentence = " . $sentence . ", updated = NOW(), donottranslate = 'No', IdLanguage = 0, Description = " . $description . ", IdMember = 1, created = NOW(), TranslationPriority = 5, isarchived = NULL, majorupdate = NOW(), domain = " . $domain | 1 |
|
| <<<SQL DELETE FROM `{$this->getTableName( )}` WHERE {$where} SQL | 1 |
|
| "INSERT INTO {$this->getTableName( )} (" . implode(',', $fields) . ") VALUES (" . implode(',', $values) . ")" | 1 |
|
| "
SELECT SQL_CACHE COUNT(*) AS count FROM comments WHERE AdminAction = 'AdminCommentMustCheck' " | 1 |
|
| <<<SQL SELECT COUNT({$field}) AS count FROM `{$this->getTableName( )}` WHERE {$where} SQL | 1 |
|
| <<<SQL SELECT COUNT({$field}) AS count FROM `{$this->getTableName( )}` SQL | 1 |
|
| <<<SQL SELECT * FROM `{$this->getTableName( )}` SQL | 1 |
|
| <<<SQL SELECT * FROM `{$this->getTableName( )}` WHERE `{$this->getPrimaryKey( )}` = '{$id}' SQL | 1 |
|
| "update members set NbRemindWithoutLogingIn=NbRemindWithoutLogingIn+1 where members.id=" . $msg->IdReceiver | 1 |
|
| "select SQL_CACHE Sentence,donottranslate from words where code='$wordCode' and IdLanguage=0" | 1 |
|
| "select SQL_CACHE Sentence,donottranslate from words where code='$wordCode' and IdLanguage='" . $languageId . "'" | 1 |
|
| "UPDATE broadcastmessages SET Status = '$status' WHERE IdBroadcast = $id AND IdReceiver = $receiver" | 1 |
|
| '
SELECT DISTINCT languages.* FROM languages, words WHERE languages.id = words.IdLanguage AND words.code = \'WelcomeToSignup\' ORDER BY FlagSortCriteria ' | 1 |
|
| '
SELECT COUNT(*) AS cnt FROM messages, members AS mSender, members AS mReceiver WHERE mSender.id=IdSender AND messages.SpamInfo=\'SpamSayMember\' AND mReceiver.id=IdReceiver AND ( mSender.Status=\'Active\' OR mSender.Status=\'Pending\' ) ' | 1 |
|
| '
SELECT COUNT(*) AS cnt FROM messages WHERE Status=\'ToCheck\' AND messages.WhenFirstRead=\'0000-00-00 00:00:00\'' | 1 |
|
| 'SELECT SQL_CACHE COUNT(*) AS cnt FROM `membersgroups`,`groups` where `membersgroups`.`Status`="WantToBeIn" and `groups`.`id`=`membersgroups`.`IdGroup`' . $where | 1 |
|
| "
SELECT SQL_CACHE COUNT(*) AS cnt FROM pendingmandatory, geonames_countries, geonames_cache WHERE ( pendingmandatory.Status = 'NeedMore' OR pendingmandatory.Status = 'Pending' ) AND geonames_cache.geonameid = pendingmandatory.IdCity AND geonames_countries.iso_alpha2 = geonames_cache.fk_countrycode AND ( geonames_countries.iso_alpha2 IN ($AccepterScope) OR geonames_countries.name IN ($AccepterScope) ) " | 1 |
|
| "
SELECT SQL_CACHE COUNT(*) AS cnt FROM pendingmandatory, geonames_countries, geonames_cache WHERE ( pendingmandatory.Status = 'NeedMore' OR pendingmandatory.Status = 'Pending' ) AND geonames_cache.geonameid = pendingmandatory.IdCity AND geonames_countries.iso_alpha2 = geonames_cache.fk_countrycode " | 1 |
|
| 'INSERT INTO poll_choices_translations ( poll_choice_id, translation_id) SELECT p.id, t.id FROM polls_choices p, translations t where p.IdChoiceText = t.IdTrad' | 1 |
|
| "UPDATE request r SET r.updated = NULL where r.created = r.updated;" | 1 |
|
| ' INSERT INTO ' . $crypt_db . 'cryptedfields ( `AdminCryptedValue`, `MemberCryptedValue`, `IdMember`, `IsCrypted`, `TableColumn`, `IdRecord` ) VALUES ( \'' . $ssA . '\', \'' . $ssM . '\', \'' . $IdMember . '\', \'' . $IsCrypted . '\', \'' . $TableColumn . '\', \'' . $IdRecord . '\' )' | 1 |
|
| "SELECT SQL_CACHE `Sentence`,`IdLanguage` FROM `translations` WHERE `IdTrad`=" . $IdTrad . " order by id asc limit 1" | 1 |
|
| ' INSERT INTO `' . MOD_encdb::TABLE_NAME . '`( `val_admin`, `val_member`, `id_member`, `encryption` ) VALUES( "' . $aString . '", "' . $mString . '", ' . $this->_idMember . ', \'Y\' )' | 1 |
|
| 'INSERT INTO ' . $DB_ARCH . '`logs` ( `IdMember`, `Str`, `Type`, `created` ) VALUES( ' . $idMember . ', \'' . $message . '\', \'' . $type . '\', now() )' | 1 |
|
| "
SELECT SQL_CACHE Sentence, donottranslate, updated FROM words WHERE code = '$code' AND IdLanguage = $language_id " | 1 |
|
| "select id," . $SentenceCol . " from " . $this->_tablename . " where " . $this->_idtradcolumn . "='" . $Code . "' and ShortCode='" . $IdLanguage . "'" | 1 |
|
| "UPDATE translations SET TableColumn='" . $TableColumn . "',IdRecord=" . $IdRecord . ",IdTranslator=" . $IdTranslator . ",Sentence='" . $ss . "' WHERE id=" . $rr->id | 1 |
|
| "SELECT * FROM translations WHERE IdTrad=" . $IdTrad . " AND IdLanguage=" . $DefLanguage . " /* in forum->ReplaceInFTrad */" | 1 |
|
| "update " . $table[0] . " set " . $TableColumn . "=" . $IdTrad . " where id=" . $IdRecord | 1 |
|
| "insert into translations(TableColumn,IdRecord,IdLanguage,IdOwner,IdTrad,IdTranslator,Sentence,created) " | 1 |
|
| "select max(IdTrad)+1 AS maxi from translations" | 1 |
|
| "update memberstrads set TableColumn='" . $TableColumn . "',IdRecord=" . $IdRecord . ",IdTranslator=" . $IdTranslator . ",Sentence='" . $ss . "' where id=" . $rr->id | 1 |
|
| "select * from memberstrads where IdTrad=" . $IdTrad . " and IdOwner=" . $IdMember . " and IdLanguage=" . $IdLanguage | 1 |
|
| "update " . $table[0] . " set " . $TableColumn . "=" . $IdTrad . " where " . $table[0] . ".id=" . $IdRecord | 1 |
|
| "insert into memberstrads(TableColumn,IdRecord,IdLanguage,IdOwner,IdTrad,IdTranslator,Sentence,created) " | 1 |
|
| "Select max(IdTrad) as maxi, min(IdTrad) as mini from memberstrads" | 1 |
|
| "SELECT SQL_CACHE `Sentence`,`IdLanguage` FROM `translations` WHERE `IdTrad`=" . $IdTrad . " and `IdLanguage`=0" | 1 |
|
| ' SELECT SQL_CACHE `val_admin` FROM `' . MOD_encdb::TABLE_NAME . '` WHERE `id`=' . $id | 1 |
|
| "SELECT SQL_CACHE `Sentence`,`IdLanguage` FROM `translations` WHERE `IdTrad`=" . $IdTrad . " and `IdLanguage`=" . $IdLanguage | 1 |
|
| "SELECT SQL_CACHE `Sentence` FROM `memberstrads` WHERE `IdTrad`=" . $IdTrad . " order by id asc limit 1" | 1 |
|
| "SELECT SQL_CACHE `Sentence` FROM `memberstrads` WHERE `IdTrad`=" . $IdTrad . " and `IdLanguage`=0 ORDER BY updated DESC" | 1 |
|
| "SELECT SQL_CACHE `Sentence` FROM `memberstrads` WHERE `IdTrad`=" . $IdTrad . " and `IdLanguage`=" . $IdLanguage . " ORDER BY updated DESC" | 1 |
|
| " DELETE FROM memberstrads WHERE IdTrad = '" . (-$IdTrad) . "' AND IdOwner = '{$IdMember}' AND IdLanguage = '{$IdLanguage}'" | 1 |
|
| ' SELECT SQL_CACHE code, Sentence, donottranslate, updated, majorupdate FROM words WHERE code = "' . $this->_dao->escape(strtolower($code)) . '" AND ShortCode = "' . $this->_dao->escape($lang) . '"' . $extraWhere | 1 |
|
| "SELECT SQL_CACHE `code`,`Sentence`, `donottranslate`, `updated`, majorupdate " . "FROM `words` " . "WHERE `id`=" . $this->_dao->escape($code) | 1 |
|
| "SELECT SQL_CACHE `code`,`Sentence`, `donottranslate`, `updated` " . "FROM `words` " . "WHERE `code`='" . $this->_dao->escape($code) . "' and `ShortCode`='en'" | 1 |
|
| "SELECT SQL_CACHE `code`,`Sentence`, `donottranslate`, `updated` " . "FROM `words` " . "WHERE `code`='" . $this->_dao->escape($code) . "' and `ShortCode`='" . $this->_dao->escape($lang) . "'" | 1 |
|
| "SELECT SQL_CACHE `code`,`Sentence`, `donottranslate`, `updated` " . "FROM `words` " . "WHERE `id`=" . $this->_dao->escape($code) | 1 |
|
| "
SELECT SQL_CACHE `code`, `Sentence` FROM `words` WHERE ShortCode = '" . $locale . "' ORDER BY code" | 1 |
|
| "SELECT * FROM `params`" | 1 |
|
| <<<SQL SELECT SQL_CACHE members.id, members.Username, MAX(g2.name) AS countryname FROM members, membersphotos, addresses, geonames_cache AS g1, geonames_cache AS g2 WHERE members.Status='Active' AND ABS(HOURS(TIMEDIFF(members.created, now())) > 24 AND membersphotos.IdMember = members.id AND members.id = addresses.IdMember AND addresses.IdCity = g1.geonameId AND g2.geonameId = g1.parentCountryId GROUP BY members.id, members.Username ORDER BY members.id DESC LIMIT {$this->dao->escape($quantity)} SQL | 1 |
|
| " SELECT * FROM " . $crypt_db . "cryptedfields WHERE id = $crypted_id " | 1 |
|
| ' SELECT SQL_CACHE `val_member` FROM `' . MOD_encdb::TABLE_NAME . '` WHERE `id`=' . $id | 1 |
|
| "UPDATE stats set created = date(created);" | 1 |
|
| "UPDATE request r, messages m SET r.updated = m.updated where r.id = m.request_id;" | 1 |
|
| 'UPDATE feedbacks SET idMember = NULL WHERE idMember = 0' | 1 |
|
| "UPDATE request r, messages m SET r.created = m.created where r.created = '0000-00-00 00:00:00' and r.id = m.request_id;" | 1 |
|
| " UPDATE `flags` SET Name = 'NotAllowToPostInForum' WHERE Name = 'NotAllowedToPostInForum'; UPDATE `flags` SET Name = 'NotAllowToPostInBlog' WHERE Name = 'NotAllowedToPostInBlog'; UPDATE `flags` SET Name = 'AlwayCheckSendMail' WHERE Name = 'AlwaysCheckSendMail'; UPDATE `flags` SET Name = 'NotAllowToWriteInChat' WHERE Name = 'NotAllowedToWriteInChat'; " | 1 |
|
| " UPDATE `flags` SET Name = 'NotAllowedToPostInForum', Relevance = 100 WHERE Name = 'NotAllowToPostInForum'; UPDATE `flags` SET Name = 'NotAllowedToPostInBlog' WHERE Name = 'NotAllowToPostInBlog'; UPDATE `flags` SET Name = 'AlwaysCheckSendMail' WHERE Name = 'AlwayCheckSendMail'; UPDATE `flags` SET Name = 'NotAllowedToWriteInChat' WHERE Name = 'NotAllowToWriteInChat'; " | 1 |
|
| "UPDATE members SET `registration_key` = SHA2(CONCAT(LOWER(email), ' - ', LOWER(username)), 256) WHERE Status = '" . MemberStatusType::AWAITING_MAIL_CONFIRMATION . "';" | 1 |
|
| " DELETE FROM rights WHERE Name = 'ManageSubscriptions'" | 1 |
|
| " INSERT INTO rights SET Name = 'ManageSubscriptions', Description = 'Members with this right can change subscriptionssettings for a member. Level = 1, Scope = \"All\"'" | 1 |
|
| "UPDATE preferences SET `Status` = 'Inactive' WHERE codename = '" . $codename . "'" | 1 |
|
| "UPDATE preferences SET `Status` = 'Normal' WHERE codename = '" . $codename . "'" | 1 |
|
| "Show thread" | 1 |
|
| "Select a template for translation" | 1 |
|
| "Show complete" | 1 |
|
| "Show Details" | 1 |
|
| "Update Status" | 1 |
|
| 'UPDATE feedbacks SET idMember = 0 WHERE idMember = NULL' | 1 |
|
| 'Show me at the top of the search results' | 1 |
|
| " update gallery g INNER JOIN user u ON g.user_id_foreign = u.id INNER JOIN members m ON u.handle = m.username SET g.user_id_foreign = m.id " | 1 |
|
| 'UPDATE `groups` SET `approved` = 1' | 1 |
|
| " SELECT b.blog_id, b.IdMember, bd.blog_title, bd.blog_text, blog_created FROM blog AS b JOIN blog_data AS bd ON b.blog_id = bd.blog_id LEFT JOIN `blog_to_tag` b2t ON b.`blog_id` = b2t.`blog_id_foreign` LEFT JOIN `blog_tags` bt ON b2t.`blog_tag_id_foreign` = bt.`blog_tag_id` WHERE bt.`name` LIKE 'Community News for the frontpage'" | 1 |
|
| 'INSERT INTO group_membership_trads ( group_membership_id, members_trad_id) SELECT mg.id, mt.id FROM membersgroups mg, memberstrads mt where mg.Comment = mt.IdTrad and mt.IdRecord <> -1' | 1 |
|
| "UPDATE words SET `domain` = '" . DomainType::ICU_MESSAGES . "' WHERE code like 'label.admin.messages.reported'" | 1 |
|
| "UPDATE words SET `domain` = '" . DomainType::ICU_MESSAGES . "' WHERE code like 'label.admin.comments.reported'" | 1 |
|
| "UPDATE words SET `domain` = '" . DomainType::ICU_MESSAGES . "' WHERE code like 'label.admin.groups.awaiting.approval'" | 1 |
|
| "UPDATE words SET `domain` = '" . DomainType::VALIDATORS . "' WHERE code like 'search.location%'" | 1 |
|
| "select m.id as memberId, u.id as userId from members m, user u where m.username = u.handle order by m.id desc" | 1 |
|
| " update gallery_comments g INNER JOIN members m ON g.user_id_foreign = m.id INNER JOIN user u ON u.handle = m. username SET g.user_id_foreign = u.id " | 1 |
|
| " update gallery_items g INNER JOIN members m ON g.user_id_foreign = m.id INNER JOIN user u ON u.handle = m.username SET g.user_id_foreign = u.id " | 1 |
|
| " update gallery g INNER JOIN members m ON g.user_id_foreign = m.id INNER JOIN user u ON u.handle = m.username SET g.user_id_foreign = u.id " | 1 |
|
| "select m.id as memberId, u.id as userId from members m, user u where m.username = u.handle order by u.id desc" | 1 |
|
| " update gallery_comments g INNER JOIN user u ON g.user_id_foreign = u.id INNER JOIN members m ON u.handle = m.username SET g.user_id_foreign = m.id " | 1 |
|
| " update gallery_items g INNER JOIN user u ON g.user_id_foreign = u.id INNER JOIN members m ON u.handle = m.username SET g.user_id_foreign = m.id " | 1 |
|
| " SELECT " . implode(', ', $tradIdFields) . " FROM members WHERE id = :memberId " | 1 |
|
| "INSERT INTO `hosting_eagerness_slider` SET `member_id` = {$member->id}, `endDate` = '{$hesEnddate}', `step` = {$step}, `remaining` = {$duration}, `current` = {$current}, `initialized` = NOW(), `updated` = NOW()" | 1 |
|
| " SELECT " . implode(', ', $cryptedFields) . " FROM members WHERE id = :memberId " | 1 |
|
| " SELECT `geonames_cache`.*,`geo_hierarchy`.`parentid` FROM `geonames_cache`,`geo_hierarchy` WHERE geonames_cache.geonameId = '" . $geonameId . "' AND geo_hierarchy.geoid = '" . $geonameId . "' AND `geo_hierarchy`.`comment` = 'geonames' " | 1 |
|
| " SELECT SQL_CACHE * FROM members WHERE id = " . IdMember($Username) | 1 |
|
| " SELECT SQL_CACHE id, Username FROM members WHERE id = $rr->ChangedId " | 1 |
|
| " SELECT SQL_CACHE id, ChangedId, Username, Status FROM members WHERE Username='" . mysql_real_escape_string($username) . "' " | 1 |
|
| 'SELECT SQL_CACHE * FROM membersphotos WHERE IdMember=". $rr->IdMember . " AND SortOrder=0' | 1 |
|
| 'SELECT SQL_CALC_FOUND_ROWS DISTINCT members.id AS IdMember, Username, geonames.name AS CityName, geonamescountries.name AS CountryName, IF(members.ProfileSummary != 0, 1, 0) AS HasSummary, IF(DATEDIFF(NOW(), members.LastLogin) < 300, 1, 0) AS HasLoggedIn FROM (' . $tablelist . ') ' . $where . ' ' . $orderBy . ' LIMIT ' . $start . ',' . $limit | 1 |
|
| <<<SQL SELECT EnglishName, ShortCode FROM languages WHERE ShortCode IN ($l) SQL | 1 |
|
| <<<SQL SELECT ShortCode FROM words WHERE code = 'welcometosignup' SQL | 1 |
|
| " SELECT `geonameId` FROM `geonames_cache` ORDER BY `geonameId` Asc " | 1 |
|
| " SELECT `IdCity` FROM `addresses` " | 1 |
|
| " INSERT INTO geo_usage SET id = 'NULL', geoId = " . $key . ", typeId = " . $addressTypeId . ", count = " . $value . " " | 1 |
|
| " SELECT * FROM `geo_usage` " | 1 |
|
| " SELECT `geoId`, `parentId` FROM `geo_hierarchy` " | 1 |
|
| " INSERT INTO geonames_cache_backup SET id = NULL, geonameId = '" . $this->dao->escape($result->geonameId) . "', latitude = '" . $this->dao->escape($result->latitude) . "', longitude = '" . $this->dao->escape($result->longitude) . "', name = '" . $this->dao->escape($result->name) . "', population = '" . $this->dao->escape($result->population) . "', fclass = '" . $this->dao->escape($result->fclass) . "', fcode = '" . $this->dao->escape($result->fcode) . "', fk_countrycode = '" . $this->dao->escape($result->fk_countrycode) . "', fk_admincode = '" . $this->dao->escape($result->fk_admincode) . "', timezone = '" . $this->dao->escape($result->timezone) . "', parentid = '" . $this->dao->escape($result->parentid) . "', date_updated = NOW() " | 1 |
|
| " SELECT `id` FROM `geo_type` WHERE `name` = '" . $usagetype . "' " | 1 |
|
| " SHOW COLUMNS FROM $table LIKE '$column' " | 1 |
|
| " UPDATE geo_usage SET `count` = `count` - 1 WHERE `id` = '" . $inuse->id . "' " | 1 |
|
| " INSERT INTO geo_usage SET id = 'NULL', geoId = " . $this->dao->escape($geonameId) . ", typeId = '" . $usagetypeId . "', count = '1' " | 1 |
|
| " UPDATE geo_usage SET `count` = `count` + 1 WHERE `id` = '" . $inuse->id . "' " | 1 |
|
| " SELECT `id` FROM `geo_usage` WHERE `typeId` = '" . $usagetypeId . "' AND `geoId` = '" . $this->dao->escape($geonameId) . "' " | 1 |
|
| " INSERT INTO `geo_hierarchy` SET `geoId` = '" . $this->dao->escape($geonameId) . "', `parentId` = '" . $this->dao->escape($parentId) . "', `comment` = 'geonames' " | 1 |
|
| " SELECT `id` FROM `geo_hierarchy` WHERE `geoId` = '" . $geonameId . "' AND `parentId` = '" . $parentId . "' " | 1 |
|
| " INSERT INTO geonames_cache SET geonameId = '" . $this->dao->escape($dataset['geonameId']) . "', latitude = '" . $this->dao->escape($dataset['lat']) . "', longitude= '" . $this->dao->escape($dataset['lng']) . "', name = '" . $this->dao->escape($dataset['name']) . "', population = '" . $this->dao->escape($dataset['population']) . "', fclass = '" . $this->dao->escape($dataset['fcl']) . "', fcode = '" . $this->dao->escape($dataset['fcode']) . "', fk_countrycode = '" . $this->dao->escape($dataset['countryCode']) . "', fk_admincode = '" . $this->dao->escape($dataset['adminCode1']) . "', timezone = '" . $this->dao->escape($dataset['timezone']) . "', parentAdm1Id = '" . $this->dao->escape($parentAdm1Id) . "', parentCountryId = '" . $this->dao->escape($parentCountryId) . "' " | 1 |
|
| " SELECT * FROM `geonamesalternatenames` WHERE `geonameId` = '" . $geonameId . "' AND `isoLanguage` = '" . $lang . "' ORDER BY `isPreferred` " | 1 |
|
| " SELECT * FROM `geonames_cache` WHERE `geonameId` = '" . $geonameId . "' " | 1 |
|
| "SELECT p.*, m.Username AS 'CreatorUsername', g.id AS GroupId, g.name AS GroupName FROM " | 1 |
|
| "UPDATE `polls` SET `Status` = 'Closed' WHERE `Status` = 'Open' and `Ended` <= NOW()" | 1 |
|
| "select * from polls where id=" . $IdPoll . " /* can user contribute */" | 1 |
|
| "SELECT p.*, m.Username AS 'CreatorUsername', g.id AS GroupId, g.name AS GroupName from polls p " | 1 |
|
| " SELECT SQL_CACHE username FROM members WHERE id = " . intval($cid) | 1 |
|
| ' SELECT `id` FROM `members` WHERE `Email` = \'' . $this->dao->escape($this->normalizeEmail($email)) . '\'' | 1 |
|
| "select polls.*,members.Username as 'CreatorUsername', g.id as IdGroupRestricted from (polls)" | 1 |
|
| "
SELECT `IdOwner` FROM `specialrelations` WHERE UNIX_TIMESTAMP(`updated`) >= " . $lastupdate->updated . "-120" | 1 |
|
| "
SELECT `id` FROM `members` WHERE `Username` = '$username' " | 1 |
|
| "
SELECT `IdMember`,`Value`,`preferences`.`DefaultValue` FROM `preferences`,`memberspreferences` WHERE `preferences`.`id` = `memberspreferences`.`IdPreference` AND `preferences`.`codeName` = 'PreferenceLinkPrivacy' " | 1 |
|
| "select count(*) as Cnt from comments where IdToMember=" . $value->IdMember . " and Quality='Good'" | 1 |
|
| "select count(*) as Cnt from comments where IdToMember=" . $value->IdMember | 1 |
|
| "select max(Type) as TypeVerif from verifiedmembers where IdVerified=" . $value->IdMember | 1 |
|
| "
SELECT SQL_CACHE members.Username, 'NbComment',memberspreferences.Value as PreferenceLinkPrivacy,'NbTrust','Verified',members.id, members.id as IdMember, g1.Name AS City, g2.Name AS Country,`members`.`Status` FROM members JOIN addresses ON addresses.IdMember = members.id AND addresses.rank = 0 LEFT JOIN geonames AS g1 ON addresses.IdCity = g1.geonameId LEFT JOIN geonamescountries AS g2 ON g1.country = g2.country LEFT JOIN memberspreferences ON `memberspreferences`.`IdPreference`=" . $rPref->id . " and `memberspreferences`.`IdMember`=`members`.`id` WHERE `members`.`id` in ($idquery) and (`members`.`Status` in ('Active', 'OutOfRemind')) " | 1 |
|
| "select `id`,`DefaultValue` from `preferences` where `preferences`.`codeName` = 'PreferenceLinkPrivacy'" | 1 |
|
| "
SELECT * FROM `linklist` WHERE linklist.fromID = $fromid AND linklist.toID = $toid LIMIT " . (int) $limit | 1 |
|
| " DELETE FROM addresses WHERE IdMember = :memberId " | 1 |
|
| "SELECT `toID`
FROM `linklist` WHERE linklist.fromID = $fromid AND linklist.degree = $degree LIMIT " . (int) $limit | 1 |
|
| "
SELECT `IdOwner`,`IdRelation`,`Type`, `members`.`id`, `members`.`status` FROM `specialrelations` , `members` WHERE `IdRelation` = `members`.`id` AND (`members`.`Status` in ('Active','OutOfRemind') ) ORDER BY `IdOwner`,`IdRelation` Asc " | 1 |
|
| "
SELECT `comments`.`IdFromMember` AS `IdFromMember`,`comments`.`IdToMember` AS `IdToMember`,`comments`.`Quality` AS `Quality` , `members`.`id`, `members`.`status` FROM `comments`, `members` WHERE `IdToMember` = `members`.`id` AND (`members`.`Status` in ('Active','OutOfRemind','ActiveHidden')) AND NOT FIND_IN_SET('NeverMetInRealLife',`comments`.`relation`) AND (FIND_IN_SET('hewasmyguest',`comments`.`relation`) or FIND_IN_SET('hehostedme',`comments`.`relation`) or FIND_IN_SET('OnlyOnce',`comments`.`relation`) or FIND_IN_SET('HeIsMyFamily',`comments`.`relation`) or FIND_IN_SET('HeHisMyOldCloseFriend',`comments`.`relation`) ) ORDER BY `IdFromMember`,`IdToMember` Asc " | 1 |
|
| "
SELECT `fromID`,path FROM `linklist` WHERE `path` LIKE '%{i:0;i:" . $id . ";%' AND (`toID` != " . $id . " AND fromID != " . $id . ") " | 1 |
|
| "
SELECT `IdFromMember` FROM `comments` WHERE UNIX_TIMESTAMP(`updated`) >= " . $lastupdate->updated . "-120" | 1 |
|
| "SELECT email FROM members m WHERE m.email = '{$email}'" | 1 |
|
| "SELECT UNIX_TIMESTAMP(`updated`) as updated FROM `linklist` ORDER BY `updated` DESC LIMIT 1" | 1 |
|
| "
DELETE FROM linklist WHERE fromID = " . $id | 1 |
|
| "
INSERT INTO linklist SET id = 'NULL', fromID = " . $fields['fromID'] . ", toID = " . $fields['toID'] . ", degree = " . $fields['degree'] . ", rank = " . $fields['rank'] . ", path = " . $fields['path'] . " " | 1 |
|
| "
SELECT fromID FROM linklist GROUP BY fromID " | 1 |
|
| 'Show links' | 1 |
|
| ' INSERT INTO addresses ( `IdMember`, `IdCity`, `HouseNumber`, `StreetName`, `Zip`, `created`, `Explanation` ) VALUES ( ' . $memberID . ', ' . $vars['location-geoname-id'] . ', 0, 0, 0, now(), 0)' | 1 |
|
| "INSERT INTO memberspreferences (IdMember, IdPreference, Value) VALUES " | 1 |
|
| " INSERT INTO `members` ( `Username`, `IdCity`, `Latitude`, `Longitude`, `Gender`, `HideGender`, `created`, `BirthDate`, `HideBirthDate`, `MaxGuest`, `Email`, `FirstName`, `SecondName`, `LastName`, `HideAttribute`, `accomodation`, `hosting_interest` ) VALUES ( ?, ?, ?, ?, ?, ?, NOW(), ?, ?, 1, ?, ?, ?, ?, ?, ?, ? );" | 1 |
|
| "SELECT id FROM preferences WHERE codename = '" . $preference . "'" | 1 |
|
| ' SELECT `id` FROM `languages` WHERE `ShortCode` = \'' . $this->session->get('lang') . '\'' | 1 |
|
| ' INSERT INTO `feedbacks` ( `created`, `Discussion`, `IdFeedbackCategory`, `IdVolunteer`, `Status`, `IdLanguage`, `IdMember` ) VALUES( now(), \'' . $feedback . '\', ' . FEEDBACK_CATEGORY_SIGNUP . ', 0, \'closed by member\', ' . $lang . ', ' . $this->session->get('IdMember') . ' )' | 1 |
|
| 'SELECT `id` FROM `members` WHERE `Username` = \'' . $this->dao->escape(strtolower($Username)) . '\'' | 1 |
|
| 'SELECT `handle` FROM `user` WHERE `id` = ' . (int) $userId | 1 |
|
| "select * from polls_choices where IdPoll=" . $IdPoll . " order by created asc" | 1 |
|
| "select count(*) as cnt from polls_contributions where Email='" . $Email . " and IdPoll=" . $IdPoll | 1 |
|
| 'Show Friends' | 1 |
|
| " SELECT SQL_CALC_FOUND_ROWS m.BirthDate, m.HideBirthDate, m.Accomodation, m.username, m.idCity, IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary FROM geonames g, members m WHERE m.Status = 'Active' AND m.MaxGuest >= 1 AND m.IdCity = g.geonameId AND g.geonameId = '%s' ORDER BY m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC" | 1 |
|
| "SELECT COUNT(*) as cnt from messages where WhenFirstRead between '$d1' and '$d2' " | 1 |
|
| "SELECT COUNT(*) as cnt from messages where DateSent between '$d1' and '$d2' " | 1 |
|
| "SELECT COUNT(distinct(members.id)) as cnt from members right join " . PVars::getObj('syshcvol')->ARCH_DB . ".logs on members.id=" . PVars::getObj('syshcvol')->ARCH_DB . ".logs.IdMember and " . PVars::getObj('syshcvol')->ARCH_DB . ".logs.type='Login' and " . PVars::getObj('syshcvol')->ARCH_DB . ".logs.created between '$d1' and '$d2' and " . PVars::getObj('syshcvol')->ARCH_DB . ".logs.Str like 'Successful login%' " | 1 |
|
| "SELECT COUNT(DISTINCT(members.id)) AS cnt FROM members,comments WHERE Status in ('Active','ChoiceInactive','OutOfRemind') AND members.id=comments.IdToMember AND comments.Quality='Good'" | 1 |
|
| "SELECT COUNT(*) AS cnt FROM members WHERE Status in ('Active','ChoiceInactive','OutOfRemind')" | 1 |
|
| ' SELECT * FROM stats ORDER BY id DESC LIMIT 0,60 ' | 1 |
|
| "
SELECT * FROM faqcategories " | 1 |
|
| "
SELECT * FROM words WHERE code IN (" . implode(", ", $faq_wordcodes_A) . ") " | 1 |
|
| "
SELECT * FROM words WHERE code IN (" . implode(", ", $faq_wordcodes_Q) . ") " | 1 |
|
| "
SELECT * FROM faq WHERE faq.Active='Active' ORDER BY SortOrder " | 1 |
|
| "SELECT * FROM ( SELECT geonameId, city, ispreferred,isshort, source,count(m.id) NbMember FROM ( SELECT * from ( SELECT g.geonameId geonameId, a.alternatename city, a.ispreferred ispreferred, a.isshort isshort, 'alt' source FROM geonamesalternatenames a, geonames g WHERE g.country = '%1\$s' AND g.admin1 = '%2\$s' AND g.geonameId = a.geonameId AND a.isoLanguage = '%3\$s' ORDER BY isshort DESC, ispreferred DESC ) allA GROUP BY geonameId ) AByGid, members m WHERE m.idcity = AByGid.geonameId AND m.status = 'Active' AND m.MaxGuest >= 1 GROUP BY geonameId UNION SELECT g.geonameId g, g.name AS city, 0 ispreferred, 0 isshort, 'geo' source, COUNT(m.id) NbMember FROM geonames g, members m WHERE g.country = '%1\$s' AND g.admin1 = '%2\$s' AND g.geonameId = m.IdCity AND m.status = 'Active' AND m.MaxGuest >= 1 GROUP BY geonameId ORDER BY geonameId, isshort DESC, ispreferred DESC, source ASC, city ASC) ag GROUP BY geonameId " | 1 |
|
| "SELECT * FROM ( SELECT a.admin1 admin1, a.name region, 0 ispreferred, 0 isshort, 'geo' source FROM geonames a WHERE a.country = '%1\$s' AND a.fcode = 'ADM1' UNION SELECT ga.admin1 admin1, a.alternatename region, a.ispreferred ispreferred, a.isshort isshort, 'alt' source FROM geonames ga, geonamesalternatenames a WHERE ga.geonameId = a.geonameId AND ga.country = '%1\$s' AND ga.fcode = 'ADM1' AND a.isoLanguage = '%2\$s' ORDER BY admin1, isshort DESC, ispreferred DESC, source ASC, region ASC) x GROUP BY admin1 " | 1 |
|
| "SELECT * FROM ( SELECT c.country country, a.alternatename name, c.continent continent, a.ispreferred ispreferred, a.isshort isshort, 'alternate' source FROM geonamescountries c, geonamesalternatenames a WHERE a.geonameId = c.geonameId AND a.isolanguage = '" . $this->dao->escape($this->lang) . "' AND a.isHistoric = 0 UNION SELECT country, name, continent, 0 ispreferred, 0 isshort, 'geoname' source FROM geonamescountries c ORDER BY continent ASC, country, isshort DESC, ispreferred DESC, source ASC, name ASC) x GROUP BY country " | 1 |
|
| " SELECT SQL_CALC_FOUND_ROWS m.BirthDate, m.HideBirthDate, m.Accomodation, m.username, m.idCity, IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary FROM geonames g, members m WHERE m.Status = 'Active' AND m.MaxGuest >= 1 AND m.idCity = g.geonameId AND g.admin1 = '%2\$s' AND g.country = '%1\$s' AND g.fclass = 'P' ORDER BY m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC" | 1 |
|
| "SELECT COUNT(*) AS count FROM members AS m, " . $this->getTableName( ) . " AS mg WHERE mg.IdGroup = " . $group_id . " AND mg.Status = 'In' " . " AND mg.IdMember = m.id AND m.Status IN (" . MemberStatusType::ACTIVE_ALL . ")" | 1 |
|
| " SELECT SQL_CALC_FOUND_ROWS m.BirthDate, m.HideBirthDate, m.Accomodation, m.idCity, m.username, IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary FROM geonames g, members m WHERE m.Status = 'Active' AND m.MaxGuest >= 1 AND g.geonameId = m.idCity AND g.country = '%s' ORDER BY m.Accomodation ASC, HasProfileSummary DESC, m.LastLogin DESC" | 1 |
|
| "SELECT * FROM ( SELECT g.geonameId geonameId, g.name name, 0 ispreferred, 0 isshort, 'geo' source FROM geonames g WHERE geonameId = {$geonameid} UNION SELECT a.geonameId geonameId, a.alternatename name, ispreferred, isshort, 'alt' source FROM geonamesalternatenames a WHERE geonameId = {$geonameid} AND isolanguage = '{$this->lang}' ORDER BY geonameId, ispreferred DESC, isshort DESC, source, name ) geo GROUP BY geonameId" | 1 |
|
| 'UPDATE activitiesattendees SET status = 1 WHERE activityId = ' . $activity->id | 1 |
|
| 'UPDATE activitiesattendees SET status = 4 WHERE activityId = ' . $activity->id | 1 |
|
| 'INSERT INTO activitiesattendees SET status=' . $status . ', comment=\'' . $this->dao->escape($post['activity-comment']) . '\', activityId = ' . $activity->id . ', attendeeId = ' . $this->getLoggedInMember( )->id | 1 |
|
| 'UPDATE activitiesattendees SET status=' . $status . ', comment=\'' . $this->dao->escape($post['activity-comment']) . '\' WHERE activityId = ' . $activity->id . ' AND attendeeId = ' . $this->getLoggedInMember( )->id | 1 |
|
| 'DELETE FROM activitiesattendees WHERE activityId = ' . $activity->id . ' AND attendeeId = ' . $this->getLoggedInMember( )->id | 1 |
|
| "SELECT a.* " | 1 |
|
| "SELECT COUNT(*) AS count " | 1 |
|
| "SELECT latitude, longitude FROM geonames WHERE geonameId = " . $loggedInMember->IdCity | 1 |
|
| "SELECT COUNT(*) FROM (" | 1 |
|
| "SELECT * FROM (" | 1 |
|
| "SELECT a.* FROM activities AS a, activitiesattendees AS aa WHERE a.id = aa.activityId AND aa.attendeeId = " . $member->id . " " | 1 |
|
| "INSERT INTO stats ( id , created , NbActiveMembers , NbMessageSent , NbMessageRead , NbMemberWithOneTrust , NbMemberWhoLoggedToday )VALUES (NULL ,CURRENT_TIMESTAMP , $NbActiveMembers , $NbMessageSent , $NbMessageRead , $NbMemberWithOneTrust , $NbMemberWhoLoggedToday )" | 1 |
|
| " SELECT status FROM membersgroups WHERE IdGroup=" . (int) $group->id . " AND IdMember=" . (int) $memberid | 1 |
|
| "select count(*) as cnt from polls_contributions where IdMember=" . $IdMember . " and IdPoll=" . $IdPoll | 1 |
|
| "select * from polls where id=" . $IdPoll . " and Status='Open' /* Add Vote */" | 1 |
|
| "select * from polls_choices where IdPoll=" . $IdPoll | 1 |
|
| "select * from polls_record_of_choices where IdMember=" . $this->session->get("IdMember") . " and IdPoll=" . $IdPoll | 1 |
|
| "Delete of ordered votes not implemented" | 1 |
|
| "select * from polls_record_of_choices where IdPoll=" . $IdPoll . " and " . $wherefordelete | 1 |
|
| "select * from polls_contributions where Email='" . $Email . "'" | 1 |
|
| "select * from polls_contributions where IdPoll=" . $IdPoll | 1 |
|
| "select count(*) as cnt from membersgroups as m,polls_list_allowed_groups as p where m.IdGroup=p.IdGroup and m.IdMember=" . $IdMember . " and m.Status='In' and p.IdPoll=" . $rPoll->id | 1 |
|
| "select count(*) as cnt from polls_list_allowed_groups as p where p.IdPoll=" . $rPoll->id | 1 |
|
| "update polls_choices set Counter=Counter+1 where id=" . $rContrib->id | 1 |
|
| "update polls_choices set Counter=Counter+1 where id=" . $post['ExclusiveChoice'] . " and IdPoll=" . $IdPoll | 1 |
|
| "select * from polls_choices where IdPoll=" . $IdPoll | 1 |
|
| "select * from polls_contributions where Email='" . $Email . "' and IdPoll=" . $IdPoll | 1 |
|
| "select * from polls_contributions where IdMember=" . $IdMember . " and IdPoll=" . $IdPoll | 1 |
|
| "select * from polls_choices where id=" . $IdPollChoice . " /* UpdatedChoice*/" | 1 |
|
| "SELECT UNIX_TIMESTAMP(MAX( p.create_time )) AS ts FROM groups AS g, forums_threads AS t, forums_posts AS p WHERE g.id = " . $this->id . " AND g.id = t.IdGroup AND t.last_postid = p.id" | 1 |
|
| "select * from polls where id=" . $IdPoll . " /* UpdatedChoice */" | 1 |
|
| "update polls_choices set IdChoiceText=$IdChoiceText where id=$IdChoice" | 1 |
|
| "insert into polls_choices(IdPoll,IdChoiceText,Counter,created) values(" . $rPoll->id . ",0,0,now())" | 1 |
|
| "select * from polls where id=" . $IdPoll . " /* Add Choice */" | 1 |
|
| "delete from polls_list_allowed_groups where IdPoll=" . $IdPoll | 1 |
|
| "update polls set IdCreator=" . $IdCreator . ",IdGroupCreator=" . $rPoll->IdGroupCreator | 1 |
|
| "select id from members where Username='" . $post['CreatorUsername'] . "' and Status='Active'" | 1 |
|
| "update polls set Title=$IdTitle,Description=$IdDescription where id=$IdPoll" | 1 |
|
| "insert into polls(IdCreator,IdGroupCreator,created,Title,Description,Status,AllowComment,ResultsVisibility,Started) " | 1 |
|
| "select comment,Username from polls_contributions,members where IdPoll=" . $IdPoll . " and comment <>'' and members.id=polls_contributions.IdMember" | 1 |
|
| "select *,(Counter/" . $TotContrib . ")*100 as Percent from polls_choices where IdPoll=" . $IdPoll . " order by Counter,created desc" | 1 |
|
| "select count(*) as TotContrib from polls_contributions where IdPoll=" . $IdPoll | 1 |
|
| "select * from polls where id=" . $IdPoll . " /* GetPollResults */" | 1 |
|
| 'Show Links between members' | 1 |
|
| "
SELECT * FROM `linklist` WHERE linklist.fromID = $fromid AND linklist.degree = $degree LIMIT " . (int) $limit | 1 |
|
| " SELECT id FROM languages WHERE ShortCode = '" . $this->dao->escape($langcode) . "' " | 1 |
|
| " UPDATE members SET Status = 'Active' WHERE members.id = $member_id and Status='OutOfRemind' " | 1 |
|
| " SELECT * FROM verifiedmembers WHERE IdVerified = $this->id ORDER BY Type desc limit 1 " | 1 |
|
| 'SELECT DISTINCT Category FROM mycontacts WHERE IdMember= ' . $this->id | 1 |
|
| "select SQL_CACHE count(*) as cnt from mycontacts where IdMember=" . $this->session->get("IdMember") | 1 |
|
| " SELECT SQL_CACHE id, ShortCode, Name FROM languages " | 1 |
|
| " SELECT SQL_CACHE * FROM memberstrads WHERE IdOwner = $this->id " | 1 |
|
| "SELECT SQL_CACHE languages.id,ShortCode,Name from memberstrads,languages where languages.id=memberstrads.IdLanguage and IdOwner = $this->id and IdTrad=$this->ProfileSummary" | 1 |
|
| "SELECT SQL_CACHE memberslanguageslevel.IdLanguage AS IdLanguage,languages.Name,languages.ShortCode AS ShortCode, " . "memberslanguageslevel.Level AS Level,WordCode FROM memberslanguageslevel,languages " . "WHERE memberslanguageslevel.IdMember=" . $this->id . " AND memberslanguageslevel.IdLanguage=languages.id AND memberslanguageslevel.Level != 'DontKnow' order by memberslanguageslevel.Level asc" | 1 |
|
| 'UPDATE addresses SET StreetName = ' . intval($cryptId) . ' WHERE IdMember = ' . $this->id . ' LIMIT 1' | 1 |
|
| 'UPDATE addresses SET HouseNumber = ' . intval($cryptId) . ' WHERE IdMember = ' . $this->id . ' LIMIT 1' | 1 |
|
| 'UPDATE addresses SET Zip = ' . intval($cryptId) . ' WHERE IdMember = ' . $this->id . ' LIMIT 1' | 1 |
|
| " SELECT SQL_CACHE user.id FROM user WHERE handle = '$this->Username' " | 1 |
|
| " INSERT INTO memberspreferences SET IdMember = " . $member->id . ", IdPreference = 1, Value = " . $this->session->get('IdLanguage') | 1 |
|
| " UPDATE user SET lastlogin = NOW() WHERE id = $tb_user_id " | 1 |
|
| " SELECT * FROM user WHERE handle = '$esc_handle' " | 1 |
|
| " SELECT comments.*, comments.Quality AS comQuality, comments.id AS id, comments.created, comments.updated, UNIX_TIMESTAMP(comments.created) unix_created, UNIX_TIMESTAMP(comments.updated) unix_updated FROM comments, members WHERE comments.IdToMember = $this->id AND comments.IdFromMember = " . $id . " AND comments.IdFromMember = members.Id " | 1 |
|
| " SELECT PASSWORD('$password') AS PassMysqlEncrypted " | 1 |
|
| " INSERT INTO user SET auth_id = $int_authId, handle = '$esc_handle', email = '', pw = '$esc_pwenc', active = 1 " | 1 |
|
| " INSERT IGNORE INTO user SET id = $member_id, auth_id = $int_authId, handle = '$esc_handle', email = '', pw = '$esc_pwenc', active = 1 " | 1 |
|
| " INSERT INTO mod_user_auth (id, name) VALUES (?, ?) " | 1 |
|
| " SELECT id FROM mod_user_auth WHERE name = '" . $this->dao->escape($authName) . "' " | 1 |
|
| " SELECT COUNT(*) cnt FROM ( SELECT g.geonameId FROM geonames g WHERE g.name LIKE '" . $this->dao->escape($place) | 1 |
|
| "SELECT * FROM geonames WHERE geonameId = " . $geonameId | 1 |
|
| "SELECT logs.*, Username " . "FROM " . $db . ".logs LEFT JOIN members ON members.id=logs.IdMember " . "WHERE 1=1 " . $where . " " . "ORDER BY created DESC LIMIT $start_rec," . $limitcount | 1 |
|
| " SELECT DISTINCT m.id, m.Username, Date(m.created) as 'created', m.BirthDate, m.HideBirthDate, m.Accomodation as 'Accommodation', m.TypicOffer, m.Restrictions, m.ProfileSummary, m.Occupation, m.Gender, m.HideGender, m.MaxGuest, m.HideAttribute, m.FirstName, m.SecondName, m.LastName, IF (m.accomodation = 'neverask', 0, m.hosting_interest) as hosting_interest, date_format(m.LastLogin,'%Y-%m-%d') AS LastLogin, IF(m.ProfileSummary != 0, 1, 0) AS HasProfileSummary, IF(mp.photoCount IS NULL, 0, 1) AS HasProfilePhoto, g.geonameId, g.country, g.latitude, g.longitude, ((g.latitude - " . $vars['location-latitude'] . ") * (g.latitude - " . $vars['location-latitude'] . ") + (g.longitude - " . $vars['location-longitude'] . ") * (g.longitude - " . $vars['location-longitude'] . ")) AS Distance, IF(c.IdToMember IS NULL, 0, c.commentCount) AS CommentCount, (hosting_interest * 5 + IF(mp.photoCount IS NULL, 0, 1) * 4 + IF(m.ProfileSummary != 0, 1, 0) * 3) as weighted, ((hosting_interest * 6) / (DATEDIFF(NOW(), m.LastLogin) + 7) + IF(mp.photoCount IS NULL, 0, 1) * 4 + IF(m.ProfileSummary != 0, 1, 0) * 3) as weighted2 *FROM* " . $this->tables . " LEFT JOIN ( SELECT COUNT(*) As commentCount, IdToMember FROM comments, members m2 WHERE IdFromMember = m2.id AND m2.Status IN ('Active', 'OutOfRemind') GROUP BY IdToMember ) c ON c.IdToMember = m.id LEFT JOIN ( SELECT COUNT(*) As photoCount, IdMember FROM membersphotos GROUP BY IdMember) mp ON mp.IdMember = m.id *WHERE* " . $this->maxGuestCondition . " " . $this->statusCondition . " " . $this->commentsCondition . | 1 |
|
| ' SELECT * FROM notes ' | 1 |
|
| 'Delete images' | 1 |
|
| "INSERT INTO `gallery_items_to_gallery` SET `gallery_id_foreign` = '" . $vars['galleryId'] . "', `item_id_foreign`= " . $itemId | 1 |
|
| ' INSERT INTO `gallery_items` (`id`, `user_id_foreign`, `file`, `original`, `flags`, `mimetype`, `width`, `height`, `title`, `created`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, NOW()) ' | 1 |
|
| " SELECT comments.*, comments.Quality AS comQuality, comments.id AS id, comments.created, comments.updated, UNIX_TIMESTAMP(comments.created) unix_created, UNIX_TIMESTAMP(comments.updated) unix_updated, members.username AS UsernameFromMember, members2.username AS UsernameToMember FROM comments, members, members as members2 WHERE comments.IdToMember = " . $this->id . " AND comments.IdFromMember = members.Id AND comments.IdToMember = members2.Id AND members.Status IN (" . MemberStatusType::MEMBER_COMMENTS . ") ORDER BY comments.updated DESC " | 1 |
|
| " SELECT id FROM membersphotos WHERE IdMember = " . $this->id . " ORDER BY SortOrder ASC LIMIT 1 " | 1 |
|
| ' SELECT DISTINCT g.`id` AS `id`, `user_id_foreign`, `flags`, `title`, `text` FROM `gallery` AS g LEFT JOIN `gallery_items_to_gallery` AS gi ON g.`id` = gi.`gallery_id_foreign` WHERE g.`id` = gi.`gallery_id_foreign` AND g.`user_id_foreign` = ' . (int) $UserId . ' ORDER BY `id` DESC' | 1 |
|
| " INSERT INTO comments ( IdToMember, IdFromMember, Relations, Quality, TextWhere, TextFree, AdminAction, created, updated ) values ( " . $vars['IdMember'] . ", " . $this->session->get('IdMember') . ", '" . $LenghtComments . "','" . $vars['Quality'] . "', '', '" . $this->dao->escape($vars['TextFree']) . "', '" . $AdminAction . "', now(), now() )" | 1 |
|
| " DELETE FROM " . $cryptedTable . " WHERE id IN ( '" . implode("', '", $cryptedFields) . "') " | 1 |
|
| "DELETE FROM mycontacts WHERE IdMember = " . $loggedInMember->id . " AND IdContact = " . $memberId | 1 |
|
| "INSERT INTO mycontacts SET IdMember = " . $loggedInMember->id . ", IdContact = " . $member->id . ", Created = NOW(), Category = '" . $this->dao->escape($category) . "'" . ", Comment = '" . $this->dao->escape($comment) . "'" | 1 |
|
| "UPDATE mycontacts SET Updated = NOW(), Category = '" . $this->dao->escape($category) . "'" . ", Comment = '" . $this->dao->escape($comment) . "' WHERE IdMember = " . $loggedInMember->id . " AND IdContact = " . $member->id | 1 |
|
| "SELECT * FROM mycontacts WHERE IdMember = " . $loggedInMember->id . " AND IdContact = " . $member->id | 1 |
|
| " INSERT INTO `membersphotos` ( FilePath, IdMember, created, SortOrder, Comment ) VALUES ( '" . $this->avatarDir->dirName( ) . "/" . $memberid . "', " . $memberid . ", now(), -1, '' ) " | 1 |
|
| "update of another profile <b>" . $m->Username . "</b>" | 1 |
|
| "select * from preferences" | 1 |
|
| "select password, PASSWORD('" . $vars['passwordold'] . "') AS mysql from members where id=" . $this->session->get('IdMember') | 1 |
|
| " DELETE FROM specialrelations WHERE id = '$id' " | 1 |
|
| "select * from specialrelations where IdOwner=" . $vars['IdRelation'] . " AND IdRelation=" . $vars['IdOwner'] | 1 |
|
| "select * from specialrelations where IdOwner=" . $vars['IdOwner'] . " AND IdRelation=" . $vars['IdRelation'] | 1 |
|
| " INSERT INTO specialrelations ( IdOwner, IdRelation, Type, Comment, created ) values ( " . $this->session->get("IdMember") . ", " . $vars['IdRelation'] . ", '" . stripslashes($vars['stype']) . "', " . $words->InsertInMTrad($this->dao->escape($vars['Comment']), "specialrelations.Comment", 0) . ", now() )" | 1 |
|
| <<<SQL INSERT INTO memberspreferences (IdMember, IdPreference, Value, created) VALUES ('{$IdMember}', '{$IdPreference}', '{$Value}', NOW()) SQL | 1 |
|
| "SELECT * FROM rightsvolunteers AS rv, rights AS r WHERE rv.IdMember = {$this->getPKValue( )} AND rv.IdRight = r.id AND rv.Level > 0" | 1 |
|
| "select preferences.codeName from preferences where id='{$IdPreference}'" | 1 |
|
| "select memberspreferences.id as id,Value from memberspreferences,preferences where IdMember='{$IdMember}' and IdPreference=preferences.id and preferences.id='{$IdPreference}'" | 1 |
|
| "Update profile" | 1 |
|
| " SELECT SQL_CACHE id,ShortCode, Name,WordCode FROM languages WHERE shortcode = '$langcode' " | 1 |
|
| " SELECT SQL_CACHE id,ShortCode, Name,WordCode FROM languages WHERE id = '$langcode' " | 1 |
|
| " UPDATE addresses SET IdCity = {$geonameid} WHERE IdMember = {$member->id} and Rank=" . $rank | 1 |
|
| " SELECT COUNT(m.id) FROM members AS m, {$this->getTableName( )} AS p WHERE p.IdMember = {$member->getPKValue( )} AND p.IdVisitor = m.id " | 1 |
|
| <<<SQL SELECT m.*, p.updated FROM members AS m, {$this->getTableName( )} AS p WHERE m.id = p.IdVisitor AND p.IdMember = {$member->getPKValue( )} AND m.Status NOT IN ('Banned', 'TakenOut', 'Rejected','ActiveHidden', 'Buggy') ORDER BY p.updated DESC LIMIT {$pager->getActiveStart( )}, {$pager->getActiveLength( )} SQL | 1 |
|
| "DELETE FROM {$this->getTableName( )} WHERE IdMember = '{$this->dao->escape($member->getPKValue( ))}'" | 1 |
|
| " SELECT SQL_CACHE l.Name AS Name, l.ShortCode AS ShortCode, l.WordCode AS WordCode, l.id AS id FROM languages AS l WHERE (l.IsWrittenLanguage = 1) " | 1 |
|
| ' DELETE FROM members->sessions WHERE (IdMember = ' . (int) $this->id . ' AND SeriesToken = \'' . $seriesTokenEsc . '\') OR modified < NOW() - INTERVAL ' . PVars::getObj('env')->rememberme_expiry . ' DAY' | 1 |
|
| ' INSERT INTO members->sessions (IdMember, AuthToken, SeriesToken) VALUES (' . (int) $this->id . ', \'' . $authToken . '\', \'' . $seriesToken . '\')' | 1 |
|
| "delete from online where IdMember={$this->getPKValue( )}" | 1 |
|
| "UPDATE `members` SET `PassWord` = ? WHERE `id` = ?" | 1 |
|
| <<<SQL SELECT DISTINCT `id`, `user_id_foreign`, `flags`, `title`, `text` FROM `gallery` LEFT JOIN `gallery_items_to_gallery` AS `g` ON g.`gallery_id_foreign` = g.`gallery_id_foreign` WHERE g.`gallery_id_foreign` = gallery.`id` ORDER BY `id` DESC SQL | 1 |
|
| "SELECT id, HouseNumber as hn, streetname as sn, Zip as zp from addresses" | 1 |
|
| ' DELETE FROM `gallery` WHERE `id` = ' . (int) $galleryId . ' ' | 1 |
|
| 'SELECT `items`, `data` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(:feed, :count, :data, :time)' | 1 |
|
| 'SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `id` = ' . implode(' OR `id` = ', $database_ids) . ' AND `feed_id` = :feed' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'items` (`feed_id`, `id`, `data`, `posted`) VALUES(:feed, :id, :data, :date)' | 1 |
|
| 'SELECT `id` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :feed' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `items` = 0, `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'INSERT INTO `' . $this->options['extras']['prefix'] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(:id, 0, :data, :time)' | 1 |
|
| 'SELECT `data` FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `feed_id` = :feed ORDER BY `posted` DESC' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `items` = :items, `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'SELECT `mtime` FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `mtime` = :time WHERE `id` = :id' | 1 |
|
| 'DELETE FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :id' | 1 |
|
| 'DELETE FROM `' . $this->options['extras']['prefix'] . 'items` WHERE `feed_id` = :id' | 1 |
|
| ' DELETE FROM `gallery_items_to_gallery` WHERE `gallery_id_foreign`= ' . (int) $galleryId . ' ' | 1 |
|
| " INSERT INTO rights SET `Name` = '" . $this->dao->escape($vars['name']) . "', `Description` = '" . $this->dao->escape($vars['description']) . "'" | 1 |
|
| 'UPDATE `' . $this->options['extras']['prefix'] . 'cache_data` SET `data` = :data, `mtime` = :time WHERE `id` = :feed' | 1 |
|
| 'SELECT COUNT(*) FROM `' . $this->options['extras']['prefix'] . 'cache_data` WHERE `id` = :feed' | 1 |
|
| " INSERT INTO broadcast SET Type = '" . $type . "', Name = '" . $name . "', created = NOW(), Status = 'Created', IdCreator = " . $this->session->get("IdMember") | 1 |
|
| "SELECT * FROM languages WHERE " | 1 |
|
| "SELECT COUNT(*) AS n " . "FROM " . $db . ".logs LEFT JOIN members ON members.id=logs.IdMember " . "WHERE 1=1 " . $where | 1 |
|
| " SELECT SUM(LENGTH(sentence)) AS cnt FROM words WHERE IdLanguage=0 AND (NOT donottranslate='yes') AND (isarchived=0 OR isarchived is NULL)" | 1 |
|
| ' SELECT languages.EnglishName englishName, languages.shortcode shortCode, SUM(LENGTH(w2.sentence)) translated FROM words w1 JOIN words w2 ON w2.code = w1.code AND w2.IdLanguage=0 JOIN languages ON w1.idlanguage=languages.id WHERE (NOT w2.donottranslate="yes") AND (w2.isarchived = 0 OR w2.isarchived is NULL) AND w2.updated<=w1.updated ' . $strLang . ' GROUP BY w1.idlanguage ORDER BY SUM(LENGTH(w2.sentence)) DESC' | 1 |
|
| 'SELECT Sentence FROM words WHERE idlanguage=0 AND code="' . $code . '"' | 1 |
|
| 'SELECT code FROM words WHERE id=' . (int) $id | 1 |
|
| ' SELECT count(*) cnt FROM words WHERE code="' . $this->dao->escape($code) . '" AND shortcode="' . $this->dao->escape($shortcode) . '"' | 1 |
|
| 'UPDATE words SET updated = NOW() WHERE id = ' . (int) $id | 1 |
|
| 'SHOW TABLES' | 1 |
|
| ' INSERT INTO words SET code = "' . $this->dao->escape($form["EngCode"]) . '", ShortCode = "' . $this->dao->escape($form["lang"]) . '", IdLanguage = (SELECT id FROM languages WHERE shortcode="' . $this->dao->escape($form["lang"]) . '"), Sentence = "' . $this->dao->escape($form["Sentence"]) . '", updated = now(), ' . $eng_ins . $desc . ' IdMember = ' . (int) $this->session->get("IdMember") . ', created = now() ON DUPLICATE KEY UPDATE ' . $eng_upd . $desc . ' Sentence = "' . $this->dao->escape($form["Sentence"]) . '"' | 1 |
|
| ' UPDATE words SET ' . $changeInAll . 'updated = updated WHERE code = "' . $form["EngCode"] . '" ' | 1 |
|
| ' SELECT count(id) AS cnt FROM words WHERE code = "' . $this->dao->escape($form['EngCode']) . '" AND idLanguage=0 ' | 1 |
|
| " INSERT INTO flagsmembers SET IdFlag = '" . $this->dao->escape($vars['flagid']) . "', IdMember = '" . $member->id . "', Scope = '" . $this->dao->escape($vars['scope']) . "', Level = '" . $this->dao->escape($vars['level']) . "', Comment = '" . $this->dao->escape($vars['comment']) . "', created = NOW()" | 1 |
|
| " INSERT INTO flags SET `Name` = '" . $this->dao->escape($vars['name']) . "', `Description` = '" . $this->dao->escape($vars['description']) . "', `Relevance` = '100' " | 1 |
|
| " INSERT INTO donations SET IdMember = " . $memberid . ", Email = '', StatusPrivate = 'showamountonly', created = '" . $donatedon . "', Amount = " . $amount . ", Money = '', IdCountry = " . $countryid . ", namegiven = '', referencepaypal = '', membercomment = '', SystemComment = '" . $this->dao->escape($comment) . "'" | 1 |
|
| "SELECT id, EnglishName FROM languages WHERE id IN ('" . implode("', '", $languages) . "')" | 1 |
|
| " INSERT INTO rightsvolunteers SET IdRight = '" . $this->dao->escape($vars['rightid']) . "', IdMember = '" . $member->id . "', Scope = '" . $this->dao->escape($vars['scope']) . "', Level = '" . $this->dao->escape($vars['level']) . "', Comment = '" . $this->dao->escape($vars['comment']) . "', created = NOW()" | 1 |
|
| " INSERT INTO words SET code = 'broadcast_title_" . $name . "', ShortCode = 'en', IdLanguage = 0, `domain` = 'messages+intl-icu', Sentence = '" . $this->dao->escape($subject) . "', updated = NOW(), created = NOW(), majorupdate = NOW(), isarchived = NULL, donottranslate = 'no', IdMember = " . $this->getLoggedInMember( )->id . ", Description = '" . $this->dao->escape($description) . "'" | 1 |
|
| "UPDATE $tableName " | 1 |
|
| "INSERT INTO `gallery_items_to_gallery` SET `gallery_id_foreign` = '" . $vars['gallery'] . "', `item_id_foreign`= " . $vars['id'] | 1 |
|
| "UPDATE `gallery_items_to_gallery` SET `gallery_id_foreign` = '" . $vars['gallery'] . "' WHERE `item_id_foreign`= " . $vars['id'] | 1 |
|
| " INSERT INTO words SET code = 'broadcast_body_" . $name . "', ShortCode = 'en', IdLanguage = 0, `domain` = 'messages+intl-icu', Sentence = '" . $this->dao->escape($body) . "', updated = NOW(), created = NOW(), majorupdate = NOW(), isarchived = NULL, donottranslate = 'no', IdMember = " . $this->getLoggedInMember( )->id . ", Description = '" . $this->dao->escape($description) . "'" | 1 |
|
| "UPDATE `gallery_items` SET `title` = '" . $vars['t'] . "' , `description` = '" . $vars['txt'] . "' WHERE `id`= " . $vars['id'] | 1 |
|
| "UPDATE `gallery` SET `title` = '" . $vars['t'] . "' , `description` = '" . $vars['txt'] . "' WHERE `id`= " . $vars['id'] | 1 |
|
| ' DELETE FROM `gallery_items_to_gallery` WHERE `item_id_foreign`= ' . (int) $image->id | 1 |
|
| ' INSERT INTO `gallery` (`id`, `user_id_foreign`, `flags`, `title`, `text`) VALUES (' . $this->dao->nextId('gallery') . ', ' . (int) $member->id . ', 0, \'' . $this->dao->escape($title) . '\', \'' . ($desc ? $this->dao->escape($desc) : '') . '\') ' | 1 |
|
| ' DELETE FROM `gallery_items` WHERE `id` = ' . (int) $image->id | 1 |
|
| "DELETE FROM `gallery_items_to_gallery` WHERE `item_id_foreign`= " . $d | 1 |
|
| " SELECT DISTINCT m.id, m.Username, m.created, m.Status, m.BirthDate, m.HideBirthDate, m.Accomodation, m.TypicOffer, m.Restrictions, m.ProfileSummary, m.Occupation, m.Gender, m.HideGender, m.FirstName, m.SecondName, m.LastName, m.Email, m.bewelcomed, g.geonameId as geonameId, g.country as country FROM members m, geonames g WHERE m.Status IN (" . $statuses . ") AND DATEDIFF(NOW(), created) < 90" | 1 |
|
| "SELECT id, Name FROM groups ORDER BY Name" | 1 |
|
| "SELECT id FROM preferences WHERE codeName = '" . $pref . "'" | 1 |
|
| "SELECT id,Name FROM groups WHERE id IN ('" . implode("', '", $this->enqueueGroups) . "') ORDER BY Name" | 1 |
|
| "SELECT country,name FROM geonamescountries WHERE country IN ('" . implode("', '", $this->enqueueCountries) . "') ORDER BY name" | 1 |
|
| " DELETE FROM broadcastmessages WHERE Status = 'ToSend' AND IdBroadcast = " . $id | 1 |
|
| " DELETE FROM broadcastmessages WHERE Status = 'ToApprove' AND IdBroadcast = " . $id | 1 |
|
| "INSERT INTO `gallery_items_to_gallery` SET `gallery_id_foreign` = '" . $this->dao->escape($vars['gallery']) . "',`item_id_foreign`= " . $d | 1 |
|
| "select count(*) as cnt from polls_contributions where IdPoll=" . $rr->id | 2 |
|
| "Delete Comment" | 2 |
|
| "SELECT FOUND_ROWS() as cnt" | 2 |
|
| 'Update links' | 2 |
|
| "SELECT * from cryptedfields where id IN (" . $row['ids'] . ")" | 2 |
|
| "select SQL_CACHE DefaultValue from preferences where codeName='" . $namepref . "'" | 2 |
|
| "Update order" | 2 |
|
| "SELECT a.* FROM activities AS a WHERE " | 2 |
|
| "select * from groups where id=" . $rr->IdGroupCreator | 2 |
|
| "SELECT a.* FROM activities AS a, geonames AS g WHERE " | 2 |
|
| "SELECT a.* FROM activities AS a, geonames AS g, geonamescountries AS gc WHERE " | 2 |
|
| 'Show map' | 2 |
|
| "select * from specialrelations where IdRelation=" . $vars["IdRelation"] . " and IdOwner=" . $this->session->get("IdMember") | 2 |
|
| "SELECT country,name FROM geonamescountries ORDER BY name" | 2 |
|
| <<<SQL SELECT * FROM `{$this->getTableName( )}` WHERE {$where} SQL | 2 |
|
| "select * from forum_trads where IdTrad=" . $vars["IdTrad"] . " and IdLanguage=" . $vars["IdLanguage"] | 2 |
|
| "insert into polls_list_allowed_groups(IdPoll,IdGroup) values(" . $IdPoll . "," . $IdGroup . ") " | 2 |
|
| "insert into polls_contributions(IdMember,Email,created,comment,IdPoll) values (" . $IdMember . ",'" . $Email . "',now(),'" . $this->dao->escape($post['Comment']) . "'," . $IdPoll . ")" | 2 |
|
| "SHOW COLUMNS FROM $table LIKE '$column'" | 2 |
|
| "insert into polls_record_of_choices(IdMember,Email,created,IdPollChoice,IdPoll) values (" . $IdMember . ",'" . $Email . "',now()," . $Choice . "," . $IdPoll . ")" | 2 |
|
| "Update Order" | 2 |
|
| "select IdGroup from membersgroups where IdMember=" . $IdMember . " and IdGroup=" . $rPost->IdGroup . " and Status='In'" | 2 |
|
| "update post" | 2 |
|
| "update polls_choices set Counter=Counter-1 where id=" . $rContrib[$ii]->IdPollChoice | 2 |
|
| "delete from polls_contributions where IdPoll=" . $IdPoll . " and " . $wherefordelete | 2 |
|
| "delete from polls_record_of_choices where IdPollChoice=" . $IdPoll . " and " . $wherefordelete | 2 |
|
| "Update Preference" | 2 |
|
| "Show Comment" | 2 |
|
| "SHOW FULL TABLES WHERE Table_Type = 'BASE TABLE'" | 3 |
|
| "select * from polls where id=" . $IdPoll | 3 |
|
| " SELECT SQL_CACHE Sentence FROM memberstrads WHERE IdTrad = $IdTrad ORDER BY id ASC LIMIT 1 " | 3 |
|
| " SELECT SQL_CACHE Sentence FROM memberstrads WHERE IdTrad = $IdTrad AND IdLanguage = 0 " | 3 |
|
| " SELECT SQL_CACHE Sentence FROM memberstrads WHERE IdTrad = $IdTrad AND IdLanguage= $IdLanguage " | 3 |
|
| " SELECT * FROM " . $crypt_db . "cryptedfields WHERE id = $IdCrypt " | 5 |
|