Code: Selecteer alles
There are no posts in this forum.
Click on the Post New Topic link on this page to post one.Code: Selecteer alles
$sql = "SELECT t.*, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
FROM " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2, " . TOPICS_STATIC_TABLE . " st
WHERE t.forum_id = $forum_id
AND t.topic_poster = u.user_id
AND st.topic_id = t.topic_id
AND p.post_id = t.topic_first_post_id
AND p2.post_id = t.topic_last_post_id
AND u2.user_id = p2.poster_id
AND t.topic_type <> " . POST_ANNOUNCE . "
AND t.topic_type <> " . POST_GLOBAL_ANNOUNCE . "
$limit_topics_time
ORDER BY t.topic_type DESC, st.static_id DESC, t.topic_status ASC, t.topic_last_post_id DESC
LIMIT $start, ".$board_config['topics_per_page'];Code: Selecteer alles
<?php
/***************************************************************************
* $RCSfile: nivisec_install.php,v $
* -------------------
* copyright : (C) 2003 Nivisec.com
* email : support@nivisec.com
*
* $Id: nivisec_install.php,v 1.1.1.1 2003/07/04 05:25:51 nivisec Exp $
*
*
***************************************************************************/
/***************************************************************************
*
* This program 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.
*
***************************************************************************/
define('IN_PHPBB', TRUE);
// Check for what root path we are in
if (file_exists('./config.php'))
{
$phpbb_root_path = './';
}
elseif (file_exists('../config.php'))
{
$phpbb_root_path = '../';
}
else
{
die('Can not find the phpbb root path! Make sure this file is in your phpBB directory');
}
require($phpbb_root_path.'extension.inc');
require($phpbb_root_path.'config.php');
require($phpbb_root_path.'includes/db.'.$phpEx);
$sql_queue = array(
"ALTER TABLE `phpbb_forums` ADD `forum_static` TINYINT( 1 ) UNSIGNED DEFAULT '0' NOT NULL",
"CREATE TABLE `phpbb_topics_static` (
`forum_id` MEDIUMINT UNSIGNED NOT NULL ,
`topic_id` MEDIUMINT UNSIGNED NOT NULL ,
`static_id` MEDIUMINT UNSIGNED NOT NULL ,
INDEX ( `topic_id` ))"
);
echo '<html><head><title>SQL Install</title><style type="text/css">
<!--
body {
background-color: #E5E5E5;
scrollbar-face-color: #DEE3E7;
scrollbar-highlight-color: #FFFFFF;
scrollbar-shadow-color: #DEE3E7;
scrollbar-3dlight-color: #D1D7DC;
scrollbar-arrow-color: #006699;
scrollbar-track-color: #EFEFEF;
scrollbar-darkshadow-color: #98AAB1;
}
font,th,td,p { font-family: Verdana, Arial, Helvetica, sans-serif }
a:link,a:active,a:visited { color : #006699; }
a:hover { text-decoration: underline; color : #DD6900; }
hr { height: 0px; border: solid #D1D7DC 0px; border-top-width: 1px;}
.bodyline { background-color: #FFFFFF; border: 1px #98AAB1 solid; }
.forumline { background-color: #FFFFFF; border: 2px #006699 solid; }
td.row1 { background-color: #EFEFEF; }
td.row2 { background-color: #DEE3E7; }
td.row3 { background-color: #D1D7DC; }
td.cat,td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom {
background-image: url(templates/subSilver/images/cellpic1.gif);
background-color:#D1D7DC; border: #FFFFFF; border-style: solid; height: 28px;
}
td.cat,td.catHead,td.catBottom {
height: 29px;
border-width: 0px 0px 0px 0px;
}
th.thHead,th.thSides,th.thTop,th.thLeft,th.thRight,th.thBottom,th.thCornerL,th.thCornerR {
font-weight: bold; border: #FFFFFF; border-style: solid; height: 28px;
}
td.row3Right,td.spaceRow {
background-color: #D1D7DC; border: #FFFFFF; border-style: solid;
}
th.thHead,td.catHead { font-size: 12px; border-width: 1px 1px 0px 1px; }
th.thSides,td.catSides,td.spaceRow { border-width: 0px 1px 0px 1px; }
th.thRight,td.catRight,td.row3Right { border-width: 0px 1px 0px 0px; }
th.thLeft,td.catLeft { border-width: 0px 0px 0px 1px; }
th.thBottom,td.catBottom { border-width: 0px 1px 1px 1px; }
th.thTop { border-width: 1px 0px 0px 0px; }
th.thCornerL { border-width: 1px 0px 0px 1px; }
th.thCornerR { border-width: 1px 1px 0px 0px; }
.maintitle {
font-weight: bold; font-size: 22px; font-family: "Trebuchet MS",Verdana, Arial, Helvetica, sans-serif;
text-decoration: none; line-height : 120%; color : #000000;
}
.gen { font-size : 12px; }
.genmed { font-size : 11px; }
.gensmall { font-size : 10px; }
.gen,.genmed,.gensmall { color : #000000; }
a.gen,a.genmed,a.gensmall { color: #006699; text-decoration: none; }
a.gen:hover,a.genmed:hover,a.gensmall:hover { color: #DD6900; text-decoration: underline; }
.cattitle { font-weight: bold; font-size: 12px ; letter-spacing: 1px; color : #006699}
a.cattitle { text-decoration: none; color : #006699; }
a.cattitle:hover{ text-decoration: underline; }
.copyright { font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif; color: #444444; letter-spacing: -1px;}
a.copyright { color: #444444; text-decoration: none;}
a.copyright:hover { color: #000000; text-decoration: underline;}
-->
</style></head><body>
<table width="100%" cellspacing="0" cellpadding="10" border="0" align="center">
<tr><td class="bodyline"><table width="100%" cellspacing="0" cellpadding="0" border="0"><tr>
<td><a href="http://www.nivisec.com"><img src="http://www.nivisec.com/images/phpbb/random_logo.php" border="0" vspace="1" /></a><br><span class="gensmall">PHP version: ' . phpversion() . '</span></td>
<td align="center" width="100%" valign="middle"><span class="maintitle">Database Table Install</span></td></tr></table><br />';
for($i=0; $i < count($sql_queue); $i++)
{
$sql = $sql_queue[$i];
$sql = str_replace('phpbb_', $table_prefix, $sql);
if (!$db->sql_query($sql))
{
$error = $db->sql_error();
$error_m = $error['message'];
$error_info = (substr_count($error_m, 'Duplicate') || substr_count($error_m, 'already exists')) ? '<br><b>Analysis:</b><span class="gen">This is considered a duplicate entry and can be ignored as a failure because the needed information is already inserted.</span>' : '';
echo "[<font color=\"red\">FAILED</font>] <span class=\"gensmall\">:: $sql</span><br />
<b>Reason:</b><span class=\"gen\">$error_m</span>
$error_info<br /><br />";
}
else
{
print '[<font color="green">OK</font>] <span class="gensmall">:: ' . $sql . '</span><br /><br />';
}
}
print '<br /><span class="maintitle">Please delete this file for security reasons!</span>';
echo '</table><br><div align="center"><span class="copyright">
Powered by <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB</a> © 2001, 2002 phpBB Group<br />
Table Install by <a href="http://www.nivisec.com" target="_nivisec" class="copyright">Nivisec.com</a></span></div>
</td></tr></table></body></html>';
?>