phpBB España Oficial

Código: Seleccionar todo

    /*
    * 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.6'),
    ('affiliates_index_version_check', '1'),
    ('my_minibanner', 'images/banners/my_minibanner.gif'),
    ('minibanners_title_name', 'minibanners'),
    ('minibanners_width', '88'),
    ('minibanners_height', '31'),
    ('minibanners_vel', '20'),
    ('links_title_name', 'enlaces'),
    ('links_vel', '20'),
    ('link_us_title_name', 'enlacenos');

    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),
    (6, 'square_blue.gif', 'phpBB.com', 'http://www.phpbb.com/', '1', 6);

    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,
    `minibanners_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`minibanners_id`),
    KEY `minibanners_order` (`minibanners_order`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
    INSERT INTO `phpbb_affiliates_index_minibanners` (`minibanners_id`, `minibanners_url`, `minibanners_img`, `minibanners_description`, `minibanners_order`) VALUES
    (1, 'http://www.ivemfinity.com/', 'images/minibanners/banner_d.gif', 'Software libre, phpBB3, tutoriales, musica y mucho mas', 0),
    (2, 'http://www.mundoforeros.com/', 'images/minibanners/mini_mun.gif', 'Torneos en Mundijuegos', 1),
    (3, 'http://www.portalxl.nl/', 'images/minibanners/portalxl.png', 'Portalxl.nl', 2),
    (4, 'http://www.phpbb.com/', 'images/minibanners/phpBB.gif', 'phpBB.com', 3),
    (5, 'http://www.phpbb-es.com/', 'images/minibanners/banner_phpbb_es.png', 'phpBB castellano, hispano', 4);