[ABD] phpBB Arcade 2.0.RC5

[NiceM]

What document are you talking about?

[sited.tk]

What document are you talking about?

License to use/distribute/modify.

[keith10456]

See in my sig

NiceM, I already visited your site, but I didn't find there any games developer's document that authorizes to freely distribute them with or without modifications. Am I wrong?
Also, I binary compared some of your downloadable game and they didn't match original ones (downloaded from developer's site), and again I did not find any developer's document that authorizes to modify his/her .swf. Am I wrong?

Here's an idea... Don't use them then

[sited.tk]

See in my sig

NiceM, I already visited your site, but I didn't find there any games developer's document that authorizes to freely distribute them with or without modifications. Am I wrong?
Also, I binary compared some of your downloadable game and they didn't match original ones (downloaded from developer's site), and again I did not find any developer's document that authorizes to modify his/her .swf. Am I wrong?

Here's an idea... Don't use them then

Actually I don't use them because I cannot use them and I don't wanna use them, if I'm not sure about their "nature"
But please, believe me, I'm not here to judge your choice or the like; I just expressed my opinion about a feature I think phpBB Arcade should have and why it should. If you all think that is not so, then stop; I'll write the code I need by myself. That's all.

[keith10456]

When I go to arcade.php I'm receiving the following error:

Code: Select all

SQL ERROR [ mysql4 ]

Got error 28 from storage engine [1030]

SQL

SELECT COUNT(g.game_id) AS total_wins, u.user_id, u.username, u.user_colour, u.user_avatar, u.user_avatar_type FROM (phpbb_arcade_games g) LEFT JOIN phpbb_users u ON (g.game_highuser = u.user_id) WHERE u.user_type IN (0, 3) GROUP BY u.user_id, u.username, u.user_colour, u.user_avatar, u.user_avatar_type ORDER BY total_wins DESC LIMIT 10

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: arcade/includes/cache.php
LINE: 151
CALL: dbal->sql_query_limit()

FILE: arcade/includes/class.php
LINE: 118
CALL: arcade_cache->obtain_arcade_leaders()

FILE: arcade/includes/class.php
LINE: 79
CALL: arcade->set_data()

FILE: arcade.php
LINE: 63
CALL: arcade->arcade()

[keith10456]

When I go to arcade.php I'm receiving the following error:

Code: Select all

SQL ERROR [ mysql4 ]

Got error 28 from storage engine [1030]

SQL

SELECT COUNT(g.game_id) AS total_wins, u.user_id, u.username, u.user_colour, u.user_avatar, u.user_avatar_type FROM (phpbb_arcade_games g) LEFT JOIN phpbb_users u ON (g.game_highuser = u.user_id) WHERE u.user_type IN (0, 3) GROUP BY u.user_id, u.username, u.user_colour, u.user_avatar, u.user_avatar_type ORDER BY total_wins DESC LIMIT 10

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: includes/db/mysql.php
LINE: 222
CALL: dbal_mysql->sql_query()

FILE: includes/db/dbal.php
LINE: 170
CALL: dbal_mysql->_sql_query_limit()

FILE: arcade/includes/cache.php
LINE: 151
CALL: dbal->sql_query_limit()

FILE: arcade/includes/class.php
LINE: 118
CALL: arcade_cache->obtain_arcade_leaders()

FILE: arcade/includes/class.php
LINE: 79
CALL: arcade->set_data()

FILE: arcade.php
LINE: 63
CALL: arcade->arcade()

Disregard this. It was my hosts' fault.

[LordGabriel]

After the last update, I get this error while trying to update with install/index.php (the final step, I already done every other edit from the update_1.0.0-2.0.RC1.xml):

[phpBB Debug] PHP Notice: in file /install/index.php on line 1625: Undefined index: REQUIREMENTS_UPDATE_TITLE
[phpBB Debug] PHP Notice: in file /install/index.php on line 1626: Undefined index: REQUIREMENTS_UPDATE_EXPLAIN

How can I solve this?

EDIT: found the problem and fixed just by updating the language files.

[sleevedbiker]

I updated from 1.0.0 but when i go to install, go through the steps of updating, I then click update and i get the following sql error....

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_arcade_permissions' in 'field list' [1054]

SQL

SELECT user_id, user_arcade_permissions, user_arcade_perm_from, user_arcade_pm, games_per_page, games_sort_dir, games_sort_order FROM phpbb_users ORDER BY user_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: install/install_update.php
LINE: 153
CALL: dbal_mysql->sql_query()

FILE: install/install_update.php
LINE: 72
CALL: install_update->update()

FILE: install/index.php
LINE: 263
CALL: install_update->main()

FILE: install/index.php
LINE: 112
CALL: module->load()

[KillBill.]

I updated from 1.0.0 but when i go to install, go through the steps of updating, I then click update and i get the following sql error....

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_arcade_permissions' in 'field list' [1054]

SQL

SELECT user_id, user_arcade_permissions, user_arcade_perm_from, user_arcade_pm, games_per_page, games_sort_dir, games_sort_order FROM phpbb_users ORDER BY user_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: install/install_update.php
LINE: 153
CALL: dbal_mysql->sql_query()

FILE: install/install_update.php
LINE: 72
CALL: install_update->update()

FILE: install/index.php
LINE: 263
CALL: install_update->main()

FILE: install/index.php
LINE: 112
CALL: module->load()

interesting, it is missing user_arcade_permissions column.

You run this command in phpmyadmin.
The phpbb_ prefix to replace what you use.

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_arcade_permissions` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

[sleevedbiker]

interesting, it is missing user_arcade_permissions column.

You run this command in phpmyadmin.
The phpbb_ prefix to replace what you use.

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_arcade_permissions` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;

that executed successfully but then i got this error when running the update install folder....

Code: Select all

General Error
SQL ERROR [ mysql4 ]

Unknown column 'user_arcade_perm_from' in 'field list' [1054]

SQL

SELECT user_id, user_arcade_permissions, user_arcade_perm_from, user_arcade_pm, games_per_page, games_sort_dir, games_sort_order FROM phpbb_users ORDER BY user_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 175
CALL: dbal->sql_error()

FILE: install/install_update.php
LINE: 153
CALL: dbal_mysql->sql_query()

FILE: install/install_update.php
LINE: 72
CALL: install_update->update()

FILE: install/index.php
LINE: 263
CALL: install_update->main()

FILE: install/index.php
LINE: 112
CALL: module->load()

So I added

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_arcade_perm_from` mediumint(8) DEFAULT '0' NOT NULL;

than it said

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'user_arcade_pm' in 'field list' [1054]

so i added

Code: Select all

ALTER TABLE `phpbb_users` ADD `user_arcade_pm` tinyint(1) NOT NULL default '1';

Now I receive

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'games_per_page' in 'field list' [1054]

and when I try to add

Code: Select all

ALTER TABLE `phpbb_users` ADD `games_per_page` smallint(4) unsigned NOT NULL default '0';

I get this message from the phpmyadmin

Error
SQL query:

ALTER TABLE `phpbb_users` ADD `games_per_page` SMALLINT( 4 ) UNSIGNED NOT NULL DEFAULT '0'

MySQL said:

#1060 - Duplicate column name 'games_per_page'

So, I re-ran the update file for the arcade it now sees the 'games_per_page' SQL and now tells me

Code: Select all

SQL ERROR [ mysql4 ]

Unknown column 'games_sort_dir' in 'field list' [1054]

And Added

Code: Select all

ALTER TABLE `phpbb_users` ADD `games_sort_dir` char(1) collate utf8_bin NOT NULL default 'a';

then

Code: Select all

QL ERROR [ mysql4 ]

Unknown column 'games_sort_order' in 'field list' [1054]

added

Code: Select all

ALTER TABLE `phpbb_users` ADD `games_sort_order` char(1) collate utf8_bin NOT NULL default 'n';

Now this is where I am currently at... after running the update install folder again I now get

Code: Select all

SQL ERROR [ mysql4 ]

Duplicate entry 'arcade_startdate' for key 1 [1062]

SQL

INSERT INTO phpbb_arcade_config (config_name, config_value, is_dynamic) VALUES ('arcade_startdate', 1291252627, 0)

(the reason I am going through this step by step is to make sure I am adding the correct SQL)

also, all the arcade options in the ACP under the Arcade tag are now gone. Seems like something got really messed up when i first used the install(update) folder. I am hoping I wont have to re-add over 4000 games to categories again.

[KillBill.]

Since you have a half-finished updating
Rather, I will send private message you a revised update file.

[bobocop]

I'm confused here, is this release ok to do a new install on phpbb's new release (3.0.9) ?

Thanks KillBill and NiceM for keeping this going ( I completely lost my other site and am trying to reinstall everything from scratch ) I'm glad i saved all the games i downloaded from igames.origon.dk Thanks.

* removed *

[keith10456]

I'm confused here, is this release ok to do a new install on phpbb's new release (3.0.9) ?

Yes.

[mistycat]

Just done a new install of forum, and have added the arcade, but when verifying am told some files not edited? But I have made the edits on these files, any ideas?

The following files seem to not be edited:

phpbb_root_path/styles/prosilver/template/overall_header.html
<!-- IF S_ARCADE_FB -->
<meta property="og:site_name" content="{SITENAME}" />
<meta property="og:title" content="{ARCADE_FB_GN}" />
<meta property="og:image" content="{ARCADE_FB_GI}" />
<!-- ENDIF -->


phpbb_root_path/styles/prosilver/template/overall_header.html
<!-- IF S_IN_ARCADE -->
<link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
<!-- ENDIF -->


phpbb_root_path/styles/prosilver/template/simple_header.html
<!-- IF S_IN_ARCADE -->
<link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
<!-- ENDIF -->


phpbb_root_path/styles/prosilver_se/template/overall_header.html
<!-- IF S_ARCADE_FB -->
<meta property="og:site_name" content="{SITENAME}" />
<meta property="og:title" content="{ARCADE_FB_GN}" />
<meta property="og:image" content="{ARCADE_FB_GI}" />
<!-- ENDIF -->
phpbb_root_path/styles/prosilver_se/template/overall_header.html
<!-- IF S_IN_ARCADE -->
<link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
<!-- ENDIF -->


phpbb_root_path/styles/prosilver_se/template/simple_header.html
<!-- IF S_IN_ARCADE -->
<link href="{T_THEME_PATH}/arcade.css" rel="stylesheet" type="text/css" media="screen, projection" />
<!-- ENDIF -->Checking if all modules exist:All modules found

[keith10456]

Did you upload the edited files?

Also, be sure to edit the files of the style you're using (and upload them).


Note: As with any mod installation, be sure to make a back-up of your forum's files and database before you install the mod.