Item Creator

[Checkerbunny11]

Hey i have a little problem and i don´t know how to fixx soo for example i create this with item creator:

<?xml version="1.0" standalone="yes"?>
<ItemCreator xmlns="http://dol.oecken.net/ItemCreator/schem ... plates.xsd">
<ItemTemplate>
<ItemTemplate_ID>2b487f96-f3cb-413a-9d8e-905279010f10</ItemTemplate_ID>
<Id_nb>I_dont_know</Id_nb>
<Name>Test_Test</Name>
<Level>50</Level>
<Durability>50000</Durability>
<MaxDurability>50000</MaxDurability>
<Condition>50000</Condition>
<MaxCondition>50000</MaxCondition>
<Quality>120</Quality>
<DPS_AF>102</DPS_AF>
<SPD_ABS>51</SPD_ABS>
<Hand>0</Hand>
<Type_Damage>0</Type_Damage>
<Object_Type>36</Object_Type>
<Item_Type>25</Item_Type>
<Color>43</Color>
<Emblem>0</Emblem>
<Effect>0</Effect>
<Weight>16</Weight>
<Model>4084</Model>
<Extension>5</Extension>
<Bonus>35</Bonus>
<Bonus1>0</Bonus1>
<Bonus2>0</Bonus2>
<Bonus3>0</Bonus3>
<Bonus4>0</Bonus4>
<Bonus5>0</Bonus5>
<Bonus6>0</Bonus6>
<Bonus7>0</Bonus7>
<Bonus8>0</Bonus8>
<Bonus9>0</Bonus9>
<Bonus10>0</Bonus10>
<ExtraBonus>0</ExtraBonus>
<Bonus1Type>0</Bonus1Type>
<Bonus2Type>0</Bonus2Type>
<Bonus3Type>0</Bonus3Type>
<Bonus4Type>0</Bonus4Type>
<Bonus5Type>0</Bonus5Type>
<Bonus6Type>0</Bonus6Type>
<Bonus7Type>0</Bonus7Type>
<Bonus8Type>0</Bonus8Type>
<Bonus9Type>0</Bonus9Type>
<Bonus10Type>0</Bonus10Type>
<ExtraBonusType>0</ExtraBonusType>
<IsPickable>false</IsPickable>
<IsDropable>false</IsDropable>
<CanDropAsLoot>false</CanDropAsLoot>
<IsTradable>false</IsTradable>
<Platinum>0</Platinum>
<Gold>0</Gold>
<Silver>0</Silver>
<Copper>0</Copper>
<MaxCount>1</MaxCount>
<PackSize>1</PackSize>
<Charges>0</Charges>
<MaxCharges>0</MaxCharges>
<Charges1>0</Charges1>
<MaxCharges1>0</MaxCharges1>
<SpellID>0</SpellID>
<ArtiID>0</ArtiID>
<SpellID1>0</SpellID1>
<ProcSpellID>0</ProcSpellID>
<ProcSpellID1>0</ProcSpellID1>
<PoisonSpellID>0</PoisonSpellID>
<PoisonMaxCharges>0</PoisonMaxCharges>
<PoisonCharges>0</PoisonCharges>
<Realm>0</Realm>
<AllowedClasses />
</ItemTemplate>
</ItemCreator>



Come this Error:

[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 '<?xml version="1.0" standalone="yes"?>
<ItemCreator xmlns="http://dol.oecken.ne' at line 1
[Err] <?xml version="1.0" standalone="yes"?>
<ItemCreator xmlns="http://dol.oecken.net/ItemCreator/schem ... plates.xsd">
<ItemTemplate>
<ItemTemplate_ID>fac8aa82-134c-425a-be2f-ee33bffdaaa4</ItemTemplate_ID>
<Id_nb>Test_Test</Id_nb>
<Name>Test_Test</Name>
<Level>50</Level>
<Durability>50000</Durability>
<MaxDurability>50000</MaxDurability>
<Condition>50000</Condition>
<MaxCondition>50000</MaxCondition>
<Quality>120</Quality>
<DPS_AF>102</DPS_AF>
<SPD_ABS>51</SPD_ABS>
<Hand>0</Hand>
<Type_Damage>0</Type_Damage>
<Object_Type>36</Object_Type>
<Item_Type>25</Item_Type>
<Color>0</Color>
<Emblem>0</Emblem>
<Effect>0</Effect>
<Weight>16</Weight>
<Model>4084</Model>
<Extension>0</Extension>
<Bonus>35</Bonus>
<Bonus1>0</Bonus1>
<Bonus2>0</Bonus2>
<Bonus3>0</Bonus3>
<Bonus4>0</Bonus4>
<Bonus5>0</Bonus5>
<Bonus6>0</Bonus6>
<Bonus7>0</Bonus7>
<Bonus8>0</Bonus8>
<Bonus9>0</Bonus9>
<Bonus10>0</Bonus10>
<ExtraBonus>0</ExtraBonus>
<Bonus1Type>0</Bonus1Type>
<Bonus2Type>0</Bonus2Type>
<Bonus3Type>0</Bonus3Type>
<Bonus4Type>0</Bonus4Type>
<Bonus5Type>0</Bonus5Type>
<Bonus6Type>0</Bonus6Type>
<Bonus7Type>0</Bonus7Type>
<Bonus8Type>0</Bonus8Type>
<Bonus9Type>0</Bonus9Type>
<Bonus10Type>0</Bonus10Type>
<ExtraBonusType>0</ExtraBonusType>
<IsPickable>false</IsPickable>
<IsDropable>false</IsDropable>
<CanDropAsLoot>false</CanDropAsLoot>
<IsTradable>false</IsTradable>
<Platinum>0</Platinum>
<Gold>0</Gold>
<Silver>0</Silver>
<Copper>0</Copper>
<MaxCount>1</MaxCount>
<PackSize>1</PackSize>
<Charges>0</Charges>
<MaxCharges>0</MaxCharges>
<Charges1>0</Charges1>
<MaxCharges1>0</MaxCharges1>
<SpellID>0</SpellID>
<ArtiID>0</ArtiID>
<SpellID1>0</SpellID1>
<ProcSpellID>0</ProcSpellID>
<ProcSpellID1>0</ProcSpellID1>
<PoisonSpellID>0</PoisonSpellID>
<PoisonMaxCharges>0</PoisonMaxCharges>
<PoisonCharges>0</PoisonCharges>
<Realm>0</Realm>
<AllowedClasses />
</ItemTemplate>
</ItemCreator>
[Msg] Finished - Unsuccessfully
-----------------------------------------

i hope anyone can help me.... pls!!

[Argo]

did you use this sign ` in the name ? cause if you name your item as example naihla`s xxx and then load the item again, it gives this error.

[Checkerbunny11]

i use Test_Test but when i add it in the db under itemtemplate comes this error sry and sry for my bad english^^

[Etaew]

It sounds like your trying to use the xml it generates as a sql query.

[Checkerbunny11]

I saved the item in a sql data and wanna add it direct in db , with Execute Batch File..... but ever come this error idk why-.-

[Overdriven]

I saved the item in a sql data and wanna add it direct in db , with Execute Batch File..... but ever come this error idk why-.-

Post the SQL.

The stuff you posted is XML.

Trust me. I'm right. *Burns old XML to the ground*

[Graveen]

what error. Important...

[Checkerbunny11]

hmm when is saved it to sql is it XML okay and how can i change it to right sqlß??

[Tinantiol]

did you connected your db to the item creator? IF NOT type on Preferences then sql setup and put in your db info, click on test connection and then save. When you create a new item go on export/save item and type execute, go in-game and you have it there ^^.


It work for me!