View Single Post
  #3  
Old 09-18-2008, 09:15 AM
So_1337
Dragon
 
Join Date: May 2006
Location: Cincinnati, OH
Posts: 689
Default

It's definitely possible. Here's a quick tutorial:

Find what item you want it to look like on Lucy. Say I want to put the Sword of Truth graphic on a different sword. At the top right, go to "Raw". Scroll down until you find "idfile", and grab that value. In this case it's IT10025.

Now, let's find what item we want to put it on. Let's say we want it on Greenmist, item #5127. (The item IDs in the database match up with Lucy's system, as you probably already know; just saying it in case you hadn't caught it.)

Let's put a query together now, based on those:

Code:
UPDATE items SET idfile = 'IT10025' WHERE id = 5127;
We're changing the ID file in the items table where we find that value. Just run this query in MySQL or Navicat or whatever database tool you're using, and you should see the new graphic after a reboot.

Between this and the material field, you can really affect the look of weapons and armor. It really bothers me that Torque of the Wyrmlord and Seru's Torque don't have graphics when you wear them on your arms or wrists, so I usually add a graphic to them if I get tired of looking like a lizard wearing a wifebeater. I know Lauren always insists that her mace look pretty, so I had to update the graphic on Blackstar to something sparkly.

I'm off topic now, I think I answered everything for you =P Send me a PM if you still have interest in those queries, I'll send you what I have.
Reply With Quote