Portal

[Blisk]

Is there a MOD for EZ portal which show on a portal a Posts from 1 topic.
Like Jokes form Topic "Jokes" on EZ portal?

[oxpus]

Random or the last one?

[Blisk]

random everytime user visit portal

[oxpus]

Okay, I'll take a look the next days...

[Blisk]

ok TNX

[oxpus]

Look here: http://www.oxpus.de/downloads.php?view= ... =317&cat=1

[Blisk]

file is corrupted, please upload it again.
TNX

[oxpus]

Done. Retry it. Sorry.

[Blisk]

didn't find this line

#
#-----[ OPEN ]--------------------------------------------------
#
portal.php

#
#-----[ FIND ]--------------------------------------------------
#
//
// Fetch Posts from Announcements Forum
//

[oxpus]

Find another place. Best bevor the news block!

[Blisk]

It works now.
I put it before birthday block.

But one thing.
I thought more about random post from TOPIC, and not topic itself, some topics have more posts (jokes).
And When the post is longer I hope about fiex size of box and a slider beside.

[oxpus]

You have a link to the Topic under the post text.....
Regard: If you will load the full topic on the portal, the portal itself can slow down

[Blisk]

not a full topic, but only one random post from topics.
and now when a post is long, it streches up a box fully,

or maybe better, fixed size box and scrolling text from post in it.


I manage to do scrolling text.
but not how to make a bacground of
View Comments (Post your comment)
a light blue color?

[oxpus]

Use a class. Look into your .css File in the template folder and search for something like cat... or th....
Use this class in the code block on portal_body.tpl like

Code: Alles auswählen

class="cattitle"

and refresh the browser window...

Hm, one random post from the forum... Not only the first post of a random topic...
Okay, try this:
Open the fetchposts.php, find

Code: Alles auswählen

	$sql = "SELECT t.*, u.username, pt.post_text, pt.bbcode_uid, p.enable_smilies
		FROM " . TOPICS_TABLE . " AS t, " . USERS_TABLE . " AS u, " . POSTS_TEXT_TABLE . " AS pt, " . POSTS_TABLE . " AS p
		WHERE t.forum_id = $fetch_forum_id
			AND t.topic_poster = u.user_id
			AND t.topic_first_post_id = p.post_id
			AND p.post_id = pt.post_id
			AND t.topic_status <> 2
		ORDER BY rand()
		LIMIT 1";

and replace this block with

Code: Alles auswählen

	$sql = "SELECT t.*, u.username, pt.post_text, pt.bbcode_uid, p.enable_smilies
		FROM " . TOPICS_TABLE . " AS t, " . USERS_TABLE . " AS u, " . POSTS_TEXT_TABLE . " AS pt, " . POSTS_TABLE . " AS p
		WHERE t.forum_id = $fetch_forum_id
			AND t.topic_poster = u.user_id
			AND t.topic_id = p.topic_id
			AND p.post_id = pt.post_id
			AND t.topic_status <> 2
		ORDER BY rand()
		LIMIT 1";

This may display a random post from the defined forum.

[Blisk]

It works.
TNX

[Blisk]

Is it possible to have 2 of this?

[oxpus]

From the same or from different forums?

[Blisk]

For the different forums

[oxpus]

So this snippet must install a second time.
With other variables , ACP settings, etc...
Or simply change the SQL and uninstall the part on the ACP!
Find:

Code: Alles auswählen

$sql = "SELECT t.*, u.username, pt.post_text, pt.bbcode_uid, p.enable_smilies
       FROM " . TOPICS_TABLE . " AS t, " . USERS_TABLE . " AS u, " . POSTS_TEXT_TABLE . " AS pt, " . POSTS_TABLE . " AS p
       WHERE t.forum_id = $fetch_forum_id
          AND t.topic_poster = u.user_id
          AND t.topic_id = p.topic_id
          AND p.post_id = pt.post_id
          AND t.topic_status <> 2
       ORDER BY rand()
       LIMIT 1";

and replace with

Code: Alles auswählen

$sql = "SELECT t.*, u.username, pt.post_text, pt.bbcode_uid, p.enable_smilies
       FROM " . TOPICS_TABLE . " AS t, " . USERS_TABLE . " AS u, " . POSTS_TEXT_TABLE . " AS pt, " . POSTS_TABLE . " AS p
       WHERE t.topic_poster = u.user_id
          AND t.topic_id = p.topic_id
          AND p.post_id = pt.post_id
          AND t.topic_status <> 2
       ORDER BY rand()
       LIMIT 2";