Quick Najena Door Fixes

Thristam · #1 07-23-2006, 03:16 PM

Thanks man, nice job =)

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

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

**hayward6** · #3 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 · #4 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** · #5 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 · #6 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 · #7 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 · #8 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

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.