Updated Solo Server Package

[l0stmancd]

The script is being ran up to the point it hits that MySQL call. You hail them, it responds, it binds, just quietly fails at that point.

Since the script is perl I would assume this means perl is running it.

[djeryv]

I run mine on Linux. Not sure it is an issue. Just mentioning it.

Also, you can have perl installed all day long...but if you don't have the MySQL plugin installed for Perl, you won't be able to run queries. The reason you can't leave the tutorial is because it does a MySQL query to see where to put you based on your character. It is getting stuck like the other scripts in my package. I never mention this in my readme because I thought it comes default with the package...but maybe I am wrong.

So make sure the DBD::mysql - MySQL driver is installed.

[Element D]

Not sure if I should have created a new thread for this, but is there anything in this package that caps leveling at 70? I can command level (#level) past 70, and still gain xp, but no further leveling naturally. AA leveling is normal.

By "still gain xp" i mean it shows the xp bar increase, but when its full it just resets with no level gained.

[Riklin]

I have been playing this solo server for a while. First, I set it up on a windows 10 pc, and run it using the local login server. The setup was extremely easy. Akka really made it simple, compared to the old way, which used to take a full day to set up... copying the files from the solo_server zip file was no problem, and the sql script itself ran flawlessly. Anyway, on to the game itself...

The GOOD:
The added NPCs work nicely and are a nice addition. The additional quests are definitely welcome, as something new to work on! In zones that used to be train "traps" like blackburrow, befallen, crushbone, you can single pull and fight much easier than before. In all my hours, I have not had a single train. A few adds, yes, but no trains. The gear that you get from the new quests is pretty good for the level, compared to what you used back in the day, the first time through. All in all, this looks promising and will likely provide a bunch of hours of enjoyment.

The Bazaar merchants are a really, really nice addition, btw!

Things I question:

1. I am finding the npc's regen faster than they used to. For instance in blackburrow, they will be back up to around 70% in 12-18 seconds! Not sure if this was intentional, to me that makes it less solo useful...

2. I find the respawn delay to be more of a hindrance than a benefit. EverQuest is a grind. NPCs do not drop what you want every time. Because of this additional delay, it makes quests in the game that depend on rare drops, even more of a pain to do.

3. The shaman in pok would be much more useful if he was more "prolific", as in found in more than PoK. SoW is one of the key spells in Norrath, and with the shaman in 1 place, that puts people dependent on PoK... EDIT: just found the SoW pots in the Bazaar... Oops...

4. If you set the character to a GM, you will see that the "character_aura" table is missing, and this is with the latest Akka windows install.


Thank you for offering this solo server package! It is a welcome diversion!

[GlassDeviant]

1. Maybe compared to live "real" EQ, but the npc regen seems to me pretty accurate for the RoF2 expansion, which is the max client level which will work with EQEmu.

2. Respawns are pretty close to what I remember, having played since 1998 (beta) through VoA.

3. Yeah, with all the potions available the shaman is not really necessary. All of my characters run with at least a stack of every useful one (sow, mana regen, hp regen, haste, etc. as appropriate to their classes).

4. It's possible that your install hit a snag, all of the tables are fine on my solo server but I had to run the install twice to get it completely installed properly. Try running some aura buffs from the console and see if they show up in the auras window and actually work. If they don't you may need to reinstall over top of your existing server.

[Riklin]

When you started playing EQ is irrelevant. The conversation here is specifically about this solo server mod with the current PEQ source, used in AKKA's great install scripts. The respawn rates were one of the very specific things this solo pack changed! The respawn rates are very different, especially for zones that used to be common for trains. Some of these very zones btw, are ones with rare spawns that are already a pain. This makes those even take longer with the longer respawn rates. These respawn rates are also very different than the default PEQ database.

Regarding the character_aura table, I found where that table was added back in June this year, so copied the sql and added that table. character_aura is definitely missing from the current peq source. Regarding install problems, nothing was in the log files after the install, and I installed this TWICE, once on a Debian Linux box and again on a windows 10 box. BOTH setups showed these SQL messages after the account.status was set to 250.

There is also another SQL error that shows up when you search in the bazaar. Apparently this year sometime a change was made to items.spellid was changed to items.clickeffect. There appears to be SQL still dependent on that spellid column, specifically when you perform a search in the bazaar.

[djeryv]

You could reload all of the database tables from source (excluding character ones), and then take out any respawn change queries I have in my solo server package. Then load my solo server package and you will have the original respawn times but all of my other stuff.

[Riklin]

That is exactly what I was looking into. I'm only about half way through the code so far, but I'll find the stuff to comment out soon, I hope...

[djeryv]

Get rid of this part and you will be all set

-- This increases spawn rates for the quick spawning monsters
-- It allows you to clear dungeons easier

UPDATE spawn2 SET respawntime=1800 WHERE respawntime<1800;

...or reduce the time.

[anithos]

I ran the eqemu installer from akkadius and only running a local server. I can join and play the server from a fresh install but as soon as I modify the database with the solo-server.sql I can no longer see the server running in game. I followed the steps in the read me and from other post in this thread. It does appear to be up and running from what I can see on the cmd windows running. Anyone have any advice?

[Techungry]

First I want to thank you for the scripts as this has made a fairly entertaining solo server for me and my friends so far. Curious if you developed any approaches to scaling down NPC spells? These updates work pretty well for most content but I found a few issues one you start getting into higher levels.

NPC pets were not scaled. The best approach I came up with to solve this one was to identify pets which were NPC only and a scale those. Not sure how well that will work in the long run if there are lots of NPCs using pets which are also use for PCs.

NPC spells are still full strength. Have to be real careful dealing with casters. Raid targets fall into this category as well. Any spells or procs they have do full damage still. I am not sure how best to approach this one other than going through one by one .

I also had to edit the Perl script for the Sister in PoK, who could sent you to zoned not yet done where NPC’s hit for millions...I just removed those from her list.

[bigwhitebuddha]

Hey there,

First of all, thank you so much for putting together this for everyone! I was wondering if someone could give me a hand with an issue I am experiencing.

After installing the Akka's repack, I downloaded your server files. I placed all of the .pl files in the correct location, but am having trouble figuring out where to put the main .SQL file. I placed it in the mariadb folder with the other .sql files, but this proved to do nothing.

I have tried to look on various forums and guides and haven't discovered anything in regards to overwriting sql files. Can anyone help me with this?

[Monet]

Hey there, first off thanks for the work you've put into this! Really enjoy the changes you've made and looking forward to getting further into it to take out some of those bosses I've always wanted to get revenge on

Having a bit of an issue in playing with a friend. Got the server up and running fine, shows up on the server ist, we can both log in (me locally from the same machine, him via the internet), and we can adventure and kill things and take their stuff normally. However, if we Hail the new added NPCs (Teacher, etc.) it will crash the other player's client. He hails the Teacher, I crash, I hail the Teacher, he crashes. If I'm by myself, I can use them fine. Any clues as to what is going on?

I'm thinking my system should handle things fine, but here are the specs: Windows 10 Pro, i7 4790K quad core @ 4GHz, 16G RAM, GTX 1080Ti card, and the server is running off an SSD drive.

[bigwhitebuddha]

After doing some digging, I realized that the sql file is on a server...

However, I am still having trouble understanding how to tell my existing server to source the new sql file given by this forum. Any help?

[John C]

The SQL file in this package are the statements that have to be executed once in order to update the database. You CTRL-C copy the entire file and then paste it into the Query tab in HeidiSQL and run them from there. There are a lot of details on how to do that on page 2 of this thread if you aren't familiar with Heidi. Good luck and let us know if you still have trouble.