Code: Select all
$result = $db->sql_query($sql);$i=-1; $today->visitlist = array();
Code: Select all
DROP TABLE IF EXISTS `phpbb_visitors_table`;
CREATE TABLE `phpbb_visitors_today` (
`index` int(11) NOT NULL auto_increment,
`user_id` int(1) NOT NULL default '0',
`user_ip` varchar(15) NOT NULL default '',
`allow_viewonline` tinyint(1) NOT NULL default '0',
`last_visit` int(11) NOT NULL default '0',
PRIMARY KEY (`index`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_time', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_color', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_hidden', '1', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_delete_threshold', 86400, 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_record_count', '0', 1);
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_record_date', '0', 1);
Code: Select all
FROM
' . USERS_TABLE . ' u,
' . VISITORS_TABLE . ' v
Code: Select all
FROM (
' . USERS_TABLE . ' u,
' . VISITORS_TABLE . ' v )
Code: Select all
INSERT INTO `phpbb_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);
Code: Select all
INSERT INTO `phpbb_3config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('visit_display_bots', '1', 1);