Having custom spell creation issues

AngelBane · #1 08-15-2010, 06:06 PM

I am trying to get a handle on creating custom spells so I started out copying a spell and modyfying it.

I am using SOF Client and PEQDB (070_pop_cvs)

Using NullSpelledit
I copied the spell wild growth.
I renamed the spell young growth
changed the mana to 40
changed cast time to 1000
changed recast to 7500
changed the Min/Max for total HP Effect to 440
Changed shaman restriction to 1
Changed Druid restriction to 12

exported to file because it would not allow me to update database.

Using georges spell import export I imported the new spells_us.txt to the DB

Copied the new spells_us.txt to the Client Folder.

Copied the new spells_us.txt to the EQEmu Folder.

I copied the wild growth spell scroll uing the query (because PEQEditor Copy generates an error)
(I omited the field list due to it's sheer size will post it if you want.)
INSERT INTO items (<FIELDLIST>) SELECT <FIELDLIST> from ITEMS where id=118299;

Using PEQEditor
Changed the name of the Scroll to "Spell: Young Growth"
Changed the Lore name of the scroll to "Spell: Young Growth"
Changed the Price to 1
Changed Scroll Effect to 21061 (the ID of the new spell name)

DataBase Changes
items Table
119782 ,0 ,Spell: Young Growth ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,1 ,0 ,1 ,0 ,1 ,0 ,1 ,0 ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 , ,0 ,544 ,4278190080 ,0 ,0 ,0 ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 , ,-1 ,0 ,0 ,0 ,0 ,0 ,0 ,504 ,IT98 ,0 ,20 ,0 ,0 ,0 ,0 ,Spell: Young Growth ,-1 ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,1 ,1 ,0 ,0 ,0 ,65535 ,0 ,0 ,0 ,0 ,3 ,0 ,1 ,0 ,0 ,0 ,-1 ,0 ,0 ,0 ,0 ,0 ,0 ,1 ,0 ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,2010-08-15 10:09:01 , ,0 ,0 ,0 ,0 ,1 ,0 ,1 , ,0 ,-1 ,0 ,0 ,0 ,0 ,-1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,21061 ,7 ,0 ,0 ,0 , ,2010-01-07 20:59:48 , ,13THFLOOR ,0 , ,1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,-1 ,0 ,0 ,0000000000000000000 ,0 , ,-1 ,0 ,0 ,0 ,0 , ,-1 ,0 ,0 ,0 ,0 ,0 , ,-1 ,0 ,0 ,0 ,0 ,0 , ,-1 ,0 ,0 ,0 ,0 ,0 , ,0 ,0 ,0 ,0 , , , , , ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,20081007181604 ,0 ,70 ,0 ,0 ,0 ,-1 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 , ,-1 ,0

Spells New Table
21061 ,Young Growth ,PLAYER_1 ,0 ,0 ,0 ,Vines and foliage protect your body. , is protected by vines and foliage. ,The wild growth crumbles away. ,100 ,0 ,0 ,0 ,1000 ,1500 ,7500 ,3 ,25 ,0 ,40 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,440 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,440 ,0 ,0 ,0 ,0 ,2511 ,2056 ,-1 ,-1 ,-1 ,-1 ,1 ,1 ,1 ,1 ,-1 ,-1 ,-1 ,-1 ,100 ,100 ,100 ,100 ,100 ,100 ,100 ,1088 ,100 ,100 ,100 ,100 ,0 ,1 ,0 ,0 ,10 ,10 ,10 ,10 ,10 ,10 ,10 ,69 ,254 ,254 ,254 ,254 ,5 ,110 ,4 ,-1 ,0 ,0 ,255 ,255 ,255 ,255 ,255 ,12 ,255 ,255 ,255 ,1 ,255 ,255 ,255 ,255 ,255 ,255 ,42 ,27 ,0 ,2 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,132 ,132 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,18549 ,45 ,141 ,0 ,0 ,0 ,0 ,0 ,100 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,100 ,0 ,168 ,3 ,1500 ,0 ,0 ,0 ,0 ,3 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,0 ,1 ,1 ,0 ,0 ,0 ,0 ,0 ,-1 ,5240 ,1 ,0 ,0 ,0 ,0 ,1 ,1

Merchant list (Bolace in halas)
29002 16 119782

Spells_US.txt Changes
21061^Young Growth^PLAYER_1^0^0^0^Vines and foliage protect your body.^ is protected by vines and foliage.^The wild growth crumbles away.^100^0^0^0^1000^1500^7500^3^25^0^40^0^0^0^0^0 ^0^0^440^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0^0 ^0^0^440^0^0^0^0^2511^2056^-1^-1^-1^-1^1^1^1^1^-1^-1^-1^-1^100^100^100^100^100^100^100^1088^100^100^100^100 ^0^1^0^0^10^10^10^10^10^10^10^69^254^254^254^254^5 ^110^4^-1^0^0^255^255^255^255^255^12^255^255^255^1^255^255 ^255^255^255^255^42^27^0^2^0^0^0^0^0^0^0^0^0^0^0^0 ^0^0^0^0^0^0^0^0^132^132^0^0^0^0^0^0^0^0^0^18549^4 5^141^0^0^0^0^0^100^0^0^0^0^0^0^0^0^0^0^0^0^0^0^10 0^0^168^3^1500^0^0^0^0^3^0^0^0^0^0^0^0^0^0^0^0^1^1 ^0^0^0^0^0^-1^5240^1^0^0^0^0^1^1^1^0^-1

Restarted the Server

Restarted the client

Then I load the CLient create a new Barbarian shaman

go kill a gobbie to have enough copper to buy the spell off Bolace.

I Buy the spell

The classes listed are DRU(255) SHM(255)

I try to scribe it ... I get the message "Your Class can never use the Spell: Young Growth."

I #scribespells 1 and the spell does not get scribed.

What am I doing wrong?

Null · #2 08-15-2010, 06:27 PM

Check PMs!

Null · #3 08-17-2010, 01:24 AM

I finally got a chance to try your spell file, and I didn't have any issues writing your full file up to my database. Here is the process I used:

Open the Spell Editor
Load the SPDat and Skill files.
Connect to the Database
Click Browse Local and select your spells_us.txt file (the same one you sent me)
Click Submit and wait for everything to load up
Click File->Full Write to Database

From then on you should be able to use Write Changes instead of Full Write to update your database.

I am not sure what the rest of your issues are, but if you are running the most recent version of the spell editor it should load everything up fine.

AngelBane · #4 08-17-2010, 02:23 AM

Thanks Null

that fixed the problems I had with the editor.

I still have issues with the creation of the spell :(