EQEmulator Forums
Page 7 of 10 « First 3456 7 8910
Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   General::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=601)
-   -   Updated Solo Server Package (https://www.eqemulator.org/forums/showthread.php?t=42039)

Rodnoldo 05-24-2019 05:49 PM
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 05-24-2019 07:17 PM
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 06-06-2019 03:07 PM
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 07-21-2019 07:37 PM
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 07-22-2019 06:25 PM
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 07-22-2019 06:30 PM
Quote:
Originally Posted by Uleat (Post 263064)
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.

Uleat 07-22-2019 08:41 PM
We use ProjectEQ's database, which is currently at 'Omens of War.'

Reggatta 07-31-2019 05:03 PM
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?

woton 10-20-2019 07:18 PM
just wondering, how do we bring the PoK books back?

Huppy 10-20-2019 11:44 PM
Did you delete them ? lol

woton 10-21-2019 01:35 PM
We used this server pack and the poK books in starting zones were removed as part of it.

Huppy 10-21-2019 03:00 PM
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.

woton 10-21-2019 03:27 PM
Thx for the info.

Huppy 10-21-2019 03:50 PM
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.

Huppy 10-21-2019 04:15 PM
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);


All times are GMT -4. The time now is 07:05 AM.
Page 7 of 10 « First 3456 7 8910
Show 40 post(s) from this thread on one page

Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.