MyBB Community Forums

Full Version: Game Section
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
:O!
Ahh, thanks then lol
There is a syntax error in database.
Try to delete tha table in database and reinstall the plugin!
best plugin EVA! thank you!!
(2008-11-30, 11:06 PM)Gordie Wrote: [ -> ]Everything was working fine until I added a game to My Favorites. Now I get this error when I go to games.php
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

I'll look for it Wink

@spinning: What error do you get now? Still the first? Remove then the gamesession field of the mybb_session table.

@Everybody that asked where to download games: you can download these days 25 games a day at http://community.gamesection.org
Game Section 1.2 RC2 is released!
Changes since 1.2 RC1:
- MyBB Who's online bug fixed
- ACP: Version Control system bug fixed
- ACP: Recount champions when score_type is changed
- Bug with settings is fixed
- Possibility to select the wanted category using Add Game (Tar)
- Credits page updated
- games_tournaments.lang.php is renamed to tournaments.lang.php
- tar library replaced from inc/tar to inc/3rdparty/tar
- Theme setting bug fixed
- active fields updated from yes-no to 1-0
- Language variables fixed
- Spinning added when refreshing Random game
- Spinning added when search game to create a tournament
- Rate system updated to the new AJAX system
- Repair and Recount Ratings tool updated
- System for multiple queries is deleted
- Fixed bug with editing a game
- Categories and default page is purged
- Random games can now handle categories from the refresh function, too
- Fixed bug cat specific stats
- Updated Who's online system of the Game Section for compatibility with the spiders database

NOTE: I forgot to include arcade.php in RC1. arcade.php is needed to add a vBulletin v3 game score.
It's included in RC2, now.


Changes since 1.1.9:
- Overviewed/rewritten code
- Tournaments UNFINISHED
- Support for many game systems
- Less queries for the user statistics
- Most played games (in stats)
- Players with most champions (in stats)
- Advanced version of the last new champions (Option in menu) - all champions changes (with cache)
- Favourites
- Last played
- Advanced who's online
- Category picture
- Number of games in category
- New system to show the categories
- New settings system
- Search system in ACP
- Control games (warning when adding the same game)
- Choise between 1 large query and 3 less queries
- Category in games overview (AdminCP)
- Added date in games overview (AdminCP)
- Searchbar on the page with your search results
- Compatibility with edit, merge and delete of users
- Possibility to view statistics of the category
- Random games with refresh button (AJAX)
- Compatible with MySQL strict
- Updated rate system
- Compatibility of Who's online system with bots database

More information
wow.. I never even noticed this Big Grin I'm gonna use it now!
in function games_users_merge() (inc/plugins(games.php)
Line 659, you may want to add $db to your globals (currently you have $source_user, $destination_user).
You should get an error once the line 671 is reached ($db->update_query("games_champions", $user_update, "uid='".$source_user['uid']."'")Wink
(2008-12-28, 07:11 PM)Pirata Nervo Wrote: [ -> ]in function games_users_merge() (inc/plugins(games.php)
Line 659, you may want to add $db to your globals (currently you have $source_user, $destination_user).
You should get an error once the line 671 is reached ($db->update_query("games_champions", $user_update, "uid='".$source_user['uid']."'")Wink

was that to me? O.o
No, it was to the author of the plugin Toungue
Blush ok sorry