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
  #91  
Old 05-24-2019, 05:49 PM
Rodnoldo
Fire Beetle
 
Join Date: Nov 2004
Location: Colorado
Posts: 15
Default

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.
Reply With Quote
  #92  
Old 05-24-2019, 07:17 PM
djeryv
Hill Giant
 
Join Date: Apr 2008
Posts: 234
Default

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.
Reply With Quote
  #93  
Old 06-06-2019, 03:07 PM
Hondo
Fire Beetle
 
Join Date: Jul 2010
Posts: 3
Default

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!
Reply With Quote
  #94  
Old 07-21-2019, 07:37 PM
Angelicus6
Fire Beetle
 
Join Date: Mar 2009
Location: Florida
Posts: 13
Default

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?
Reply With Quote
  #95  
Old 07-22-2019, 06:25 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

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
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #96  
Old 07-22-2019, 06:30 PM
Angelicus6
Fire Beetle
 
Join Date: Mar 2009
Location: Florida
Posts: 13
Default

Quote:
Originally Posted by Uleat View Post
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.
Reply With Quote
  #97  
Old 07-22-2019, 08:41 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

We use ProjectEQ's database, which is currently at 'Omens of War.'
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
  #98  
Old 07-31-2019, 05:03 PM
Reggatta
Fire Beetle
 
Join Date: Jul 2019
Location: New Hampshire
Posts: 2
Default

I just checked out the Bazaar, and it's nearly empty. That is, there are no merchants. I see Brother Dremel, however. Do you have any suggestions on how to restore the merchants?
Reply With Quote
  #99  
Old 10-20-2019, 07:18 PM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default

just wondering, how do we bring the PoK books back?
Reply With Quote
  #100  
Old 10-20-2019, 11:44 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

Did you delete them ? lol
__________________
Hanging out at Antonica.World
Reply With Quote
  #101  
Old 10-21-2019, 01:35 PM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default

We used this server pack and the poK books in starting zones were removed as part of it.
Reply With Quote
  #102  
Old 10-21-2019, 03:00 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

In the database, (doors table), they are called POKTELE500 (for the old zone versions) and OBJ_POK_BOOK_ (for the revamped version) If those entries are missing, you would have to grab a fresh DB and copy the entries from there.
__________________
Hanging out at Antonica.World
Reply With Quote
  #103  
Old 10-21-2019, 03:27 PM
woton
Sarnak
 
Join Date: Mar 2019
Posts: 88
Default

Thx for the info.
Reply With Quote
  #104  
Old 10-21-2019, 03:50 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

I just looked at that "solo package" and noticed in the script where those pok books were deleted. Not sure why it was handled that way, (by the author of the script), they could of simply been renamed to prevent them from spawning. Here is that query:
Code:
DELETE FROM doors WHERE id=9 OR id=2353 OR id=2561 OR id=3415 OR id=4139 OR id=4968 OR id=4969 OR id=5070 OR id=7123 OR id=5337 OR id=5783 OR id=5996 OR id=6623 OR id=9363 OR id=12283 OR id=12797 OR id=12913 OR id=17404 OR id=34179 OR id=14156 OR id=33835;
I'll put a query together, to restore these door entries.
__________________
Hanging out at Antonica.World
Reply With Quote
  #105  
Old 10-21-2019, 04:15 PM
Huppy's Avatar
Huppy
Demi-God
 
Join Date: Oct 2010
Posts: 1,333
Default

If you copy and paste this into a query, it will put those deleted pok book entries back in the doors table.

Code:
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (12283, 78, 'nektulos', 0, 'POKTELE500', 742.973, -342.478, -8.34902, 267.81, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 132, -841, -157, 1, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (5070, 1, 'Innothule', 0, 'POKTELE500', -729.133, -29.9866, -29.2157, 477.21, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 69, -813, -145, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (9, 8, 'Tox', 0, 'POKTELE500', 2324.96, -582.532, -47.8143, 120, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 35.9378, 630, -145, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (4969, 109, 'Gfaydark', 0, 'POKTELE500', -173.6, -757.995, -4.09175, 163.29, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 884, 871, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (4968, 108, 'Gfaydark', 0, 'POKTELE500', -2260.51, -1820.6, -1.68313, 17, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 73, 811, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (3415, 1, 'Everfrost', 0, 'POKTELE500', 2887.25, -78.1207, -64.1542, 238.73, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 132.109, 873, -145, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (4139, 44, 'Misty', 0, 'POKTELE500', -559.555, -1262.71, 6.89263, 2, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 1229, 871, -155, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (5337, 77, 'feerrott', 0, 'POKTELE500', 867.158, -161.403, -9.75448, 504, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 444, -844, -157, 255, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (2353, 7, 'Tox', 0, 'POKTELE500', -2344.14, 295.884, -49.748, 371.01, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 1228, -893, -152, 252, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (2561, 46, 'Steamfont', 0, 'POKTELE500', -1373.04, 933.79, -111.662, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -75, -421, -155, 0, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (6623, 77, 'fieldofbone', 0, 'POKTELE500', -3010.88, 1843.5, 8.377, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 36, -655, -157, 1, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (5783, 177, 'freportw', 0, 'POKTELE500', -682.064, 77.3664, -34.8048, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -234, -406, -157, 2, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (5996, 77, 'qeynos2', 0, 'POKTELE500', 183.698, 484.484, 0.002, 3, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -289, 147, -157, 127, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (7123, 77, 'overthere', 0, 'POKTELE500', 3134.56, 1937.59, -53.3417, 384, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, 884, -840, -157, 254, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (9363, 78, 'shadeweaver', 0, 'POKTELE500', -3011.8, -2425.1, -218.342, 494, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, -293, 364, -157, 192, 0, 511, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (14156, 37, 'crescent', 0, 'POKTELE500', -1213, -2761, -113.5, 130, 58, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'poknowledge', 0, -127, 58, -155.9, 63, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (12797, 212, 'rathemtn', 0, 'POKTELE500', -1176.75, 305, -3, 32, 58, 0, 0, 0, 0, 0, 0, 0, 0, 23, 'poknowledge', 0, 1182, 771, -156, 128, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (12913, 78, 'butcher', 0, 'POKTELE500', 1754.95, -506.765, -3.65425, 258.958, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 474, 829, -157, 255, 0, 511, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (17404, 77, 'innothuleb', 0, 'POKTELE500', -443.25, -361.75, 2.5, 0, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 95, -812, -157, 384, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (33835, 77, 'arena', 0, 'POKTELE500', -1022.76, 147.807, 46.7928, 504.45, 58, 0, 0, 0, 0, 0, 0, 0, 0, 77, 'poknowledge', 0, 140, -430, -152, 260, 0, 0, 100, 0, 4294967295, 0);
INSERT INTO `doors`(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `disable_timer`, `doorisopen`, `door_param`, `dest_zone`, `dest_instance`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `client_version_mask`, `is_ldon_door`) VALUES (34179, 4, 'feerrott2', 0, 'POKTELE500', 1300, 212, 50, 201, 58, 0, 0, 0, 0, 0, 0, 0, 0, 25, 'poknowledge', 0, 444, -844, -157, 127.5, 0, 0, 100, 0, 4294967295, 0);
__________________
Hanging out at Antonica.World
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 01:03 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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3