Thread

SQL QUERIES
1
SELECT es.* FROM exp_sites AS es WHERE es.site_id = '1'
2
SELECT DISTINCT ee.* FROM exp_extensions ee WHERE enabled = 'y' ORDER BY hook, priority ASC, class
3
SELECT member_id, admin_sess, last_activity FROM exp_sessions WHERE session_id = '41f17c971fb10c56fc38d1464174d643e3e9685c' AND ip_address = '76.105.145.124' AND user_agent = 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_1; '
4
SELECT m.weblog_id, m.tmpl_group_id, m.username, m.screen_name, m.member_id, m.email, m.url, m.location, m.join_date, m.last_visit, m.last_activity, m.total_entries, m.total_comments, m.total_forum_posts, m.total_forum_topics, m.last_forum_post_date, m.language, m.timezone, m.daylight_savings, m.time_format, m.profile_theme, m.forum_theme, m.private_messages, m.accept_messages, m.last_view_bulletins, m.last_bulletin_date, m.display_signatures, m.display_avatars, m.last_email_date, m.notify_by_default, m.ignore_list, m.upload_id, m.cp_theme, m.quick_links, m.quick_tabs, m.template_size, g.* FROM exp_members AS m, exp_member_groups AS g WHERE g.site_id = '1' AND unique_id = 'd42b928ad2b401175e1e350aa7d22100538cd4a2' AND password = '31e89f49da6384af89b72287e8965a0aeeb77bad' AND m.group_id = g.group_id
5
SELECT weblog_id, blog_title FROM exp_weblogs WHERE site_id = '1' AND is_user_blog = 'n' ORDER BY blog_title
6
SELECT module_id FROM exp_module_member_groups WHERE group_id = '1'
7
SELECT template_group_id FROM exp_template_member_groups WHERE group_id = '1'
8
SELECT site_id, site_label FROM exp_sites ORDER BY site_label
9
UPDATE `exp_sessions` SET `session_id` = '41f17c971fb10c56fc38d1464174d643e3e9685c', `member_id` = '142', `admin_sess` = '1', `ip_address` = '76.105.145.124', `user_agent` = 'Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10_6_1; ', `last_activity` = '1253758527' WHERE session_id ='41f17c971fb10c56fc38d1464174d643e3e9685c'
10
SELECT group_id, template_name, save_template_file, template_data, template_notes, template_type, edit_date, last_author_id FROM exp_templates WHERE template_id = '294'
11
SELECT group_name FROM exp_template_groups WHERE group_id = '5'
12
SELECT screen_name FROM exp_members WHERE member_id = 142
13
SELECT tracker_id, item_date, screen_name FROM exp_revision_tracker LEFT JOIN exp_members ON exp_members.member_id = exp_revision_tracker.item_author_id WHERE item_table = 'exp_templates' AND item_field = 'template_data' AND item_id = '294' ORDER BY tracker_id DESC
14
INSERT INTO exp_security_hashes (date, ip_address, hash) VALUES (UNIX_TIMESTAMP(), '76.105.145.124', 'aa86e1b605fab8ba44f24e61abc17be4f117a345'),(UNIX_TIMESTAMP(), '76.105.145.124', 'c5853a4c557824313e37c674b1ada4824456fbbb'),(UNIX_TIMESTAMP(), '76.105.145.124', '864605cde29ea03347578e4afaa0deec25687c8c')