Medellin/Colombia
I have to do is run this code in phpmyadmin.
CREATE TABLE `phpbb_logs` (
`id_log` MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
`mode` VARCHAR(50) NULL DEFAULT '',
`topic_id` MEDIUMINT(10) NULL DEFAULT '0',
`user_id` MEDIUMINT(8) NULL DEFAULT '0',
`username` VARCHAR(255) NULL DEFAULT '',
`user_ip` CHAR(8) DEFAULT '0' NOT NULL,
`time` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id_log`)
);
CREATE TABLE `phpbb_admin_logs` (
`id_log` MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
`mode` VARCHAR(50) NULL DEFAULT '',
`user_id` MEDIUMINT(8) NULL DEFAULT '0',
`username` VARCHAR(255) NULL DEFAULT '',
`user_ip` CHAR(8) DEFAULT '0' NOT NULL,
`time` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id_log`)
);
CREATE TABLE `phpbb_logs_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL,
PRIMARY KEY (`config_name`)
);
INSERT INTO `phpbb_logs_config` VALUES ('all_admin', 1);
ALTER TABLE `phpbb_users` ADD `user_view_log` TINYINT(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` ADD `forum_allow_log` TINYINT(2) NOT NULL DEFAULT '1';
`id_log` MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
`mode` VARCHAR(50) NULL DEFAULT '',
`topic_id` MEDIUMINT(10) NULL DEFAULT '0',
`user_id` MEDIUMINT(8) NULL DEFAULT '0',
`username` VARCHAR(255) NULL DEFAULT '',
`user_ip` CHAR(8) DEFAULT '0' NOT NULL,
`time` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id_log`)
);
CREATE TABLE `phpbb_admin_logs` (
`id_log` MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
`mode` VARCHAR(50) NULL DEFAULT '',
`user_id` MEDIUMINT(8) NULL DEFAULT '0',
`username` VARCHAR(255) NULL DEFAULT '',
`user_ip` CHAR(8) DEFAULT '0' NOT NULL,
`time` INT(11) NULL DEFAULT '0',
PRIMARY KEY (`id_log`)
);
CREATE TABLE `phpbb_logs_config` (
`config_name` varchar(255) NOT NULL,
`config_value` varchar(255) NOT NULL,
PRIMARY KEY (`config_name`)
);
INSERT INTO `phpbb_logs_config` VALUES ('all_admin', 1);
ALTER TABLE `phpbb_users` ADD `user_view_log` TINYINT(2) NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` ADD `forum_allow_log` TINYINT(2) NOT NULL DEFAULT '1';
Remember to change the prefix, so the first line of the code looks like this insted.
for example
