View Single Post
  #2  
Old 03-13-2008, 08:52 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

Use this query:

Code:
UPDATE npc_types SET d_meele_texture1 = XXXXX WHERE id = YYYYY;
The Xs are the 'idfile' value that you'll find when looking at the raw data for a weapon on Lucy or in the database and the Ys are the NPC ID. Use only the numbers that you find.

For example, Seru holds the Sword of Truth [which has an 'idfile' value of 'IT10025'] and he is NPC ID 159690. So the query for him looks like this:

Code:
UPDATE npc_types SET d_meele_texture1 = '10025' WHERE id = '159690';
Reply With Quote