SELECT app_directory, app_public_title, app_enabled FROM ipncore_applications
SELECT * FROM ipncache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navigation_tabs','module_cache','hooks','useragents','useragentgroups','skinsets','outputformats','skin_remap','group_cache','settings','lang_data','banfilters','stats','badwords','bbcode','mediatag','profilefields','rss_output_cache','rss_export','indev','attachtypes','multimod','moderators','announcements','report_cache','report_plugins','ranks','reputation_levels','chatting','birthdays','calendar_events','calendars','support_staff','support_departments','support_statuses','donation_goals','blog_stats','blogmods','idm_cats','idm_mods' )
DELETE FROM ipnsessions WHERE (ip_address='38.107.179.243') OR running_time < 1327732110
SELECT f.*,p.* FROM ipnforums f LEFT JOIN ipnpermission_index p ON ( p.perm_type='forum' AND p.app='forums' AND p.perm_type_id=f.id )
SELECT * FROM ipnskin_cache WHERE cache_set_id=1 AND cache_type IN ('css', 'replacements')
SELECT id, member_id, member_name, seo_name, login_type, running_time, member_group, uagent_type FROM ipnsessions WHERE running_time > 1327734810
SELECT * FROM ipncore_applications ORDER BY app_position ASC
SELECT rss_export_title, rss_export_id FROM ipnrss_export WHERE rss_export_enabled=1
SELECT t.tid, t.title as topic_title, t.title_seo, t.start_date, t.starter_id, t.starter_name, t.moved_to, t.views, t.posts,m.*,pp.* FROM ipntopics t LEFT JOIN ipnmembers m ON ( m.member_id=t.starter_id )
LEFT JOIN ipnprofile_portal pp ON ( m.member_id=pp.pp_member_id ) WHERE t.tid IN (31,30,29,28,27)
SELECT * FROM ipncache_store WHERE cs_key IN ( 'gallery_fattach' )
SHUTDOWN: INSERT INTO ipnsessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`ip_address`,`browser`,`in_error`,`current_appcomponent`,`current_module`,`current_section`,`location_1_type`,`location_1_id`,`location_2_type`,`location_2_id`,`location_3_type`,`location_3_id`,`uagent_key`,`uagent_version`,`uagent_type`,`uagent_bypass`) VALUES('23327bf28d94998ffbf20de65a64e449','',0,2,0,1327735710,'38.107.179.243','CCBot/1.0 (+http://www.commoncrawl.org/bot.html)',0,'forums','','','',0,'',0,'',0,'__NONE__',0,'',0)
SHUTDOWN: INSERT INTO ipncache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'app_cache','a:7:{s:4:\"core\";a:21:{s:6:\"app_id\";s:1:\"1\";s:9:\"app_title\";s:6:\"System\";s:16:\"app_public_title\";s:10:\"Help Files\";s:15:\"app_description\";s:32:\"Manage global tools and settings\";s:10:\"app_author\";s:29:\"Invision Power Services, Inc.\";s:11:\"app_version\";s:5:\"3.2.1\";s:16:\"app_long_version\";s:5:\"32004\";s:13:\"app_directory\";s:4:\"core\";s:9:\"app_added\";s:10:\"1313444531\";s:12:\"app_position\";s:1:\"1\";s:13:\"app_protected\";s:1:\"1\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:4:\"root\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:0:\"\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:0:\"\";s:6:\"search\";a:3:{s:10:\"can_search\";i:1;s:18:\"can_viewNewContent\";i:0;s:15:\"can_userContent\";i:0;}s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:1;s:8:\"comments\";b:1;s:4:\"like\";b:0;s:6:\"search\";b:1;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:0:{}}s:15:\"hasCustomHeader\";i:0;}s:7:\"members\";a:21:{s:6:\"app_id\";s:1:\"2\";s:9:\"app_title\";s:7:\"Members\";s:16:\"app_public_title\";s:7:\"Members\";s:15:\"app_description\";s:25:\"Manage members and groups\";s:10:\"app_author\";s:29:\"Invision Power Services, Inc.\";s:11:\"app_version\";s:5:\"3.2.1\";s:16:\"app_long_version\";s:5:\"32004\";s:13:\"app_directory\";s:7:\"members\";s:9:\"app_added\";s:10:\"1313444534\";s:12:\"app_position\";s:1:\"2\";s:13:\"app_protected\";s:1:\"1\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:4:\"root\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:0:\"\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:0:\"\";s:6:\"search\";a:6:{s:10:\"can_search\";i:1;s:18:\"can_viewNewContent\";i:1;s:26:\"can_vnc_filter_by_followed\";i:0;s:22:\"can_vnc_unread_content\";i:0;s:15:\"can_userContent\";i:1;s:12:\"contentTypes\";a:2:{i:0;s:7:\"members\";i:1;s:8:\"comments\";}}s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:0;s:8:\"comments\";b:0;s:4:\"like\";b:0;s:6:\"search\";b:1;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:0:{}}s:15:\"hasCustomHeader\";i:0;}s:6:\"forums\";a:21:{s:6:\"app_id\";s:1:\"3\";s:9:\"app_title\";s:6:\"Forums\";s:16:\"app_public_title\";s:6:\"Forums\";s:15:\"app_description\";s:23:\"Manage forums and posts\";s:10:\"app_author\";s:29:\"Invision Power Services, Inc.\";s:11:\"app_version\";s:5:\"3.2.1\";s:16:\"app_long_version\";s:5:\"32004\";s:13:\"app_directory\";s:6:\"forums\";s:9:\"app_added\";s:10:\"1313444536\";s:12:\"app_position\";s:1:\"3\";s:13:\"app_protected\";s:1:\"1\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:4:\"root\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:0:\"\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:0:\"\";s:6:\"search\";a:7:{s:10:\"can_search\";i:1;s:18:\"can_viewNewContent\";i:1;s:26:\"can_vnc_filter_by_followed\";i:1;s:22:\"can_vnc_unread_content\";i:1;s:15:\"can_userContent\";i:1;s:14:\"can_searchTags\";i:1;s:18:\"followContentTypes\";a:2:{i:0;s:6:\"topics\";i:1;s:6:\"forums\";}}s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:1;s:8:\"comments\";b:0;s:4:\"like\";b:1;s:6:\"search\";b:1;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:0:{}}s:15:\"hasCustomHeader\";i:0;}s:4:\"blog\";a:21:{s:6:\"app_id\";s:1:\"4\";s:9:\"app_title\";s:4:\"Blog\";s:16:\"app_public_title\";s:5:\"Blogs\";s:15:\"app_description\";s:0:\"\";s:10:\"app_author\";s:29:\"Invision Power Services, Inc.\";s:11:\"app_version\";s:5:\"2.4.0\";s:16:\"app_long_version\";s:5:\"24002\";s:13:\"app_directory\";s:4:\"blog\";s:9:\"app_added\";s:10:\"1313444538\";s:12:\"app_position\";s:1:\"4\";s:13:\"app_protected\";s:1:\"0\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:3:\"ips\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:0:\"\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:0:\"\";s:6:\"search\";a:7:{s:10:\"can_search\";i:1;s:18:\"can_viewNewContent\";i:1;s:22:\"can_vnc_unread_content\";i:1;s:26:\"can_vnc_filter_by_followed\";i:1;s:15:\"can_userContent\";i:1;s:12:\"contentTypes\";a:2:{i:0;s:7:\"entries\";i:1;s:8:\"comments\";}s:18:\"followContentTypes\";a:2:{i:0;s:7:\"entries\";i:1;s:4:\"blog\";}}s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:1;s:8:\"comments\";b:1;s:4:\"like\";b:1;s:6:\"search\";b:1;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:3:{s:12:\"zero_is_best\";a:4:{i:0;s:17:\"g_blog_attach_max\";i:1;s:23:\"g_blog_attach_per_entry\";i:2;s:21:\"g_blog_preventpublish\";i:3;s:15:\"g_blog_maxblogs\";}s:7:\"exclude\";a:0:{}s:12:\"less_is_more\";a:0:{}}}s:15:\"hasCustomHeader\";i:1;}s:7:\"gallery\";a:21:{s:6:\"app_id\";s:1:\"5\";s:9:\"app_title\";s:7:\"Gallery\";s:16:\"app_public_title\";s:7:\"Gallery\";s:15:\"app_description\";s:0:\"\";s:10:\"app_author\";s:29:\"Invision Power Services, Inc.\";s:11:\"app_version\";s:5:\"4.1.0\";s:16:\"app_long_version\";s:5:\"41002\";s:13:\"app_directory\";s:7:\"gallery\";s:9:\"app_added\";s:10:\"1313444540\";s:12:\"app_position\";s:1:\"5\";s:13:\"app_protected\";s:1:\"0\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:3:\"ips\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:0:\"\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:0:\"\";s:6:\"search\";a:7:{s:10:\"can_search\";i:1;s:18:\"can_viewNewContent\";i:1;s:26:\"can_vnc_filter_by_followed\";i:1;s:22:\"can_vnc_unread_content\";i:1;s:15:\"can_userContent\";i:1;s:12:\"contentTypes\";a:3:{i:0;s:6:\"images\";i:1;s:6:\"albums\";i:2;s:8:\"comments\";}s:18:\"followContentTypes\";a:2:{i:0;s:6:\"images\";i:1;s:6:\"albums\";}}s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:1;s:8:\"comments\";b:1;s:4:\"like\";b:1;s:6:\"search\";b:1;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:1:{s:12:\"neg1_is_best\";a:7:{i:0;s:15:\"g_max_diskspace\";i:1;s:12:\"g_max_upload\";i:2;s:14:\"g_max_transfer\";i:3;s:11:\"g_max_views\";i:4;s:12:\"g_movie_size\";i:5;s:13:\"g_album_limit\";i:6;s:17:\"g_img_album_limit\";}}}s:15:\"hasCustomHeader\";i:0;}s:9:\"dbmanager\";a:20:{s:6:\"app_id\";s:1:\"6\";s:9:\"app_title\";s:24:\"DB Customization Manager\";s:16:\"app_public_title\";s:0:\"\";s:15:\"app_description\";s:82:\"Scans your database for objects not part of a standard install, to help you remove\";s:10:\"app_author\";s:14:\"Michael McCune\";s:11:\"app_version\";s:5:\"1.1.0\";s:16:\"app_long_version\";s:5:\"11000\";s:13:\"app_directory\";s:9:\"dbmanager\";s:9:\"app_added\";s:10:\"1313444932\";s:12:\"app_position\";s:1:\"6\";s:13:\"app_protected\";s:1:\"0\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:5:\"other\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:0:{}s:11:\"app_website\";s:25:\"http://invisionfocus.com/\";s:16:\"app_update_check\";s:64:\"http://invisionfocus.com/resource_updates.php?resource=dbmanager\";s:17:\"app_global_caches\";s:0:\"\";s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:0;s:8:\"comments\";b:0;s:4:\"like\";b:0;s:6:\"search\";b:0;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:0:{}}s:15:\"hasCustomHeader\";i:0;}s:4:\"clan\";a:20:{s:6:\"app_id\";s:1:\"7\";s:9:\"app_title\";s:12:\"Clan Manager\";s:16:\"app_public_title\";s:4:\"Clan\";s:15:\"app_description\";s:32:\"KSI's Clan Management System\";s:10:\"app_author\";s:8:\"Arethusa\";s:11:\"app_version\";s:9:\"0.1 Alpha\";s:16:\"app_long_version\";s:5:\"10000\";s:13:\"app_directory\";s:4:\"clan\";s:9:\"app_added\";s:10:\"1313445759\";s:12:\"app_position\";s:1:\"7\";s:13:\"app_protected\";s:1:\"0\";s:11:\"app_enabled\";s:1:\"1\";s:12:\"app_location\";s:5:\"other\";s:12:\"app_hide_tab\";s:1:\"0\";s:14:\"app_tab_groups\";a:5:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"5\";i:4;s:1:\"6\";}s:11:\"app_website\";s:27:\"http://forums.ksiglobal.com\";s:16:\"app_update_check\";s:0:\"\";s:17:\"app_global_caches\";s:40:\"badwords,banfilters,bbcode,profilefields\";s:10:\"extensions\";a:6:{s:11:\"itemMarking\";b:0;s:8:\"comments\";b:0;s:4:\"like\";b:0;s:6:\"search\";b:0;s:13:\"incomingEmail\";b:0;s:12:\"groupOptions\";a:0:{}}s:15:\"hasCustomHeader\";i:0;}}',1327735710,0) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated),cs_rebuild=VALUES(cs_rebuild)
SHUTDOWN: INSERT INTO ipncache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'systemvars','a:4:{s:10:\"mail_queue\";i:0;s:13:\"task_next_run\";s:10:\"1322784000\";s:14:\"incomingEmails\";b:0;s:15:\"itemMarkerClean\";i:1315006760;}',1327735710,0) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated),cs_rebuild=VALUES(cs_rebuild)
SHUTDOWN: INSERT INTO ipncache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'navigation_tabs','a:7:{i:0;a:4:{s:3:\"app\";s:4:\"core\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:10:\"Help Files\";}i:1;a:4:{s:3:\"app\";s:7:\"members\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:7:\"Members\";}i:2;a:4:{s:3:\"app\";s:6:\"forums\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:6:\"Forums\";}i:3;a:4:{s:3:\"app\";s:4:\"blog\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:5:\"Blogs\";}i:4;a:4:{s:3:\"app\";s:7:\"gallery\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:7:\"Gallery\";}i:5;a:4:{s:3:\"app\";s:9:\"dbmanager\";s:6:\"groups\";a:0:{}s:6:\"module\";s:0:\"\";s:5:\"title\";s:0:\"\";}i:6;a:4:{s:3:\"app\";s:4:\"clan\";s:6:\"groups\";a:5:{i:0;s:1:\"1\";i:1;s:1:\"2\";i:2;s:1:\"3\";i:3;s:1:\"5\";i:4;s:1:\"6\";}s:6:\"module\";s:0:\"\";s:5:\"title\";s:4:\"Clan\";}}',1327735710,0) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated),cs_rebuild=VALUES(cs_rebuild)
SHUTDOWN: INSERT INTO ipncache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'rss_output_cache','a:1:{i:0;s:87:\"Invision Power Board Blogs RSS feed:|:http://members.ksiglobal.com/index.php?/rss/blog/\";}',1327735710,0) ON DUPLICATE KEY UPDATE cs_array=VALUES(cs_array),cs_key=VALUES(cs_key),cs_value=VALUES(cs_value),cs_updated=VALUES(cs_updated),cs_rebuild=VALUES(cs_rebuild)
