-- MySQL dump 10.13 Distrib 8.0.31, for Linux (x86_64) -- -- Host: escortbook.cktimfhsqqst.eu-west-1.rds.amazonaws.com Database: escortsite -- ------------------------------------------------------ -- Server version 5.5.5-10.6.18-MariaDB-log /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `reminders` -- DROP TABLE IF EXISTS `reminders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reminders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login_date_days` int(11) NOT NULL, `has_pics` varchar(200) NOT NULL, `pic_number` tinyint(4) NOT NULL, `has_members` varchar(10) NOT NULL, `has_submit_directories` varchar(10) NOT NULL, `has_video` varchar(10) NOT NULL, `has_account` tinyint(10) NOT NULL DEFAULT 1, `has_confirmed` varchar(10) NOT NULL, `custom_page_option_json` text NOT NULL, `unread_booking_date_days` int(11) NOT NULL, `visitors` int(11) NOT NULL DEFAULT 0, `num_unread_messages` int(11) NOT NULL DEFAULT 0, `subject` varchar(255) NOT NULL, `content` text NOT NULL, `periodicity` int(11) NOT NULL DEFAULT 1 COMMENT 'how often it will be sent the reminder', `importance` int(11) NOT NULL DEFAULT 100, `sent_date` date DEFAULT NULL, `newsletter_active` tinyint(1) NOT NULL, `escort_type` enum('independent','agency','employed') NOT NULL DEFAULT 'independent', `imported_from_eros` tinyint(1) NOT NULL, `custom_domain` tinyint(1) NOT NULL, `premium_user` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reminders` -- LOCK TABLES `reminders` WRITE; /*!40000 ALTER TABLE `reminders` DISABLE KEYS */; INSERT INTO `reminders` VALUES (4,0,'2',0,'','','',1,'','null',0,0,0,'##fullname## add some pics to your site','

Hello ##fullname##

\r\n

We noticed you signed up on EscortBook.com but you didn\'t upload any pictures yet... Sign in and complete your site to be qualified for free advertising from our partner directories.

\r\n

Regards,

\r\n

Katie Miller

',1,1,'2016-09-28',1,'independent',0,0,0),(5,30,'',0,'','','',1,'','null',0,0,0,'Revive your online presence','

Hi ##fullname##

\r\n

We haven\'t seen you here in more than a month and we\'re afraid you might be missing out on some of our latest features and service updates.

\r\n

We\'re all into personalized escort experiences, and this is how we believe your website should be: a true reflection of your character and professionalism. That\'s why we are constantly improving our services.

\r\n

Try logging in on a weekly basis and see for yourself what\'s new on EscortBook.

\r\n

You will find:

\r\n

Strong marketing tools, with tens of escort directories to post your ads on and attract more customers
Videos in your media gallery
New site templates every week, all with a smartphone friendly version.

\r\n

\r\nLogin
\r\n

See you soon,

\r\n

',1,13,'2022-08-18',1,'independent',0,0,0),(6,3,'',0,'1','2','',1,'','{\"Links\":\"1\"}',0,0,0,'##fullname## - start a marketing campaign','

\r\n

Hi ##fullname##

\r\n

We saw you made your website recently on EscortBook.com .. Congrats, it looks very nice.

\r\n

We want to help you promote your new site with few tips:

\r\n

1. Add your members to the newsletter list, send them weekly newsletters with your promotions / tours / your site updates etc. You can write the newsletters now and set them to be sent anytime

\r\n

2. Drive more traffic to your website: start submitting your site to directories , register on forums & present yourself with a small bio ( mentioning your EscortBook site too)

\r\n

3. Stay close to the site, we\'re going to post the \"Search Engine Optimization\" tips & tricks, over 12 years of SEO experience shared to you for free.

\r\n

Sign-in on EscortBook & start driving traffic now!

\r\n

Have a good day,

\r\n

EscortBook Team

',1,2,'2016-09-28',1,'independent',0,0,0),(9,0,'',0,'','','',1,'','{\"Rates\":\"2\"}',0,0,0,'##fullname## fill the rates page','

Hello ##fullname##

\r\n

We noticed you made an account on EscortBook.com but you didn\'t fill the \"Rates\" page.

\r\n

Once you sign in on Escortbook.com you can edit your incall and outcall rates anytime by clicking here

\r\n

Please let us know if you need any help.

\r\n

Regards,

\r\n

EscortBook Team

',1,3,'2016-09-28',1,'independent',0,0,0),(10,0,'',0,'','','',1,'','{\"Services\":\"2\"}',0,0,0,'##fullname## fill the services page','

Hello ##fullname##

\r\n

We noticed you made an account on EscortBook.com but you didn\'t fill the \"Services\" page.

\r\n

Once you sign in on Escortbook.com you can edit \'Services\' page anytime by accessing services page

\r\n

Please let us know if you need any help.

\r\n

Regards,

\r\n

Katie Miller

\r\n

EscortBook Team

',1,4,'2016-09-28',1,'independent',0,0,0),(13,0,'',0,'','','',1,'2','null',0,0,0,'##fullname## confirm your EscortBook account','

\r\n

Hello ##fullname##,

\r\n

We saw you registered on EscortBook recently but you didn\'t confirm your account.

\r\n

Please click here to activate instantly your account or enter this url: ##confirmation## in your browser.

\r\n

Regards,

\r\n

Katie Miller

\r\n

',1,5,'2022-08-18',1,'independent',0,0,0),(16,30,'1',0,'','','',1,'','null',0,0,0,'Keep them hooked','

Hi ##fullname##,

\r\n

It\'s a pity not to benefit from all that your website and the EscortBook platform has to offer, simply by not logging in on a regular basis. So, put your awesome website to work and start getting those bookings!

\r\n

Be PRESENT, stay ACTIVE and enjoy the PERKS of being an EscortBook escort.

\r\n

This is what you\'ve been missing out since your last log in that happened almost a month ago:

\r\n

We\'ve added new site designs so that you can find the one perfect for you.
We\'ve made all out templates smartphone friendly, so you can be found and seen on the go.
We\'ve come up with new sites to promote yourself on.
We\'ve written new BLOG articles to help you navigate the escort lifestyle.

\r\n

Use our resources in your advantage and outshine your competitors!

\r\n

Get in touch with our sales representative and see what you can do to benefit from all that we have to offer.

\r\n

See you on EscortBook

\r\nGo to my site
\r\n

Regards,

\r\n

',1,1,'2022-08-18',1,'independent',0,0,0),(21,30,'',0,'','','',1,'','null',0,0,0,'##fullname## we want you back :)','

Hello ##fullname##

\r\n

We noticed you didn\'t log on EscortBook.com in the past month, come back and check EscortBook\'s new features as we update the site constantly:

\r\n

- Powerful marketing tools : Escort directory submitter, forum & classified site list

\r\n

- Tens of new template designs ( smartphone friendly versions included too)

\r\n

- Videos in media gallery

\r\n

Have a good day,

\r\n

EscortBook Team

',1,1,'2022-08-18',1,'agency',0,0,0),(22,0,'',0,'','','',1,'2','null',0,0,0,'##fullname## confirm your EscortBook account','

\r\n Hello ##fullname##,

\r\n

\r\n We saw you registered on EscortBook recently but you didn't confirm your account.

\r\n

\r\n Please click here to activate instantly your account or enter this url: ##confirmation## in your browser.

\r\n

\r\n Regards,

\r\n

\r\n Katie Miller

\r\n

\r\n
\r\n
\r\n

',1,1,'2022-08-18',1,'agency',0,0,0),(23,30,'',0,'','','',1,'','null',0,0,0,'You\'re losing clients','

\r\n

Hello ##fullname##,

\r\n

It\'s been more than a month since you’ve last checked your website on EscortBook.com. During this period you’ve missed:

\r\n

-new design templates - one of them might be just perfect for you

\r\n

-new sites to promote yourself on

\r\n

-new tips on our BLOG, on how to be successful

\r\n

',1,1,'2022-08-18',1,'agency',0,0,0),(25,0,'',0,'','','',1,'','null',0,0,0,'New hosting for your old website. Check it out','

Dear ##fullname##

\r\n

This is the perfect time to restart your website activity, so don’t miss it! We offer you the possibility of activating your website on www.EscortBook.com, one of the best, FREE escort site generator on the market. This brings you the opportunity of reviving your older account and use it to attract new clientele and potential regulars.

\r\n

Escortbook.com brings you:

\r\n

an easy to use admin platform
your own domain
optimisation for search engines
an up to date traffic analysis

\r\n

For a more detailed introduction of Escortbook.com we invite you to use our customer support service!

\r\n

We hope we’ll have a great collaboration in the future!

\r\n

The EscortBook Team

',1,1,'2019-02-07',0,'independent',1,2,0),(26,0,'',0,'','','',1,'','null',0,0,0,'New home for your website - We bring new business your way','

Dear ##fullname##

\r\n

We are happy to announce an important upgrade of your account ! Your domain has migrated to EscortBook.com, a top of the line, FREE escort site generator that can offer you the complete marketing tools that your website needs to be more visible and to attract more clients.

\r\n

We are talking about a service that brings you:

\r\n

an easy to use admin platform
your own domain
optimisation for search engines
an up to date traffic analysis

\r\n

Please go and visit Escortbook.com and reset your password.

\r\n

For a more detailed introduction of Escortbook.com we invite you to use our customer support service!

\r\n

Thank you for choosing us, as your partners !

\r\n

The EscortBook Team

',1,1,'2019-02-07',0,'independent',1,1,0),(28,0,'',0,'','','',1,'','null',0,0,0,'Your premium subscription has expired','

Hello,

\r\n

Please note that your premium subscription has expired. You are now using the free version of your website.

\r\n

If you wish to unlock again premium features such as:

\r\n

\r\n
custom domain name
\r\n
\r\n
custom email address
\r\n
\r\n
newsletters
\r\n
\r\n
ads-free (no camplace tab, no free banners )
\r\n
\r\n
custom watermark ,
\r\n

\r\n

please make sure to upgrade as soon as possible.

\r\n

For any further questions, please open a ticket or contact our Support Team via email at info@escortbook.com

\r\n

Best regards

\r\n

Sophie

\r\n

Escortbook Team

',1,1,'2020-11-24',0,'independent',0,0,1),(29,0,'',0,'','','',1,'','null',0,0,0,'Your site\'s domain name will expire soon','

Hello,

\r\n

Please note that your personal domain ##custom_domain## will expire on ##expiration_date##

\r\n

If you wish to renew it, please upgrade to premium as soon as possible and send us a confirmation email at info@escortbook.com

\r\n

Regards,

\r\n

Sophie

\r\n

Escortbook Team

',1,1,NULL,0,'independent',0,1,0),(30,0,'',0,'','','',1,'','null',0,0,0,'Your site\'s domain name will expire in 72 hours','

Hello,

\r\n

Please note that your personal domain ##custom_domain## will expire in the next 72 hours.

\r\n

If you wish to renew it, please upgrade to premium before ##expiration_date## and send us a confirmation email at info@escortbook.com or contact us via ticket.

\r\n

Regards,

\r\n

Sophie

\r\n

Escortbook Team

',1,11,NULL,0,'independent',0,1,0),(31,0,'',0,'','','',1,'','null',0,0,0,'Your site\'s domain name has expired','

Hello,

\r\n

Please note that your personal domain ##custom_domain## has expired on ##expiration_date##

\r\n

Your website is now using an Escortbook subdomain and can be found at the following URL ##url_subdomain##

\r\n

For any questions, please contact us via email at info@escortbook.com or via ticket.

\r\n

Regards,

\r\n

Sophie

\r\n

Escortbook Team

',1,1,NULL,0,'independent',0,1,0); /*!40000 ALTER TABLE `reminders` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'escortsite' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2024-10-02 5:04:05