Way to Mass add loot drop ids?
 

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?

woops
 

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?????

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