File: /www/exchange0old/sql/archive/email_fix.sql
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (37, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', 'Enquiry', NULL, '', 'Credebt Exchange Limited', 'Enquiry', 1, 'Dear Admin ! <br>\r\n\r\nWe have a New Enquiry from DEBX Support Form.<br>\r\n\r\nFull Name : <fullname><br>\r\nEmail Address : <emailaddress><br>\r\nDial Country : <dialcountry><br>\r\nDial Code : <dialcode><br>\r\nDial Number : <dialnumber><br>\r\nOrganisation Name : <organizationname><br>\r\nEnquiry : <enquiry><br>\r\nMessage : <message><br>\r\n<br>\r\nThank You<br>\r\n\r\nCredebt Exchange Support Team<br>\r\n\r\nDo not reply to this email, contact us using<br>\r\nhttps://www.credebtexchange.com/support.php<br>\r\n\r\nFor more details about Trading, visit<br>\r\nhttp://www.credebtexchange.com/trader<br>\r\n\r\nhttp://www.credebtexchange.com<br>\r\n\r\nTrade on Your Terms<br>\r\n-------------------------------0----------------------------<br>\r\nFor legal & confidential disclaimer and email footer, visit:<br>\r\nhttp://www.credebtexchange.com/legal/email+footer<br>\r\n-------------------------------0----------------------------<br>\r\n\r\n© Credebt Exchange. 2011. All rights reserved.', 'Dear Admin ! <br>\r\n\r\nWe have a New Enquiry from DEBX Support Form.<br>\r\n\r\nFull Name : <fullname><br>\r\nEmail Address : <emailaddress><br>\r\nDial Country : <dialcountry><br>\r\nDial Code : <dialcode><br>\r\nDial Number : <dialnumber><br>\r\nOrganisation Name : <organizationname><br>\r\nEnquiry : <enquiry><br>\r\nMessage : <message><br>\r\n<br>\r\nThank You<br>\r\n\r\nCredebt Exchange Support Team<br>\r\n\r\nDo not reply to this email, contact us using<br>\r\nhttps://www.credebtexchange.com/support.php<br>\r\n\r\nFor more details about Trading, visit<br>\r\nhttp://www.credebtexchange.com/trader<br>\r\n\r\nhttp://www.credebtexchange.com<br>\r\n\r\nTrade on Your Terms<br>\r\n-------------------------------0----------------------------<br>\r\nFor legal & confidential disclaimer and email footer, visit:<br>\r\nhttp://www.credebtexchange.com/legal/email+footer<br>\r\n-------------------------------0----------------------------<br>\r\n\r\n© Credebt Exchange. 2011. All rights reserved.', 1, '2015-06-04 08:47:34', 1);
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (38, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', '####### SELL RATE QUOTE #######', NULL, 'tradedesk@credebtexchange.com', 'Credebt Exchange Limited', '####### SELL RATE QUOTE #######', 1, 'Attn. <name><br><br>\r\n Further to your recent request for a Sell Rate quote, the RSA Offer below is conditional on receiving further information as requested by your Specialist.<br><br>\r\n Annual Turnover : <annualTurnover><br><br>\r\n Provisional RSA Offer: <sellrate>%<br><br>\r\n\r\n IMPORTANT NOTE:- The Exchange is a fast moving, liquid market that operates on a ‘first come, first served’ basis. This Provisional RSA Offer expires within 72 hours from time of issue.<br><br>\r\n If you want to confirm this Sell Rate and begin trading on Credebt Exchange, complete this online form now:<br><br>\r\n <a href="https://www.credebtexchange.com/originator/enquiry.php">https://www.credebtexchange.com/originator/enquiry.php</a><br><br>\r\n Should you wish to discuss this communication, please contact the Trade Desk using any of the details below.<br><br>\r\n Thank you for your enquiry and we look forward to offering you the best in commercial services.<br><br>\r\n Yours Sincerely,<br><br>\r\n tradedesk@credebtexchange.com<br><br>\r\n Direct Dial : +353 1 685-3665<br>\r\n Switchboard : +353 1 685-3600<br><br>\r\n Please Note:- All calls to and from Credebt Exchange are recorded to confirm instructions given and for training and quality control purposes.<br><br>\r\n <a href="http://www.credebtexchange.com">http://www.credebtexchange.com</a><br><br>\r\n Low Cost Capital<br><br>\r\n -------------------------------0----------------------------<br><br>\r\n For legal & confidential disclaimer and email footer, visit:<br><br>\r\n <a href="http://www.credebtexchange.com/legal/email+footer"> http://www.credebtexchange.com/legal/email+footer</a><br><br>\r\n -------------------------------0----------------------------<br>', 'Attn. <name><br><br>\r\n Further to your recent request for a Sell Rate quote, the RSA Offer below is conditional on receiving further information as requested by your Specialist.<br><br>\r\n Annual Turnover : <annualTurnover><br><br>\r\n Provisional RSA Offer: <sellrate>%<br><br>\r\n\r\n IMPORTANT NOTE:- The Exchange is a fast moving, liquid market that operates on a ‘first come, first served’ basis. This Provisional RSA Offer expires within 72 hours from time of issue.<br><br>\r\n If you want to confirm this Sell Rate and begin trading on Credebt Exchange, complete this online form now:<br><br>\r\n <a href="https://www.credebtexchange.com/originator/enquiry.php">https://www.credebtexchange.com/originator/enquiry.php</a><br><br>\r\n Should you wish to discuss this communication, please contact the Trade Desk using any of the details below.<br><br>\r\n Thank you for your enquiry and we look forward to offering you the best in commercial services.<br><br>\r\n Yours Sincerely,<br><br>\r\n tradedesk@credebtexchange.com<br><br>\r\n Direct Dial : +353 1 685-3665<br>\r\n Switchboard : +353 1 685-3600<br><br>\r\n Please Note:- All calls to and from Credebt Exchange are recorded to confirm instructions given and for training and quality control purposes.<br><br>\r\n <a href="http://www.credebtexchange.com">http://www.credebtexchange.com</a><br><br>\r\n Low Cost Capital<br><br>\r\n -------------------------------0----------------------------<br><br>\r\n For legal & confidential disclaimer and email footer, visit:<br><br>\r\n <a href="http://www.credebtexchange.com/legal/email+footer"> http://www.credebtexchange.com/legal/email+footer</a><br><br>\r\n -------------------------------0----------------------------<br>', 1, '2015-06-04 09:12:08', 1);
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (39, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', '####### SELL RATE REQUEST #######', 'tradedesk@credebtexchange.com', '', 'Credebt Exchange Limited', '####### SELL RATE REQUEST #######', 1, 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Per line : <perline><br>\r\n Annual Turnover : <annualTurnover><br>\r\n Business : <business><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Per line : <perline><br>\r\n Annual Turnover : <annualTurnover><br>\r\n Business : <business><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 1, '2015-00-00 00:00:00', 1);
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (40, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', '####### SELL RATE REQUEST #######', 'tradedesk@credebtexchange.com', '', 'Credebt Exchange Limited', '####### SELL RATE REQUEST #######', 1, 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Date : <date><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Date : <date><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 1, '0000-00-00 00:00:00', 1);
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (41, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', '####### TRIED TO LOGIN FROM APP #######', 'tradedesk@credebtexchange.com', '', 'Credebt Exchange Limited', '####### TRIED TO LOGIN FROM APP #######', 1, 'Tried to login from App by <email><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 'Tried to login from App by <email><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 1, '0000-00-00 00:00:00', 1);
INSERT INTO `mail_management` (`mail_id`, `smtp_host`, `smtp_port`, `smtp_username`, `smtp_password`, `mail_name`, `mail_to`, `mail_from`, `mail_from_name`, `mail_subject`, `mail_type`, `mail_content`, `mail_content_text`, `mail_status`, `modified_at`, `modified_by`) VALUES (42, 'localhost', '25', 'patrick.reynolds@credebtexchange.com', 'Gz1', '####### MEMBERSHIP ENQUIRY #######', 'tradedesk@credebtexchange.com', '', 'Credebt Exchange Limited', '####### MEMBERSHIP ENQUIRY #######', 1, 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Business : <business><br>\r\n Annual Turnover : <annualTurnover><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 'Full Name : <name><br>\r\n Email Address : <email><br>\r\n Phone Number : <phone><br>\r\n Business : <business><br>\r\n Annual Turnover : <annualTurnover><br> <br>\r\n For details about trading and trading strategies, visit :<br>\r\n <br>http://www.credebtexchange.com/originator\r\n <br><br>Do not reply to this email, contact us using:\r\n <br><br>https://www.credebtexchange.com/support.php\r\n <br><br>Thank You<br><br>Credebt Exchange Support Team\r\n <br><br>http://www.credebtexchange.com\r\n <br><br> Trade on Your Terms\r\n <br><br>----------------------------0--------------------------\r\n <br>For legal & confidential disclaimer and email footer, visit:\r\n <br>http://www.credebtexchange.com/legal/email+footer \r\n <br>----------------------------0--------------------------\r\n <br>© 2012, Credebt Exchange Limited. All rights reserved.', 1, '2015-06-04 10:07:52', 1);