IP : 3.16.75.176Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
./
var/
softaculous/
dotcl/
../
vtiger72/
../
conc8/
../
lss/
../
commentics/
commentics.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */;
-- -- Table structure for table `[[dbprefix]]emails` --
CREATE TABLE `[[dbprefix]]emails` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `type` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `subject` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `text` text COLLATE utf8mb4_unicode_ci NOT NULL, `html` text COLLATE utf8mb4_unicode_ci NOT NULL, `language` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `date_modified` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=15 ;
-- -- Dumping data for table `[[dbprefix]]emails` --
INSERT INTO `[[dbprefix]]emails` VALUES (1, 'ban', '[username], there's a new ban!', 'Hello [username],\r\n\r\nA new user, with the IP address [ip address], has been banned for the following reason:\r\n- [reason]\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A new user, with the IP address [ip address], has been banned for the following reason:</td>\r\n</tr>\r\n<tr>\r\n<td>- [reason]</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (2, 'comment_approve', 'Comment Approve', 'Hello [username],\r\n\r\nA new comment has been posted on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nThis comment requires approval due to the following reason(s):\r\n[reason]\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A new comment has been posted on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">This comment requires approval due to the following reason(s):</td>\r\n</tr>\r\n<tr>\r\n<td>[reason]</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (3, 'comment_success', 'Comment Success', 'Hello [username],\r\n\r\nA new comment has been posted on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nThis comment does not require approval.\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A new comment has been posted on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">This comment does not require approval.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (4, 'flag', '[username], a comment is flagged!', 'Hello [username],\r\n\r\nA new comment has been flagged on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe flagged comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A new comment has been flagged on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The flagged comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (5, 'edit', '[username], a comment was edited!', 'Hello [username],\r\n\r\nA comment has been edited on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe edited comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A comment has been edited on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The edited comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (6, 'delete', '[username], a comment was deleted!', 'Hello [username],\r\n\r\nA comment has been deleted on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe deleted comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A comment has been deleted on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The deleted comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (7, 'new_version', 'New Version', 'Hello [username],\r\n\r\nA newer version of Commentics is available.\r\n\r\nYour installed version is [installed version]. The newest version is [newest version].\r\n\r\nPlease upgrade at your earliest convenience.\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A newer version of Commentics is available.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Your installed version is [installed version]. The newest version is [newest version].</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Please upgrade at your earliest convenience.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (8, 'password_reset', 'Password Reset', 'Hello [username],\r\n\r\nYour login details are listed below:\r\n\r\nUsername: [username]\r\nPassword: [password]\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Your login details are listed below:</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px"><b>Username:</b></td><td style="padding-top:15px; padding-left:5px">[username]</td>\r\n</tr>\r\n<tr>\r\n<td><b>Password:</b></td><td style="padding-left:5px">[password]</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (9, 'setup_test', 'Setup Test', 'Hello [username],\r\n\r\nThis is a test email generated by the ''Settings -> Email -> Setup'' page.\r\n\r\nIf you have received this email, you have the correct email settings.\r\n\r\nHere is the link to your admin panel:\r\n[admin link]\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [username],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">This is a test email generated by the ''Settings -> Email -> Setup'' page.</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:15px">If you have received this email, you have the correct email settings.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Here is the link to your admin panel:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[admin link]">[admin link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (10, 'subscriber_confirmation', 'Subscription Confirmation', 'Hello [name],\r\n\r\nYou have requested a subscription to the page [page reference], located at the following address:\r\n[page url]\r\n\r\nPlease confirm this subscription by clicking the link below:\r\n[confirmation link]\r\n\r\nIf you did not request this subscription, there is nothing that you need to do.\r\n\r\nYou will not receive anymore emails of this type.\r\n\r\nRegards,\r\n\r\n[signature]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [name],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">You have requested a subscription to the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[page url]">[page url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Please confirm this subscription by clicking the link below:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[confirmation link]">[confirmation link]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">If you did not request this subscription, there is nothing that you need to do.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">You will not receive anymore emails of this type.</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]', 'english', '[[regtime]]'), (11, 'subscriber_notification_admin', '[name], the Admin has posted!', 'Hello [name],\r\n\r\nThe admin has posted a comment on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nRegards,\r\n\r\n[signature]\r\n\r\nTo manage your subscription, click the link below:\r\n[user url]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [name],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The admin has posted a comment on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">To manage your subscription, click the link below:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[user url]">[user url]</a></td>\r\n</tr>\r\n</table>', 'english', '[[regtime]]'), (12, 'subscriber_notification_basic', '[name], there''s a new comment!', 'Hello [name],\r\n\r\nA new comment has been posted on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nRegards,\r\n\r\n[signature]\r\n\r\nTo manage your subscription, click the link below:\r\n[user url]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [name],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">A new comment has been posted on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">To manage your subscription, click the link below:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[user url]">[user url]</a></td>\r\n</tr>\r\n</table>', 'english', '[[regtime]]'), (13, 'subscriber_notification_reply', '[name], you have a reply!', 'Hello [name],\r\n\r\nYou have a reply on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment was made by [poster] and was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nRegards,\r\n\r\n[signature]\r\n\r\nTo manage your subscription, click the link below:\r\n[user url]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [name],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">You have a reply on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment was made by [poster] and was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">To manage your subscription, click the link below:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[user url]">[user url]</a></td>\r\n</tr>\r\n</table>', 'english', '[[regtime]]'), (14, 'user_comment_approved', '[name], your comment is approved!', 'Hello [name],\r\n\r\nYour comment is now approved on the page [page reference], located at the following address:\r\n[comment url]\r\n\r\nThe comment that you posted was as follows:\r\n\r\n************************\r\n\r\n[comment]\r\n\r\n************************\r\n\r\nRegards,\r\n\r\n[signature]\r\n\r\nTo manage your preferences, click the link below:\r\n[user url]', '<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td>Hello [name],</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Your comment is now approved on the page [page reference], located at the following address:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[comment url]">[comment url]</a></td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">The comment that you posted was as follows:</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:10px">[comment]</td>\r\n</tr>\r\n<tr>\r\n<td style="padding-top:20px">************************</td>\r\n</tr>\r\n</table>\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">Regards,</td>\r\n</tr>\r\n</table>\r\n\r\n[signature]\r\n\r\n<table style="border-collapse:collapse" border="0" cellpadding="0" cellspacing="0">\r\n<tr>\r\n<td style="padding-top:15px">To manage your preferences, click the link below:</td>\r\n</tr>\r\n<tr>\r\n<td><a href="[user url]">[user url]</a></td>\r\n</tr>\r\n</table>', 'english', '[[regtime]]');
-- -- Table structure for table `[[dbprefix]]questions` --
CREATE TABLE `[[dbprefix]]questions` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `question` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `answer` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `language` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `date_modified` datetime NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=21 ;
-- -- Dumping data for table `[[dbprefix]]questions` --
INSERT INTO `[[dbprefix]]questions` VALUES (1, 'Enter the third letter of the word castle.', 's', 'english', '[[regtime]]', '[[regtime]]'), (2, 'Enter the word shark backwards.', 'krahs', 'english', '[[regtime]]', '[[regtime]]'), (3, 'What is the opposite word of weak?', 'strong', 'english', '[[regtime]]', '[[regtime]]'), (4, 'Is it true or false that green is a number?', 'false', 'english', '[[regtime]]', '[[regtime]]'), (5, 'How many letters are in the word two?', '3|three', 'english', '[[regtime]]', '[[regtime]]'), (6, 'Which is darker: black or white?', 'black', 'english', '[[regtime]]', '[[regtime]]'), (7, 'Enter the last letter of the word satellite.', 'e', 'english', '[[regtime]]', '[[regtime]]'), (8, 'What is the opposite word of small?', 'big', 'english', '[[regtime]]', '[[regtime]]'), (9, 'Out of 56, 14 or 27, which is the smallest?', '14|fourteen', 'english', '[[regtime]]', '[[regtime]]'), (10, 'Enter the word hand backwards.', 'dnah', 'english', '[[regtime]]', '[[regtime]]'), (11, 'Type the numbers for four hundred seventy-two.', '472', 'english', '[[regtime]]', '[[regtime]]'), (12, 'Enter the fifth word of this sentence.', 'of', 'english', '[[regtime]]', '[[regtime]]'), (13, 'Enter the third word of this sentence.', 'third', 'english', '[[regtime]]', '[[regtime]]'), (14, 'What is the sum of 1 + 2 + 3?', '6|six', 'english', '[[regtime]]', '[[regtime]]'), (15, 'Enter the word table backwards.', 'elbat', 'english', '[[regtime]]', '[[regtime]]'), (16, 'What is the day after Friday?', 'saturday', 'english', '[[regtime]]', '[[regtime]]'), (17, 'Is ice cream hot or cold?', 'cold', 'english', '[[regtime]]', '[[regtime]]'), (18, 'What is the next number: 10, 12, 14, ..?', '16|sixteen', 'english', '[[regtime]]', '[[regtime]]'), (19, 'What is the fifth month of the year?', 'may', 'english', '[[regtime]]', '[[regtime]]'), (20, 'Type the word for the number 9.', 'nine', 'english', '[[regtime]]', '[[regtime]]');
-- -- Table structure for table `[[dbprefix]]voters` --
CREATE TABLE `[[dbprefix]]voters` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `comment_id` int(10) unsigned NOT NULL DEFAULT '0', `ip_address` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `date_added` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;