Seite 1 von 1

HELP Arcade mode !?

Verfasst: 30.12.2005 15:07
von r4ven2
hab mir den activity mod 1.1.0 plus von
http://phpbb-amod.com/down_db.php?page=cat&id=14
gezogen
die Installationsanweisungen genauestens befolgt alle dateien edidiert und danach die installation im ACP durchgeführt

Im ACP funktioniert alles einwandfrei ich kann spiele adden und alle Einstellungen
aber wenn ich die spiele im forum aufrufe kommt folgender Fehler :

phpBB : Kritischer Fehler
Sorry, the games are currently offline until the admin upgrades/installs the current version. The current version is 1.1.0. Your version is Unknown.
Instructions
Since you are an admin, please goto your admin panel, you can get there by clicking here. After you do that, please look on the left for Amod+ Admin and under it you will see a link, Db Adjustments. If this is a fresh install for you, please click Install Activity Mod Plus. If you are upgrading from a previous version, please look in the second section, and in the drop down menu and select what you are upgrading from. You are upgrading to 1.1.0. After doing that, this error will go away and you will be allowed to play games.



Die Instructions hab ich aber schon durchgeführt und die haben auch einwandfrei geklappt (geupdatet hab ich nicht is ja schon die version 1.1.0)

das ganze läuft lokal mit xampp (liegt da vielleicht der hund begraben?)

Verfasst: 30.12.2005 18:35
von r4ven2
okay bin schon ein bisschen weiter

hab jetzt die schritte die er eigentlich bein imstallieren vom acp aus macht manuell in die sql eingegeben

danach gabs wieder nen error :D das ganze hat aber anscheinend funktioniert - nur hab ich aber die selben schritte dann noch mal in der sql ausgeführt damit ich die error message nochmal seh und hier posten kann und jetzt steh ich wieder am anfang :-?

ERROR MESSAGE:

MySQL meldet:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE phpbb_users
DROP `ina_last_playtype`, DROP `ina_games_played`, DRO' at line 4


ausgeführter BEFEHL:

Code: Alles auswählen

DROP TABLE IF EXISTS phpbb_ina_data,
phpbb_ina_games,
phpbb_ina_scores,
phpbb_ina_top_scores,
phpbb_ina_ban,
phpbb_ina_cheat_fix,
phpbb_ina_categories,
phpbb_ina_categories_data,
phpbb_ina_challenge_tracker,
phpbb_ina_challenge_users,
phpbb_ina_trophy_comments,
phpbb_ina_sessions,
phpbb_ina_last_game_played,
phpbb_ina_gamble,
phpbb_ina_gamble_in_progress,
phpbb_ina_rating_votes,
phpbb_ina_favorites,
phpbb_ina_hall_of_fame,
phpbb_ina_chat ALTER TABLE phpbb_users DROP `ina_last_playtype` ,
DROP `ina_games_played` ,
DROP `user_trophies` ,
DROP `ina_cheat_fix` ,
DROP `ina_games_today` ,
DROP `ina_last_visit_page` ,
DROP `ina_game_playing` ,
DROP `ina_game_pass` ,
DROP `ina_games_pass_day` ,
DROP `ina_time_playing` ,
DROP `ina_char_name` ,
DROP `ina_char_age` ,
DROP `ina_char_from` ,
DROP `ina_char_intrests` ,
DROP `ina_char_img` ,
DROP `ina_char_gender` ,
DROP `ina_char_ge` ,
DROP `ina_char_name_effects` ,
DROP `ina_char_title_effects` ,
DROP `ina_char_saying_effects` ,
DROP `ina_char_views` ,
DROP `ina_char_title` ,
DROP `ina_char_saying` ,
DROP `ina_settings` DELETE FROM phpbb_config WHERE config_name = 'ina_email_sent' DELETE FROM phpbb_config WHERE config_name = 'ina_rating_reward' DELETE FROM phpbb_config WHERE config_name = 'ina_rating_reward' DELETE FROM phpbb_config WHERE config_name = 'ina_use_logo' DELETE FROM phpbb_config WHERE config_name = 'ina_use_max_games_per_day' DELETE FROM phpbb_config WHERE config_name = 'ina_max_games_per_day' DELETE FROM phpbb_config WHERE config_name = 'ina_version' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_submit_scores_m' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_submit_scores_g' DELETE FROM phpbb_config WHERE config_name = 'ina_trophy_king' DELETE FROM phpbb_config WHERE config_name = 'ina_trophy_king_old' DELETE FROM phpbb_config WHERE config_name = 'ina_use_trophy' DELETE FROM phpbb_config WHERE config_name = 'default_reward_dbfield' DELETE FROM phpbb_config WHERE config_name = 'default_cash' DELETE FROM phpbb_config WHERE config_name = 'use_rewards_mod' DELETE FROM phpbb_config WHERE config_name = 'use_cash_system' DELETE FROM phpbb_config WHERE config_name = 'report_cheater' DELETE FROM phpbb_config WHERE config_name = 'ina_default_order' DELETE FROM phpbb_config WHERE config_name = 'warn_cheater' DELETE FROM phpbb_config WHERE config_name = 'use_point_system' DELETE FROM phpbb_config WHERE config_name = 'use_gamelib' DELETE FROM phpbb_config WHERE config_name = 'games_path' DELETE FROM phpbb_config WHERE config_name = 'gamelib_path' DELETE FROM phpbb_config WHERE config_name = 'use_gk_shop' DELETE FROM phpbb_config WHERE config_name = 'use_allowance_system' DELETE FROM phpbb_config WHERE config_name = 'games_per_page' DELETE FROM phpbb_config WHERE config_name = 'current_ina_date' DELETE FROM phpbb_config WHERE config_name = 'ina_delete' DELETE FROM phpbb_config WHERE config_name = 'ina_default_charge' DELETE FROM phpbb_config WHERE config_name = 'ina_default_increment' DELETE FROM phpbb_config WHERE config_name = 'ina_default_g_path' DELETE FROM phpbb_config WHERE config_name = 'ina_default_g_reward' DELETE FROM phpbb_config WHERE config_name = 'ina_default_g_height' DELETE FROM phpbb_config WHERE config_name = 'ina_default_g_width' DELETE FROM phpbb_config WHERE config_name = 'ina_guest_play' DELETE FROM phpbb_config WHERE config_name = 'ina_button_option' DELETE FROM phpbb_config WHERE config_name = 'ina_post_block' DELETE FROM phpbb_config WHERE config_name = 'ina_post_block_count' DELETE FROM phpbb_config WHERE config_name = 'ina_join_block' DELETE FROM phpbb_config WHERE config_name = 'ina_join_block_count' DELETE FROM phpbb_config WHERE config_name = 'ina_challenge' DELETE FROM phpbb_config WHERE config_name = 'ina_pm_trophy' DELETE FROM phpbb_config WHERE config_name = 'ina_challenge_msg' DELETE FROM phpbb_config WHERE config_name = 'ina_challenge_sub' DELETE FROM phpbb_config WHERE config_name = 'ina_pm_trophy_msg' DELETE FROM phpbb_config WHERE config_name = 'ina_pm_trophy_sub' DELETE FROM phpbb_config WHERE config_name = 'challenges_sent' DELETE FROM phpbb_config WHERE config_name = 'ina_new_game_limit' DELETE FROM phpbb_config WHERE config_name = 'ina_pop_game_limit' DELETE FROM phpbb_config WHERE config_name = 'ina_new_game_count' DELETE FROM phpbb_config WHERE config_name = 'ina_use_newest' DELETE FROM phpbb_config WHERE config_name = 'ina_use_online' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_cheat' DELETE FROM phpbb_config WHERE config_name = 'ina_show_view_profile' DELETE FROM phpbb_config WHERE config_name = 'ina_show_view_topic' DELETE FROM phpbb_config WHERE config_name = 'ina_default_order' DELETE FROM phpbb_config WHERE config_name = 'ina_cash_name' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_top5_page' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_challenges_page' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_gamble_page' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_comments_page' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_trophy_page' DELETE FROM phpbb_config WHERE config_name = 'ina_disable_everything' DELETE FROM phpbb_config WHERE config_name = 'ina_jackpot_pool' DELETE FROM phpbb_config WHERE config_name = 'ina_online_list_color' DELETE FROM phpbb_config WHERE config_name = 'ina_online_list_text' DELETE FROM phpbb_config WHERE config_name = 'ina_max_gamble' DELETE FROM phpbb_config WHERE config_name = 'ina_daily_game_id' DELETE FROM phpbb_config WHERE config_name = 'ina_daily_game_date' DELETE FROM phpbb_config WHERE config_name = 'ina_daily_game_random' DELETE FROM phpbb_config WHERE config_name = 'ina_use_daily_game' DELETE FROM phpbb_config WHERE config_name = 'ina_use_shoutbox' DELETE FROM phpbb_config WHERE config_name = 'ina_force_registration' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_char_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_gender_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_age_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_name_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_from_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_intrests_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_ge_per_game' DELETE FROM phpbb_config WHERE config_name = 'ina_char_ge_per_beat_score' DELETE FROM phpbb_config WHERE config_name = 'ina_char_ge_per_trophy' DELETE FROM phpbb_config WHERE config_name = 'ina_char_show_viewtopic' DELETE FROM phpbb_config WHERE config_name = 'ina_char_show_viewprofile' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_title_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_change_saying_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_char_name_effects_costs' DELETE FROM phpbb_config WHERE config_name = 'ina_char_title_effects_costs' DELETE FROM phpbb_config WHERE config_name = 'ina_char_saying_effects_costs' DELETE FROM phpbb_config WHERE config_name = 'ina_game_pass_cost' DELETE FROM phpbb_config WHERE config_name = 'ina_game_pass_length'

HABT IHR IRGENDEINE IDEE ??????

bitte helft mir bin der verzweiflung nahe denn von der syntax hab ich nicht die geringste Ahnung

Verfasst: 30.12.2005 19:39
von rabbit
hinter den befehlen müssen kommata sein bzw, nach einer befehlskette ein semikolon.

d.h. hiernach kommt ein semikolon:

Code: Alles auswählen

phpbb_ina_chat
und hier auch:

Code: Alles auswählen

DROP `ina_settings`

Verfasst: 30.12.2005 19:46
von r4ven2
So den Mysql eroor hab ich zwar immer noch aber komischerweise
scheint es zur Zeit trotzdem zu funktionieren - (nach etlichen Versuchen die mehr auf Glück als auf Verstand beruhen :lol: )

HÄTTE DAFÜR ABER NE ANDERE FRAGE

-) kann ich zusätzlich zu dem link im overlayheader auch eine forumskategorie erstellen die auf die gamessection verweist anstatt ein forum zu öffnen
-) und wie erstelle ich einen link für ein einzelnes spiel der als topic dargestellt wird aber keines ist?

edit: thx rabbit habs noch nich nach deiner anleitung probiert aberich lass es lieber mal vorsichtshalber so wies is solang keine fehler auftreten