|
4
|
1 #!/usr/bin/php |
|
|
2 <?php |
|
8
|
3 /* Copyright 2010 Ivo Smits <Ivo@UCIS.nl>. All rights reserved. |
|
|
4 Redistribution and use in source and binary forms, with or without modification, are |
|
|
5 permitted provided that the following conditions are met: |
|
|
6 |
|
|
7 1. Redistributions of source code must retain the above copyright notice, this list of |
|
|
8 conditions and the following disclaimer. |
|
|
9 |
|
|
10 2. Redistributions in binary form must reproduce the above copyright notice, this list |
|
|
11 of conditions and the following disclaimer in the documentation and/or other materials |
|
|
12 provided with the distribution. |
|
|
13 |
|
|
14 THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESS OR IMPLIED |
|
|
15 WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND |
|
|
16 FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHORS OR |
|
|
17 CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR |
|
|
18 CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR |
|
|
19 SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON |
|
|
20 ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING |
|
|
21 NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF |
|
|
22 ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. |
|
|
23 |
|
|
24 The views and conclusions contained in the software and documentation are those of the |
|
|
25 authors and should not be interpreted as representing official policies, either expressed |
|
|
26 or implied, of Ivo Smits.*/ |
|
|
27 |
|
4
|
28 chdir(__DIR__); |
|
|
29 require_once './common.php'; |
|
|
30 |
|
|
31 docleanup('Orphaned peergroups', 'DELETE FROM `peergroups` WHERE `group` NOT IN (SELECT `id` FROM `groups`)'); |
|
|
32 docleanup('Orphaned peergroups', 'DELETE FROM `peergroups` WHERE `peer` NOT IN (SELECT `id` FROM `peers`)'); |
|
|
33 docleanup('Orphaned groupmessages', 'DELETE FROM `groupmessages` WHERE `group` NOT IN (SELECT `id` FROM `groups`)'); |
|
|
34 docleanup('Orphaned messages', 'DELETE FROM `messages` WHERE `id` NOT IN (SELECT `message` FROM `groupmessages`)'); |
|
|
35 docleanup('Orphaned groupmessages', 'DELETE FROM `groupmessages` WHERE `message` NOT IN (SELECT `id` FROM `messages`)'); |
|
|
36 docleanup('Optimize', 'OPTIMIZE TABLE `groupmessages`, `groups`, `messages`, `peergroups`, `peer`'); |
|
|
37 |
|
|
38 function docleanup($comment, $query) { |
|
|
39 global $db; |
|
|
40 $count = $db->update($query); |
|
|
41 print($comment.': '.$count."\n"); |
|
|
42 } |
