Запросы
SET NAMES ‘utf8’
SET CHARACTER SET ‘utf8’
SET character_set_connection = utf8
SET collation_connection = utf8_general_ci
SELECT * FROM ibf_cache_store WHERE cs_key IN ( ‘systemvars’,’login_methods’,’vnums’,’app_cache’,’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’,’attachtypes’,’multimod’,’moderators’,’announcements’,’report_cache’,’chatting’,’birthdays’,’calendar’,’calendars’,’ranks’,’reputation_levels’ )
SELECT * FROM ibf_sessions WHERE id=’deleted’
DELETE FROM ibf_sessions WHERE id=’deleted’ OR id=’alexa=5417335129_session’ OR running_time < 1521467581
SELECT f.*,p.* FROM ibf_forums f LEFT JOIN ibf_permission_index p ON ( p.perm_type=’forum’ AND p.app=’forums’ AND p.perm_type_id=f.id )
SELECT * FROM ibf_skin_cache WHERE cache_set_id=1 AND cache_type IN (‘css’, ‘replacements’)
SELECT * FROM ibf_skin_cache WHERE cache_set_id=1 AND cache_value_1=’skin_forums_global’
SHUTDOWN: INSERT INTO ibf_sessions (id,member_name,member_id,member_group,login_type,running_time,ip_address,browser,location,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(‘alexa=5417335129_session’,’Alexa’,0,15,0,1521473581,’54.173.35.129′,’ia_archiver’,»,0,’forums’,’forums’,’boards’,»,0,»,0,»,0,’alexa’,0,’search’,0)