vb.org Archive
Page 11 of 14 « First 910 11 1213 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - Mindestic Gaming CMS Lite BETA (https://vborg.vbsupport.ru/showthread.php?t=137797)

Bravo 08-09-2007 10:52 AM
Is it possible to add it so that mods can add games and all that stuff from the modcp?

ngocha85 08-21-2007 03:29 PM
27/8/2007.
My Happy day.:D

jgommel 08-26-2007 09:29 PM
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");

JVCode 08-26-2007 10:27 PM
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 08-27-2007 07:14 AM
BUMP! Someone please fix the SQL error and re-upload the files, i'm dieing to use this MOD. :)

JVCode 08-30-2007 08:27 AM
Bump.. :)

Luky 08-30-2007 12:44 PM
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 08-30-2007 12:48 PM
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 09-11-2007 12:46 PM
Quote:
Originally Posted by JVCode (Post 1326556)
BUMP! Someone please fix the SQL error and re-upload the files, i'm dieing to use this MOD. :)
What SQL errors?

JVCode 09-11-2007 01:43 PM
Quote:
Originally Posted by jgommel (Post 1326281)
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");





This...


All times are GMT. The time now is 12:02 PM.
Page 11 of 14 « First 910 11 1213 Last »
Show 40 post(s) from this thread on one page

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.01123 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete