PhpBB3 BBCodes

Code: Select all

<div class="forabg">
{$CA_BLOCK_START}
  <div class="inner"><span class="corners-top"><span></span></span>
  <ul class="topiclist">
	 <li class="header">
		<dl class="no_icon">
		   <dt>{TSRAT_NUMBER} {L_RECENT_ACTIVE}</dt>
		   <dd class="topics">{L_REPLIES}</dd>
		   <dd class="posts">{L_VIEWS}</dd>
		   <dd class="lastpost"><span>{L_LAST_POST}</span></dd>
		</dl>
	 </li>
  </ul>
  <ul <!-- IF S_TS_JSSCROLL and not S_TS_TICKER -->id="vertical-ticker"<!-- ELSEIF S_TS_TICKER and not S_TS_JSSCROLL -->id="news" <!-- ENDIF -->class="topiclist forums">
	 <!-- IF S_TS_TICKER and not S_TS_JSSCROLL -->
	 <li class="row">
	 <!-- BEGIN recent_active -->
	 <dl class="icon" style="background-image: url({ROOT_PATH}images/starimg.png); background-repeat: no-repeat;">
		<dt>
		   <a href="{recent_active.U_FIRST_TOPIC}" class="forumtitle">{recent_active.TOPIC_TITLE}</a><br />
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_FIRST_POSTER_COLOUR};" href="{recent_active.USERNAME_FIRST}">{recent_active.TOPIC_FIRST_POSTER_NAME}</a> {L_IN} <a href="{recent_active.FORUM_URL}">{recent_active.FORUM_NAME}</a> {recent_active.TOPIC_TIME}
		</dt>
		<dd class="topics" style="width:8%">{recent_active.TOPIC_REPLIES}</dd>
		<dd class="posts" style="width:8%">{recent_active.TOPIC_VIEWS}</dd>
		<dd class="lastpost"><span>
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_LAST_POSTER_COLOUR};" href="{recent_active.USERNAME_LAST}">{recent_active.TOPIC_LAST_POSTER_NAME}</a> <a href="{recent_active.U_LAST_TOPIC}">{LAST_POST_IMG}</a><br />{recent_active.TOPIC_LAST_POST_TIME}</span>
		</dd>
	 </dl>
	 <!-- END recent_active -->
	 </li>
	 <!-- ELSE -->
	 <!-- BEGIN recent_active -->
	 <li class="row">
	 <dl class="icon" style="background-image: url({ROOT_PATH}images/starimg.png); background-repeat: no-repeat;">
		<dt>
		   <a href="{recent_active.U_FIRST_TOPIC}" class="forumtitle">{recent_active.TOPIC_TITLE}</a><br />
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_FIRST_POSTER_COLOUR};" href="{recent_active.USERNAME_FIRST}">{recent_active.TOPIC_FIRST_POSTER_NAME}</a> {L_IN} <a href="{recent_active.FORUM_URL}">{recent_active.FORUM_NAME}</a> {recent_active.TOPIC_TIME}
		</dt>
		<dd class="topics" style="width:8%">{recent_active.TOPIC_REPLIES}</dd>
		<dd class="posts" style="width:8%">{recent_active.TOPIC_VIEWS}</dd>
		<dd class="lastpost"><span>
		   {L_POST_BY_AUTHOR} <a style="font-weight:bold; color: #{recent_active.TOPIC_LAST_POSTER_COLOUR};" href="{recent_active.USERNAME_LAST}">{recent_active.TOPIC_LAST_POSTER_NAME}</a> <a href="{recent_active.U_LAST_TOPIC}">{LAST_POST_IMG}</a><br />{recent_active.TOPIC_LAST_POST_TIME}</span>
		</dd>
	 </dl>
	 </li>
	 <!-- END recent_active -->
	 <!-- ENDIF -->
  </ul>
  <span class="corners-bottom"><span></span></span></div>
{$CA_BLOCK_END}
</div>
<!-- IF S_TS_JSSCROLL and TS_JSSCROLL_NAVIGATION and not S_TS_TICKER -->
<div style="text-align:right; padding-right:10px;"><a href="#" title="{L_PREVIOUS_SCROLL}" id="ticker-previous"><img src="{ROOT_PATH}images/player_rew.png" width="16" height="16" alt="{L_PREVIOUS_SCROLL}" /></a> <a href="#" title="{L_NEXT_SCROLL}" id="ticker-next"><img src="{ROOT_PATH}images/player_fwd.png" width="16" height="16" alt="{L_NEXT_SCROLL}" /></a> <a href="#" title="{L_STOP_SCROLL}" id="stop"><img src="{ROOT_PATH}images/player_pause.png" width="16" height="16" alt="{L_STOP_SCROLL}" /></a> <a href="#" title="{L_START_SCROLL}" id="start"><img src="{ROOT_PATH}images/player_play.png" width="16" height="16" alt="{L_START_SCROLL}" /></a></div>
<!-- ENDIF -->

Code: Select all

SELECT `post_text` FROM phpbb_posts WHERE `topic_id` = 3630;

Code: Select all

MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0035 sec )

Code: Select all

DELETE FROM phpbb_topics WHERE topic_id IN (SELECT topic_id FROM phpbb_posts WHERE post_id IS NULL);