Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Скрипт сгенерирован Devart dbForge Studio for MySQL, Версия 4.50.285.1
- -- Дата скрипта: 18.11.2010 17:54:53
- -- Версия сервера базы данных источника: 5.0.51a-24+lenny2+spu1
- -- Строка соединения источника: User Id=hummer;Host=188.72.225.21;Character Set=utf8;
- -- Версия сервера базы данных получателя: 5.0.51a-24+lenny2+spu1
- -- Строка соединения получателя: User Id=hummer;Host=188.72.225.21;Character Set=utf8;
- -- Выполните скрипт в базу world, чтобы синхронизировать ее с базой test
- -- Пожалуйста, сохраните резервную копию вашей базы получателя перед запуском этого скрипта
- SET NAMES 'utf8';
- USE world;
- BEGIN;
- --
- -- Отключение внешних ключей
- --
- /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
- --
- -- Обновление данных в таблице spell_bonus_data
- --
- UPDATE spell_bonus_data SET dot_bonus = -1, ap_bonus = -1, ap_dot_bonus = -1, comments = 'Druid - Starfall rank 1' WHERE entry = 50288;
- UPDATE spell_bonus_data SET dot_bonus = -1, ap_bonus = -1, ap_dot_bonus = -1, comments = 'Druid - Starfall AOE rank 1' WHERE entry = 50294;
- UPDATE spell_bonus_data SET direct_bonus = 0.13 WHERE entry = 53188;
- UPDATE spell_bonus_data SET direct_bonus = 0.13 WHERE entry = 53189;
- UPDATE spell_bonus_data SET direct_bonus = 0.13 WHERE entry = 53190;
- UPDATE spell_bonus_data SET direct_bonus = 0.3 WHERE entry = 53191;
- UPDATE spell_bonus_data SET direct_bonus = 0.3 WHERE entry = 53194;
- UPDATE spell_bonus_data SET direct_bonus = 0.3 WHERE entry = 53195;
- --
- -- Удаление данных из таблицы spell_dbc
- --
- DELETE FROM spell_dbc WHERE Id IN(7056, 27488, 45459, 45460);
- --
- -- Удаление данных из таблицы spell_linked_spell
- --
- DELETE FROM spell_linked_spell WHERE spell_trigger = 24714 AND spell_effect = 24750 AND TYPE = 1 OR spell_trigger = 56683 AND spell_effect = -56726 AND TYPE = 1 OR spell_trigger = 56684 AND spell_effect = -56687 AND TYPE = 0 OR spell_trigger = 57787 AND spell_effect = -57745 AND TYPE = 1;
- --
- -- Удаление данных из таблицы spell_proc_event
- --
- DELETE FROM spell_proc_event WHERE entry IN(71571, 71573);
- --
- -- Удаление данных из таблицы spell_scripts
- --
- DELETE FROM spell_scripts WHERE id = 42287 AND effIndex = 0 AND delay = 0 AND command = 17 AND datalong = 33041 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 47097 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 47324 AND datalong2 = 0 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 47097 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 47325 AND datalong2 = 0 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 47701 AND effIndex = 0 AND delay = 0 AND command = 10 AND datalong = 26902 AND datalong2 = 30000 AND dataint = 0 AND x = 4647.22 AND y = -4860.69 AND z = 35.48 AND o = 0.153 OR id = 48724 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 48723 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 48726 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 48725 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 48728 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 48727 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 48730 AND effIndex = 0 AND delay = 0 AND command = 15 AND datalong = 48729 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0 OR id = 49466 AND effIndex = 1 AND delay = 1 AND command = 15 AND datalong = 47523 AND datalong2 = 1 AND dataint = 0 AND x = 0 AND y = 0 AND z = 0 AND o = 0;
- --
- -- Удаление данных из таблицы spell_script_names
- --
- DELETE FROM spell_script_names WHERE spell_id = 50524 AND ScriptName = 'spell_dk_runic_power_feed' OR spell_id = 55891 AND ScriptName = 'spell_taldaram_flame_ball_visual' OR spell_id = 55947 AND ScriptName = 'spell_taldaram_flame_ball_visual' OR spell_id = 66118 AND ScriptName = 'spell_gen_leeching_swarm' OR spell_id = 69172 AND ScriptName = 'spell_tyrannus_overlord_brand' OR spell_id = 70903 AND ScriptName = 'spell_cultist_dark_martyrdrom' OR spell_id = 71236 AND ScriptName = 'spell_cultist_dark_martyrdrom' OR spell_id = 71598 AND ScriptName = 'spell_creature_permanent_feign_death' OR spell_id = 71718 AND ScriptName = 'spell_taldaram_summon_flame_ball' OR spell_id = 71756 AND ScriptName = 'spell_taldaram_ball_of_inferno_flame' OR spell_id = 71806 AND ScriptName = 'spell_taldaram_glittering_sparks' OR spell_id = 71905 AND ScriptName = 'spell_item_shadowmourne' OR spell_id = 72040 AND ScriptName = 'spell_taldaram_summon_flame_ball' OR spell_id = 72080 AND ScriptName = 'spell_valanar_kinetic_bomb' OR spell_id = 72087 AND ScriptName = 'spell_valanar_kinetic_bomb_knockback' OR spell_id = 72782 AND ScriptName = 'spell_taldaram_ball_of_inferno_flame' OR spell_id = 72783 AND ScriptName = 'spell_taldaram_ball_of_inferno_flame' OR spell_id = 72784 AND ScriptName = 'spell_taldaram_ball_of_inferno_flame' OR spell_id = 72999 AND ScriptName = 'spell_blood_council_shadow_prison_damage' OR spell_id = 73001 AND ScriptName = 'spell_blood_council_shadow_prison';
- --
- -- Удаление данных из таблицы spell_target_position
- --
- DELETE FROM spell_target_position WHERE id IN(56679, 57535, 57541, 57677, 57746, 57747, 57773, 57782, 57786);
- --
- -- Обновление данных в таблице spell_target_position
- --
- UPDATE spell_target_position SET target_position_x = -503.593, target_position_z = 62.7621, target_orientation = 3.14159 WHERE id = 70856;
- UPDATE spell_target_position SET target_position_x = -615.146, target_position_z = 199.909, target_orientation = 0 WHERE id = 70857;
- UPDATE spell_target_position SET target_position_x = -549.073, target_position_z = 539.223, target_orientation = 0 WHERE id = 70858;
- --
- -- Удаление данных из таблицы trinity_string
- --
- DELETE FROM trinity_string WHERE entry IN(63, 65);
- --
- -- Удаление данных из таблицы vehicle_accessory
- --
- DELETE FROM vehicle_accessory WHERE entry = 28614 AND seat_id = 0 OR entry = 29931 AND seat_id = 0;
- --
- -- Вставка данных в таблицу vehicle_accessory
- --
- INSERT INTO vehicle_accessory(entry, seat_id, accessory_entry, minion, description) VALUES
- (33113, 0, 33114, 1, 'Flame Leviathan'),
- (33113, 1, 33114, 1, 'Flame Leviathan');
- --
- -- Включение внешних ключей
- --
- /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement