phpBB.de

Code: Alles auswählen

Newest User Registration Date

UNIX Time:
Time Format: 01.01.1970, 01:00:00

Code: Alles auswählen

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

#
#-----[ FIND ]------------------------------------------------
#
		case 'newestuser':
			$sql = "SELECT user_id, username

# 
#-----[ REPLACE WITH ]------------------------------------------ 
#
		case 'newestuser':
			$sql = "SELECT user_id, username, user_regdate

#
#-----[ SAVE/CLOSE FILE ]--------------------------------
#
# EoM

Code: Alles auswählen

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

# 
#-----[ FIND ]------------------------------------------------ 
# 
define('CACHE_WORDS', true);
define('CACHE_THEMES', true);
define('CACHE_SMILIES', true);
define('CACHE_RANKS', true);
define('CACHE_BIRTHDAY', true);
define('CACHE_TREE', true);

# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
/*
define('CACHE_WORDS', true);
define('CACHE_THEMES', true);
define('CACHE_SMILIES', true);
define('CACHE_RANKS', true);
define('CACHE_BIRTHDAY', true);
define('CACHE_TREE', true);
*/

# 
#-----[ SAVE/CLOSE FILE ]-------------------------------- 
# 
# EoM

Code: Alles auswählen

//-- mod : cache -----------------------------------------------------------------------------------
//-- add
	global $board_config;

	// first inits
	if ( !isset($board_config['max_users']) || !isset($board_config['record_last_user_id']) || !isset($board_config['record_last_username']) )
	{
		users_stats();
		cache_birthday();
	}
	if ( !isset($board_config['max_posts']) || !isset($board_config['max_topics']) )
	{
		board_stats();
	}
	switch ( $mode )
	{
		case 'usercount':
			return intval($board_config['max_users']);
			break;
		case 'newestuser':
			$row = array( 'user_id' => intval($board_config['record_last_user_id']), 'username' => $board_config['record_last_username']);
			return $row;
			break;
		case 'postcount':
			return intval($board_config['max_posts']);
			break;
		case 'topiccount':
			return intval($board_config['max_topics']);
			break;
	}
//-- fin mod : cache -------------------------------------------------------------------------------

Code: Alles auswählen

     users_stats(); 

Code: Alles auswählen

$cache_bday_file = $phpbb_root_path . "cache/bday/bday_" . $board_config['board_timezone'] . ".php"; 
if (@file_exists($cache_bday_file)) 
{
	$sql = "SELECT user_regdate
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
		ORDER BY user_id DESC
		LIMIT 1";
	$result = $db->sql_query($sql);
	while ($row = mysql_fetch_array($result))
	{
		$newest_regdate = $row['user_regdate'];
	}

	$last_update_time = @filemtime($cache_bday_file); 
	$valid = (((date('Yz',time()) - date('Yz',$last_update_time))<1) && ((time() - $newest_regdate) > (time() - $last_update_time) )) ? true : false;  
} 
else 
{ 
   $valid = false; 
} 

Code: Alles auswählen

(((date('YzH',time()) - date('YzH',$last_update_time))<1)

Code: Alles auswählen

(((date('Ymd',time()) - date('Ymd',$last_update_time)) == 0)

Code: Alles auswählen

(((date('Yz',time()) - date('Yz',$last_update_time)) == 0)

Code: Alles auswählen

$cache_bday_file = $phpbb_root_path . "cache/bday/bday_" . $board_config['board_timezone'] . ".php";
if (@file_exists($cache_bday_file))
{
	$sql = "SELECT user_regdate
		FROM " . USERS_TABLE . "
		WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
		ORDER BY user_id DESC
    LIMIT 0,1";
	$result = $db->sql_query($sql);
	while ($row = mysql_fetch_array($result))
	{
		$newest_regdate = $row['user_regdate'];
	}
	$db->sql_freeresult($result);

	$last_update_time = @filemtime($cache_bday_file);
	$valid = (((date('Yz',time()) - date('Yz',$last_update_time)) == 0) && ((time() - $newest_regdate) > (time() - $last_update_time) )) ? true : false;
}
else
{
   $valid = false;
}