summary refs log tree commit diff stats
path: root/admin/welcome.php
diff options
context:
space:
mode:
authorStarla Insigna <hatkirby@fourisland.com>2009-08-13 17:46:09 -0400
committerStarla Insigna <hatkirby@fourisland.com>2009-08-13 17:46:09 -0400
commitb5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a (patch)
tree0449277e94a42aa155995a90fd8a89cb3309e7ab /admin/welcome.php
parent6a1d5b60e6ec541a36727b84b71168f62221f7d7 (diff)
downloadfourisland-b5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a.tar.gz
fourisland-b5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a.tar.bz2
fourisland-b5736e3ad3830fa732dcbd1a518ec3dd6ea7b98a.zip
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
Diffstat (limited to 'admin/welcome.php')
-rw-r--r--admin/welcome.php71
1 files changed, 71 insertions, 0 deletions
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 @@
1<?php
2/*
3 444444444
4 4::::::::4
5 4:::::::::4
6 4::::44::::4
7 4::::4 4::::4 Four Island
8 4::::4 4::::4
9 4::::4 4::::4 Written and maintained by Starla Insigna
104::::444444::::444
114::::::::::::::::4 admin/welcome.php
124444444444:::::444
13 4::::4 Please do not use, reproduce or steal the
14 4::::4 contents of this file without explicit
15 4::::4 permission from Hatkirby.
16 44::::::44
17 4::::::::4
18 4444444444
19*/
20
21if (!defined('S_INCLUDE_FILE')) {define('S_INCLUDE_FILE',1);}
22
23require('headerproc.php');
24
25$category = 'home';
26
27$template = new FITemplate('admin/welcome');
28
29$cntposts = "SELECT COUNT(*) FROM updates";
30$cntposts2 = mysql_query($cntposts);
31$cntposts3 = mysql_fetch_array($cntposts2);
32$template->add('POSTS', $cntposts3['COUNT(*)']);
33
34$cntpending = "SELECT COUNT(*) FROM pending";
35$cntpending2 = mysql_query($cntpending);
36$cntpending3 = mysql_fetch_array($cntpending2);
37$template->add('PENDING', $cntpending3['COUNT(*)']);
38
39$cntdrafts = "SELECT COUNT(*) FROM drafts";
40$cntdrafts2 = mysql_query($cntdrafts);
41$cntdrafts3 = mysql_fetch_array($cntdrafts2);
42$template->add('DRAFTS', $cntdrafts3['COUNT(*)']);
43
44$cntcomments = "SELECT COUNT(*) FROM moderation";
45$cntcomments2 = mysql_query($cntcomments);
46$cntcomments3 = mysql_fetch_array($cntcomments2);
47$template->add('COMMENTS', $cntcomments3['COUNT(*)']);
48
49$cntpolls = "SELECT COUNT(*) FROM polloftheweek";
50$cntpolls2 = mysql_query($cntpolls);
51$cntpolls3 = mysql_fetch_array($cntpolls2);
52$template->add('POLLS', $cntpolls3['COUNT(*)']);
53
54$cntquotes = "SELECT COUNT(*) FROM rash_quotes";
55$cntquotes2 = mysql_query($cntquotes);
56$cntquotes3 = mysql_fetch_array($cntquotes2);
57$template->add('QUOTES', $cntquotes3['COUNT(*)']);
58
59$cntflagged = "SELECT COUNT(*) FROM rash_quotes WHERE flag = 1";
60$cntflagged2 = mysql_query($cntflagged);
61$cntflagged3 = mysql_fetch_array($cntflagged2);
62$template->add('FLAGGED', $cntflagged3['COUNT(*)']);
63
64$cntmodcom = "SELECT COUNT(*) FROM rash_queue";
65$cntmodcom2 = mysql_query($cntmodcom);
66$cntmodcom3 = mysql_fetch_array($cntmodcom2);
67$template->add('MODCOM', $cntmodcom3['COUNT(*)']);
68
69$template->display();
70
71?>