Thread: Classic Queries
View Single Post
  #1  
Old 03-01-2008, 03:59 PM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

I'd have to ask what you do currently when you want to update to the most recent version of the PEQ database, but don't want to lose your custom changes? Do you have queries made up already that source all your changes back in? That's definitely the best way to go, as it lets you keep current, but lets you customize it the way you see fit.

Depending how many changes you have, I recommend you go back and turn all the changes you made into queries that will re-create the work. To get all the information for just those two zones is a lot of work, though that's from my perspective; I'm sure there are people who know tricks with the databases that I can't even fathom

Of course, it's easy for me to suggest you do things the way that I do them =P Every time I update the database, I source in a .sql file with these queries and more:

Code:
### This allows the rogue epic to be equipped in the range slot like it used to be ###
UPDATE items SET slots = 26624 WHERE name = 'Ragebringer';

### This gives the Robe of Living Fungus regen like in the old days ###
UPDATE items SET regen = 15 WHERE name = 'Robe of Living Fungus';

### This sets the Evil Eye in Guk to drop the Bag of Sewn Evil Eye 90% and Manastone 10% ###
UPDATE lootdrop_entries SET chance = 90 WHERE lootdrop_id = 47116 and item_id = 17354;
INSERT INTO lootdrop_entries VALUES (47116,13401,1,0,10);

### This makes the Ghoul Assassin drop the Guise of the Deceiver rather than the Mask of Deception ###
UPDATE lootdrop_entries SET item_id = 2469 WHERE item_id = 2472;
Either way you go, good luck. It sounds like you're lucky that circuitdragon is willing to help you out if you resort to doing it the hard way, but I recommend getting your changes made permanent like the method above.
Reply With Quote