This is a static copy of the SEN v4 forums.
The database used is from Febuary 10th, 2007.
Forums ::
Members
Staredit Network
PDO::ERRMODE_EXCEPTION,
PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false,
];
$pdo = new PDO($dsn, $db['username'], $db['password'], $opt);
$p = isset($_GET['p']) ? (int)$_GET['p'] : 0;
//Static SEN
if (isset($_GET['idx']) || count($_GET) == 0) {
echo '
';
$a = $pdo->query("select name, description, id, last_title, last_poster_name from ibf_forums where parent_id != -1");
$flipper = 0;
while ($row = $a->fetch()) {
echo '
'.$row['last_title'].'
'
.$row['last_poster_name'].'
'.'
'
."
". $row['name'] . ""
.$row['description']."
";
}
echo '
';
} else if (isset($_GET['sf'])) {
$forum_id = (int)$_GET['sf'];
$a = $pdo->prepare("select name from ibf_forums where id = ?");
$a->execute([$forum_id]);
$forumtitle = $a->fetch();
$forumtitle = $forumtitle['name'];
echo '
Staredit Network ->
'.$forumtitle.'
';
$a = $pdo->prepare("select tid, title, description, starter_name, last_poster_name, last_post from ibf_topics WHERE forum_id = ".$forum_id." ORDER BY pinned DESC, last_post DESC LIMIT ?, 25");
$post_quantity = ($p*25) ? $p*25 : '';
$a->execute([$post_quantity]);
$flipper = 0;
while ($row = $a->fetch()) {
echo '
'
."
".date("Y-m-d H:i:s",$row['last_post'])."
"
.$row['last_poster_name']."
".$row['title']."
".$row['starter_name']."
";
}
echo "
";
echo "
Next Page (" . ($p+1) . ")";
} else if (isset($_GET['st'])) {
$topic_id = (int)$_GET['st'];
$a = $pdo->prepare("select t.title, f.name, t.forum_id from ibf_topics as t left join ibf_forums as f on t.forum_id = f.id where tid = ?");
$a->execute([$topic_id]);
$t = $a->fetch();
$topictitle = $t['title'];
$forumname = $t['name'];
$forumid = $t['forum_id'];
$a = $pdo->prepare("select author_name, post_date, post from ibf_posts where topic_id = ? ORDER BY post_date LIMIT ?, 25");
$post_quantity = ($p*25) ? $p*25 : '';
$a->execute([$topic_id, $post_quantity]);
?>
Staredit Network ->
=$forumname?> ->
'>=$topictitle?>
fetch()) {
$row['post'] = str_replace("<#EMO_DIR#>", "smilies", $row['post']);
echo "
".
'".
'
'.$row['post'] ."
";
}
echo "
";
echo "
Next Page (" . ($p+1) . ")";
$pdo = null;
}
?>