Major Additions - Mindestic Gaming CMS Lite BETA

Important Beta Information
Do NOT use on a live site until the first official stable version is released. This public beta release is for testing and feedback purpose only so do NOT use for normal use. Stable version to be released in 2008 if time allows me to.

Any updates that come in the next few weeks will NOT have any upgrade features and you will need to remove and reinstall the mod again untill the stable version is released.

Thank you for taking the time to test Mindestic Gaming CMS Lite. Please do keep in mind that this is at very early stage of development so there are a TON of features that need to be worked on. I hope to hear from all of you soon.

Mindestic Gaming CMS Lite Description
Mindestic Gaming CMS Lite is an advanced yet simple (at least it will be one day lol!) to use gaming system for your website.

Additional Future CMS Projects
In additionlal to Mindestic Gaming CMS Lite there will be other versions developed at a later date. This inculdes Mindestic Sports CMS Lite, Mindestic Music CMS Lite and Mindestic Movie CMS Lite. No dates have been set at this time.

Mindestic Gaming CMS Lite Information
Current Version Number: 1.0.0 Beta 5
vBulletin Test Version(s): 3.6.0 - 3.6.7
Queries to run: 11
File Edits: 0
New Files: 15
New Phrases: 282
New Templates: 23
New Plugins: 5
Template Edits: 0
Last Edited: June 25, 2007
Edited By: Lucas Pawelczyk
Install Time: 4 minutes
Difficulty: Easy

Next release that was planned is on hold until I get some more time, sorry.

Current Planned Features For Version Beta 6

1. Added ESRB Content Descriptors System. (100% Complete)
2. Add rating system for review system with images. (100% Complete)
3. Added user game rating system. (100% Complete)
4. Added who rated option for user game rating system. (100% Complete)
5. Fixed missing phrases on games list, admincp. (100% Complete)
6. Added mass administration options (delete, move, activate, deactivate) for games section, admin side. (100% Complete)
7. Added MSRP option for new games. (100% Complete)
8. Created additional options in settings to choose currency type. (100% Complete)
9. Added 'Currency Code' and 'Currency' to Orgin settings. Also updated Orgin database to include all currency information. (100% Complete)
10. Added platform abbreviation and small image/icon options. Updated platform database for new additions as well created basic icons. (100% Complete)
11. Add random games display option for game pages. (0% Complete)
12. Add game navbar template for game pages. (0% Complete)
13. Add 'show printable version'/'email this page' options for each game. (0% Complete)
14. Box image upload with current status. (0% Complete)
15. Title image upload with current status. (0% Complete)
16. Small title image upload with current status. (0% Complete)
17. Add basic review system . (75% Complete)
18. Add permissions for review system. (50% Complete)

Future Feature Ideas List

1. Basic and Advanced Search System.
2. Points and Store System.
3. Advertisement System
4. Release Date Calendar System.
5. Game Collections, Wishlist, Tracking System.
6. Game Screenshot System.
7. Game Movie System.
8. Game Message Board System.
9. Game Article, Editorial System.
10. Game Cheats System.
11. Game News System.
12. Game Previews System.
13. Front Page Portal Page System.

Screenshots And Change Log

1. Screenshots For Beta Version
2. Screenshots For Beta 3 Version
3. Screenshots For Beta 5 Version

[Bravo]

Is it possible to add it so that mods can add games and all that stuff from the modcp?

[ngocha85]

27/8/2007.
My Happy day.

[jgommel]

I did a brand new installation, but I too received the database error that I was missing the mindesticgcms_game table. I checked the database and sure enough, that was the only table missing.

Database error in vBulletin 3.6.8:

Invalid SQL:


        SELECT COUNT(*) AS games
        FROM vb_mindesticgcms_game AS game
        WHERE 1=1;

MySQL Error  : Table 'neosmutc_neosmutdb.vb_mindesticgcms_game' doesn't exist
Error Number : 1146
Date         : Sunday, August 26th 2007 @ 04:11:08 PM
Script       : http://www.neosmut.com/vb/games.php
Referrer     : 
IP Address   : 76.188.204.236
Username     : RodentX
Classname    : vb_database

I ended up having to add the missing table and rows manually... so far so good.

$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game (
    gameid int(11) NOT NULL auto_increment,
    gamename varchar(255) NOT NULL default '',
    gameusername varchar(50) default NULL,
    gameuserid int(10) unsigned NOT NULL default '0',
    gamelastupdate int(10) unsigned NOT NULL default '0',
    gamedateline int(10) unsigned NOT NULL default '0',
    gamereleasedate int(10) unsigned NOT NULL default '0',
    gameplatformid smallint(5) unsigned NOT NULL default '0',
    gamevalid int(10) NOT NULL default '1',
    gameviews int(10 NOT NULL default '0',
    gamedescription text NOT NULL,
    gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gameeditusername VARCHAR( 50 ) DEFAULT '' NULL,
    gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
    gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gamegenreid smallint(5) unsigned NOT NULL default '0',
    gamemediumid smallint(5) unsigned NOT NULL default '0',
    gameorginid smallint(5) unsigned NOT NULL default '0',
    gameplayerid smallint(5) unsigned NOT NULL default '0',
    gamedeveloperid smallint(5) unsigned NOT NULL default '0',
    gamepublisherid smallint(5) unsigned NOT NULL default '0',
    gameesrbid smallint(5) unsigned NOT NULL default '0',
    gamemultiplayid smallint(5) unsigned NOT NULL default '0',
    PRIMARY KEY  (gameid)
) TYPE=MyISAM");

[JVCode]

I've subscribed to this mod also, can't wait for a stable release for 3.6.8 as the current Beta 5 throws back an SQL error.. *sigh* loving the work done so far, this mod seems like a great addition to any gaming website, can't wait to have it as a main feature on my gaming website.

[JVCode]

BUMP! Someone please fix the SQL error and re-upload the files, i'm dieing to use this MOD.

[JVCode]

Bump..

[Luky]

Must you be so darn impatient?! Its BETA anyway. BETA summarised means not complete, so don't use on a public board unless you like bugs, security exploits and lack of support.

[JVCode]

You could say i'm eager yes, and i'm not bothered about having it hosted on a public site either! this is the sort of hack i've been looking for, for ages! If there are any others out there like this, someone please point me in the right direction.

[Bravo]

Originally Posted by JVCode

BUMP! Someone please fix the SQL error and re-upload the files, i'm dieing to use this MOD.

What SQL errors?

[JVCode]

Originally Posted by jgommel

I did a brand new installation, but I too received the database error that I was missing the mindesticgcms_game table. I checked the database and sure enough, that was the only table missing.

Database error in vBulletin 3.6.8:

Invalid SQL:


        SELECT COUNT(*) AS games
        FROM vb_mindesticgcms_game AS game
        WHERE 1=1;

MySQL Error  : Table 'neosmutc_neosmutdb.vb_mindesticgcms_game' doesn't exist
Error Number : 1146
Date         : Sunday, August 26th 2007 @ 04:11:08 PM
Script       : http://www.neosmut.com/vb/games.php
Referrer     : 
IP Address   : 76.188.204.236
Username     : RodentX
Classname    : vb_database

I ended up having to add the missing table and rows manually... so far so good.

$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_game (
    gameid int(11) NOT NULL auto_increment,
    gamename varchar(255) NOT NULL default '',
    gameusername varchar(50) default NULL,
    gameuserid int(10) unsigned NOT NULL default '0',
    gamelastupdate int(10) unsigned NOT NULL default '0',
    gamedateline int(10) unsigned NOT NULL default '0',
    gamereleasedate int(10) unsigned NOT NULL default '0',
    gameplatformid smallint(5) unsigned NOT NULL default '0',
    gamevalid int(10) NOT NULL default '1',
    gameviews int(10 NOT NULL default '0',
    gamedescription text NOT NULL,
    gameipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gameeditusername VARCHAR( 50 ) DEFAULT '' NULL,
    gameedituserid INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL,
    gameeditipaddress VARCHAR( 15 ) DEFAULT '' NOT NULL,
    gamegenreid smallint(5) unsigned NOT NULL default '0',
    gamemediumid smallint(5) unsigned NOT NULL default '0',
    gameorginid smallint(5) unsigned NOT NULL default '0',
    gameplayerid smallint(5) unsigned NOT NULL default '0',
    gamedeveloperid smallint(5) unsigned NOT NULL default '0',
    gamepublisherid smallint(5) unsigned NOT NULL default '0',
    gameesrbid smallint(5) unsigned NOT NULL default '0',
    gamemultiplayid smallint(5) unsigned NOT NULL default '0',
    PRIMARY KEY  (gameid)
) TYPE=MyISAM");

This...