Sürüm: 1.0.1 BETA
Yazar: ALEXIS ( Sevdin Filiz )
Açıklama: index sayfasında, son 24 saat içinde siteyi ziyaret eden kişilerin listesini verir.
Uyumlu olduğu phpBB3 sürümleri:
- phpBB 3.0.1
Özellikleri:
- son 24 saat içinde siteyi ziyaret eden üyeleri, giriş saatleri açık belirterek ve grup renkler ile renklendirerek gösterir
Yazar notları:
Şu an sadece MySQL ve SqLite üstünde test edilmiştir
0.3.1B yenilikleri:
SQL sorguları sqlite için özelleşti
Dil eklemeleri:
en/common.php içine 1 yeni değer eklenmektedir.
Lisans: GNU General Public License v2
Kurulum zorluğu: Kolay
Kurulum süresi: 3 dakika
Dosya formatı: .txt
Dosya indirme: (aşağıdaki kod görünümünden kopyalayıp bir dosyaya kaydediniz)
Ön izleme:
(yakında eklenecektir)
- Kod: Tümünü seç
##############################################################
## MOD Title: who visited last 24h
## MOD Author: angelside < n/a > (Sevdin Filiz) http://www.phpbbturkiye.net
## MOD Description: show who visited users today, showing how many users visited and visited dates.
## MOD Version: Beta: 1.0.1B
##
## Installation Level: Easy
## Installation Time: 3 minutes
##
## Files To Edit: 3
## -- includes/functions.php
## -- styles/prosilver/template/index_body.html
## -- language/en/common.php
##
## Included Files: n/a
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
##############################################################
## For security purposes, please check: http://www.phpbb.com/mods/
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://www.phpbb.com/mods/
##############################################################
## Author Notes:
##
##############################################################
## MOD History:
##
## 2007-08-05 - Version 1.0.1b
## add sql_layer for sqlite
##
## 2007-08-03 - Version 1.0.0b
## fully rewrite and clean code for RC4
##
## 2007-05-29 - Version 0.3.0
## Added multi language support
##
## 2007-05-08 - Version 0.2.0
## Added date format from board config default date format...
##
## MOD History:
## 2007-04-24 - Version 0.1.0
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################
#
#-----[ OPEN ]------------------------------------------
#
includes/functions.php
#
#-----[ FIND ]------------------------------------------
#
// Which timezone?
$tz = ($user->data['user_id'] != ANONYMOUS) ? strval(doubleval($user->data['user_timezone'])) : strval(doubleval($config['board_timezone']));
#
#-----[ AFTER ADD ]------------------------------------------
#
//--- [ + ] --- who viseted last 24h ------------------------------------------
// added
//
/* ALEXIS
listeye girmesi için bir üyenin oturum kapaması gerek :S
bunu session tablosundan takip edebilir miyiz ?
*/
$last_24 = strtotime('-1 day');
if ($db->sql_layer === 'sqlite')
{
$sql = 'SELECT COUNT(user_id) as total_visits
FROM (
SELECT DISTINCT user_id
FROM ' . USERS_TABLE . '
WHERE user_type <> ' . USER_IGNORE . '
AND user_lastvisit >=' . $last_24 .
')';
}
else
{
$sql = 'SELECT COUNT(DISTINCT user_id) as total_visits
FROM ' . USERS_TABLE . '
WHERE user_type <> ' . USER_IGNORE . '
AND user_lastvisit >=' . $last_24;
}
$result = $db->sql_query($sql);
$total_visits = (int) $db->sql_fetchfield('total_visits');
$db->sql_freeresult($result);
$template->assign_vars(array(
'S_DISPLAY_LAST24H_USERLIST' => ($total_visits) ? true : false, // if not have any visits hide complete block
'LAST24H_WISITED_USER_COUNT' => $total_visits,
'WHO_WISITED_TODAY' => $user->lang['WHO_WISITED_TODAY'],
));
if ($total_visits)
{
$sql = 'SELECT user_id, username, user_type, user_colour, user_lastvisit
FROM ' . USERS_TABLE . '
WHERE user_type <> ' . USER_IGNORE .'
AND user_lastvisit >=' . $last_24 . '
ORDER BY user_colour DESC';
$result = $db->sql_query($sql);
$last24h_userlist = '';
while ( $row = $db->sql_fetchrow($result) )
{
// + get user info
$username = $row['username'];
$user_id = (int) $row['user_id'];
$colour = $row['user_colour'];
$last24h_user = get_username_string('username', $user_id, $username, $colour);
$last24h_color = get_username_string('colour', $user_id, $username, $colour);
$last24h_profile = get_username_string('profile', $user_id, $username, $colour);
// + get user info
$last_visit = $user->format_date($row['user_lastvisit']);
$last24h_link = "<a href=\"$last24h_profile\"><span style=\"color:$last24h_color;\"><strong>$last24h_user</strong></span></a> ($last_visit)";
$last24h_userlist = ($last24h_userlist) ? ', ' . $last24h_link : $last24h_link;
$template->assign_block_vars('last24h', array(
'LAST24H_USERLIST' => $last24h_userlist,
));
}
$db->sql_freeresult($result);
}
//
//--- [ - ] --- who viseted last 24h ------------------------------------------
#
#-----[ OPEN ]------------------------------------------
#
styles/prosilver/template/index_body.html
#
#-----[ FIND ]------------------------------------------
#
<!-- IF S_DISPLAY_ONLINE_LIST -->
#
#-----[ BEFORE, ADD ]------------------------------------------
#
<!-- IF S_DISPLAY_LAST24H_USERLIST -->
<h3>{WHO_WISITED_TODAY} : {LAST24H_WISITED_USER_COUNT}</h3>
<!-- BEGIN last24h -->{last24h.LAST24H_USERLIST}<!-- END last24h -->
<!-- ENDIF -->
#
#-----[ OPEN ]------------------------------------------
#
language/en/common.php
#
#-----[ FIND ]------------------------------------------
# page end
));
?>
#
#-----[ BEFORE, ADD ]------------------------------------------
#
'WHO_WISITED_TODAY' => 'Who wisited last 24h',
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM