Cod: Selectaţi tot
SQL
Error creating visit record Am incercat sa verific daca este totul la locul lui. Tabelul e creat, am schimbat tipul campului visit_user_id din MEDIUMINT(8) in INT(11) pentru a fi similar cu user_id din phpbb_users table, si cu toate astea am aceeasi eroare.
A rezolvat cineva aceasta eroare pana acum?
Nu stiu daca e bine sa dau si codul instalarii, dar daca nu e bine ce fac, rog un moderator sa stearga portiunea de mai jos:
Cod: Selectaţi tot
##############################################################
## MOD Title: Simple Visitor Counter
## MOD Author: rudi1234 (Rudi Niemeijer) www.testforum.nl
## MOD Description: This mod places an extra line in the 'Who is Online' box containing the number of visitors and avg. visitors per day
## MOD Version: 0.0.1
##
## Installation Level: (Intermediate)
## Installation Time: 15 Minutes
## Files To Edit: sessions.php, lang_english.php (and any other supported language files), functions.php, index_body.tpl, page_header.php
## Included Files: n/a
## Extra table: login_data
##############################################################
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ 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/
##############################################################
## Author Notes:
## This mod involves creating a new table.
##
##############################################################
## MOD History:
##
## 2003-09-24 - Version 0.0.2
## - added table name VISITS_TABLE to constants.php
## - replaced use of table name in MOD with constant
## - Added 'As' keyword to SQL syntax to comply with ANSI-SQL
## - changed MOD instructions slightly to comply with MOD rules
## 2003-09-23 - Version 0.0.1
## - first working version
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
## THIS MOD IS BETA, DON'T USE IT ON A PRODUCTION BOARD
##############################################################
#
#-----[ CREEAZA TABEL ]----------------------------------------
#
CREATE TABLE visits (
visit_start INT(11) NOT NULL,
visit_user_id MEDIUMINT(8) NOT NULL
);
#
#-----[ DESCHIDE ]------------------------------------------------
#
/includes/constants.php
#
#-----[ CAUTA ]------------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
#
#-----[ ADAUGA DUPA ]-------------------------------------------
#
define('VISITS_TABLE', 'visits');
#
#-----[ DESCHIDE ]------------------------------------------------
#
/includes/session.php
#
#-----[ CAUTA ]------------------------------------------------
#
$userdata['session_id'] = $session_id;
$userdata['session_ip'] = $user_ip;
#
#-----[ ADAUGA INAINTE ]------------------------------------------
#
$sql = "INSERT INTO " . VISITS_TABLE . "
(visit_start, visit_user_id)
VALUES ($current_time, $user_id)";
if ( !$db->sql_query($sql) )
{
message_die(CRITICAL_ERROR, 'Error creating visit record ', '', __LINE__, __FILE__, $sql);
}
#
#-----[ DESCHIDE ]------------------------------------------------
#
\language\lang_romana\lang_main.php (sau oricare limba o aveti setata)
#
#-----[ CAUTA ]------------------------------------------------
#
$lang['Record_online_users'] =
#
#-----[ ADUAGA DUPA ]-------------------------------------------
#
$lang['Total_visitors'] = 'Am avut <b>%s</b> vizitatori din %s (cam %s pe zi)'; //first %s is total hits, second %s is date board started, third is avg/day.
#
#-----[ DESCHIDE ]------------------------------------------------
#
/includes/functions.php
#
#-----[ CAUTA ]------------------------------------------------
#
function get_db_stat($mode)
{
global $db;
switch( $mode )
{
#
#-----[ ADAUGA DUPA ]-------------------------------------------
#
case 'num_visitors':
$sql = "SELECT COUNT(*) AS visitors
FROM " . VISITS_TABLE;
break;
#
#-----[ CAUTA ]------------------------------------------------
#
case 'usercount':
return $row['total'];
break;
#
#-----[ ADAUGA INAINTE ]------------------------------------------
#
case 'num_visitors':
return $row['visitors'];
break;
#
#-----[ DESCHIDE ]------------------------------------------------
#
/templates/subSilver/index_body.tpl (sau oricare index_body.tpl al template-ului pe care il folositi.)
#
#-----[ CAUTA ]------------------------------------------------
#
<br />{NEWEST_USER}
#
#-----[ ADAUGA INAINTE ]------------------------------------------
#
<br />{TOTAL_VISITORS}
#
#-----[ DESCHIDE ]------------------------------------------------
#
/includes/page_header.php
#
#-----[ CAUTA ]------------------------------------------------
#
$template->assign_vars(array(
#
#-----[ ADAUGA INAINTE ]------------------------------------------
#
$visitcount = get_db_stat('num_visitors');
$boarddays = ( time() - $board_config['board_startdate'] ) / 86400;
$visitsperday = $visitcount / $boarddays;
#
#-----[ CAUTA ]------------------------------------------------
#
$template->assign_vars(array(
#
#-----[ ADAUGA DUPA ]-------------------------------------------
#
'TOTAL_VISITORS' => sprintf($lang['Total_visitors'], $visitcount, create_date($board_config['default_dateformat'], $board_config['board_startdate'], $board_config['board_timezone']), sprintf("%.1f", $visitsperday)),
#
#-----[ SALVEAZA SI INCHIDE FISIERELE ]--------------------------------
#
# EoM
Sarbatori Fericite!
