Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.6 > vBulletin 3.6 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Mindestic Gaming CMS Lite BETA Details »»
Mindestic Gaming CMS Lite BETA
Version: Beta 5, by SS9267547 SS9267547 is offline
Developer Last Online: Jun 2009 Show Printable Version Email this Page

Category: Major Additions - Version: 3.6.7 Rating:
Released: 01-27-2007 Last Update: 06-25-2007 Installs: 44
DB Changes Uses Plugins Template Edits
Additional Files Is in Beta Stage  
No support by the author.

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

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #112  
Old 11-04-2007, 12:30 PM
oninuva oninuva is offline
 
Join Date: May 2006
Location: USA
Posts: 388
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This still under dev? It is very interesting.
Reply With Quote
  #113  
Old 11-05-2007, 08:40 AM
SS9267547's Avatar
SS9267547 SS9267547 is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes this is still under development. Just start things back up so the next release should be a few weeks. I'll post more info up later and as for issues posted in the thread will be addressed in the next release.
Reply With Quote
  #114  
Old 11-05-2007, 07:09 PM
cgfuse cgfuse is offline
 
Join Date: Jun 2007
Posts: 4
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by jgommel View Post
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.

Code:
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.

Code:
$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");
I get the same problem as you, and i tried your fix and this is what it says.

Code:
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 4
STR: ->
SQL: $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")


SQL query:

$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")

MySQL said: Documentation
#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 '$db->query_write("CREATE TABLE IF NOT EXISTS ". TABLE_PREFIX ."mindesticgcms_gam' at line 1
I dont know if im doing it wrong or not, any help is greatly appreciated
Reply With Quote
  #115  
Old 11-06-2007, 01:03 AM
SS9267547's Avatar
SS9267547 SS9267547 is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If for some reason it wasn't installed, to manully put it in paste the following in your phpmyadmin under 'SQL' or whatever program you use (Replace 'community' with whatever your TABLE PREFIX is setup as in vb if any) :
PHP Code:
CREATE TABLE `community_mindesticgcms_game` (
  `
gameidint(11unsigned NOT NULL auto_increment,
  `
gamenamevarchar(255NOT NULL default '',
  `
gameusernamevarchar(50NOT NULL default '',
  `
gameuseridint(10unsigned NOT NULL default '0',
  `
gamelastupdateint(10unsigned NOT NULL default '0',
  `
gamedatelineint(10unsigned NOT NULL default '0',
  `
gamereleasedateint(10unsigned NOT NULL default '0',
  `
gameplatformidsmallint(5unsigned NOT NULL default '0',
  `
gamevalidint(10NOT NULL default '1',
  `
gameviewsint(10NOT NULL default '0',
  `
gamedescriptiontext NOT NULL,
  `
gameipaddressvarchar(15NOT NULL default '',
  `
gameeditusernamevarchar(50NOT NULL default '',
  `
gameedituseridint(10unsigned NOT NULL default '0',
  `
gameeditipaddressvarchar(15NOT NULL default '',
  `
gamegenreidsmallint(5unsigned NOT NULL default '0',
  `
gamemediumidsmallint(5unsigned NOT NULL default '0',
  `
gameorginidsmallint(5unsigned NOT NULL default '0',
  `
gameplayeridsmallint(5unsigned NOT NULL default '0',
  `
gamedeveloperidsmallint(5unsigned NOT NULL default '0',
  `
gamepublisheridsmallint(5unsigned NOT NULL default '0',
  `
gameesrbidsmallint(5unsigned NOT NULL default '0',
  `
gamemultiplayidsmallint(5unsigned NOT NULL default '0',
  `
gameesrbcddatamediumtext NOT NULL,
  
PRIMARY KEY  (`gameid`)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=
Reply With Quote
  #116  
Old 11-10-2007, 09:09 AM
Gn_Snake Gn_Snake is offline
 
Join Date: Feb 2006
Location: Italy
Posts: 358
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,
i have error mysql :

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT COUNT(*) AS total
FROM HG_mindesticgcms_game AS game;

MySQL Error : La tabella 'hardwaregame.hg_mindesticgcms_game' non esiste
Error Number : 1146
Date : Saturday, November 10th 2007 @ 12:10:27 PM
Script : http://127.0.0.1/forum/admincp/admin...ms.php?do=list
Referrer : http://127.0.0.1/forum/admincp/index.php
IP Address : 127.0.0.1
Username :
Classname : vB_Database


Help Me!!
Reply With Quote
  #117  
Old 11-10-2007, 01:40 PM
SS9267547's Avatar
SS9267547 SS9267547 is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I think your missing the game table. Just put in the sql from thishttps://vborg.vbsupport.ru/showpost....&postcount=114 post.
Reply With Quote
  #118  
Old 11-13-2007, 02:17 PM
Gn_Snake Gn_Snake is offline
 
Join Date: Feb 2006
Location: Italy
Posts: 358
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by SS9267547 View Post
I think your missing the game table. Just put in the sql from thishttps://vborg.vbsupport.ru/showpost....&postcount=114 post.
Thx
Reply With Quote
  #119  
Old 11-13-2007, 02:23 PM
Gn_Snake Gn_Snake is offline
 
Join Date: Feb 2006
Location: Italy
Posts: 358
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very good this feature for the future:

11. Game Cheats System.
Reply With Quote
  #120  
Old 11-13-2007, 11:31 PM
SS9267547's Avatar
SS9267547 SS9267547 is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 390
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yeah for sure. When I get to it who knows lol. In the next few weeks I'm planning on releasing the next beta so things will start up with development again.
Reply With Quote
  #121  
Old 11-14-2007, 05:03 PM
Phlex's Avatar
Phlex Phlex is offline
 
Join Date: Jul 2005
Posts: 63
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It would be wonderful if it would be possible to use this also as a movie database
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:13 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04962 seconds
  • Memory Usage 2,349KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (1)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete