List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| " INSERT INTO `{$pixie_prefix}pixie_settings` (`settings_id`, `site_name`, `site_keywords`, `site_url`, `site_theme`, `site_copyright`, `site_author`, `default_page`, `clean_urls`, `version`, `language`, `timezone`, `dst`, `date_format`, `logs_expire`, `rich_text_editor`, `system_message`, `last_backup`) VALUES (1, '-', '-', '-', '-', '', '', '-', 'no', '-', '-', '-', 'yes', '-', '-', 1, '', ''); " | 1 |
|
| 'Select a file for upload.' | 1 |
|
| 'INSERT INTO `' . $this->options['prefix'][0] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(' . $feed_id . ', ' . count($prepared[1]) . ', \'' . mysql_real_escape_string($prepared[0]) . '\', ' . time( ) . ')' | 1 |
|
| 'SELECT `id` FROM `' . $this->options['prefix'][0] . 'items` WHERE `id` = \'' . implode('\' OR `id` = \'', $database_ids) . '\' AND `feed_id` = ' . $feed_id | 1 |
|
| 'INSERT INTO `' . $this->options['prefix'][0] . 'items` (`feed_id`, `id`, `data`, `posted`) VALUES(' . $feed_id . ', \'' . mysql_real_escape_string($new_id) . '\', \'' . mysql_real_escape_string(serialize($prepared[1][$new_id]->data)) . '\', ' . $date . ')' | 1 |
|
| 'UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `items` = 0, `data` = \'' . mysql_real_escape_string(serialize($data)) . '\', `mtime` = ' . time( ) . ' WHERE `id` = ' . $feed_id | 1 |
|
| 'INSERT INTO `' . $this->options['prefix'][0] . 'cache_data` (`id`, `items`, `data`, `mtime`) VALUES(\'' . mysql_real_escape_string($this->id) . '\', 0, \'' . mysql_real_escape_string(serialize($data)) . '\', ' . time( ) . ')' | 1 |
|
| 'SELECT `items`, `data` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'" | 1 |
|
| 'SELECT `data` FROM `' . $this->options['prefix'][0] . 'items` WHERE `feed_id` = \'' . mysql_real_escape_string($this->id) . '\' ORDER BY `posted` DESC' | 1 |
|
| 'SELECT `mtime` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'" | 1 |
|
| 'UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `mtime` = ' . time( ) . ' WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'" | 1 |
|
| 'DELETE FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = \'' . mysql_real_escape_string($this->id) . "'" | 1 |
|
| 'DELETE FROM `' . $this->options['prefix'][0] . 'items` WHERE `feed_id` = \'' . mysql_real_escape_string($this->id) . "'" | 1 |
|
| 'Select the file(s) for upload.' | 1 |
|
| 'Delete file?' | 1 |
|
| 'select * from ' . PFX . 'pixie_log_users_online' | 1 |
|
| "show fields from $table_name" | 1 |
|
| "select * from $table_name $condition order by $order_by $asc_desc" | 1 |
|
| "select * from $table_name where {$edit_id}={$edit}" | 1 |
|
| 'show fields from ' . PFX . "$table_name" | 1 |
|
| 'select * from ' . PFX . "$table_name WHERE 1=0" | 1 |
|
| 'show fields from ' . adjust_prefix($table_name) | 1 |
|
| 'select * from ' . adjust_prefix($table_name) . ' WHERE 1=0' | 1 |
|
| "DELETE FROM `" . $settings['log_table'] . "` WHERE `date` < DATE_SUB('" . bb2_db_date( ) . "', INTERVAL 7 DAY)" | 1 |
|
| "SHOW TABLES FROM $pixie_database" | 1 |
|
| " INSERT INTO `{$pixie_prefix}pixie_core` (`page_id`, `page_type`, `page_name`, `page_display_name`, `page_description`, `page_blocks`, `page_content`, `page_views`, `page_parent`, `privs`, `publish`, `public`, `in_navigation`, `page_order`, `searchable`, `last_modified`) VALUES (1, 'static', '404', 'Error 404', 'Page not found.', '', '<p>The page you are looking for cannot be found.</p>', 11, '', 2, 'yes', 'yes', 'no', 0, 'no', '2008-01-01 00:00:11'), (2, 'plugin', 'comments', 'Comments', 'This plugin enables commenting on dynamic pages.', '', '', 1, '', 2, 'yes', 'yes', 'no', 0, 'no', '2008-01-01 00:00:11'); " | 1 |
|
| " INSERT INTO `{$pixie_prefix}pixie_files` (`file_id`, `file_name`, `file_extension`, `file_type`, `tags`) VALUES (1, 'rss_feed_icon.gif', 'gif', 'Image', 'rss feed icon'), (2, 'no_grav.jpg', 'jpg', 'Image', 'gravitar icon'), (3, 'apple_touch_icon.jpg', 'jpg', 'Image', 'icon apple touch'), (4, 'apple_touch_icon_pixie.jpg', 'jpg', 'Image', 'icon apple touch pixie'); " | 1 |
|
| 'UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `data` = \'' . mysql_real_escape_string($prepared[0]) . '\', `mtime` = ' . time( ) . ' WHERE `id` = ' . $feed_id | 1 |
|
| 'UPDATE `' . $this->options['prefix'][0] . 'cache_data` SET `items` = ' . $items . ', `data` = \'' . mysql_real_escape_string($prepared[0]) . '\', `mtime` = ' . time( ) . ' WHERE `id` = ' . $feed_id | 1 |
|
| "UPDATE `" . PFX . "pixie_settings` SET `bb2_installed`='yes'" | 1 |
|
| "delete from $table where $where" | 1 |
|
| 'Delete entry' | 1 |
|
| 'Select the module or plugin you wish to activate' | 1 |
|
| 'Delete Account' | 1 |
|
| 'Select your current time zone so Pixie can display the correct times.' | 1 |
|
| 'Select a file from your computer to upload.' | 1 |
|
| 'SELECT * FROM pixie_module_comments ORDER BY comments_id DESC' | 1 |
|
| "SELECT comment FROM pixie_module_comments WHERE comments_id='$last_comment_last_number'" | 1 |
|
| "INSERT INTO `pixie_module_contact_settings` (`contact_id`, `show_profile_information`, `show_vcard_link`) VALUES (1, 'no', 'no');" | 1 |
|
| "INSERT INTO `pixie_module_events_settings` (`events_id`, `google_calendar_links`, `number_of_events`) VALUES (1, 'yes', '10');" | 1 |
|
| 'select * from ' . $pixieconfig['table_prefix'] . 'pixie_log_users_online' | 1 |
|
| 'select * from ' . $pixieconfig['table_prefix'] . "pixie_log where user_id = 'Visitor' and log_type = 'referral'" | 1 |
|
| 'select * from ' . $pixieconfig['table_prefix'] . 'pixie_bad_behavior' | 1 |
|
| "update $table set $set where $where" | 1 |
|
| "insert into $table set $set" | 1 |
|
| 'INSERT INTO ' . $table . ' VALUES (' . $values . ');' . MSB_NL | 1 |
|
| 'SELECT * FROM ' . $table | 1 |
|
| 'SHOW CREATE TABLE ' . $table | 1 |
|
| 'SELECT last_visit FROM ' . PFX . "pixie_log_users_online WHERE visitor = '$ip'" | 1 |
|
| "select * from $table_name WHERE 1=0" | 1 |
|
| "select * from $table where $condition" | 1 |
|
| "select $col from $table where `$key` = '$val' limit 1" | 1 |
|
| "select * from $table_name $condition order by $order_by $asc_desc limit $lo,$view_number" | 2 |
|
| "select count(*) from $table where $where" | 2 |
|
| 'Select your preferred date and time format.' | 2 |
|
| 'SELECT `id` FROM `' . $this->options['prefix'][0] . 'cache_data` WHERE `id` = ' . $feed_id | 2 |
|
| "select $thing from $table where $where" | 2 |
|
| 'Select the language you wish to use.' | 2 |
|
| "select * from $table_name where tags REGEXP '[[:<:]]" . $tag . "[[:>:]]' order by $order_by $asc_desc" | 3 |
|
| "select * from $table_name where " . $search_sql . " order by $order_by $asc_desc" | 3 |
|
| "select * from $table_name where page_id = '$page_id' and (" . $search_sql . ") order by $order_by $asc_desc" | 3 |
|
| 'SHOW TABLES' | 3 |
|
| "select $things from $table where $where" | 3 |
|