phpBB România

forumul phpBB in limba romana. Opinii, implementari, ajutor, instructiuni si download.
https://phpbb3.ro/community/

Arcade Mod 2.1.3

https://phpbb3.ro/community/viewtopic.php?t=4894

Pagina 1 din 3

Arcade Mod 2.1.3

Scris: 14-Sep-2006, 15:07:26
de 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??

Scris: 14-Sep-2006, 15:15:53
de 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 :D

Scris: 14-Sep-2006, 15:16:27
de 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??

Scris: 14-Sep-2006, 15:16:57
de 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 ....

Scris: 14-Sep-2006, 15:18:26
de 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

Scris: 14-Sep-2006, 15:21:01
de 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 !

Scris: 14-Sep-2006, 15:22:36
de 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:((((((((((((((((((((

Scris: 14-Sep-2006, 15:26:24
de evo_vii
creaza tu singur tabele din baza de date ! in phpmyadmin !

Scris: 14-Sep-2006, 15:26:25
de 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.!

Scris: 14-Sep-2006, 15:40:01
de mariusik88
am copiat toate astea in sql si nu merg imi zice ca nu poate sa le creeze si eu am tot prefixul phpbb
Ora este UTC+03:00
Pagina 1 din 3

Furnizat de phpBB® Forum Software © phpBB Limited

Translation/Traducere: phpBB România