PUBLIC: Database 'Bug' Reports

[masterfreek64]

the SQL is ready and tested l, only the server rejected the upload twice. What to do?

[ichijin]

Keep getting this error with itemtemplate.sql. Have tried navicat, sqllog, and mysql command line.

Code: Select all

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, DPS_AF, SPD_ABS, Hand, Type_Damage, Object_Typ' at line 2


Any help is appreciated.

[nor]

Keep getting this error with itemtemplate.sql. Have tried navicat, sqllog, and mysql command line.

Code: Select all

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Condition, MaxCondition, Quality, DPS_AF, SPD_ABS, Hand, Type_Damage, Object_Typ' at line 2


Any help is appreciated.

As of MySQL ~5.0 word 'Condition' and some other word are keywords. Just need to escape them using `` (on my keyboard the key under Esc, the same key that types ~ if pressed with shift, can just copy/paste).

In general it is a good idea to escape all field/table names in case further versions of MySQL add more keywords.

Information based only on error message, have not checked .sql.

[ichijin]

As of MySQL ~5.0 word 'Condition' and some other word are keywords. Just need to escape them using `` (on my keyboard the key under Esc, the same key that types ~ if pressed with shift, can just copy/paste).

That did the trick. Just replaced all Condition as `Condition` and it worked perfectly. Thanks.

[Larogoth]

Just figured I'd let ya know that the Heretic's Reanimate Corpse spell should be under the Heretic Rejuvenation Spec line if this wasn't already corrected in the database. I loaded up a server last night to goof around with and noticed it's currently under the Heretic Enhancement Spec line.

Here's a link to the Heretic's Spells as from the Camelot Herald.

http://www.camelotherald.com/spells/line.php?c=40&line=125

[ichijin]

Using SVN compiled with the DB Files from here. Went through and did all the fixes ('NULL' to NULL in all the spots and such).

Now, everything seems to run ok. STores have gear, I can loot gear, wear gear, etc. But when the server is booting, I get this error in console:

Code: Select all

17:08:30,578 - [MAIN] - WARN  - DOL.GS.GameInventoryItem - Item Creation: Template not found!
   at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
   at System.Environment.get_StackTrace()
   at DOL.GS.GameInventoryItem.CreateFromTemplate(String templateID) in D:\DaoC\trunk\GameServer\gameobjects\GameInventoryItem.cs:line 93
   at DOL.GS.GameEmeraldSealsMerchant..ctor() in D:\DaoC\trunk\GameServer\gameobjects\GameMerchant.cs:line 603
   at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
   at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
   at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
   at System.Activator.CreateInstance(Type type, Boolean nonPublic)
   at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
   at DOL.GS.Region.LoadFromDatabase(Mob[] mobObjs, Int64& mobCount, Int64& merchantCount, Int64& itemCount, Int64& bindCount) in D:\DaoC\trunk\GameServer\world\Region.cs:line 571
   at DOL.GS.WorldMgr.Init(RegionData[] regionsData) in D:\DaoC\trunk\GameServer\world\WorldMgr.cs:line 369
   at DOL.GS.GameServer.Start() in D:\DaoC\trunk\GameServer\GameServer.cs:line 684
   at DOL.DOLServer.Actions.ConsoleStart.OnAction(Hashtable parameters)
   at DOL.DOLServer.MainClass.Main(String[] args)


It doesnt seem to be causing any problems that I noticed, but is there a fix for this one? The ability implimentation was said to have fixed this problem a couple pages back on this post, but that did not do it for me.

[ichijin]

In GameMerchant.cs, 4 lines need to be updated.

Code: Select all

         m_moneyItem = GameInventoryItem.CreateFromTemplate("DiamondSeal");

            m_moneyItem = GameInventoryItem.CreateFromTemplate ("SapphireSeal");

            m_moneyItem = GameInventoryItem.CreateFromTemplate("EmeraldSeal");

         m_moneyItem = GameInventoryItem.CreateFromTemplate("aurulite");


Change them to:

Code: Select all

         m_moneyItem = GameInventoryItem.CreateFromTemplate("diamond_seals");

            m_moneyItem = GameInventoryItem.CreateFromTemplate("sapphire_seals");

            m_moneyItem = GameInventoryItem.CreateFromTemplate("emerald_seals");

         m_moneyItem = GameInventoryItem.CreateFromTemplate("powdered_aurulite");


[sio]

Code: Select all

insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-495','495','60','Wild Swing','MaulerStaff','1','495','10','0','0','0','0','28','0.04','0','0','495','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-496','496','60','Splintered Strike','MaulerStaff','2','496','10','0','0','0','0','28','0.98','5','5','496','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-497','497','60','Focused Breach','MaulerStaff','4','497','15','0','0','496','7','28','0.89','10','0','497','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-498','498','60','Rescue','MaulerStaff','6','498','10','0','0','0','0','28','0.94','15','5','498','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-499','499','60','Percussion','MaulerStaff','8','499','10','0','2','1','0','28','0.89','10','-5','499','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-500','500','60','Cinder Strike','MaulerStaff','10','500','10','0','2','2','0','28','0.42','10','5','500','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-501','501','60','Subterfuge','MaulerStaff','12','501','10','0','0','0','0','28','0','10','15','501','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-502','502','60','Jolting Staff','MaulerStaff','15','502','10','0','0','498','7','28','0.66','10','5','502','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-503','503','60','Smelting Blow','MaulerStaff','18','503','5','0','0','499','7','28','0.87','15','0','503','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-504','504','60','Winding Blow','MaulerStaff','21','504','10','0','0','496','7','28','0.69','10','5','504','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-505','505','60','Shocking Staff','MaulerStaff','25','505','10','0','0','498','7','28','0.76','10','5','505','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-506','506','60','Ember Clib','MaulerStaff','29','506','10','0','1','0','5','28','0.75','10','5','506','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-507','507','60','Burning Cloud','MaulerStaff','34','507','15','0','2','0','0','28','0.89','5','0','507','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-508','508','60','Scorching Staff','MaulerStaff','39','508','15','0','0','506','7','28','0.89','15','-5','508','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-509','509','60','Forging Blow','MaulerStaff','44','509','10','0','0','499','7','28','0.95','15','0','509','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-MaulerStaff-510','510','60','Tempered Strike','MaulerStaff','50','510','10','0','0','506','7','28','0.93','15','10','510','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-511','511','60','Ducking Blow','FistWraps','1','511','10','0','0','0','0','27','0.04','0','0','511','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-512','512','60','Jab','FistWraps','2','512','10','0','0','0','0','27','0.97','5','5','512','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-513','513','60','Uppercut','FistWraps','4','513','15','0','0','512','7','27','0.88','10','0','513','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-514','514','60','Jaw Breaker','FistWraps','6','514','10','0','0','513','7','27','0.53','5','5','514','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-515','515','60','Owl Strike','FistWraps','8','515','10','0','0','0','0','27','0.51','10','-5','515','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-516','516','60','Heart Stopper','FistWraps','10','516','10','0','2','2','0','27','0.41','10','5','516','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-517','517','60','Body Blow','FistWraps','12','517','10','0','2','1','0','27','0','10','15','517','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-518','518','60','Haymaker','FistWraps','15','518','10','0','0','0','0','27','0.88','5','5','518','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-519','519','60','Wind Taker','FistWraps','18','519','5','0','2','0','0','27','0.66','10','0','519','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-520','520','60','Rib Cracker','FistWraps','21','520','10','0','0','516','7','27','0.88','10','5','520','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-521','521','60','Eagle Strike','FistWraps','25','521','10','0','0','515','7','27','0.76','15','-5','521','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-522','522','60','Gut Shot','FistWraps','29','522','10','0','0','518','7','27','0.74','10','5','522','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-523','523','60','Dislocation','FistWraps','34','523','15','0','1','0','5','27','0.88','10','0','523','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-524','524','60','Cross','FistWraps','39','524','15','0','0','518','7','27','0.88','10','5','524','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-525','525','60','Counter Blow','FistWraps','44','525','10','0','0','523','7','27','0.95','10','5','525','0','0');
insert into `style` (`Style_ID`, `ID`, `ClassId`, `Name`, `SpecKeyName`, `SpecLevelRequirement`, `Icon`, `EnduranceCost`, `StealthRequirement`, `OpeningRequirementType`, `OpeningRequirementValue`, `AttackResultRequirement`, `WeaponTypeRequirement`, `GrowthRate`, `BonusToHit`, `BonusToDefense`, `TwoHandAnimation`, `RandomProc`, `ArmorHitLocation`) values('Mauler-FistWraps-526','526','60','Phoenix Strike','FistWraps','50','526','10','0','0','515','7','27','0.88','15','5','526','0','0');


[Tolakram]

Just in case you weren't aware,

the public database is not available, file not found.

[Etaew]

Seems fine for me.

[Tolakram]

It is, now.

[Deniska]

I start check Bonedancer's spells and found some mistakes.
For example:
Hasten Pack, Hasten Squad, Hasten Cohort, Hasten Battalion, Hasten Company, Hasten Army, Hasten Horde (Pet-Buff Dex/Qui, Bone Mystics spell line) assigned to Bone Warriors spell line(linexspell.sql, 23 aug).
Spell "Summon Bone Magus"(spellID 10105, Bone Mystics spell line) not exists in spell.sql(23 aug). IStandAloneToo posted BD spells and templates(15 september, you can found it here), and this spell exists in his release. But this spell is not assigned to any spell line /:.
Maybe there are more mistakes, i don't check all spells/spelllines atm.
If database team already knows about this mistakes and they are fixed - just delete the topic. (:
If no, i can check all spells and make a correct base of BD spells/spelllines.

My info is based on CamelotHerald and DAoC Charplan v1.6.11. Hope they are right /:.

[IStandAloneToo]

I start check Bonedancer's spells and found some mistakes.
For example:
Hasten Pack, Hasten Squad, Hasten Cohort, Hasten Battalion, Hasten Company, Hasten Army, Hasten Horde (Pet-Buff Dex/Qui, Bone Mystics spell line) assigned to Bone Warriors spell line(linexspell.sql, 23 aug).
Spell "Summon Bone Magus"(spellID 10105, Bone Mystics spell line) not exists in spell.sql(23 aug). IStandAloneToo posted BD spells and templates(15 september, you can found it here), and this spell exists in his release. But this spell is not assigned to any spell line /:.
Maybe there are more mistakes, i don't check all spells/spelllines atm.
If database team already knows about this mistakes and they are fixed - just delete the topic. (:
If no, i can check all spells and make a correct base of BD spells/spelllines.

Yes I didn't do anything with the new BD specialized pets as I didn't have enough info to create their templates/spells. However, it is in the linexspell DB (in mine anyways). I must have forgotten to add in the linexspell changes that I had made. Give me a sec and I will upload those.

Edit: Thanks for bringing that up, I just uploaded the spell lines and linexspell fields!

[Deniska]

No problem. But in new BD spells package again only BDNPCTemplate.sql and BDSpells.sql. (:

[IStandAloneToo]

Well, I tried to put it up but for some reason it isn't showing it. I'll mess with it in about an hour.

Edit: It was a problem with the website since we moved. Etaew fixed it and now it works. Enjoy!