[ABD] phpBB Arcade 1.0.RC10

Any abandoned MODs will be moved to this forum.

WARNING: MODs in this forum are not currently being supported or maintained by the original MOD author. Proceed at your own risk.
Forum rules
IMPORTANT: MOD Development Forum rules

WARNING: MODs in this forum are not currently being supported nor updated by the original MOD author. Proceed at your own risk.
User avatar
Blackmore
Registered User
Posts: 18
Joined: Thu Dec 25, 2008 10:03 am

Re: [RC] phpBB Arcade 1.0.RC7

Post by Blackmore » Mon Feb 23, 2009 9:09 am

If a user wants to register this is the forum showing:
SQL ERROR [ mysqli ]

Field 'user_arcade_permissions' doesn't have a default value [1364]
I've checked the edits in the functions_user.php but it still doesn't work.
Can anyone help me?

PS: I made this: http://www.phpbb.com/kb/article/doesnt- ... ue-errors/ but it still doesnt work.
Cheers,
Blackmore

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Mon Feb 23, 2009 7:57 pm

Blackmore wrote:If a user wants to register this is the forum showing:
SQL ERROR [ mysqli ]

Field 'user_arcade_permissions' doesn't have a default value [1364]
I've checked the edits in the functions_user.php but it still doesn't work.
Can anyone help me?

PS: I made this: http://www.phpbb.com/kb/article/doesnt- ... ue-errors/ but it still doesnt work.
The only reason for this is that functions_user.php is not edited correctly.

Tuxman
Registered User
Posts: 420
Joined: Sun Jun 08, 2003 6:24 pm
Location: Germany
Contact:

Re: [RC] phpBB Arcade 1.0.RC7

Post by Tuxman » Thu Feb 26, 2009 8:19 pm

For some reason I can't submit score in my arcade anymore... all newly installed games return a blank page?
I haven't touched anything, installed them from origon.dk...
[ randomly phpBBing ]

killerz11
Registered User
Posts: 10
Joined: Sun May 20, 2007 3:19 am

Re: [RC] phpBB Arcade 1.0.RC7

Post by killerz11 » Thu Feb 26, 2009 9:48 pm

I have a lot of games that are unsorted because I didn't notice you can enter the URL to download games, and after the page loads and you can download games by certain categories, so for example i can now download a lot of games under "puzzle" and upload them then add them all to "puzzle". Is there anyway to auto synchronize my current games with the categories on this other place "http://igames.origon.dk/forum"?

edit: and when im on htat downloads page, and tell it to hide installed games, the page shows the first 50 but hides installed ones (obviously) so it may online show 5 on the page if i have 45 installed. that means i have to go through each page to find uninstalled ones, what would be the chance for you to change it so it shows the first 50 uninstalled ones on a page, so it just ignores installed ones?

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 12:27 am

killerz11 wrote:I have a lot of games that are unsorted because I didn't notice you can enter the URL to download games, and after the page loads and you can download games by certain categories, so for example i can now download a lot of games under "puzzle" and upload them then add them all to "puzzle". Is there anyway to auto synchronize my current games with the categories on this other place "http://igames.origon.dk/forum"?

edit: and when im on htat downloads page, and tell it to hide installed games, the page shows the first 50 but hides installed ones (obviously) so it may online show 5 on the page if i have 45 installed. that means i have to go through each page to find uninstalled ones, what would be the chance for you to change it so it shows the first 50 uninstalled ones on a page, so it just ignores installed ones?
There is no way to sync the games between sites. I have no plans to implement such a feature as it would probably kill Origon's server.

The other problem you are describing is by design. To do what you ask would also place a huge strain on the hosting server.

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 12:30 am

Tuxman wrote:For some reason I can't submit score in my arcade anymore... all newly installed games return a blank page?
I haven't touched anything, installed them from origon.dk...
Do the all old games still work? When I am having scoring issues I usually use http://www.fiddlertool.com/ to see if the games are missing any files.

Tuxman
Registered User
Posts: 420
Joined: Sun Jun 08, 2003 6:24 pm
Location: Germany
Contact:

Re: [RC] phpBB Arcade 1.0.RC7

Post by Tuxman » Fri Feb 27, 2009 12:50 am

edit:
Yep, the other games still work...

How to use that tool?
[ randomly phpBBing ]

starwar
Registered User
Posts: 99
Joined: Tue Nov 21, 2006 7:22 pm

Re: [RC] phpBB Arcade 1.0.RC7

Post by starwar » Fri Feb 27, 2009 5:02 am

I got this error everytime I submit in ACP.
pls help me
General Error
SQL ERROR [ mysql4 ]

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 '/Clear arcade permissions if (!class_exists('auth_arcade')) { global , , ' at line 4 [1064]

SQL

UPDATE phpbb_users SET user_permissions = '', user_perm_from = 0 //Clear arcade permissions if (!class_exists('auth_arcade')) { global , , ; include_once( . 'includes/arcade/arcade_constants.' . ); include_once( . 'includes/auth_arcade.' . ); } = new auth_arcade(); ();

BACKTRACE

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

FILE: includes/auth.php
LINE: 527
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 276
CALL: auth->acl_clear_prefetch()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

Mr_makaveli
Registered User
Posts: 1159
Joined: Sun Oct 26, 2008 3:34 pm

Re: [RC] phpBB Arcade 1.0.RC7

Post by Mr_makaveli » Fri Feb 27, 2009 7:13 am

Colours:

Id like to change the colour of the high scorers, new games, statistics etc (pretty much everything blue)

what files do i need to edit?
www.tgzforum.com, a new forum for all types of people

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 2:19 pm

Tuxman wrote:edit:
Yep, the other games still work...

How to use that tool?
Basically you install the program. Open you web browser and get ready to play the game, just do not click the link to play yet. Then open the fiddlertool and then go back to the browser and click play. Once you are finished check back at the fiddlertool and you will see any errors in red.

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 2:21 pm

Mr_makaveli wrote:Colours:

Id like to change the colour of the high scorers, new games, statistics etc (pretty much everything blue)

what files do i need to edit?
All the template files. Any then modify the function in the arcade class file that displays the usernames as it displays the users group color.

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 2:22 pm

starwar wrote:I got this error everytime I submit in ACP.
pls help me
General Error
SQL ERROR [ mysql4 ]

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 '/Clear arcade permissions if (!class_exists('auth_arcade')) { global , , ' at line 4 [1064]

SQL

UPDATE phpbb_users SET user_permissions = '', user_perm_from = 0 //Clear arcade permissions if (!class_exists('auth_arcade')) { global , , ; include_once( . 'includes/arcade/arcade_constants.' . ); include_once( . 'includes/auth_arcade.' . ); } = new auth_arcade(); ();

BACKTRACE

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

FILE: includes/auth.php
LINE: 527
CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 276
CALL: auth->acl_clear_prefetch()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
You made a mistake editing the auth.php file.

Tuxman
Registered User
Posts: 420
Joined: Sun Jun 08, 2003 6:24 pm
Location: Germany
Contact:

Re: [RC] phpBB Arcade 1.0.RC7

Post by Tuxman » Fri Feb 27, 2009 2:29 pm

Fiddler doesn't show my any errors, so obviously no file is missing..
[ randomly phpBBing ]

User avatar
JRSweets
Registered User
Posts: 2047
Joined: Wed Apr 14, 2004 8:37 pm
Location: Massachusetts

Re: [RC] phpBB Arcade 1.0.RC7

Post by JRSweets » Fri Feb 27, 2009 3:26 pm

Could you provide a link to a couple of these games. Any game I have tried is working correctly.

Tuxman
Registered User
Posts: 420
Joined: Sun Jun 08, 2003 6:24 pm
Location: Germany
Contact:

Re: [RC] phpBB Arcade 1.0.RC7

Post by Tuxman » Fri Feb 27, 2009 3:30 pm

To these used on my board?
Well, submitting score for guests is disabled...

http://forum.gamersirc.net/arcade.php

All recent games starting with "Stairfall 2" can't submit score. I don't get an error message in the ACP either.
[ randomly phpBBing ]

Locked

Return to “[3.0.x] Abandoned MODs”