phpBB España Oficial

/*
* this comment do not executed in the SQL queries // no ejecute este cometario en las consulta SQL
* if your table prefixes isn't phpbb, you must be change SQL queries prefix for your tables prefix
* si el prefijo de tus tablas no es phpbb, debes cambiar el prefijo de las consultas SQL por el prefijo de tus tablas
*/

INSERT INTO `phpbb_acl_options` (`auth_option_id`, `auth_option`, `is_global`, `is_local`, `founder_only`) VALUES (' ', 'a_affiliates_index_manage', 1, 0, 0);

CREATE TABLE IF NOT EXISTS `phpbb_affiliates_index_config` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` mediumtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`config_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
INSERT INTO `phpbb_affiliates_index_config` (`config_name`, `config_value`) VALUES
('affiliates_index_enable', '1'),
('affiliates_index_links', '1'),
('affiliates_index_link_us', '1'),
('affiliates_index_minibanners', '1'),
('version_check_time', '0'),
('version_check_version', '0.0.0'),
('affiliates_index_version', '0.0.5'),
('affiliates_index_version_check', '1'),
('my_minibanner', '/images/banners/my_minibanner.gif');

CREATE TABLE IF NOT EXISTS `phpbb_affiliates_index_links` (
`links_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`links_img` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`links_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`links_url` varchar(150) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`links_view` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`links_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`links_id`),
KEY `links_order` (`links_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `phpbb_affiliates_index_links` (`links_id`, `links_img`, `links_name`, `links_url`, `links_view`, `links_order`) VALUES
(1, 'square_orange.gif', 'Ivemfinity', 'http://www.ivemfinity.com/', '1', 1),
(2, 'square_red.gif', 'Mundoforeros', 'http://www.mundoforeros.com/', '1', 2),
(3, 'square_green.gif', 'Board3.de', 'http://www.board3.de/', '1', 3),
(4, 'square_yellow.gif', 'Portalxl.nl', 'http://www.portalxl.nl/', '1', 4),
(5, 'square_brown.gif', 'phpBB-es', 'http://www.phpbb-es.com/', '1', 5);

CREATE TABLE IF NOT EXISTS `phpbb_affiliates_index_minibanners` (
`minibanners_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`minibanners_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`minibanners_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`minibanners_description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`minibanners_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
INSERT INTO `phpbb_affiliates_index_minibanners` (`minibanners_id`, `minibanners_url`, `minibanners_img`, `minibanners_description`) VALUES
(1, 'http://www.ivemfinity.com/', 'images/minibanners/banner_d.gif', 'Software libre, phpBB3, tutoriales, musica y mucho mas'),
(2, 'http://www.mundoforeros.com/', 'images/minibanners/mini_mun.gif', 'Torneos en Mundijuegos'),
(3, 'http://www.portalxl.nl/', 'images/minibanners/portalxl.png', 'Portalxl.nl'),
(4, 'http://www.phpbb.com/', 'images/minibanners/phpBB.gif', 'phpBB.com'),
(5, 'http://www.phpbb-es.com/', 'images/minibanners/banner_phpbb_es.png', 'phpBB castellano, hispano');