Resent Topic hilfe

Fragen zu allen Themen rund ums Programmieren außerhalb von phpBB können hier gestellt werden - auch zu anderen Programmiersprachen oder Software wie Webservern und Editoren.
Antworten
Tamilgate
Mitglied
Beiträge: 14
Registriert: 04.10.2006 20:22

Resent Topic hilfe

Beitrag von Tamilgate »

Also ich hab das Recent Topic mir runtergeladen und auch gemacht was da stand

aber jetz bekom ich einen fehler von
Warning: include_once() [function.include-once]: Unable to access /srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/forum/config.php in /srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/recent.php on line 13

Warning: include_once(/srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/forum/config.php) [function.include-once]: failed to open stream: No such file or directory in /srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/recent.php on line 13

Warning: include_once() [function.include]: Failed opening '/srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/forum/config.php' for inclusion (include_path='.:/srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/') in /srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/recent.php on line 13

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /srv/www/httpd/phost/t/com/pytalhost/tamilgate/web/forum/phpBB2/recent.php on line 14
Unable to select server.

Hier ist mein Resent PHP:
<?php
// ############ Edit below ########################################
$topic_length = '30'; // length of topic title
$topic_limit = '10'; // limit of displayed topics
$special_forums = '0'; // specify forums ('0' = no; '1' = yes)
$forum_ids = ''; // IDs of forums; separate them with a comma

$config_path = '/forum/'; // path to config.php
$root_path = '/forum/'; // link path
// ############ Edit above ########################################

$path = dirname(__FILE__);
include_once($path.$config_path .'config.php');
mysql_connect($dbhost, $dbuser, $dbpasswd) OR die('Unable to select server.');
mysql_select_db($dbname) OR die('Unable to select database.');

// ############## output ##############
echo '<table width="100%" cellpadding="1" cellspacing="1" border="0" align="center">
<tr>
<th colspan="2">'. $topic_limit .' last topics</th>
</tr>';
// ############## output ##############

$where_forums = ( $special_forums == '0' ) ? '' : 't.forum_id IN ('. $forum_ids .') AND ';
$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username AS first_poster, u.user_id AS first_poster_id, u2.username AS last_poster, u2.user_id AS last_poster_id, p.post_username AS first_poster_name, p2.post_username AS last_poster_name, p2.post_time
FROM ". $table_prefix ."topics t, ". $table_prefix ."forums f, ". $table_prefix ."users u, ". $table_prefix ."posts p, ". $table_prefix ."posts p2, ". $table_prefix ."users u2
WHERE $where_forums t.topic_poster = u.user_id AND f.forum_id = t.forum_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
ORDER BY t.topic_last_post_id DESC LIMIT $topic_limit";
$result = mysql_query($sql);
if( !$result )
{
die('SQL Statement Error: '. mysql_error());
exit();
}

$line = array();
while( $row = mysql_fetch_array($result) )
{
$line[] = $row;
}

for( $i = 0; $i < count($line); $i++ )
{
$forum_id = $line[$i]['forum_id'];
$forum_url = $root_path .'viewforum.php?f='. $forum_id;
$topic_id = $line[$i]['topic_id'];
$topic_url = $root_path .'viewtopic.php?t='. $topic_id;

$topic_title = ( strlen($line[$i]['topic_title']) < $topic_length ) ? $line[$i]['topic_title'] : substr(stripslashes($line[$i]['topic_title']), 0, $topic_length) .'...';

$topic_type = ( $line[$i]['topic_type'] == '2' ) ? 'Announcement ': '';
$topic_type .= ( $line[$i]['topic_type'] == '3' ) ? 'Global Announcement ': '';
$topic_type .= ( $line[$i]['topic_type'] == '1' ) ? 'Sticky ': '';
$topic_type .= ( $line[$i]['topic_vote'] ) ? 'Poll ': '';

$views = $line[$i]['topic_views'];
$replies = $line[$i]['topic_replies'];

$first_time = date('d.m.Y', $line[$i]['topic_time']);
$first_author = ( $line[$i]['first_poster_id'] != '-1' ) ? '<a href="'. $root_path .'profile.php?mode=viewprofile&u='. $line[$i]['first_poster_id'] .'">'. $line[$i]['first_poster'] .'</a>' : ( ($line[$i]['first_poster_name'] != '' ) ? $line[$i]['first_poster_name'] : 'guest' );
$last_time = date('d.m.Y', $line[$i]['post_time']);
$last_author = ( $line[$i]['last_poster_id'] != '-1' ) ? $line[$i]['last_poster'] : ( ($line[$i]['last_poster_name'] != '' ) ? $line[$i]['last_poster_name'] : 'guest' );
$last_url = '<a href="'. $root_path .'viewtopic.php?p='. $line[$i]['topic_last_post_id'] .'#'. $line[$i]['topic_last_post_id'] .'">'. $last_author .'</a>';

// ############## output ##############
echo '<tr>
<td valign="top" nowrap="nowrap">'. $topic_type .'<a href="'. $topic_url .'">'. $topic_title .'</a></td>
</tr>
<tr>
<td><a href="'. $forum_url .'" target="_blank">'. $line[$i]['forum_name'] .'</a>: '. $last_url .' '. $last_time .'</td>
</tr>';
// ############## output ##############
}

echo '</table>';
mysql_close();
?>
Der sagt ja das der fehler zeile 13 ist:
also die hier
include_once($path.$config_path .'config.php');
was muss ich dort eintragen?
und wie muss es ausehen

Bitte helft mir


Es tut mir leid das ich neues thema auf mache aber ich hab überrall gesucht aber gab nicht das gleiche deshalb habe ich neu aufgemacht
Benutzeravatar
Stefane
Mitglied
Beiträge: 784
Registriert: 04.02.2006 22:43
Wohnort: Rathenow
Kontaktdaten:

Beitrag von Stefane »

hiho,
du siehst in der recent.php folgenden text ganz oben:

Code: Alles auswählen

// ############ Edit below ########################################
$topic_length = '30'; // length of topic title
$topic_limit = '10'; // limit of displayed topics
$special_forums = '0'; // specify forums ('0' = no; '1' = yes)
$forum_ids = ''; // IDs of forums; separate them with a comma

$config_path = '/forum/'; // path to config.php
$root_path = '/forum/'; // link path
// ############ Edit above ######################################## 
Das heißt, hier musst du auch was editieren, damit das richtig funktioniert.
Gerade das hier:

Code: Alles auswählen

$config_path = '/forum/'; // path to config.php
$root_path = '/forum/'; // link path
ist falsch, was den Fehler versursacht.
ich denke, wenn du das in das änderst, könnte der Fehler schon behoben sein:

Code: Alles auswählen

$config_path = '/'; // path to config.php
$root_path = '/'; // link path
Antworten

Zurück zu „Coding & Technik“