Game Section 1.2 RC3.2

[Paretje]

File changes
Changed files:
admin/modules/games/games.php
admin/modules/games/version.php
games/templates.php
inc/languages/english/tournaments.lang.php
inc/plugins/games.php
games.php
tournaments.php

Description
Changes since 1.2 RC3.1.1:
- Better control on input from game config with add tar or add simple
- games_play template fix
- Score order fix of new score page
- Champion link of search results fixed
- Changed copyright year to MyBB 1.4 variable
- Version control system now based on plugin information
- Infoboxes tournaments finished
- Fix of redirection when tournament added
- Join system added
- Add tournament system controls now if the user is a guest
- Only show add tournament link, if you aren't a guest
- Show join tournament link only when you have permission and logged-in, and when there is a free place, and when you didn't join already
- Show play link only when play permissions (in order to prevent people playing who had permission to play, but haven't at the moment)

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

Download
New Game Section install:
  games1.2RC3.2.tar.gz (Size: 137,53 KB / Downloads: 972)
Upgrade from 1.2 RC3.1.1:
  games1.2RC3.2_1.2RC3.1.1.tar.gz (Size: 42,12 KB / Downloads: 720)

[Paretje]

Translations for this version:
Currently, there aren't translations yet.

[Paretje]

Zip file (includes the 2 versions!):
  Games.zip (Size: 212,92 KB / Downloads: 400)

Patch file:
  patch.patch (Size: 22,01 KB / Downloads: 340)

[atomjani]

What is the patch.patch file?

[Paretje]

Well, with that file, you can just change your files, instead of replacing them. So it's usefull when you change your files. But, you still have to run the upgrade.php file off course.

[Jockl]

Although I will exchange the files and run the upgrade.php file, I do have a question.

If using the patch-File: I don't know how to use this. Could you please explain?

[Paretje]

In the directory you installed MyBB, run the follow command:

Code:

patch < patch.patch

[Jockl]

aahh...ok! Thank you.

[Rafael]

Have an error when try to run the upgrade.php and I have all the files uploaded.

this is what I have:

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
1050 - Table 'TABLE_PREFIX_games_tournaments_players' already exists
Query:
CREATE TABLE `TABLE_PREFIX_games_tournaments_players` ( `pid` INT(15) NOT NULL AUTO_INCREMENT, `tid` INT(10) NOT NULL, `rid` INT(1) NOT NULL, `uid` INT(10) NOT NULL, `username` VARCHAR(120) NOT NULL, `score` FLOAT NOT NULL, `score_try` INT(2) NOT NULL, `tries` INT(2) NOT NULL, `dateline` BIGINT(30) NOT NULL, PRIMARY KEY (`pid`), KEY `tid` (`tid`), KEY `rid` (`rid`), KEY `uid` (`uid`) ) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

[Rafael]

In the directory you installed MyBB, run the follow command:

Code:

patch < patch.patch

Nice tip