phpBB.de

Code: Alles auswählen

######################################################## 
## Mod Title:   Site History Mod 
## Mod Version: 0.11.3 beta
## Author:       Niels Chr. Rød Denmark < ncr@db9.dk > http://mods.db9.dk
##
## Description:  Stores the number of your sites vistitors into the db, so this info can be
## viewet in a statisics page
## you will be able to se how meny users was on your site a a given time, back in time
## statistics data is stored as accumulated date over a period of one day
## you will also be able to se how meny posts/topic those users made that time
## in total giving you an overview over when you users are visiting your site, and if they
## did only browse or in fact also made /delete posts
##
## Note, this mod, uses the forums time (hard coded) to deside when "today" is, this is nessesary since data is accumulative
##
## This mod is for phpBB2 ver 2.0.2
## 
## 
## Installation Level:  Easy 
## Installation Time:   2-3 Minutes 
## Files To Edit:      2 
##    phpBB2/index.php
##	phpBB2/includes/constants.php
##    phpBB2/includes/functions_posts.php
## Included files		3
##	phpBB2/site_hist.php
##	phpBB2/language/langues_english/lang_siste_hist.php
##	phpBB2/templates/subsilver/site_hist.tpl
##
##
## History:
##	ver 0.9.0. - initial beta, stores users movement into DB
##	ver 0.9.1. - corrected some typos in the how-to
## Now named Site History Mod
##	ver 0.9.2. - corrected this part to work with prefix tabels
##	ver 0.9.3. - now includes a view of the statistics
##	ver 0.9.4. - now includes month,week and day statistics
##	ver 0.9.5. - now improve the statistic mod, so who.is-online also show if users watch this
##	ver 0.9.6. - updated the lang_statistcs2.php - thanks to THX|PK|, there was a few spelling mistakes 
##	ver 0.10.0. - now made independet of the original statistics mod, to improve the load speed of site_hist page
##	ver 0.11.0. - now made it independed of the last visit mod, also stored data does follow the forums time
##	ver 0.11.1. - fixed a [FIND] tag in the index.php
##	ver 0.11.2. - included number of newly registerd users in the site history
##	ver 0.11.3. - new version of site_hist.php
##
################################################################# 
## Security Disclaimer: This MOD Cannot Be Posted To Or Added At Any Non-Official phpBB Sites 
################################################################# 
## 
## Installation Notes: 
## If you do not wan to do the ADD SQL your self, then I have provided
## a db_update.php, with will do the SQL stuff, simply run this instead
##
## in the index.php file, you should read this inserted code
## and replace the value with what ever timezone you prefere
##
## // change the number later in the next line, to what ever time zone your forum is located, this need to be hard coded
## // in the release of this mod, the number is 1 
## $dato=create_date('H', $current_time,1);
##
## the timezone need also to be change in the site_hist.php
## define('SERVER_TIME_ZONE',1);
## the value 1, need to be set to what ever timezone you wish
######################################################## 

# 
#-----[ ADD SQL ]------------------------------------------ 
# 
# or run the included db_update.php file
CREATE TABLE site_history (date int (11)  not null , reg mediumint(8)   not null , hidden mediumint(8)   not null , guests mediumint(8)   not null , new_topics mediumint(8)   not null , new_posts mediumint(8)   not null  , UNIQUE (date))

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/constants.php

# 
#-----[ FIND ]------------------------------------------ 
# 
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
define('SITE_HISTORY_TABLE', $table_prefix.'site_history');

# 
#-----[ FIND ]------------------------------------------ 
# 
define('PAGE_GROUPCP', -11);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
define('PAGE_SITE_HIST', -66);

# 
#-----[ OPEN ]------------------------------------------ 
# 
index.php

# 
#-----[ FIND ]------------------------------------------ 
# 
$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);

# 
#-----[ AFTE, ADD ]------------------------------------------ 
# 
// added for site History mod
$current_time=time();
$minutes = date('is', $current_time);
$hour_now = $current_time - (60*($minutes[0].$minutes[1])) - ($minutes[2].$minutes[3]); 
// change the number late in the next line, to what ever time zone your forum is located, this need to be hard coded
// in the release of this mod, the number is 1 
$dato=create_date('H', $current_time,1);
$timetoday = $hour_now - (3600*$dato); 
$sql = 'SELECT COUNT(DISTINCT session_ip) as guests_today FROM '.SESSIONS_TABLE.' WHERE session_user_id="'.ANONYMOUS.'" AND session_time >= '.$timetoday.' AND session_time< '.($timetoday+86399);
if (!$result = $db->sql_query($sql)) 
{
	message_die(GENERAL_ERROR, "Couldn't retrieve guest user today data", "", __LINE__, __FILE__, $sql); 
}
$guest_count = $db->sql_fetchrow ($result);
$sql = 'SELECT user_allow_viewonline, COUNT(*) as count FROM ' . USERS_TABLE . ' WHERE user_id!="'.ANONYMOUS.'" AND user_session_time >= '.$timetoday.' AND user_session_time< '.($timetoday+86399).' GROUP BY user_allow_viewonline'; 
if (!$result = $db->sql_query($sql))
{ 
	message_die(GENERAL_ERROR, "Couldn't retrieve user today data", "", __LINE__, __FILE__, $sql); 
}
while ($reg_count = $db->sql_fetchrow ($result))
{
	if ($reg_count['user_allow_viewonline'])
	{
		$logged_visible_today=$reg_count['count'];
	}
	else
	{
		$logged_hidden_today=$reg_count['count'];
	}
}
$db->sql_freeresult($result);
$sql='UPDATE '.SITE_HISTORY_TABLE.' SET reg="'.$logged_visible_today.'", hidden="'.$logged_hidden_today.'", guests=
"'.$guest_count['guests_today'].'" WHERE date='.$hour_now;
if ( !$db->sql_query($sql) || !$db->sql_affectedrows() )
{
	$sql = 'INSERT IGNORE INTO '.SITE_HISTORY_TABLE.' (date, reg, hidden, guests)
		VALUES ('.$hour_now.', "'.$logged_visible_today.'", "'.$logged_hidden_today.'", "'.$guest_count['guests_today'].'")';
	if ( !($db->sql_query($sql)) )
	{
		message_die(CRITICAL_ERROR, 'Error create new site_hitory ', '', __LINE__, __FILE__, $sql);
	}
}
if (isset($result))
{
	$db->sql_freeresult($result);
}

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/functions_post.php

# 
#-----[ FIND ]------------------------------------------ 
# 
	return;
}

//
// Delete a post/poll

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
# 
$current_time=time();
$minutes = date('is', $current_time);
$hour_now = $current_time - (60*($minutes[0].$minutes[1])) - ($minutes[2].$minutes[3]); 
$sql='UPDATE '.SITE_HISTORY_TABLE.' SET '.(($mode == 'newtopic' || $post_data['first_post']) ? 'new_topics=new_topics':'new_posts=new_posts').$sign.' WHERE date='.$hour_now;
if ( !$db->sql_query($sql) || !$db->sql_affectedrows() )
{
 	$sql = 'INSERT IGNORE INTO '.SITE_HISTORY_TABLE. ' (date, '.(($mode == 'newtopic' || $post_data['first_post']) ? 'new_topics': 'new_posts').')
 		VALUES ('.$hour_now.', "1")';
	if ( !($db->sql_query($sql)) )
	{
		message_die(CRITICAL_ERROR, 'Error createing new site_hitory'.$sql, '', __LINE__, __FILE__, $sql);
	}
}

# 
#-----[ MAKE FILE ]------------------------------------------ 
#
# Included.

site_hist.php

# 
#-----[ MAKE FILE ]------------------------------------------ 
# 
# Included.

language/english/lang_site_hist.php

# 
#-----[ MAKE FILE ]------------------------------------------ 
# 
# Included.

templates/subsilver/site_hist.tpl