Z3k4 devrait pouvoir t'aidéMathias Mio à dit:
Je me permets de t'aider RP_MySQLConfig = {} -- Ignore this line
--[[
Welcome to MySQL for DarkRP!
In this file you can find a manual for MySQL configuration and the MySQL config settings.
]]
RP_MySQLConfig.EnableMySQL = true -- Set to true if you want to use an external MySQL database, false if you want to use the built in SQLite database (garrysmod/sv.db) of Garry's mod.
RP_MySQLConfig.Host = "" -- This is the IP address of the MySQL host. Make sure the IP address is correct and in quotation marks (" ")
RP_MySQLConfig.Username = "" -- This is the username to log in on the MySQL server. -- contact the owner of the server about the username and password. Make sure it's in quotation marks! (" ")
RP_MySQLConfig.Password = "" -- This is the Password to log in on the MySQL server, -- Everyone who has access to FTP on the server can read this password. -- Make sure you know who to trust. Make sure it's in quotation marks (" ")
RP_MySQLConfig.Database_name = "" -- This is the name of the Database on the MySQL server. Contact the MySQL server host to find out what this is
RP_MySQLConfig.Database_port = 3306 -- This is the port of the MySQL server. Again, contact the MySQL server host if you don't know this.
RP_MySQLConfig.Preferred_module = "tmysql4" -- Preferred module, case sensitive, must be either "mysqloo" or "tmysql4". Only applies when both are installed.
RP_MySQLConfig.MultiStatements = false -- Only available in tmysql4: allow multiple SQL statements per query. Has no effect if no scripts use it.
--[[
MANUAL!
HOW TO USE MySQL FOR DARKRP!
Download tmysql4 and read the guide here:
https://facepunch.com/showthread.php?t=1442438
WHAT TO DO IF YOU CAN'T GET IT TO WORK! - There are always errors on the server, try if you can see those (with HLDS/server logs) - the same errors are also in the logs if you can't find the errors on the server. the logs are at garrysmod/data/DarkRP_logs/ on the SERVER! The MySQL lines in the log always precede with "MySQL Error:" (without the quotation marks) - make sure the settings in this file (mysql.lua) are correct - make sure the MySQL server is accessible from the servers IP
]]Oh, je savais pas que le darkrp gérer les bddEpicGaby à dit:Salut
En fait, c'est pas si compliqué que ça en a l'air.
Tout d'abords, active les connexions MySQL sur DarkRP. N'oublie pas d'avoir mysqloo9 ou tmysql4 qui sont indispensables pour que GMOD puisse se connecter à une BDD.
Ensuite, crée une BDD avec mTx ( le panel ) je connais pas trop, je suis pas client chez eux.
Une fois que tu as fais tout ça, il va falloir relier DarkRP à ta BDD.
( garrysmod/addons/darkrpmodification-master/lua/darkrp_config/mysql.lua )
Configure la ligne RP_MySQLConfig.Host en mettant l'ip de ta bdd ( la où elle est hébergée )Code:RP_MySQLConfig = {} -- Ignore this line --[[ Welcome to MySQL for DarkRP! In this file you can find a manual for MySQL configuration and the MySQL config settings. ]] RP_MySQLConfig.EnableMySQL = true -- Set to true if you want to use an external MySQL database, false if you want to use the built in SQLite database (garrysmod/sv.db) of Garry's mod. RP_MySQLConfig.Host = "" -- This is the IP address of the MySQL host. Make sure the IP address is correct and in quotation marks (" ") RP_MySQLConfig.Username = "" -- This is the username to log in on the MySQL server. -- contact the owner of the server about the username and password. Make sure it's in quotation marks! (" ") RP_MySQLConfig.Password = "" -- This is the Password to log in on the MySQL server, -- Everyone who has access to FTP on the server can read this password. -- Make sure you know who to trust. Make sure it's in quotation marks (" ") RP_MySQLConfig.Database_name = "" -- This is the name of the Database on the MySQL server. Contact the MySQL server host to find out what this is RP_MySQLConfig.Database_port = 3306 -- This is the port of the MySQL server. Again, contact the MySQL server host if you don't know this. RP_MySQLConfig.Preferred_module = "tmysql4" -- Preferred module, case sensitive, must be either "mysqloo" or "tmysql4". Only applies when both are installed. RP_MySQLConfig.MultiStatements = false -- Only available in tmysql4: allow multiple SQL statements per query. Has no effect if no scripts use it. --[[ MANUAL! HOW TO USE MySQL FOR DARKRP! Download tmysql4 and read the guide here: https://facepunch.com/showthread.php?t=1442438 WHAT TO DO IF YOU CAN'T GET IT TO WORK! - There are always errors on the server, try if you can see those (with HLDS/server logs) - the same errors are also in the logs if you can't find the errors on the server. the logs are at garrysmod/data/DarkRP_logs/ on the SERVER! The MySQL lines in the log always precede with "MySQL Error:" (without the quotation marks) - make sure the settings in this file (mysql.lua) are correct - make sure the MySQL server is accessible from the servers IP ]]
RP_MySQLConfig.Username avec le nom d'utilisateur qui t'as été crée
RP_MySQLConfig.Password avec le mot de passe de ton utilisateur
RP_MySQLConfig.Database_name avec le nom de la base de donnée à laquelle tu te connectes
Fait ça pour les deux serveurs et le tour est joué ( personnellement, j'ai déjà configuré ceci pour une commu, résultat = les joueurs détestaient
En espèrent t'avoir aidé,
Gaby !
De rien, ce fut un plaisir.Mathias Mio à dit:
merxi