From b5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a Mon Sep 17 00:00:00 2001
From: Starla Insigna <hatkirby@fourisland.com>
Date: Thu, 13 Aug 2009 17:46:09 -0400
Subject: Rewrote Admin panel

The following database changes must be made:

* A TEXT column called "text" must be added to the end of "polloftheweek"
* The transferPollRss.php script must be run
* The "pollrss" table must be dropped

Closes #113
---
 admin/welcome.php | 71 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 71 insertions(+)
 create mode 100644 admin/welcome.php

(limited to 'admin/welcome.php')

diff --git a/admin/welcome.php b/admin/welcome.php
new file mode 100644
index 0000000..76b42b1
--- /dev/null
+++ b/admin/welcome.php
@@ -0,0 +1,71 @@
+<?php
+/*
+       444444444  
+      4::::::::4  
+     4:::::::::4  
+    4::::44::::4  
+   4::::4 4::::4   Four Island
+  4::::4  4::::4  
+ 4::::4   4::::4   Written and maintained by Starla Insigna
+4::::444444::::444
+4::::::::::::::::4  admin/welcome.php
+4444444444:::::444
+          4::::4   Please do not use, reproduce or steal the
+          4::::4   contents of this file without explicit
+          4::::4   permission from Hatkirby.
+        44::::::44
+        4::::::::4
+        4444444444
+*/
+
+if (!defined('S_INCLUDE_FILE')) {define('S_INCLUDE_FILE',1);}
+
+require('headerproc.php');
+
+$category = 'home';
+
+$template = new FITemplate('admin/welcome');
+
+$cntposts = "SELECT COUNT(*) FROM updates";
+$cntposts2 = mysql_query($cntposts);
+$cntposts3 = mysql_fetch_array($cntposts2);
+$template->add('POSTS', $cntposts3['COUNT(*)']);
+
+$cntpending = "SELECT COUNT(*) FROM pending";
+$cntpending2 = mysql_query($cntpending);
+$cntpending3 = mysql_fetch_array($cntpending2);
+$template->add('PENDING', $cntpending3['COUNT(*)']);
+
+$cntdrafts = "SELECT COUNT(*) FROM drafts";
+$cntdrafts2 = mysql_query($cntdrafts);
+$cntdrafts3 = mysql_fetch_array($cntdrafts2);
+$template->add('DRAFTS', $cntdrafts3['COUNT(*)']);
+
+$cntcomments = "SELECT COUNT(*) FROM moderation";
+$cntcomments2 = mysql_query($cntcomments);
+$cntcomments3 = mysql_fetch_array($cntcomments2);
+$template->add('COMMENTS', $cntcomments3['COUNT(*)']);
+
+$cntpolls = "SELECT COUNT(*) FROM polloftheweek";
+$cntpolls2 = mysql_query($cntpolls);
+$cntpolls3 = mysql_fetch_array($cntpolls2);
+$template->add('POLLS', $cntpolls3['COUNT(*)']);
+
+$cntquotes = "SELECT COUNT(*) FROM rash_quotes";
+$cntquotes2 = mysql_query($cntquotes);
+$cntquotes3 = mysql_fetch_array($cntquotes2);
+$template->add('QUOTES', $cntquotes3['COUNT(*)']);
+
+$cntflagged = "SELECT COUNT(*) FROM rash_quotes WHERE flag = 1";
+$cntflagged2 = mysql_query($cntflagged);
+$cntflagged3 = mysql_fetch_array($cntflagged2);
+$template->add('FLAGGED', $cntflagged3['COUNT(*)']);
+
+$cntmodcom = "SELECT COUNT(*) FROM rash_queue";
+$cntmodcom2 = mysql_query($cntmodcom);
+$cntmodcom3 = mysql_fetch_array($cntmodcom2);
+$template->add('MODCOM', $cntmodcom3['COUNT(*)']);
+
+$template->display();
+
+?>
-- 
cgit 1.4.1