Go Back   EQEmulator Home > EQEmulator Forums > General > General::Server Discussion

General::Server Discussion Discussion about emulator servers.
Do not post support topics here.

Reply
 
Thread Tools Display Modes
  #76  
Old 01-17-2019, 12:41 AM
anithos
Fire Beetle
 
Join Date: Oct 2010
Posts: 1
Default My server is no longer on the list after after I source the SQL

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?
Reply With Quote
  #77  
Old 02-07-2019, 12:39 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 22
Default

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.
Reply With Quote
  #78  
Old 02-10-2019, 03:38 PM
bigwhitebuddha
Fire Beetle
 
Join Date: Aug 2014
Posts: 2
Default Having trouble finding PEQ .sql file

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?
Reply With Quote
  #79  
Old 02-11-2019, 10:18 AM
bigwhitebuddha
Fire Beetle
 
Join Date: Aug 2014
Posts: 2
Default

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?
Reply With Quote
  #80  
Old 02-11-2019, 11:10 AM
John C
Sarnak
 
Join Date: Jul 2018
Location: Atlanta, GA
Posts: 49
Default

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.
Reply With Quote
  #81  
Old Yesterday, 12:04 PM
greenspectre
Fire Beetle
 
Join Date: Feb 2017
Posts: 7
Default

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?
Reply With Quote
  #82  
Old Yesterday, 10:35 PM
Techungry
Fire Beetle
 
Join Date: Jan 2019
Location: Georgia
Posts: 22
Default

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'));
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:52 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3