Datum Laatste Post

[Nas]

Bestaat/is er soms een mod die de datum van de laatst geplaatste post bijhoud in het profiel en eventueel weergeeft ook in de memberlist/gebruikerslijst ?

mvg,
nas

[marrucc]

Zoek eens op http://www.phpbbhacks.com geloof dat er wel een is.

[Nas]

ik heb deze wat bewerkt :
http://www.phpbbhacks.com/download/1811

en heb nu :

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_viewprofile.php

#
#-----[ FIND ]------------------------------------------ 
#
$posts_per_day = $profiledata['user_posts'] / $memberdays;

#
#-----[ AFTER, ADD ]------------------------------------------ 
#

//
// MOD: Add Last User POSTED Date to User Profiles
//	
$post_time_sql = "SELECT post_time
        FROM " . POSTS_TABLE . "
	WHERE poster_id = " . $user_id . "
	ORDER BY post_time DESC
	LIMIT 1";

	if ( !($post_time_result = $db->sql_query($post_time_sql)) )
	{
	  message_die(GENERAL_ERROR, 'Error getting user last post time', '', __LINE__, __FILE__, $post_time_sql);
	}

	$post_time_row = $db->sql_fetchrow($post_time_result);
	$last_post_time = ( isset($post_time_row['post_time']) ) ? create_date($board_config['default_dateformat'], $post_time_row['post_time'], $board_config['board_timezone']) : $lang['None'];
//
// MOD: -END-
//

#
#-----[ FIND ]------------------------------------------
#
	'L_AVATAR' => $lang['Avatar'], 

#
#-----[ AFTER, ADD ]------------------------------------------
#

//
// MOD: Add Last User POSTED Date to User Profiles
//
	'L_LAST_POSTED' => $lang['Last_Posted'],
//
// MOD: -END-
//

#
#-----[ FIND ]------------------------------------------
#
	'YIM' => $yim,

#
#-----[ AFTER, ADD ]------------------------------------------
#

//
// MOD: Add Last User POSTED Date to User Profiles
//
	'LAST_POSTED_TIME' => $last_post_time,
//
// MOD: -END-
//

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]------------------------------------------
#
		<tr> 
		  <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_INTERESTS}:</span></td>
		  <td> <b><span class="gen">{INTERESTS}</span></b></td>
		</tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
		<tr>
		  <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_LAST_VISITED}:</span></td>
		  <td> <b><span class="gen">{LAST_VISIT_TIME}</span></b></td>
		</tr>

# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------ 
#
//
// That's all, Folks!
// -------------------------------------------------

#
#-----[ BEFORE, ADD ]------------------------------------------
#

//
// MOD: Add Last User POSTED Date to User Profiles
//
$lang['Last_Posted'] = 'Last Posted';
$lang['Never'] = 'Never';
//
// MOD: -END-
//

# 
#-----[ OPEN ]------------------------------------------ 
# 
language/lang_dutch/lang_main.php

#
#-----[ FIND ]------------------------------------------ 
#
//
// That's all, Folks!
// -------------------------------------------------

#
#-----[ BEFORE, ADD ]------------------------------------------
#

//
// MOD: Add Last User POSTED Date to User Profiles
//
$lang['Last_Posted'] = 'Laatst Gepost';
$lang['Never'] = 'Nooit';
//
// MOD: -END-
//

Maar hij geeft een fout weer

Error getting user last post time

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY post_time DESC LIMIT 1' at line 4

SELECT post_time FROM phpbb_posts WHERE poster_id = ORDER BY post_time DESC LIMIT 1

Line : 84
File : .../includes/usercp_viewprofile.php

weet iemand waarom

Code: Selecteer alles

$post_time_sql = "SELECT post_time
        FROM " . POSTS_TABLE . "
	WHERE poster_id = " . $user_id . "
	ORDER BY post_time DESC
	LIMIT 1";

	if ( !($post_time_result = $db->sql_query($post_time_sql)) )
	{
	  message_die(GENERAL_ERROR, 'Error getting user last post time', '', __LINE__, __FILE__, $post_time_sql);
	}

	$post_time_row = $db->sql_fetchrow($post_time_result);
	$last_post_time = ( isset($post_time_row['post_time']) ) ? create_date($board_config['default_dateformat'], $post_time_row['post_time'], $board_config['board_timezone']) : $lang['None'];

niet werkt ??

[Bee]

Dit zit dieper, je zal moeten uitzoeken waarom $user_id geen waarde krijgt, want dat is de fout hier...

[Nas]

Dit zit dieper, je zal moeten uitzoeken waarom $user_id geen waarde krijgt, want dat is de fout hier...

Je hebt gelijk ik had $user_id = $profiledata['userid'] getypt ,wat natuurlijk $profiledata['user_id'] moet zijn , onoplettendheid zeker

THX trouwens :thumb:

[Sir White NL]

Ik krijg die foutmelding ook, maar die oplossing van je die snap ik niet ?
Userid kom ik niet tegen ??

[Luuk]

Je moet userid vervangen met user_id.

[Cheeta]

daar weet luuk alles van he *wordt er zelf nog steeds niet goed van

http://www.phpbbhacks.com/download/2006

[Sir White NL]

Je moet userid vervangen met user_id.

hahahah nee dat snapte ik nog net, maar waar staat die dan, want ik kon hem niet vinden ?

[Luuk]

Ik weet niet in welk bestand je fout zit, maar doorzoek het hele bestand maar eens