Need original NPC locations for Old Bazaar

[cavedude]

Way back in the day before I took over PEQ (2005ish) I had my own database that I am fairly certain had old Bazaar spawned. I did some searching and I dug up an older version of that database. I did a quick peak in the file, and I see spawnpoints in bazaar so it looks like it may be good. I do know new Bazaar was not spawned until after I took over PEQ, so it wouldn't be in that database.

I always wanted to get old bazaar sourced into PEQ for preservation so I may actually take a look at this. But, feel free to extract and if needed convert the data that you need. Of course, our collection methods back in the day were primitive compared to what we have now, so it's not going to be 100% accurate, but it sure beats spawning the entire zone from scratch. Plus, I remember Bazaar being a very basic zone.

Here is the database: http://www.peqtgc.com/cavedude0.6.0-DR3.zip

[cavedude]

Alright, here you are. I extracted old Bazaar from my old database, and converted the data for our current schema and IDs. You can grab it here: http://www.peqtgc.com/oldbazaar.sql

That is the exact file I sourced into PEQ, so the IDs won't conflict if you are using PEQ as a base. Most of them are using auto increment anyway, only npc_types, spawngroup, and merchantlist (uses npcid) aren't. It is also setup to be version 1 of Bazaar, with a static instance ID of 3. So, if you want to see the zone without changing anything, you'd do a #zoneinstance 3 in-game. If you need it to be the base zone, just change all the version columns to 0, and delete the instance_lockout query.

Finally, of course your client needs to be using the .s3d version of bazaar, and the .eqg version is moved, deleted, or renamed.

[EQstarr]

Thanks, I'll take a look at that. I didn't think of the zone instance, but I'll try that too. It gives me some ideas that I could use on some of the other revamped zones.

I'm also going to try looking at the first file you posted too, just for some of the other zones. I'm hoping I can use your PEQ 4.0 Server Pack to quickly set it up, drop the tables, and then load in that SQL.

[cavedude]

That database came from version 1.0 of the installer, which wasn't even released under the PEQ name (I didn't take over PEQ until about version 3.6 or so) so you'd need to do a lot of work to get it compatible with the 4.0 release, even more to get it current.

However, I do know of one gem somewhere in my old databases... Grobb is spawned as Gukta, with the Frogloks running the city, and the Trolls in Neriak. I remember collecting and spawning that zone myself. But, I don't know which version that is in. The database I linked above is one of the older ones... I'll have to see about finding the newest one as all of the old server pack links are now dead :(

[EQstarr]

Originally Posted by cavedude

That database came from version 1.0 of the installer, which wasn't even released under the PEQ name (I didn't take over PEQ until about version 3.6 or so) so you'd need to do a lot of work to get it compatible with the 4.0 release, even more to get it current.

However, I do know of one gem somewhere in my old databases... Grobb is spawned as Gukta, with the Frogloks running the city, and the Trolls in Neriak. I remember collecting and spawning that zone myself. But, I don't know which version that is in. The database I linked above is one of the older ones... I'll have to see about finding the newest one as all of the old server pack links are now dead :(

THAT would be awesome data to have access to! Essentially, one could create a constant war between the trolls and frogloks so that for awhile it is Grobb and other times Gukta.

[EQstarr]

Originally Posted by cavedude

Alright, here you are. I extracted old Bazaar from my old database, and converted the data for our current schema and IDs. You can grab it here: http://www.peqtgc.com/oldbazaar.sql

I think this might actually work for me. I've been going through the code to look at Spawn points, etc.

I already have many of the NPC's in place for the Old Bazaar. All I needed was something a little more "official" to double-check against my work and make a few more fine-tune adjustments. I know some of the NPC's I placed are wrong, so this will help.

[cavedude]

I'm told only one NPC is missing, compared to EQMac. The rest of the zone is identical.