Disabling zones/expansions via EOC
 

I'm using the EOC to disable specific expansions and zones. I'm not sure if I'm doing it correctly.

My expansion variable is set to "16731", based on the chart I found in the EOC wiki. My hope here is to activate Kunark, Velious, Luclin, & Ykesha, while skipping PoP. Did I use the right code? Is it possible to be that selective; i.e. skip an expansion?

I'm also attempting to disable the tutorial zone; The EOC wiki doesn't seem to have an answer to this, although I'm willing to bet I missed it. I'm not sure how to disable the tutorial zones via the EOC, so I'm hoping someone can "show" me how.

I'm also hoping to disable AA's (which I forgot about, while making this post), and am wondering if simply deleting the rulesets for them, is sufficient to accomplish that?

Expansions:
http://www.eqemulator.org/forums/sho...89&postcount=3
(this is an older post so it's missing bitmask values past SoF, but you get the idea).

Start Zones:
http://www.eqemulator.org/forums/showthread.php?t=40374
Simplest way (to me) is just changing the requirements so that the base AA (or all of them if you just wanna do a bulk edit) is unattainable in each tree.

The github wiki has a lot of references lists to use (including bitmasks for clients and expansions). https://github.com/EQEmu/Server/wiki
As far as disabling any and all AA's, that can be done with a simple sql query:

Thank you very much, guys!

I now see I was supposed to add the expansion values, not simply append them to one another.

And I've been messing around with the SQL library a bit, in my attempt to modify items not found in the EOC, so I'm glad to have an example of how to use the query system, thanks!

I'm trying to set the starting zones to their defaults. I can't seem to figure it out.

The Titanium and SoF client is set to "-1" by default. I assumed I needed to set those values to "0", as well as, all the values from the post (meant for PoK) to "0" (I deleted the x,y,z,heading arguments).

I assumed "0" would simply set them to some activated state, where the program would look to their defaults, but clearly, I am wrong, as it's spitting my characters out in South Qeynos lol.

I'm about to attempt setting them back "-1". I suppose I'm posting to document the process, and hopes that someone can better explain this to me.

It helps to back back up your database (before editing, and along the way) But keep in mind, when it comes to changing or altering the start zone for a toon, it has to be set in the char_create_combinations as well. The following sql query will set your start_zones table back to default settings:

Oh gawd, thank you. I needed this. I didn't realize, until too late, that one of the steps from the other post cleared everything out, in that spl DB/file. I was literally about to look up how to restore it, when I thought to check back here. Lifesaver!

I just realized my char_create_combination table is completely blank. Don't suppose anyone has a Query for that? I'm trying to find the answer, as I type, but hoping for another assist... lol

In that case, with a blank table you would need an insert query :

You sir, have saved my butt, about 4x, this week. Thank you, seriously.

I've just had a thougbt... I keep testing with Frogloks... But Grobb is back under Troll control. Are my Frogloks being dumped in South Qeynos because there is technically, not Gukta? Do I need to rebuild that zone, or a replacement zone, for my little froggies to go?

Edit: My Expansion setting is 23 )(LoY 16, SoL 4, SoV 2, RoK 1), for reference.

By default, frogs start in rathe mountains. Been that way for many years. If the start zones are not working with the correct (default) settings, something you got going on is a little screwy, lol

lol. I haven't checked each race, yet. From the couple I have tried, it does seem to be the Frogloks, specifically, though.

It's been ages since I played live (even after the fooled me, by saying the game was free-to-play, and I had a "silver" membership). I think LDoN was the last one I played.

Looks like I have some numbers, to stare at >.<

Curently, my issue is trying to find the db file(s) that pertain to character creation. At character creation, the town my Frogs are allowed to start in, is still referred to as Gukta, when I assume it should say Rathe.

I have tried it with multiple frogs, and multiple classes, and continue to be spit out, in South Qeynos.

The other potential I'm looking at, is if the x/y/z coords, are potentially to blame.

Otherwise, my start_zones & char_create_combinations, appear to have the correct ID's.

Those two database tables is the answer to your own question. When your database is sourced in, (and ultimately updated), it consists of over 200+ tables. Those tables, the columns and fields/values inside them, is what makes up your entire peq database. As for what database editing program or utility that each individual uses, is a personal preference. I use Navicat to access my database. This is what I see when I do that. (not all 218 tables are viewable in screenshot).

https://i.ibb.co/7CHh0RQ/peqdb001.jpg

After some time, I reinstalled the entire server. I wanted to be sure I hadn't done something along the way, I didn't mean to, or hadn't known would screw me.

I've been playing about in the DB, using Heidi, and it's starting to make more sense to me.

I now, see, however, that this is my problem:


I've been attempting to point the eqemu_server.pl to my MariaDB folder, by editing the "get_mysql_path" lines, around about line 990. No matter what format I used, I couldn't get it to use the path I manually inserted.

I suspect the problem is that my MariaDB folder is actually labeled "MariaDB 10.0". The server file is looking for "MariaDB/i". I realize the "i" is for the "include" folder, but as you'll see below, I was concerned by how the filepath was stated.

I came to this conclusion, when I had changed my MariaDB folder name from "MariaDB 10.0" to "MariaDB", because I suddenly couldn't run MySQL.exe, nor could I find any way to alter the filepath (MySQL.exe) to the right one.

What I believe is the offending code from eqemu_Server.pl:

I have tried replacing the MariaDB portions to the full file path, partials, quoted, quoted in sections, and just about every syntax I could think of or find, online.

For all I know, I'm doing this all wrong, but I wanted to try and figure it out, myself. After about 5hrs (plus the about 2 days, I've been stuck on this problem as a whole), I'm not sure what to do lol.

EDIT: The more I look at the prompts for World, Zone, etc., the more I think I was in the wrong place. They appear to access the MySQL just fine; the server loads, and seems playable (although, i've only had a chance to run around and test the spawn points loc's).

UPDATE: PARTIALLY SOLVED!

Ok, so as it turns out, I was missing Environmental Variables, for the Windows Command Prompt to work with. This post led me to that answer. But here's the short version!

Fixing: [Error:eqemu_server.pl] MySQL path not found, please add the path for automatic database upgrading to continue...

1. (note: this is for Windows 10; see above post for link to article for older versions): Navigate to Control Panel > View Advanced Sysytem Settings
2. Click "Environmental Variable"; scroll down to "path"; select and hit edit
3. Hit "New"; Hit "Browse";navigate to your MariaDB\bin folder; Hit Ok.
4. Repeat the above process for: MariaDB\Include; MariaDB\Data.
5. Once completed, hit "Ok" on your window.
6. (I can't be sure this part work, BUT I also did this): I added these, to the PATHEXT field (in the Environmental Variables window): .H;.PDB;/PL;.FRM

HOWEVER, I'm still experiencing the problem with Starting Zones. I've seen a couple other posts but no answers. The server appears to be using the variable (peq>start_zones) player_choice (i.e. Gukta on the character creation screen for starting zone) to identify the starting zone, instead of zone_id.

One person had an issue with expansions not being locked out, and it was simply about setting rules_values > World:UseClientBasedExpansionSettings > false. I've done this, and am still popping up in places, I shouldn't be. My quest continues.

I'm way too tired at the moment to try this, but is it possible that the difference in DB and table entry names, could be to blame?

example: in char_create_combinations, it's listed as start_zone, where as, the DB file is labeled start_zones?

In the database, you have tables, (not files), each of those tables (like char_create_combinations) will have columns with fields/values in them. So you will see a column named "start_zone" inside a table, but you may see another table named "start_zones", which will have all it's own columns with the fields/values in them. The odd things that are happening for you are unique and specific to something on your server setup. It's just a matter of finding out what has gone wrong. Sometimes, it could be something conflicting between your server (and/or) it's settings and your client. Troubleshooting can be overwhelming for some issues. If you are having issues with an absolute clean server/database (no custom editing), then there may be other problems that are getting overlooked. Example: Do you have these character create problems with a complete default server install? If it works smoothly, then tracing your steps back to when it first happened may help to find out what happened.
I know you may have difficulty understanding the database and (possibly), the problems you experience, but one thing I can assure you, the default server, as a whole, functions as intended. I am constantly goofing around testing (abnormal) things, then when I am done, I delete the whole database and download a fresh copy, which functions, as it should with all it's default settings. Sometimes, when there is updated source code (for the binaries), I will re-compile those as well.
In most cases, the reason anyone has issues with part of a server not working properly, it's something that happened on their end.(on their computer). This could be anything from a needed app that wasn't installed correctly, to configs that were edited wrong, or databases that got edited and/or corrupt in some way that caused a malfuntion. I just installed a fresh database last night and it's working as expected, with all it's default settings. That whole process, including getting it fully updated only takes me about 10 minutes.
But that's something anyone can do, once they have the knowledge and experience to work with these servers. It also helps to have some more advanced knowledge of your computer. (files, folders, apps, etc.). Believe me, 25 years ago, when I had absolutely no knowledge of computers, if I would of came to a site like this, I would of shut my puter off and went back to my nintendo ;)
Before I did start monkeying with this project 9 years ago, I had never dabbled in anything related to perl, sql or databases. I had no experience at all. A lot of reading, trials and tribulations learning the basics of it all. But because this whole Emu project is forever improving and evolving, the learning never stops. It's a lot easier when someone stays on top of it, rather than going awol for awhile and coming back to a brand new chapter. For those simply using the installer and the updater, it's not a concern anymore, but for many doing custom work, manual installs and updates, it can be tedious reviving an old server and getting it up to date without breaking it. (custom content).

Thanks for the big feedback. I thought I was using the wrong terminology, but I wasn't sure.

The table names thought, came to me while half-asleep, and having stared at the screen for something like 14hrs, and now makes more sense to me lol.

I'm trying to recall, if I tried a new toon, on the fresh server, prior to fixing the Environmental issue, and making any changes. I don't think I did. I think now that one issue is out of the way, it's time to start a fresh folder (or perhaps, walk back some of the major changes I made), and see what happens. Suppose the best thing I should do, is make one change, then see how it affects the server.

I think my frustration and, let's say, lack of knowledge, led me to overthinking and not slowing it down lol

STATUS UPDATE

-Deleted the Server Folder
-Uninstalled Perl
-Uninstalled MariaDB
-Deleted any left behind folders.
-Restarted PC
-Ran CCleaner directory cleaner
-Unzipped server archive into folder on my D: drive (My SSD)
-Ran installer
-Installer eventually fails "MySQL path not found..."
-Update Environmental Variables
-Server install proceeds -> Complete
-modify "login_server2" in config.json file to reflect LAN ip
-Boot up server "t_start_server_with_loginserver"
-error logging into loginserver (presumably because I've not inputted any login credentials)
-log on to server
-make Froglok Warrior
-spit out in South Qeynos >:|
-"No start_zones entry in database, using defaults" under World.exe prompt


You also asked for PC specs:
More specifically, an Asus ROG Strix II Laptop.

The only other server software I've ever run, to my knowledge, would be ASM (Ark Server Manager). It was a pretty dummy proof piece of software, where everything was handled in one single window. You simply filled out fields to alter the server, and input mod id's. I uninstalled it, about the time I decided to give this a shot.

I knew I forgot something! Took this from the forementioned Froglok Warrior. This happened on all new toons.


https://oi32.photobucket.com/albums/...psfe22udes.png



Is it possible this issue is Client-side? I just remembered that my Titanium folder has been altered to play in P99.

Tested with a fresh install of Titanium (because when I setup p99 for this comp, I didn't bother to backup to OG files *cough). No affect, outside of UI changes.

Sorry Stubbay, I hadn't used Titanium client in a long time, but I just fired it up and logged into that fresh install, and it's definately a client issue with the character creation. I got the same thing as you.
BUT, when I login with an RoF2 client it works as it should. Every toon has it's choice of the classic start zone or Crescent Reach, which is normal. (frogs in rathe mountains). This is with all expansions enabled, no db edits. I'm going to play with this for awhile and see what happens.

Ah, damn... At least, that aides in the diagnostics.

I have forgotten to say, thank you, for the immense amount of IT support you've been giving me. I've seen you all over the board, reading other related posts lol.

Guess I'll take to poking about my client files, then; see if I find anything, in the meantime.

Found this, in Everquest\logs\dbg.txt:

The only anomaly that stood out to me, so far. This file does not exist in my EQ folder. As it's an s3d, though, I assume this is purely a visual file of some sort. When I look for this specific file, online, I get a lot of results related to Luclin models.

Just updating the post, I suppose.


EDIT:Against my better judgment, I decided to take this issue to the folks over at P99. Hopefully, they won't mind my non-P99 issue. I'm using Titanium to play just fine on their server; so, thought it wouldn't hurt to ask.

Update: the P99 dbg.txt, shows the same "error". So, I'm guessing this absolutely has nothing to do with the issue. I'm trying to figure out what files/tables/etc., are responsible for communication between the client and server. I assume the issue may be there, but really, I'm taking what I assume are educated guesses.

EDIT:The patch_titanium.conf & opcodes.conf, look oddly similar. I thought "op" was for "other patcher" or something (swear I read that, somewhere). Wondering if this is the culprit; if I can simply steal OP_CharacterCreate from one of the other patch files, such as SoF. May try it. *shrug*


EDIT: Tried the above... caused errors and a crash lol.

I stared at the P99 files, for a while, and the only file that seems like it would have any real effect, was dsetup.dll. I threw this into my client folder, and it did nothing. I'm guessing the issues, have to be server-side, but with how it communicates with Titanium, specifically. At least, I feel like I'm narrowing things down.

I've noticed something new, and am not sure if this is considered"normal".


Currently searching around for topics related to this, but so far very little. Nothing that seems specific to Titanium, at least.

Clients do not stay logged into the login server.

They are handed off to a world server..so, that's normal behavior.

Well, that clears that up for me, thank you!

Update:Didn't know until today there was a way to get more info out of the logs. Inc wall text! (trimmed for obvious reasons)

This most definitely struck me as odd. This character was supposed to be a Froglok. I tested this with three other races, and none were anomalous like this was:

This is as I finalized the little Froglok Warrior:
Now, I came across this yet, there was no further follow up. If this guy was on the right path, I have no idea where to insert any code as the thread was left unresolved, and the user hasn't been active in 2yrs. I've been looking around, but no where seems "obvious" to me.

I've tried a few places, and caused nothing but crashes. So, even if I was adding the right code in, it was in the wrong places.

Froglok's aka Guktan's were not a playable race during the Titanium era.

Ah, right. Hadn't thought of that. Thanks!