phpBB.nl

Code: Selecteer alles

search.php

#
#-----[ FIND ]------------------------------------------------
#
		$sql = "SELECT session_id 
			FROM " . SESSIONS_TABLE;

#
#-----[ REPLACE WITH ]----------------------------------------
#

// Start replacement - Last visit MOD
	$expiry_time = $current_time - $board_config['session_length'];
		$sql = "SELECT session_id
			FROM " . SESSIONS_TABLE ." WHERE session_time>$expiry_time";
// Start replacement - Last visit MOD

Code: Selecteer alles

//
		// Flood control
		//
		$where_sql = ($userdata['user_id'] == ANONYMOUS) ? "se.session_ip = '$user_ip'" : 'se.session_user_id = ' . $userdata['user_id'];
		$sql = 'SELECT MAX(sr.search_time) AS last_search_time
			FROM ' . SEARCH_TABLE . ' sr, ' . SESSIONS_TABLE . " se
			WHERE sr.session_id = se.session_id
				AND $where_sql";
		if ($result = $db->sql_query($sql))
		{

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------------ 
# 
templates/subSilver/index_body.tpl

# 
#-----[ FIND ]------------------------------------------------ 
# 
whosonline.gif

# 
#-----[ IN-LINE FIND ]---------------------------------------- 
#
rowspan="{%:1}"

# 
#-----[ INCREMENT ]------------------------------------------- 
# 
%:1 +1

Code: Selecteer alles

# 
#-----[ SQL ]-------------------------------------------------
# 
ALTER TABLE phpbb_users ADD user_lastlogon INT (11) DEFAULT '0' not null;
ALTER TABLE phpbb_users ADD user_totaltime INT (11) DEFAULT '0';
ALTER TABLE phpbb_users ADD user_totallogon INT (11) DEFAULT '0';
ALTER TABLE phpbb_users ADD user_totalpages INT (11) DEFAULT '0';

INSERT INTO phpbb_config (config_name, config_value) VALUES ('hidde_last_logon','0');

UPDATE phpbb_users SET user_lastlogon = user_lastvisit WHERE user_lastlogon = '0';
UPDATE phpbb_users SET user_totallogon = '1' WHERE user_totallogon = '0' AND user_session_time <> '0';
UPDATE phpbb_users SET user_totaltime = (user_session_time - user_lastlogon) WHERE user_totaltime = '0' AND user_lastlogon > '0';

Code: Selecteer alles

// Start add - Last visit MOD
$lang['Last_logon'] = "Laatste bezoek"; 
$lang['Hidde_last_logon'] = "Verborgen"; 
$lang['Never_last_logon'] = "Nooit"; 
$lang['Users_today_zero_total'] = "In totaal hebben <b>0</b> gebruikers vandaag het B-B-F bezocht: "; 
$lang['Users_today_total'] = "In totaal hebben <b>%d</b> gebruikers vandaag het B-B-F bezocht: "; 
$lang['User_today_total'] = "In totaal hebben <b>%d</b> gebruikers vandaag het B-B-F bezocht: "; 
$lang['Users_lasthour_explain'] = ", waarvan %d het laatste uur."; 
$lang['Users_lasthour_none_explain'] = ""; //showen of none have visited the last hour

$lang['Years'] = 'Jaren'; 
$lang['Year'] = 'Jaar'; 
$lang['Weeks'] = 'Weken'; 
$lang['Week'] = 'Week'; 
$lang['Day'] = 'Dag'; 
$lang['Total_online_time'] = 'Totale Online tijd'; 
$lang['Last_online_time'] = 'Lengte Online tijd'; 
$lang['Number_of_visit'] = 'Aantal bezoeken'; 
$lang['Number_of_pages'] = 'Aantal pagina bezoeken';
// End add - Last visit MOD

Code: Selecteer alles

// Start add - Last visit MOD
$lang['Last_logon'] = "Laatste bezoek"; 
$lang['Hidde_last_logon'] = "Verborgen"; 
$lang['Never_last_logon'] = "Nooit"; 
$lang['Users_today_zero_total'] = "In totaal hebben <b>0</b> gebruikers vandaag het CDB bezocht :: "; 
$lang['Users_today_total'] = "In totaal hebben <b>%d</b> gebruikers vandaag het CDB bezocht :: "; 
$lang['User_today_total'] = "In totaal hebben <b>%d</b> gebruikers het CDB bezocht :: "; 
$lang['Users_lasthour_explain'] = ", waarvan %d het laatste uur."; 
$lang['Users_lasthour_none_explain'] = ""; //showen of none have visited the last hour

$lang['Years'] = 'Jaren'; 
$lang['Year'] = 'Jaar'; 
$lang['Weeks'] = 'Weken'; 
$lang['Week'] = 'Week'; 
$lang['Day'] = 'Dag'; 
$lang['Total_online_time'] = 'Totale Online tijd'; 
$lang['Last_online_time'] = 'Lengte Online tijd'; 
$lang['Number_of_visit'] = 'Aantal bezoeken'; 
$lang['Number_of_pages'] = 'Aantal pagina bezoeken';
// End add - Last visit MOD

Code: Selecteer alles

<?php
#########################################################
## SQL commands to phpBB2
## Author: Paul Norman
## Nickname: acoolwelshbloke
## Email: acoolwelshbloke@tec2spec.co.uk
##
## Ver 1.0.9
##
## phpBB2 database update script for mods.
## This file is intended for use with phpBB2, when installing the Last Visit mod.
## After you run this file you may delete it, but remember only admin can use so it really doesen't matter.
## The script will look for whatever prefix you are using, and it will use the existing DB defined by congig.php
## The execution of these/this script(s) including the SQL commands are harmless, so you can run it as meny times you like.
## Please note, though the users last visit will be set back to his/her last login, 
## however this is a minor cosmetic isue, and it will correct itself next time the user logs in.
##
#########################################################

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
'ALTER TABLE '.USERS_TABLE.' ADD user_lastlogon INT (11) DEFAULT "0" not null',
'UPDATE '.USERS_TABLE.' SET user_lastlogon=user_lastvisit WHERE user_lastlogon="0"',
'INSERT INTO '.CONFIG_TABLE.' (config_name, config_value) VALUES ("hidde_last_logon", "0")',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totaltime INT (11) DEFAULT "0"',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totallogon INT (11) DEFAULT "0"',
'ALTER TABLE ' . USERS_TABLE .' ADD user_totalpages INT (11) DEFAULT "0"',
'UPDATE '. USERS_TABLE .' SET user_totaltime=(user_session_time-user_lastlogon) WHERE user_totaltime="0" AND user_lastlogon>0',
'UPDATE '. USERS_TABLE .' SET user_totallogon=1 WHERE user_totallogon="0" AND user_session_time<>"0"'
);


$mods = array ( 
'Last Visit PART 1 Mod','Last Visit PART 1 Mod','Last Visit PART 2 Mod','Last Visit PART 4 Mod','Last Visit PART 4 Mod','Last Visit PART 4 Mod','Last Visit PART 4 Mod','Last Visit PART 4 Mod'
);

############################################### Do not change anything below this line #######################################

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//

if (!$userdata['session_logged_in'])
{
	header('Location: ' . append_sid("login.$phpEx?redirect=last_visit_db_update.$phpEx", true));
}

if ($userdata['user_level'] != ADMIN)
{
	message_die(GENERAL_MESSAGE, $lang['Not_Authorised']);
} 

$n=0;
$message="<b>This list is a result of the SQL queries needed for MOD</b><br/><br/>";
while($sql[$n])
{
	$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
	if(!$result = $db->sql_query($sql[$n])) 
	$message .= '<b><font color=#FF0000>[Already added]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	else $message .='<b><font color=#0000fF>[Added/Updated]</font></b> line: '.($n+1).' , '.$sql[$n].'<br />';
	$n++;
}
 message_die(GENERAL_MESSAGE, $message); 
?>