-
Notifications
You must be signed in to change notification settings - Fork 238
/
mysql.lua
34 lines (29 loc) · 2.23 KB
/
mysql.lua
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
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 = false -- 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 = "127.0.0.1" -- This is the IP address of the MySQL host. Make sure the IP address is correct and in quotation marks (" ")
RP_MySQLConfig.Username = "user" -- 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 = "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 = "DarkRP" -- 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 = "mysqloo" -- 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 MySQLOO and read the guide here:
https://github.com/FredyH/MySQLOO
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
]]