Spell tables?

[Kurosan]

Idk what they're all called.. But the db i have is missing them anyone have the spells 112 and other needed spell tables?

Thanks.


Edit: And if possible their/your trainer tables

[b!atch]

Here is my tables..

-- Table "trainerspelloverride" DDL

CREATE TABLE `trainerspelloverride` (
  `spellid` int(10) unsigned NOT NULL default '0',
  `cost` int(10) unsigned NOT NULL default '0',
  `requiredspell` int(10) unsigned NOT NULL default '0',
  `deletespell` int(10) unsigned NOT NULL default '0',
  `requiredskill` int(10) unsigned NOT NULL default '0',
  `requiredskillvalue` int(10) unsigned NOT NULL default '0',
  `reqlevel` int(10) unsigned NOT NULL default '0',
  `requiredclass` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `spellid` (`spellid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Trainer System';

-- Table "spells112" DDL

CREATE TABLE `spells112` (
  `Id` int(100) default '0',
  `School` int(100) default '0',
  `Category` int(100) default '0',
  `field4` int(100) default '0',
  `DispelType` int(100) default '0',
  `MechanicsType` int(100) default '0',
  `Attributes` int(100) default '0',
  `AttributesEx` int(100) default '0',
  `Flags3` int(100) default '0',
  `field10` int(100) default '0',
  `field11` int(100) default '0',
  `UNK12` int(100) default '0',
  `UNK13` int(100) default '0',
  `Targets` int(100) default '0',
  `TargetCreatureType` int(100) default '0',
  `RequiresSpellFocus` int(100) default '0',
  `CasterAuraState` int(100) default '0',
  `TargetAuraState` int(100) default '0',
  `CastingTimeIndex` int(100) default '0',
  `RecoveryTime` int(100) default '0',
  `CategoryRecoveryTime` int(100) default '0',
  `InterruptFlags` int(100) default '0',
  `AuraInterruptFlags` int(100) default '0',
  `ChannelInterruptFlags` int(100) default '0',
  `procFlags` int(100) default '0',
  `procChance` int(100) default '0',
  `procCharges` int(100) default '0',
  `maxLevel` int(100) default '0',
  `baseLevel` int(100) default '0',
  `spellLevel` int(100) default '0',
  `DurationIndex` int(100) default '0',
  `powerType` int(100) default '0',
  `manaCost` int(100) default '0',
  `manaCostPerlevel` int(100) default '0',
  `manaPerSecond` int(100) default '0',
  `manaPerSecondPerLevel` int(100) default '0',
  `rangeIndex` int(100) default '0',
  `speed` float default '0',
  `modalNextSpell` int(100) default '0',
  `maxstack` int(100) default '0',
  `Totem1` int(100) default '0',
  `Totem2` int(100) default '0',
  `Reagent1` int(100) default '0',
  `Reagent2` int(100) default '0',
  `Reagent3` int(100) default '0',
  `Reagent4` int(100) default '0',
  `Reagent5` int(100) default '0',
  `Reagent6` int(100) default '0',
  `Reagent7` int(100) default '0',
  `Reagent8` int(100) default '0',
  `ReagentCount1` int(100) default '0',
  `ReagentCount2` int(100) default '0',
  `ReagentCount3` int(100) default '0',
  `ReagentCount4` int(100) default '0',
  `ReagentCount5` int(100) default '0',
  `ReagentCount6` int(100) default '0',
  `ReagentCount7` int(100) default '0',
  `ReagentCount8` int(100) default '0',
  `EquippedItemClass` int(100) default '0',
  `EquippedItemSubClass` int(100) default '0',
  `RequiredItemFlags` int(100) default '0',
  `Effect1` int(100) default '0',
  `Effect2` int(100) default '0',
  `Effect3` int(100) default '0',
  `EffectDieSides1` int(100) default '0',
  `EffectDieSides2` int(100) default '0',
  `EffectDieSides3` int(100) default '0',
  `EffectBaseDice1` int(100) default '0',
  `EffectBaseDice2` int(100) default '0',
  `EffectBaseDice3` int(100) default '0',
  `EffectDicePerLevel1` float default '0',
  `EffectDicePerLevel2` float default '0',
  `EffectDicePerLevel3` float default '0',
  `EffectRealPointsPerLevel1` float default '0',
  `EffectRealPointsPerLevel2` float default '0',
  `EffectRealPointsPerLevel3` float default '0',
  `EffectBasePoints1` int(100) default '0',
  `EffectBasePoints2` int(100) default '0',
  `EffectBasePoints3` int(100) default '0',
  `Effectunk1901` int(100) default '0',
  `Effectunk1902` int(100) default '0',
  `Effectunk1903` int(100) default '0',
  `EffectImplicitTargetA1` int(100) default '0',
  `EffectImplicitTargetA2` int(100) default '0',
  `EffectImplicitTargetA3` int(100) default '0',
  `EffectImplicitTargetB1` int(100) default '0',
  `EffectImplicitTargetB2` int(100) default '0',
  `EffectImplicitTargetB3` int(100) default '0',
  `EffectRadiusIndex1` int(100) default '0',
  `EffectRadiusIndex2` int(100) default '0',
  `EffectRadiusIndex3` int(100) default '0',
  `EffectApplyAuraName1` int(100) default '0',
  `EffectApplyAuraName2` int(100) default '0',
  `EffectApplyAuraName3` int(100) default '0',
  `EffectAmplitude1` int(100) default '0',
  `EffectAmplitude2` int(100) default '0',
  `EffectAmplitude3` int(100) default '0',
  `Effectunknown1` float default '0',
  `Effectunknown2` float default '0',
  `Effectunknown3` float default '0',
  `EffectChainTarget1` int(100) default '0',
  `EffectChainTarget2` int(100) default '0',
  `EffectChainTarget3` int(100) default '0',
  `EffectSpellGroupRelation1` int(100) default '0',
  `EffectSpellGroupRelation2` int(100) default '0',
  `EffectSpellGroupRelation3` int(100) default '0',
  `EffectMiscValue1` int(100) default '0',
  `EffectMiscValue2` int(100) default '0',
  `EffectMiscValue3` int(100) default '0',
  `EffectTriggerSpell1` int(100) default '0',
  `EffectTriggerSpell2` int(100) default '0',
  `EffectTriggerSpell3` int(100) default '0',
  `EffectPointsPerComboPoint1` float default '0',
  `EffectPointsPerComboPoint2` float default '0',
  `EffectPointsPerComboPoint3` float default '0',
  `SpellVisual` int(100) default '0',
  `field114` int(100) default '0',
  `dummy` int(100) default '0',
  `CoSpell` int(100) default '0',
  `spellPriority` int(100) default '0',
  `Name` longtext collate utf8_unicode_ci,
  `NameAlt1` longtext collate utf8_unicode_ci,
  `NameAlt2` longtext collate utf8_unicode_ci,
  `NameAlt3` longtext collate utf8_unicode_ci,
  `NameAlt4` longtext collate utf8_unicode_ci,
  `NameAlt5` longtext collate utf8_unicode_ci,
  `NameAlt6` longtext collate utf8_unicode_ci,
  `NameAlt7` longtext collate utf8_unicode_ci,
  `NameFlags` longtext collate utf8_unicode_ci,
  `Rank` longtext collate utf8_unicode_ci,
  `RankAlt1` longtext collate utf8_unicode_ci,
  `RankAlt2` longtext collate utf8_unicode_ci,
  `RankAlt3` longtext collate utf8_unicode_ci,
  `RankAlt4` longtext collate utf8_unicode_ci,
  `RankAlt5` longtext collate utf8_unicode_ci,
  `RankAlt6` longtext collate utf8_unicode_ci,
  `RankAlt7` longtext collate utf8_unicode_ci,
  `RankFlags` longtext collate utf8_unicode_ci,
  `Description` longtext collate utf8_unicode_ci,
  `DescriptionAlt1` longtext collate utf8_unicode_ci,
  `DescriptionAlt2` longtext collate utf8_unicode_ci,
  `DescriptionAlt3` longtext collate utf8_unicode_ci,
  `DescriptionAlt4` longtext collate utf8_unicode_ci,
  `DescriptionAlt5` longtext collate utf8_unicode_ci,
  `DescriptionAlt6` longtext collate utf8_unicode_ci,
  `DescriptionAlt7` longtext collate utf8_unicode_ci,
  `DescriptionFlags` longtext collate utf8_unicode_ci,
  `BuffDescription` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt1` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt2` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt3` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt4` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt5` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt6` longtext collate utf8_unicode_ci,
  `BuffDescriptionAlt7` longtext collate utf8_unicode_ci,
  `buffdescflags` int(100) default '0',
  `ManaCostPercentage` int(100) default '0',
  `unkflags` int(100) default '0',
  `StartRecoveryTime` int(100) default '0',
  `StartRecoveryCategory` int(100) default '0',
  `SpellFamilyName` int(100) default '0',
  `SpellGroupType` int(100) default '0',
  `unkne` int(100) default '0',
  `MaxTargets` int(100) default '0',
  `Spell_Dmg_Type` int(100) default '0',
  `FG` int(100) default '0',
  `FH` int(100) default '0',
  `dmg_multiplier_1` float default '0',
  `dmg_multiplier_2` float default '0',
  `dmg_multiplier_3` float default '0',
  `FL` int(100) default '0',
  `FM` int(100) default '0',
  `FN` int(100) default '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='not touching this :P';

-- Table "spell_proc_data" DDL

CREATE TABLE `spell_proc_data` (
  `name_hash` int(30) NOT NULL default '0',
  `proc_chance` int(30) NOT NULL default '0',
  `forced_proc_flags` int(30) NOT NULL default '-1',
  PRIMARY KEY  (`name_hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Table "spellextra" DDL

CREATE TABLE `spellextra` (
  `Id` int(10) unsigned NOT NULL auto_increment,
  `specialtype` int(10) unsigned default NULL,
  `enchantableslots` int(10) unsigned default NULL,
  `ExtraFlags` int(10) unsigned default NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=39417 DEFAULT CHARSET=latin1 COMMENT='Spell System';

-- Table "spelloverride" DDL

CREATE TABLE `spelloverride` (
  `overrideId` int(10) unsigned NOT NULL default '0',
  `spellId` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `overrideId` (`overrideId`,`spellId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spell System';

-- Table "spell_disable" DDL

CREATE TABLE `spell_disable` (
  `spellid` int(30) NOT NULL default '0',
  `replacement_spellid` int(30) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Spell System';

-- Table "spell_disable_trainers" DDL

CREATE TABLE `spell_disable_trainers` (
  `spellid` int(30) NOT NULL default '0',
  `replacement_spellid` int(30) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Trainer System';

-- Table "trainer_spells" DDL

CREATE TABLE `trainer_spells` (
  `entry` int(11) unsigned NOT NULL default '0',
  `cast_spell` int(11) unsigned NOT NULL default '0',
  `spellcost` int(11) unsigned NOT NULL default '0',
  `reqspell` int(11) unsigned NOT NULL default '0',
  `reqskill` int(11) unsigned NOT NULL default '0',
  `reqskillvalue` int(11) unsigned NOT NULL default '0',
  `reqlevel` int(11) unsigned NOT NULL default '0',
  `deletespell` int(11) unsigned NOT NULL default '0',
  `is_prof` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`,`cast_spell`),
  KEY `entry` (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trainer System';

[Kurosan]

Thanks, seems the trainers are still broke though =[

[b!atch]

download the rar and run the sqls then it should work

[Kurosan]

ill try it when the file is approved i guess ;o , won't let me download yet =P

[arigity]

attachments take forever to get approved >.> might want to upload it somewhere else.

[b!atch]

grr..ill try filebeam i guess


Filebeam - Free Fast File Hosting


Filebeam - Free Fast File Hosting

[Kurosan]

grr..ill try filebeam i guess

That would be great, ;P

[b!atch]

tell me if they still dont work^^

[Kurosan]

Nope, doesn't work.. Thanks for the effort though.. +rep

[b!atch]

erm. what trainer tables do you have?

[Kurosan]

only tables i seen with trainer on them

Filebeam - Free Fast File Hosting

[2dgreengiant]

they got removed in the latest ascent

[b!atch]

Try Deleting all the tables i gave you.. Now run the sqls once more.. This one too Filebeam - Free Fast File Hosting

And if it doesnt work then.. I have no clue what to do

[Kurosan]

yeah it doesn't work D:

Guess ill wait for a update