Chyba - Nahravani SQL...

[-X-Ni-ck-X- 2]

Caute chtel jsem si do databaze MANGOS nahrat tento SQL:

INSERT INTO items (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2) 
VALUES (400306,2,8,-1,"Harin, Spawn of Northrend","Harin, Spawn of Northrend","Harin, Spawn of Northrend","Harin, Spawn of Northrend",35575,5,0,0000,0000,17,-1,-1,0,70,0,0,0,0,0,0,0,0,1,0,3,81,4,57,7,52,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,50,55,0,670,682,4,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,3700,0,0,27088,2,0,-1,0,-1,386***2,0,-1,0,-1,27124,0,0,200000,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,2,"The blade emits a radiance of cold",0,0,0,0,0,1,1,0,0,0,0,250,0,0,0,0,8,0,4,0,1, 0,106,0,0,0,0);

 

A ukazalo mi to tuto chybu:

[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 '**2,0,-1,0,-1,27124,0,0,200000,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,2,"The blade emits a' at line 2
[Msg] Finished - Unsuccessfully

[Apixx 67]

Vtom scriptu maji byt ty hvezdicky "***" ?? (Pokud ne skus je dat pryc a pak to nahraj)

Edited May 6, 2009 by Apixx

[-X-Ni-ck-X- 2]

Hvezdicky jsem dal pryc a ted to napsalo toto:

[Err] 1146 - Table 'mangos.items' doesn't exist

 

Ale newim do jake dabase s itemy by se to melo ulozit ???

[Wladass 1216]

Tabulka pro itemy je item_template proto ti to nejde

[Apixx 67]

No rikam musis vymazat hvezdicky a nahraj to do DB mangos pak ve hre das .additem a ID itemu a mas problem vyreseny

[Aristo 15]

INSERT INTO item_template (entry, class, subclass, field4, name, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ItemExtendedCost, ReqDisenchantSkill, unk2)
VALUES (400306,2,8,-1,"Harin, Spawn of Northrend","Harin, Spawn of Northrend","Harin, Spawn of Northrend","Harin, Spawn of Northrend",35575,5,0,0000,0000,17,-1,-1,0,70,0,0,0,0,0,0,0,0,1,0,3,81,4,57,7,52,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,50,55,0,670,682,4,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,3700,0,0,27088,2,0,-1,0,-1,3862,0,-1,0,-1,27124,0,0,200000,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,2,"The blade emits a radiance of cold",0,0,0,0,0,1,1,0,0,0,0,250,0,0,0,0,8,0,4,0,1, 0,106,0,0,0,0);

Zkus tohle, tabulka "items" jak si měl neexistuje, pokud chceš vytvořit item tak se to narává do "item_template

Edited May 6, 2009 by N/P/C

[-X-Ni-ck-X- 2]

Cky skusim

 

EDIT: Takze mi to ukazuje zase jednu chybu:

[Err] 1136 - Column count doesn't match value count at row 1

Edited May 6, 2009 by -X-Ni-ck-X-

[Wladass 1216]

 

EDIT : Jasný mám to, máš tam příliš mnoho sloupečků, který se snažíš vtěsnat do tabulky...

Edited May 6, 2009 by wladass

[-X-Ni-ck-X- 2]

A jak to mam nahrat ???

[Aristo 15]

Jak si nahrával ty předešlé když ti to házelo ty errory? řekl bych že tohle se nahrává úplně stejně ne?

[Wladass 1216]

Nevím kde jsi tento "script" vzal ,ale nejspíše nesouhlasi jak s počtem tak ani s názvy sloupečků v tvé databázi..

[-X-Ni-ck-X- 2]

Takze ted odejdu trochu od tematu:

Jak je to z Item ID ??? Co kdyz dam Id stejne jako ma uz i jiny Item ???

A jeste jak je to se SPEED kdyz bude speed 10.5 tak je to rychlejsi nez 2.5 ??

Edited May 6, 2009 by -X-Ni-ck-X-

[Wladass 1216]

Čeky předělám ti ten item script..

 

Pokud dáš funkci REPLACE INTO tak ti starý item nahradí novým.

 

REPLACE INTO `item_template` (`entry`, `class`, `subclass`, `unk0`, `name`, `displayid`, `Quality`, `Flags`, `BuyCount`, `BuyPrice`, `SellPrice`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `RequiredSkill`, `RequiredSkillRank`, `requiredspell`, `requiredhonorrank`, `RequiredCityRank`, `RequiredReputationFaction`, `RequiredReputationRank`, `maxcount`, `stackable`, `ContainerSlots`, `StatsCount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScalingStatDistribution`, `ScalingStatValue`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `RangedModRange`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellppmRate_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellppmRate_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellppmRate_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellppmRate_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `PageText`, `LanguageID`, `PageMaterial`, `startquest`, `lockid`, `Material`, `sheath`, `RandomProperty`, `RandomSuffix`, `block`, `itemset`, `MaxDurability`, `area`, `Map`, `BagFamily`, `TotemCategory`, `socketColor_1`, `socketContent_1`, `socketColor_2`, `socketContent_2`, `socketColor_3`, `socketContent_3`, `socketBonus`, `GemProperties`, `RequiredDisenchantSkill`, `ArmorDamageModifier`, `Duration`, `ItemLimitCategory`, `ScriptName`, `DisenchantID`, `FoodType`, `minMoneyLoot`, `maxMoneyLoot`) VALUES (400306, 2, 8, -1, 'Harin, Spawn of Northrend', 35575, 5, 0, 1, 0, 0, 17, -1, -1, 0, 70, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 3, 81, 4, 57, 7, 52, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 50, 55, 0, 670, 682, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3700, 0, 0, 27088, 2, 0, 0, -1, 0, -1, 3862, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 0, 0, 0, 0, -1, 0, -1, 2, 'The blade emits a radiance of cold', 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 8, 0, 4, 0, 1, 0, 106, 0, -1, 0, 0, 0, '', 0, 0, 0, 0);

 

Nevím jak moc to bude dobře in-game ale syntax už sedí a hodnoty by měli taky..

Edited May 6, 2009 by Xmat
doublepost je ee ;)

[-X-Ni-ck-X- 2]

Diky...moc...