View Single Post
  #1  
Old 01-09-2012, 10:09 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

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.
Reply With Quote