phpBB.de

Code: Alles auswählen

Last Seen MOD by ZoZo
# 
#-----[ OPEN ]------------------------------------------ 
# 

 portal.php: 

# 
#-----[ FIND ]----------------------------------- 
# 

else 
{ 
   $l_total_user_s = $lang['Registered_users_total']; 
} 

# 
#-----[ AFTER ADD ]----------------------------------- 
# 
  
// 
// last seen hack 
// 
$sql = "SELECT username, user_id, user_lastvisit FROM phpbb_users WHERE user_id > 0 AND user_level <> 1 ORDER BY user_lastvisit DESC LIMIT 10"; 
if (!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not query last seen information', '', __LINE__, __FILE__, $sql); } 
$number_last_seen = $db->sql_numrows($result); 
$last_seen_row = array(); 
while ($row = $db->sql_fetchrow($result)) { $last_seen_row[] = $row; } 
for ($i = 0; $i < $number_last_seen; $i++) { 
  $template->assign_block_vars('last_seen_row', 
    array( 
      'U_LSEEN_LINK'     => append_sid("profile.$phpEx?mode=viewprofile&u=".$last_seen_row[$i]['user_id']), 
      'L_LSEEN_USERNAME' => $last_seen_row[$i]['username'], 
      'L_LSEEN_TIME'     => date("m.d.y H:i", $last_seen_row[$i]['user_lastvisit'])) 
  ); 
} 
  


// If you check the sql statement, you'll see we're picking the last 10 non-Admin users. adjust to suit your tastes.// 
// Enjoy! 

# 
#-----[ FIND ]----------------------------------- 
# 
  
// Poll Forum ID: separate by comma for multi-forums, eg. '3,8,14' 
$CFG['poll_forum'] = '1'; 

# 
#-----[ AFTER ADD ]----------------------------------- 
# 
  
$CFG['last_seen'] = '10'; 

# 
#-----[ FIND ]----------------------------------- 
# 
  
$template->set_filenames(array( 
   'body' => 'portal_body.tpl') 
); 

# 
#-----[ AFTER ADD ]----------------------------------- 
# 
  
// last seen hack 
$sql = "SELECT username, user_id, user_level, user_allow_viewonline, user_lastvisit FROM " . USERS_TABLE. " 
WHERE username <> 'Anonymous' 
ORDER BY user_lastvisit DESC LIMIT " . $CFG['last_seen']; 
if (!$result = $db->sql_query($sql)) 
{ 
message_die(GENERAL_ERROR, 'Could not query last seen information', '', __LINE__, __FILE__, $sql); 
} 

while ($row = $db->sql_fetchrow($result)) 
{ 
$style_color = ''; 
if ( $row['user_level'] == ADMIN ) 
{ 
$row['username'] = '<b>' . $row['username'] . '</b>'; 
$style_color = 'style="color:#' . $theme['fontcolor3'] . '"'; 
} 
else if ( $row['user_level'] == MOD ) 
{ 
$row['username'] = '<b>' . $row['username'] . '</b>'; 
$style_color = 'style="color:#' . $theme['fontcolor2'] . '"'; 
} 
if ( $row['user_allow_viewonline'] ) 
{ 
$user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'>' . $row['username'] . '</a>'; 
} 
else 
{ 
$user_online_link = '<a href="' . append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $row['user_id']) . '"' . $style_color .'><i>' . $row['username'] . '</i></a>'; 
} 
if ( $row['user_allow_viewonline'] || $userdata['user_level'] == ADMIN ) 
{ 
$template->assign_block_vars('last_seen_row', array( 
'L_LSEEN_USERNAME' => $user_online_link, 
'L_LSEEN_TIME' => create_date($board_config['default_dateformat'], $row['user_lastvisit'], $board_config['board_timezone'])) 
); 
} 
}  


# 
#-----[ FIND ]----------------------------------- 
# 
  
   'WELCOME_TEXT' => $CFG['welcome_text'], 


# 
#-----[ AFTER ADD ]----------------------------------- 
# 
  
   'L_LAST_SEEN' => $lang['Last_Seen'], 

# 
#-----[ OPEN ]------------------------------------------ 
# 
 portal_body.tpl: [All Template Folders] place block where needed. reference other block docs for details. 

  
        <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"> 
          <tr> 
           <td class="catHead" height="25" colspan="2"><span class="genmed"><b>Last Seen</b></span></td> 
          </tr> 
            <tr> 
              <td align="left" valign="top"> 
                <table width="100%" cellpadding="0" cellspacing="0"> 
                <!-- BEGIN last_seen_row --> 
                <tr> 
                 <td class="row1" align="left" valign="middle"><span class="gensmall">? <a href="{last_seen_row.U_LSEEN_LINK}">{last_seen_row.L_LSEEN_USERNAME}</a></span></td> 
                    <td class="row1" align="right" valign="middle"><span class="gensmall">{last_seen_row.L_LSEEN_TIME}&</span></td> 
                </tr> 
                <!-- END last_seen_row --> 
              </table> 
              </td> 
            </tr> 
        </table> 
          <br /> 

# 
#-----[ SAVE/UPLOAD ALL FILES ]------------------------------------------ 
# EoM

Code: Alles auswählen

else
{
	$l_total_post_s = $lang['Posted_articles_total'];
}

Code: Alles auswählen

$sql = "SELECT username, user_id, user_lastvisit FROM phpbb_users WHERE user_id > 0 AND user_level <> 1 ORDER BY user_lastvisit DESC LIMIT 10"; 
if (!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not query last seen information', '', __LINE__, __FILE__, $sql); } 
$number_last_seen = $db->sql_numrows($result); 
$last_seen_row = array(); 
while ($row = $db->sql_fetchrow($result)) { $last_seen_row[] = $row; } 
for ($i = 0; $i < $number_last_seen; $i++) { 
  $template->assign_block_vars('last_seen_row', 
    array( 
      'U_LSEEN_LINK'     => append_sid("profile.$phpEx?mode=viewprofile&u=".$last_seen_row[$i]['user_id']), 
      'L_LSEEN_USERNAME' => $last_seen_row[$i]['username'], 
      'L_LSEEN_TIME'     => date("m.d.y H:i", $last_seen_row[$i]['user_lastvisit'])) 
  ); 
}