[Solved] Create spells and line

[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.

[deathwish]

have you setup the trainer to give out that spell line?

[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

[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.

[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

[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.

[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.

[Tolakram]

Did you make sure the class for your styles matches? Classid I think.

[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.