Cheat Sheet for Creating Items

[pitbull23701]

This Cheat Sheet is for those who are like me
and have no Item Editor to help them out. hope it helps.
-----------
IT numbers
--------------
Epic 2.0
--------------
Bard - 10735
Beastlord - 10736
Berserker - 10737
Cleric - 10738
Druid - 10739
Enchanter - 10740
Magician - 10741
Monk - 10742
Necromancer - 10743
Paladin - 10744
Ranger - 10745
Rogue - 10746
Shadow Knight - 10747
Shaman - 10748
Warrior - 10749
Wizard - 10750
---------------
Shields PoP Era
---------------
Eagle Shield - 10530
Hat Spiked Shield - 10531
Tiki Shield - 10532
RedWarrior Shield - 10533
Justice Shield - 10534
Bow'n'Arrow Shield - 10535
Spider Eye Shield - 10536
Pirate Shield - 10537
Fairy Shield - 10538
BoT Giant Skull Shield - 10539
Thunder Shield - 10540
Chain Whip Shield - 10541
Snell Shield - 10542
Fire Shield - 10543
Solusek Shield - 10544
-------------------------------
Shields Pre PoP / GoD / OOW ERA
-------------------------------
Triangle Shield - 10664
Small Triangle Shield - 10665
Door Shield - 10666
Door Shield small - 10667
Metal Trang Shield - 10668
Small Trang Shield - 10669
War Shield - 10670
Tiny War Shield - 10671
Ghastly Shield - 10729
Gothic Ghostly Shield - 10730
Wrist Shield(OoW) - 10772
Kite Shield(OoW) - 10775
----
Bows
----
Tallon Zeks bow - 10412
GoD Mob Bow - 10717
Wooden PoP Bow - 10614
--------
Halberds
--------
GoD Mob Halberd - 10720
-------------
PoP God Weaps
-------------
Tribunal Hammer - 10400
Rallos Axe - 10401
Karana Staff - 10403
Marr Sword - 10404
some grim staffhammer - 10406
Rallos Staff - 10407
Flaming Mace - 10408
Bone Mace - 10409
Pofire Staff - 10410
Weird sword - 10411
Tallon Bow - 10412
vallon Sword - 10413
-----
Wands
-----
Serpant Wand - 10501
Ice Dagger/Wand - 10502
Firey Wand - 10503
Glowing Purple Wand - 10504
2 sided glowing Wand(GoD) - 10731
Mana Purple Wand(GoD) - 10732
Candle Wand - 10733
----------
1hand axes
----------
GoD Axe - 10719
--------
Daggers
--------
Stone Dagger - 10711
Lizard Tail Dagger - 10715
tiny Prognid Dagger - 10722
Icy Dagger - 10502
--------------------------
Slot Cheat Sheet
--------------------------
Charm - 1
Head - 4
Ears - 18
Neck - 32
Shoulders - 64
Arms - 128
Back - 256
Wrists - 1536
Range - 2048
Hands - 4096
Primary - 8192
Secondary - 16384
Primary / Secondary - 24576
Fingers - 98304
Chest - 131072
Legs - 262144
Feet - 524288
Waist - 1048576
Ammo - 2097152
-----------------------
Class Cheat Sheet
-----------------------
All - 65535
Warrior - 1
Cleric - 2
Paladin - 4
Ranger - 8
Shadow Knight - 16
Druid - 32
Monk - 64
Bard - 128
Rogue - 256
Shaman - 512
Necro - 1024
Wizard - 2048
Magician - 4096
Enchanter - 8192
Beastlord - 16384
Berserker - 32768
Plate Class's - 151
Chain Class's (including warrior/bard/Pally/Sk) - 33693
Just Chain Class's - 33544
Leather Class's - 16480
Robe Class's - 15360
-----------------------
Item Types
-----------------------
0 - 1 Hand Slashing
1 - 2 Hand Slashing
2 - 1 Hand Piercing
35 - 2 Hand Piercing
3 - 1 Hand Blunt
4 - 2 Hand Blunt
5 - Bow/Archery
6 - Throwing Weap
10 - Clothing
14 - Food
15 - Drink
21 - Potion
33 - Key
45 - Hand to Hand
-----------------------
Effect Types Cheat Sheet
-----------------------
2 - Worn effect
3 - Clickie Item dont poof
4 - Clickie Item Poofs after outta charges
-----------------------
Materials Cheat Sheet
-----------------------
0 - Plain Cloth
1 - Leather
2 - Chain
3 - Plate
14 - Robe (Green)
-----------------------
Made by: Deathbane
Server: Chaotic Visions
-----------------------

[Cisyouc]

3 - Plate
14 - Robe (Green)

Might I add that...

10 - Red and Gold Robe
11 - Blackand Purple (Priest of Discord) Robe
12 - Yellow Robe
13 - Light Blue and Gold Robe
14 - Turquoise and Brown Robe
15 - Purple, Blue and Gold Robe
16 - White and Grey Robe

(God I cant believe i memorized that)

[Koshoji]

Hi guys,

I can see that these lists contain very valuable information. But, without an item editor, what method would one use to put that info to use? Would anyone mind posting an example or two for the newbie?

Thanks much!

[pitbull23701]

use a program called MySQL-Front you can find it at.... http://www.mysql-front.com just load your database and go to items table to add items to your database im sure you can figure it out from here its much like a item editor except without a quick sidebar edit list stats are listed asta astr etc. hope that helps.

[Koshoji]

Thanks Pittbull,

One question;
Will I have to uninstall my present version of MySQL in order to install FRONT?
Or can I install Mysql front on top of WinMysqlAdmin 1.4?

[pittbull23701]

no and if my damn acct wasent baned id been able 2 replied faster but no you dont have to reinstall mysql for front front is just an editor

[pittbull23701]

hmm ima make an item editor for those who use irc. ganna make it via dialog all i ask inreturn is to be unbaned from irc and forums i mean evading is thrilling n all but annoying and kinda degrading to the admins anyway ill release a flexable updateable item maker done in mirc scripting if im unbaned

[Cisyouc]

Originally Posted by pittbull23701

hmm ima make an item editor for those who use irc. ganna make it via dialog all i ask inreturn is to be unbaned from irc and forums i mean evading is thrilling n all but annoying and kinda degrading to the admins anyway ill release a flexable updateable item maker done in mirc scripting if im unbaned

Well, mangoo is already working on Item Editor 3.0, and raw queries work better than Item Editors in my experience

[pittbull23701]

i can have mine made twice as fast

[Koshoji]

Thanks for the reply Pittbull, I tried it and it works great.
I'm trying to kind of use Mysql Front in conjunction with eqadmin. I can't make any changes so far with eqadmin, but can see the items visually with it. From there I'm trying to actually effect the changes with Mysql Front. This is pretty fun!

[Belfedia]

YOu have one eqadmin programs working with 6.0 DR2 ? and peq_database ? where i can find that ?