[Расширение] (phpBB 3.1-3.3) BB3Topics: вывод новых тем, сообщений, объявлений, голосований, популярных и т.п. тем

[PPK]

Не видно ничего на скриншоте

[southklad]

После обновления до новой версии, такая ошибка на главной

Код: Выделить всё

SQL ERROR [ mysqli ]

Column 'post_id' in field list is ambiguous [1052]

SQL

SELECT topic_title, f.forum_id, forum_name, post_id, t.topic_id, topic_posts_approved, topic_time, topic_last_post_time, post_time, fp.post_text AS first_post_text, fpu.user_avatar AS fp_avatar, fpu.user_avatar_type AS fp_avatar_type, fpu.user_avatar_width AS fp_avatar_width, fpu.user_avatar_height AS fp_avatar_height FROM phpbb_topics t, phpbb_forums f, phpbb_posts p LEFT JOIN phpbb_posts fp ON (fp.post_id = t.topic_first_post_id) LEFT JOIN phpbb_users fpu ON (fpu.user_id = t.topic_poster) WHERE t.topic_visibility = 1 AND f.forum_id=t.forum_id AND t.topic_posts_approved > 0 AND t.topic_last_post_id=p.post_id AND t.topic_first_post_id!=p.post_id AND t.forum_id = f.forum_id AND t.forum_id IN('424', '23', '432', '433', '434', '435', '436', '437', '345') ORDER BY topic_last_post_time DESC LIMIT 10

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/ppk/bb3topics/core/bb3topics.php
LINE: 716
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/ppk/bb3topics/event/listener.php
LINE: 60
CALL: ppk\bb3topics\core\bb3topics->display_bb3topics()

FILE: (not given by php)
LINE: (not given by php)
CALL: ppk\bb3topics\event\listener->display_bb3t_index()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 158
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 231
CALL: phpbb\event\dispatcher->trigger_event()

Отправлено спустя 27 минут 3 секунды:
Так же пытаюсь подогнать под свой стиль, но не получается. Вот так у меня было

Код: Выделить всё

<div class="panel" style="<!-- IF S_BB3TOPICS_HEIGHT and not S_DISPLAY_BB3TOPICS_V -->max-height:{S_BB3TOPICS_HEIGHT}px;overflow:auto;<!-- ENDIF -->">
<div class="forabg">
			<div class="inner">{$CA_BLOCK2_START}<a href="http://southklad.ru/forum/viewforum.php?f=23">{L_BB3TOPICS_AYK}</a>{$CA_BLOCK2_START2} 
			<ul class="topiclist">
				<li class="header">
					<dl class="icon">
						<dt><div class="list-inner">&nbsp;</div></dt>
						<dd>&nbsp;</dd>
					</dl>
				</li>
			</ul>
			<ul class="topiclist forums">
				<li class="row">
	<div class="inner" style="background-color: #F3EDDD;">
		<span class="corners-top"><span></span></span>
			<p><a href="./search.php?search_id=egosearch&fid[]=23&sc=0&sr=topics" title="{L_BB3TOPICS_AVTOR_ID}">{L_BB3TOPICS_AVTOR_ID}</a></p>
			<table class="tablebg" width="100%" cellspacing="1" cellpadding="0">
				<!-- IF not S_DISPLAY_BB3TOPICS_V -->
				<tr>
					<!-- IF .bb3topics_topics --><td class="bg1"><strong>{L_BB3TOPICS_TOPICS}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_announces --><td class="bg1"><strong>{L_BB3TOPICS_ANNOUNCES}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_viewed --><td class="bg1"><strong>{L_BB3TOPICS_VIEWED}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_replies --><td class="bg1"><strong>{L_BB3TOPICS_REPLIES}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_votes --><td class="bg1"><strong>{L_BB3TOPICS_VOTES}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_random --><td class="bg1"><strong>{L_BB3TOPICS_RANDOM}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_personal --><td class="bg1"><strong>{L_BB3TOPICS_PERSONAL}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_sticky --><td class="bg1"><strong>{L_BB3TOPICS_STICKY}</strong></td><!-- ENDIF -->
					<!-- IF .bb3topics_global --><td class="bg1"><strong>{L_BB3TOPICS_GLOBAL}</strong></td><!-- ENDIF -->
				</tr>
				<tr><!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_topics --><tr><td class="bg1"><strong>{L_BB3TOPICS_TOPICS}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_topics -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_topics -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_topics.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_topics.U_VIEW_TOPIC}" title="{bb3topics_topics.FULL_TITLE}" class="topictitle">{bb3topics_topics.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_topics -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_announces --><tr><td class="bg1"><strong>{L_BB3TOPICS_ANNOUNCES}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_announces -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_announces -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_announces.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_announces.U_VIEW_TOPIC}" title="{bb3topics_announces.FULL_TITLE}" class="topictitle">{bb3topics_announces.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_announces -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_viewed --><tr><td class="bg1"><strong>{L_BB3TOPICS_VIEWED}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_viewed -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_viewed -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_viewed.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_viewed.U_VIEW_TOPIC}" title="{bb3topics_viewed.FULL_TITLE}" class="topictitle">{bb3topics_viewed.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_viewed -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_replies --><tr><td class="bg1"><strong>{L_BB3TOPICS_REPLIES}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_replies -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_replies -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_replies.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_replies.U_VIEW_TOPIC}" title="{bb3topics_replies.FULL_TITLE}" class="topictitle">{bb3topics_replies.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_replies -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_votes --><tr><td class="bg1"><strong>{L_BB3TOPICS_VOTES}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_votes -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_votes -->
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_votes.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_votes.U_VIEW_TOPIC}" title="{bb3topics_votes.FULL_TITLE}" class="topictitle">{bb3topics_votes.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_votes -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_random --><tr><td class="bg1"><strong>{L_BB3TOPICS_RANDOM}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_random -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_random -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_random.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_random.U_VIEW_TOPIC}" title="{bb3topics_random.FULL_TITLE}" class="topictitle">{bb3topics_random.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_random -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_personal --><tr><td class="bg1"><strong>{L_BB3TOPICS_PERSONAL}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_personal -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_personal -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_personal.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_personal.U_VIEW_TOPIC}" title="{bb3topics_personal.FULL_TITLE}" class="topictitle">{bb3topics_personal.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_personal -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_sticky --><tr><td class="bg1"><strong>{L_BB3TOPICS_STICKY}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_sticky -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_sticky -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_sticky.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_sticky.U_VIEW_TOPIC}" title="{bb3topics_sticky.FULL_TITLE}" class="topictitle">{bb3topics_sticky.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_sticky -->
						</ul>
					</td>
					<!-- ENDIF -->
					<!-- IF S_DISPLAY_BB3TOPICS_V --><!-- IF .bb3topics_global --><tr><td class="bg1"><strong>{L_BB3TOPICS_GLOBAL}</strong></td></tr><tr><!-- ENDIF --><!-- ENDIF -->
					<!-- IF .bb3topics_global -->
					<td class="bg1"<!-- IF not S_DISPLAY_BB3TOPICS_V --> style="width: {S_BB3TOPICS_WIDTH}%;" valign="top"<!-- ENDIF -->>
						<ul style="line-height:1.5em;list-style:none;">
						<!-- BEGIN bb3topics_global -->
							<li>
							<!-- IF S_BB3TOPICS_DT --><span style="border-bottom: 1px dotted black;">{bb3topics_global.TIME}</span>&nbsp;<!-- ENDIF --><a href="{bb3topics_global.U_VIEW_TOPIC}" title="{bb3topics_global.FULL_TITLE}" class="topictitle">{bb3topics_global.TITLE}</a><br />
							<!-- EVENT topiclist_row_append -->
							</li>
						<!-- END bb3topics_global -->
						</ul>
					</td>
					<!-- ENDIF -->
				</tr>
			</table>
		<span class="corners-bottom"><span></span></span>
	</div>
</div>
<br style="clear:both" />
</li>
			</ul>
 
			{$CA_BLOCK2_END}
			</div>
		</div>

Как бы тоже самое и для новой версии сделать?

[PPK]

Как бы тоже самое и для новой версии сделать?

А стиль какой?

[southklad]

Стиль вот этот CA Vintage http://www.stsoftware.biz/phpbb30_style ... htmlтолько для 3,1 переделанный

[southklad]

Как бы тоже самое и для новой версии сделать?

А стиль какой?

Подскажите как доработать под этот стиль? Пожалуйста

[DeathMan]

Классное расширение, спасибо за работу...

[chzda]

Здравствуйте.
На стиле AllanStyle-SUBSILVER не захотело запускаться.
Подскажите, возможно ли на этом стиле запустить это приложение

[PPK]

[chzda]

Блин, не понимаю тогда в чем дело.
Можно к Вам обратиться за платной помощью в данном вопросе?

Отправлено спустя 43 секунды:
Хочу, что бы выводилось в вертикальном варианте

[PPK]

На других стилях работает?