Mani fonction Mysql

Cleaner · March 22, 2006

Bonjour,,

Je desirais savoir si quelqu un utilise les fonctions Mysql de mani ??

car depuis peu il est possible d utilise un config mysql, c est fort pratique si on a plusieurs serveur a gere !

merci de votre aide

cold · March 23, 2006

Non pas du tout mais expose toujours ton problème on ne sait jamais :wink:

Cordialement.

Cleaner · March 23, 2006

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

cold · March 23, 2006

bon ca fait quelques temps que je voulais tester la version beta 1.2 (une M rc4 est sortie ce jour), je m'y colle dans l'heure et je te tiens informé...

cold · March 23, 2006

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.

Cleaner · March 23, 2006

je vais testart car ja i toujours repondu avec sql.verygames.net et non avexc l ip //

d ou peu etre lerreur

Cleaner · March 23, 2006

aie aie

je ne pige pas

jai remis les paramettre a 1 changer le nom par l ip de la base sql

et rien

pas de creeation de base !

je reve !

passes moi la structure de base please ?

cold · March 23, 2006

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!!

Cleaner · March 23, 2006

MERCI

Cleaner · March 23, 2006

cela fonctionne enfin

:)

erreur de serveur !

c est pas facil de faire marche cela sur une modif passe sur le serveur 1

et j interroge le second !!

4k · March 24, 2006

kikoo :wink:

quelq un peut dire comment l installer

genre un petit tuto ca serait cool

:wink:

cold · March 24, 2006

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.

Sign In

Mani fonction Mysql

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation