[Beta] Last Topic a User posted in Profile MOD
Verfasst: 05.04.2006 21:35
Hallo,
hab auch mal einen Mod erstellt. Dieser fügt im Profil des Users einen Link zu letzten Thema ein, in welchem der User gepostet hat.
hab auch mal einen Mod erstellt. Dieser fügt im Profil des Users einen Link zu letzten Thema ein, in welchem der User gepostet hat.
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