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
|
#!/usr/bin/php
<?php
mb_internal_encoding('utf-8');
require __DIR__ . '/inc/cli.php';
$variants = [["hour", 3600], ["day", 3600*24], ["3 days", 3600*24*3], ["week", 3600*24*7], ["month", 3600*24*7*30]];
printf(" || ");
foreach ($variants as $iter) {
[$term, $time] = $iter;
printf("%8s | ", $term);
}
print("\n");
print(str_repeat('=', 13+11*count($variants)));
print("\n");
function mb_str_pad ($input, $pad_length, $pad_string, $pad_type, $encoding="UTF-8") {
if (!$encoding) {
$diff = strlen((string) $input) - mb_strlen((string) $input);
}
else {
$diff = strlen((string) $input) - mb_strlen((string) $input, $encoding);
}
return str_pad((string) $input, $pad_length + $diff, $pad_string, $pad_type);
}
$q = query("SELECT uri FROM ``boards``");
while ($f = $q->fetch()) {
$str = $f['uri'];
$str = mb_str_pad($str,10," ", STR_PAD_LEFT, "UTF-8");
printf("%s || ", $str);
foreach ($variants as $iter) {
[$term, $time] = $iter;
$qq = query(sprintf("SELECT COUNT(*) as count FROM ``posts_%s`` WHERE time > %d", $f['uri'], time()-$time));
$c = $qq->fetch()['count'];
printf("%8d | ", $c);
}
print("\n");
}
|
