Page 1 of 1

[Solved] Create spells and line

PostPosted: Wed Mar 14, 2012 4:40 pm
by HunabKu
Hi all.

I'm creating a custom character class.

All works except the magic line appear with a "?" before his name.
After searches, i understand it's a DB problem. I've created this in :

In language
Code: Select all
INSERT INTO `language` (`Language_ID`, `TranslationID`, `EN`, `DE`, `FR`, `IT`, `ES`, `CZ`, `PackageID`, `CU`) VALUES
('MySpellLine', 'SkillBase.RegisterPropertyNames.MySpellLine', 'My Spell Line', 'My Spell Line', 'My Spell Line', '', NULL, NULL, '', NULL);
In spell
Code: Select all
INSERT IGNORE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES
('MySpell_7', 29003, 29003, 29003, 'My Spell 7', 'Description of my Spell level 7', 'Self', NULL, 5, 3, NULL, NULL, 'Type_Of_My_Spell_7', 1200, 0, 0, 0, 0, 0, 0, 0, 36, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, 2010, 2, NULL, 1, 1, NULL, NULL, NULL, NULL, 'MyPackageID', NULL);
In spellline
Code: Select all
INSERT INTO `spellline` (`SpellLine_ID`, `KeyName`, `Name`, `Spec`, `IsBaseLine`, `PackageID`) VALUES
('MySpellLine', 'My Spell Line', My Spell Line', 'My Spell Line', 0, 'MyPackageID');
In specialization
Code: Select all
INSERT INTO `specialization` (`Specialization_ID`, `KeyName`, `Name`, `Icon`, `Description`) VALUES
('MySpellLine', 'My Spell Line', 'My Spell Line', 0, 'no');
In linexspell
Code: Select all
INSERT INTO `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`, `PackageID`) VALUES
(''MySpell_7', 'My Spell Line', 29003, 7, 'MyPackageID'),
I don't understand where is the problem.

Thanks by advance.

Hunab Ku.

Re: Create spells and line

PostPosted: Wed Mar 14, 2012 5:19 pm
by deathwish
have you setup the trainer to give out that spell line?

Re: Create spells and line

PostPosted: Wed Mar 14, 2012 11:11 pm
by Belthax
I would look in Linexspell or Specialization for a typo in the line name.

Open the custom class file and make sure its completly the same as it is in the file.

Code: Select all
INSERT INTO `spellline` (`SpellLine_ID`, `KeyName`, `Name`, `Spec`, `IsBaseLine`, `PackageID`) VALUES
('MySpellLine', 'My Spell Line', My Spell Line', 'My Spell Line', 0, 'MyPackageID');

Missing a ' infront of the third My Spell Line

Re: Create spells and line

PostPosted: Thu Mar 15, 2012 5:34 am
by HunabKu
Primary, thanks a lot to you.

- To deathwish: Yes i've created a trainer and works.

- To Balthax: The missing ' is a mistake not real error. I will make all occurrences without space or _ and will see if work more.

Re: Create spells and line

PostPosted: Thu Mar 15, 2012 6:42 pm
by HunabKu
Okai the spellline now appear in specialization tab in game, style line not appear in combat tab in game and spell line not appear in magic tab in game.

Do you have an idea please ?

Thanks by advance.

Hunab Ku

Re: Create spells and line

PostPosted: Fri Mar 16, 2012 8:13 am
by Belthax
Dunno if you have added spells/styles to them yet but they need to have spells and styles to appear. And you need to have trained enough untill you trained a spell/style.

Re: Create spells and line

PostPosted: Fri Mar 16, 2012 6:03 pm
by HunabKu
Okai very thanks Belthax the spel line and spells works.
But style line and styles don't appear either.

I've created styles in styles table and correspondant spells in sylexspell.

Re: Create spells and line

PostPosted: Fri Mar 16, 2012 6:10 pm
by Tolakram
Did you make sure the class for your styles matches? Classid I think.

Re: Create spells and line

PostPosted: Fri Mar 16, 2012 6:41 pm
by HunabKu
Waow i'm too tired lol. Thanks Tolakram !

PS: I respond to your PM but as i can't i send respond at Baradien.
PS 2: I can't respond by PM again
Code: Select all
Some users couldn’t be added as they have disabled private message receipt.