Need original NPC locations for Old Bazaar

[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.