| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/www/cj79373/administrator/components/com_engage/sql/xml/ |
Upload File : |
<?xml version="1.0" encoding="UTF-8"?>
<!--~
~ @package AkeebaEngage
~ @copyright Copyright (c)2020-2022 Nicholas K. Dionysopoulos / Akeeba Ltd
~ @license GNU General Public License version 3, or later
-->
<schema>
<!-- Metadata -->
<meta>
<!-- Supported driver types -->
<drivers>
<driver>mysql</driver>
<driver>mysqli</driver>
<driver>pdomysql</driver>
</drivers>
</meta>
<!-- SQL commands to run on installation and update -->
<sql>
<!-- Comments table -->
<action table="#__engage_comments" canfail="0">
<condition type="missing" value="" />
<query><![CDATA[
CREATE TABLE `#__engage_comments` (
`engage_comment_id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT,
`parent_id` BIGINT(20) unsigned NULL,
`asset_id` int(10) unsigned NOT NULL,
`body` longtext NOT NULL,
`name` varchar(255) DEFAULT NULL,
`email` varchar(255) DEFAULT NULL,
`ip` varchar(64) DEFAULT NULL,
`user_agent` varchar(255) NOT NULL,
`enabled` tinyint(3) NOT NULL DEFAULT '0',
`created_on` datetime DEFAULT NULL,
`created_by` int(11) DEFAULT NULL,
`modified_on` datetime DEFAULT NULL,
`modified_by` int(11) DEFAULT NULL,
PRIMARY KEY (`engage_comment_id`),
KEY `#__engage_comments_asset` (`asset_id`),
KEY `#__engage_comments_created_on` (`created_on` DESC)
) DEFAULT COLLATE utf8_general_ci COMMENT='Content comments';
]]></query>
</action>
<!-- Email templates table -->
<action table="#__engage_emailtemplates" canfail="0">
<condition type="missing" value="" />
<query><![CDATA[
CREATE TABLE `#__engage_emailtemplates` (
`engage_emailtemplate_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`key` varchar(255) NOT NULL DEFAULT 'moderate',
`language` varchar(10) NOT NULL DEFAULT '*',
`subject` varchar(255) NOT NULL,
`template` text NOT NULL,
`enabled` TINYINT(3) NOT NULL DEFAULT 1,
`created_on` datetime NULL DEFAULT NULL,
`created_by` bigint(20) NOT NULL DEFAULT '0',
`modified_on` datetime NULL DEFAULT NULL,
`modified_by` bigint(20) NOT NULL DEFAULT '0',
PRIMARY KEY (`engage_emailtemplate_id`),
UNIQUE KEY `#__engage_emailtemplate_keylang` (`key`(100),`language`)
) DEFAULT COLLATE utf8_general_ci COMMENT='Email templates for comments';
]]></query>
</action>
<!-- Unsubscribed emails -->
<action table="#__engage_unsubscribe" canfail="0">
<condition type="missing" value="" />
<query><![CDATA[
CREATE TABLE `#__engage_unsubscribe` (
`asset_id` bigint(20) NOT NULL,
`email` varchar(255) NOT NULL,
PRIMARY KEY (`asset_id`,`email`)
) DEFAULT COLLATE utf8_general_ci COMMENT='Unsubscribed emails';
]]></query>
</action>
<action table="#__engage_emailtemplates" canfail="0">
<condition type="equals" value="0"><![CDATA[
SELECT COUNT(*) FROM `#__engage_emailtemplates` WHERE `engage_emailtemplate_id` = 1;
]]></condition>
<query><![CDATA[
INSERT INTO `#__engage_emailtemplates` (`engage_emailtemplate_id`, `key`, `language`, `subject`, `template`, `enabled`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES (1, 'manage', '*', 'A new comment on “[CONTENT_TITLE]” awaits your moderation', '<html lang="en">
<head>
<meta charset="UTF-8">
<title>A new comment on “[CONTENT_TITLE]” awaits your moderation</title>
<style type="text/css">
:root {
color-scheme: light dark;
}
/*Reset styles*/
body {
font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif;
font-size: 12pt;
margin: 0;
padding: 0;
color: black;
background: slategrey;
}
.engageemail-outer-wrapper {
background: slategrey;
}
.engageemail-outer-wrapper table {
width: 100%;
max-width: 960px;
margin: 0 auto;
}
.engageemail-wrapper {
width: 100%;
height: 100%;
padding: 1em;
}
.engageemail-container {
background-color: white;
color: black;
text-align: left;
box-shadow: black 0 0 8px;
}
.engageemail-sitename {
background-color: #efefef;
text-align: right;
padding: 1em 1em;
min-height: 40px;
}
.engageemail-sitename a {
color: black;
font-size: 16pt;
border: none;
text-decoration: none;
}
.engageemail-message {
padding: 0.5em 1em;
}
.engageemail-message a {
color: #38b5b8;
text-decoration: underline;
}
.engageemail-comment-header {
padding: 0.25em;
background-color: darkslategray;
color: white;
}
img.engageemail-comment-header-avatar {
float: left;
margin: 0 0.5em 0.5em 0;
}
span.engageemail-comment-name {
display: block;
font-weight: bold;
}
span.engageemail-comment-email {
display: block;
font-size: 90%;
}
span.engageemail-comment-ip,
span.engageemail-comment-date,
span.engageemail-comment-user-agent {
font-size: 90%;
color: lightgrey;
}
span.engageemail-comment-user-agent:before {
content: " • ";
}
.engageemail-comment {
margin: 0.5em 0;
border-left: 3px solid grey;
padding: 0 .5em;
overflow: scroll;
}
a.engageemail-button {
display: inline-block;
text-align: center;
padding: 0.25em 0.5em;
color: cornflowerblue;
box-sizing: border-box;
text-decoration: none;
font-size: 10pt;
}
a.engageemail-button:hover {
color: dodgerblue;
}
a.engageemail-button-success {
color: seagreen;
}
a.engageemail-button-success:hover {
color: darkseagreen;
}
a.engageemail-button-warning {
color: darkorange;
}
a.engageemail-button-warning:hover {
color: orange;
}
a.engageemail-button-danger {
color: red;
}
a.engageemail-button-danger:hover {
color: darkred;
}
.engageemail-legalinfo {
text-align: center;
width: 100%;
max-width: 960px;
color: lightgrey;
font-size: 9pt;
font-weight: normal;
background-color: rgba(0, 0, 0, 0.2);
margin: 2em auto;
padding: 0.5em 0;
}
.engageemail-legalinfo a {
color: white;
font-weight: bold;
text-decoration: underline;
border: none;
}
.engageemail-legalinfo p {
margin: 0.3em 1em 0;
}
@media (prefers-color-scheme: dark) {
body {
background: darkslategray;
}
.engageemail-outer-wrapper {
background-color: darkslategray;
}
.engageemail-container {
background-color: #383636;
color: lightgrey;
}
.engageemail-sitename {
background-color: #1f2f2f;
}
.engageemail-sitename a {
color: whitesmoke;
}
a.engageemail-button-danger:hover {
color: orangered;
}
}
</style>
</head>
<body>
<div class="engageemail-outer-wrapper">
<table>
<tr>
<td width="10%"></td>
<td>
<div class="engageemail-wrapper">
<div class="engageemail-container">
<!-- Logo Header -->
<div class="engageemail-sitename">
<a href="[SITEURL]" title="Visit [SITENAME]">
[SITENAME]
</a>
</div>
<!-- Message -->
<div class="engageemail-message">
<p>
Hello [RECIPIENT:NAME],
</p>
<p>
A new comment was filed on “<a href="[CONTENT_LINK]">[CONTENT_TITLE]</a>”. The comment is currently unpublished and awaits your moderation.
</p>
<p>
Please find the comment details below.
</p>
<!-- Comment -->
<div class="engageemail-comment-header">
<img src="[AVATAR_URL]" class="engageemail-comment-header-avatar">
<span class="engageemail-comment-name">
[NAME]
</span>
<span class="engageemail-comment-email">
[EMAIL]
</span>
<span class="engageemail-comment-ip">
From [IP]
</span>
<span class="engageemail-comment-date">
on [DATE_LOCAL]
</span>
<span class="engageemail-comment-user-agent">
User Agent: [USER_AGENT]
</span>
</div>
<div class="engageemail-comment">
[COMMENT_SANITIZED]
</div>
<div>
<a class="engageemail-button" href="[COMMENT_LINK]">
View Comment
</a>
<a class="engageemail-button engageemail-button-success" href="[PUBLISH_URL]">
Publish
</a>
<a class="engageemail-button engageemail-button-danger" href="[DELETE_URL]">
Delete
</a>
<a class="engageemail-button engageemail-button-warning" href="[POSSIBLESPAM_URL]">
Possible Spam
</a>
<a class="engageemail-button engageemail-button-danger" href="[SPAM_URL]">
Spam and Delete
</a>
</div>
</div>
</div>
<!-- Legal info -->
<div class="engageemail-legalinfo">
<p>
You are receiving this email because you are a comments manager for the content that was commented on.
</p>
<p>
You <em>cannot</em> unsubscribe from these emails because you are a comments manager.
</p>
<p>
Please do not reply to this email, it''s sent from an unmonitored email address.
</p>
</div>
</div>
</td>
<td width="10%"></td>
</tr>
</table>
</div>
</body>
</html>', 1, '2020-04-01 00:00:00', 0, '2020-04-01 00:00:00', 0);
]]></query>
<query><![CDATA[
INSERT INTO `#__engage_emailtemplates` (`engage_emailtemplate_id`, `key`, `language`, `subject`, `template`, `enabled`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES (2, 'spam', '*', 'A new spam comment on “[CONTENT_TITLE]” awaits your moderation', '<html lang="en">
<head>
<meta charset="UTF-8">
<title>A new spam comment on “[CONTENT_TITLE]” awaits your moderation</title>
<style type="text/css">
:root {
color-scheme: light dark;
}
/*Reset styles*/
body {
font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif;
font-size: 12pt;
margin: 0;
padding: 0;
color: black;
background: slategrey;
}
.engageemail-outer-wrapper {
background: slategrey;
}
.engageemail-outer-wrapper table {
width: 100%;
max-width: 960px;
margin: 0 auto;
}
.engageemail-wrapper {
width: 100%;
height: 100%;
padding: 1em;
}
.engageemail-container {
background-color: white;
color: black;
text-align: left;
box-shadow: black 0 0 8px;
}
.engageemail-sitename {
background-color: #efefef;
text-align: right;
padding: 1em 1em;
min-height: 40px;
}
.engageemail-sitename a {
color: black;
font-size: 16pt;
border: none;
text-decoration: none;
}
.engageemail-message {
padding: 0.5em 1em;
}
.engageemail-message a {
color: #38b5b8;
text-decoration: underline;
}
.engageemail-comment-header {
padding: 0.25em;
background-color: darkslategray;
color: white;
}
img.engageemail-comment-header-avatar {
float: left;
margin: 0 0.5em 0.5em 0;
}
span.engageemail-comment-name {
display: block;
font-weight: bold;
}
span.engageemail-comment-email {
display: block;
font-size: 90%;
}
span.engageemail-comment-ip,
span.engageemail-comment-date,
span.engageemail-comment-user-agent {
font-size: 90%;
color: lightgrey;
}
span.engageemail-comment-user-agent:before {
content: " • ";
}
.engageemail-comment {
margin: 0.5em 0;
border-left: 3px solid grey;
padding: 0 .5em;
overflow: scroll;
}
a.engageemail-button {
display: inline-block;
text-align: center;
padding: 0.25em 0.5em;
color: cornflowerblue;
box-sizing: border-box;
text-decoration: none;
font-size: 10pt;
}
a.engageemail-button:hover {
color: dodgerblue;
}
a.engageemail-button-success {
color: seagreen;
}
a.engageemail-button-success:hover {
color: darkseagreen;
}
a.engageemail-button-warning {
color: darkorange;
}
a.engageemail-button-warning:hover {
color: orange;
}
a.engageemail-button-danger {
color: red;
}
a.engageemail-button-danger:hover {
color: darkred;
}
.engageemail-legalinfo {
text-align: center;
width: 100%;
max-width: 960px;
color: lightgrey;
font-size: 9pt;
font-weight: normal;
background-color: rgba(0, 0, 0, 0.2);
margin: 2em auto;
padding: 0.5em 0;
}
.engageemail-legalinfo a {
color: white;
font-weight: bold;
text-decoration: underline;
border: none;
}
.engageemail-legalinfo p {
margin: 0.3em 1em 0;
}
@media (prefers-color-scheme: dark) {
body {
background: darkslategray;
}
.engageemail-outer-wrapper {
background-color: darkslategray;
}
.engageemail-container {
background-color: #383636;
color: lightgrey;
}
.engageemail-sitename {
background-color: #1f2f2f;
}
.engageemail-sitename a {
color: whitesmoke;
}
a.engageemail-button-danger:hover {
color: orangered;
}
}
</style>
</head>
<body>
<div class="engageemail-outer-wrapper">
<table>
<tr>
<td width="10%"></td>
<td>
<div class="engageemail-wrapper">
<div class="engageemail-container">
<!-- Logo Header -->
<div class="engageemail-sitename">
<a href="[SITEURL]" title="Visit [SITENAME]">
[SITENAME]
</a>
</div>
<!-- Message -->
<div class="engageemail-message">
<p>
Hello [RECIPIENT:NAME],
</p>
<p>
A new comment was filed on “<a href="[CONTENT_LINK]">[CONTENT_TITLE]</a>”. The comment is currently marked as spam.
</p>
<p>
Please find the comment details below.
</p>
<!-- Comment -->
<div class="engageemail-comment-header">
<img src="[AVATAR_URL]" class="engageemail-comment-header-avatar">
<span class="engageemail-comment-name">
[NAME]
</span>
<span class="engageemail-comment-email">
[EMAIL]
</span>
<span class="engageemail-comment-ip">
From [IP]
</span>
<span class="engageemail-comment-date">
on [DATE_LOCAL]
</span>
<span class="engageemail-comment-user-agent">
User Agent: [USER_AGENT]
</span>
</div>
<div class="engageemail-comment">
[COMMENT_SANITIZED]
</div>
<div>
<a class="engageemail-button" href="[COMMENT_LINK]">
View Comment
</a>
<a class="engageemail-button engageemail-button-success" href="[PUBLISH_URL]">
Publish
</a>
<a class="engageemail-button engageemail-button-danger" href="[DELETE_URL]">
Delete
</a>
<a class="engageemail-button engageemail-button-danger" href="[SPAM_URL]">
Spam and Delete
</a>
<a class="engageemail-button engageemail-button-success" href="[UNSPAM_URL]">
Not spam and Publish
</a>
</div>
</div>
</div>
<!-- Legal info -->
<div class="engageemail-legalinfo">
<p>
You are receiving this email because you are a comments manager for the content that was commented on.
</p>
<p>
You <em>cannot</em> unsubscribe from these emails because you are a comments manager.
</p>
<p>
Please do not reply to this email, it''s sent from an unmonitored email address.
</p>
</div>
</div>
</td>
<td width="10%"></td>
</tr>
</table>
</div>
</body>
</html>', 1, '2020-04-01 00:00:00', 0, '2020-04-01 00:00:00', 0);
]]></query>
<query><![CDATA[
INSERT INTO `#__engage_emailtemplates` (`engage_emailtemplate_id`, `key`, `language`, `subject`, `template`, `enabled`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES (3, 'notify', '*', 'New reply to your comment on “[CONTENT_TITLE]”', '<html lang="en">
<head>
<meta charset="UTF-8">
<title>New reply to your comment on “[CONTENT_TITLE]”</title>
<style type="text/css">
:root {
color-scheme: light dark;
}
/*Reset styles*/
body {
font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif;
font-size: 12pt;
margin: 0;
padding: 0;
color: black;
background: slategrey;
}
.engageemail-outer-wrapper {
background: slategrey;
}
.engageemail-outer-wrapper table {
width: 100%;
max-width: 960px;
margin: 0 auto;
}
.engageemail-wrapper {
width: 100%;
height: 100%;
padding: 1em;
}
.engageemail-container {
background-color: white;
color: black;
text-align: left;
box-shadow: black 0 0 8px;
}
.engageemail-sitename {
background-color: #efefef;
text-align: right;
padding: 1em 1em;
min-height: 40px;
}
.engageemail-sitename a {
color: black;
font-size: 16pt;
border: none;
text-decoration: none;
}
.engageemail-message {
padding: 0.5em 1em;
}
.engageemail-message a {
color: #38b5b8;
text-decoration: underline;
}
.engageemail-comment-header {
padding: 0.25em;
background-color: darkslategray;
color: white;
}
img.engageemail-comment-header-avatar {
float: left;
margin: 0 0.5em 0.5em 0;
}
span.engageemail-comment-name {
display: block;
font-weight: bold;
}
span.engageemail-comment-email {
display: block;
font-size: 90%;
}
span.engageemail-comment-ip,
span.engageemail-comment-date,
span.engageemail-comment-user-agent {
font-size: 90%;
color: lightgrey;
}
span.engageemail-comment-user-agent:before {
content: " • ";
}
.engageemail-comment {
margin: 0.5em 0;
border-left: 3px solid grey;
padding: 0 .5em;
overflow: scroll;
}
a.engageemail-button {
display: inline-block;
text-align: center;
padding: 0.25em 0.5em;
color: cornflowerblue;
box-sizing: border-box;
text-decoration: none;
font-size: 10pt;
}
a.engageemail-button:hover {
color: dodgerblue;
}
a.engageemail-button-success {
color: seagreen;
}
a.engageemail-button-success:hover {
color: darkseagreen;
}
a.engageemail-button-warning {
color: darkorange;
}
a.engageemail-button-warning:hover {
color: orange;
}
a.engageemail-button-danger {
color: red;
}
a.engageemail-button-danger:hover {
color: darkred;
}
.engageemail-legalinfo {
text-align: center;
width: 100%;
max-width: 960px;
color: lightgrey;
font-size: 9pt;
font-weight: normal;
background-color: rgba(0, 0, 0, 0.2);
margin: 2em auto;
padding: 0.5em 0;
}
.engageemail-legalinfo a {
color: white;
font-weight: bold;
text-decoration: underline;
border: none;
}
.engageemail-legalinfo p {
margin: 0.3em 1em 0;
}
@media (prefers-color-scheme: dark) {
body {
background: darkslategray;
}
.engageemail-outer-wrapper {
background-color: darkslategray;
}
.engageemail-container {
background-color: #383636;
color: lightgrey;
}
.engageemail-sitename {
background-color: #1f2f2f;
}
.engageemail-sitename a {
color: whitesmoke;
}
a.engageemail-button-danger:hover {
color: orangered;
}
}
</style>
</head>
<body>
<div class="engageemail-outer-wrapper">
<table>
<tr>
<td width="10%"></td>
<td>
<div class="engageemail-wrapper">
<div class="engageemail-container">
<!-- Logo Header -->
<div class="engageemail-sitename">
<a href="[SITEURL]" title="Visit [SITENAME]">
[SITENAME]
</a>
</div>
<!-- Message -->
<div class="engageemail-message">
<p>
Hello [RECIPIENT:NAME],
</p>
<p>
A reply was posted to your previous comment on “<a href="[CONTENT_LINK]">[CONTENT_TITLE]</a>”.
</p>
<p>
Please find the comment details below.
</p>
<!-- Comment -->
<div class="engageemail-comment-header">
<img src="[AVATAR_URL]" class="engageemail-comment-header-avatar">
<span class="engageemail-comment-name">
[NAME]
</span>
<span class="engageemail-comment-email">
[EMAIL]
</span>
<span class="engageemail-comment-ip">
From [IP]
</span>
<span class="engageemail-comment-date">
on [DATE_LOCAL]
</span>
<span class="engageemail-comment-user-agent">
User Agent: [USER_AGENT]
</span>
</div>
<div class="engageemail-comment">
[COMMENT_SANITIZED]
</div>
<div>
<a class="engageemail-button" href="[COMMENT_LINK]">
View Comment
</a>
</div>
</div>
</div>
<!-- Legal info -->
<div class="engageemail-legalinfo">
<p>
You are receiving this email because you commented on “[CONTENT_TITLE]”.
</p>
<p>
If you do not wish to receive these emails you can <a href="[UNSUBSCRIBE_URL]">unsubscribe</a>.
</p>
<p>
The Unsubscribe link only affects notifications for the content this comment was submitted on. It does not unsubscribe you from notifications for comments filed on any other content you may have already commented on our site. Submitting a new comment on that content will resubscribe you to the notifications.
</p>
<p>
Please do not reply to this email, it''s sent from an unmonitored email address.
</p>
</div>
</div>
</td>
<td width="10%"></td>
</tr>
</table>
</div>
</body>
</html>', 1, '2020-04-01 00:00:00', 0, '2020-04-01 00:00:00', 0);
]]></query>
<query><![CDATA[
INSERT INTO `#__engage_emailtemplates` (`engage_emailtemplate_id`, `key`, `language`, `subject`, `template`, `enabled`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES (4, 'notify_managers', '*', 'A new comment was submitted on “[CONTENT_TITLE]”', '<html lang="en">
<head>
<meta charset="UTF-8">
<title>A new comment was submitted on “[CONTENT_TITLE]”</title>
<style type="text/css">
:root {
color-scheme: light dark;
}
/*Reset styles*/
body {
font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif;
font-size: 12pt;
margin: 0;
padding: 0;
color: black;
background: slategrey;
}
.engageemail-outer-wrapper {
background: slategrey;
}
.engageemail-outer-wrapper table {
width: 100%;
max-width: 960px;
margin: 0 auto;
}
.engageemail-wrapper {
width: 100%;
height: 100%;
padding: 1em;
}
.engageemail-container {
background-color: white;
color: black;
text-align: left;
box-shadow: black 0 0 8px;
}
.engageemail-sitename {
background-color: #efefef;
text-align: right;
padding: 1em 1em;
min-height: 40px;
}
.engageemail-sitename a {
color: black;
font-size: 16pt;
border: none;
text-decoration: none;
}
.engageemail-message {
padding: 0.5em 1em;
}
.engageemail-message a {
color: #38b5b8;
text-decoration: underline;
}
.engageemail-comment-header {
padding: 0.25em;
background-color: darkslategray;
color: white;
}
img.engageemail-comment-header-avatar {
float: left;
margin: 0 0.5em 0.5em 0;
}
span.engageemail-comment-name {
display: block;
font-weight: bold;
}
span.engageemail-comment-email {
display: block;
font-size: 90%;
}
span.engageemail-comment-ip,
span.engageemail-comment-date,
span.engageemail-comment-user-agent {
font-size: 90%;
color: lightgrey;
}
span.engageemail-comment-user-agent:before {
content: " • ";
}
.engageemail-comment {
margin: 0.5em 0;
border-left: 3px solid grey;
padding: 0 .5em;
overflow: scroll;
}
a.engageemail-button {
display: inline-block;
text-align: center;
padding: 0.25em 0.5em;
color: cornflowerblue;
box-sizing: border-box;
text-decoration: none;
font-size: 10pt;
}
a.engageemail-button:hover {
color: dodgerblue;
}
a.engageemail-button-success {
color: seagreen;
}
a.engageemail-button-success:hover {
color: darkseagreen;
}
a.engageemail-button-warning {
color: darkorange;
}
a.engageemail-button-warning:hover {
color: orange;
}
a.engageemail-button-danger {
color: red;
}
a.engageemail-button-danger:hover {
color: darkred;
}
.engageemail-legalinfo {
text-align: center;
width: 100%;
max-width: 960px;
color: lightgrey;
font-size: 9pt;
font-weight: normal;
background-color: rgba(0, 0, 0, 0.2);
margin: 2em auto;
padding: 0.5em 0;
}
.engageemail-legalinfo a {
color: white;
font-weight: bold;
text-decoration: underline;
border: none;
}
.engageemail-legalinfo p {
margin: 0.3em 1em 0;
}
@media (prefers-color-scheme: dark) {
body {
background: darkslategray;
}
.engageemail-outer-wrapper {
background-color: darkslategray;
}
.engageemail-container {
background-color: #383636;
color: lightgrey;
}
.engageemail-sitename {
background-color: #1f2f2f;
}
.engageemail-sitename a {
color: whitesmoke;
}
a.engageemail-button-danger:hover {
color: orangered;
}
}
</style>
</head>
<body>
<div class="engageemail-outer-wrapper">
<table>
<tr>
<td width="10%"></td>
<td>
<div class="engageemail-wrapper">
<div class="engageemail-container">
<!-- Logo Header -->
<div class="engageemail-sitename">
<a href="[SITEURL]" title="Visit [SITENAME]">
[SITENAME]
</a>
</div>
<!-- Message -->
<div class="engageemail-message">
<p>
Hello [RECIPIENT:NAME],
</p>
<p>
A new comment was filed on “<a href="[CONTENT_LINK]">[CONTENT_TITLE]</a>”. The comment is already published.
</p>
<p>
Please find the comment details below.
</p>
<!-- Comment -->
<div class="engageemail-comment-header">
<img src="[AVATAR_URL]" class="engageemail-comment-header-avatar">
<span class="engageemail-comment-name">
[NAME]
</span>
<span class="engageemail-comment-email">
[EMAIL]
</span>
<span class="engageemail-comment-ip">
From [IP]
</span>
<span class="engageemail-comment-date">
on [DATE_LOCAL]
</span>
<span class="engageemail-comment-user-agent">
User Agent: [USER_AGENT]
</span>
</div>
<div class="engageemail-comment">
[COMMENT_SANITIZED]
</div>
<div>
<a class="engageemail-button" href="[COMMENT_LINK]">
View Comment
</a>
<a class="engageemail-button engageemail-button-warning" href="[UNPUBLISH_URL]">
Unpublish
</a>
<a class="engageemail-button engageemail-button-danger" href="[DELETE_URL]">
Delete
</a>
<a class="engageemail-button engageemail-button-warning" href="[POSSIBLESPAM_URL]">
Possible Spam
</a>
<a class="engageemail-button engageemail-button-danger" href="[SPAM_URL]">
Spam and Delete
</a>
</div>
</div>
</div>
<!-- Legal info -->
<div class="engageemail-legalinfo">
<p>
You are receiving this email because you are a comments administrator for the content that was commented on.
</p>
<p>
If you do not wish to receive these emails for this content you can <a href="[UNSUBSCRIBE_URL]">unsubscribe</a>.
</p>
<p>
The Unsubscribe link only affects notifications for the content this comment was submitted on. It does not unsubscribe you from notifications for comments filed on any other content you may have already commented on our site. Submitting a new comment on that content will resubscribe you to the notifications.
</p>
<p>
Please do not reply to this email, it''s sent from an unmonitored email address.
</p>
</div>
</div>
</td>
<td width="10%"></td>
</tr>
</table>
</div>
</body>
</html>', 1, '2020-04-01 00:00:00', 0, '2020-04-01 00:00:00', 0);
]]></query>
<query><![CDATA[
INSERT INTO `#__engage_emailtemplates` (`engage_emailtemplate_id`, `key`, `language`, `subject`, `template`, `enabled`, `created_on`, `created_by`, `modified_on`, `modified_by`) VALUES (5, 'notify_author', '*', 'A new comment was submitted on “[CONTENT_TITLE]”', '<html lang="en">
<head>
<meta charset="UTF-8">
<title>A new comment was submitted on “[CONTENT_TITLE]”</title>
<style type="text/css">
:root {
color-scheme: light dark;
}
/*Reset styles*/
body {
font-family: ''Helvetica Neue'', Helvetica, Arial, sans-serif;
font-size: 12pt;
margin: 0;
padding: 0;
color: black;
background: slategrey;
}
.engageemail-outer-wrapper {
background: slategrey;
}
.engageemail-outer-wrapper table {
width: 100%;
max-width: 960px;
margin: 0 auto;
}
.engageemail-wrapper {
width: 100%;
height: 100%;
padding: 1em;
}
.engageemail-container {
background-color: white;
color: black;
text-align: left;
box-shadow: black 0 0 8px;
}
.engageemail-sitename {
background-color: #efefef;
text-align: right;
padding: 1em 1em;
min-height: 40px;
}
.engageemail-sitename a {
color: black;
font-size: 16pt;
border: none;
text-decoration: none;
}
.engageemail-message {
padding: 0.5em 1em;
}
.engageemail-message a {
color: #38b5b8;
text-decoration: underline;
}
.engageemail-comment-header {
padding: 0.25em;
background-color: darkslategray;
color: white;
}
img.engageemail-comment-header-avatar {
float: left;
margin: 0 0.5em 0.5em 0;
}
span.engageemail-comment-name {
display: block;
font-weight: bold;
}
span.engageemail-comment-email {
display: block;
font-size: 90%;
}
span.engageemail-comment-ip,
span.engageemail-comment-date,
span.engageemail-comment-user-agent {
font-size: 90%;
color: lightgrey;
}
span.engageemail-comment-user-agent:before {
content: " • ";
}
.engageemail-comment {
margin: 0.5em 0;
border-left: 3px solid grey;
padding: 0 .5em;
overflow: scroll;
}
a.engageemail-button {
display: inline-block;
text-align: center;
padding: 0.25em 0.5em;
color: cornflowerblue;
box-sizing: border-box;
text-decoration: none;
font-size: 10pt;
}
a.engageemail-button:hover {
color: dodgerblue;
}
a.engageemail-button-success {
color: seagreen;
}
a.engageemail-button-success:hover {
color: darkseagreen;
}
a.engageemail-button-warning {
color: darkorange;
}
a.engageemail-button-warning:hover {
color: orange;
}
a.engageemail-button-danger {
color: red;
}
a.engageemail-button-danger:hover {
color: darkred;
}
.engageemail-legalinfo {
text-align: center;
width: 100%;
max-width: 960px;
color: lightgrey;
font-size: 9pt;
font-weight: normal;
background-color: rgba(0, 0, 0, 0.2);
margin: 2em auto;
padding: 0.5em 0;
}
.engageemail-legalinfo a {
color: white;
font-weight: bold;
text-decoration: underline;
border: none;
}
.engageemail-legalinfo p {
margin: 0.3em 1em 0;
}
@media (prefers-color-scheme: dark) {
body {
background: darkslategray;
}
.engageemail-outer-wrapper {
background-color: darkslategray;
}
.engageemail-container {
background-color: #383636;
color: lightgrey;
}
.engageemail-sitename {
background-color: #1f2f2f;
}
.engageemail-sitename a {
color: whitesmoke;
}
a.engageemail-button-danger:hover {
color: orangered;
}
}
</style>
</head>
<body>
<div class="engageemail-outer-wrapper">
<table>
<tr>
<td width="10%"></td>
<td>
<div class="engageemail-wrapper">
<div class="engageemail-container">
<!-- Logo Header -->
<div class="engageemail-sitename">
<a href="[SITEURL]" title="Visit [SITENAME]">
[SITENAME]
</a>
</div>
<!-- Message -->
<div class="engageemail-message">
<p>
Hello [RECIPIENT:NAME],
</p>
<p>
A new comment was filed on “<a href="[CONTENT_LINK]">[CONTENT_TITLE]</a>”. The comment is already published.
</p>
<p>
Please find the comment details below.
</p>
<!-- Comment -->
<div class="engageemail-comment-header">
<img src="[AVATAR_URL]" class="engageemail-comment-header-avatar">
<span class="engageemail-comment-name">
[NAME]
</span>
<span class="engageemail-comment-email">
[EMAIL]
</span>
<span class="engageemail-comment-ip">
From [IP]
</span>
<span class="engageemail-comment-date">
on [DATE_LOCAL]
</span>
<span class="engageemail-comment-user-agent">
User Agent: [USER_AGENT]
</span>
</div>
<div class="engageemail-comment">
[COMMENT_SANITIZED]
</div>
<div>
<a class="engageemail-button" href="[COMMENT_LINK]">
View Comment
</a>
</div>
</div>
</div>
<!-- Legal info -->
<div class="engageemail-legalinfo">
<p>
You are receiving this email because you are the author of the content that was commented on.
</p>
<p>
If you do not wish to receive these emails for this content you can <a href="[UNSUBSCRIBE_URL]">unsubscribe</a>.
</p>
<p>
The Unsubscribe link only affects notifications for the content this comment was submitted on. It does not unsubscribe you from notifications for comments filed on any other content you may have already commented on our site. Submitting a new comment on that content will resubscribe you to the notifications.
</p>
<p>
Please do not reply to this email, it''s sent from an unmonitored email address.
</p>
</div>
</div>
</td>
<td width="10%"></td>
</tr>
</table>
</div>
</body>
</html>', 1, '2020-04-01 00:00:00', 0, '2020-04-01 00:00:00', 0);
]]></query>
</action>
<!-- Replace zero datetime with nullable datetime -->
<action table="#__engage_emailtemplates" canfail="1">
<condition type="nullable" value="created_on" operator="not"/>
<query><![CDATA[
ALTER TABLE `#__engage_emailtemplates` MODIFY `created_on` DATETIME NULL DEFAULT NULL;
]]></query>
<query><![CDATA[
UPDATE `#__engage_emailtemplates` SET `created_on` = NULL WHERE `created_on` = '0000-00-00 00:00:00';
]]></query>
</action>
<action table="#__engage_emailtemplates" canfail="1">
<condition type="nullable" value="modified_on" operator="not"/>
<query><![CDATA[
ALTER TABLE `#__engage_emailtemplates` MODIFY `modified_on` DATETIME NULL DEFAULT NULL;
]]></query>
<query><![CDATA[
UPDATE `#__engage_emailtemplates` SET `modified_on` = NULL WHERE `modified_on` = '0000-00-00 00:00:00';
]]></query>
</action>
<!-- Convert sole UNIQUE constraints to PRIMARY KEYs -->
<action table="#__engage_unsubscribe" canfail="1">
<condition type="equals" value="0"><![CDATA[
SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`table_constraints`
WHERE TABLE_SCHEMA=(SELECT DATABASE())
AND table_name='#__engage_unsubscribe'
AND CONSTRAINT_TYPE='PRIMARY KEY'
]]></condition>
<query><![CDATA[
ALTER TABLE `#__engage_unsubscribe` DROP KEY `#__engage_unsubscribe_unique`;
]]></query>
<query><![CDATA[
ALTER TABLE `#__engage_unsubscribe` ADD PRIMARY KEY (`asset_id`,`email`);
]]></query>
</action>
<!-- Convert tables to InnoDB -->
<action table="#__engage_comments" canfail="1">
<condition type="equals" operator="not" value="1"><![CDATA[
SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE (`TABLE_NAME` = '#__engage_comments') AND (`TABLE_SCHEMA` = DATABASE()) AND (`ENGINE` = 'InnoDB');
]]></condition>
<query><![CDATA[
ALTER TABLE `#__engage_comments` ENGINE InnoDB;
]]></query>
</action>
<action table="#__engage_emailtemplates" canfail="1">
<condition type="equals" operator="not" value="1"><![CDATA[
SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE (`TABLE_NAME` = '#__engage_emailtemplates') AND (`TABLE_SCHEMA` = DATABASE()) AND (`ENGINE` = 'InnoDB');
]]></condition>
<query><![CDATA[
ALTER TABLE `#__engage_emailtemplates` ENGINE InnoDB;
]]></query>
</action>
<action table="#__engage_unsubscribe" canfail="1">
<condition type="equals" operator="not" value="1"><![CDATA[
SELECT COUNT(*) FROM `INFORMATION_SCHEMA`.`TABLES` WHERE (`TABLE_NAME` = '#__engage_unsubscribe') AND (`TABLE_SCHEMA` = DATABASE()) AND (`ENGINE` = 'InnoDB');
]]></condition>
<query><![CDATA[
ALTER TABLE `#__engage_unsubscribe` ENGINE InnoDB;
]]></query>
</action>
</sql>
</schema>