X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=scripts%2Fallsites.php;h=211728c497fa9381bf53671738d1f2b8172768c7;hb=15ae1cddfebe4035947ede4a53a6d24e8505ddab;hp=cf1419e550f359915973cad826c8be8fa59f8ee6;hpb=9d87313eaebe8240393ac300a435f3b1332c8849;p=quix0rs-gnu-social.git
diff --git a/scripts/allsites.php b/scripts/allsites.php
index cf1419e550..211728c497 100755
--- a/scripts/allsites.php
+++ b/scripts/allsites.php
@@ -18,23 +18,76 @@
* along with this program. If not, see .
*/
-# Abort if called from a web server
+// Abort if called from a web server
define('INSTALLDIR', realpath(dirname(__FILE__) . '/..'));
+$shortoptions = 't:w:';
+$longoptions = array('tagged=', 'not-tagged=');
+
$helptext = <<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 join status_network_tag '.
+ 'on status_network.site_id = status_network_tag.site_id '.
+ 'where status_network_tag.tag = "' . $tag . '"');
-if ($sn->find()) {
while ($sn->fetch()) {
print "$sn->nickname\n";
}
-}
\ No newline at end of file
+
+ 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 = "'.$tag.'")');
+
+ while ($sn->fetch()) {
+ print "$sn->nickname\n";
+ }
+
+ return;
+}
+
+if (have_option('t', 'tagged')) {
+ $tag = get_option_value('t', 'tagged');
+ print_tagged_sites($tag);
+} else if (have_option('w', 'not-tagged')) {
+ $tag = get_option_value('w', 'not-tagged');
+ print_untagged_sites($tag);
+} else {
+ print_all_sites();
+}