[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
ichijin wrote: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 wrote: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).
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)
m_moneyItem = GameInventoryItem.CreateFromTemplate("DiamondSeal");
m_moneyItem = GameInventoryItem.CreateFromTemplate ("SapphireSeal");
m_moneyItem = GameInventoryItem.CreateFromTemplate("EmeraldSeal");
m_moneyItem = GameInventoryItem.CreateFromTemplate("aurulite");
m_moneyItem = GameInventoryItem.CreateFromTemplate("diamond_seals");
m_moneyItem = GameInventoryItem.CreateFromTemplate("sapphire_seals");
m_moneyItem = GameInventoryItem.CreateFromTemplate("emerald_seals");
m_moneyItem = GameInventoryItem.CreateFromTemplate("powdered_aurulite");
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');
Deniska wrote: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.
Users browsing this forum: No registered users and 1 guest