I'm a new user here, and i see your great script for generate the install file, i try to test this but i'm not an expert...
would you like help me for create my file please ?
(sorry for my poor english, i'm french)
here, that's my queries and modules to add...
- Code: Select all
CREATE TABLE `phpbb_acl_arcade` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`group_id` int(11) NOT NULL,
`cat_id` int(11) NOT NULL,
`can_play` tinyint(4) NOT NULL DEFAULT '0',
`can_see` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_arcade` (
`config_name` varchar(50) NOT NULL,
`config_value` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`picture` varchar(50) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_championships` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) COLLATE utf8_bin NOT NULL,
`description` text COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `phpbb_championships_games` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`championship_id` int(11) NOT NULL DEFAULT '0',
`game_id` int(11) NOT NULL DEFAULT '0',
`round_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `phpbb_championships_rounds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`championship_id` int(11) NOT NULL,
`date_start` int(11) NOT NULL,
`date_end` int(11) NOT NULL,
`total_games` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_championships_scores` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` double NOT NULL,
`game_id` int(11) NOT NULL,
`gamer_id` int(11) NOT NULL,
`score_date` int(10) unsigned NOT NULL,
`championship_id` int(11) NOT NULL DEFAULT '0',
`score_comment` text NOT NULL,
`round_id` int(11) NOT NULL DEFAULT '0',
`is_first` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_games` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`variable_name` varchar(50) NOT NULL,
`file_name` varchar(50) NOT NULL,
`height` int(11) NOT NULL,
`width` int(11) NOT NULL,
`description` text NOT NULL,
`cat_id` int(11) NOT NULL,
`picture` varchar(50) NOT NULL,
`time_played` int(11) NOT NULL DEFAULT '0',
`best_score_first` tinyint(4) NOT NULL DEFAULT '1',
`adapter` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `phpbb_games_bookmarks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`game_id` int(11) NOT NULL,
`gamer_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE `phpbb_marks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`game_id` int(11) NOT NULL,
`gamer_id` int(11) NOT NULL,
`mark` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_scores` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` double NOT NULL,
`game_id` int(11) NOT NULL,
`gamer_id` int(11) NOT NULL,
`score_date` int(10) unsigned NOT NULL,
`cat_id` int(11) NOT NULL DEFAULT '0',
`score_comment` text NOT NULL,
`is_first` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_sessions_arcade` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`session_id` varchar(32) NOT NULL,
`gamer_id` int(11) NOT NULL,
`game_id` int(11) NOT NULL,
`start_time` int(11) NOT NULL,
`session_forum_id` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_teams` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`description` text NOT NULL,
`su_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `phpbb_ultim_scores` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`points` double NOT NULL,
`game_id` int(11) NOT NULL,
`gamer_id` int(11) NOT NULL,
`score_date` int(10) unsigned NOT NULL,
`cat_id` int(11) NOT NULL DEFAULT '0',
`score_comment` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
CREATE TABLE `phpbb_users_teams` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`team_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`champ_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE phpbb_users ADD user_arcade_style INT(11) DEFAULT 0;
ALTER TABLE phpbb_users ADD user_arcade_cat_style INT(11) DEFAULT 0;
ALTER TABLE phpbb_users ADD user_arcade_allow_pm INT(11) DEFAULT 0;
INSERT INTO `phpbb_arcade` (`config_name`, `config_value`) VALUES
('games_per_page', '10'),
('number_bookmarks', '5'),
('use_bookmark_system', '1'),
('active_arcade', '1'),
('games_thumb_width', '30'),
('games_thumb_height', '30'),
('game_of_day', '0'),
('display_style', '0'),
('stats_thumb_width', '30'),
('stats_thumb_height', '30'),
('use_comment', '1'),
('max_time', '0'),
('number_blocks', '3'),
('last_upd', '0'),
('nb_messages', '3'),
('nb_jours', '7'),
('activer_post', '1'),
('winners', '10'),
('scorerow', '5'),
('recordrow', '5'),
('gamesnews', '10'),
('activer_bloc', '1'),
('winnersindex', '5'),
('gamesnewsindex', '5');
For queries i think it's good, but i don't know how to add modules
here's my modules to add :
Administration Control Panel > System > Module Management :: Administration Control Panel
Create a new module "ACP_ARCADEOA", type category, no parent
Click on Olympus Arcade
Create a new module "ACP_ARCADEOA", type category with Olympus Arcade as parent
Click on Olympus Arcade
Select "Arcade configuration" then "Add module"
Select "Categories management" then "Add module"
Select "Arcade permissions" then "Add module"
Select "Games management" then "Add module"
Select "Install games" then "Add module"
Select "Championships management" then "Add module"
Enable all modules
Navigate to:
Administration Control Panel > System > Module Management :: User Control Panel
Create a new module "UCP_ARCADEOA", type category, no parent
Click on Olympus Arcade
Create a new module "UCP_ARCADEOA", type category with Olympus Arcade as parent
Click on Olympus Arcade
Enable this module
