Using Navicat to edit items or change items

[Huppy]

I am not trying to post something "new" here. I just thought
I would share this info for other "noobies" like myself who
were looking for ideas or tips on editing or changing items.
I know there's tools out there, but Navicat works for me.
I personally have no desire to find any easier method than
this, because I am in no rush when at the keyboard.

First of all, my goal was to create an item for a quest that,
in the end, would be a turn-in to spawn a named mob.
I didn't want to simply implement an already existing item
that was used for another quest or tradeskill, but at the
same time, I wanted to keep it simple for myself.(smirk)

I went looking through the "items" table in the peq and found
what was known as "Character Transfer Token" (itemid 51969).
(Page 45 in the items database)
Since its obvious this item will probably never be used on
the emulator servers, it was a perfect candidate for what I
needed.
For the purposes of this quest, I changed the name of it to
"Special Rat Cheese". I put the No Trade, Temporary, Lore
flags on it, and changed the lore description of the item.
Next I had to make it look like a piece of cheese, so I
logged on my GM toon and used #itemsearch cheese command, to
display a result I found called "a small wedge of cheese",
with itemid 58239.
I looked it up in the peq items table and noted the iconid
and idfile entries. Then on my quest item entry, I made sure
they were the same. Then voila! I logged on a toon, engaged
the quest npc and was handed a Special Rat Cheese, which looked
just like the small wedge of cheese item.

By the way, I noticed in the peq "zone" table, the "tutoriala
was not implemented, since, by default, a newly created toon
will go to tutorialb, skipping the "kobold jailor" quest.
Tutoriala was empty, with no mobs, so I decided to use this
as my dungeon for the above mentioned quest.
I changed the name of it (not the short name), calling it
"Arial's Dungeon". The scripted npc in PoK sends you there
to turn in the "cheese" to Arial, then he depops and then
the "Dungeon Boss" spawns. This is only a level 15-20 quest
zone, but it is fun to experiment with for now.