-
Notifications
You must be signed in to change notification settings - Fork 0
/
stats.php
executable file
·82 lines (75 loc) · 4.56 KB
/
stats.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?php
/*
* stats.php - WikiWW statistics page
* PHP by: Jacob I. Torrey
* Design by: Jacob I. Torrey
*/
include('lib/misc.inc.php');
include('lib/classes.class.php');
include('lib/cache.lib.php');
$c = new Cache();
$c->startCache(5);
print statichtmlheader();
?>
</head><body>
<div id="title">
<h1>Wiki Wide Web Statistics</h1>
</div>
<div id="central">
<?php print menu(); ?>
<p class="indent">Below are some statistics generated about Wiki Wide Web:</p>
<ul>
<li>Number of users:
<?php
$db = new DB();
$db->query("SELECT count(uid) FROM user;");
$num = $db->fetchRow();
$num = $num[0];
$db->close();
print $num;
?>
</li>
<li>Number of diffs:
<?php
$db = new DB();
$db->query("SELECT count(did) FROM diff;");
$num = $db->fetchRow();
$num = $num[0];
$db->close();
print $num;
?>
</li>
<li>Our newest user:
<?php
$db = new DB();
$db->query("SELECT username FROM user ORDER BY `uid` DESC LIMIT 1;");
$num = $db->fetchRow();
$num = ucfirst($num[0]);
$db->close();
print $num;
?>
</li>
<li>Our most active user:
<?php
$db = new DB();
$db->query("SELECT user.username, COUNT(diff.did) FROM user, diff WHERE diff.uid = user.uid GROUP BY diff.uid ORDER BY count(diff.did) DESC LIMIT 1;");
$num = $db->fetchRow();
$username = ucfirst($num[0]);
$num = $num[1];
$db->close();
print "$username with $num edits";
?>
</li>
</ul>
</div>
<div id="footer"><form class="center" action="https://www.paypal.com/cgi-bin/webscr" method="post"><div>
<input type="hidden" name="cmd" value="_s-xclick" />
<input type="image" src="https://www.paypal.com/en_US/i/btn/x-click-but21.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!" />
<img alt="" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1" />
<input type="hidden" name="encrypted" value="-----BEGIN PKCS7-----MIIHRwYJKoZIhvcNAQcEoIIHODCCBzQCAQExggEwMIIBLAIBADCBlDCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb20CAQAwDQYJKoZIhvcNAQEBBQAEgYCx28hudRjiIWdRJkI79sW59LWXF3Dy8MAVI6oVilTFIXTrskvk9k/vLSVy3upq+8OHaDCSSDCMo2hNVHOQPTpkBUM4RWIZZluC+63fUi9qg63wv8svp2540/wnc3m7Sy5IqCsZ01NpCHyy/cXS6XxB1AyabWO3/LpkHEDZktDrWTELMAkGBSsOAwIaBQAwgcQGCSqGSIb3DQEHATAUBggqhkiG9w0DBwQIrQebTpazTRGAgaAY4LfYy908zDe1Xffef5tjLQwN9w05hMthFurVqT0FNMkqXcIOOOw1oBkz9kKaGrqKwMRp4UQSxh/Ud8W2Bh9Ned+fpwDKE9lN/GEgomgeThcn6P8oVHjjdmRiAvYBvq+FaBn6LhJp3D35u7o5E7emd7NieByMWu7iN5b+G6OsfLORaxk82k0A7QaRjXmgjAm0++CHWPwwBrDgGaIDsyN6oIIDhzCCA4MwggLsoAMCAQICAQAwDQYJKoZIhvcNAQEFBQAwgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMB4XDTA0MDIxMzEwMTMxNVoXDTM1MDIxMzEwMTMxNVowgY4xCzAJBgNVBAYTAlVTMQswCQYDVQQIEwJDQTEWMBQGA1UEBxMNTW91bnRhaW4gVmlldzEUMBIGA1UEChMLUGF5UGFsIEluYy4xEzARBgNVBAsUCmxpdmVfY2VydHMxETAPBgNVBAMUCGxpdmVfYXBpMRwwGgYJKoZIhvcNAQkBFg1yZUBwYXlwYWwuY29tMIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDBR07d/ETMS1ycjtkpkvjXZe9k+6CieLuLsPumsJ7QC1odNz3sJiCbs2wC0nLE0uLGaEtXynIgRqIddYCHx88pb5HTXv4SZeuv0Rqq4+axW9PLAAATU8w04qqjaSXgbGLP3NmohqM6bV9kZZwZLR/klDaQGo1u9uDb9lr4Yn+rBQIDAQABo4HuMIHrMB0GA1UdDgQWBBSWn3y7xm8XvVk/UtcKG+wQ1mSUazCBuwYDVR0jBIGzMIGwgBSWn3y7xm8XvVk/UtcKG+wQ1mSUa6GBlKSBkTCBjjELMAkGA1UEBhMCVVMxCzAJBgNVBAgTAkNBMRYwFAYDVQQHEw1Nb3VudGFpbiBWaWV3MRQwEgYDVQQKEwtQYXlQYWwgSW5jLjETMBEGA1UECxQKbGl2ZV9jZXJ0czERMA8GA1UEAxQIbGl2ZV9hcGkxHDAaBgkqhkiG9w0BCQEWDXJlQHBheXBhbC5jb22CAQAwDAYDVR0TBAUwAwEB/zANBgkqhkiG9w0BAQUFAAOBgQCBXzpWmoBa5e9fo6ujionW1hUhPkOBakTr3YCDjbYfvJEiv/2P+IobhOGJr85+XHhN0v4gUkEDI8r2/rNk1m0GA8HKddvTjyGw/XqXa+LSTlDYkqI8OwR8GEYj4efEtcRpRYBxV8KxAW93YDWzFGvruKnnLbDAF6VR5w/cCMn5hzGCAZowggGWAgEBMIGUMIGOMQswCQYDVQQGEwJVUzELMAkGA1UECBMCQ0ExFjAUBgNVBAcTDU1vdW50YWluIFZpZXcxFDASBgNVBAoTC1BheVBhbCBJbmMuMRMwEQYDVQQLFApsaXZlX2NlcnRzMREwDwYDVQQDFAhsaXZlX2FwaTEcMBoGCSqGSIb3DQEJARYNcmVAcGF5cGFsLmNvbQIBADAJBgUrDgMCGgUAoF0wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDcwNTI2MTUyNTMyWjAjBgkqhkiG9w0BCQQxFgQUiiBVxMeS5uvgHpLx+spDlsTWylAwDQYJKoZIhvcNAQEBBQAEgYCC2101lPv6OrVG5CCkK7YF8MV6v+emWRe3HJ+Jw5pFJUuSROV2OrWJKpg2d+fqg7X3XS9hVwAi/naYGQV9IaqBDuxK+0eSyDpgtFuLn0lqMT/PC10N7tr0Y0iz2fOEVHNwYiGmYhCMXyXq5AzGsyiCh24tmVPd+ICxz3VAjcHMZw==-----END PKCS7-----
" /></div>
</form>
<p class="center">© 2007 JIT Web Solutions</p></div>
</body>
</html>
<?php $c->endCache(); ?>