EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   Where to find rule_values database? (https://www.eqemulator.org/forums/showthread.php?t=43218)

TripSin 03-01-2021 03:28 PM

Where to find rule_values database?
 
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 03-01-2021 05:28 PM

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 03-01-2021 06:29 PM

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 03-01-2021 07:12 PM

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 03-02-2021 02:15 AM

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 03-03-2021 11:37 AM

Quote:

Originally Posted by TripSin (Post 266272)
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 03-03-2021 03:22 PM

Quote:

Originally Posted by TripSin (Post 266272)
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:

https://i.gyazo.com/25c49f11e834a704...4567f1dac3.png

And you can also write queries with it like this:

https://i.gyazo.com/6ea4bb57ff150894...f3f79a99de.png

TripSin 03-03-2021 09:20 PM

Thanks for all the info everyone


All times are GMT -4. The time now is 01:55 PM.

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.