Updated Solo Server Package

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

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

[Rodnoldo]

Hello, planning to build this solo server for the family.
When I look at the Google Drive file, EQEmuSoloSettings.zip was modified Sept 4, 2018.

I see references in this forum thread indicating code updates and fixes. Also some tweaks.

Is all of this included in a version of the "solo_server.sql" downloadable someplace?
Or should I install the package from the Google Drive and run through this thread to add the fixes suggested?

Not complaining, just asking. Thanks, very much.

[djeryv]

The suggestions are just suggestions that are not included...so do the ones that interest you. I never needed them but our play styles differ.

[Hondo]

Been having a blast with your solo package, djeryv! Kind of just playing the game, as someone mentioned, like Baldur's Gate 2 with a group of bots. It's been a blast going back and visiting all those familiar locations. Plus, there's really an absolute ton of content in EQemu in general.

I've found you've really thought out your package well, as whenever I've needed something, or even just a quality of life improvement, one of your NPCs has met that need. I only wish there were more quests at higher level--you did a really great job on those. I suppose crafting will help me out there, as I really haven't started on that yet.

Anyhow, I just wanted to say thanks for all the time you put into this, and for sharing it. You've really helped turn EQ into a fun single player game. Also to Uleat for all your work on the bots, because wow, they are so well done.

Excellent job!

[Angelicus6]

My mom gave me a laptop to see if I can fix it up and use. It is only a year old, but it's not anymore near a powerhouse. It has an i3 8th gen processor, integrated graphics and 4Gbs of ram, but I know that it will play EQ at the very least. Was hoping to be able to set something like this up on the laptop and just play there as well.

Will this work?

Or should I just set it up on my PC and connect that way?

[Uleat]

I used to dev and play on an i3 1st gen with 4gb of ram.

I still have the same system..but, now with 8gb of ram

[Angelicus6]

Originally Posted by Uleat

I used to dev and play on an i3 1st gen with 4gb of ram.

I still have the same system..but, now with 8gb of ram

Thank you for the reply.

What expansion does this cover up to? I'm not sure I read that within the thread.