Time Logged-In แสดงรายละเอียดการเข้าสู่ระบบในข้อมูลส่วนตัว

ชื่อ: Time Logged-In
ผู้เขียน: Bulakbol
นำเสนอโดย: DexMoreGroup
ประเภท: Profile
รองรับ: SMF 1.1.xx, 2.0.xx
ปรับปรุงล่าสุด: 19 กุมภาพันธ์ 2552
ต้นฉบับ: Time Logged-In

รายละเอียด
เพิ่มรายละเอียดการเข้าสู่ระบบของสมาชิก โดยสามารถจัดการอนุญาตให้ดูได้เฉพาะกลุ่มสมาชิก ดูรายละเอียดเพิ่มเติมในรูปตัวอย่างครับ

ตัวอย่าง

สำหรับ SMF 1.1.xx

แก้ไขไฟล์:

file $sourcedir/LogInOut.php

ค้นหา -->>

โค๊ด: [Select]

updateMemberData($ID_MEMBER, array('lastLogin' => time(), 'memberIP' => '\'' . $user_info['ip'] . '\'', 'memberIP2' => '\'' . $_SERVER['BAN_CHECK_IP'] . '\''));

แก้เป็น -->>

โค๊ด: [Select]

updateMemberData($ID_MEMBER, array('lastLogin' => time(), 'memberIP' => '\'' . $user_info['ip'] . '\'', 'memberIP2' => '\'' . $_SERVER['BAN_CHECK_IP'] . '\'', 'firstLogin' => time()));

file $sourcedir/Load.php

ค้นหา -->>

โค๊ด: [Select]

mem.birthdate, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.posts, mem.lastLogin, mem.karmaGood,

แก้เป็น -->>

โค๊ด: [Select]

mem.birthdate, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.posts, mem.lastLogin, mem.karmaGood, mem.firstLogin,

file $sourcedir/ManagePermissions.php

ค้นหา -->>

โค๊ด: [Select]

['profile_remote_avatar' => false,

แก้เป็น -->>

โค๊ด: [Select]

'profile_remote_avatar' => false,
'profile_logged_in' => false,

ค้นหา -->>

โค๊ด: [Select]

'profile_remote_avatar',
'poll_vote',

แก้เป็น -->>

โค๊ด: [Select]

'profile_remote_avatar',
'profile_logged_in',
'poll_vote',

file $sourcedir/Profile.php

ค้นหา -->>

โค๊ด: [Select]

mysql_free_result($request);
}
}

แก้เป็น -->>

โค๊ด: [Select]

mysql_free_result($request);
}

// TimeLoggedIn mod by Bulakbol
if (allowedTo('profile_logged_in'))
{
// Read all theme names
$theme_request = db_query("
SELECT ID_THEME, variable, value
FROM {$db_prefix}themes
WHERE (variable IN ('name'))
AND ID_MEMBER = 0", __FILE__, __LINE__);

$context['theme_names'] = array();
while ($row = mysql_fetch_assoc($theme_request))
$context['theme_names'][$row['ID_THEME']][$row['variable']] = $row['value'];

mysql_free_result($theme_request);

If ((isset($user_profile[$memID]['spy']) && $user_profile[$memID]['spy'] == 1 && $context['user']['id'] != 1) || $user_profile[$memID]['firstLogin'] == 0)
{
$member['post_count'] = 0;
$dayb4['post_count'] = 0;
$context['first_login'] = $txt['tli_not_available'];
$context['online_for'] = $txt['tli_not_available'];
}
else
{
// a day before login date
$day_before = @getdate($user_profile[$memID]['lastLogin'] - (24*60*60));
$midnight_before = mktime(0, 0, 0, $day_before['mon'], $day_before['mday'], $day_before['year']) - ($modSettings['time_offset'] * 3600);
// last active date
$last_login_date = @getdate($user_profile[$memID]['lastLogin']);
$midnight_last_login = mktime(0, 0, 0, $last_login_date['mon'], $last_login_date['mday'], $last_login_date['year']) - ($modSettings['time_offset'] * 3600);
// today's date
$today = @getdate(time());
$midnight = mktime(0, 0, 0, $today['mon'], $today['mday'], $today['year']) - ($modSettings['time_offset'] * 3600);

if ($midnight_last_login != $midnight)
{
// following day after last active - search only 24 hours messages since last active
$after_last_active = @getdate($user_profile[$memID]['lastLogin'] + (24*60*60));
$midnight_after = mktime(0, 0, 0, $after_last_active['mon'], $after_last_active['mday'], $after_last_active['year']) - ($modSettings['time_offset'] * 3600);

$post_request = db_query("
SELECT COUNT(*) as post_count
FROM {$db_prefix}messages AS m
WHERE m.ID_MEMBER = " . $memID . " && m.posterTime > " . $midnight_last_login . "
AND m.ID_MEMBER = " . $memID . " && m.posterTime < " . $midnight_after . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND m.ID_BOARD != $modSettings[recycle_board]" : '') . "
LIMIT 1", __FILE__, __LINE__
);
$member = mysql_fetch_assoc($post_request);
mysql_free_result($post_request);
}
else
{
// last active today
$post_request = db_query("
SELECT COUNT(*) as post_count
FROM {$db_prefix}messages AS m
WHERE m.ID_MEMBER = " . $memID . " && m.posterTime > " . $midnight_last_login . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND m.ID_BOARD != $modSettings[recycle_board]" : '') . "
LIMIT 1", __FILE__, __LINE__
);
$member = mysql_fetch_assoc($post_request);
mysql_free_result($post_request);
}
// a day before last active day
$dayb4_request = db_query("
SELECT COUNT(*) as post_count
FROM {$db_prefix}messages AS m
WHERE m.ID_MEMBER = " . $memID . " && m.posterTime > " . $midnight_before . "
AND m.ID_MEMBER = " . $memID . " && m.posterTime < " . $midnight_last_login . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? "
AND m.ID_BOARD != $modSettings[recycle_board]" : '') . "
LIMIT 1", __FILE__, __LINE__
);
$dayb4 = mysql_fetch_assoc($dayb4_request);
mysql_free_result($dayb4_request);

$context['first_login'] = timeformat($user_profile[$memID]['firstLogin']);
$context['online_for'] = days_hours_minutes(($user_profile[$memID]['lastLogin'] - $user_profile[$memID]['firstLogin']) / 86400);
}
$context['posts_before'] = $dayb4['post_count'] . ($dayb4['post_count'] == 1 ? $txt['tli_post'] : $txt['tli_posts']);
$context['posts_made'] = $member['post_count'] . ($member['post_count'] == 1 ? $txt['tli_post'] : $txt['tli_posts']);
$context['total_logged_in'] = $user_profile[$memID]['totalTimeLoggedIn'] != 0 ? days_hours_minutes($user_profile[$memID]['totalTimeLoggedIn'] / 86400) : $txt['tli_not_available'];
$context['theme_name'] = $context['theme_names'][$user_profile[$memID]['ID_THEME'] == 0 ? $modSettings['theme_guests'] : $user_profile[$memID]['ID_THEME']]['name'];
}
}

function days_hours_minutes($total)
{
global $txt;

$hours = floor(($total - floor($total)) * 24);
$minutes = floor(((($total - floor($total)) * 24) - $hours) * 60);
$logged = (floor($total) == 0 ? '' : (floor($total) . (floor($total) == 1 ? $txt['tli_day'] : $txt['tli_days']))) .
($hours == 0 ? '' : ($hours) . ($hours == 1 ? $txt['tli_hour'] : $txt['tli_hours'])) .
$minutes . ($minutes == 1 ? $txt['tli_minute'] : $txt['tli_minutes']);

return $logged;
}

file $themedir/Profile.template.php

ค้นหา -->>

โค๊ด: [Select]

[echo '
<tr>
<td>', $txt[86], ': </td>
<td>', $context['member']['posts'], ' (', $context['member']['posts_per_day'], ' ', $txt['posts_per_day'], ')</td>
</tr><tr>]]></search>
<add><![CDATA[if (!allowedTo('profile_logged_in'))
echo ' <tr>
<td>', $txt[86], ': </td>
<td>', $context['member']['posts'], ' (', $context['member']['posts_per_day'], ' ', $txt['posts_per_day'], ')</td>
</tr>';
echo ' <tr>

แก้เป็น -->>

โค๊ด: [Select]

<td>', $context['member']['registered'], '</td>
</tr><tr>
<td>', $txt['lastLoggedIn'], ': </td>]]></search>
<add><![CDATA[<td>', $context['member']['registered'], '</td>
</tr>';

if (!allowedTo('profile_logged_in'))
echo ' <tr>
<td>', $txt['lastLoggedIn'], ': </td>]]></add>
</operation>
<operation>
<search position="replace"><![CDATA[// Is this member requiring activation and/or banned?]]></search>
<add><![CDATA[if (allowedTo('profile_logged_in'))
echo '
<tr>
<td colspan="2"><hr size="1" width="100%" class="hrcolor" /></td>
</tr><tr>
<td>', $txt['tli_logged_in'], ': </td>
<td>', $context['first_login'], '</td>
</tr><tr>
<td>', $txt['lastLoggedIn'], ': </td>
<td>', $context['member']['last_login'], '</td>
</tr><tr>
<td>', $txt['tli_online_for'], ': </td>
<td>', $context['online_for'], '</td>
</tr><tr>
<td>', $txt['tli_posts_made'], ':</td>
<td>', $context['posts_made'], '</td>
</tr><tr>
<td>', $txt['tli_posts_before'], ':</td>
<td>', $context['posts_before'], '</td>
</tr><tr>
<td>', $txt['tli_total_posts'], ': </td>
<td>', $context['member']['posts'], ' (', $context['member']['posts_per_day'], ' ', $txt['posts_per_day'], ')</td>
</tr><tr>
<td>', $txt['tli_total_logged_in'], ':</td>
<td>', $context['total_logged_in'], '</td>
</tr><tr>
<td>', $txt['tli_theme'], ':</td>
<td>', $context['theme_name'], '</td>
</tr>';

// Is this member requiring activation and/or banned?

file $languagedir/Modifications.thai-utf8.php

เพิ่ม -->>
ขออภัย! ท่านไม่สามารถเข้าถึงข้อมูลส่วนนี้ได้ กรุณาอ่าน เงื่อนไขการใช้งาน DexMore.Com

file $languagedir/ManagePermissions.thai-utf8.php

เพิ่ม -->>
ขออภัย! ท่านไม่สามารถเข้าถึงข้อมูลส่วนนี้ได้ กรุณาอ่าน เงื่อนไขการใช้งาน DexMore.Com

สร้างไฟล์: tlidb11x.php เพื่อสร้างฐานข้อมูล ไว้ใน $boarddir (ที่เดียวกับไฟล์ SSI.php) รัน http://www.your_url.xxx/$boarddir/tlidb11x.php -->> Enter เสร็จแล้วลบทิ้ง

โค๊ด: [Select]

<?php
{
if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
require_once(dirname(__FILE__) . '/SSI.php');
elseif (!defined('SMF'))
die('Error: Cannot install - please verify you put this in the same place as SMF\'s index.php.');

global $db_prefix;

$request = db_query("
SHOW COLUMNS FROM {$db_prefix}members
LIKE 'firstLogin'", __FILE__, __LINE__);
$no_upgrade = mysql_num_rows($request) > 0;
mysql_free_result($request);

if (!$no_upgrade)
db_query("
ALTER TABLE {$db_prefix}members
ADD COLUMN firstLogin int(10) NOT NULL default 0
", __FILE__, __LINE__);

if(SMF == 'SSI')
echo 'Database updates complete!';

}
?>

การตั้งค่า: ผู้ดูแล -->> แก้ไขการอนุญาต -->> กลุ่มสมาชิก [ขั้นสูง]

ลิงค์หัวข้อ: http://dexmore.com/topic/2404

สำหรับ SMF 2.0.xx

แก้ไขไฟล์:

file $sourcedir/LogInOut.php

ค้นหา -->>

โค๊ด: [Select]

updateMemberData($user_info['id'], array('last_login' => time(), 'member_ip' => $user_info['ip'], 'member_ip2' => $_SERVER['BAN_CHECK_IP']));

แก้เป็น -->>

โค๊ด: [Select]

updateMemberData($user_info['id'], array('last_login' => time(), 'member_ip' => $user_info['ip'], 'member_ip2' => $_SERVER['BAN_CHECK_IP'], 'first_login' => time()));

file $sourcedir/Load.php

ค้นหา -->>

โค๊ด: [Select]

mem.karma_bad, mem.member_ip, mem.member_ip2, mem.lngfile, mem.id_group, mem.id_theme, mem.buddy_list,

แก้เป็น -->>

โค๊ด: [Select]

mem.karma_bad, mem.member_ip, mem.member_ip2, mem.lngfile, mem.id_group, mem.id_theme, mem.buddy_list, mem.first_login,

file $sourcedir/ManagePermissions.php

ค้นหา -->>

โค๊ด: [Select]

'profile_remote_avatar',
'mark_any_notify',

แก้เป็น -->>

โค๊ด: [Select]

'profile_remote_avatar',
'profile_logged_in',
'mark_any_notify',

ค้นหา -->>

โค๊ด: [Select]

'profile_remote_avatar' => array(false, 'profile', 'use_avatar'),

แก้เป็น -->>

โค๊ด: [Select]

['profile_remote_avatar' => array(false, 'profile', 'use_avatar'),
'profile_logged_in' => array(false, 'profile', 'view_basic_info'),

file $sourcedir/Profile-View.php

ค้นหา -->>

โค๊ด: [Select]

loadCustomFields($memID);
}

แก้เป็น -->>

โค๊ด: [Select]

loadCustomFields($memID);

// TimeLoggedIn by Bulakbol
if (allowedTo('profile_logged_in'))
{
// Read all theme names
$theme_request = $smcFunc['db_query']('', '
SELECT id_theme, variable, value
FROM {db_prefix}themes
WHERE (variable IN ({string:name}))
AND id_member = {int:guest}',
array(
'guest' => 0,
'name' => 'name'
)
);
$context['theme_names'] = array();
while ($row = $smcFunc['db_fetch_assoc']($theme_request))
$context['theme_names'][$row['id_theme']][$row['variable']] = $row['value'];

$smcFunc['db_free_result']($theme_request);

If ((!empty($user_profile[$memID]['spy']) && $context['user']['id'] != 1) || empty($user_profile[$memID]['first_login']))
{
$member['post_count'] = 0;
$dayb4['post_count'] = 0;
$context['first_login'] = $txt['tli_not_available'];
$context['online_for'] = $txt['tli_not_available'];
}
else
{
// last active date
$last_login_date = @getdate($user_profile[$memID]['last_login']);
$midnight_last_login = mktime(0, 0, 0, $last_login_date['mon'], $last_login_date['mday'], $last_login_date['year']) - ($modSettings['time_offset'] * 3600);
// today's date
$today = @getdate(time());
$midnight = mktime(0, 0, 0, $today['mon'], $today['mday'], $today['year']) - ($modSettings['time_offset'] * 3600);

if ($midnight_last_login != $midnight)
{
// not active today so, for faster search, search 24 hours old messages only
$after_last_active = @getdate($user_profile[$memID]['last_login'] + (24*60*60));

$post_request = $smcFunc['db_query']('', '
SELECT COUNT(*) as post_count
FROM {db_prefix}messages AS m
WHERE (m.id_member = {int:current_member} && m.poster_time > {int:midnight_last_login}
AND m.id_member = {int:current_member} && m.poster_time < {int:midnight_after})' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
AND id_board != {int:recycle_board}' : '') . '
LIMIT 1',
array(
'current_member' => $memID,
'recycle_board' => $modSettings['recycle_board'],
'midnight_last_login' => $midnight_last_login,
'midnight_after' => mktime(0, 0, 0, $after_last_active['mon'], $after_last_active['mday'], $after_last_active['year']) - ($modSettings['time_offset'] * 3600),
)
);
$member = $smcFunc['db_fetch_assoc']($post_request);
$smcFunc['db_free_result']($post_request);
}
else
{
// last active today
$post_request = $smcFunc['db_query']('', '
SELECT COUNT(*) as post_count
FROM {db_prefix}messages AS m
WHERE (m.id_member = {int:current_member} && m.poster_time > {int:midnight_last_login})' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
AND id_board != {int:recycle_board}' : '') . '
LIMIT 1',
array(
'current_member' => $memID,
'recycle_board' => $modSettings['recycle_board'],
'midnight_last_login' => $midnight_last_login,
)
);
$member = $smcFunc['db_fetch_assoc']($post_request);
$smcFunc['db_free_result']($post_request);
}
// a day before last active
$day_before = @getdate($user_profile[$memID]['last_login'] - (24*60*60));
$dayb4_request = $smcFunc['db_query']('', '
SELECT COUNT(*) as post_count
FROM {db_prefix}messages AS m
WHERE (m.id_member = {int:current_member} && m.poster_time > {int:midnight_before}
AND m.id_member = {int:current_member} && m.poster_time < {int:midnight_last_login})' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
AND id_board != {int:recycle_board}' : '') . '
LIMIT 1',
array(
'current_member' => $memID,
'recycle_board' => $modSettings['recycle_board'],
'midnight_last_login' => $midnight_last_login,
'midnight_before' => $midnight_before = mktime(0, 0, 0, $day_before['mon'], $day_before['mday'], $day_before['year']) - ($modSettings['time_offset'] * 3600),
)
);
$dayb4 = $smcFunc['db_fetch_assoc']($dayb4_request);
$smcFunc['db_free_result']($dayb4_request);

$context['first_login'] = timeformat($user_profile[$memID]['first_login']);
$context['online_for'] = days_hours_minutes(($user_profile[$memID]['last_login'] - $user_profile[$memID]['first_login']) / 86400);
}
$context['posts_before'] = $dayb4['post_count'] . ($dayb4['post_count'] == 1 ? $txt['tli_post'] : $txt['tli_posts']);
$context['posts_made'] = $member['post_count'] . ($member['post_count'] == 1 ? $txt['tli_post'] : $txt['tli_posts']);
$context['total_logged_in'] = $user_profile[$memID]['total_time_logged_in'] != 0 ? days_hours_minutes($user_profile[$memID]['total_time_logged_in'] / 86400) : $txt['tli_not_available'];
$context['theme_name'] = $context['theme_names'][empty($user_profile[$memID]['id_theme']) ? $modSettings['theme_guests'] : $user_profile[$memID]['id_theme']]['name'];
}
}

function days_hours_minutes($total)
{
global $txt;

$hours = floor(($total - floor($total)) * 24);
$minutes = floor(((($total - floor($total)) * 24) - $hours) * 60);
$logged = (floor($total) == 0 ? '' : (floor($total) . (floor($total) == 1 ? $txt['tli_day'] : $txt['tli_days']))) .
($hours == 0 ? '' : ($hours) . ($hours == 1 ? $txt['tli_hour'] : $txt['tli_hours'])) .
$minutes . ($minutes == 1 ? $txt['tli_minute'] : $txt['tli_minutes']);

return $logged;
}

file $themedir/Profile.template.php

ค้นหา -->>

โค๊ด: [Select]

if (!isset($context['disabled_fields']['posts']))

แก้เป็น -->>

โค๊ด: [Select]

if (!isset($context['disabled_fields']['posts']) && !allowedTo('profile_logged_in'))

ค้นหา -->>

โค๊ด: [Select]

<dl class="noborder">';

// Can they view/issue a warning?

แก้เป็น -->>

โค๊ด: [Select]

', !allowedTo('profile_logged_in') ? '<dl class="noborder">' : '<dl>';

// Can they view/issue a warning?

ค้นหา -->>

โค๊ด: [Select]

<dd>', $context['member']['registered'], '</dd>
<dt>', $txt['lastLoggedIn'], ': </dt>
<dd>', $context['member']['last_login'], '</dd>';

แก้เป็น -->>

โค๊ด: [Select]

<dd>', $context['member']['registered'], '</dd>';

if (!allowedTo('profile_logged_in'))
echo '
<dt>', $txt['lastLoggedIn'], ': </dt>
<dd>', $context['member']['last_login'], '</dd>';

if (allowedTo('profile_logged_in'))
echo '
<dt>', $txt['tli_logged_in'], ': </dt>
<dd>', $context['first_login'], '</dd>
<dt>', $txt['lastLoggedIn'], ': </dt>
<dd>', $context['member']['last_login'], '</dd>
<dt>', $txt['tli_online_for'], ': </dt>
<dd>', $context['online_for'], '</dd>
<dt>', $txt['tli_posts_made'], ':</dt>
<dd>', $context['posts_made'], '</dd>

<dt>', $txt['tli_posts_before'], ':</dt>
<dd>', $context['posts_before'], '</dd>

<dt>', $txt['tli_total_posts'], ': </dt>
<dd>', $context['member']['posts'], ' (', $context['member']['posts_per_day'], ' ', $txt['posts_per_day'], ')</dd>

<dt>', $txt['tli_total_logged_in'], ':</dt>
<dd>', $context['total_logged_in'], '</dd>

<dt>', $txt['tli_theme'], ':</dt>
<dd>', $context['theme_name'], '</dd>

</dl><dl class="noborder">';

file $languagedir/Modifications.thai-utf8.php

เพิ่ม -->>
ขออภัย! ท่านไม่สามารถเข้าถึงข้อมูลส่วนนี้ได้ กรุณาอ่าน เงื่อนไขการใช้งาน DexMore.Com

file $languagedir/ManagePermissions.thai-utf8.php

เพิ่ม -->>
ขออภัย! ท่านไม่สามารถเข้าถึงข้อมูลส่วนนี้ได้ กรุณาอ่าน เงื่อนไขการใช้งาน DexMore.Com

สร้างไฟล์: tlidb20x.php เพื่อสร้างฐานข้อมูล ไว้ใน $boarddir (ที่เดียวกับไฟล์ SSI.php) รัน http://www.your_url.xxx/$boarddir/tlidb20x.php -->> Enter เสร็จแล้วลบทิ้ง

โค๊ด: [Select]

<?php

if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
require_once(dirname(__FILE__) . '/SSI.php');
elseif (!defined('SMF'))
die('Error: Cannot update database.');

if(!array_key_exists('db_add_column', $smcFunc))
db_extend('packages');

$first_login = array(
'name' => 'first_login',
'type' => 'int',
'size' => 10,
'null' => false,
'unsigned' => true,
'default' => 0
);

$smcFunc['db_add_column']('members', $first_login);

if(SMF == 'SSI')
echo 'Done!';

?>

ลิงค์หัวข้อ: http://dexmore.com/topic/2404

Time Logged-In แสดงรายละเอียดการเข้าสู่ระบบในข้อมูลส่วนตัว

ทำเว็บไซต์ | แต่งบอร์ด | ออกแบบ | SMF | Joomla | Drupal | WordPress | JQuery | CMS | ECommerce | Tel. +668-08577477