Text only | Text with Images

Simple Machines Community Forum

Customizing SMF => Modifications and Packages => Topic started by: M-DVD on November 30, 2008, 11:32:24 AM

Title: Last Topics of Person
Post by: M-DVD on November 30, 2008, 11:32:24 AM
Link to Mod (http://custom.simplemachines.org/mods/index.php?mod=1526)

MOD Last Topics of Person v1.1
=====================






  • Autor:
M-DVD (http://custom.simplemachines.org/mods/index.php?action=profile;u=148997)
  • Version:
1.1
  • Release:
22th November 2008
  • Languages:
(https://www.simplemachines.org/site_images/lang/english.gif) (https://www.simplemachines.org/site_images/lang/english_british.gif) (https://www.simplemachines.org/site_images/lang/spanish.gif) (https://www.simplemachines.org/site_images/lang/spanish_latin.gif) (https://www.simplemachines.org/site_images/lang/romanian.gif) (https://www.simplemachines.org/site_images/lang/arabic.gif)
(https://www.simplemachines.org/site_images/lang/serbian_latin.gif) (https://www.simplemachines.org/site_images/lang/serbian_cyrillic.gif) (https://www.simplemachines.org/site_images/lang/russian.gif) (https://www.simplemachines.org/site_images/lang/ukrainian.gif) (https://www.simplemachines.org/site_images/lang/german.gif)
  • Compatible With:
SMF 1.1.1 - 1.1.8
SMF 2 Beta 3 & 4
(Isn't necessary for RC1)




(https://www.simplemachines.org/community/Themes/smsite/images/star.gif)(https://www.simplemachines.org/community/Themes/smsite/images/star.gif)(https://www.simplemachines.org/community/Themes/smsite/images/star.gif)(https://www.simplemachines.org/community/Themes/smsite/images/star.gif)(https://www.simplemachines.org/community/Themes/smsite/images/star.gif) (http://mods.simplemachines.org/index.php?action=review;sa=add;mod=1526)
Comment this Mod (http://www.simplemachines.org/community/index.php?action=post;topic=277651.0)
(https://www.simplemachines.org/site_images/modtitlebar.png)(https://www.simplemachines.org/site_images/modtitlebar.png)(https://www.simplemachines.org/site_images/modtitlebar.png) (http://custom.simplemachines.org/mods/index.php?action=profile;u=148997)
My MODs (http://custom.simplemachines.org/mods/index.php?action=profile;u=148997)
(https://www.simplemachines.org/community/Themes/smsite/images/bbc/img.gif)(https://www.simplemachines.org/community/Themes/smsite/images/bbc/img.gif)(https://www.simplemachines.org/community/Themes/smsite/images/bbc/img.gif) (http://custom.simplemachines.org/mods/index.php?mod=1526)
Images (http://custom.simplemachines.org/mods/index.php?mod=1526)
(https://www.paypal.com/en_GB/i/btn/btn_donate_SM.gif) (https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=4587421)Help support my MODs (https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=4587421)


Features:


Thanks to SMF Team for code the query to SMF 2.0b.

==========================

Languages (normal & utf-8)


$txt['mod_show_member_topics'] = 'topics of this person';
$txt['showPosts;topics'] = 'Show Topics';
$txt['latest_topics'] = 'Latest topics of:';

==========================

Características:


Fin.
Title: Re: Last Topics of Person
Post by: minos on November 30, 2008, 01:32:06 PM
gracias lo instale y funciona bien... aun no se porque no lo trae por defecto jeje
Title: Re: Last Topics of Person
Post by: M-DVD on November 30, 2008, 01:39:30 PM
ja ja ja, justo estaba por responder a un tema que hiciste hace unos meses en el SubForo en Español donde pedías algo por el estilo, para avisar sobre este MOD.

Y por lo menos SMF 2.0 ya lo trae, solo que no trae el Link en el perfil. En esta versión el MOD solo tiene que hacer ese cambio.  :P

Title: Re: Last Topics of Person
Post by: minos on November 30, 2008, 03:47:14 PM
ah jeje coincidencia pero weno que ya este .. es util
Title: Re: Last Topics of Person
Post by: M@nNiak on November 30, 2008, 06:17:29 PM
Excelente amigo, una opcion que es de mucha ayuda, Me funciona perfecto.   :D

Solo una pequeña sugerencia, nose si seria posible que en vez de solo marcar los "ultimos" temas del usuario mostrara todos los temas iniciados por X usuario como en Vbulletin, por que veo que en este al ir al profile del usuario y dar en "mostrar los ultimos temas.."  solo en la primer pagina salen los temas a partir de la 2 ya son como normalmente se muestran segun la fecha, yose k este Mod es para unicamente los "ultimos temas.." pero seria una excelente opcion poder tener "ver todos los temas iniciados por el usuario".



En fin... este Mod me funciono muy bien Muchas Gracias.  ;)
Title: Re: Last Topics of Person
Post by: OldRockSongs on November 30, 2008, 06:28:40 PM
I just installed this mod. I luv it!
Title: Re: Last Topics of Person
Post by: ~BeneKiD on November 30, 2008, 07:23:29 PM
Increible M-DVD jajaja al leerlo me hice ilusiones con cierto proyecto... xD ya sabes k...
Pero bueno.. con un poco mas... estara :D

Title: Re: Last Topics of Person
Post by: kyle007 on December 02, 2008, 11:05:03 AM
That's great, thanks alot,that's what i'm looking for
Title: Re: Last Topics of Person
Post by: Nibogo on December 02, 2008, 08:46:54 PM
Works great M-DVD better than the Show Topics Mod , thanks men ;)
Title: Re: Last Topics of Person
Post by: M-DVD on December 02, 2008, 09:37:36 PM
Quote from: OldRockSongs on November 30, 2008, 06:28:40 PM
I just installed this mod. I luv it!

Quote from: kyle007 on December 02, 2008, 11:05:03 AM
That's great, thanks alot,that's what i'm looking for

Quote from: NIBOGO on December 02, 2008, 08:46:54 PM
Works great M-DVD better than the Show Topics Mod , thanks men ;)

Thank for yours comments.  :D

Quote from: M@nNiak on November 30, 2008, 06:17:29 PM
Excelente amigo, una opcion que es de mucha ayuda, Me funciona perfecto.   :D

Solo una pequeña sugerencia, nose si seria posible que en vez de solo marcar los "ultimos" temas del usuario mostrara todos los temas iniciados por X usuario como en Vbulletin, por que veo que en este al ir al profile del usuario y dar en "mostrar los ultimos temas.."  solo en la primer pagina salen los temas a partir de la 2 ya son como normalmente se muestran segun la fecha, yose k este Mod es para unicamente los "ultimos temas.." pero seria una excelente opcion poder tener "ver todos los temas iniciados por el usuario".

En fin... este Mod me funciono muy bien Muchas Gracias.  ;)

Te soy sincero si te digo que no entendí nada  O:)

¿Te refieres a que en lugar de que te muestre con paginación, quieres que te los muestre todos en una sola página?.

¿Hay un link donde pueda ver lo que sale y como lo quieres?

Gracias por la sugerencia  :)
Title: Re: Last Topics of Person
Post by: M@nNiak on December 04, 2008, 05:28:56 AM
Quote from: M-DVD on December 02, 2008, 09:37:36 PM


Te soy sincero si te digo que no entendí nada  O:)

¿Te refieres a que en lugar de que te muestre con paginación, quieres que te los muestre todos en una sola página?.

¿Hay un link donde pueda ver lo que sale y como lo quieres?

Gracias por la sugerencia  :)


je je si me enrede explikando, me referia a que estaria mejor que en vez de que solo sean solo "los ultimos temas creados del usuario" , seria muy bueno que fuera  "ver todos los temas iniciados por el usuario"

todos los que ha creado y no unicamente los ultimos como pasa con este MOD que repito es muy buen trabajo  ;)  , espero esta vez haberme explicado mejor.

Saludos
Title: Re: Last Topics of Person
Post by: M-DVD on December 04, 2008, 09:26:14 PM
Si se puede. Creo que en administración, tu puedes elegir el número de mensajes que te saldrán en esa lista.

El objetivo de la paginación es precisamente no mostrar todo, que eso implica mayor demanda de recursos. Imagínate que sean 100, 200, 500, 1000 temas.
Title: Re: Last Topics of Person
Post by: Relyana on December 28, 2008, 01:01:22 PM
Ahora bien, mi pregunta sería:  ¿Por que se escribe mucho en español aquí y no en Inglés 

Sorry for my Spanish  :P Why are you all replying in Spanish here ? I'm sure non-Spanish users would also love to understand what you have to say.  ;)

Romanian
Code Select
$txt['mod_show_member_topics'] = 'subiectele acestei persoane';
Title: Re: Last Topics of Person
Post by: M-DVD on December 29, 2008, 01:51:52 PM
Quote from: Relyana on December 28, 2008, 01:01:22 PM
Ahora bien, mi pregunta sería:  ¿Por que se escribe mucho en español aquí y no en Inglés 

Sorry for my Spanish  :P Why are you all replying in Spanish here ? I'm sure non-Spanish users would also love to understand what you have to say.  ;)

Sorry, I do not think it happening again.   :-[

Good Spanish.  :P


Quote from: Relyana on December 28, 2008, 01:01:22 PM
I'm sure non-Spanish users would also love to understand what you have to say.  ;)

Abstract: One user suggested that it was better if they list "all" topics (without pages).

I commented that this is not appropriate; imagine 100, 200, 1000 topics in list, it would be much RAM consumption.

Quote from: Relyana on December 28, 2008, 01:01:22 PM
Romanian
Code Select
$txt['mod_show_member_topics'] = 'subiectele acestei persoane';


Thanks, in a few hours update.

Thanks, uploaded language.  :)
Title: Re: Last Topics of Person
Post by: kyle007 on December 29, 2008, 06:59:50 PM
What's new in updated version ?
Title: Re: Last Topics of Person
Post by: M-DVD on December 29, 2008, 08:46:36 PM
Quote from: kyle007 on December 29, 2008, 06:59:50 PM
What's new in updated version ?

Hello.

Still no update version (the last version is v1.0).

I have uploaded a file with all the translations (Language_full.zip) :)
Title: Re: Last Topics of Person
Post by: kyle007 on December 30, 2008, 11:00:11 AM
Oh sorry :)

BTW i have a suggestion for your next update...

When browsing last topics of a person, it doesn't show only topics he started, it also shows all of the posts he replied in his topics, so this is a bit annoying...

Could you make it to show just the first post of his topic ? ( I wish i could explain properly :) )
Title: Re: Last Topics of Person
Post by: taha116 on December 30, 2008, 11:15:03 AM
Nice mod!
Title: Re: Last Topics of Person
Post by: M-DVD on January 02, 2009, 09:46:52 PM
Quote from: kyle007 on December 30, 2008, 11:00:11 AM
Oh sorry :)

BTW i have a suggestion for your next update...

When browsing last topics of a person, it doesn't show only topics he started, it also shows all of the posts he replied in his topics, so this is a bit annoying...

Could you make it to show just the first post of his topic ? ( I wish i could explain properly :) )

Oh, thanks. I escaped this detail.

Is already fixed, soon update, fix + improvements

Quote from: taha116 on December 30, 2008, 11:15:03 AM
Nice mod!

Thanks   :D
Title: Re: Last Topics of Person
Post by: M-DVD on January 04, 2009, 12:20:30 PM
Update Last Topics of Person v1.1:
=========================

New features:

How do I upgrade?

=======================================

Características Nuevas:

¿Como actualizar?
Title: Re: Last Topics of Person
Post by: kyle007 on January 04, 2009, 01:00:42 PM
@M-DVD, thanks for the update...Now it's totally flawless...
Title: Re: Last Topics of Person
Post by: M-DVD on January 09, 2009, 11:56:35 AM
Quote from: kyle007 on January 04, 2009, 01:00:42 PM
@M-DVD, thanks for the update...Now it's totally flawless...

Thank you for reporting the error. 8)
Title: Re: Last Topics of Person
Post by: erisa on January 10, 2009, 11:16:17 AM
Is it possible if you could add like Last activity of a person?

Example "Abc" updated his profile 5 minutes ago or play Donkey Kong in arcade?
Title: Re: Last Topics of Person
Post by: M-DVD on January 10, 2009, 11:18:36 AM
Quote from: erisa on January 10, 2009, 11:16:17 AM
Is it possible if you could add like Last activity of a person?

Example "Abc" updated his profile 5 minutes ago or play Donkey Kong in arcade?

   
There is already a mod that does that.  :)

Edit: Profile User Action (http://custom.simplemachines.org/mods/index.php?mod=540)
Title: Re: Last Topics of Person
Post by: erisa on January 11, 2009, 09:51:52 PM
The Profile User Action doesn't work for me. Anyway I actually just want a block for the last 5 user action to be put on my homepage. Its ok. Thanks anyway!
Title: Re: Last Topics of Person
Post by: SgtMic on March 03, 2009, 05:53:22 PM
Does not install into RC1 Public.

The errors are in profile.template.php.

Code Select
Find:
// Loop through every area, displaying its name as a header.

Code Select
Find:
<a href="', $scripturl, '?action=profile;u=', $context['id_member'], ';sa=showPosts">', $txt['show_latest'], ' ', $txt['posts_member'], '.</a><br /> 

Neither of these are found in the file. I do have mods installed so I also checked an unmodded file.
Same result.

Title: Re: Last Topics of Person
Post by: M-DVD on March 03, 2009, 09:23:21 PM
Quote from: SgtMic on March 03, 2009, 05:53:22 PM
Does not install into RC1 Public.

The errors are in profile.template.php.

Code Select
Find:
// Loop through every area, displaying its name as a header.

Code Select
Find:
<a href="', $scripturl, '?action=profile;u=', $context['id_member'], ';sa=showPosts">', $txt['show_latest'], ' ', $txt['posts_member'], '.</a><br /> 

Neither of these are found in the file. I do have mods installed so I also checked an unmodded file.
Same result.



Hi, this mod isn't necessary for SMF 2 RC1 :)
Title: Re: Last Topics of Person
Post by: SgtMic on March 04, 2009, 12:19:36 AM
I just liked this layout better than what's found in RC1. :)
Title: Re: Last Topics of Person
Post by: M-DVD on March 12, 2009, 08:22:56 PM
Quote from: SgtMic on March 04, 2009, 12:19:36 AM
I just liked this layout better than what's found in RC1. :)

Sorry for delay.

To do that, you need to change many files of SMF RC1 with the above version. It isn't something only in the MOD. ::)
Title: Re: Last Topics of Person
Post by: islam2hamy on April 04, 2009, 03:04:36 AM
Modifications.Arabic-utf8.php

Code Select

$txt['mod_show_member_topics'] = 'مواضيع هذا العضو';
$txt['showPosts;topics'] = 'إظهر المواضيع';
$txt['latest_topics'] = 'أخر المواضيع لـ:';


lease before put the translation in the file be sure that the file encode is UTF-8
Title: Re: Last Topics of Person
Post by: M-DVD on April 04, 2009, 03:50:38 PM
Thank for translate, have been uploaded
Title: Re: Last Topics of Person
Post by: LOVELORD on April 17, 2009, 07:35:15 PM
Sebian-latin
Serbian-cyrilic
Title: Re: Last Topics of Person
Post by: M-DVD on April 20, 2009, 12:44:21 AM
Quote from: LOVELORD on April 17, 2009, 07:35:15 PM
Sebian-latin
Serbian-cyrilic

I have uploaded your translantion. Thanks :D
Title: Re: Last Topics of Person
Post by: ZeUsSaN on May 03, 2009, 09:28:35 PM
Quote from: russian$txt['mod_show_member_topics']= 'темы этого пользователя';
$txt['showPosts;topics']= 'Показать Темы';
$txt['latest_topics']= 'Самые последние темы:';

Quote from: ukrainian$txt['mod_show_member_topics']= 'теми цього користувача';
$txt['showPosts;topics']= 'Показати Теми';
$txt['latest_topics']= 'Самі останні теми:';
Title: Re: Last Topics of Person
Post by: M-DVD on May 08, 2009, 08:21:24 PM
Quote from: ZeUsSaN on May 03, 2009, 09:28:35 PM
Quote from: russian$txt['mod_show_member_topics']= 'темы этого пользователя';
$txt['showPosts;topics']= 'Показать Темы';
$txt['latest_topics']= 'Самые последние темы:';

Quote from: ukrainian$txt['mod_show_member_topics']= 'теми цього користувача';
$txt['showPosts;topics']= 'Показати Теми';
$txt['latest_topics']= 'Самі останні теми:';

Thanks. I have uploaded your translations :D
Title: Re: Last Topics of Person
Post by: apo-freak on May 09, 2009, 02:22:11 PM
sorry..
QuoteSorry, but the modification could not be parsed.
warning for  1.1.8

and the german translations for utf-8  and  "normal":

Quote$txt['mod_show_member_topics'] = 'zeige die Themen des Benutzers';
$txt['showPosts;topics'] = 'Themen anzeigen';
$txt['latest_topics'] = 'die letzten Themen von:';
Title: Re: Last Topics of Person
Post by: M-DVD on May 09, 2009, 09:26:05 PM
Quote from: apo-freak on May 09, 2009, 02:22:11 PM
sorry..
QuoteSorry, but the modification could not be parsed.
warning for  1.1.8

I have install this mod in SMF 1.1.0 without problem.

Have you install the LastTopicsofPerson_v1_1.zip file or the languages_full.zip file?
(you should install the LastTopicsofPerson_v1_1.zip file.)
(the languages_full.zip should be unzip, and rezip this files in the LastTopicsofPerson_v1_1.zip)

Quote from: apo-freak on May 09, 2009, 02:22:11 PM
and the german translations for utf-8  and  "normal":

Quote$txt['mod_show_member_topics'] = 'zeige die Themen des Benutzers';
$txt['showPosts;topics'] = 'Themen anzeigen';
$txt['latest_topics'] = 'die letzten Themen von:';


Thanks for translate, have been uploaded :D
Title: Re: Last Topics of Person
Post by: onlychriss on May 12, 2009, 11:13:42 PM
Magnifico algo asi andaba buscando por estos dias y pues muchas gracias
Title: Re: Last Topics of Person
Post by: M-DVD on May 15, 2009, 07:53:01 PM
Quote from: onlychriss on May 12, 2009, 11:13:42 PM
Magnifico algo asi andaba buscando por estos dias y pues muchas gracias

Thanks for your comment :)
Title: Re: Last Topics of Person
Post by: 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!
Title: Re: Last Topics of Person
Post by: M-DVD on June 15, 2009, 11:30:57 PM
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.
Title: Re: Last Topics of Person
Post by: Col on March 17, 2010, 07:33:30 PM
Hi,

There is a conflict between this and the View Any Topic (http://custom.simplemachines.org/mods/index.php?mod=687) mod.

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

Code Select

   <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:

Code Select

   <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:

Code Select

    <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:

Code Select

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


?

Thanks.
Title: Re: Last Topics of Person
Post by: aw06 on March 24, 2010, 10:53:00 AM
Will this be updated to Rc3 ?
Title: Re: Last Topics of Person
Post by: 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??
Title: Re: Last Topics of Person
Post by: 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
Title: Re: Last Topics of Person
Post by: Nibogo on March 24, 2010, 06:10:38 PM
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
Title: Re: Last Topics of Person
Post by: 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 ..
Title: Re: Last Topics of Person
Post by: Nibogo on March 24, 2010, 06:27:02 PM
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
Title: Re: Last Topics of Person
Post by: Col on March 24, 2010, 10:06:58 PM
Quote from: Col on March 17, 2010, 07:33:30 PM
Hi,

There is a conflict between this and the View Any Topic (http://custom.simplemachines.org/mods/index.php?mod=687) mod.

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

Code Select

   <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:

Code Select

   <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:

Code Select

    <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:

Code Select

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


?

Thanks.

Any help with above code would be greatly appreciated.

Thanks.
Title: Re: Last Topics of Person
Post by: sharks on June 26, 2010, 02:12:08 PM
I just installed it on SMF 1.1.11 and it works! Thanks! :D
Title: Re: Last Topics of Person
Post by: Biology Forums on January 29, 2012, 04:02:25 PM
Is it also possible to show last topics with no replies?
Title: Re: Last Topics of Person
Post by: LuciferMorningstar on January 11, 2024, 07:32:04 PM
I need a mod like this for SMF 2.1.4  :'(
Title: Re: Last Topics of Person
Post by: 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.
Title: Re: Last Topics of Person
Post by: LuciferMorningstar on January 11, 2024, 08:39:17 PM
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.
Text only | Text with Images