SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
"insert into {$collection} (`uuid`, `_id`, `siteid`, `entity_subtype`,`owner`, `contents`, `publish_status`, `created`) values (:uuid, :id, :siteid, :subtype, :owner, :contents, :publish_status, :created) on duplicate key update `uuid` = :uuid, `entity_subtype` = :subtype, `owner` = :owner, `contents` = :contents, `publish_status` = :publish_status, `created` = :created"1
  • /Idno/Data/MySQL.php
"insert into {$collection}_search (`_id`, `search`) values (:id, :search) on duplicate key update `search` = :search"1
  • /Idno/Data/MySQL.php
"delete from {$collection}_metadata where _id = :id"1
  • /Idno/Data/MySQL.php
"insert into {$collection}_metadata set `_id` = :id, `name` = :name, `value` = :value"1
  • /Idno/Data/MySQL.php
"select distinct {$collection}.* from " . $collection . " where uuid = :uuid"1
  • /Idno/Data/MySQL.php
"select {$collection}.* from " . $collection . " where _id = :id"1
  • /Idno/Data/MySQL.php
"select {$collection}.* from " . $collection . " order by created desc limit 1"1
  • /Idno/Data/MySQL.php
"select distinct {$collection}.* from {$collection} "1
  • /Idno/Data/MySQL.php
"select * from {$collection} limit {$offset},{$limit}"1
  • /Idno/Data/MySQL.php
'insert into ' . $collection . ' '1
  • /Idno/Data/MySQL.php
"select * from {$collection}_metadata where `_id` = :uuid"1
  • /Idno/Data/MySQL.php
"insert into {$collection}_metadata "1
  • /Idno/Data/MySQL.php
"select count(distinct {$collection}.uuid) as total from {$collection} "1
  • /Idno/Data/MySQL.php
"delete from {$collection} where _id = :id"1
  • /Idno/Data/MySQL.php
"delete from {$collection}"1
  • /Idno/Data/MySQL.php
"select * from versions"1
  • /Idno/Data/AbstractSQL.php
'Delete page'1
  • /IdnoPlugins/StaticPages/templates/default/staticpages/admin.tpl.php
'Show advanced options'1
  • /IdnoPlugins/StaticPages/templates/default/entity/StaticPage/edit.tpl.php
'Show the page title as a heading?'1
  • /IdnoPlugins/StaticPages/templates/default/entity/StaticPage/edit.tpl.php
'Select a photo'1
  • /templates/default/forms/input/image-file.tpl.php
'Select an image'1
  • /templates/default/file/picker/image.tpl.php
'Select a user picture'1
  • /templates/default/entity/User/edit.tpl.php
'Select Known export file'1
  • /templates/default/admin/import.tpl.php
'Select WordPress export file'1
  • /templates/default/admin/import.tpl.php
'Show per-post privacy settings.'1
  • /templates/default/admin/home.tpl.php
'Select yes if you use secure logins to your mail server.'1
  • /templates/default/admin/email.tpl.php
'Select <em>Always Show Bookmarks Bar</em> from the <em>View</em> menu.'1
  • /templates/default/account/settings/tools.tpl.php
'Select <em>View</em>, then <em>Toolbars</em>, and make sure'1
  • /templates/default/account/settings/tools.tpl.php
'Select <em>Tools</em>, then make sure <em>Favorites Bar</em> is checked.'1
  • /templates/default/account/settings/tools.tpl.php
'Update your background image and other display settings.'1
  • /Themes/Cherwell/templates/default/admin/cherwell.tpl.php
"Delete %s"8
  • /IdnoPlugins/Like/Pages/Delete.php
  • /IdnoPlugins/StaticPages/Pages/Delete.php
  • /IdnoPlugins/Status/Pages/Delete.php
  • /IdnoPlugins/Text/Pages/Delete.php
  • /IdnoPlugins/Event/Pages/Delete.php
  • /IdnoPlugins/Event/Pages/RSVP/Delete.php
  • /IdnoPlugins/Photo/Pages/Delete.php
  • /IdnoPlugins/Media/Pages/Delete.php