Quick Najena Door Fixes

**hayward6** · #1 07-26-2006, 04:45 AM

Cant wait to test this out, Najena is one of my favorite zones... lots of memories.

**hayward6** · #2 07-26-2006, 11:59 PM

Wow This is great, I guess it worked because I was told I "opened the locked door with my magic GM key" Najena is such a nice zone. I'll have to bring my legit guy here.

Sarepean · #3 07-27-2006, 01:34 PM

Wow, to be honest, I didn't expect this kind of response to a couple of quick fixes.

Can't wait until the lockpick column is working as intended. =)

Befallen coming soon (just three quick doors, I'll probably do it Friday night or Saturday night).

I also may start working on Shadow Men spawns.

**hayward6** · #4 07-28-2006, 12:04 AM

Quote:

Originally Posted by Sarepean

Wow, to be honest, I didn't expect this kind of response to a couple of quick fixes.

Can't wait until the lockpick column is working as intended. =)

Befallen coming soon (just three quick doors, I'll probably do it Friday night or Saturday night).

I also may start working on Shadow Men spawns.

Befallen would be awesome, I just went there the other night to work on my server and found that the doors didn't reuire any keys.

Thanks alot,

Angelox · #5 07-28-2006, 01:47 AM

Quote:

Originally Posted by Sarepean

Wow, to be honest, I didn't expect this kind of response to a couple of quick fixes.

Can't wait until the lockpick column is working as intended. =)

Befallen coming soon (just three quick doors, I'll probably do it Friday night or Saturday night).

I also may start working on Shadow Men spawns.

Man, I'm starved for stuff like this, and I'm sure I'm not alone. I guess the most of us start up a server and think it's ready for play, in reality, it's not - there's many, many details that still need to be fixed.
Have you tried GeorgeS sql_browser? great for exporting data to SQL format - and I'm sure he'll customize more if you need.
http://66.159.225.58/eqemu/eq.html

Sarepean · #6 07-28-2006, 02:20 AM

I'm using HeidiSQL from the developer of Front-SQL. When I make any changes to my database, it shows me the SQL statement equivalent of the change I just made. So, I make all the changes I'm going to, copy all the SQL I used and then I trim it down to the smallest necessary number of statements. Using this program, I can also see the table layout, the data, and construct my own SQL statements to query the database all in the program.

If you haven't checked it out already, I'd give it a shot. It's a nifty little program with a lot of features and it's free. The only problem I see with it is that it associates itself with the .SQL extension. I haven't figured out exactly what opening an SQL file with the program does, yet, but I'm also not wanting to find out given that the EQ database is the only one I have. =P

I think I'll probably download the program you've directed me to this weekend and give it a go, but, in my opinion, the program I'm using is already damned convenient. =P When I was using Front-SQL, I was always having to query the database from the MySQL prompt rather then in the Front-SQL program, but the Query ability seems to work in HeidiSQL and gives me a quick way to go back and forth between Queries and data. =)

As I pointed out to someone requesting a #DoorInfo command--- Najena door fixes took me a whole 20 minutes to fix and then release to here and most of that was clicking a door several times and alt-tabbing out to see the information dump in the zone window so I could figure out what door. As far as the SQL went, HeidiSQL made that part easy. =D

Teppen · #7 07-28-2006, 04:27 AM

Would be a nice sub project to find a group of members that are dedicated to finding and fixing doors that require keys. Creating a sticky thread with the sql fixes per zone as they are updated would be nice. Please note, anyone interested in this would have to have an active live account if he or she was to help out. This would be nice to add to peq db, making it more like live. Im just talking here, but if anyone is actually interested in this, pm me sometime.

Oh, and Sarepean.. I requested the #DoorInfo command in the feature request forum because I didnt think one existed yet, and I thought it would be a nice addition to the commands, especially for a dev. I never thought of your method, and Im sure it would come in handy. My only problem with that method, is that my pc doesnt always like it when I alt-tab, sometimes it even locks up my eq with a "eq is not responding". So, that is why I requested a command to spit out the clicked door info into a log file.

-Teppen

Sarepean · #8 07-28-2006, 04:49 AM

I've kind of made it into a small sub project for myself, but I'm glad that it's an interest of several other people. The only areas I know really well are the classic areas and I no longer have a live account and have not had one for almost 2 years now.

Personally, I think that Allakhazams is good enough information for a lot of the minor additions we need to make. The comments and information a lot of people make under the database entries for Allakhazams is amazingly helpful, too.

After seeing the spawn condition part of the spawn2 table and then the spawnconditions table, I think I'm going to set to work on things like the Ancient Cyclops spawn and will probably check to see if the Kithicor undead have been fixed as well. =)

I can't think of a lot of old world zones that needed keys and had locked doors, though. =/ Najena and Befallen were all that I could think of when I sat down to try and figure it out. They were also some of the only dungeons.

What I would like to see after these fixes is more engaging quests to get people BACK into the old world zones. For instance, the Tome of Ages quest. I would honestly love to sit down with a group of people to try and get the entire quest done as a community type thing. Perhaps completing the entire Tome of Ages quest would spawn a random Fabled Creature so, to collect all the fabled gear, you would have to do the quest a ton of times--- lot of time and effort--- and, for their hard work, we change the fabled gear to be droppable?

I'd also like to see some kind of major quest in the Ocean of Tears to get people back into that zone now that the boats no longer work (and haven't for a long long time... not EQEmu's fault, this one is Sony).

EDIT:: I would kind of like to see the whole doors thing become a team thing as well. I'm knocking down Befallen this weekend. Who all is interested in participating in this? I'm figuring we probably need 2 or 3 people working on the doors if we have enough zones. The Hole will probably be the big one since that zone was designed to bring Thieves back into the team situation.

bobbydole · #9 07-28-2006, 07:14 AM

Quote:

Originally Posted by Angelox

Man, I'm starved for stuff like this, and I'm sure I'm not alone. I guess the most of us start up a server and think it's ready for play, in reality, it's not - there's many, many details that still need to be fixed.

I really think that shows you how far it's really come. If we didn't have these server packs, which allowed people to get a server running so easily, if the server & DB weren't so well developed as they are now, people wouldn't be so surprised/disappointed when they find something out of place.