Arcade Mod 2.1.3

[mariusik88]

salut!! Vreau si eu Arcade Mod 2.1.3 plzz nu il gasesc pe nicaieri plzz ajutati-ma si pe mine cu un link plzzz

la arcade mod 2.1.2 imi da eroarea asta
Error getting total games

DEBUG MODE

SQL Error : 1146 Table 'trupaelgi_04.phpbb_ina_user_data' doesn't exist

SELECT * FROM phpbb_ina_user_data WHERE user_id = 2

Line : 312
File : classes_arcade.php

ce pot sa-i fac??

[seelview]

Pai daca nu a fost lansat cum vrei sa il gasesti ?

Ultima versiune scoasa este 2.1.2 asa cum scrie pe forumul phpbb.com

EDIT: Trebuie sa face si modificarile bazei de date ca sa iti functioneze cum trebuie modul

[mariusik88]

la arcade mod 2.1.2 imi da eroarea asta
Error getting total games

DEBUG MODE

SQL Error : 1146 Table 'trupaelgi_04.phpbb_ina_user_data' doesn't exist

SELECT * FROM phpbb_ina_user_data WHERE user_id = 2

Line : 312
File : classes_arcade.php

ce pot sa-i fac??

[evo_vii]

cand l-ai instalat ar fi tre sa existe si un fisier : ArcadeMod2.1.3_db_install sau ceva in genul prin care ti se creau tabelele necesare in baza de date ! daca e le poti crea singur ....

[mariusik88]

nu am fisieru ala . poti sa-mi dai un link de unde sa-l descarc sau de unde pot sa iau tabelele (adica comenzile pentru creat tabelele) plzz

[evo_vii]

tabelele le poti crea manual sau cauta o alta sursa de unde sa iei Arcade Mod 2.1.3 care poate are acel fisier !

[mariusik88]

arcade mod 2.1.3 nu s-a lansat ma intereseaza tabelele pentru 2.1.2 si anume phpbb_ina_user_data ca pe asta nu il gaseste celelelalte tabele le-am creat insa pe asta nu-l gasesc:((((((((((((((((((((

[evo_vii]

creaza tu singur tabele din baza de date ! in phpmyadmin !

[Aliniuz]

incearca sa introduci aceste comenzi in phpmyadmin inlocuind phpbb_ cu prefix-ul ales de tine

CREATE TABLE phpbb_ina_data ( `version` VARCHAR(25) DEFAULT '2.0.0' ) DONE.!
CREATE TABLE phpbb_ina_games ( `game_id` mediumint(9) NOT NULL auto_increment, `game_name` varchar(25) default NULL, `game_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', `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', `win_width` smallint(6) NOT NULL default '0', `win_height` smallint(6) NOT NULL default '0', `highscore_limit` varchar(255) default NULL, `reverse_list` tinyint(1) NOT NULL default '0', `played` int(10) unsigned NOT NULL default '0', `instructions` text, PRIMARY KEY `game_id` (`game_id`) ) DONE.!
CREATE TABLE phpbb_ina_scores ( `game_name` varchar(255) default NULL, `player` varchar(40) default NULL, `score` int(10) unsigned NOT NULL default '0', `date` int(11) default NULL, KEY `game_name` (`game_name`)) DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('default_reward_dbfield','') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('default_cash','') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_rewards_mod','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_cash_system','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('report_cheater','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('warn_cheater','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_point_system','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_gamelib','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_path','') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('gamelib_path','') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_gk_shop','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('use_allowance_system','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_per_page','20') DONE.!
INSERT INTO phpbb_ina_data ( `version` ) VALUES ('2.0.0') DONE.!
ALTER TABLE phpbb_ina_games ADD `game_avail` TINYINT(1) default 1 DONE.!
ALTER TABLE phpbb_ina_games ADD `allow_guest` TINYINT(1) default 0 DONE.!
ALTER TABLE phpbb_ina_games ADD `image_path` VARCHAR(255) default '.gif' DONE.!
ALTER TABLE phpbb_ina_games ADD `cat_id` MEDIUMINT(8) default NULL DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_default_img','templates/subSilver/images/games.gif') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_default_txt','Over 120 games available to Registered Members - No Fee - No Catch.
') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_default_id','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_tournament_mode','0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_offline','0') DONE.!
CREATE TABLE phpbb_ina_at_scores ( `game_name` varchar(255) default NULL, `player` varchar(40) default NULL, `score` int(10) unsigned NOT NULL default '0', `date` int(11) default NULL, KEY `game_name` (`game_name`)) DONE.!
ALTER TABLE phpbb_ina_scores ADD `player_id` MEDIUMINT(8) AFTER `player` DONE.!
ALTER TABLE phpbb_ina_at_scores ADD `player_id` MEDIUMINT(8) AFTER `player` DONE.!
CREATE TABLE phpbb_ina_sessions ( `session_id` varchar(32) 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, KEY `session_id` (`session_id`)) DONE.!
UPDATE phpbb_ina_scores AS s, phpbb_users AS u SET `s.player_id` = `u.user_id` WHERE `s.player` = `u.username` NOT REQUIRED.!
Unknown column 's.player_id' in 'field list'
UPDATE phpbb_ina_at_scores AS s, phpbb_users AS u SET `s.player_id` = `u.user_id` WHERE `s.player` = `u.username` NOT REQUIRED.!
Unknown column 's.player_id' in 'field list'
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_cheat_mode','1') DONE.!
ALTER TABLE phpbb_ina_scores ADD `player_ip` VARCHAR(16) default 0 DONE.!
ALTER TABLE phpbb_ina_at_scores ADD `player_ip` VARCHAR(16) default 0 DONE.!
ALTER TABLE phpbb_ina_games ADD `at_highscore_limit` smallint(5) default 0 DONE.!
ALTER TABLE phpbb_ina_games ADD `at_game_bonus` smallint(5) default 0 DONE.!
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`) 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 ') DONE.!
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, PRIMARY KEY (`cat_id`), KEY `cat_id` (`cat_id`)) DONE.!
ALTER TABLE phpbb_ina_sessions ADD `arcade_hash` varchar(33) default NULL DONE.!
ALTER TABLE phpbb_ina_sessions ADD KEY `arcade_hash` (`arcade_hash`) DONE.!
ALTER TABLE phpbb_ina_games ADD `score_type` smallint(1) default NULL DONE.!
ALTER TABLE phpbb_ina_scores CHANGE `score` `score` DOUBLE( 12, 4 ) UNSIGNED DEFAULT '0' NOT NULL DONE.!
ALTER TABLE phpbb_ina_at_scores CHANGE `score` `score` DOUBLE( 12, 4 ) UNSIGNED DEFAULT '0' NOT NULL DONE.!
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, KEY `user_id` (`user_id`)) DONE.!
CREATE TABLE phpbb_ina_fav ( `user_id` mediumint(8) NOT NULL default '0', `game_id` mediumint(9) NOT NULL default '0', KEY `game_id` (`game_id`)) DONE.!
CREATE TABLE phpbb_ina_tour ( `tour_id` mediumint(5) NOT NULL auto_increment, `tour_name` varchar(25) default NULL, `tour_desc` text, PRIMARY KEY `tour_id` (`tour_id`)) DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_guest_highscore', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_auto_size', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_at_highscore', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_show_stats', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_image_width', '50') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_image_height', '50') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_per_admin_page', '') DONE.!
CREATE TABLE phpbb_ina_pms ( `to_id` mediumint(8) NOT NULL default '0', `from_id` mediumint(8) NOT NULL default '0', `last_sent` int(11) NOT NULL default '0', `total_sent` mediumint(8) default NULL, `code` tinyint(4) default NULL, KEY `to_id` (`to_id`)) DONE.!
CREATE TABLE phpbb_ina_user_data ( `user_id` mediumint(8) NOT NULL default '0', `last_played` varchar(25) default NULL, `last_played_date` int(11) default NULL, `first_places` mediumint(9) default '0', `last_won_date` int(11) default NULL, `at_first_places` mediumint(9) default '0', `user_game_time` int(11) default '0', KEY `user_id` (`user_id`)) DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_cat_image_width', '80') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_cat_image_height', '80') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_tournament_max', '10') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_tournament_games', '6') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_tournament_players', '12') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_moderators_mode', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_posts_required', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_use_pms', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_total_top', '10') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_new_games', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_cat_zero', 'Show all the Games') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_use_comments', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_use_rating', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_show_played', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_show_all', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_no_guests', '0') DONE.!
ALTER TABLE phpbb_ina_games ADD `game_autosize` smallint(1) default NULL DONE.!
ALTER TABLE phpbb_ina_games ADD `date_added` int(11) default '0' DONE.!
ALTER TABLE phpbb_ina_games ADD `rank_required` int(11) default NULL DONE.!
ALTER TABLE phpbb_ina_games ADD `level_required` tinyint(4) default NULL DONE.!
ALTER TABLE phpbb_ina_games CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_sessions CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_scores CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_at_scores CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_cat CHANGE `name` `cat_name` VARCHAR( 100 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_cat CHANGE `desc` `cat_desc` TEXT DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_cat CHANGE `icon` `cat_icon` VARCHAR( 255 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_sessions CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_games CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_scores ADD `time_taken` INT( 11 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_scores CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_at_scores CHANGE `game_name` `game_name` VARCHAR( 50 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_ina_at_scores ADD `time_taken` INT( 11 ) DEFAULT NULL DONE.!
ALTER TABLE phpbb_users ADD `games_block_pm` tinyint(1) NOT NULL default 1 DONE.!
ALTER TABLE phpbb_ina_data ADD `minor` TINYINT(3) default '0' DONE.!
ALTER TABLE phpbb_users CHANGE `user_rank` `user_rank` INT( 11 ) NOT NULL DEFAULT '0' DONE.!
ALTER TABLE phpbb_users CHANGE `user_level` `user_level` TINYINT( 4 ) NOT NULL DEFAULT '0' DONE.!
ALTER TABLE phpbb_ina_sessions ADD `user_win` VARCHAR(25) default 'NORM' DONE.!
ALTER TABLE phpbb_ina_games ADD `group_required` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL DONE.!
ALTER TABLE phpbb_ina_games CHANGE `level_required` `level_required` TINYINT( 4 ) NOT NULL DEFAULT '0' DONE.!
ALTER TABLE phpbb_ina_games CHANGE `group_required` `group_required` MEDIUMINT( 8 ) DEFAULT '0' NOT NULL DONE.!
ALTER TABLE phpbb_ina_games CHANGE `rank_required` `rank_required` INT( 11 ) DEFAULT '0' NOT NULL DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_rate', '1') DONE.!
ALTER TABLE phpbb_ina_fav CHANGE `game_id` `fav_game_id` MEDIUMINT( 9 ) DEFAULT NULL DONE.!
CREATE TABLE phpbb_ina_rate ( `rate_game_name` varchar(50) default NULL, `rate_user_id` mediumint(8) NOT NULL default '0', `rate_user_ip` varchar(8) NOT NULL default '', `rate_point` tinyint(3) unsigned NOT NULL default '0', KEY `rate_game_name` (`rate_game_name`)) DONE.!
CREATE TABLE phpbb_ina_comment ( `comment_id` int(11) unsigned NOT NULL auto_increment, `comment_game_name` varchar(50) default NULL, `comment_user_id` mediumint(8) NOT NULL default '0', `comment_username` varchar(32) default NULL, `comment_user_ip` varchar(8) NOT NULL default '', `comment_time` int(11) unsigned NOT NULL default '0', `comment_text` text, `comment_edit_time` int(11) unsigned default NULL, `comment_edit_count` smallint(5) unsigned NOT NULL default '0', `comment_edit_user_id` mediumint(8) default NULL, `game_name` varchar(50) default NULL, PRIMARY KEY(`comment_id`), KEY `comment_game_name` (`comment_game_name`), KEY `comment_user_id` (`comment_user_id`)) DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_comments', '1') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_mod_ban_users', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_comment_size', '256') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_rank_required', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_pm_highscore', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_pm_at_highscore', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_pm_comment', '0') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_pm_new', '0') DONE.!
ALTER TABLE phpbb_ina_fav ADD `fav_game_name` varchar( 50 ) DEFAULT NULL DONE.!
UPDATE phpbb_ina_fav f, phpbb_ina_games g SET `f.fav_game_name` = `g.game_name` WHERE `g.game_id` = `f.fav_game_id` NOT REQUIRED.!
Unknown column 'f.fav_game_name' in 'field list'
UPDATE phpbb_ina_rate r, phpbb_ina_games g SET `r.rate_game_name` = `g.game_name` WHERE `r.rate_game_id` = `g.game_id` NOT REQUIRED.!
Unknown column 'r.rate_game_name' in 'field list'
UPDATE phpbb_ina_comment c, phpbb_ina_games g SET `c.comment_game_name` = `g.game_name` WHERE `c.comment_game_id` = `g.game_id` NOT REQUIRED.!
Unknown column 'c.comment_game_name' in 'field list'
ALTER TABLE phpbb_ina_scores ADD `gameData` TEXT AFTER `game_name` DONE.!
UPDATE phpbb_ina_data SET version = '2.1.0', minor = '0' DONE.!
ALTER TABLE phpbb_ina_user_data ADD `second_places` MEDIUMINT (9) AFTER `first_places` DONE.!
ALTER TABLE phpbb_ina_user_data ADD `third_places` MEDIUMINT (9) AFTER `second_places` DONE.!
ALTER TABLE phpbb_ina_user_data ADD `at_second_places` MEDIUMINT (9) AFTER `at_first_places` DONE.!
ALTER TABLE phpbb_ina_user_data ADD `at_third_places` MEDIUMINT (9) AFTER `at_second_places` DONE.!
CREATE TABLE `phpbb_ina_highscore` ( `highscore_id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT , `highscore_year` YEAR UNSIGNED NOT NULL , `highscore_mon` TINYINT( 2 ) UNSIGNED NOT NULL , `highscore_game` VARCHAR( 25 ) NOT NULL , `highscore_player` VARCHAR( 40 ) NOT NULL , `highscore_score` DOUBLE( 12, 4 ) UNSIGNED NOT NULL , `highscore_date` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY `highscore_id` ( `highscore_id` ) ) DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('highscore_start_year', '2006') DONE.!
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('highscore_start_mon', '04') DONE.!
UPDATE phpbb_ina_data SET version = '2.1.1' DONE.!
ALTER TABLE phpbb_ina_fav DROP `game_id` NOT REQUIRED.!
Can't DROP 'game_id'; check that column/key exists
INSERT INTO phpbb_config (`config_name`, `config_value`) VALUES ('games_show_fav', '1') DONE.!
ALTER TABLE phpbb_users ADD `arcade_banned` INT DEFAULT '0' DONE.!
UPDATE phpbb_ina_data SET version = '2.1.2' DONE.!

[mariusik88]

am copiat toate astea in sql si nu merg imi zice ca nu poate sa le creeze si eu am tot prefixul phpbb