phpBB.de

Code: Alles auswählen

	<td class="row3" align="center" valign="middle" width="45" height="36"><img src="{catrow.forumrow.FORUM_FOLDER_IMG}" width="45" height="36" alt="{catrow.forumrow.L_FORUM_FOLDER_ALT}" title="{catrow.forumrow.L_FORUM_FOLDER_ALT}" /></td>
	<td class="row1" width="620" onmouseover="this.style.backgroundColor='{C_ROW1_OVER}';" onmouseout="this.style.backgroundColor='{C_ROW1}';" onclick="window.location.href='{catrow.forumrow.U_VIEWFORUM}'">
        <span class="forumlink"> <a href="{catrow.forumrow.U_VIEWFORUM}" class="forumlink">{catrow.forumrow.FORUM_NAME}</a><br />
	  </span> <span class="genmed">{catrow.forumrow.FORUM_DESC} {catrow.forumrow.ACTIVE_TOTAL} {catrow.forumrow.ACTIVE} {catrow.forumrow.ACTIVE_INFO}<br />
	  </span></td>

Code: Alles auswählen

Could not obtain topic ids

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') GROUP BY topic_id' at line 

SELECT topic_id FROM phpbb_posts WHERE post_id IN () GROUP BY topic_id

Line : 72

Code: Alles auswählen

Could not obtain main information

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND p.post_id = t.topic_last_post_id AND UNIX_TIMESTAMP(NOW()

SELECT from_unixtime(p.post_time, '%d.%m.%y %H:%i:%s') as topic_time, f.forum_name as forum_name, f.forum_id as forum_id, u.username as username, u2.username as username2, u2.user_id as user_id2, p.poster_id as poster_id, p.post_username as post_username, p.post_id as post_id, t.*, p.post_time as post_time FROM phpbb_topics t, phpbb_posts p LEFT OUTER JOIN phpbb_forums f on p.forum_id = f.forum_id LEFT OUTER JOIN phpbb_users u on p.poster_id = u.user_id LEFT OUTER JOIN phpbb_users u2 on u2.user_id = t.topic_poster WHERE t.topic_id IN () AND p.post_id = t.topic_last_post_id AND UNIX_TIMESTAMP(NOW()) - p.post_time < 86400 ORDER BY p.post_time desc LIMIT 0, 50

Code: Alles auswählen

<?php
// ############ Edit below ###############################
$length = '25'; // length of topic title
$limit = 5'; // how many topics?
$l_recent = 'recent topics';
$l_started = 'started at';
$l_by = 'by';
$special_forums = '0'; // 0 = no; 1 = yes
$forums = ',2,3,4,5,6,7,8,9,10,11,12,13,14,17,18,19,20,21,22,23,24,28,29,30,31,32,33,35,36,37,38,39'; // ID of forums; separate them with a comma
$css = 'http://www.your_domain.com/forum/templates/name/name.css'; //path and name to your css_sheet - optional
// ############ Edit above ###############################