|
Архив - только для чтения |
| Модератор форума: andycrowz |
| Форум » Корзина форума » Корзина » Столкнулся с проблемой когда заливал альтершоп |
| Столкнулся с проблемой когда заливал альтершоп |
Альтершоп взял тут
[Err] 1054 - Unknown column 'DeathState' in 'field list' [Err] REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200109, 0, 0, 0, 0, 0, 22959, 0, 22959, 0, 'Flask', 'flask', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4493, 0, 0, ''); DELETE FROM `npc_vendor` WHERE (`entry`=200109); INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES (200109, 40079, 0, 0, 0), (200109, 40082, 0, 0, 0), (200109, 40083, 0, 0, 0), (200109, 40084, 0, 0, 0), (200109, 40404, 0, 0, 0), (200109, 44939, 0, 0, 0), (200109, 46376, 0, 0, 0), (200109, 46377, 0, 0, 0), (200109, 46378, 0, 0, 0), (200109, 46379, 0, 0, 0), (200109, 47499, 0, 0, 0); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200110, 0, 0, 0, 0, 0, 22959, 0, 22959, 0, 'Scroll', 'scroll', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4493, 0, 0, ''); DELETE FROM `npc_vendor` WHERE (`entry`=200110); INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES (200110, 37092, 0, 0, 0), (200110, 37094, 0, 0, 0), (200110, 37098, 0, 0, 0), (200110, 43464, 0, 0, 0), (200110, 43466, 0, 0, 0), (200110, 44315, 0, 0, 0), (200110, 49632, 0, 0, 0); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, [Err] 1062 - Duplicate entry '200116-36922-0' for key 'PRIMARY' [Err] INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES (200116, 36922, 0, 0, 0), (200116, 40123, 0, 0, 0), (200116, 40124, 0, 0, 0), (200116, 40125, 0, 0, 0), (200116, 40126, 0, 0, 0), (200116, 40127, 0, 0, 0), (200116, 40128, 0, 0, 0), (200116, 45882, 0, 0, 0), (200116, 45987, 0, 0, 0); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200115, 0, 0, 0, 0, 0, 657, 0, 657, 0, 'BLUE', 'gemstone', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''); DELETE FROM `npc_vendor` WHERE (`entry`=200115); INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES (200115, 36925, 0, 0, 0), (200115, 40119, 0, 0, 0), (200115, 40120, 0, 0, 0), (200115, 40121, 0, 0, 0), (200115, 40122, 0, 0, 0), (200115, 45880, 0, 0, 0), (200115, 45881, 0, 0, 0); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (200114, 0, 0, 0, 0, 0, 657, 0, 657, 0, 'RED', 'gemstone', '', 0, 80, 80, 0, 35, 35, 4224, 1, 1, 50, 150, 0, 1000, 1, 2000, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 10, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, ''); DELETE FROM `npc_vendor` WHERE (`entry`=200114); INSERT INTO `npc_vendor` (entry, item, maxcount, incrtime, ExtendedCost) VALUES (200114, 36919, 0, 0, 0), (200114, 40111, 0, 0, 0), (200114, 40112, 0, 0, 0), (200114, 40113, 0, 0, 0), (200114, 40114, 0, 0, 0), (200114, 40115, 0, 0, 0), (200114, 40116, 0, 0, 0), (200114, 40117, 0, 0, 0), (200114, 40118, 0, 0, 0), (200114, 45862, 0, 0, 0), (200114, 45879, 0, 0, 0), (200114, 45883, 0, 0, 0); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficult [Err] 1054 - Unknown column 'DeathState' in 'field list' [Err] DELETE FROM `creature` WHERE `id`=200160; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201186, 200160, 0, 1, 1, 0, 0, -8927.26, 528.74, 94.4227, 0.73638, 300, 0, 0, 5342, 0, 0, 0), (201412, 200160, 1, 1, 1, 0, 4493, 1416.14, -4357.62, 25.4627, 4.84822, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=40070; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (204302, 40070, 0, 1, 1, 0, 2026, -8893, 561.573, 92.8915, 2.19847, 300, 0, 0, 46460, 21290, 0, 0), (9337690, 40070, 1, 1, 1, 0, 2026, 1421.93, -4356.06, 25.4629, 4.89668, 300, 0, 0, 46460, 21290, 0, 0); DELETE FROM `creature` WHERE `id`=40071; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201204, 40071, 0, 1, 1, 0, 4493, -8895.74, 559.463, 93.0128, 2.27908, 300, 0, 0, 46460, 21290, 0, 0), (9337693, 40071, 1, 1, 1, 0, 4493, 1428.85, -4355.53, 25.4629, 4.75999, 300, 0, 0, 46460, 21290, 0, 0); DELETE FROM `creature` WHERE `id`=40072; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201205, 40072, 0, 1, 1, 0, 0, -8898.53, 557.201, 93.2434, 2.22803, 300, 0, 0, 46460, 21290, 0, 0), (9337689, 40072, 1, 1, 1, 0, 3934, 1425.31, -4355.79, 25.4629, 4.87028, 300, 0, 0, 46460, 212900, 0, 0); DELETE FROM `creature` WHERE `id`=40073; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201365, 40073, 1, 1, 1, 0, 4493, 1430.92, -4355.66, 25.4627, 4.61947, 300, 0, 0, 58080, 0, 0, 0), (201206, 40073, 0, 1, 1, 0, 4493, -8901.79, 554.804, 93.471, 2.26337, 300, 0, 0, 58080, 0, 0, 0); DELETE FROM `creature` WHERE `id`=40074; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (204305, 40074, 1, 1, 1, 18595, 4321, 1432.81, -4355.49, 25.4624, 4.71667, 300, 0, 0, 58080, 0, 0, 0), (204299, 40074, 0, 1, 1, 0, 4321, -8903.78, 553.214, 93.6497, 2.40424, 300, 0, 0, 58080, 0, 0, 0); DELETE FROM `creature` WHERE `id`=40075; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (204306, 40075, 1, 1, 1, 0, 3245, 1435.85, -4355.5, 25.4624, 4.65384, 300, 0, 0, 58080, 0, 0, 0), (204300, 40075, 0, 1, 1, 0, 3245, -8906.32, 551.087, 93.8911, 2.20396, 300, 0, 0, 58080, 0, 0, 0); DELETE FROM `creature` WHERE `id`=40076; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201467, 40076, 1, 1, 1, 0, 4321, 1439.1, -4356.47, 25.4626, 3.91162, 300, 0, 0, 58080, 0, 0, 0), (201245, 40076, 0, 1, 1, 0, 4321, -8908.93, 548.799, 94.1543, 2.32651, 300, 0, 0, 58080, 0, 0, 0); DELETE FROM `creature` WHERE `id`=40077; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipme [Err] 1054 - Unknown column 'DeathState' in 'field list' [Err] DELETE FROM `creature` WHERE `id`=200126; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201241, 200126, 0, 1, 1, 0, 0, -8960.77, 556.23, 93.8736, 1.53328, 300, 0, 0, 5342, 0, 0, 0), (201402, 200126, 1, 1, 1, 0, 0, 1424.99, -4385.47, 25.4627, 0.150859, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200133; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201156, 200133, 0, 1, 1, 0, 0, -8918.81, 537.589, 94.8596, 3.92805, 300, 0, 0, 5342, 0, 0, 0), (201408, 200133, 1, 1, 1, 0, 0, 1424.57, -4382.98, 25.4627, 0.13534, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200134; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201199, 200134, 0, 1, 1, 0, 0, -8934.77, 538.185, 94.3793, 0.722823, 300, 0, 0, 5342, 0, 0, 0), (201409, 200134, 1, 1, 1, 0, 0, 1424.46, -4380.98, 25.4627, 0.0827188, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200135; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (9338226, 200135, 0, 1, 1, 0, 1949, -8940.63, 564.309, 93.7997, 3.71793, 300, 0, 0, 53420, 0, 0, 0), (201410, 200135, 1, 1, 1, 0, 1949, 1424.27, -4378.62, 25.4627, 0.114134, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200106; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201157, 200106, 0, 1, 1, 0, 0, -8917.02, 535.308, 95.0445, 3.76798, 300, 0, 0, 5342, 0, 0, 0), (201251, 200106, 0, 1, 1, 0, 0, -9141.05, 368.215, 90.769, 2.33717, 300, 0, 0, 5342, 0, 0, 0), (201252, 200106, 1, 1, 1, 0, 0, 1323.2, -4394.54, 26.2344, 1.8001, 300, 0, 0, 5342, 0, 0, 0), (201423, 200106, 1, 1, 1, 0, 0, 1419.79, -4372.65, 25.4627, 1.72685, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200107; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201250, 200107, 0, 1, 1, 0, 0, -8916.29, 534.134, 94.9506, 3.8522, 300, 0, 0, 5342, 0, 0, 0), (201424, 200107, 1, 1, 1, 0, 0, 1417.67, -4372.96, 25.4627, 1.7347, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200108; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201459, 200108, 0, 1, 1, 0, 0, -8918.04, 536.193, 94.9968, 3.81296, 300, 0, 0, 5342, 0, 0, 0), (201425, 200108, 1, 1, 1, 0, 0, 1415.38, -4373.3, 25.4627, 1.69543, 300, 0, 0, 5342, 0, 0, 0); DELETE FROM `creature` WHERE `id`=200109; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (201136, 200109, 0, 1, 1, 0, 0, -8915.33, 533.108, 94.8559, 3.89744, 300, 0, 0, 5342, 0, 0, 0), (201426, 200109, 1, 1, 1, 0, 0, 1412.89, -4373.48, 25.4627, 1.62867, 300, 0, 0, 5342, [Err] 1054 - Unknown column 'DeathState' in 'field list' [Err] REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (70020, 0, 0, 0, 0, 0, 27153, 0, 27153, 0, 'Enchanter Nalthanis', 'Grand Master Enchanting Trainer', '', 0, 83, 83, 2, 35, 35, 81, 1, 2, 248, 372, 0, 93, 1, 2000, 2000, 8, 2, 8, 0, 2, 0, 0, 0, 198, 298, 74, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 4311, 0, 0, ''); DELETE FROM `npc_trainer` WHERE (`entry`=70020); INSERT INTO `npc_trainer` (entry, spell, spellcost, reqskill, reqskillvalue, reqlevel) VALUES (70020, 27958, 50000, 333, 350, 0), (70020, 32667, 50000, 333, 375, 35), (70020, 44484, 150000, 333, 405, 60), (70020, 44488, 150000, 333, 410, 60), (70020, 44489, 150000, 333, 420, 60), (70020, 44492, 100000, 333, 395, 60), (70020, 44500, 100000, 333, 395, 60), (70020, 44506, 50000, 333, 375, 60), (70020, 44508, 150000, 333, 410, 60), (70020, 44509, 150000, 333, 420, 60), (70020, 44510, 150000, 333, 410, 60), (70020, 44513, 100000, 333, 395, 60), (70020, 44528, 90000, 333, 385, 60), (70020, 44529, 150000, 333, 415, 60), (70020, 44555, 50000, 333, 375, 60), (70020, 44582, 100000, 333, 395, 60), (70020, 44584, 150000, 333, 405, 60), (70020, 44589, 150000, 333, 415, 60), (70020, 44592, 50000, 333, 360, 60), (70020, 44593, 150000, 333, 420, 60), (70020, 44598, 150000, 333, 415, 60), (70020, 44616, 100000, 333, 400, 60), (70020, 44623, 50000, 333, 370, 60), (70020, 44629, 100000, 333, 395, 60), (70020, 44630, 80000, 333, 390, 60), (70020, 44633, 150000, 333, 410, 60), (70020, 44635, 100000, 333, 395, 60), (70020, 44636, 100000, 333, 400, 0), (70020, 44645, 100000, 333, 400, 0), (70020, 47766, 100000, 333, 400, 60), (70020, 47900, 150000, 333, 425, 60), (70020, 51312, 350000, 333, 350, 65), (70020, 59636, 100000, 333, 400, 0), (70020, 60606, 50000, 333, 375, 60), (70020, 60609, 50000, 333, 350, 60), (70020, 60616, 50000, 333, 360, 60), (70020, 60619, 150000, 333, 425, 0), (70020, 60621, 80000, 333, 380, 60), (70020, 60623, 90000, 333, 385, 60), (70020, 60653, 100000, 333, 395, 60), (70020, 60663, 150000, 333, 420, 60), (70020, 60668, 150000, 333, 425, 60), (70020, 60767, 100000, 333, 440, 60), (70020, 62959, 90000, 333, 385, 60); REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `spel [Err] 1062 - Duplicate entry '5-6' for key 'PRIMARY' [Err] INSERT INTO `playercreateinfo` VALUES ('5', '6', '1', '1637', '1434.25', '-4398.33', '25.4628', '0'); INSERT INTO `playercreateinfo` VALUES ('6', '6', '1', '1637', '1434.25', '-4398.33', '25.4628', '0'); INSERT INTO `playercreateinfo` VALUES ('7', '6', '0', '1519', '-8952.6', '566.102', '93.7933', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '6', '1', '1637', '1434.25', '-4398.33', '25.4628', '0'); INSERT INTO `playercreateinfo` VALUES ('10', '6', '1', '1637', '1434.25', '-4398.33', '25.4628', '0'); INSERT INTO `playercreateinfo` VALUES ('11', '6', '0', '1519', '-8952.6', '566.102', '93.7933', '0'); DELETE FROM `pool_pool` WHERE `pool_id`>1243 AND `pool_id`<9122; DELETE FROM `pool_gameobject` WHERE `pool_entry`>5691 AND `pool_entry`<6125; DELETE FROM `pool_pool` WHERE `pool_id`>9868 AND `pool_id`<10686; DELETE FROM `pool_gameobject` WHERE `pool_entry`>10685 AND `pool_entry`<13466; REPLACE INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction_A`, `faction_H`, `npcflag`, `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`, `Health_mod`, `Mana_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES (100000, 0, 0, 0, 0, 0, 26789, 0, 0, 0, 'Lafina', 'Teleport Service', '', 0, 80, 80, 0, 35, 35, 1, 0.75, 2, 1755, 1755, 0, 1504, 1000, 1500, 0, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 7, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 3, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 'npc_teleport'); DELETE FROM `creature` WHERE `id`=100000; INSERT INTO `creature` (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`sp awndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`) VALUES (9338190, 100000, 0, 1, 1, 0, 0, -8908.56, 524.485, 93.8555, 3.86955, 300, 0, 0, 534200, 0, 0, 0), (9338201, 100000, 1, 1, 1, 0, 0, 1447.83, -4429.03, 25.4628, 1.68307, 300, 0, 0, 534200, 0, 0, 0); UPDATE `item_template` SET `BuyCount` = 200 WHERE `entry` = 52021; UPDATE `item_template` SET `BuyCount` = 200 WHERE `entry` = 52020; UPDATE `item_template` SET `BuyCount` = 20 WHERE `entry` = 21215; UPDATE `item_template` SET `BuyCount` = 100, `maxcount` = 2000, `stackable` = 1000 WHERE `entry` = 6265; UPDATE `quest_template` SET `ExclusiveGroup` = 0 WHERE `ExclusiveGroup` IN (24579, 13830, 12958, 13112, 13100); 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` [Msg] Finished - Unsuccessfully -------------------------------------------------- |
Quote (liders) Unknown column 'DeathState' in 'field list' В тринити около года, а то уже и больше нет этой колонки, переписывайте все запросы, которые ее содержат.
Arcanum Core © Dev.
Для запросов на выдачу наград/снятие замечаний есть темы в Работе Портала. Не пишите по этому поводу в личку.
Сообщение # 2 написано 01.11.2012 в 17:32
|
| |||
| |||