|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
General::Server Discussion Discussion about emulator servers. Do not post support topics here. |
05-24-2019, 05:49 PM
|
Fire Beetle
|
|
Join Date: Nov 2004
Location: Colorado
Posts: 15
|
|
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.
|
05-24-2019, 07:17 PM
|
Hill Giant
|
|
Join Date: Apr 2008
Posts: 234
|
|
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.
|
06-06-2019, 03:07 PM
|
Fire Beetle
|
|
Join Date: Jul 2010
Posts: 3
|
|
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!
|
07-21-2019, 07:37 PM
|
Fire Beetle
|
|
Join Date: Mar 2009
Location: Florida
Posts: 13
|
|
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?
|
07-22-2019, 06:25 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
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
|
07-22-2019, 06:30 PM
|
Fire Beetle
|
|
Join Date: Mar 2009
Location: Florida
Posts: 13
|
|
Quote:
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.
|
07-22-2019, 08:41 PM
|
|
Developer
|
|
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
|
|
We use ProjectEQ's database, which is currently at 'Omens of War.'
__________________
Uleat of Bertoxxulous
Compilin' Dirty
|
07-31-2019, 05:03 PM
|
Fire Beetle
|
|
Join Date: Jul 2019
Location: New Hampshire
Posts: 2
|
|
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?
|
10-20-2019, 07:18 PM
|
Sarnak
|
|
Join Date: Mar 2019
Posts: 88
|
|
just wondering, how do we bring the PoK books back?
|
10-20-2019, 11:44 PM
|
|
Demi-God
|
|
Join Date: Oct 2010
Posts: 1,332
|
|
Did you delete them ? lol
|
10-21-2019, 01:35 PM
|
Sarnak
|
|
Join Date: Mar 2019
Posts: 88
|
|
We used this server pack and the poK books in starting zones were removed as part of it.
|
10-21-2019, 03:00 PM
|
|
Demi-God
|
|
Join Date: Oct 2010
Posts: 1,332
|
|
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.
|
10-21-2019, 03:27 PM
|
Sarnak
|
|
Join Date: Mar 2019
Posts: 88
|
|
Thx for the info.
|
10-21-2019, 03:50 PM
|
|
Demi-God
|
|
Join Date: Oct 2010
Posts: 1,332
|
|
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.
|
|
|
|
10-21-2019, 04:15 PM
|
|
Demi-God
|
|
Join Date: Oct 2010
Posts: 1,332
|
|
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);
|
|
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 03:51 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|