Архив - только для чтения | |
Модератор форума: andycrowz |
Форум Корзина форума Корзина AlterShop 3.3.5a for ManGOS 10333-10589 только для моих ядер |
AlterShop 3.3.5a for ManGOS 10333-10589 только для моих ядер |
lanc, ты брал оффициальный гмшоп? 1.0.1 ? если да, то ты не добавлял сам вендоров? просто у меня есть расстановка в шаттрате вдруг ты чего добавил)
Добавлено (04.09.2010, 12:04)
Сообщение # 32 написано 04.09.2010 в 12:04
|
народ пишет вот ето
[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 'DELETE FROM `creature_template` WHERE `entry` BETWEEN 200000 AND 220300' at line 1 [Err] DELETE FROM `creature_template` WHERE `entry` BETWEEN 200000 AND 220300; [Msg] Finished - Unsuccessfully што делать пытаюсь залить в твою сборку -blizzlike_10351 мне прост реалмы надо сделать а фан оч важен((( ![]()
Сообщение # 34 написано 09.09.2010 в 20:12
|
удали эту строчку... если первый раз льеш гмшоп то она вабще не нужна, а почему на нее ругается я не в курсе я лил себе через консоль некаких ошибок нету, правда давно это было я не помню как там на всякий случай можеш попробовать заменить ту строчку на DELETE FROM creature_template WHERE entry BETWEEN 200000 AND 220300; возможно в самом файле допустил ошибку
Сообщение # 35 написано 09.09.2010 в 20:25
|
удалил пишет ещё круче
[cut][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 'INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_e' at line 1 [Err] INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `PowerType`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200000, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h/Bow/Gun/Mace 1h/Mace 2h/Polearm/Sword 1h/Sword 2h', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200001, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Staff/Fist weapon/Dagger/Thrown/Crossbow/Wand', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200002, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200003, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Bow/Gun', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200004, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Mace 1h/Mace 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200005, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Polearm/Sword 1h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200006, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Sword 2h/Staff', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 0, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0 [Msg] Finished - Unsuccessfully[/cut] Добавлено (10.09.2010, 13:18)
Сообщение # 36 написано 10.09.2010 в 13:18
|
Err] 1054 - Unknown column 'modelid_A' in 'field list'
[Err] REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_A`, `modelid_A2`, `modelid_H`, `modelid_H2`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200000, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h/Bow/Gun/Mace 1h/Mace 2h/Polearm/Sword 1h/Sword 2h', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200001, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Staff/Fist weapon/Dagger/Thrown/Crossbow/Wand', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200002, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200003, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Bow/Gun', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200004, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Mace 1h/Mace 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200005, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Polearm/Sword 1h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200006, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Sword 2h/Staff', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200007, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Fist weapon/Dagger', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286 [Msg] Finished - Unsuccessfully -------------------------------------------------- что делать?
Сообщение # 37 написано 26.09.2010 в 04:26
|
Quote (Chinik) Дак че делать то если не пашет АВТОР! АУУУУУ ручками переделывать) Шас попробую.
Сообщение # 40 написано 29.09.2010 в 11:20
|
[Err] 1054 - Unknown column 'VehicleEntry' in 'field list'
[Err] INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `faction_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `VehicleEntry`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200000, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h/Bow/Gun/Mace 1h/Mace 2h/Polearm/Sword 1h/Sword 2h', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200001, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Staff/Fist weapon/Dagger/Thrown/Crossbow/Wand', 'weapon_1-69LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200002, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Axe 1h/Axe 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200003, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Bow/Gun', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200004, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Mace 1h/Mace 2h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200005, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Polearm/Sword 1h', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200006, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Sword 2h/Staff', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 10000, 1, 35, 35, 4224, 1.15, 1.14286, 1, 1, 1200, 1620, 0, 1208, 1, 1600, 1760, 0, 0, 0, 0, 0, 0, 0, 0, 57.728, 79.376, 100, 7, 138936390, 0, 0, 0, 999, 999, 999, 999, 999, 999, 0, 0, 0, 0, 0, 0, 1500, 1700, '', 0, 3, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''), (200007, 0, 0, 0, 0, 0, 27021, 0, 27021, 0, 'Fist weapon/Dagger', 'weapon_70-79LvL', NULL, 0, 81, 81, 10000, 10000, 10000, 1000 [Msg] Finished - Unsuccessfully --------------------------------------------
Сообщение # 41 написано 05.10.2010 в 14:30
|
Zver107, а ты что смог залить у меня вот на рев 4 пишет
Code [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 'DELETE FROM `creature_template` WHERE `entry` BETWEEN 200000 AND 220300' at line 1 [Err] DELETE FROM `creature_template` WHERE `entry` BETWEEN 200000 AND 220300; [Msg] Finished - Unsuccessfully -------------------------------------------------- вот ид вообще там они есть Добавлено (14.10.2010, 12:58)
Сообщение # 44 написано 14.10.2010 в 12:58
|
Steels, всё прекрассно идёт и нормально отображается заливай правильно
![]() ![]() Новый Храм будет воздвигнут. Ты вещь государства или хозяин Своей Жизни? Начни империю с Себя. Мы не сделали ничего великого, но обесценили то, что считалось великим.
Сообщение # 47 написано 15.10.2010 в 10:39
|
Данная тема была перемещена из раздела Патчи / Моды / Фиксы MaNGOS.
Причина перемещения: устарело Переместил: ph3n.
Сообщение # 54 написано 01.11.2012 в 16:53
|
| |||