Updated Solo Server Package

[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?

[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.

[greenspectre]

I just wanted to say thank you for all the work you've done on this package. I look forward to giving it a good try, but I have a tech support question. I followed you instructions and set my server up, was able to log into it and make a character and everything, but I'm noticing the mobs in Gloomingdeep at least are not respawning at all. This includes the barrels and nests. Is that a package problem or a server setup problem?

[Techungry]

One of the items in the script lengthens drastically the spawn times to 30 minutes. Restore your DB table and comment out this line before running the script again.

UPDATE spawn2 SET respawntime=1800 WHERE respawntime<1800;

I choose to start over myself and remove that and a few other things. With the scaled down NPC's and reduced agro ranges its really not necessary. I also choose to replace the NPC scaling and instead used Akkadius scaling tables because it effects both melee and spells. If you use this script NPCs can’t hit you well with melee but they still do full damage with spells and heals so any caster is pretty sketchy if it’s red or yellow.

I know it wasn't the question but I though I would share my modification to the NPC scaling so that it proportionally adjusted each based on their original values. I found that having every level X NPC having the same HP etc...lost some of the uniqueness and diversity of NPC's strengths. I used the spellscale and healscale columns in teh NPC tables to tune down their spells and heals on top of that.

Something like this. You can't run it twice without restoring npc_types table with original values since it bases the scale on the value at the time you run it. That list of ID's included under 1000 are NPC's pets I identified who were incredibly strong with the original script since they were not touched.

-- scale hp/damage down
-- =1-(LEVEL/81)
UPDATE npc_types SET hp=CEIL(hp*(1-(LEVEL/80))) WHERE (LEVEL<81 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET hp=CEIL(hp*(1-(LEVEL/80))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(1-(LEVEL/80))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(1-(LEVEL/80))) WHERE LEVEL>20 AND LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET spellscale=50 WHERE level>19 AND rare_spawn=0 AND raid_target=0 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET healscale=50 WHERE level>19 AND rare_spawn=0 AND raid_target=0 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));

[Melciah]

Techungy, if I want to try your hp/damage updates would I replace the npc_types section of the SQL when import, or run yours after the oroginal from Solo_server to get the desired results?

[Techungry]

It would be done in place of the related adjustments in the original script. In other words, the adjustment would be to the default out of the box table values. I am actually still tuning it a bit. Here is the entire adjustments I am using to the npc_types table. Just remove any sql related to adjusting the stats of the npc_types table in teh original script and use this in its place.

LOCK TABLES `npc_types` WRITE;
-- scale STR up to to hit more frequently
-- UPDATE npc_types SET STR=CEIL(STR*1.2);
-- scale hp/damage down
-- =1-(LEVEL/89)
UPDATE npc_types SET hp=CEIL(hp*(1-(LEVEL/89))) WHERE (LEVEL<81 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(1-(LEVEL/89))) WHERE LEVEL>20 AND LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET spellscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET healscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- adjust agro radius down
UPDATE npc_types SET aggroradius=CEIL(aggroradius*0.30) WHERE aggroradius>20;
-- scale resists down
UPDATE npc_types SET MR=CEIL(MR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET CR=CEIL(CR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET DR=CEIL(DR*(1-(LEVEL/89))) WHERE LEVEL<81 AND id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET FR=CEIL(FR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET PR=CEIL(PR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET Corrup=CEIL(Corrup*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UNLOCK TABLES;

[John C]

Techungry -
I just applied your adjustments to give them a spin. I like the scaling concept and was intending to do something similar, so thanks for sharing. Just FYI though, you lost a couple of parentheses during your cut and paste on the DR line (missing "((" just before "id"). I was able to correct it for my load, but you might want to do a little edit to ensure it works for others.

Update: I like the way it is playing so far. I just get naturally worried that there is no scaling applied to anything over level 80. It likely doesn't matter since most of those are outside of what is typically playable, but just to be safe I added a few lines to adjust them too - I just had to bend the nerf curve a bit. Just in case you are interested, here is what I am using:

LOCK TABLES `npc_types` WRITE;
-- scale STR up to to hit more frequently
-- UPDATE npc_types SET STR=CEIL(STR*1.2);
-- scale hp/damage down
-- =1-(LEVEL/89)
UPDATE npc_types SET hp=CEIL(hp*(1-(LEVEL/89))) WHERE (LEVEL<81 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(1-(LEVEL/89))) WHERE LEVEL>20 AND LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET spellscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET healscale=50 WHERE level>19 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- adjust agro radius down
UPDATE npc_types SET aggroradius=CEIL(aggroradius*0.30) WHERE aggroradius>20;
-- scale resists down
UPDATE npc_types SET MR=CEIL(MR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET CR=CEIL(CR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET DR=CEIL(DR*(1-(LEVEL/89))) WHERE LEVEL<81 AND id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET FR=CEIL(FR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET PR=CEIL(PR*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET Corrup=CEIL(Corrup*(1-(LEVEL/89))) WHERE LEVEL<81 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));

-- Adjusted formulas to change incline rate after level 80

UPDATE npc_types SET hp=CEIL(hp*(0.3-(LEVEL/400))) WHERE (LEVEL>80 AND ((id>1000 AND id<800000)) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET maxdmg=CEIL(maxdmg*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET mindmg=CEIL(mindmg*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
-- scale spell and heal down
UPDATE npc_types SET MR=CEIL(MR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET CR=CEIL(CR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET DR=CEIL(DR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET FR=CEIL(FR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET PR=CEIL(PR*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UPDATE npc_types SET Corrup=CEIL(Corrup*(0.3-(LEVEL/400))) WHERE LEVEL>80 AND ((id>1000 AND id<800000) OR id IN ('635','636','646','649','650','667','668','669',' 673','676','677','679','679','679','680','681','82 9','923','924'));
UNLOCK TABLES;

[Melciah]

Man, now I'm torn...

I love the idea of a modded server for solo play, but I've been looking into a few things and it appears that The Al'Kabor Project is everything I would want in a dream EQ1 server...minus the option for a LAN only version to customize further.

[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.

[l0stmancd]

FYI - I started up a new server installation on a cloud host and this works great. My family is enjoying this a lot.

Did anyone make custom quests of this sister style for levels above 20 or so? I can see us running out of 'quests' soon so thats a bummer.

Also - I found that one of the rewards in nektulos forest is a ring that _summons the mage epic creature_. So that was a thing. I thought it would be fun for a sec until I realized it made playing the game pointless and dropped it. Throwing that out there.

[Drosten]

Originally Posted by l0stmancd

FYI - I started up a new server installation on a cloud host and this works great. My family is enjoying this a lot.

This is a smart choice. We also host plenty of game projects in the cloud and this works like a miracle

[djeryv]

Originally Posted by l0stmancd

Did anyone make custom quests of this sister style for levels above 20 or so? I can see us running out of 'quests' soon so thats a bummer.

A Sister in the Plane of Knowledge has some over 20. If you fully used my package, almost all of the books to the PoK are gone from the starter areas to give that classic feel of starting in an area based on race. Anyway, there are a couple of PoK books left and I think one is in the center of the Karana plains.