First post on every page

rxu · Post by **rxu** » Tue Feb 19, 2008 1:03 pm

You haven't executed SQL queries from the MOD installation instruction.

justnicky · Post by **justnicky** » Wed Feb 20, 2008 11:01 am

rxu wrote:You haven't executed SQL queries from the MOD installation instruction.

errm... what does that mean?

rxu · Post by **rxu** » Wed Feb 20, 2008 11:16 am

Code: Select all

ALTER TABLE phpbb_topics ADD topic_first_post_show TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL;

http://www.phpbb.com/community/viewtopi ... 9&t=724145
See "EXECUTING SQL" chapter.

justnicky · Post by **justnicky** » Wed Feb 20, 2008 11:53 am

Thankyou but Php totally confuses me

vinamarine · Post by **vinamarine** » Wed Feb 20, 2008 4:08 pm

You can use phpMyAdmin to execute this query.

issjut · Post by **issjut** » Sat Feb 23, 2008 1:32 pm

Hi rxu,
just a question or request

issjut wrote: It would be great if the first post could have a different color or maybe even just a little distance between first post and new posts. In fact, first post and the new posts could better be kept apart!

[ first post ]
A little distance
[ new post 3 ]
[ new post 2 ]
[ new post 1 ]

Do you see a simple way to realize it now? Currently it's really difficult to differ the first Post from the others.
This confused my users

Maybe, one of the two things is easy to implement?

Renodil · Post by **Renodil** » Sat Feb 23, 2008 10:42 pm

rxu wrote:Could you tell me please what did you do, step by step, detailed?

You mean me? Well, first I did as instructed by the xml files both the one in the root folder of the mod and the template folder for prosilver, then I cleared the cache, and finally I refreshed the Templates, Themes, and Image Sets.

rxu · Post by **rxu** » Sun Feb 24, 2008 2:30 am

Renodil
So, is there a checkbox named "Show on top of every page" when you edit any first post of any topic or posting new topic?

Renodil · Post by **Renodil** » Sun Feb 24, 2008 2:41 am

I don't know. I didn't know to look for that. I'll put it back in my test board and find out. Thanks.

rxu · Post by **rxu** » Sun Feb 24, 2008 3:06 am

issjut wrote:Do you see a simple way to realize it now? Currently it's really difficult to differ the first Post from the others. This confused my users

Try the following code:

Code: Select all

OPEN
viewtopic.php

FIND
	'U_TOPIC'				=> "{$server_path}viewtopic.$phpEx?f=$forum_id&t=$topic_id",

AFTER, ADD
	'S_TOPIC_FIRST_POST_SHOW'	=> ($topic_data['topic_first_post_show'] == 1) ? true : false,

OPEN
styles/prosilver/template/viewtopic_body.html

FIND
	<div id="p{postrow.POST_ID}" class="post

IN-LINE FIND
<!-- IF postrow.S_ROW_COUNT is odd -->

IN_LINE REPLACE
<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 -->bg3<!-- ELSEIF postrow.S_ROW_COUNT is odd -->

FIND
	<hr class="divider" />

AFTER, ADD
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><br /><br /><!-- ENDIF -->

OPEN
styles/subsilver/template/viewtopic_body.html

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
<!-- END postrow -->

BEFORE, ADD
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><br /><br /><!-- ENDIF -->
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

But I guess this is suitable for default posts sorting option only.

Renodil · Post by **Renodil** » Sun Feb 24, 2008 3:52 am

rxu wrote:

issjut wrote:Do you see a simple way to realize it now? Currently it's really difficult to differ the first Post from the others. This confused my users

Try the following code:

Code: Select all

OPEN
viewtopic.php

FIND
	'U_TOPIC'				=> "{$server_path}viewtopic.$phpEx?f=$forum_id&t=$topic_id",

AFTER, ADD
	'S_TOPIC_FIRST_POST_SHOW'	=> ($topic_data['topic_first_post_show'] == 1) ? true : false,

OPEN
styles/prosilver/template/viewtopic_body.html

FIND
	<div id="p{postrow.POST_ID}" class="post

IN-LINE FIND
<!-- IF postrow.S_ROW_COUNT is odd -->

IN_LINE REPLACE
<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 -->bg3<!-- ELSEIF postrow.S_ROW_COUNT is odd -->

FIND
	<hr class="divider" />

AFTER, ADD
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><br /><br /><!-- ENDIF -->

OPEN
styles/subsilver/template/viewtopic_body.html

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
	<!-- IF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

REPLACE WITH
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><tr class="row3"><!-- ELSEIF postrow.S_ROW_COUNT is even --><tr class="row1"><!-- ELSE --><tr class="row2"><!-- ENDIF -->

FIND
<!-- END postrow -->

BEFORE, ADD
	<!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><br /><br /><!-- ENDIF -->
# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

But I guess this is suitable for default posts sorting option only.

I don't see how that makes the first post stand out on every page.

rxu · Post by **rxu** » Sun Feb 24, 2008 4:14 am

Do you mean the code itself is or do you mean you've applied it and it's not workable?

If last case, didn't you forget to clear the cache?

Renodil · Post by **Renodil** » Sun Feb 24, 2008 6:24 am

rxu wrote:Do you mean the code itself is or do you mean you've applied it and it's not workable?
If last case, didn't you forget to clear the cache?

If you're talking to me I'm fine now. I didn't know there was a check box that is placed in the posting when starting a topic or editing the first post of it.

issjut · Post by **issjut** » Sun Feb 24, 2008 10:55 pm

Thank U! Everything works perfect!

AHTEPO · Post by **AHTEPO** » Sat Mar 01, 2008 9:58 pm

Renodil wrote:I don't see how that makes the first post stand out on every page.

You mean that?

Code: Select all

FIND
   <hr class="divider" />

AFTER, ADD
   <!-- IF S_TOPIC_FIRST_POST_SHOW and postrow.S_ROW_COUNT eq 0 --><br /><br /><!-- ENDIF -->

rxu, many thanks for you, man!!! But i have one question - how can i set "First post on every page" enabled/disabled for definite topics in ACP?

advertisements