static topics

MeDieViL · Bericht door **MeDieViL** » 18 feb 2004, 16:55

ik heb die mod geinstalleert, maar als ik in een forum kom dan zie ik dit

There are no posts in this forum.
Click on the Post New Topic link on this page to post one.

!!

MeDieViL · Bericht door **MeDieViL** » 18 feb 2004, 18:09

ik denki dat hier ergens de fout zit...

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'];

MeDieViL · Bericht door **MeDieViL** » 18 feb 2004, 19:27

iemand? ik weet bena zeker dat daar een fout zit

omdat ik dat normaal moest replacen met iets, maar heb dat ni gedaan en geprobeert de dinge die erbij staan te kopiere erin omdat anders een paar mdos zioals global announcement ni meer zouden werken

MeDieViL · Bericht door **MeDieViL** » 19 feb 2004, 18:38

plz!!!
zeg dan iemand tenminste dat er geen fouten zitten in dat stukje

WebSiteNet · Bericht door **WebSiteNet** » 19 feb 2004, 18:44

Geef dan wat meer info over welk board, welke foutnmeldingen precies en waar (screenshot?), en welke mod.

MeDieViL · Bericht door **MeDieViL** » 19 feb 2004, 18:53

static topic mod zoals ik al zei?

screenshot? na dat ik de mod had geinstalleert, krijg ik gewoon in elk forum "er zijng een berichten in dit forum" ofzoiets, zoals op een nieuw forum

board: http://www.tradingworld.net/forum

MeDieViL · Bericht door **MeDieViL** » 20 feb 2004, 19:45

plz
ik wil die mod graag, ik denk dat er een conflict is met de cat hierachie mod

de mod
http://www.nivisec.com/phpbb.php?l=p&fi=22

viewforum
http://www.tradingworld.net/tw/viewforum.php.txt

daar moet ergesn een foutje zitten

MeDieViL · Bericht door **MeDieViL** » 20 feb 2004, 22:41

pff die mod werkt niet dan..., de vraag is nu, ik heb die deze sql installer gebruikt ervoor, hoe krijg ik alles terug uit de database??

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> &copy; 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>';
?>

WebSiteNet · Bericht door **WebSiteNet** » 21 feb 2004, 08:25

Door het veld forum_static te verwijderen uit de forums tabel en de tabel phpbb_forums_static (oid) te verwijderen.