News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Last Topics of Person

Started by M-DVD, November 30, 2008, 11:32:24 AM

Previous topic - Next topic

M-DVD

Quote from: neverhurry on June 11, 2009, 06:05:12 AM
hi, a very useful mod, great job!

is it possible not to show the 1st message of the topic? I mean is it possible to show just the subjects?

thank you!

Currently no.

Col

Hi,

There is a conflict between this and the View Any Topic mod.

The View Any Topic mod made the following code change to profile.php:


   <operation>
   <search position="replace"><![CDATA[   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
]]></search>
   <add><![CDATA[   FROM ({$db_prefix}messages AS m, {$db_prefix}messages AS mf, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
]]></add>
  </operation>


This mod attempts to make the following code change at the same point in profile.php:


   <operation>
   <search position="replace"><![CDATA[
   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></search>
   <add><![CDATA[
   FROM {$db_prefix}messages AS m
    INNER JOIN {$db_prefix}topics AS t ON (" . ($context['is_topics'] ? 't.ID_FIRST_MSG = m.ID_MSG' : 't.ID_TOPIC = m.ID_TOPIC') . ")
    INNER JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = t.ID_BOARD)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></add>
  </operation>


Is the solution simply:


    <operation>
   <search position="replace"><![CDATA[
   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></search>
   <add><![CDATA[
   FROM {$db_prefix}messages AS m, {$db_prefix}messages AS mf
    INNER JOIN {$db_prefix}topics AS t ON (" . ($context['is_topics'] ? 't.ID_FIRST_MSG = m.ID_MSG' : 't.ID_TOPIC = m.ID_TOPIC') . ")
    INNER JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = t.ID_BOARD)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></add>
  </operation>


ie Is it that the first line of the added code should read:


    FROM {$db_prefix}messages AS m, {$db_prefix}messages AS mf


?

Thanks.

aw06

Will this be updated to Rc3 ?
:: ShopinJA.com Powered by SMF 1.1.19 | Ig-Oh Theme by Koni | 70 Rock Solid Error Free Mods | Many Custom Edits & Tweaks ::
- Host Unlimited Websites - Free Website Builder & Templates - Unlimited Disk Space & Bandwidth


aw06

Quote from: NIBOGO on March 24, 2010, 11:34:36 AM
Quote from: aw06 on March 24, 2010, 10:53:00 AM
Will this be updated to Rc3 ?

???

Why you need this if it's included by default on SMF 2.0 RC3??

No man, i'm asking is this mod will be updated to work with 2.0 Rc3 :P
:: ShopinJA.com Powered by SMF 1.1.19 | Ig-Oh Theme by Koni | 70 Rock Solid Error Free Mods | Many Custom Edits & Tweaks ::
- Host Unlimited Websites - Free Website Builder & Templates - Unlimited Disk Space & Bandwidth

Nibogo

Quote from: aw06 on March 24, 2010, 12:24:26 PM
Quote from: NIBOGO on March 24, 2010, 11:34:36 AM
Quote from: aw06 on March 24, 2010, 10:53:00 AM
Will this be updated to Rc3 ?

???

Why you need this if it's included by default on SMF 2.0 RC3??

No man, i'm asking is this mod will be updated to work with 2.0 Rc3 :P

You have to be kidding:

Quote from: M-DVD
    * Compatible With:   SMF 1.1.1 - 1.1.8, SMF 2 Beta 3 & 4 (Isn't necessary for RC1)

As I toll you this is already integrated into SMF 2.0 RC3

aw06

i want it to show on profile summary, well in classic mode it does not show ..
:: ShopinJA.com Powered by SMF 1.1.19 | Ig-Oh Theme by Koni | 70 Rock Solid Error Free Mods | Many Custom Edits & Tweaks ::
- Host Unlimited Websites - Free Website Builder & Templates - Unlimited Disk Space & Bandwidth

Nibogo

Quote from: aw06 on March 24, 2010, 06:19:34 PM
i want it to show on profile summary, well in classic mode it does not show ..

You still have the Show Messages link there you can select to Show Messages, Topics or Attachments of that person, I'm pretty sure that isn't going to be update it to SMF 2.0 RC3

Col

Quote from: Col on March 17, 2010, 07:33:30 PM
Hi,

There is a conflict between this and the View Any Topic mod.

The View Any Topic mod made the following code change to profile.php:


   <operation>
   <search position="replace"><![CDATA[   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
]]></search>
   <add><![CDATA[   FROM ({$db_prefix}messages AS m, {$db_prefix}messages AS mf, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
]]></add>
  </operation>


This mod attempts to make the following code change at the same point in profile.php:


   <operation>
   <search position="replace"><![CDATA[
   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></search>
   <add><![CDATA[
   FROM {$db_prefix}messages AS m
    INNER JOIN {$db_prefix}topics AS t ON (" . ($context['is_topics'] ? 't.ID_FIRST_MSG = m.ID_MSG' : 't.ID_TOPIC = m.ID_TOPIC') . ")
    INNER JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = t.ID_BOARD)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></add>
  </operation>


Is the solution simply:


    <operation>
   <search position="replace"><![CDATA[
   FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></search>
   <add><![CDATA[
   FROM {$db_prefix}messages AS m, {$db_prefix}messages AS mf
    INNER JOIN {$db_prefix}topics AS t ON (" . ($context['is_topics'] ? 't.ID_FIRST_MSG = m.ID_MSG' : 't.ID_TOPIC = m.ID_TOPIC') . ")
    INNER JOIN {$db_prefix}boards AS b ON (b.ID_BOARD = t.ID_BOARD)
    LEFT JOIN {$db_prefix}categories AS c ON (c.ID_CAT = b.ID_CAT)]]></add>
  </operation>


ie Is it that the first line of the added code should read:


    FROM {$db_prefix}messages AS m, {$db_prefix}messages AS mf


?

Thanks.

Any help with above code would be greatly appreciated.

Thanks.

sharks

I just installed it on SMF 1.1.11 and it works! Thanks! :D

Biology Forums

Is it also possible to show last topics with no replies?

LuciferMorningstar

I need a mod like this for SMF 2.1.4  :'(

TwitchisMental

Quote from: LuciferMorningstar on January 11, 2024, 07:32:04 PMI need a mod like this for SMF 2.1.4  :'(
Uhmm this is a built in feature of 2.1.4 . Go to a users profile and in the menu hover profile info > show posts > and click topics.

LuciferMorningstar

Quote from: TwitchisMental on January 11, 2024, 07:57:41 PM
Quote from: LuciferMorningstar on January 11, 2024, 07:32:04 PMI need a mod like this for SMF 2.1.4  :'(
Uhmm this is a built in feature of 2.1.4 . Go to a users profile and in the menu hover profile info > show posts > and click topics.

Thank you.  It's a little hidden.  It would be helpful to put some kind of link to your thread list on each user's profile page.

Advertisement: