DELETE FROM `creature_text` WHERE entry = 900002 AND groupid = 0 AND id = 0;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES (900002, 0, 0, 'Oyé, oyé par ici les glyphes !', 12, 0, 100, 0, 2, 0, 214001, 0, 'Vendeur de glyphes custom');

DELETE FROM `creature_text` WHERE entry = 900024 AND groupid = 0 AND id = 0;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES (900024, 0, 0, 'Venez lire les dernières nouvelles de Versus ! (n''oubliez pas de vider votre cache régulièrement)', 12, 0, 100, 0, 2, 0, 0, 0, 'Crieur public custom h2');

DELETE FROM `creature_text` WHERE entry = 900023 AND groupid = 0 AND id = 0;
INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES (900023, 0, 0, 'Venez lire les dernières nouvelles de Versus ! (n''oubliez pas de vider votre cache régulièrement)', 12, 0, 100, 0, 2, 0, 214004, 0, 'Crieur public custom');

DELETE FROM `smart_scripts` WHERE entryorguid = 900024 AND source_type = 0 AND id = 0 AND link = 0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900024, 0, 0, 0, 1, 0, 100, 0, 5000, 5000, 600000, 600000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK crieur public custom h2');

DELETE FROM `smart_scripts` WHERE entryorguid = 900023 AND source_type = 0 AND id = 0 AND link = 0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900023, 0, 0, 0, 1, 0, 100, 0, 5000, 5000, 600000, 600000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK crieur public custom');

DELETE FROM `smart_scripts` WHERE entryorguid = 900000 AND source_type = 0 AND id = 0 AND link = 0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900000, 0, 0, 0, 1, 0, 100, 0, 40000, 40000, 900000, 900000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK vendeuse de gemmes custom');

DELETE FROM `smart_scripts` WHERE entryorguid = 900002 AND source_type = 0 AND id = 0 AND link = 0;
INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900002, 0, 0, 0, 1, 0, 100, 0, 10000, 10000, 900000, 900000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK vendeur de glyphes 1');