settings error

[upthevale]

Whenever a user edits the game section settings. and then hits save. they then cant get into the game seciton..

as they are presented with this following error

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
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 'LIMIT 0,20' at line 10
Query:
SELECT DISTINCT g.gid, g.title, g.name, g.description, g.played, g.lastplayed, g.lastplayedby, g.rating, g.dateline, c.username, c.score, f.fid, r.rid, s.score AS pscore, u.username AS lastplayedusername FROM mybb_games g LEFT JOIN mybb_games_champions c ON (g.gid=c.gid) LEFT JOIN mybb_games_favourites f ON (g.gid=f.gid AND f.uid='1') LEFT JOIN mybb_games_rating r ON (g.gid=r.gid AND r.uid='1') LEFT JOIN mybb_games_scores s ON (g.gid=s.gid AND s.uid='1') LEFT JOIN mybb_users u ON (g.lastplayedby=u.uid) WHERE g.active='yes' ORDER BY g. LIMIT 0,20

[eneR]

Hi,

the same error too!
You must edit manualy your database (mybb_user) 2 settings from nothing to zero. don

[upthevale]

ok cheers

[ryansstuff]

Right how do i disable that setting? the setting-menu how do i get that not showed?

[eneR]

only i have deleted the link from the template.
Look in the templates from the gamesection, than you find this.

[Paretje]

The default settings of the users has to be zero, that's right.

[bombbob]

Can somebody please explain clearly how to sort this SQL error out, and how to disable the settings menu?

Cheers.

[Paretje]

Maybe it's better to warn your users about this bug in the software.

Otherwise open games.php and find:

PHP Code:

        //Test user
        if($mybb->user['uid'] == 0)
        {
            error_no_permission();
        }
        elseif($mybb->usergroup['canusercp'] == "no")
        {
            error_no_permission();
        } 


Before add:

PHP Code:

        //Stop the program and explain why
        die("This section is temporally closed because of a bug which makes the Game Section unusable."); 


[Paretje]

I've fixed this bug, so you don't have to close this anymore

Open games/global.php and find:

PHP Code:

    if($mybb->user['games_sortby'] == "0")
    {
        $sortby = $games_core->settings['sortby'];
    }
    else
    {
        $sortby = $mybb->user['games_sortby'];
    }
    
    if($mybb->user['games_order'] == "0")
    {
        $order = $games_core->settings['order'];
    }
    else
    {
        $order = $mybb->user['games_order'];
    } 


Replace with:

PHP Code:

    if($mybb->user['games_sortby'] == 0)
    {
        $sortby = $games_core->settings['sortby'];
    }
    else
    {
        $sortby = $mybb->user['games_sortby'];
    }
    
    if($mybb->user['games_order'] == 0)
    {
        $order = $games_core->settings['order'];
    }
    else
    {
        $order = $mybb->user['games_order'];
    }