2 require_once("boot.php");
10 @include(".htconfig.php");
11 require_once("include/dba.php");
12 $db = new dba($db_host, $db_user, $db_pass, $db_data);
13 unset($db_host, $db_user, $db_pass, $db_data);
16 load_config('config');
17 load_config('system');
22 function remove_orphans() {
24 logger("Deleting orphaned data from thread table");
25 q("DELETE FROM `thread` WHERE NOT EXISTS (SELECT `id` FROM `item` WHERE `item`.`parent` = `thread`.`iid`)");
27 logger("Deleting orphaned data from notify table");
28 q("DELETE FROM `notify` WHERE NOT EXISTS (SELECT `id` FROM `item` WHERE `item`.`id` = `notify`.`iid`)");
30 logger("Deleting orphaned data from sign table");
31 q("DELETE FROM `sign` WHERE NOT EXISTS (SELECT `id` FROM `item` WHERE `item`.`id` = `sign`.`iid`)");
33 logger("Deleting orphaned data from term table");
34 q("DELETE FROM `term` WHERE NOT EXISTS (SELECT `id` FROM `item` WHERE `item`.`id` = `term`.`oid`)");
36 logger("Done deleting orphaned data from tables");