Mod Help

Discussion in 'Free Hosting' started by Ericsson, Mar 4, 2005.

Thread Status:
Not open for further replies.
  1. Ericsson

    Ericsson Banned

    Messages:
    262
    Likes Received:
    0
    Trophy Points:
    0
    Im trying to install a mod. This is the end instructions, I dont know what it means anyone know.

    Code:
    # 
    #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
    # 
    
    #
    #-----[ SQL ]------------------------------------------ 
    #
    CREATE TABLE `phpbb_ina_data` ( version VARCHAR(255) DEFAULT NULL );
    CREATE TABLE `phpbb_ina_games` (
    							`game_id` mediumint(9) NOT NULL auto_increment, 
    							`cat_id` mediumint(8) default NULL,
    							`game_name` varchar(25) default NULL, 
    							`game_path` varchar(255) default NULL, 
    							`image_path` varchar(255) default NULL, 
    							`game_desc` varchar(255) default NULL, 
    							`game_charge` int(11) unsigned default '0', 
    							`game_reward` int(11) unsigned NOT NULL default '0', 
    							`game_bonus` smallint(5) unsigned default '0', 
    					`at_game_bonus` smallint(5) default '0',
    							`game_use_gl` tinyint(3) unsigned default '0', 
    							`game_flash` tinyint(1) unsigned NOT NULL default '0', 
    							`game_show_score` tinyint(1) NOT NULL default '1',
    							`game_avail` tinyint(1) unsigned default '1',
    							`allow_guest` tinyint(1) unsigned default '0', 
    							`win_width` smallint(6) NOT NULL default '0', 
    							`win_height` smallint(6) NOT NULL default '0', 
    							`highscore_limit` int(11) default NULL, 
    					`at_highscore_limit` int(10) default '0',
     							`reverse_list` tinyint(1) NOT NULL default '0', 
    							`played` int(10) unsigned NOT NULL default '0', 
    							`instructions` text,
    					`score_type` smallint(1) default NULL,
    							PRIMARY KEY  (`game_id`));
    CREATE TABLE `phpbb_ina_scores` (
    							`game_name` varchar(255) default NULL, 
    							`player_id` mediumint(8) default NULL, 
    							`player_ip` varchar(16) default NULL,
    							`score` decimal(12,4) default NULL, 
    							`date` int(11) default NULL );
    CREATE TABLE `phpbb_ina_at_scores` (
    							`game_name` varchar(255) default NULL, 
    							`player_id` mediumint(8) default NULL, 
    							`player_ip` varchar(16) default NULL,
    							`score` decimal(12,4) default NULL, 
    							`date` int(11) default NULL );
    CREATE TABLE `phpbb_ina_sessions` (
    							`arcade_hash` varchar(33) default NULL,
    							`user_id` mediumint(8) NOT NULL default '0',
    							`start_time` int(11) NOT NULL default '0',
    							`session_ip` varchar(8) NOT NULL default '',
    							`page` int(1) NOT NULL default '0',
    							`game_name` varchar(25) default NULL,
    							`user_ip` varchar(16) default '0',
    							`ip_name` varchar(255) default NULL);
    CREATE TABLE `phpbb_ina_banned` (
    							`username` varchar(25) default NULL,
    							`user_id` mediumint(8) default NULL,
    							`player_ip` varchar(16) default NULL,
    							`game` varchar(25) default NULL,
    							`score` mediumint(8) default NULL,
    							`date` varchar(16) default NULL);
    CREATE TABLE `phpbb_ina_cat` (
    							`cat_id` mediumint(8) NOT NULL auto_increment,
    							`mod_id` mediumint(8) default NULL,
    							`cat_name` varchar(100) default NULL,
    							`cat_desc` text,
    							`icon` varchar(255) default NULL,
    							`special_play` smallint(5) NOT NULL default '0',
    							`last_game` varchar(25) default NULL,
    							`last_player` mediumint(8) default NULL,
    							`last_time` int(11) default NULL );
    CREATE TABLE `phpbb_ina_fav` (
    							`user_id` mediumint(8) NOT NULL default '0',
    							`game_id` mediumint(9) NOT NULL default '0');
    CREATE TABLE `phpbb_ina_tour` (
    							`tour_id` mediumint(5) NOT NULL auto_increment,
    							`tour_name` varchar(25) default NULL,
    							`tour_desc` text);
    INSERT INTO `phpbb_ina_data` VALUES ('v2.0.7');
    INSERT INTO `phpbb_ina_games` (`game_id`, `game_name`, `game_path`, `image_path`, `game_desc`, `game_charge`, `game_reward`, `game_bonus`, `game_use_gl`, `game_flash`, `game_show_score`, `win_width`, `win_height`, `highscore_limit`, `reverse_list`, `played`, `instructions`, `game_avail`, `allow_guest`, `cat_id`) VALUES (1, 'donkeykong', 'games/donkeykong/', '', 'The Classic - Donkey Kong', 0, 0, 0, 0, 1, 1, 448, 600, 0, 0, 0, 'CLICK where it says \'Press Space Bar To Start\' to start the game :(', 1, 1, NULL);
    INSERT INTO `phpbb_config` VALUES ('default_reward_dbfield','');
    INSERT INTO `phpbb_config` VALUES ('default_cash','');
    INSERT INTO `phpbb_config` VALUES ('use_rewards_mod','0');
    INSERT INTO `phpbb_config` VALUES ('use_cash_system','0');
    INSERT INTO `phpbb_config` VALUES ('report_cheater','0');
    INSERT INTO `phpbb_config` VALUES ('warn_cheater','0');
    INSERT INTO `phpbb_config` VALUES ('use_point_system','0');
    INSERT INTO `phpbb_config` VALUES ('use_gamelib','0');
    INSERT INTO `phpbb_config` VALUES ('games_path','games/');
    INSERT INTO `phpbb_config` VALUES ('gamelib_path','');
    INSERT INTO `phpbb_config` VALUES ('use_gk_shop','0');
    INSERT INTO `phpbb_config` VALUES ('use_allowance_system','0');
    INSERT INTO `phpbb_config` VALUES ('games_per_page','25');
    INSERT INTO `phpbb_config` VALUES ('games_default_img','templates/subSilver/images/games.gif');
    INSERT INTO `phpbb_config` VALUES ('games_default_txt','More games available to Registered Members - No Fee - No Catch.<br />');
    INSERT INTO `phpbb_config` VALUES ('games_default_id','0');
    INSERT INTO `phpbb_config` VALUES ('games_offline','0');
    INSERT INTO `phpbb_config` VALUES ('games_cheat_mode','1');
    INSERT INTO `phpbb_config` VALUES ('games_guest_highscore', '1');
    INSERT INTO `phpbb_config` VALUES ('games_auto_size', '1');
    INSERT INTO `phpbb_config` VALUES ('games_at_highscore', '1');
    INSERT INTO `phpbb_config` VALUES ('games_show_stats', '1');
    INSERT INTO `phpbb_config` VALUES ('games_image_width', '50');
    INSERT INTO `phpbb_config` VALUES ('games_image_height', '50');
    INSERT INTO `phpbb_config` VALUES ('games_per_admin_page', '25');
    
    
    # EoM 
     
  2. Maurice

    Maurice New Member

    Messages:
    1,930
    Likes Received:
    0
    Trophy Points:
    0

    This part makes tables in the MySQL database, save it as a SQL file and upload it with phpmyadmin if it isn't automated.
     
  3. sportman3333333

    sportman3333333 Red Sox Won!!!!!!

    Messages:
    358
    Likes Received:
    0
    Trophy Points:
    0
    yep, open a notepad, save it as .sql. upload it to phpmyadmin. Your all set.
     
  4. Ericsson

    Ericsson Banned

    Messages:
    262
    Likes Received:
    0
    Trophy Points:
    0
    How do I upload to phpmyadmin?
     
  5. Corey

    Corey I Break Things Staff Member

    Messages:
    34,553
    Likes Received:
    202
    Trophy Points:
    63
    In cPanel if you go to MySQL databases you should beable to pick PHPMyAdmin, in there run a query using the text file.. I believe that should do it.

    -Corey
     
Thread Status:
Not open for further replies.

Share This Page