Headlines.pl from YaBB Gold to Yabbse

[hprod]

I really loved YaBBSE, I installed some days ago and migrate 10.000 messages from YaBB Gold.
I am really happy of this choice.

Now I wonder if exists any mod like Headlines.pl YaBB Gold mod. I used to show at my home page the Recent Update topics.
Yes, yes, I used News.php and SSI.php, but it is not exactly like Headlines.pl

Headlines.pl showed:
1. only the subject of last updated topics from all boards
But only showed one line one per thread, not like SSI.php, that shows links to all posts in the same thread.

2. and add 'new icon' if the user hadnt read it yet.
3. Numbers the subjects

An example:
http://216.239.51.100/search?q=cache:j3bthVB5FZoJ:www.digital-photographers.net/members/yabb/Headlines.pl+headlines.pl+yabb&hl=es&ie=UTF-8

If this mod doesnt exists, it would be possible to modify SSI.php to do the same that Headlines.pl

Modifying SSI recenttopics:
1. Deleting Board name
2. Deleting author
3. Deleting Date
4. Numbering subjects displayed
5. Only showing one link to thread updated
--------- more features ----------
1. It would be great to select from which boards I want to show the TOP, and not always ALL BOARDS


THANKS A LOT!!! I am really grateful for your job.

[Spaceman-Spiff]

1. only the subject of last updated topics from all boards
But only showed one line one per thread, not like SSI.php, that shows links to all posts in the same thread.

Install the new recent topics mod/SSI enchancement, follow the white rabbit link in my sig

2. and add 'new icon' if the user hadnt read it yet.

This has been around since yse v1.5.0 or 1.5.1, the new icon will show if the cookies setting is correct (no local cookies if calling the SSI from a different directory)

3. Numbers the subjects

the code can be edited easily to do this

[hprod]

Sorry,
I cant get into your link:
http://www.monkey-pirate.com/php/ysegallery?action=download
Seems to be down

[Spaceman-Spiff]

yes, site's been down since morning
here's the mod: http://www.yabbse.org/community/index.php?board=158;action=display;threadid=18816

[hprod]

Spaceman, it's really really GOD! Exactly what I was looking for!!
Thanks a lot.

I need to ask you for help, I would like to:
1.) Include numbering of recent topics (may you help me with code)
2.) Change SQL Select to take only recent topics from several boards, not all

Thanks again,
I'm really grateful of your help

[Spaceman-Spiff]

1.) Include numbering of recent topics (may you help me with code)

edit SSI.php, search for:

Code Select Expand

   define('YaBBSE_ssi', 1);add after

Code Select Expand

   $recent_counter = 0;
search for

Code Select Expand

            $recent_time = timeformat($row['posterTime']);add after:

Code Select Expand

            $recent_counter++;
then somewhere in the template file, add: $recent_counter

2.) Change SQL Select to take only recent topics from several boards, not all

search for:

Code Select Expand

      WHERE m.ID_MSG = t.ID_LAST_MSGadd after:

Code Select Expand

         AND (t.ID_BOARD=3 OR t.ID_BOARD=4)you can add as many board as you want, just put another OR...
or if you just want to exclude several boards: AND (t.ID_BOARD!=3 AND t.ID_BOARD!=4)

[hprod]

YEAHHHHHHHHHHHH
IT's really really great!!!
I'm so grateful for your help!!!

YES, That's exactly what I was looking for!!!

THANKS A LOT SPACEMAN  

[hprod]

One more question...
recentTopics from SSI.php shows the subject of the last message posted in the topic, but I would like to show the main subject (the first one) of the topic.

May you help me to code it?

Thanks again,
I love YaBB SE
Simply wonderful

[[Unknown]]

Check Spaceman-Spiff's recentPoll/recentTopics SSI mod..  follow the white rabbit.

-[Unknown]

[Spaceman-Spiff]

One more question...
recentTopics from SSI.php shows the subject of the last message posted in the topic, but I would like to show the main subject (the first one) of the topic.

May you help me to code it?

i think showing the last subject is better...
but here's the code anyway, replace the 2nd sql query in recentTopics with this one:

Code Select Expand

      $request = mysql_query("
         SELECT m.posterTime, m2.subject, m.ID_TOPIC, m.posterName, m.ID_MEMBER, IFNULL(mem.realName, m.posterName) AS posterDisplayName, m.icon, t.numReplies, t.ID_BOARD, t.ID_FIRST_MSG, b.name AS bName, IFNULL(lt.logTime, 0) AS isRead, IFNULL(lmr.logTime, 0) AS isMarkedRead
         FROM {$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards as b, {$db_prefix}messages AS m2
            LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER)
            LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC=t.ID_TOPIC AND lt.ID_MEMBER=$ID_MEMBER)
            LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=t.ID_BOARD AND lmr.ID_MEMBER=$ID_MEMBER)
         WHERE m.ID_MSG IN (" . implode(',', $messages) . ")
            AND t.ID_TOPIC=m.ID_TOPIC
            AND b.ID_BOARD=t.ID_BOARD
            AND m2.ID_MSG=t.ID_FIRST_MSG
         ORDER BY m.posterTime DESC;") or database_error(__FILE__, __LINE__);(not tested)

[hprod]

YEAHHHHHHHHHHHHHHHHHHHHHHHH
That works!!!!!!!!

Thanks again, I'm really grateful for your fast answer.

YES YES YES
YES YES YES

;-)

THANKS

[Fizzy]

I gotta tell you hprod, that Spaceman Spiff is one hell of a mod writer.

Mega kudos to spACEman sp1ff

[hprod]

Hehe
Yes it is!!!

[Cadish]

How can I add the new-icon to the "Recent post bar" without working with the SSI.php. That means with Recent.php...

I've been trying to edit LastPostings(), but I didn't succeed...

[Cadish]

NE1? It can't be that hard...