From 5e95090defff64bc8cd7a318a73aa930948fb66d Mon Sep 17 00:00:00 2001
From: Peter Palfrader <peter@palfrader.org>
Date: Mon, 15 Nov 2004 09:20:11 +0000
Subject: Initial import

---
 web/remsaint.php | 76 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 76 insertions(+)
 create mode 100644 web/remsaint.php

(limited to 'web/remsaint.php')

diff --git a/web/remsaint.php b/web/remsaint.php
new file mode 100644
index 0000000..91f3468
--- /dev/null
+++ b/web/remsaint.php
@@ -0,0 +1,76 @@
+<?
+/* RemSaint
+ *
+ * (c) 2002 Peter Palfrader <pp@3node.com>
+ */
+
+/**
+ * RemSaint
+ *
+ * @author	Peter Palfrader/3node
+ * @version	$Id$
+ */
+
+require_once("../include/Namespace.inc");
+require_once("../include/Tools.inc");
+require_once("../include/Template.inc");
+
+$namespace = new Namespace(
+	array( have_database => 1, 
+	       have_session => 1,
+	       have_user => 1 )
+) or
+	die("Nobody loves me. I don't even have space for a name.");
+
+$rules = Array();
+$rules['list']['manage'] = array(type => 'integer', optional => 1);
+$rules['list']['sort'] = array(type => 'string', optional => 1);
+$arguments = param_check($GLOBALS, $rules, array(params_required=>false));
+
+$user = false;
+$userref = false;
+$manage = $arguments['manage'] ? 1 : 0;
+
+if (! $namespace->user->check_login())
+	$manage = 0;
+else {
+	$user = $namespace->session->data['user']['username'];
+	$userref = $namespace->session->data['user']['ref'];
+}
+
+$orderby='nick';
+$sort='nick';
+if ($arguments['sort'] == 'type1') {
+	$orderby='-reliability_type1';
+	$sort='reliability_type1';
+};
+if ($arguments['sort'] == 'type2') {
+	$orderby='-reliability_type2';
+	$sort='reliability_type2';
+};
+if ($arguments['sort'] == 'status') {
+	$orderby='in_critical, in_warning';
+	$sort = 'status';
+};
+
+
+$data = array();
+# YYYY-MM-DD HH24:MI TZ
+if ($manage)
+	$data['remailers'] = $namespace->database->query_all("SELECT subscription.ref, remailer.ref, remailer.in_warning, remailer.in_critical, remailer.nick, remailer.reliability_type1, remailer.reliability_type2, to_char(remailer.last_update, 'YYYY-MM-DD') AS last_update, listed1, listed2, subscription.notify_warning, subscription.notify_critical, subscription.notify_recovery, true AS t, false AS f FROM remailer LEFT OUTER JOIN (SELECT * FROM subscription WHERE subscription.account_ref=?) as subscription ON remailer.ref=subscription.remailer_ref ORDER BY $orderby", array($userref));
+else
+	$data['remailers'] = $namespace->database->query_all("SELECT ref, in_warning, in_critical, nick, reliability_type1, reliability_type2, to_char(last_update, 'YYYY-MM-DD') AS last_update, listed1, listed2, true AS t, false AS f FROM remailer ORDER BY $orderby");
+$data['manage'] = $manage;
+$data['sort'] = $sort;
+$data['user'] = $user;
+$data['this'] = $PHP_SELF;
+
+$template = new Template('remsaint-status.html', $namespace->config->template_path);
+$template->parse($data);
+print $template->output();
+
+$namespace->stop();
+
+# vim:set ts=4:
+# vim:set shiftwidth=4:
+?>
-- 
cgit v1.2.3