SQL Insert Statement Generator
zin
PD
Tundra
Profile 4
Profile 5
Profile 6
Name (n)
User number (u)
Topic ID (t)
Post ID (p)
Date (d) - Unix Timestamp
IP Address (ip) - Optional
Generated SQL Code
Unix stamp
Copy Code
Quick SQL Snippets
RESTART EDITED BY
UPDATE phpbb_posts SET post_edit_time = 0, post_edit_reason = '', post_edit_user = 0, post_edit_count = 0 WHERE post_id = 2925;
Copy Code
TOPIC TITLE LIST
SELECT t.topic_id, t.topic_title FROM phpbb_topics t LEFT JOIN phpbb_forums f ON t.forum_id = f.forum_id WHERE t.topic_id BETWEEN 1023 AND 1045 ORDER BY t.topic_id ASC;
Copy Code
LIST EDITED BY POSTS
SELECT p.post_id, p.topic_id, p.forum_id, u.username AS edited_by, FROM_UNIXTIME(p.post_edit_time) AS edit_date, p.post_edit_count, CONCAT('https://witch-house.com/forum/viewtopic.php?p=', p.post_id, '#p', p.post_id) AS post_link FROM phpbb_posts p LEFT JOIN phpbb_users u ON p.post_edit_user = u.user_id WHERE p.post_edit_time > 0 AND p.post_edit_user > 0 ORDER BY p.post_edit_time DESC;
Copy Code
LIST SPARE POSTS
SELECT n.number AS missing_post_id FROM ( -- Calculate the number by summing the place values SELECT (tt.tt * 10000) + (t.t * 1000) + (h.h * 100) + (te.t * 10) + (u.u * 1) + 1 AS number FROM (SELECT 0 AS u UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS u -- Ones place CROSS JOIN (SELECT 0 AS t UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS te -- Tens place CROSS JOIN (SELECT 0 AS h UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS h -- Hundreds place CROSS JOIN (SELECT 0 AS t UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS t -- Thousands place CROSS JOIN (SELECT 0 AS tt UNION ALL SELECT 1 UNION ALL SELECT 2) AS tt -- Ten Thousands place ) n LEFT JOIN phpbb_posts p ON p.post_id = n.number WHERE n.number >= (SELECT MIN(post_id) FROM phpbb_posts) AND n.number <= (SELECT MAX(post_id) FROM phpbb_posts) AND p.post_id IS NULL ORDER BY n.number;
Copy Code