phpBB.de

########################################################
## Mod Title: Last Visit Mod
## Mod Version: 1.2.4
## Author: Niels Chr. Rød Denmark < ncr@db9.dk > http://mods.db9.dk
##
## This mod is for phpBB2 ver 2.0.2
##
## Description: This mod will enable logning of the users last visit time,
## after this mod, users can see when another user have last visited
## the board, this is shown in the correspondings users profile.
## This mod support, user level and hidden users
## Admin will always be able to see other users last visit, regardless of the settings
## if board config is "off", then only admin can see the information
## if board is "on", then all users kan se other users last visit
## except hidden users, who will still be "hidden"
## This mod, will also display the number of reg/hidden and guest users today on the index page
##
##
##
## Installation Level: Easy
## Installation Time: 10-15 Minutes
## Files To Edit: 6
## language/subsilver/lang_main.php
## includes/usercp_viewprofile.php
## includes/sessions.php
## index.php
## templates/subsilver/index_body.tpl
## templates/subsilver/profile_view_body.tpl
## Include files: 1
## db_update.php
##
## History:
## 0.9.0. - initial BETA for RC-2
## 1.0.0. - initial release for RC-2
## 1.0.10. - History started, change in how timezones are handled
## 1.0.11. - corrected a typo in how timezones are handled
## 1.0.12. - corection to follow phpBB2 coding guidelines
## 1.0.13. - Now includes the number of users witch have visited the board the last hour
## 1.0.14. - fixed that the language part was missing from the last hour addition
## 1.0.15. - added extra feature, that how meny guest visited the board today are also countet
## 1.0.16. - missed something in the page_header.php file
## 1.0.17. - moved some changes from page_header.php over to index.php, for incresed performance
## 1.0.18. - fixed session.php that guest users are reset from the "today list"
## 1.0.19. - guest was still beeing reset, new change to session.php $dato
## 1.2.0. - BETA for phpBB2 version 2.0.2.
## 1.2.1. - typo, missed a comma in session.php
## 1.2.2. - fixed that guest users was not counted rigth if mixed timezones
## 1.2.3. - removed som added code in session.php
## 1.2.4. - add, posibilty to log guest users time
##
##############################################################
## This MOD is released under the GPL License.
## Intellectual Property is retained by the MOD Author(s) listed above
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered
## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/
##############################################################
## Authors Notes:
##
## Instead of runing the SQL commands your self, I have also included a db_update.php file
## if you are loged in as ADMIN, you can run this file, witch will do the neasessary changes to the DB
## the file will by it self put prefix on your tables, else
## if you are using a prefix to you DB tabels then you have to add this to
## the [ADD SQL] commands, e.g. "phpbb_users" instead of just "users" - ONLY
## in the initial [ADD SQL] commands, not in the php code !
##
##
## The most important thing to keep in mind is, take your time, make
## sure you are finding the correct lines to modify, then take care to paste the new code.
## Please also keep in mind, if you are using more than one language file or theme at your
## site, you will need to edit the corrosponding files for each occurrence. Good Luck!
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
## and the Database
#################################################################


#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
ALTER TABLE users ADD user_lastlogon INT (11) DEFAULT '0'

#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
UPDATE users SET user_lastlogon=user_lastvisit

#
#-----[ ADD SQL ]------------------------------------------
#
SQL-query:
INSERT INTO config (config_name, config_value) VALUES ('hidde_last_logon', '0')