Can someone help me setup MySQL on my garrysmod server? Or at least post links to downloads that I need. Thanks In advance!
What are you talking about?
MySQL is a database server. It has absolutely nothing to do with Garry's Mod. You should be in the Tech Support forum.
Squerl, some people use MySQL databases with their Garry's Mod servers to store info.
Here's a basic tutorial to get you started off with hooking up your database to your server: [url]http://maurits.tv/data/garrysmod/wiki/wiki.garrysmod.com/indexb25c.html[/url]
What kind of info?
[QUOTE=Squerl101;40923780]What kind of info?[/QUOTE]
Player name, SteamID, wins, amount of points/money, time played, donation, server rank, if they are registered on the forums or not, and some people (I have no idea why) prefer to use their own SQL database to store bans instead of using something like sourcebans.
SourceBans uses SQL.
I know, I was talking about using a personal SQL database that handles bans how they want, not through sourcebans.
I though that DarkRP uses it's own internal system to remember how much money everyone has.
DarkRP uses a form of SQL - SQLite. This is included in Garry's Mod itself (sv.db file). You can also use MySQL if you configure DarkRP to.
MySQL has the advantage that it is easier if you want multiple servers under the same database (which means that, for example, you have the same money on both servers).
---
Anyway, on topic. Check [URL="https://www.facepunch.com/showthread.php?t=1220537"]this[/URL].
Makes sense.
Off topic, SQLite is much faster but more restricted than MySQL. I prefer MySQL in the sense that it is a lot more versitile and is quite flexible. At one point I had created a custom version of DarkRP that uses MySQL, but it's been so long since I've done very complexing custom databasing like that, plus I doubt I still have it.
On topic, use Bo's link; you can find many tutorials by just googling it.
[QUOTE=code_gs;40929178]Off topic, SQLite is much faster but more restricted than MySQL. I prefer MySQL in the sense that it is a lot more versitile and is quite flexible. At one point I had created a custom version of DarkRP that uses MySQL, but it's been so long since I've done very complexing custom databasing like that, plus I doubt I still have it.
On topic, use Bo's link; you can find many tutorials by just googling it.[/QUOTE]
Why would you have to create a custom version of DarkRP for that? The only thing you need is to get the library and edit the _MySQL.lua file inside the gamemode to hook up with the MySQL Server.
Is there any place to get a free mysql server?
I don't think you have to have a physical server that runs MySQL. That's just a piece of software that runs on operating systems. You should just be able to download and install it, and then configure Garry's Mod (or SourceBans) to work with it.
[QUOTE=KnownUser;40937541]Is there any place to get a free mysql server?[/QUOTE]
If you are not willing to pay for a MySQL server, and it is not including with your server hosting (some GSPs provide this), then just use SQLite. It runs locally on your server but you won't be able to easily access it if you run multiple servers or you want to display its contents in a fancy table on your website.
[QUOTE=Svenskunganka;40929379]Why would you have to create a custom version of DarkRP for that? The only thing you need is to get the library and edit the _MySQL.lua file inside the gamemode to hook up with the MySQL Server.[/QUOTE]
Because it didn't use a typical MySQL database that it just calls information from, it was a custom version that used WAMP and I had to recode it to understand how the information was arranged.
[QUOTE=KnownUser;40937541]Is there any place to get a free mysql server?[/QUOTE]
Download WAMP, works really great.
Sorry, you need to Log In to post a reply to this thread.
