PDA

View Full Version : Way to Mass add loot drop ids?


Terethian
08-31-2007, 10:41 PM
Not sure where to post this since it's more of a database question but....

I have very limited visual c++ skills and i have the diablo loot program but what I want to do is take a single lootdrop ID code and add that SAME ID code to every loot table for every npc. I tried changing the source code but I keep having it crash after the first entry...... Any help on this?

Terethian
08-31-2007, 10:58 PM
Ok I did NOT mean to post this in this part of the forum at all. I thought I was in a different area. I tried to delete post but doesn't seem possible?????

GeorgeS
09-01-2007, 03:52 PM
You mean assigning a single lootdrop id to every NPC in the table - if so, that's very simple in SQL.


UPDATE npc_types SET loottable_id=1000 WHERE id>0


GeorgeS

If this is not what you wanted, then sorry for misunderstanding the message