<?php
run_query("ALTER TABLE `" . $config['table_prefix'] . "mail_templates` ADD `type` TINYINT NOT NULL AFTER `id`");
run_query("UPDATE `" . $config['table_prefix'] . "mail_templates` SET type=1, body=replace(body,'{link_record}','{record_link}')");
run_query("INSERT INTO `" . $config['table_prefix'] . "mail_templates` (`type`, `name`, `sender`, `subject`, `body`) VALUES (2, '" . $lang['Create_user'] . "', '" . $config['application'] . "', '" . $lang['Program_invite'] . "', '<p><b>" . $lang['Hello'] . ", {fio}!</b></p>\n<p>" . $lang['You_reg_in_program'] . " \"" . $config['application'] . "\"</p>\n<p>" . $lang['click_following_link'] . ": <a href=\"{program_link}\">{program_link}</a></p>\n<p><b>" . $lang['Login'] . ": {login}</b></p>\n<p><b>" . $lang['Password'] . ": {password}</b></p>\n<p>&nbsp;</p>\n<p>" . $lang['Good_luck'] . "!</p>\n')");
?>