Game Section 1.2 RC4

[Paretje]

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

Added files:
inc/tasks/tournamentstatus.php

Description
Changes since 1.2 RC3.2:
- Add Game (Simple) redirection to gamedata fixed
- Task created to change the status of the tournaments
- View system fixed
- dateline of players table not filled when joining
- Tournament Options added to Game Section Settings
- Run the task in practice only when the tournament system is activated
- Maxplayers field deleted
- Code to add session information of the tournament added
- The score system is added

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.2RC4.tar.gz (Size: 138,62 KB / Downloads: 188)
Upgrade from 1.2 RC3.2:
  games1.2RC4_1.2RC3.2.tar.gz (Size: 44,22 KB / Downloads: 95)

[Paretje]

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

For translators who started their translation already, this file contains the changes between RC3.2 and RC4:
  patch.patch (Size: 2,9 KB / Downloads: 4)

[Paretje]

Zip file (includes the 2 versions!):
  Games.zip (Size: 224,32 KB / Downloads: 31)

[Paretje]

MyBB 1.6 Version
This Game Section works perfectly in MyBB 1.6. You only have to do this change:
Open inc/plugins/games.php and find:

PHP Code:

        "compatibility" => "14*" 


Replace with:

PHP Code:

        "compatibility" => "16*" 


[ethernet]

thanks for making sure its compatible with mybb 1.6, i am in the process of porting and testing my plugin at 1.6 and glad to see other users have done this too

i will be using this plugin once mybb 1.6 is offical released

great job

[rodstands]

I keep getting this error when I install a new game.....

Code:

Your copy of MyBB running on Big Ez's World (http://bigezworld.com) has experienced an error. Details of the error include:
---
Type: 2
File: inc/functions.php (Line no. 164)
Message
require_once(/hsphere/local/home/hillbillyangler/bigezworld.com/inc/db_.php): failed to open stream: No such file or directory

33 games , 33 errors , this a fresh install on mybb version 1.4.11. I cannot find such a table in my database nor is there any file of this name in my system or the game software. Please Advise , thanks in advance.....

[Paretje]

OK, what PHP version are you (rodstands and Twitchin Kitten)?
What database software +version?
What server software (Apache, ...)

[Twitchin Kitten]

Ha ha, Paretje, I know who rodstands is! He's even hosted on the same company I am so my answer should suffice for both of us.

I copied this off the page in phpmyadmin for you.

Apache/1.3.37 (Unix) PHP/5.2.6 mod_throttle/3.1.2 mod_psoft_traffic/0.2 mod_ssl/2.8.28 OpenSSL/0.9.8b
MySQL client version: 5.0.41
PHP extension: mysql

At first I was thinking an error in your code but then I realized everyone would be getting that error.

---

Well I upgraded and I got the same results. An error and the same one.

Code:

Type: 2
File: inc/functions.php (Line no. 164)
Message
require_once(/hsphere/local/home/xxxxxxxx/twitchinkitten.com/inc/db_.php): failed to open stream: No such file or directory

Why does it keep calling for a file that does not exist? That's what's puzzling.

[Susanne]

I get this

PHP Code:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1146 - Table 'DB439279.mybb_games_tournaments_players' doesn't exist
Query:
SELECT DISTINCT t.tid, t.gid, g.title, g.name FROM mybb_games_tournaments_players p LEFT JOIN mybb_games_tournaments t ON (p.tid=t.tid) LEFT JOIN mybb_games g ON (t.gid=g.gid) WHERE p.uid='1' AND t.status='started' AND g.active='1 ORDER BY t.dateline DESC 


Why don't I have that "mybb_games_tournaments_players"? And how should I add it?

---

Add:
Well, I just get it if I say YES to tournaments.

[Paretje]

(10-02-2010 23:08)Twitchin Kitten Wrote:  Ha ha, Paretje, I know who rodstands is! He's even hosted on the same company I am so my answer should suffice for both of us.

I copied this off the page in phpmyadmin for you.

Apache/1.3.37 (Unix) PHP/5.2.6 mod_throttle/3.1.2 mod_psoft_traffic/0.2 mod_ssl/2.8.28 OpenSSL/0.9.8b
MySQL client version: 5.0.41
PHP extension: mysql

At first I was thinking an error in your code but then I realized everyone would be getting that error.

---

Well I upgraded and I got the same results. An error and the same one.

Code:

Type: 2
File: inc/functions.php (Line no. 164)
Message
require_once(/hsphere/local/home/xxxxxxxx/twitchinkitten.com/inc/db_.php): failed to open stream: No such file or directory

Why does it keep calling for a file that does not exist? That's what's puzzling.

That's the problem, that's the MyBB Code, so I don't understand why you have that problem with my code, and not with the complete MyBB software ...

OK, but now I'm confused. I can be wrong, but I think you still din't answer exactly WHERE you get the problem, in what part of the Game Section? You said it's not DURING the upgrade, so I started to think you got the error in the Game System front end, but I see it's just working. S, is it then occuring in the ACP?