INSERT INTO `Email_Notification` (`id`, `email`, `days`, `deactivate`, `updated`, `bcc`, `subject`, `content_type`, `body`, `use_variables`) VALUES
(1, '30 day renewal reminder', 30, '0', '0000-00-00 00:00:00', '', 'Listing renewal notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour listing "LISTING_TITLE" will expire in DAYS_INTERVAL days.\r\n\r\nYou can renew immediately by logging in to your account and submitting a credit card payment through the Payment area by the link below.\r\n\r\nDEFAULT_URL/members/billing/index.php\r\n\r\nFor further assistance please contact SITEMGR_EMAIL\r\n\r\nThank you for being a member of the Directory.\r\n\r\nRegards,\r\nThe EDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,LISTING_TITLE,LISTING_RENEWAL_DATE,DAYS_INTERVAL,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(2, '15 day renewal reminder', 15, '0', '0000-00-00 00:00:00', '', 'Listing renewal notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour listing "LISTING_TITLE" will expire in DAYS_INTERVAL days.\r\n\r\nYou can renew immediately by logging in to your account and submitting a credit card payment through the Payment area by the link below.\r\n\r\nDEFAULT_URL/members/billing/index.php\r\n\r\nFor further assistance please contact SITEMGR_EMAIL\r\n\r\nThank you for being a member of the Directory.\r\n\r\nRegards,\r\nThe EDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,LISTING_TITLE,LISTING_RENEWAL_DATE,DAYS_INTERVAL,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(3, '7 day renewal reminder', 7, '0', '0000-00-00 00:00:00', '', 'Listing renewal notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour listing "LISTING_TITLE" will expire in DAYS_INTERVAL days.\r\n\r\nYou can renew immediately by logging in to your account and submitting a credit card payment through the Payment area by the link below.\r\n\r\nDEFAULT_URL/members/billing/index.php\r\n\r\nFor further assistance please contact SITEMGR_EMAIL\r\n\r\nThank you for being a member of the Directory.\r\n\r\nRegards,\r\nThe EDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,LISTING_TITLE,LISTING_RENEWAL_DATE,DAYS_INTERVAL,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(4, '1 day renewal reminder', 1, '0', '0000-00-00 00:00:00', '', 'Listing renewal notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour listing "LISTING_TITLE" will expire in DAYS_INTERVAL days.\r\n\r\nYou can renew immediately by logging in to your account and submitting a credit card payment through the Payment area by the link below.\r\n\r\nDEFAULT_URL/members/billing/index.php\r\n\r\nFor further assistance please contact SITEMGR_EMAIL\r\n\r\nThank you for being a member of the Directory.\r\n\r\nRegards,\r\nThe EDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,LISTING_TITLE,LISTING_RENEWAL_DATE,DAYS_INTERVAL,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(5, 'Sponsor Account Create (sitemgr area)', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Account', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for signing up for an account in DEFAULT_URL\r\nLogin to manage your account with the username and password below.\r\n\r\nDEFAULT_URL/members\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nDEFAULT_URL', 'ACCOUNT_NAME,ACCOUNT_USERNAME,ACCOUNT_PASSWORD,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(6, 'Sponsor Account Update (sitemgr area)', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Account', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour account is updated in DEFAULT_URL\r\nLogin to manage your account with the username and password below.\r\n\r\nDEFAULT_URL/members\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nDEFAULT_URL', 'ACCOUNT_NAME,ACCOUNT_USERNAME,ACCOUNT_PASSWORD,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(7, 'Visitor Account Create (sitemgr area)', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Account', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for signing up for an account in DEFAULT_URL\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nDEFAULT_URL', 'ACCOUNT_NAME,ACCOUNT_USERNAME,ACCOUNT_PASSWORD,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(8, 'Visitor Account Update (sitemgr area)', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Account', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour account is updated in DEFAULT_URL\r\n\r\nUsername: ACCOUNT_USERNAME\r\nPassword: ACCOUNT_PASSWORD\r\n\r\nDEFAULT_URL', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(9, 'Forgotten Password', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE account information', 'text/plain', 'As requested, here is the information regarding your EDIRECTORY_TITLE account.\r\nTo change your forgotten password please click the link below and enter a new password.\r\nKEY_ACCOUNT\r\n\r\nFor further assistance please contact SITEMGR_EMAIL.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE.', 'ACCOUNT_NAME,ACCOUNT_USERNAME,KEY_ACCOUNT,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(10, 'New Listing', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYou have just added one listing in our directory.\r\n\r\nWhat do I do next?\r\n\r\nPlease login to the directory at the link below and click on Make your Payment link on the left menu options to pay for your listing.\r\nDEFAULT_URL/members\r\n\r\nOnce this has been completed a directory administrator will review your listing and set it live within the directory.\r\n\r\nSubmissions are reviewed within 2 working days following payment.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Advertising Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(11, 'New Event', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for adding your event to our directory calendar.\r\n\r\nAn administrator will review your event and make it live within the directory within 2 working days.\r\n\r\nYou can see your event in DEFAULT_URL/members/"Manage Events" link.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Advertising Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(12, 'New Banner', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYou have just added one banner in our directory.\r\n\r\nWhat do I do next?\r\n\r\nPlease login to the directory at the link below and click on Make your Payment link on the left menu options to pay for your banner.\r\nDEFAULT_URL/members\r\n\r\nOnce this has been completed a directory administrator will review your banner and set it live within the directory.\r\n\r\nSubmissions are reviewed within 2 working days following payment.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Advertising Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(13, 'New Classified', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYou have just added one classified in our directory.\r\n\r\nWhat do I do next?\r\n\r\nPlease login to the directory at the link below and click on Make your Payment link on the left menu options to pay for your classified.\r\nDEFAULT_URL/members\r\n\r\nOnce this has been completed a directory administrator will review your classified and set it live within the directory.\r\n\r\nSubmissions are reviewed within 2 working days following payment.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Advertising Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(14, 'New Article', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYou have just added one article in our directory.\r\n\r\nWhat do I do next?\r\n\r\nPlease login to the directory at the link below and click on Make your Payment link on the left menu options to pay for your article.\r\nDEFAULT_URL/members\r\n\r\nOnce this has been completed a directory administrator will review your article and set it live within the directory.\r\n\r\nSubmissions are reviewed within 2 working days following payment.\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Advertising Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(15, 'Custom Invoice', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Invoice', 'text/plain', 'Hello ACCOUNT_NAME,\r\n\r\nYour invoice is ready for payment at the following link:\r\n\r\nDEFAULT_URL/members/billing/index.php\r\n\r\nAmount Due: CUSTOM_INVOICE_AMOUNT CUSTOM_INVOICE_TAX\r\n\r\nEDIRECTORY_TITLE\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,CUSTOM_INVOICE_AMOUNT,CUSTOM_INVOICE_TAX'),
(16, 'Active Listing', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Activation Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour listing is live and active on EDIRECTORY_TITLE\r\n\r\nLISTING_DEFAULT_URL/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,LISTING_DEFAULT_URL'),
(17, 'Active Event', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Activation Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour event is live and active on EDIRECTORY_TITLE\r\n\r\nEVENT_DEFAULT_URL/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,EVENT_DEFAULT_URL '),
(18, 'Active Banner', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Activation Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour banner is live and active on EDIRECTORY_TITLE\r\n\r\nDEFAULT_URL/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(19, 'Active Classified', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Activation Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour classified is live and active on EDIRECTORY_TITLE\r\n\r\nCLASSIFIED_DEFAULT_URL/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,CLASSIFIED_DEFAULT_URL'),
(20, 'Active Article', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Activation Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour article is live and active on EDIRECTORY_TITLE\r\n\r\nARTICLE_DEFAULT_URL/\r\n\r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team\r\n', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE,ARTICLE_DEFAULT_URL'),
(21, 'Email to Friend', 0, '0', '0000-00-00 00:00:00', '', 'Here''s information on ITEM_TITLE from EDIRECTORY_TITLE', 'text/plain', 'Hello, I found this item in EDIRECTORY_TITLE and I think it would be great for you.\r\n\r\nYou can view it at ITEM_URL\r\n', 'EDIRECTORY_TITLE,ITEM_TITLE,ITEM_URL'),
(22, 'Listing Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see:\r\nYour account in DEFAULT_URL/members/ "Manage Account" link.\r\nAnd\r\nYour item in DEFAULT_URL/members/ "Manage Listings" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(23, 'Event Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see:\r\nYour account in DEFAULT_URL/members/ "Manage Account" link.\r\nAnd\r\nYour item in DEFAULT_URL/members/ "Manage Events" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(24, 'Banner Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see:\r\nYour account in DEFAULT_URL/members/ "Manage Account" link.\r\nAnd\r\nYour item in DEFAULT_URL/members/ "Manage Banners" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(25, 'Classified Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see:\r\nYour account in DEFAULT_URL/members/ "Manage Account" link.\r\nAnd\r\nYour item in DEFAULT_URL/members/ "Manage Classifieds" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(26, 'Article Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see:\r\nYour account in DEFAULT_URL/members/ "Manage Account" link.\r\nAnd\r\nYour item in DEFAULT_URL/members/ "Manage Articles" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(27, 'Claimer Signup', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Claimer Signup Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for signing up for an account in EDIRECTORY_TITLE (DEFAULT_URL).\r\nLogin to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nYou can see your account in DEFAULT_URL/members/ "Manage Account" link.', 'ACCOUNT_NAME,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(28, 'Claim Automatically Approved', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Claim Approved Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nYour claim to the item "LISTING_TITLE" was "automatically approved".\r\nYou can see it in DEFAULT_URL/members/ "Manage Listings" link.', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(29, 'Claim Approved', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Claim Approved Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nYour claim to the item "LISTING_TITLE" was "approved" by site manager.\r\nYou can see your item in DEFAULT_URL/members/ "Manage Listings" link.', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(30, 'Claim Denied', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Claim Denied Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\nYour claim to the item "LISTING_TITLE" from DEFAULT_URL was "denied" by site manager.', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(31, 'Approve Reply', 0, '0', '0000-00-00 00:00:00', '', '[EDIRECTORY_TITLE] Reply Approved Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour reply was approved by site manager.\r\nYou can see it in DEFAULT_URL/members/ \r\n  \r\nThank you for being a member of the EDIRECTORY_TITLE! \r\n  \r\nRegards \r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(32, 'Approve Review', 0, '0', '0000-00-00 00:00:00', '', '[EDIRECTORY_TITLE] Review Approved Notification', 'text/plain', 'Dear ACCOUNT_NAME, \r\n  \r\nYour item has a new review approved by site manager.\r\nYou can see it in DEFAULT_URL/members/ \r\n  \r\nRegards \r\nEDIRECTORY_TITLE Team ', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(33, 'New Review', 0, '0', '0000-00-00 00:00:00', '', '[EDIRECTORY_TITLE] New Review Notification', 'text/plain', 'Dear ACCOUNT_NAME, \r\n  \r\nYour item on EDIRECTORY_TITLE has a new review. \r\nYou can see it in DEFAULT_URL/members/\r\n  \r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards \r\n EDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(34, 'Invoice Notification', 0, '0', '0000-00-00 00:00:00', NULL, '[EDIRECTORY_TITLE] Invoice Notification', 'text/plain', 'Dear ACCOUNT_NAME, \r\n\r\nYou can see your invoice in DEFAULT_URL \r\n\r\nRegards \r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(35, 'Visitor Account Create', 0, '0', '0000-00-00 00:00:00', '', 'EDIRECTORY_TITLE Profile', 'text/plain', 'Dear ACCOUNT_NAME,\r\nThank you for create your profile in EDIRECTORY_TITLE (DEFAULT_URL).\r\nClick on the link below to activate your account.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nAfter that, you can login to manage your account with the information below.\r\n\r\nACCOUNT_LOGIN_INFORMATION\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,LINK_ACTIVATE_ACCOUNT,ACCOUNT_LOGIN_INFORMATION,DEFAULT_URL,EDIRECTORY_TITLE'),
(36, 'Sponsor Stats & Engagement E-mail', 0, '0', '0000-00-00 00:00:00', NULL, 'Activity for your listing on EDIRECTORY_TITLE', 'text/plain', 'Dear \r\n\r\nACCOUNT_NAME,\r\n\r\nHere is the activity for LISTING_TITLE for the last 30 days:\r\n\r\n[TABLE_STATS]\r\n\r\nUpdate your listing and get more visibility by signing in here:\r\n\r\nDEFAULT_URL/members/\r\n\r\nRegards,\r\nThe EDIRECTORY_TITLE Team\r\n\r\nTo stop receiving this email please login and change your email settings, or send an email to \r\n\r\nSITEMGR_EMAIL', 'ACCOUNT_NAME,LISTING_TITLE,TABLE_STATS,DEFAULT_URL,EDIRECTORY_TITLE,SITEMGR_EMAIL'),
(37, 'Deal Redeemed (Owner)', 0, '0', '0000-00-00 00:00:00', NULL, '[EDIRECTORY_TITLE] Deal Redeemed Notification', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nYour deal on EDIRECTORY_TITLE was redeemed. \r\nYou can see it in DEFAULT_URL/members/\r\n  \r\nThank you for being a member of the EDIRECTORY_TITLE!\r\n\r\nRegards\r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,ACCOUNT_USERNAME,DEFAULT_URL,SITEMGR_EMAIL,EDIRECTORY_TITLE'),
(38, 'Deal Redeemed (Visitor)', 0, '0', '0000-00-00 00:00:00', NULL, '[EDIRECTORY_TITLE] Deal Redeemed', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nThank you for redeem a deal in EDIRECTORY_TITLE (DEFAULT_URL).\r\nYou can see it by logging in your visitor area.\r\n\r\nYour code: REDEEM_CODE\r\n\r\nRegards \r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,DEFAULT_URL,EDIRECTORY_TITLE,REDEEM_CODE'),
(39, 'Account Activation', 0, 0, '0000-00-00 00:00:00', NULL, '[EDIRECTORY_TITLE] Account Activation', 'text/plain', 'Dear ACCOUNT_NAME,\r\n\r\nTo activate your account, please click on the link below.\r\n\r\nLINK_ACTIVATE_ACCOUNT\r\n\r\nFor further assistance please contact SITEMGR_EMAIL.\r\n\r\nRegards\r\n\r\nEDIRECTORY_TITLE Team', 'ACCOUNT_NAME,LINK_ACTIVATE_ACCOUNT,SITEMGR_EMAIL,EDIRECTORY_TITLE');