patchdemo/editcounts.php at ca2ffd065c9ebcc05a29ca7c43009480f1619dc3 · MatmaRex/patchdemo · GitHub

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
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
<?php
require_once "includes.php";

include "header.php";

if ( !can_admin() ) {
	echo 'Access denied.';
	if ( $useOAuth && !$user ) {
		echo oauth_signin_prompt();
	}
	return;
}

$short_fields = [
	'ss_total_edits' => [
		'label' => 'Edits',
		'link' => 'Special:RecentChanges?days=90',
	],
	'last_edit' => [
		'label' => 'Last edit',
		'link' => 'Special:RecentChanges?days=90',
		'formatter' => static function ( $time ) {
			return ( new DateTime( $time ) )->format( 'Y-m-d H:i:s' );
		}
	],
	'ss_good_articles' => [
		'label' => 'Articles',
		'link' => 'Special:AllPages',
	],
	'ss_total_pages' => [
		'label' => 'Pages',
		// Doesn't appear to be a list of all pages anywhere
		'link' => 'Special:AllPages',
	],
	'ss_users' => [
		'label' => 'Users',
		'link' => 'Special:ListUsers',
	],
	'ss_active_users' => [
		'label' => 'Active users',
		'link' => 'Special:ActiveUsers',
	],
	'ss_images' => [
		'label' => 'Images',
		// Or Special:MediaStatistics?
		'link' => 'Special:ListFiles',
	],
];

$results = $mysqli->query( 'SELECT wiki FROM wikis WHERE !deleted ORDER BY created DESC' );
if ( !$results ) {
	die( $mysqli->error );
}

$update = isset( $_POST['update'] );

echo '<div class="consoleLog">';

$wikis = [];
while ( $data = $results->fetch_assoc() ) {
	$wiki = $data['wiki'];
	$wikis[$wiki] = $data;

	if ( $update ) {
		$cmd = make_shell_command(
			[
				'PATCHDEMO' => __DIR__,
				'NAME' => $wiki,
			],
			'sh -c \'php $PATCHDEMO/wikis/$NAME/w/maintenance/initSiteStats.php --update --active\''
		);
		shell_echo( $cmd );
	}

	$stats = $mysqli->query( "
			SELECT *,
			( SELECT MAX( rev_timestamp ) FROM patchdemo_$wiki.revision ) AS last_edit
			FROM patchdemo_$wiki.site_stats LIMIT 1" );
	if ( $stats ) {
		foreach ( $stats as $row ) {
			$wikis[$wiki] += $row;
		}
	}
}

echo '</div>';

uksort( $wikis, static function ( $a, $b ) use ( $wikis ) {
	return ( $wikis[ $b ][ 'ss_total_edits' ] ?? -1 ) <=> ( $wikis[ $a ][ 'ss_total_edits' ] ?? -1 );
} );

echo new OOUI\FormLayout( [
	'method' => 'POST',
	'items' => [
		new OOUI\FieldsetLayout( [
			'label' => null,
			'items' => [
				new OOUI\FieldLayout(
					new OOUI\ButtonInputWidget( [
						'classes' => [ 'form-submit' ],
						'label' => 'Update stats',
						'type' => 'submit',
						'name' => 'update',
						'flags' => [ 'progressive' ]
					] ),
					[
						'align' => 'inline',
					]
				),
			]
		] ),
	]
] );

echo '<table class="wikis"><tr class="headerRow"><th>Wiki</th>';
foreach ( $short_fields as $field => $fieldMeta ) {
	echo '<th>' . $fieldMeta['label'] . '</th>';
}
foreach ( $wikis as $wiki => $data ) {
	echo '<tr>' .
		'<td data-label="Wikis" class="wiki"><a href="wikis/' . $wiki . '/w/index.php" title="' . $wiki . '">' . substr( $wiki, 0, 10 ) . '</a></td>';

	foreach ( $short_fields as $field => $fieldMeta ) {
		echo '<td data-label="' . $fieldMeta['label'] . '">' .
			'<a href="wikis/' . $wiki . '/w/index.php/' . $fieldMeta['link'] . '">' .
				( isset( $data[$field] ) ?
					( isset( $fieldMeta['formatter'] ) ? $fieldMeta['formatter']( $data[$field] ) : $data[$field] ) :
					'<em>?</em>'
				) .
			'</a>' .
		'</td>';
	}
	echo '</tr>';
}
echo '</table>';

include "footer.html";