Way to Mass add loot drop ids?

[Terethian]

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]

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]

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