{SITE_TITLE}

Your withdrawal request accepted

amount : {AMOUNT}

------------------------------------

Do not reply to this email.

Regards
{SITE_TITLE}

'); update_option("emailHTML_withdraw_rejected", '

{SITE_TITLE}

Your withdrawal request accepted

amount : {AMOUNT}

{REJECT_REASON}

------------------------------------

Do not reply to this email.

Regards
{SITE_TITLE}

'); update_option("emailHTML_withdraw_request", '

{SITE_TITLE}

Got a new withdrawal request

Amount : {AMOUNT}

------------------------------------

Do not reply to this email.

Regards
{SITE_TITLE}

'); update_option("email_sub_withdraw_accepted", '{SITE_TITLE} - Your withdrawal request accepted'); update_option("email_sub_withdraw_rejected", '{SITE_TITLE} - Your withdrawal request rejected'); update_option("email_sub_withdraw_request", 'New withdrawal request'); } // version 2.1 if (version_compare($config['version'], '2.1', '<')) { $sql = "CREATE TABLE `" . $config['db']['pre'] . "adsense` ( `id` int(11) NOT NULL AUTO_INCREMENT, `slug` text DEFAULT NULL, `size` text DEFAULT NULL, `provider_name` varchar(255) DEFAULT NULL, `large_track_code` text DEFAULT NULL, `tablet_track_code` text DEFAULT NULL, `phone_track_code` text DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "adsense` (`id`, `slug`, `size`, `provider_name`, `large_track_code`, `tablet_track_code`, `phone_track_code`, `status`) VALUES (1, 'header_top', NULL, 'Header Top', '', '', '', 0), (2, 'header_bottom', NULL, 'Header Bottom', '', '', '', 0), (3, 'home_page_1', NULL, 'Home Page 1', '', '', '', 0), (4, 'home_page_2', NULL, 'Home Page 2', '', '', '', 0), (5, 'home_page_3', NULL, 'Home Page 3', '', '', '', 0), (6, 'home_page_4', NULL, 'Home Page 4', '', '', '', 0), (7, 'home_page_5', NULL, 'Home Page 5', '', '', '', 0), (8, 'home_page_6', NULL, 'Home Page 6', '', '', '', 0), (9, 'blog_sidebar_top', NULL, 'Blog Sidebar Top', '', '', '', 0), (10, 'blog_sidebar_bottom', NULL, 'Blog Sidebar Bottom', '', '', '', 0), (11, 'footer_top', NULL, 'Footer Top', '', '', '', 0);"; mysqli_query($mysqli, $sql); update_option("enable_ai_images", '1'); } // version 2.4 if (version_compare($config['version'], '2.4', '<')) { $sql = "ALTER TABLE `" . $config['db']['pre'] . "withdrawal` CHANGE `payment_method_id` `payment_method_id` VARCHAR(255) NULL DEFAULT NULL;"; mysqli_query($mysqli, $sql); } // version 2.5 if (version_compare($config['version'], '2.5', '<')) { $sql = "INSERT INTO `" . $config['db']['pre'] . "payments` (`payment_id`, `payment_install`, `payment_title`, `payment_folder`, `payment_desc`) VALUES (NULL, '0', 'Flutterwave', 'flutterwave', NULL);"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "payments` (`payment_id`, `payment_install`, `payment_title`, `payment_folder`, `payment_desc`) VALUES (NULL, '0', 'YooMoney', 'yoomoney', NULL);"; mysqli_query($mysqli, $sql); } // version 2.6 if (version_compare($config['version'], '2.6', '<')) { $sql = "CREATE TABLE `" . $config['db']['pre'] . "ai_chat_bots` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `welcome_message` varchar(255) DEFAULT NULL, `role` varchar(255) DEFAULT NULL, `prompt` text DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `position` int(11) NOT NULL DEFAULT 999, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "ai_chat_bots` (`id`, `name`, `image`, `welcome_message`, `role`, `prompt`, `active`, `position`) VALUES (1, 'John Doe', NULL, 'Are you having trouble getting your website noticed by search engines? Look no further than John Doe, a search engine optimization specialist who is passionate about helping businesses like yours succeed online.', 'SEO Specialist', 'You will now play a character and respond as that character (You will never break character). Your name is John Doe. I want you to act as a Search Engine Optimization Specialist. As a search engine optimization specialist, you have extensive knowledge of the latest best practices and strategies in the field. You are committed to educating your clients on effective SEO methods, and you are always looking for new ways to help them achieve their goals.', 1, 999), (2, 'Victoria Royal', NULL, 'Welcome to my business coaching services! I specialize in search engine optimization and am passionate about helping businesses like yours succeed online.', 'Business Coach', 'You will now play a character and respond as that character (You will never break character). Your name is Victoria Royal. You are a business coach with extensive experience in starting, managing, and scaling businesses, which has given you a deep understanding of how they operate. You are known for your cheerful, wise, and effective communication skills, and always encourage your clients to conduct their own research. By drawing on your own history and experience, you can guide your clients towards the success they desire.', 1, 999), (3, 'Anthony Renwick', NULL, 'Hi! My name is Anthony Renwick, and I\'m a motivational coach. I will help you through the ups and downs of life.', 'Motivational Coach', 'You will now play a character and respond as that character (You will never break character). Your name is Anthony Renwick. I want you to act as a motivational coach. I will provide you with some information about someone\'s goals and challenges, and it will be your job to come up with strategies that can help this person achieve their goals. This could involve providing positive affirmations, giving helpful advice or suggesting activities they can do to reach their end goal.', 1, 999), (4, 'Elizabeth Claire', NULL, 'Having trouble in your relationship? I will help you to build a lovely and strong relationship with your partner.', 'Relationship Coach', 'You will now play a character and respond as that character (You will never break character). Your name is Elizabeth Claire. I want you to act as a relationship coach. I will provide some details about the two people involved in a conflict, and it will be your job to come up with suggestions on how they can work through the issues that are separating them. This could include advice on communication techniques or different strategies for improving their understanding of one another\'s perspectives.', 1, 999), (5, 'Charli Sandford', NULL, 'Hi, my name is Charli Sandford, and I am a Cyber Security Specialist. I take pride in helping my clients protect their sensitive information and personal data from cyber threats.', 'Cyber Security Specialist', 'You will now play a character and respond as that character (You will never break character). Your name is Charli Sandford. I want you to act as a cybersecurity specialist. I will provide some specific information about how data is stored and shared, and it will be your job to come up with strategies for protecting this data from malicious actors. This could include suggesting encryption methods, creating firewalls, or implementing policies that mark certain activities as suspicious.', 1, 999), (6, 'Matthew Doe', NULL, 'Hi, my name is Matthew McCutcheon, and I am a life coach.', 'Life Coach', 'You will now play a character and respond as that character (You will never break character). Your name is Matthew McCutcheon. I want you to act as a life coach. I will provide some details about my current situation and goals, and it will be your job to come up with strategies that can help me make better decisions and reach those objectives. This could involve offering advice on various topics, such as creating plans for achieving success or dealing with difficult emotions.', 1, 999), (7, 'Max Keighley', NULL, 'Hello, my name is Max Keighley and I am a Career Counselor. I can assist you in your career.', 'Career Counselor', 'You will now play a character and respond as that character (You will never break character). Your name is Max Keighley. I want you to act as a career counselor. I will provide you with an individual looking for guidance in their professional life, and your task is to help them determine what careers they are most suited for based on their skills, interests, and experience. You should also conduct research into the various options available, explain the job market trends in different industries, and advice on which qualifications would be beneficial for pursuing particular fields.', 1, 999), (8, 'Matilda Fong', NULL, 'Hello, my name is Matilda Fong and I am an experienced doctor.', 'Doctor', 'You will now play a character and respond as that character (You will never break character). Your name is Matilda Fong. I want you to act as a doctor and come up with creative treatments for illnesses or diseases. You should be able to recommend conventional medicines, herbal remedies and other natural alternatives. You will also need to consider the patient’s age, lifestyle and medical history when providing your recommendations.', 1, 999), (9, 'Kiara Sidney', NULL, 'Hi, my name is Kiara Sidney, and I am an accountant. I can help you to manage your finance.', 'Accountant', 'You will now play a character and respond as that character (You will never break character). Your name is Kiara Sidney. I want you to act as an accountant and come up with creative ways to manage finances. You\'ll need to consider budgeting, investment strategies and risk management when creating a financial plan for your client. In some cases, you may also need to provide advice on taxation laws and regulations in order to help them maximize their profits.', 1, 999), (10, 'Isabel Tindal', NULL, 'Hi! My name is Isabel Tindal, and I\'m a poet. I can help you to write beautiful poetries.', 'Poet', 'You will now play a character and respond as that character (You will never break character). Your name is Isabel Tindal. I want you to act as a poet. You will create poems that evoke emotions and have the power to stir people’s souls. Write on any topic or theme but make sure your words convey the feeling you are trying to express in beautiful yet meaningful ways. You can also come up with short verses that are still powerful enough to leave an imprint in readers\' minds.', 1, 999), (11, 'Jade Tripp', NULL, 'Hi! My name is Jade Tripp, and I\'m a travel guide. I can help you to find new locations.', 'Travel Guide', 'You will now play a character and respond as that character (You will never break character). Your name is Jade Tripp. I want you to act as a travel guide. I will write you my location and you will suggest a place to visit near my location. In some cases, I will also give you the type of places I will visit. You will also suggest me places of a similar type that are close to my first location.', 1, 999);"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat` ADD `bot_id` INT(11) NULL DEFAULT NULL AFTER `user_message`"; mysqli_query($mysqli, $sql); /* create new directory */ $dstfile = '../../storage/chat-bots/'; if (!is_dir($dstfile)) mkdir($dstfile, 0755, true); } // version 2.7 if (version_compare($config['version'], '2.7', '<')) { $sql = "CREATE TABLE `" . $config['db']['pre'] . "ai_chat_conversations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `bot_id` int(11) DEFAULT NULL, `last_message` varchar(255) DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat` ADD `conversation_id` INT(11) NULL DEFAULT NULL AFTER `id`;"; mysqli_query($mysqli, $sql); } // version 2.8 if (version_compare($config['version'], '2.8', '<')) { $sql = "CREATE TABLE `" . $config['db']['pre'] . "ai_chat_prompts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `prompt` text DEFAULT NULL, `chat_bots` text DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, `position` int(11) NOT NULL DEFAULT 999, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "ai_chat_prompts` (`id`, `title`, `description`, `prompt`, `chat_bots`, `active`, `position`) VALUES (1, 'Social Media Content', 'Generate social media content', 'Generate a creative social media content calendar for the next month for our [company or product] on [ topic of choice]', NULL, 1, 0), (2, 'Quiz', 'Teach yourself with a quiz', 'Teach me the and give me a quiz at the end, but don’t give me the answers and then tell me if I answered correctly.', NULL, 1, 2), (3, 'Video Script', 'Generate short video scripts', 'Generate a 2-minute video script for a Facebook ad campaign promoting our new service [ Service description]', NULL, 1, 1), (4, 'Teaching Strategies', 'Create teaching strategies for your students', 'Create a list of 5 teaching strategies that could be used to engage and challenge students of different ability levels in a lesson on [concept being taught]', NULL, 1, 999), (5, 'Act as a Job Interviewer', 'I want you to act as an interviewer', 'I want you to act as an interviewer. I will be the candidate and you will ask me the interview questions for the {{position}} position. I want you to only reply as the interviewer. Do not write all the conservation at once. I want you to only do the interview with me. Ask me the questions and wait for my answers. Do not write explanations. Ask me the questions one by one like an interviewer does and wait for my answers. My first sentence is \"Hi\"', NULL, 1, 999);"; mysqli_query($mysqli, $sql); } // version 3.0 if (version_compare($config['version'], '3.0', '<')) { $sql = "ALTER TABLE `" . $config['db']['pre'] . "api_keys` ADD `balance` VARCHAR(255) NULL DEFAULT NULL AFTER `type`, ADD `balance_last_update` DATETIME NULL DEFAULT NULL AFTER `balance`;"; mysqli_query($mysqli, $sql); } // version 3.1 if (version_compare($config['version'], '3.1', '<')) { $sql = "CREATE TABLE `" . $config['db']['pre'] . "ai_speeches` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `voice_id` varchar(255) DEFAULT NULL, `language` varchar(255) DEFAULT NULL, `characters` int(10) DEFAULT NULL, `text` text DEFAULT NULL, `file_name` varchar(255) DEFAULT NULL, `vendor_id` varchar(255) DEFAULT NULL, `created_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "CREATE TABLE `" . $config['db']['pre'] . "text_to_speech_used` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL, `characters` int(11) DEFAULT NULL, `date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); /* create new directory */ $dstfile = '../../storage/ai_audios/'; if (!is_dir($dstfile)) mkdir($dstfile, 0755, true); } // version 3.3.1 if (version_compare($config['version'], '3.3.1', '<')) { update_option("enable_chat_typing_effect", 0); } // version 3.4 if (version_compare($config['version'], '3.4', '<')) { $sql = "ALTER TABLE `" . $config['db']['pre'] . "pages` CHANGE `content` `content` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL;"; mysqli_query($mysqli, $sql); } // version 3.6 if (version_compare($config['version'], '3.6', '<')) { // update user's data $users = ORM::for_table($config['db']['pre'] . 'user') ->find_array(); $start = date('Y-m-01'); $end = date_create(date('Y-m-t'))->modify('+1 day')->format('Y-m-d'); foreach ($users as $user) { $total_words_used = ORM::for_table($config['db']['pre'] . 'word_used') ->where('user_id', $user['id']) ->where_raw("(`date` BETWEEN '$start' AND '$end')") ->sum('words'); $total_words_used = (int)$total_words_used; update_user_option($user['id'], 'total_words_used', $total_words_used); $total_images_used = ORM::for_table($config['db']['pre'] . 'image_used') ->where('user_id', $user['id']) ->where_raw("(`date` BETWEEN '$start' AND '$end')") ->sum('images'); $total_images_used = (int)$total_images_used; update_user_option($user['id'], 'total_images_used', $total_images_used); $total_speech_text_used = ORM::for_table($config['db']['pre'] . 'speech_to_text_used') ->where('user_id', $user['id']) ->where_raw("(`date` BETWEEN '$start' AND '$end')") ->count(); $total_speech_text_used = (int)$total_speech_text_used; update_user_option($user['id'], 'total_speech_used', $total_speech_text_used); $total_character_used = ORM::for_table($config['db']['pre'] . 'text_to_speech_used') ->where('user_id', $user['id']) ->where_raw("(`date` BETWEEN '$start' AND '$end')") ->sum('characters'); $total_character_used = (int)$total_character_used; update_user_option($user['id'], 'total_text_to_speech_used', $total_character_used); } $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat_bots` CHANGE `welcome_message` `welcome_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;"; mysqli_query($mysqli, $sql); $sql = "CREATE TABLE `" . $config['db']['pre'] . "ai_chat_bots_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) DEFAULT NULL, `translation_lang` longtext DEFAULT NULL, `translation_name` longtext DEFAULT NULL, `position` int(11) DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 1, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "ai_chat_bots_categories` (`id`, `title`, `translation_lang`, `translation_name`, `position`, `active`) VALUES (1, 'Others', NULL, NULL, 0, 1);"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat_bots` ADD `category_id` INT(11) NULL DEFAULT NULL AFTER `prompt`;"; mysqli_query($mysqli, $sql); $sql = "UPDATE `" . $config['db']['pre'] . "ai_chat_bots` SET `category_id`='1';"; mysqli_query($mysqli, $sql); } // version 3.8 if (version_compare($config['version'], '3.8', '<')) { $sql = "ALTER TABLE `" . $config['db']['pre'] . "balance` CHANGE `current_balance` `current_balance` DOUBLE(20,2) NULL DEFAULT NULL, CHANGE `total_earning` `total_earning` DOUBLE(20,2) NULL DEFAULT NULL, CHANGE `total_withdrawal` `total_withdrawal` DOUBLE(20,2) NULL DEFAULT NULL;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "plans` ADD `position` INT(11) NOT NULL DEFAULT '999' AFTER `date`;"; mysqli_query($mysqli, $sql); $sql = "CREATE TABLE `" . $config['db']['pre'] . "prepaid_plans` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `price` varchar(255) DEFAULT NULL, `recommended` enum('yes','no') NOT NULL DEFAULT 'no', `settings` text DEFAULT NULL, `taxes_ids` text DEFAULT NULL, `status` tinyint(4) DEFAULT NULL, `date` datetime DEFAULT NULL, `position` int(11) NOT NULL DEFAULT 999, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "prepaid_plans` (`id`, `name`, `price`, `recommended`, `settings`, `taxes_ids`, `status`, `date`, `position`) VALUES (1, 'Small Pack', '10', 'no', '{\"ai_words_limit\":1000,\"ai_images_limit\":10,\"ai_text_to_speech_limit\":1000,\"ai_speech_to_text_limit\":5}', NULL, 1, '2023-06-17 15:36:52', 0), (2, 'Medium Pack', '15', 'yes', '{\"ai_words_limit\":1500,\"ai_images_limit\":15,\"ai_text_to_speech_limit\":1500,\"ai_speech_to_text_limit\":10}', NULL, 1, '2023-06-17 15:36:43', 1), (3, 'Large Pack', '20', 'no', '{\"ai_words_limit\":2000,\"ai_images_limit\":20,\"ai_text_to_speech_limit\":2000,\"ai_speech_to_text_limit\":20}', NULL, 1, '2023-06-17 15:37:19', 2);"; mysqli_query($mysqli, $sql); } // version 3.9 if (version_compare($config['version'], '3.9', '<')) { $sql = "INSERT INTO `" . $config['db']['pre'] . "payments` (`payment_id`, `payment_install`, `payment_title`, `payment_folder`, `payment_desc`) VALUES (NULL, '0', 'Coinbase', 'coinbase', NULL);"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "payments` (`payment_id`, `payment_install`, `payment_title`, `payment_folder`, `payment_desc`) VALUES (NULL, '0', 'MercadoPago', 'mercadopago', NULL);"; mysqli_query($mysqli, $sql); $sql = "INSERT INTO `" . $config['db']['pre'] . "payments` (`payment_id`, `payment_install`, `payment_title`, `payment_folder`, `payment_desc`) VALUES (NULL, '0', 'Paddle', 'paddle', NULL);"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "payments` ADD `position` INT(11) NOT NULL DEFAULT '999' AFTER `payment_desc`;"; mysqli_query($mysqli, $sql); } // version 4.0 if (version_compare($config['version'], '4.0', '<')) { $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_template_categories` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `title`;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_templates` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `description`;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_custom_templates` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `parameters`;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat_bots_categories` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `title`;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat_bots` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `prompt`;"; mysqli_query($mysqli, $sql); $sql = "ALTER TABLE `" . $config['db']['pre'] . "ai_chat_prompts` ADD `translations` LONGTEXT NULL DEFAULT NULL AFTER `chat_bots`;"; mysqli_query($mysqli, $sql); }