-- 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_flagged` -- DROP TABLE IF EXISTS `reminders_flagged`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `reminders_flagged` ( `id` int(11) NOT NULL AUTO_INCREMENT, `subject` varchar(255) NOT NULL, `content` text NOT NULL, `escort_type` enum('independent','agency','employed') NOT NULL DEFAULT 'independent', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `reminders_flagged` -- LOCK TABLES `reminders_flagged` WRITE; /*!40000 ALTER TABLE `reminders_flagged` DISABLE KEYS */; INSERT INTO `reminders_flagged` VALUES (2,'Your website lacks info. Wrap it up to get free advertising','

\r\n

Hello,

\r\n

Your EscortBook account was chosen by our partner escort directories to get FREE advertising! At the moment your website is flagged as incomplete by our support team, but don’t worry, there are just a few things you need to make sure are in order and you’ll get your free advertising!

\r\n

1. Make sure that no info is missing from you site, like the “About us” text and that you have selected a Design that matches your style.

\r\n

2. Check out the Escorts you’ve added, to be certain that their profiles are complete.

\r\n

3. See if your “About Us” text is relevant, easy to read, clear and SEO friendly.

\r\n

4. Check if your contact details (email address and phone number) are correct.

\r\n

After checking all the points above, ask for a reconsideration from our support team by clicking on this link. It will be moderated as soon as possible and you will get your free advertising promised!

\r\n

**Log into your EscortBook account HERE

\r\n

Regards,

\r\n

Katie Miller

','agency'),(11,'Your EscortBook website gets you free advertising','

Hi,

\r\n

We have free advertising to offer to our best sites and you might be one of the lucky ones!

\r\n

All you need to do is make sure that your website is complete. At the moment, we have a red flag concerning this aspect and that means that your website either lacks information on some of its pages, or you have poor quality photos, incorrect info or no info at all at you contact page, or that your description text lacks SEO value.

\r\n

Follow our suggestions, go through the existing info on your EscortBook website, make the necessary changes and/or add-ons and then ask our support team to review your website and give it the thumbs up.

\r\n

After doing so, you\'re all \"dressed up\" for success, ready to expand your business on one of the leading escort directories on the market.
Get the most of what we\'ve got to offer!

\r\n

\r\nGo to my account
\r\n

Regards,

\r\n

','independent'),(12,'No red flags for free advertising!','

No red flags for free advertising!

\r\n

Nothing is worse than a red flag when dating someone, right?

\r\n

Then why keep a red flag on your website and let it drag you down in your pursuit of top clients?!

\r\n

Your website is not 100% completed yet. This may be due to one of the reasons below:

\r\n

Some website pages are lacking info
You did not select a template for your website from Design section in Dashboard
You have no presentation and welcome text in About Me page
Poor quality photos

\r\n

Log in, go through your website, see what the problem is, fix it, and not only you\'ll have a top-class personal site, but you will also get our FREE advertising offer.

\r\nComplete your website »\r\n

Use our free advertising deal to get your name known and your services booked !

\r\n

Access our customer support at info@escortbook.com.

\r\n

Regards,

\r\n

','independent'),(13,'A complete website gets you free advertising','

Hi,

\r\n

Did you know that there\'s a red flag on your website, that stops you from getting free advertising on escort websites?

\r\n

This is how it goes: we have a free advertising offer to offer you, on our partner directories, with the only condition that you have a complete EscortBook website.

\r\n

Unfortunately, at the moment your website has a red flag concerning one of the aspects below:

\r\n

It doesn\'t have relevant content, or any content at all, on all its pages
The \"About Me\" description text is not SEO friendly, making it difficult for you to be found by potential clients
The Contact form lacks information, or it has incorrect data
Your photos are not at a good quality, making you look unprofessional.

\r\n

Review your website\'s content, taking it one step at a time, make sure you have the right content on every page, and then ask our support team to revise it once again.

\r\n

When that\'s done, the free advertising package on the escort directory is all yours.

\r\n

This is your chance. Take it!

\r\n

\r\nGo to my account
\r\n

Regards,

\r\n

','independent'),(14,'Step up your game with a complete website on Escortbook','

Hi,

\r\n

Did you know that your website is missing some important details?

\r\n

This is how it goes: we know that clients spend more time on a website and they tend to make bookings when they have as much info as they can get.

\r\n

Unfortunately, at the moment your website has a red flag concerning one of the aspects below:

\r\n

It doesn\'t have relevant content, or any content at all, on all its pages
The \"About Me\" description text is not SEO friendly, making it difficult for you to be found by potential clients
The Contact form lacks information, or it has incorrect data
Your photos are not at a good quality, making you look unprofessional.

\r\n

Review your website\'s content, taking it one step at a time, make sure you have the right content on every page, and then ask our support team to revise it once again.

\r\n

When that\'s done, we are sure you will enjoy compliments from your future clients.

\r\n

This is your chance. Take it!

\r\n

\r\nGo to my account
\r\n

Regards,

\r\n

','independent'); /*!40000 ALTER TABLE `reminders_flagged` 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-03 5:04:03