think tank forum

lucas@www:~$ cat sql.php
<?php

$id_start = 1;
$id_end = 2690;

echo <<<ABC
CREATE TABLE `enum` (
    `id` INT NOT NULL ,
    PRIMARY KEY ( `id` )
);



INSERT INTO `enum` ( `id` ) VALUES
ABC;

for ($i=$id_start; $i<=$id_end; $i++) {
    echo ($i===$id_start) ? "($i)" : ", ($i)";
};

echo <<<ABC
;


SELECT `enum`.`id`
FROM `enum`
LEFT JOIN `ttf_thread`
  ON `ttf_thread`.`thread_id`=`enum`.`id`
WHERE `ttf_thread`.`thread_id` IS NULL;

DROP TABLE `enum`;

ABC;

lucas@www:~$ php sql.php > go.sql
lucas@www:~$ mysql -p thinktankforums-com < go.sql > results.txt
Enter password:
lucas@www:~$ cat results.txt
id
20
31
156
399
622
623
624
1965
lucas@www:~$

lucas@www:~$ cat link.php
<?php

$str = trim(file_get_contents('results.txt'));

$arr = explode(PHP_EOL, $str);

foreach ($arr as $id) {
    echo ($id === 'id') ? '' : "https://www.thinktankforums.com/thread.php?thread_id=$id".PHP_EOL;
};

?>
lucas@www:~$ php link.php
 https://www.thinktankforums.com/thread.php?thread_id=20 
 https://www.thinktankforums.com/thread.php?thread_id=31 
 https://www.thinktankforums.com/thread.php?thread_id=156 
 https://www.thinktankforums.com/thread.php?thread_id=399 
 https://www.thinktankforums.com/thread.php?thread_id=622 
 https://www.thinktankforums.com/thread.php?thread_id=623 
 https://www.thinktankforums.com/thread.php?thread_id=624 
 https://www.thinktankforums.com/thread.php?thread_id=1965 
lucas@www:~$