Welcome to EQEmu Operations Center


Information Regarding EOC and Tools


 

This is the central place in which documentation is maintained for EOC 2.0 and its resources.

The purpose of EoC is to provide rapid server development tools that may or may not be available through other mediums.

The goal is not to replace or duplicate effort but to make an extremely effective creative medium to develop and manage server's and their content respectively

EQEmu Operations Center (EoC) 2.0

  • Active status: development
  • Sub tools: PEQ Editor managed and maintained by the PEQ team
  • How does it work?
    • Currently the EoC is a web tool that works as an external tool that does not require extensive web server setup, configs and many prerequisite knowledge to get development tools up and in place
    • You simply need your MySQL (Database Server) to be opened up on port 3306 on your server. For some people this could mean:
      • Open up port 3306 on Windows Firewall
      • Open up port 3306 on your home Router (Port Forwarding)
    • You also need to have a database user (NOT ROOT - IMPORTANT) custom created so that you add a database connection to connect to your server

High level reference of the communication architecture between your test/production server and the EOC.

This is simply to explain that EOC needs to 'read' your database via port 3306 in order to have the EOC tools manipulate your database data.

Create your Database User

  • To create your database user you will need to run the query below to create your database user:
    • This will allow connections only from EOC via the specified user below, you shouldn't need to change the password because you are only allowing from the EOC server
CREATE USER 'eoc_database_user'@'192.99.119.164' IDENTIFIED BY 'eoc_database_password';
GRANT GRANT OPTION ON *.* TO 'eoc_database_user'@'192.99.119.164';
GRANT ALL ON *.* TO 'eoc_database_user'@'192.99.119.164';

Accessing EoC

  • Browse to: http://eoc.akkadius.com/EOC2/login.php
    • (You may want to bookmark it)
  • You will need to create your connection or connections, in EOC 2.0 you can create multiple connections and it will be stored in your browser
  • In the example you need to input 
    • Hostname or IP
    • Database Name
    • Database User
    • Database Password
  • Once you have verified a successful connection, you are able to login
​
  • Once you have succesfully logged in, you have created a connection which is stored in a cookie on your browser and you can quickly flip between your stored databases
  • When you are in the EOC interface you will be able to see your stored connections at the top right and be able to swap to and from them almost instantly

Tools

Tool Features Development Status Developed and/or Maintained By How to Use Guides and Extra Information

PEQ Editor

 

The PEQ Editor is an entire editor suite on its own accessible from EoC. This is so users do not have to setup their own for convenience and/or lack of knowledge.

This may have features or capabilities that aren't available otherwise in other similar editors in the EOC.

Support Forums: PEQ Forums
The PEQ Editor provides facilities to edit the following things in the database:
  • NPCs
  • Spawns
  • Loot
  • Spell Sets
  • Merchants
  • Faction Hits
  • Faction Defaults
  • Tradeskills
  • Adventures
  • Tasks
  • Objects
  • Zone Data
  • Server Data
  • More
 
Active

The PEQ Team

This editor has been developed by various PEQ team members over time, and it is constantly evolving as PEQ uses it to further build their database.

Zone Copy/Import

  • An extremely powerful tool made to be able to copy entire zones and create 'partitions' if you will.
  • EQEmu leverages instancing and you can have two completely different versions of a zone, this tool allows you to not start from scratch and at least make a copy of the base data in the zone before modifying all of the existing spawns.
  • This copies:
    • Doors
    • Objects
    • NPC's
    • Spawns
    • Grids
  • Copy Types:
    • Full - Will copy everything
    • Partial - Will just copy over spawn data, not create new NPC's
  • You can import content from a second database connection. So out of a list of your connections you can pick a zone from a different database and it will import all the NPC's
    • You cannot 
    • The downside of this is that all of the NPC's have to be actually spawned in the zone and the ID's change, so if you are importing content you have to be mindful that ID's need to change in your scripts and whatever else that may tie to them

 

Active/Complete
  • Akkadius

Item Editor

Making an item editor is flat out an absolute pain in the ass. There's an insane amount of data to translate, this one is very functional but still has some of its quirks.

  • Full and extensive Item Searching and filters
  • Quick Item Stat Scaling (Auto Scaler)
  • Visual Item Color Selector
  • Visual Class Selector
  • Visual Icon and Weapon Viewing/Selecting
  • Field Descriptions
  • Quick Free Item ID Slot picker
  • Visual Class picker
  • Visual Race Picker
  • Visual Inventory slot picker
  • Spell data visual search
  • Extensive data field translators
  • Does not break to database schema changes

Active/Functional

This tool could use some sharpening but is very functional.

  • Akkadius

Task Editor

Here is a very fine and functional task editor originally created by Trevius. I went through and modified many things for the port to EOC 2.0 from EOC 1.0 but all of the functionality very much remains the same. This has been my goto utility for editing tasks and for many others.

  • No page loads, all AJAX seamless
  • Editing existing Tasks
  • Creating New Tasks
  • Creating Task Activities
  • Easy to use task paramters
  • Realtime saving
  • Easy to use interface

Active/Complete

Believe there are some small quirks from the port left over

  • Trevius
  • Akkadius

NPC Editor

  • Grid like NPC Editor that allows you to search a zone by its instance ID as well as NPC Name as a filter
  • Allows for Mass Field Editing, the powerful aspect of this editor as it allows you to make mass changes to a zone of NPC's based on certain critera.
  • This tools goes GREAT with the zone copier tool for instancing, you can copy a zone into a new version and then massively modify the new data to make the zone appear completely different and do alot of work very quickly
  • Individual NPC Editing allows you to get a visual and translated reference of editing individual npc_types field data

Active/Functional

Known issues:

Sluggish when doing individual NPC editing when you have many results loaded in a zone. Fixing this would require a rewrite of the grid loading. What you see currently is a port from EOC 1.0

  • Akkadius

dbstr_us.txt editor

Client File

  • This tool was originally meant to be a place you can upload your EverQuest clients working dbstr_us.txt and reference it in other EOC tools and utilites as well such as the Spell Editor that is currently in development
  • You can upload a local dbstr_us.txt and the server remembers you by your browser so be careful if you plan to use this for extended use you should download a copy of the text file when you are done working with it
  • You can edit and search for entries quickly with your uploaded and working version
Active/In-Development
  • Akkadius

_chr.txt File Editor

Client File

  • This tool takes some really hard to find information and makes a very easy visual tool to create custom race model loaders for zones
  • When the client loads zone graphic assets, it looks for this character text file to know what models to load. If I zoned into crushbone it would be crushbone_chr.txt, this format uses the zone short name in the client folder.
  • Be wary when using this that sometimes loading particular models can crash the client, so make sure you test your files before giving them to clients
    • You can search for race models and visually select which ones you want included in your custom loader
Active/Complete
  • Akkadius

Race Viewer

  • Simple to use visual Race Viewer
    • Provides search by ID or Name
Active/Complete
  • Akkadius
 

Spell Icon Viewer

  • Simple to use spell icon viewer
  • Also used in the Spell Editor
Active/Complete
  • Akkadius

Item Icon Viewer

  • Simple to use item icon viewer and searcher, also used in the Item Editor
Active/Complete
  • Akkadius