Where to find rule_values database?

[TripSin]

I'd like to change the expansion of my server. I'm reading that I need to add/change the following values something like this:

World:UseClientBasedExpansionSettings = false
World:ExpansionSettings = 0

But I don't know WHERE to do this. Is there a file that needs to be edited? If so, where is this file? Every thread I've come across seems to just assume you know where to find this database or whatever it is that needs to be changed.

Thanks for any assistance

[Huppy]

Your database (peq) is full of tables, columns and values, which you will need something to log on and edit your database. There are many tools out there available, but that's a seperate learning process in itself. You may have gotten heidisql with your install ? maybe ?

Some use the EOC, peq editor, navicat, etc. There is a section in these forums with resources, as well as looking at the gitbook wiki:
https://eqemu.gitbook.io/server/

[TripSin]

My question is where is this database located? Is it a file(s) on my harddrive? If so, what is the name of the file(s)? Is it something I have to edit while on the server? If so, what do I use to access it?

[Huppy]

C:\Program Files\MariaDB 10.0\data is where the "data files" are kept (on mine), but you can't simply edit them. (they are not text files)

[TripSin]

Oh, dang. I mean I don't understand why it has to be so hard to put in one entry and modify a single digit value for another but oh well.

[hayward6]

Originally Posted by TripSin

Oh, dang. I mean I don't understand why it has to be so hard to put in one entry and modify a single digit value for another but oh well.

Hello, and welcome. What you are trying to do is actually very simple, but you need some level of understanding of these systems and applications. I run mysql on my linux server and simply use MySql Query Browser and MySql Workbench to make any database changes I want. There's more to it than that, like knowing the account and permissions, and knowing the url/address to hit to access the database.

It can be frustrating at first, but if you want to dive in to the emulator you need some patience and study. If you put the cart in front of the horse here, eventually you will run up against a wall you can't navigate around. Take your time and learn.

[Splose]

Originally Posted by TripSin

Oh, dang. I mean I don't understand why it has to be so hard to put in one entry and modify a single digit value for another but oh well.

Get Navicat or HeidiSQL to look through your database. If you don't know how to write any queries at all you can start out by just combing through the database like this:



And you can also write queries with it like this:

[TripSin]

Thanks for all the info everyone