View Single Post
  #4  
Old 08-24-2016, 07:09 PM
phantomghost
Hill Giant
 
Join Date: May 2015
Posts: 126
Default

Think you can change the user and password in HeidiSQL:

Under the query tab:

UPDATE mysql.user SET user='newusername',
password=PASSWORD('newpassword') WHERE user='root';
FLUSH PRIVILEGES;

(Copy/pasted the above).

http://wiki.eqemulator.org/p?Complet...er_Setup_Guide

That guide above is fairly decent as well. (Slightly out-dated) But overall gets you where you need (if you decide you want bots on the server, not sure if you can add them or not using that installer).

Some pretty basic things you can mess with (I would backup your server before messing around).
eqemu_update.pl - Option 1

Open HeidiSql and type in your password. Under (I assume it is called PEQ) you can go through the different tables.

The rule_values is a good one to go through and set your rules. (Keep in mind under the zones table certain zones are set under specific rulesets. (You can set them all to the same ruleset or change them by zone).

The items table is fairly self explanatory. (Google eqemu items) if you need help figuring out what each column is.

level_exp_mods is another one that is not too difficult to figure out what you are changing.

Some of the tables such as AA's and spells can be fairly easy to update, but are a bit more complicated as it may require you update files in your client).
Reply With Quote