Jump to content
News ticker
  • Bienvenue sur le nouveau forum VeryGames
  • Welcome to the new VeryGames forum
  • VeryNews

    Mani fonction Mysql


    Cleaner

    Recommended Posts

    jene parviens pas a l utiliser !

     

    c est pour savoir si chez Vg il y a avait des admin qui utilisaient cette partie de mani

     

    je suis preneur de lecon de config sur se sujet.

     

    Mais il me semeble que les serveur de jeux non pas de dns, ou ne peuvent resoudre l ip de sql.verygames.net

    Link to comment
    Share on other sites

    bon je viens de faire la mise a jour sur la version 1.2 beta RC5 et tout semble bien fonctionner.

    Concernant Sql les tables ont bien été crées ainsi que les contenus (infos serveur, clients...)

    Il me reste a voir la réelle utilité de tout ça...(je dois encore installer l'interface web de gestion)

    Voilà le contenu de mon fichier database.txt si ca peut t'aider

    "database.txt"
    {
    // 
    // Database.txt file for database connectivity via mani_admin_plugin V1.2 onwards
    // If this file is used, make sure that it is not visible to the world if 
    // your game server doubles as a webhost.
    //
    
    // First value determines whether the database connectivity is turned on 
    // or off (1 = on, 0 = off). This is turned off by default !!!
    
    "db_enabled"	"1"
    
    // Now the database connection values
    //
    
    // Put your internet host name here
    "db_host"	"213.251.148.96"
    
    // Put your database user id for mysql in here
    "db_user"	"server1352"
    
    // Put the password for your mysql database in here
    "db_password"	"tonpasssql"
    
    // Put the name of your database in here
    "db_name"	"server1352"
    
    // Port number of the database here (Default is 3306)
    "db_port"	"3306"
    
    // Timeout in seconds before connection gives up
    // Default is 5 seconds
    "db_timeout"	"10"
    
    // Name of the prefix to place before the table names
    "db_table_prefix"	"map_"
    
    // Names of tables within the database, no need to change these
    // unless a third party application requires it
    "db_table_client"		"client"
    "db_table_client_flag"		"client_flag"
    "db_table_client_group"		"client_group"
    "db_table_client_level"		"client_level"
    "db_table_client_server"	"client_server"
    "db_table_flag"			"flag"
    "db_table_ip"			"ip"
    "db_table_level"		"level"
    "db_table_nick"			"nick"
    "db_table_server"		"server"
    "db_table_steam"		"steam"
    "db_table_version"		"version"
    
    // Linux only !!!!
    // If you are using a web server that is local to the gameserver
    // (you would have put 'localhost' or '127.0.0.1' in the db_host 
    // section. You need to enter the path to mysql.sock here
    // This is usually '/var/lib/mysql/mysql.sock' but could be
    // something different on your particular system
    
    "db_socket_path"	"/var/lib/mysql/mysql.sock"
    
    // Now we have data that is inserted into the 'server' 
    // table on the database. This is information about your
    // game server, not the mysql database
    
    // Server ID. This should be a numeric number (default is 1). 
    //
    // IMPORTANT !!
    // If you are using multiple servers on a single database
    // you MUST use a different server id for each server.
    
    "server_id"		"1"
    
    // Server group that your server belongs to
    "server_group_id"	"Default"	
    
    // The following are purely informational for a 
    // web front end so it's easier to see which
    // server is which.
    
    "server_name"		"Team XoR CS:Source Game Server"
    "server_ip_address" 	"213.251.148.102"
    "server_port"		"27015"
    
    // Your mod name
    "mod_name"		"CS:Source"
    
    // RCON Password. Note this is not used yet but may be in the future
    // for allowing remote rcon commands to be used from an advanced 
    // web front end or via inter-server communications
    
    "rcon_password"		"tonpassrcon"
    }
    

    Je n'ai qu'un serveur à administrer donc je ne peux pas te donner + d'infos sur une config multi-serveurs (mais j'y réfléchi...)

     

    Voilà.

     

    Cordialement.

    Link to comment
    Share on other sites

    Et hop un petit dump sql

    -- phpMyAdmin SQL Dump
    -- version 2.7.0-pl2-Debian-1
    -- http://www.phpmyadmin.net
    -- 
    -- Host: sql-1.verygames.net
    -- Generation Time: Mar 23, 2006 at 07:11 PM
    -- Server version: 4.1.15
    -- PHP Version: 4.4.0-4
    -- 
    -- Database: `server1352`
    -- 
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_client`
    -- 
    
    CREATE TABLE `map_client` (
     `user_id` mediumint(8) NOT NULL auto_increment,
     `name` varchar(32) NOT NULL default '',
     `password` varchar(32) default '',
     `email` varchar(255) default '',
     `notes` varchar(255) default '',
     PRIMARY KEY  (`user_id`),
     UNIQUE KEY `name` (`name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_client_flag`
    -- 
    
    CREATE TABLE `map_client_flag` (
     `user_id` mediumint(8) NOT NULL default '0',
     `flag_string` text,
     `type` char(1) NOT NULL default '',
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`type`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_client_group`
    -- 
    
    CREATE TABLE `map_client_group` (
     `user_id` mediumint(8) NOT NULL default '0',
     `group_id` varchar(32) NOT NULL default '',
     `type` char(1) NOT NULL default '',
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`group_id`,`type`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_client_level`
    -- 
    
    CREATE TABLE `map_client_level` (
     `user_id` mediumint(8) NOT NULL default '0',
     `level_id` mediumint(8) NOT NULL default '-1',
     `type` char(1) NOT NULL default '',
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`level_id`,`type`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_client_server`
    -- 
    
    CREATE TABLE `map_client_server` (
     `user_id` mediumint(8) NOT NULL default '0',
     `server_group_id` varchar(32) NOT NULL default '0',
     PRIMARY KEY  (`user_id`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_flag`
    -- 
    
    CREATE TABLE `map_flag` (
     `flag_id` varchar(20) character set latin1 collate latin1_bin NOT NULL default '',
     `type` char(1) NOT NULL default '',
     `description` varchar(128) NOT NULL default '',
     PRIMARY KEY  (`flag_id`,`type`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_group`
    -- 
    
    CREATE TABLE `map_group` (
     `group_id` varchar(32) NOT NULL default '',
     `flag_string` text,
     `type` char(1) NOT NULL default '',
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`group_id`,`type`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_ip`
    -- 
    
    CREATE TABLE `map_ip` (
     `user_id` mediumint(8) NOT NULL default '0',
     `ip_address` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`ip_address`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_level`
    -- 
    
    CREATE TABLE `map_level` (
     `level_id` mediumint(8) NOT NULL default '-1',
     `type` char(1) NOT NULL default '',
     `flag_string` text,
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`level_id`,`type`,`server_group_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_nick`
    -- 
    
    CREATE TABLE `map_nick` (
     `user_id` mediumint(8) NOT NULL default '0',
     `nick` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`nick`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_server`
    -- 
    
    CREATE TABLE `map_server` (
     `server_id` mediumint(8) NOT NULL default '0',
     `name` varchar(128) NOT NULL default '',
     `ip_address` varchar(32) NOT NULL default '',
     `port` mediumint(8) NOT NULL default '0',
     `mod_name` varchar(64) NOT NULL default '',
     `rcon_password` varchar(64) default '',
     `server_group_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`server_id`),
     UNIQUE KEY `name` (`name`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_steam`
    -- 
    
    CREATE TABLE `map_steam` (
     `user_id` mediumint(8) NOT NULL default '0',
     `steam_id` varchar(32) NOT NULL default '',
     PRIMARY KEY  (`user_id`,`steam_id`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
    
    -- --------------------------------------------------------
    
    -- 
    -- Table structure for table `map_version`
    -- 
    
    CREATE TABLE `map_version` (
     `version_id` varchar(20) NOT NULL default ''
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

     

    Attention il s'agit de la structure uniquement!!

    Link to comment
    Share on other sites

    Cela ne concerne que Mani 1.2. Il va te falloir faire la majeur partie des choses à la main (saisie manuelle des données sous Sql, définition des admins et groupes différents de la 1.1...), car l'interface web de gestion n'est pas encore compatible avec la dernière beta M RC6.

    Si la doc et les cfg ne sont pas suffisament clairs à tes yeux je te conseille de patienter encore un peu, ca t'éviteras quelques déboires.

     

    Cordialement.

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Reply to this topic...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...