phpbb games mod
Geplaatst: 12 nov 2004, 21:58
oké,
ik heb deze mod ingevoerd in mijn forum:
MOD Title: Arcade / Activities MOD
MOD Version: 2.0.6
en tot hier ben ik al geraakt
nu weet ik niet hoe het hiermee zit?
wat moet ik hier doen? kan iemand mij uitleg geven
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_ina_data ( version VARCHAR(255) DEFAULT NULL );
CREATE TABLE phpbb_ina_games (
`game_id` mediumint(9) NOT NULL auto_increment,
`cat_id` mediumint(8) default NULL,
`game_name` varchar(25) default NULL,
`game_path` varchar(255) default NULL,
`image_path` varchar(255) default NULL,
`game_desc` varchar(255) default NULL,
`game_charge` int(11) unsigned default '0',
`game_reward` int(11) unsigned NOT NULL default '0',
`game_bonus` smallint(5) unsigned default '0',
`at_game_bonus` smallint(5) default '0',
`game_use_gl` tinyint(3) unsigned default '0',
`game_flash` tinyint(1) unsigned NOT NULL default '0',
`game_show_score` tinyint(1) NOT NULL default '1',
`game_avail` tinyint(1) unsigned default '1',
`allow_guest` tinyint(1) unsigned default '0',
`win_width` smallint(6) NOT NULL default '0',
`win_height` smallint(6) NOT NULL default '0',
`highscore_limit` int(11) default NULL,
`at_highscore_limit` int(10) default '0',
`reverse_list` tinyint(1) NOT NULL default '0',
`played` int(10) unsigned NOT NULL default '0',
`instructions` text, PRIMARY KEY (`game_id`),
`score_type` smallint(1) default NULL,
PRIMARY KEY (`game_id`));
CREATE TABLE phpbb_ina_scores (
`game_name` varchar(255) default NULL,
`player_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`score` decimal(12,4) unsigned default NULL,
`date` int(11) default NULL );
CREATE TABLE phpbb_ina_at_scores (
`game_name` varchar(255) default NULL,
`player_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`score` decimal(12,4) unsigned default NULL,
`date` int(11) default NULL );
CREATE TABLE phpbb_ina_sessions (
`arcade_hash` varchar(33) default NULL,
`user_id` mediumint(8) NOT NULL default '0',
`start_time` int(11) NOT NULL default '0',
`session_ip` varchar(8) NOT NULL default '',
`page` int(1) NOT NULL default '0',
`game_name` varchar(25) default NULL,
`user_ip` varchar(16) default '0',
`ip_name` varchar(255) default NULL);
CREATE TABLE phpbb_ina_banned (
`username` varchar(25) default NULL,
`user_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`game` varchar(25) default NULL,
`score` mediumint(8) default NULL,
`date` varchar(16) default NULL);
CREATE TABLE phpbb_ina_cat (
`cat_id` mediumint(8) NOT NULL auto_increment,
`mod_id` mediumint(8) default NULL,
`name` varchar(100) default NULL,
`desc` text,
`icon` varchar(255) default NULL,
`special_play` smallint(5) NOT NULL default '0',
`last_game` varchar(25) default NULL,
`last_player` mediumint(8) default NULL,
`last_time` int(11) default NULL );
CREATE TABLE phpbb_ina_fav (
`user_id` mediumint(8) NOT NULL default '0',
`game_id` mediumint(9) NOT NULL default '0');
CREATE TABLE phpbb_ina_tour (
`tour_id` mediumint(5) NOT NULL auto_increment,
`tour_name` varchar(25) default NULL,
`tour_desc` text);
INSERT INTO phpbb_ina_data VALUES ('v2.0.6');
INSERT INTO phpbb_ina_games (`game_id`, `game_name`, `game_path`, `image_path`, `game_desc`, `game_charge`, `game_reward`, `game_bonus`, `game_use_gl`, `game_flash`, `game_show_score`, `win_width`, `win_height`, `highscore_limit`, `reverse_list`, `played`, `instructions`, `game_avail`, `allow_guest`, `cat_id`) VALUES (1, 'donkeykong', 'games/donkeykong/', '', 'The Classic - Donkey Kong', 0, 0, 0, 0, 1, 1, 448, 600, 0, 0, 0, 'CLICK where it says \'Press Space Bar To Start\' to start the game :(', 1, 1, NULL);
INSERT INTO phpbb_config VALUES ('default_reward_dbfield','');
INSERT INTO phpbb_config VALUES ('default_cash','');
INSERT INTO phpbb_config VALUES ('use_rewards_mod','0');
INSERT INTO phpbb_config VALUES ('use_cash_system','0');
INSERT INTO phpbb_config VALUES ('report_cheater','0');
INSERT INTO phpbb_config VALUES ('warn_cheater','0');
INSERT INTO phpbb_config VALUES ('use_point_system','0');
INSERT INTO phpbb_config VALUES ('use_gamelib','0');
INSERT INTO phpbb_config VALUES ('games_path','');
INSERT INTO phpbb_config VALUES ('gamelib_path','');
INSERT INTO phpbb_config VALUES ('use_gk_shop','0');
INSERT INTO phpbb_config VALUES ('use_allowance_system','0');
INSERT INTO phpbb_config VALUES ('games_per_page','20');
INSERT INTO phpbb_config VALUES ('games_default_img','templates/subSilver/images/games.gif');
INSERT INTO phpbb_config VALUES ('games_default_txt','More games available to Registered Members - No Fee - No Catch.<br />');
INSERT INTO phpbb_config VALUES ('games_default_id','0');
INSERT INTO phpbb_config VALUES ('games_offline','0');
INSERT INTO phpbb_config VALUES ('games_cheat_mode','1');
INSERT INTO phpbb_config VALUES ('games_guest_highscore', '1');
INSERT INTO phpbb_config VALUES ('games_auto_size', '1');
INSERT INTO phpbb_config VALUES ('games_at_highscore', '1');
INSERT INTO phpbb_config VALUES ('games_show_stats', '1');
INSERT INTO phpbb_config VALUES ('games_image_width', '50');
INSERT INTO phpbb_config VALUES ('games_image_height', '50');
INSERT INTO phpbb_config VALUES ('games_per_admin_page', '');
ik heb deze mod ingevoerd in mijn forum:
MOD Title: Arcade / Activities MOD
MOD Version: 2.0.6
en tot hier ben ik al geraakt
nu weet ik niet hoe het hiermee zit?
wat moet ik hier doen? kan iemand mij uitleg geven
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_ina_data ( version VARCHAR(255) DEFAULT NULL );
CREATE TABLE phpbb_ina_games (
`game_id` mediumint(9) NOT NULL auto_increment,
`cat_id` mediumint(8) default NULL,
`game_name` varchar(25) default NULL,
`game_path` varchar(255) default NULL,
`image_path` varchar(255) default NULL,
`game_desc` varchar(255) default NULL,
`game_charge` int(11) unsigned default '0',
`game_reward` int(11) unsigned NOT NULL default '0',
`game_bonus` smallint(5) unsigned default '0',
`at_game_bonus` smallint(5) default '0',
`game_use_gl` tinyint(3) unsigned default '0',
`game_flash` tinyint(1) unsigned NOT NULL default '0',
`game_show_score` tinyint(1) NOT NULL default '1',
`game_avail` tinyint(1) unsigned default '1',
`allow_guest` tinyint(1) unsigned default '0',
`win_width` smallint(6) NOT NULL default '0',
`win_height` smallint(6) NOT NULL default '0',
`highscore_limit` int(11) default NULL,
`at_highscore_limit` int(10) default '0',
`reverse_list` tinyint(1) NOT NULL default '0',
`played` int(10) unsigned NOT NULL default '0',
`instructions` text, PRIMARY KEY (`game_id`),
`score_type` smallint(1) default NULL,
PRIMARY KEY (`game_id`));
CREATE TABLE phpbb_ina_scores (
`game_name` varchar(255) default NULL,
`player_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`score` decimal(12,4) unsigned default NULL,
`date` int(11) default NULL );
CREATE TABLE phpbb_ina_at_scores (
`game_name` varchar(255) default NULL,
`player_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`score` decimal(12,4) unsigned default NULL,
`date` int(11) default NULL );
CREATE TABLE phpbb_ina_sessions (
`arcade_hash` varchar(33) default NULL,
`user_id` mediumint(8) NOT NULL default '0',
`start_time` int(11) NOT NULL default '0',
`session_ip` varchar(8) NOT NULL default '',
`page` int(1) NOT NULL default '0',
`game_name` varchar(25) default NULL,
`user_ip` varchar(16) default '0',
`ip_name` varchar(255) default NULL);
CREATE TABLE phpbb_ina_banned (
`username` varchar(25) default NULL,
`user_id` mediumint(8) default NULL,
`player_ip` varchar(16) default NULL,
`game` varchar(25) default NULL,
`score` mediumint(8) default NULL,
`date` varchar(16) default NULL);
CREATE TABLE phpbb_ina_cat (
`cat_id` mediumint(8) NOT NULL auto_increment,
`mod_id` mediumint(8) default NULL,
`name` varchar(100) default NULL,
`desc` text,
`icon` varchar(255) default NULL,
`special_play` smallint(5) NOT NULL default '0',
`last_game` varchar(25) default NULL,
`last_player` mediumint(8) default NULL,
`last_time` int(11) default NULL );
CREATE TABLE phpbb_ina_fav (
`user_id` mediumint(8) NOT NULL default '0',
`game_id` mediumint(9) NOT NULL default '0');
CREATE TABLE phpbb_ina_tour (
`tour_id` mediumint(5) NOT NULL auto_increment,
`tour_name` varchar(25) default NULL,
`tour_desc` text);
INSERT INTO phpbb_ina_data VALUES ('v2.0.6');
INSERT INTO phpbb_ina_games (`game_id`, `game_name`, `game_path`, `image_path`, `game_desc`, `game_charge`, `game_reward`, `game_bonus`, `game_use_gl`, `game_flash`, `game_show_score`, `win_width`, `win_height`, `highscore_limit`, `reverse_list`, `played`, `instructions`, `game_avail`, `allow_guest`, `cat_id`) VALUES (1, 'donkeykong', 'games/donkeykong/', '', 'The Classic - Donkey Kong', 0, 0, 0, 0, 1, 1, 448, 600, 0, 0, 0, 'CLICK where it says \'Press Space Bar To Start\' to start the game :(', 1, 1, NULL);
INSERT INTO phpbb_config VALUES ('default_reward_dbfield','');
INSERT INTO phpbb_config VALUES ('default_cash','');
INSERT INTO phpbb_config VALUES ('use_rewards_mod','0');
INSERT INTO phpbb_config VALUES ('use_cash_system','0');
INSERT INTO phpbb_config VALUES ('report_cheater','0');
INSERT INTO phpbb_config VALUES ('warn_cheater','0');
INSERT INTO phpbb_config VALUES ('use_point_system','0');
INSERT INTO phpbb_config VALUES ('use_gamelib','0');
INSERT INTO phpbb_config VALUES ('games_path','');
INSERT INTO phpbb_config VALUES ('gamelib_path','');
INSERT INTO phpbb_config VALUES ('use_gk_shop','0');
INSERT INTO phpbb_config VALUES ('use_allowance_system','0');
INSERT INTO phpbb_config VALUES ('games_per_page','20');
INSERT INTO phpbb_config VALUES ('games_default_img','templates/subSilver/images/games.gif');
INSERT INTO phpbb_config VALUES ('games_default_txt','More games available to Registered Members - No Fee - No Catch.<br />');
INSERT INTO phpbb_config VALUES ('games_default_id','0');
INSERT INTO phpbb_config VALUES ('games_offline','0');
INSERT INTO phpbb_config VALUES ('games_cheat_mode','1');
INSERT INTO phpbb_config VALUES ('games_guest_highscore', '1');
INSERT INTO phpbb_config VALUES ('games_auto_size', '1');
INSERT INTO phpbb_config VALUES ('games_at_highscore', '1');
INSERT INTO phpbb_config VALUES ('games_show_stats', '1');
INSERT INTO phpbb_config VALUES ('games_image_width', '50');
INSERT INTO phpbb_config VALUES ('games_image_height', '50');
INSERT INTO phpbb_config VALUES ('games_per_admin_page', '');