123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 |
- <?php
- define('INSTALLDIR', dirname(__DIR__));
- define('PUBLICDIR', INSTALLDIR . DIRECTORY_SEPARATOR . 'public');
- $shortoptions = 't:w:';
- $longoptions = array('tagged=', 'not-tagged=');
- $helptext = <<<ENDOFHELP
- allsites.php - list all sites configured for multi-site use
- USAGE: allsites.php [OPTIONS]
- -t --tagged=tagname List only sites with this tag
- -w --not-tagged=tagname List only sites without this tag
- ENDOFHELP;
- require_once INSTALLDIR.'/scripts/commandline.inc';
- function print_all_sites()
- {
- $sn = new Status_network();
- if ($sn->find()) {
- while ($sn->fetch()) {
- print "$sn->nickname\n";
- }
- }
- return;
- }
- function print_tagged_sites($tag)
- {
- $sn = new Status_network();
- $sn->query(
- 'SELECT status_network.nickname '.
- 'FROM status_network INNER JOIN status_network_tag '.
- 'ON status_network.site_id = status_network_tag.site_id '.
- "WHERE status_network_tag.tag = '" . $sn->escape($tag) . "'"
- );
- while ($sn->fetch()) {
- print "$sn->nickname\n";
- }
- return;
- }
- function print_untagged_sites($tag)
- {
- $sn = new Status_network();
- $sn->query(
- 'SELECT status_network.nickname '.
- 'FROM status_network '.
- 'WHERE NOT EXISTS '.
- '(SELECT tag FROM status_network_tag '.
- 'WHERE site_id = status_network.site_id '.
- "AND tag = '" . $sn->escape($tag) . "')"
- );
- while ($sn->fetch()) {
- print "$sn->nickname\n";
- }
- return;
- }
- if (have_option('t', 'tagged')) {
- $tag = get_option_value('t', 'tagged');
- print_tagged_sites($tag);
- } elseif (have_option('w', 'not-tagged')) {
- $tag = get_option_value('w', 'not-tagged');
- print_untagged_sites($tag);
- } else {
- print_all_sites();
- }
|