Aber dennoch frage ich hier nach intensiver Boardsuche ...

Ich suche einen MOD, der es mir ermöglicht, bei jedem User in der Profilansicht anzeigen zu lassen, in welchem Topic/Thema er zuletzt geschrieben hat.

Slytherin
Code: Alles auswählen
##############################################################
## MOD Title: Last Topic a User posted in Profile MOD
## MOD Author: Karstenkurt < webmaster@urlabgenial.de > (Sven COnrad) http://www.UrlaubGenial.de
## MOD Description: Diese Mod fügt im Profile den Titel des letzten Beitrag in den der User gepostet hat hinzu
## MOD Version: 1.0.1
##
## Installation Level: Easy
## Installation Time: 2 Minutes
##
## Files To Edit: (3)
## includes/usercp_viewprofile.php
## templates/subsilver/profile_view_body.tpl
## language/lang_german/lang_main.php
##
## Included Files: (0)
##
##############################################################
## For security purposes, please check: http://www.hvmdesign.com/mods.php
## for the latest version of this MOD. If this MOD is out of date,
## then it may have security risks fixed in newer versions.
##############################################################
## Author Notes:
##
##############################################################
## MOD History:
##
## 2006-04-03 - Version 1.0.0
## 2006-04-05 - Version 1.0.1
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_viewprofile.php
#
#-----[ FIND ]---------------------------------------------
#
$template->assign_vars(array(
'USERNAME' => $profiledata['username'],
#
#-----[ BEFORE, ADD ]--------------------------------------
#
//Begin Last Post in Profile
$sql = 'SELECT p.post_id, p.topic_id, t.topic_title FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t
WHERE p.topic_id = t.topic_id AND p.poster_id=' . $profiledata['user_id'] . ' ORDER BY p.post_time DESC LIMIT 0,1';
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not obtain users post information.", '', __LINE__, __FILE__, $sql);
}
while ( $row = $db->sql_fetchrow($result) )
{
$currentpost = $row['topic_title'];
$currentpostid=$row['post_id'];
$currenttopicid=$row['topic_id'];
}
$db->sql_freeresult($result);
//Ende Last Post in Profile
#
#-----[ FIND ]---------------------------------------------
#
'WWW_IMG' => $www_img,
#
#-----[ AFTER, ADD ]--------------------------------------
#
'CURRENTPOST' => $currentpost,
'CURRENTPOSTLINK' => append_sid("viewtopic.$phpEx?t=$currenttopicid#$currentpostid"),
'CURRENTPOSTDESC' => $lang['SC_Post_in_Profile'],
#
#-----[ OPEN ]------------------------------------------
#
templates/subsilver/profile_view_body.tpl
#
#-----[ FIND ]---------------------------------------------
#
<tr>
<td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_TOTAL_POSTS}: </span></td>
<td valign="top"><b><span class="gen">{POSTS}</span></b><br /><span class="genmed">[{POST_PERCENT_STATS} / {POST_DAY_STATS}]</span> <br /><span class="genmed"><a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a></span></td>
</tr>
#
#-----[ AFTER, ADD ]--------------------------------------
#!-- Start add - Last Post -->
<tr>
<td valign="top" align="right" nowrap="nowrap"><span class="gen">{CURRENTPOSTDESC}:</span></td>
<td> <b><span class="gen"><a href={CURRENTPOSTLINK}>{CURRENTPOST}</a></span></b></td>
</tr>
<!-- End add - Last Post -->
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php
#
#-----[ FIND ]---------------------------------------------
#
?>
#
#-----[ BEFORE, ADD ]--------------------------------------
#
//Last Post in Profile
$lang['SC_Post_in_Profile'] = 'Letzter Beitrag';
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Code: Alles auswählen
<!-- Start add - Last Post -->
<tr>
<td valign="middle" align="right"><span class="gen">Letzter Beitrag:</span></td>
<td width="100%"><span class="genmed"><a title="Letzte Aktivität im Forum" href="viewtopic.php?t=1#1"></a></span></td>
</tr>
<!-- End add - Last Post -->