Project 1999

Go Back   Project 1999 > General Community > Technical Discussion

Reply
 
Thread Tools Display Modes
  #11  
Old 06-23-2019, 05:06 PM
Rogean Rogean is offline
¯\_(ツ)_/¯

Rogean's Avatar

Join Date: Oct 2009
Location: Massachusetts
Posts: 5,381
Default

Quote:
Originally Posted by loramin [You must be logged in to view images. Log in or Register.]
but then again I'm a bit of masochist when it comes to updating legacy code [You must be logged in to view images. Log in or Register.]
You and me both. The number of systems I've completely recoded and overhauled since we forked from EQEmu is many. I'm a bit of a performance OCD Freak. Recoding the Scripting engine would definitely improve performance too, but I'm not going to recode all those scripts and I can't expect any of the other devs to either.
__________________
Sean "Rogean" Norton
Project 1999 Co-Manager

Project 1999 Setup Guide
Reply With Quote
  #12  
Old 06-23-2019, 08:35 PM
Stubbay Stubbay is offline
Skeleton


Join Date: May 2013
Posts: 15
Default

Quote:
Originally Posted by loramin [You must be logged in to view images. Log in or Register.]
I know nothing about the EQ Emulator software, bu the error seems to be telling you everything you need to know right there. Apparently the EQEmulator program has database records in a table called "start_zones", and they specify which zone various races start in. You need to add those records, and because you haven't yet your server is spitting people out in "odd" default locations.

And if a random person who doesn't even know the software, on what really is the wrong message bard to even be asking, is helping you ... then I think it's probably time to step back and realize that you need to spend some time reading the EQ Emulator documentation [You must be logged in to view images. Log in or Register.]
The other person is experienced. My start_zones file is as it should be. That's why we're confused. It makes no sense, and as I pointed out, this issue appears to be specific to Titanium, as they were able to recreate this issue, with a fresh server install, and using both Titanium and SoF to connect to the server. SoF worked correctly; Titanium did not.

In fact, World.exe also gives this, despite SoF and Titanium start zones being set to -1:
HTML Code:
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 12 AND player_class = 7 AND player_deity = 203 AND player_race = 128

##How I got the name Bong through hitting random, I don't know
No start_zones entry in database, using defaults
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] (Bong) Zoning from character select tutorialb (Zone ID 189: Instance ID: 0)
[World Server] Account (Stubbay) Logging(Out) to character select :: LSID: 2
[World Server] Database::DeleteCharacter name : 'Bong'
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 12 AND player_class = 7 AND player_deity = 203 AND player_race = 128

No start_zones entry in database, using defaults
[World Server] Attempting autobootup of cabwest (82:0)
Zone_id= 12, is actually the chosen starting city (player_choice), on the character creation screen. However, it's reading it as the start_zone.

That comic about Perl got a genuine chuckle out of me lol.
Reply With Quote
  #13  
Old 06-24-2019, 10:41 AM
loramin loramin is offline
Planar Protector

loramin's Avatar

Join Date: Jul 2013
Posts: 9,340
Default

Quote:
Originally Posted by Stubbay [You must be logged in to view images. Log in or Register.]
The other person is experienced. My start_zones file is as it should be. That's why we're confused. It makes no sense, and as I pointed out, this issue appears to be specific to Titanium, as they were able to recreate this issue, with a fresh server install, and using both Titanium and SoF to connect to the server. SoF worked correctly; Titanium did not.

In fact, World.exe also gives this, despite SoF and Titanium start zones being set to -1:
HTML Code:
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 12 AND player_class = 7 AND player_deity = 203 AND player_race = 128

##How I got the name Bong through hitting random, I don't know
No start_zones entry in database, using defaults
[World Server] Attempting autobootup of tutorialb (189:0)
[World Server] (Bong) Zoning from character select tutorialb (Zone ID 189: Instance ID: 0)
[World Server] Account (Stubbay) Logging(Out) to character select :: LSID: 2
[World Server] Database::DeleteCharacter name : 'Bong'
[World Server] Found 'TitaniumStartZoneID' rule setting: -1
[Status] SoF Start zone query: SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 12 AND player_class = 7 AND player_deity = 203 AND player_race = 128

No start_zones entry in database, using defaults
[World Server] Attempting autobootup of cabwest (82:0)
Zone_id= 12, is actually the chosen starting city (player_choice), on the character creation screen. However, it's reading it as the start_zone.

That comic about Perl got a genuine chuckle out of me lol.

Again, I don't know EQEmulator at all .. but even not knowing it, it seems like you already have everything you need in that message:

Code:
SELECT x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z FROM start_zones WHERE zone_id = 12 AND player_class = 7 AND player_deity = 203 AND player_race = 128
Run that query. Presumably no database records come back. To fix it, run this one:

Code:
INSERT INTO start_zones(
  x, y, z, heading, start_zone, bind_id, bind_x, bind_y, bind_z, zone_id, player_class, player_deity, player_race
) VALUES (
  ?, ?, ?,       ?,          ?,       ?,      ?,      ?,      ?,       12,            7,         203,         128
)
Except replace the question marks with the x/y/z, bind x/y/z, and other details about where players of class 7, race 128, and deity 203 should start.

Run the SELECT again, see a record come back, and if it does your EQEmu should work (for that class/race/religion at least).
__________________

Loramin Frostseer, Oracle of the Tribunal <Anonymous> and Fan of the "Where To Go For XP/For Treasure?" Guides
Anyone can improve the wiki! If you are new to the Blue server, you can improve the wiki to earn a "welcome package" of up to 2k+ platinum! Message me for details.
Last edited by loramin; 06-24-2019 at 10:55 AM..
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 11:32 AM.


Everquest is a registered trademark of Daybreak Game Company LLC.
Project 1999 is not associated or affiliated in any way with Daybreak Game Company LLC.
Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.