Code: Select all
SELECT *
FROM phpbb_config
-- --
SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments
FROM phpbb_topics t, phpbb_forums f
WHERE t.topic_id = 30
AND f.forum_id = t.forum_id
-- --
SELECT u.*, s.*
FROM phpbb_sessions s, phpbb_users u
WHERE s.session_id = '63326857c88170869c27a0d59906133f'
AND u.user_id = s.session_user_id
-- --
UPDATE phpbb_sessions
SET session_time = 1082948574, session_page = 3
WHERE session_id = '63326857c88170869c27a0d59906133f'
-- --
DELETE FROM phpbb_sessions
WHERE session_time < 1082944974
AND session_id <> '63326857c88170869c27a0d59906133f'
-- --
SELECT *
FROM phpbb_themes
WHERE themes_id = 1
-- --
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid
FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt
WHERE p.topic_id = 30
AND pt.post_id = p.post_id
AND u.user_id = p.poster_id
ORDER BY p.post_time ASC
LIMIT 0, 15
-- --
SELECT *
FROM phpbb_ranks
ORDER BY rank_special, rank_min
-- --
SELECT word, replacement
FROM phpbb_words
-- --
SELECT c.cat_id, c.cat_title, c.cat_order
FROM phpbb_categories c, phpbb_forums f
WHERE f.cat_id = c.cat_id
GROUP BY c.cat_id, c.cat_title, c.cat_order
ORDER BY c.cat_order
-- --
SELECT *
FROM phpbb_forums
ORDER BY cat_id, forum_order
-- --
UPDATE phpbb_topics
SET topic_views = topic_views + 1
WHERE topic_id = 30
-- --
SELECT * FROM phpbb_smilies
-- --
