ArcNet/recent.php at master · 314parley/ArcNet · 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
<?php
/*
 * This file is part of arcNET
 *
 * arcNET uses core code from Kusaba X and Oneechan
 *
 * tsukihi.me kusabax.cultnet.net oneechan.org
 *
 * arcNET is free software; you can redistribute it and/or modify it under the
 * terms of the GNU General Public License as published by the Free Software
 * Foundation; either version 2 of the License, or (at your option) any later
 * version.
 *
 * kusaba is distributed in the hope that it will be useful, but WITHOUT ANY
 * WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
 * A PARTICULAR PURPOSE. See the GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License along with
 * kusaba; if not, write to the Free Software Foundation, Inc.,
 * 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
 *
 * credits to jmyeom for improving this
 *
 */
require_once 'config.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
	<title>Recent Posts on Oneechan</title>
	<link rel="shortcut icon" href="<?php echo KU_WEBPATH; ?>/favicon.ico" />
</head>
<?php
include KU_ROOTDIR . 'inc/func/stringformatting.php';

global $tc_db;
$limitposts = 20;

$results = $tc_db->GetAll("SELECT * FROM `".KU_DBPREFIX."posts` WHERE `IS_DELETED` = 0 ORDER BY `timestamp` DESC LIMIT $limitposts") or die("invalid query");

if (count($results) > 0) {
	$tpl_page .= '<table border="1" width="100%">'. "\n";
	$tpl_page .= '<tr><th width="75px">'._gettext('Post Number').'</th><th>'._gettext('Post Message').'</th></tr>'. "\n";
	foreach ($results as $result) {
		$real_parentid = ($result['parentid'] == 0) ? $result['id'] : $result['parentid'];
		$result['boardname'] = $tc_db->GetOne("SELECT `name` FROM `".KU_DBPREFIX."boards` WHERE `id` = '".$result['boardid']."'");
		$result['timestamp_formatted'] = formatDate($result['timestamp']);

		$tpl_page .= '<tr><td><a href="'. KU_BOARDSPATH . '/'. $result['boardname'] . '/res/'. $real_parentid . '.html#'. $result['id'] . '">/'. $result['boardname'] . '/'. $result['id'] . '</a></td>
		<td>By ' . formatDisplayName($result['name'], $result['tripcode']) . ' - ' . $result['timestamp_formatted'] . '<br />' .
		stripslashes($result['message']) . '</td></tr>';
	}
	$tpl_page .= '</table>';
}
echo $tpl_page;

?>