SQL Insert Statement Generator
zin
PD
Tundra
PaleN
Pe† Ceme†ery
Profile 6
Name (n)
User number (u)
Topic ID (t)
Post ID (p)
IP Address (ip)
Date (d) - Unix Timestamp
Topic title (tt)
Long hash (lh)
Short hash (sh)
Post copy (pc)
Mini hash (mh)
Generated SQL Code
Unix stamp
Copy Code
Quick SQL Snippets
List 'Edited By' Posts
List Spare Posts
RESTART EDITED BY
Post ID
Copy Code
TOPIC TITLE LIST
Topic FROM
Topic TO
Copy Code
UPDATE TOPIC TITLE
Topic title
Topic ID
Copy Code
UPDATE TOPIC VIEWS
Topic ID
New View Count
Copy Code
UPDATE POST TITLE
Post title
Post ID
Copy Code
DELETE TOPIC ID
Topic ID
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