SQL Insert Statement Generator

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

Quick SQL Snippets

RESTART EDITED BY

Post ID

TOPIC TITLE LIST

Topic FROM

Topic TO

UPDATE TOPIC TITLE

Topic title

Topic ID

UPDATE POST TITLE

Post title

Post ID

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;

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;