[GUIDE] Make A Book Able To Teach Spells; With Pictures

[3xploit]

Hello, I'm now gonna show you how to create a book that can teach you a spell.

First, open your database editing UI(HeidiSQL,Navicat,SQLYog etc)
Then follow the instructions given below:


1. Open your world database, in this case it is arcemu.


2. Open up your "Items" table.

3a. If you use HeidiSQL, you can click on the button marked "+".

3b. If you don't youse HeidiSQL you can scroll all the way down and select a new row.

Now, fill in the information below:

Entry:
Whatever you want, just make it high so you don't override anything

Class:
9

Subclass:
0

Field4:
-1

Name:
Whatever you want. I choose "Book of Fireball:Rank 1" Since this book will teach you Rank 1 Fireball.

Skip everything untill you get to displayid!

Displayid:
This number will show you how this book will look like. "1317" Is a good choice, allthough you can search around and find better/cooler looking displayid if you want.

Quality:
Here you can choose between the numbers 1-5. 1= Grey 5= Epic
So it is not hard to figure out that 2= Common 3= Uncommon 4= Rare

Flags:
64

Buyprice/sellprice:
How much you get when you sell/buy the item. (This number is copper so that means 100,000 = 1g)

Skip Inventory Type

Allowable Class:
This determines what class would be able to use this book. I will go for "32256". "32256" is Druid and this means that only Druids can learn this spell
"-1" means everyone can learn it.

Allowable Race:
Same as above, decides what race who will be able to use this. I will go with "-1" here so both Tauren and Night Elf Druids cna learn this.

Itemlevel:
What level this item have. This does not really affect the item at all as far as I have experienced.

Requiredlevel:
This determines what level you need to be to use this book.

Skip everything untill "Maxcount"

Maxcount:
How many of this items the character are allowed to have in their inventory. 0=Infinite

Skip all untill you see "Spellid_1"

Spellid_1:
483. This is important! Without this you wont be able to learn anything from this book!

Skip Spelltrigger_1

Spellcharges_1, Spellcooldown_1 and Spellcategorycooldown_1:
-1

Spellcategory:
0

Spellid_2:
Here you type in the ID of your chosen spell.

Spelltrigger_2:
6

Spellcharges_2:
0

Spellcharges_2, Spellcooldown_2 and Spellcategorycooldown_2:
-1

Spellcategory_2:
0

Now skip everything from "spellcategorycooldown_2" untill "Description"

Description:
Here you can write a description of the book or what it will teach the player.

Skip everything untill you see "ReqDisenchantSkill"

ReqDisenchantSkill:
This indicates what Enchanting skill you need to disenchant this item. Since we don't want it to be disenchanted we type "-1" there.

And, that should be it. Save this and reload your database, or restart your server.
Then go ingame and type ".char additem [YOUR BOOK'S ENTRY ID]"

[Illegalpie]

TYVM Been trying to do this... +Rep



Edit: First poster AND Gratz outta leecher

[3xploit]

Thank you, and /bump 60 views and 1 comment? Cmon, leech :P

[foswell]

Super newb question... I'm used to working with SQLyog but I am not not aware as to how to search the databases as good so I am now with HeidiSQL but when I am having problems saving the data when I add a new entry like this.

Edit: I did get one on there but when I go back and try to edit it, it's not updating in game because I don't know just how to "save changes"

Very cool way of offering specialty spells that can be sold from easter egg vendors and such. Thank you much for the tutorial

[imcrunk25]

what is the realm plz

[3xploit]

Well to save the changes just click on the 'V' like button. As for the other just restart your server or use the .server reload items command


@ Imcrunk:
What realm?

[Mircast]

This is epic, thanks for the guide.
I can use this for learning professions?

[EDIT] +Rep, <_<

[azeon]

nice guide, didn't know this +rep