-- Adminer 4.8.1 MySQL 5.7.44 dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `announcements`;
CREATE TABLE `announcements` (
  `announcement_id` int(11) NOT NULL AUTO_INCREMENT,
  `announcement_area` varchar(255) DEFAULT NULL,
  `announcement_content` mediumtext,
  PRIMARY KEY (`announcement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `apis`;
CREATE TABLE `apis` (
  `api_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_url` varchar(255) DEFAULT NULL,
  `api_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`api_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `api_report`;
CREATE TABLE `api_report` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_service_id` int(11) DEFAULT NULL,
  `report_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `report_detail` text,
  `report_extra` text,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `auto_orders`;
CREATE TABLE `auto_orders` (
  `auto_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `last_post` varchar(255) DEFAULT NULL,
  `auto_date` varchar(11) DEFAULT NULL,
  `auto_link` varchar(400) DEFAULT NULL,
  `auto_quantity` int(11) DEFAULT NULL,
  `auto_limit` int(11) DEFAULT NULL,
  `auto_completed` int(11) DEFAULT '0',
  `auto_expiration` text,
  `auto_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`auto_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `auto_report`;
CREATE TABLE `auto_report` (
  `report_id` int(11) NOT NULL AUTO_INCREMENT,
  `report_service_id` int(11) DEFAULT NULL,
  `report_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `report_detail` text,
  PRIMARY KEY (`report_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `bank_accounts`;
CREATE TABLE `bank_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_title` varchar(120) DEFAULT NULL,
  `account_name` text,
  `account_iban` text,
  `account_number` varchar(120) DEFAULT NULL,
  `account_branch` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `bank_deposits`;
CREATE TABLE `bank_deposits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` int(11) DEFAULT NULL,
  `bank` int(11) DEFAULT NULL,
  `amount` double DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `blog`;
CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `blog_title` text,
  `blog_url` text,
  `blog_seotitle` text,
  `blog_seodesc` text,
  `blog_seokeyw` text,
  `blog_content` text,
  `blog_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_number` int(11) DEFAULT '9999',
  `category_icon` varchar(255) NOT NULL,
  `category_icon_color` varchar(50) NOT NULL,
  `category_name` text,
  `category_status` int(11) DEFAULT '1',
  PRIMARY KEY (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `categories` (`category_id`, `category_number`, `category_icon`, `category_icon_color`, `category_name`, `category_status`) VALUES
(1,	9999,	'fab fa-facebook',	'#2759FF',	'[{\"lang\":1,\"name\":\"Facebook\"}]',	1);

DROP TABLE IF EXISTS `child_panels`;
CREATE TABLE `child_panels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `panel_domain` text,
  `panel_currency` text,
  `panel_status` varchar(255) DEFAULT 'Pending',
  `panel_price` text,
  `panel_created` datetime DEFAULT NULL,
  `panel_detail` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `crons`;
CREATE TABLE `crons` (
  `cron_id` int(11) NOT NULL AUTO_INCREMENT,
  `cron_name` varchar(50) NOT NULL,
  `cron_operation` varchar(200) NOT NULL,
  `cron_updefault` int(11) NOT NULL DEFAULT '1',
  `cron_endup` int(11) NOT NULL,
  `cron_date_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `cron_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cron_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `crons` (`cron_id`, `cron_name`, `cron_operation`, `cron_updefault`, `cron_endup`, `cron_date_update`, `cron_status`) VALUES
(1,	'Auto Processes',	'Otomatik Sipariş Kontrolü',	15,	15,	'2021-05-31 20:24:07',	1),
(2,	'Drip Processes',	'Dripfeed Kontrolü',	30,	30,	'2021-05-31 20:23:04',	1),
(3,	'Order Processes',	'Sipariş Kontrolü\r\n',	1,	1,	'2021-06-01 00:46:08',	1),
(4,	'Provider Processes',	'API Sağlayıcı Kontrolü',	30,	30,	'2021-05-31 20:23:06',	1),
(5,	'Service Processes',	'Servis Otomasyonu',	30,	30,	'2021-05-31 20:23:06',	1),
(6,	'Refill Processes',	'İade Kontrolü',	10,	10,	'2021-05-31 20:36:16',	1),
(7,	'De Checker',	'Dolar-Euro Kontrolü\r\n',	180,	180,	'2021-05-31 17:49:08',	1),
(8,	'Proxy Checker',	'Proxy Kontrolü\r\n',	60,	60,	'2021-06-01 00:45:02',	1),
(9,	'Log Api Report Del',	'Sağlayıcı Logları Silme\r\n',	1440,	1440,	'2021-05-31 20:40:02',	1),
(10,	'Log Auto Report Del',	'Otomasyon Logları Silme',	1440,	1440,	'2021-05-31 20:40:32',	1),
(11,	'Log Cron Report Del',	'Cron Logları Silme',	1440,	1440,	'2021-05-31 20:31:04',	1);

DROP TABLE IF EXISTS `crons_report`;
CREATE TABLE `crons_report` (
  `crons_id` int(11) NOT NULL AUTO_INCREMENT,
  `crons_service_name` varchar(255) NOT NULL,
  `crons_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `crons_detail` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`crons_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `deposits`;
CREATE TABLE `deposits` (
  `deposit_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `order_id` text,
  `deposit_date` varchar(120) DEFAULT NULL,
  `deposit_extras` text,
  `deposit_method` int(11) DEFAULT NULL,
  `deposit_amount` double DEFAULT NULL,
  `deposit_status` tinyint(1) DEFAULT '2',
  `eskib` double DEFAULT NULL,
  `yenib` double DEFAULT NULL,
  PRIMARY KEY (`deposit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `drip_orders`;
CREATE TABLE `drip_orders` (
  `drip_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `drip_link` varchar(255) DEFAULT NULL,
  `drip_amount` double DEFAULT NULL,
  `drip_quantity` int(11) DEFAULT NULL,
  `drip_completed` int(11) DEFAULT '1',
  `drip_last_action` varchar(20) DEFAULT NULL,
  `drip_runs` int(11) DEFAULT NULL,
  `drip_interval` int(11) DEFAULT NULL,
  `drip_status` tinyint(1) DEFAULT '1',
  `drip_return` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`drip_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `duyuru`;
CREATE TABLE `duyuru` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `duyuru_title` text,
  `duyuru_icon` varchar(255) NOT NULL,
  `duyuru_daire_color` varchar(50) NOT NULL,
  `duyuru_icon_color` varchar(50) NOT NULL,
  `duyuru_content` text,
  `duyuru_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `integrations`;
CREATE TABLE `integrations` (
  `app_id` int(11) NOT NULL AUTO_INCREMENT,
  `app_title` varchar(120) DEFAULT NULL,
  `app_image` text,
  `app_desc` varchar(220) DEFAULT NULL,
  `app_detail` text,
  `app_data` text,
  `app_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `integrations` (`app_id`, `app_title`, `app_image`, `app_desc`, `app_detail`, `app_data`, `app_status`) VALUES
(1,	'Google reCAPTCHA v2',	'/mp-public/recaptcha.png',	'reCAPTCHA ağ sayfalarının güvenliği için otomatik tanınması zor yazıların insan emeğiyle bilgisayar ortamında taranıp sayısallaştırılmasını sağlayan bir uygulamadır.',	'{\"inputs\":{\"1\":{\"title\":\"Site Key\",\"type\":\"text\",\"name\":\"site_key\"},\"2\":{\"title\":\"Secret Key\",\"type\":\"text\",\"name\":\"secret_key\"},\"3\":{\"title\":\"Giri\\u015f Sayfas\\u0131 Do\\u011frulama\",\"type\":\"select\",\"name\":\"login_page\",\"options\":{\"1\":{\"title\":\"Pasif\",\"value\":0},\"2\":{\"title\":\"Aktif\",\"value\":1}}},\"4\":{\"title\":\"Kay\\u0131t Sayfas\\u0131 Do\\u011frulama\",\"type\":\"select\",\"name\":\"register_page\",\"options\":{\"1\":{\"title\":\"Pasif\",\"value\":0},\"2\":{\"title\":\"Aktif\",\"value\":1}}}}}',	'{\"site_key\":\"\",\"secret_key\":\"\",\"login_page\":\"0\",\"register_page\":\"0\"}',	0),
(2,	'Discord WebHook',	'/mp-public/discord.png',	'Discord’un sahip olduğu Webhook özelliği sayesinde sohbet kanallarına otomatik olarak site hakkında bildirim alabilirsin.',	'{\"inputs\":{\"1\":{\"title\":\"\\u00dcye Aksiyon Bildirimleri\",\"type\":\"text\",\"name\":\"discord_notify_url\"},\"2\":{\"title\":\"API Bildirimleri\",\"type\":\"text\",\"name\":\"discord_apiNotify_url\"}}}',	'{\"discord_notify_url\":\"\",\"discord_apiNotify_url\":\"\"}',	0),
(3,	'NetGSM - SMS',	'/mp-public/netgsm.png',	'Entegrasyon sayesinde kullanıcılara NetGSM API üzerinden toplu sms veya normal sms gönderebilirsiniz.',	'{\"inputs\":{\"1\":{\"title\":\"Kullan\\u0131c\\u0131 Ad\\u0131\",\"type\":\"text\",\"name\":\"username\"},\"2\":{\"title\":\"Parola\",\"type\":\"password\",\"name\":\"password\"},\"3\":{\"title\":\"SMS Ba\\u015fl\\u0131k\",\"type\":\"text\",\"name\":\"sms_title\"}}}',	'{\"username\":\"\",\"password\":\"\",\"sms_title\":\"\"}',	0),
(4,	'İletiMerkezi - SMS',	'/mp-public/iletimerkezi.png',	'Entegrasyon sayesinde kullanıcılara İletiMerkezi API üzerinden toplu sms veya normal sms gönderebilirsiniz.',	'{\"inputs\":{\"1\":{\"title\":\"Kullan\\u0131c\\u0131 Ad\\u0131\",\"type\":\"text\",\"name\":\"username\"},\"2\":{\"title\":\"Parola\",\"type\":\"password\",\"name\":\"password\"},\"3\":{\"title\":\"SMS Ba\\u015fl\\u0131k\",\"type\":\"text\",\"name\":\"sms_title\"}}}',	'{\"username\":\"\",\"password\":\"\",\"sms_title\":\"\"}',	0),
(5,	'BizimSMS - SMS',	'/mp-public/bizimsms.png',	'BizimSMS entegrasyonu sayesinde müşterilerinize toplu sms veya normal sms seçenekleriyle moonpanel üzerinden sms gönderebilirsiniz.',	'{\"inputs\":{\"1\":{\"title\":\"Kullan\\u0131c\\u0131 Ad\\u0131\",\"type\":\"text\",\"name\":\"username\"},\"2\":{\"title\":\"Parola\",\"type\":\"password\",\"name\":\"password\"},\"3\":{\"title\":\"SMS Ba\\u015fl\\u0131k\",\"type\":\"text\",\"name\":\"sms_title\"}}}',	'{\"username\":\"\",\"password\":\"\",\"sms_title\":\"\"}',	0),
(6,	'Beamer',	'/mp-public/getbeamer.png',	'Yeni özellikleri, en son güncellemeleri, önemli haberleri ve daha fazlasını kullanıma hazır bildirim merkezi ve hizmet olarak değişiklik günlüğü aracıyla duyurun.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"<script>alert(\\\"beamer\\\");<\\/script>\",\"visibility\":\"0\"}',	0),
(7,	'Google Analytics',	'/mp-public/googleanalytics.png',	'Google Analytics sitenizin geniş anlamda trafik ölçümü yapabilmenize ve bu trafikleri belli zamanlar ile karşılaştırmanıza yarayan ücretsiz bir Google servisidir.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(8,	'Google Tag Manager',	'/mp-public/googletagmanager.png',	'Google Tag Manager, ziyaretçi hareketlerini izleyip seçiminize bağlı olan kullanıcı davranışlarının gerçekleşip gerçekleşmediğini tespit etmenizi sağlayan bir kod grubudur.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(9,	'OneSignal',	'/mp-public/onesignal.png',	'Onesignal web tarayıcısı üzerinden sitenizi ziyaret eden kullanıcılara, istediğiniz zaman tarayıcı üzerinden bildirim göndermenize yarayan bir uygulamadır.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(10,	'Getsitecontrol',	'/mp-public/getsitecontrol.png',	'Kişiselleştirilmiş formlar, popuplar kullanıp kullanıcılara dokunabileceğiniz ve lead toplayabileceğiniz bir araç.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(11,	'Jivochat',	'/mp-public/jivochat.png',	'Jivochat, müşteriler ve işletmeler arasında iletişim sağlayan bir uygulamadır.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(12,	'Smartsupp',	'/mp-public/smartsupp.png',	'Smartsupp, müşteriler ve işletmeler arasında iletişim sağlayan bir uygulamadır.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(13,	'Push Alert',	'/mp-public/pushalert.png',	'Kullanılan tarayıcıların üzerinde küçük, popup biçiminde pencerelerin açılması ve kullanıcıların yeni içerik ve haberlerden haberdar olmasını sağlayan bir bildirim sistemidir.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(14,	'Tawk.to',	'/mp-public/tawkto.png',	'Tawk.to, web sitenizdeki veya ücretsiz özelleştirilebilir bir sayfadaki ziyaretçileri izlemenizi ve onlarla sohbet etmenizi sağlayan ücretsiz bir canlı sohbet uygulamasıdır.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"2\"}',	0),
(15,	'Tidio',	'/mp-public/tidio.png',	'Müşterilerinizle anında bağlantı kurun. Müşteri memnuniyeti, satışları artırmak, potansiyel müşteriler oluşturmak ve çok daha fazlası için sohbet robotlarıyla güçlendirilmiş, kullanımı kolay canlı sohbet!',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(16,	'Zendesk Chat',	'/mp-public/zendeskchat.png',	'Müşterilerle iletişimde olduğunuz kanalları tek bir noktadan yönetilmesini sağlayan bir müşteri destek uygulamasıdır.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(17,	'Getbutton.io',	'/mp-public/getbutton.png',	'\\\"Bize Mesaj Gönderin\\\" düğmesi, web sitesi ziyaretçilerini doğrudan masaüstü veya mobil cihazlardaki mesajlaşma uygulamasına götürür. Ziyaretçiler web sitenizden ayrılsa bile daha fazla sohbet edin ve sohbete devam edin',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0),
(18,	'Crisp Chat',	'/mp-public/crispchat.png',	'Şirketleri ve müşterileri birbirine bağlayan hepsi bir arada çok kanallı mesajlaşma platformu.',	'{\"inputs\":{\"1\":{\"title\":\"Kod Alan\\u0131\",\"type\":\"textarea\",\"name\":\"code\"},\"2\":{\"title\":\"G\\u00f6r\\u00fcn\\u00fcrl\\u00fck\",\"type\":\"select\",\"name\":\"visibility\",\"options\":{\"1\":{\"title\":\"T\\u00fcm Sayfalar\",\"value\":0},\"2\":{\"title\":\"Sadece Giri\\u015f Yapanlar\",\"value\":1},\"3\":{\"title\":\"Giri\\u015f Yapmayanlar\",\"value\":2}}}}}',	'{\"code\":\"\",\"visibility\":\"0\"}',	0);

DROP TABLE IF EXISTS `langs`;
CREATE TABLE `langs` (
  `lang_id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_name` varchar(50) DEFAULT NULL,
  `lang_code` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`lang_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `langs` (`lang_id`, `lang_name`, `lang_code`) VALUES
(1,	'Türkçe',	'TR'),
(2,	'English',	'EN');

DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus` (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT,
  `menu_type` int(11) DEFAULT NULL,
  `menu_lock` int(11) DEFAULT '0',
  `menu_link` text,
  `menu_title` text,
  `menu_line` int(11) DEFAULT '999',
  `menu_icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `menus` (`menu_id`, `menu_type`, `menu_lock`, `menu_link`, `menu_title`, `menu_line`, `menu_icon`) VALUES
(4,	1,	0,	'../',	'Yeni Sipariş',	2,	'fas fa-bolt'),
(7,	1,	0,	'auto',	'Otomatik Sipariş',	3,	'fas fa-atom'),
(8,	1,	0,	'orders',	'Siparişler',	4,	'fas fa-archive'),
(11,	1,	0,	'tickets',	'Destek',	9,	'fas fa-ticket-alt'),
(12,	1,	0,	'reference',	'Referans',	10,	'fas fa-users'),
(13,	1,	0,	'/api',	'API',	12,	'fas fa-link'),
(18,	1,	0,	'drips',	'Süreli Siparişler',	6,	'fas fa-archive'),
(19,	1,	0,	'autos',	'Abonelikler',	7,	'fas fa-archive'),
(20,	1,	0,	'rentpanel',	'Panel Kirala',	11,	'fas fa-lira-sign'),
(24,	2,	0,	'services',	'Fiyat Listesi',	1,	'fas fa-list'),
(25,	1,	0,	'services',	'Fiyat Listesi',	5,	'fas fa-list'),
(30,	1,	0,	'add-funds',	'Bakiye Ekle',	8,	'fas fa-lira-sign'),
(37,	2,	0,	'login',	'Giriş Yap',	2,	'fa fa-user'),
(39,	2,	0,	'register',	'Kayıt Ol',	3,	'fa fa-user-plus');

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `api_id` int(11) DEFAULT NULL,
  `api_order_id` int(11) DEFAULT NULL,
  `api_order_amount` double DEFAULT NULL,
  `api_order_currency` varchar(10) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `order_type` tinyint(4) DEFAULT '0',
  `order_date` varchar(11) DEFAULT NULL,
  `update_date` varchar(120) DEFAULT '0',
  `order_link` varchar(300) DEFAULT NULL,
  `order_quantity` int(11) DEFAULT NULL,
  `order_amount` double DEFAULT NULL,
  `order_start_count` int(11) DEFAULT '0',
  `order_remains` int(11) DEFAULT '0',
  `order_status` varchar(100) DEFAULT 'Pending',
  `order_return` tinyint(1) DEFAULT '0',
  `order_detail` text,
  `order_comments` text,
  `is_failed` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `pages`;
CREATE TABLE `pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `page_title` text,
  `page_content` text,
  `page_url` text,
  `page_seo` text,
  `page_visibility` int(11) DEFAULT '1',
  `page_lock` int(11) DEFAULT '1',
  `page_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `pages` (`id`, `page_title`, `page_content`, `page_url`, `page_seo`, `page_visibility`, `page_lock`, `page_date`) VALUES
(1,	'Servisler',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	'',	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2021-05-22 23:05:34'),
(2,	'Kullanici Sozlesmesi',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42'),
(3,	'Yeni Siparis',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	'',	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2021-05-22 04:05:41'),
(4,	'Bakiye Yukle',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42'),
(5,	'Sikca Sorulan Sorular',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42'),
(6,	'Blog',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42'),
(7,	'Destek',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42'),
(8,	'Giris Yap',	'&lt;p&gt;&lt;strong&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.&lt;/strong&gt;&lt;/p&gt;',	NULL,	'{\"title\":\"\",\"desc\":\"\",\"keyw\":\"\"}',	1,	1,	'2020-10-20 03:10:42');

DROP TABLE IF EXISTS `payment_bonus`;
CREATE TABLE `payment_bonus` (
  `bonus_id` int(11) NOT NULL AUTO_INCREMENT,
  `bonus_method` int(11) DEFAULT NULL,
  `bonus_from` double DEFAULT NULL,
  `bonus_amount` double DEFAULT NULL,
  `bonus_type` int(11) DEFAULT '2',
  PRIMARY KEY (`bonus_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `payment_methods`;
CREATE TABLE `payment_methods` (
  `method_id` int(11) NOT NULL AUTO_INCREMENT,
  `method_title` varchar(255) DEFAULT NULL,
  `method_details` text,
  `method_line` int(11) DEFAULT NULL,
  PRIMARY KEY (`method_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `payment_methods` (`method_id`, `method_title`, `method_details`, `method_line`) VALUES
(1,	'PayTR Kredi Karti',	'{\"name\":\"3D G\\u00fcvenli \\u00d6deme\",\"status\":\"0\",\"mid\":\"\",\"key\":\"\",\"salt\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	1),
(3,	'Paywant Kredi Karti',	'{\"name\":\"Paywant \",\"status\":\"0\",\"key\":\"\",\"secret\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	4),
(4,	'Shopier',	'{\"name\":\"Shopier \",\"status\":\"0\",\"key\":\"\",\"secret\":\"\",\"callbackurl\":\"1\",\"fee\":\"0\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	3),
(5,	'Shoplemo',	'{\"name\":\"Shoplemo\",\"status\":\"0\",\"key\":\"\",\"secret\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	5),
(6,	'PayTR Havale&EFT',	'{\"name\":\"paytr havale\",\"status\":\"0\",\"mid\":\"\",\"key\":\"\",\"salt\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	2),
(7,	'Banka Havale&EFT',	'{\"name\":\"Havale\\/Eft\",\"status\":\"1\",\"min\":\"1\",\"max\":\"10000\"}',	6),
(8,	'Papara',	'{\"name\":\"Papara ile \\u00d6deme\",\"status\":\"0\",\"number\":\"\",\"prefix\":\"\",\"imap_server\":\"\",\"imap_user\":\"\",\"imap_password\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	7),
(99,	'Payhesap',	'{\"name\":\"Payhesap\",\"status\":\"0\",\"key\":\"\",\"comission\":\"\",\"min\":\"\",\"max\":\"\"}',	8);

DROP TABLE IF EXISTS `plugins`;
CREATE TABLE `plugins` (
  `plugin_id` int(11) NOT NULL AUTO_INCREMENT,
  `plugin_title` text,
  `plugin_desc` text,
  `plugin_data` text,
  `plugin_status` int(11) DEFAULT '1',
  PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `plugins` (`plugin_id`, `plugin_title`, `plugin_desc`, `plugin_data`, `plugin_status`) VALUES
(1,	'Ucretsiz Bakiye',	'Sitenize yeni kayıt olan kullanıcılara tek seferlik bakiye hediye edin.',	'{\"gift_amount\":\"0\"}',	0),
(2,	'MoonGuard',	'Sitenizi olası DDoS saldırılarından koruyun. (%100 Güvenlik Sağlamaz, beta aşamasındadır.)',	'',	0),
(3,	'Referans Sistemi',	'Kayıtlı kullanıcılar, yeni davet ettiği kullanıcılardan yaptıkları ödeme başına komisyon alabilir ve bakiye kazanabilir.',	'{\"reference_share\":\"50\"}',	0);

DROP TABLE IF EXISTS `proxy`;
CREATE TABLE `proxy` (
  `proxy_id` int(11) NOT NULL AUTO_INCREMENT,
  `proxy_ip` varchar(155) DEFAULT NULL,
  `proxy_port` int(11) DEFAULT NULL,
  `proxy_user` varchar(155) DEFAULT NULL,
  `proxy_pass` varchar(155) DEFAULT NULL,
  `proxy_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`proxy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `recaptcha_settings`;
CREATE TABLE `recaptcha_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_key` varchar(255) DEFAULT NULL,
  `secret_key` varchar(255) DEFAULT NULL,
  `register_page` tinyint(1) DEFAULT '1',
  `login_page` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `reset_password_requests`;
CREATE TABLE `reset_password_requests` (
  `request_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `request_hash` varchar(64) DEFAULT NULL,
  `request_expiration` varchar(11) DEFAULT NULL,
  `request_status` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`request_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `services`;
CREATE TABLE `services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `api_id` int(11) DEFAULT NULL,
  `api_service` int(11) DEFAULT NULL,
  `api_type` int(11) DEFAULT '0',
  `api_detail` text,
  `service_number` int(11) DEFAULT '9999',
  `service_status` tinyint(1) DEFAULT '1',
  `service_fixed_price` double DEFAULT NULL,
  `service_name` text,
  `service_desc` text,
  `service_charge` double DEFAULT NULL,
  `service_min` int(11) DEFAULT NULL,
  `service_max` int(11) DEFAULT NULL,
  `service_auto` tinyint(1) DEFAULT '0',
  `service_type` tinyint(4) DEFAULT NULL,
  `service_drip` tinyint(1) DEFAULT '0',
  `service_package` tinyint(1) DEFAULT '0',
  `service_comment` tinyint(1) DEFAULT '0',
  `cron_price_rate` int(11) DEFAULT NULL,
  `service_min_max` text,
  `service_auto_status` int(1) NOT NULL DEFAULT '3',
  `cancel_button` int(11) DEFAULT '0',
  `refill_button` int(11) DEFAULT '0',
  `refill_type` int(11) DEFAULT '1',
  `refill_day` varchar(11) DEFAULT NULL,
  `refill_bekleme` varchar(11) DEFAULT NULL,
  PRIMARY KEY (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `services` (`service_id`, `category_id`, `api_id`, `api_service`, `api_type`, `api_detail`, `service_number`, `service_status`, `service_fixed_price`, `service_name`, `service_desc`, `service_charge`, `service_min`, `service_max`, `service_auto`, `service_type`, `service_drip`, `service_package`, `service_comment`, `cron_price_rate`, `service_min_max`, `service_auto_status`, `cancel_button`, `refill_button`, `refill_type`, `refill_day`, `refill_bekleme`) VALUES
(1,	1,	NULL,	NULL,	0,	NULL,	9999,	1,	10,	'[{\"lang\":1,\"name\":\"Organik Takipçi\"}]',	'[{\"lang\":1,\"name\":\"&amp;lt;strong&amp;gt;Dikkat Etmeniz Gerekenler:&amp;lt;/strong&amp;gt;&amp;lt;br&amp;gt;&amp;lt;br&amp;gt;★ Profiliniz gizli olmamalıdır.&amp;lt;br&amp;gt;★ Bir sipariş devam ederken ikinci siparişi girmemelisiniz.&amp;lt;br&amp;gt;★ Yoğunluğa bağlı olarak siparişlerin başlama ve yüklenme süreleri değişebilir.&amp;lt;br&amp;gt;\"}]',	50,	15,	50,	0,	NULL,	0,	0,	0,	1,	'{\"min\":1,\"max\":1}',	3,	0,	0,	1,	'',	'');

DROP TABLE IF EXISTS `settings`;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `site_title` varchar(255) DEFAULT NULL,
  `site_logo` varchar(255) DEFAULT NULL,
  `site_darklogo` varchar(255) DEFAULT NULL,
  `site_links` text,
  `avatar_logo` varchar(255) DEFAULT NULL,
  `site_favi` varchar(255) DEFAULT NULL,
  `euro` varchar(255) DEFAULT NULL,
  `dolar` varchar(255) DEFAULT NULL,
  `site_desc` text,
  `notify_settings` text,
  `site_keyw` varchar(360) DEFAULT NULL,
  `site_currency` varchar(100) DEFAULT NULL,
  `payment_method` tinyint(4) DEFAULT NULL,
  `ticket_limit` int(11) DEFAULT '0',
  `payment_commission` varchar(11) DEFAULT NULL,
  `sms_provider` int(11) DEFAULT NULL,
  `minimum_payment` int(11) DEFAULT '10',
  `api_status` tinyint(1) DEFAULT '0',
  `reference_status` tinyint(1) DEFAULT '0',
  `reference_share` double DEFAULT '0',
  `site_theme` varchar(120) DEFAULT NULL,
  `timezone` text,
  `admin_iletisim` varchar(255) DEFAULT NULL,
  `admin_phone` varchar(120) DEFAULT NULL,
  `contact_detail` text,
  `header_code` text,
  `footer_code` text,
  `maintenance_status` int(11) DEFAULT NULL,
  `discord_apiNotify_url` text,
  `discord_notify_url` text,
  `support_system` int(11) DEFAULT '1',
  `ticket_system` int(11) DEFAULT NULL,
  `register_system` int(11) DEFAULT '1',
  `forgot_system` int(11) DEFAULT '1',
  `service_list` varchar(120) DEFAULT 'public',
  `service_speed` int(11) DEFAULT '0',
  `mail_verify` tinyint(1) DEFAULT '0',
  `skype_verify` tinyint(1) DEFAULT '0',
  `cron_settings` text,
  `cron_secretkey` varchar(500) NOT NULL,
  `guard_settings` text,
  `cron_uptime` text,
  `childpanel` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `settings` (`id`, `site_title`, `site_logo`, `site_darklogo`, `site_links`, `avatar_logo`, `site_favi`, `euro`, `dolar`, `site_desc`, `notify_settings`, `site_keyw`, `site_currency`, `payment_method`, `ticket_limit`, `payment_commission`, `sms_provider`, `minimum_payment`, `api_status`, `reference_status`, `reference_share`, `site_theme`, `timezone`, `admin_iletisim`, `admin_phone`, `contact_detail`, `header_code`, `footer_code`, `maintenance_status`, `discord_apiNotify_url`, `discord_notify_url`, `support_system`, `ticket_system`, `register_system`, `forgot_system`, `service_list`, `service_speed`, `mail_verify`, `skype_verify`, `cron_settings`, `cron_secretkey`, `guard_settings`, `cron_uptime`, `childpanel`) VALUES
(1,	'Smm Panel - v4 İnteraktif Hizmetler',	'https://smmv4.webpaketlerim.com/mp-public/uploads/a8f15eda80c50adb0e71943adc8015cf.png',	'https://smmv4.webpaketlerim.com/mp-public/uploads/677e09724f0e2df9b6c000b75b5da10d.png',	'{\"links\":{\"account\":{\"url\":\"account\"},\"page\":{\"url\":\"page\"},\"add-funds\":{\"url\":\"addfunds\"},\"auto\":{\"url\":\"auto\"},\"autos\":{\"url\":\"autos\"},\"blog\":{\"url\":\"blog\",\"status\":\"1\"},\"contact\":{\"url\":\"contact\",\"status\":\"1\"},\"child\":{\"url\":\"rentpanel\"},\"drips\":{\"url\":\"drips\"},\"faq\":{\"url\":\"faq\",\"status\":\"1\"},\"forgot\":{\"url\":\"forgot\"},\"orders\":{\"url\":\"orders\"},\"reff\":{\"url\":\"reference\",\"status\":\"1\"},\"register\":{\"url\":\"register\"},\"login\":{\"url\":\"\\/\"},\"reset\":{\"url\":\"reset\"},\"services\":{\"url\":\"services\",\"status\":\"1\"},\"terms\":{\"url\":\"terms\",\"status\":\"1\"},\"tickets\":{\"url\":\"tickets\"}}}',	'',	'https://smmv4.webpaketlerim.com/mp-public/uploads/cde51585f2fe2beb601c24a05d2eaf66e765ec55.png',	'10.3972',	'8.5271',	'Smm Panel - v4 sadece api hizmeti veren bir bayilik panelidir.',	'{\"bank\":\"1\",\"online\":\"1\",\"failed\":\"1\",\"support\":\"1\",\"order\":\"1\"}',	'takipçi satın al,bedava takipçi,sosyal panel,smm panel, resellerspanel,instagram hesap çalma,instagram bedava takipçi,facebook bedava takipçi,moonpanel,İnteraktif Hizmetler,smm panel,para kazanma',	'{\"currency_code\":\"TRY\",\"currency_symbol\":\"\\u20ba\"}',	4,	2,	'',	0,	5,	1,	1,	15,	'millano-red',	'Europe/Istanbul',	'iletisim@webpaketlerim.com',	'+905320157350',	'',	'',	'',	0,	'#',	'#',	1,	0,	1,	1,	'public',	0,	0,	0,	'{\"cron_min\":\"notify\",\"cron_max\":\"notify\",\"cron_status\":\"notify\",\"cron_price\":\"close\",\"cron_price_rate\":\"10\"}',	'1',	'{\"guard_status\":\"0\"}',	'',	'{\"status\":\"1\",\"price\":\"150\"}');

DROP TABLE IF EXISTS `sms_settings`;
CREATE TABLE `sms_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(120) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `sms_title` varchar(120) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `smtp_settings`;
CREATE TABLE `smtp_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `smtp_email` varchar(255) DEFAULT NULL,
  `smtp_password` varchar(255) DEFAULT NULL,
  `smtp_host` varchar(255) DEFAULT NULL,
  `smtp_port` varchar(10) DEFAULT NULL,
  `smtp_ssl` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `smtp_settings` (`id`, `smtp_email`, `smtp_password`, `smtp_host`, `smtp_port`, `smtp_ssl`) VALUES
(1,	'',	'',	'',	'',	1);

DROP TABLE IF EXISTS `special_offers`;
CREATE TABLE `special_offers` (
  `offer_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `service_id` int(11) DEFAULT NULL,
  `offer_charge` double DEFAULT NULL,
  PRIMARY KEY (`offer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tasks`;
CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `task_type` int(11) DEFAULT NULL,
  `task_status` int(11) DEFAULT NULL,
  `task_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `task_updatedate` datetime DEFAULT NULL,
  PRIMARY KEY (`task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `tickets`;
CREATE TABLE `tickets` (
  `ticket_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `ticket_title` varchar(255) DEFAULT NULL,
  `ticket_status` tinyint(1) DEFAULT '1',
  `ticket_read` int(11) DEFAULT '0',
  `ticket_ans` int(11) DEFAULT NULL,
  `ticket_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `client_read` int(11) DEFAULT NULL,
  PRIMARY KEY (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `ticket_messages`;
CREATE TABLE `ticket_messages` (
  `message_id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_id` int(11) DEFAULT NULL,
  `message_author` tinyint(1) DEFAULT '0',
  `message_text` text,
  `message_time` varchar(12) DEFAULT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `translations`;
CREATE TABLE `translations` (
  `translation_id` int(11) NOT NULL AUTO_INCREMENT,
  `lang_id` int(11) DEFAULT NULL,
  `code_id` int(11) DEFAULT NULL,
  `translation_text` text,
  PRIMARY KEY (`translation_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `translations` (`translation_id`, `lang_id`, `code_id`, `translation_text`) VALUES
(17,	1,	1,	'Bilinmeyen bir hata oluştu'),
(18,	1,	2,	'İşleminiz devam ediyor'),
(19,	1,	3,	'Hatalı istek!'),
(20,	1,	4,	'Boş veya hatalı değer girdiniz!'),
(21,	1,	5,	'Teknik bir aksaklık oluştu. Daha sonra tekrar deneyiniz.'),
(23,	1,	6,	'Servis'),
(24,	1,	7,	'Bağlantı'),
(25,	1,	8,	'Ücret'),
(26,	1,	9,	'Miktar'),
(27,	1,	10,	'Tamamlanan'),
(28,	1,	12,	'Aralık'),
(29,	1,	13,	'Son İşlem Zamanı'),
(30,	1,	14,	'Durum'),
(31,	1,	15,	'Hepsi'),
(32,	1,	16,	'Tamamlandı'),
(33,	1,	17,	'İptal Edildi'),
(34,	1,	18,	'Kısmi Tamamlandı'),
(35,	1,	19,	'Beklemede'),
(36,	1,	20,	'Yükleniyor'),
(37,	1,	21,	'İşlemde'),
(38,	1,	22,	'Tarih'),
(39,	1,	23,	'Bağlantı'),
(40,	1,	24,	'Ücret'),
(41,	1,	25,	'Başlangıç Sayısı'),
(42,	1,	26,	'Miktar'),
(43,	1,	27,	'Servis'),
(44,	1,	28,	'Durum'),
(45,	1,	29,	'Kalan'),
(46,	1,	30,	'İşlemde'),
(47,	1,	31,	'Tamamlandı'),
(48,	1,	32,	'Yeni Sipariş'),
(49,	1,	33,	'Siparişler'),
(50,	1,	34,	'Süreli Siparişler'),
(51,	1,	35,	'Giriş Yap'),
(52,	1,	36,	'Kayıt Ol'),
(53,	1,	37,	'Çıkış Yap'),
(54,	1,	38,	'Sipariş Formu'),
(55,	1,	39,	'Kategori'),
(56,	1,	40,	'Servis'),
(57,	1,	41,	'Açıklama'),
(58,	1,	42,	'Bağlantı'),
(59,	1,	43,	'Miktar'),
(60,	1,	44,	'Süreli Sipariş'),
(61,	1,	45,	'Kaç Kez Gönderilsin?'),
(62,	1,	46,	'Aralık'),
(63,	1,	47,	'Kaç dakikada bir yollanacağını seçin.'),
(64,	1,	48,	'Toplam Miktar'),
(65,	1,	49,	'Ücret'),
(66,	1,	50,	'Sipariş Ver'),
(67,	1,	51,	'Giriş Yap'),
(68,	1,	52,	'Kullanıcı Adı'),
(69,	1,	53,	'Parola'),
(70,	1,	54,	'Giriş Yap'),
(71,	1,	55,	'Kayıt Ol'),
(72,	1,	56,	'E-posta Adresi'),
(73,	1,	57,	'Kullanıcı Adı'),
(74,	1,	58,	'Parola'),
(75,	1,	59,	'Parola (yeniden)'),
(76,	1,	60,	'Adınız'),
(77,	1,	61,	'Soyadınız'),
(78,	1,	62,	'Telefon Numaranız'),
(79,	1,	63,	'Kayıt Ol'),
(80,	1,	64,	'Kayıt ol düğmesine tıklayarak, sözleşmemizi kabul etmiş olursunuz.'),
(81,	1,	65,	'Yeni Sipariş'),
(82,	1,	66,	'Giriş Yap'),
(83,	1,	67,	'Kayıt Ol'),
(84,	1,	68,	'Siparişler'),
(85,	1,	69,	'Süreli Siparişler'),
(86,	1,	70,	'Sayfa Bulunamadı'),
(87,	1,	71,	'Aradığınız sayfa bulunamadı.<br />Bunun sebebi şunlar olabilir:<br />• Tıkladığınız bağlantının süresi dolmuş,<br />• Tıkladığınız bağlantı hatalı,<br />• Bu sayfa silinmiş veya<br />• Böyle bir sayfa hiç varolmamış olabilir.'),
(88,	1,	72,	'Fiyat Listesi'),
(89,	1,	73,	'Fiyat Listesi'),
(90,	1,	74,	'Sözleşme'),
(91,	1,	75,	'Servis Adı'),
(92,	1,	76,	'Servis Fiyatı'),
(93,	1,	77,	'Minimum Sipariş'),
(94,	1,	78,	'Maksimum Sipariş'),
(95,	1,	79,	'Oto Sipariş'),
(96,	1,	80,	'Oto Sipariş'),
(97,	1,	81,	'Oto Sipariş Formu'),
(98,	1,	82,	'Kategori'),
(99,	1,	83,	'Servis'),
(100,	1,	84,	'Servis Açıklaması'),
(101,	1,	85,	'Kullanıcı Adı'),
(102,	1,	86,	'Miktar'),
(103,	1,	87,	'Sipariş Ver'),
(104,	1,	88,	'Sonlanma Tarihi (İsteğe Bağlı)'),
(105,	1,	89,	'Gönderi Sınırı (İsteğe Bağlı)'),
(106,	1,	90,	'Oto Siparişler'),
(107,	1,	91,	'Servis'),
(108,	1,	92,	'Bağlantı'),
(109,	1,	93,	'Miktar'),
(110,	1,	94,	'Tarih'),
(111,	1,	95,	'Durum'),
(112,	1,	96,	'İşlem'),
(113,	1,	97,	'Devam ediyor...'),
(114,	1,	98,	'Tamamlandı'),
(115,	1,	99,	'Durduruldu'),
(116,	1,	100,	'Oto Siparişler'),
(117,	1,	101,	'Durdur'),
(118,	1,	102,	'Sözleşme'),
(119,	1,	103,	'Tamamlandı'),
(120,	1,	104,	'İptal Edildi'),
(121,	1,	105,	'Kısmi Tamamlandı'),
(122,	1,	106,	'Beklemede'),
(123,	1,	107,	'Yükleniyor'),
(124,	1,	108,	'İşlemde'),
(125,	1,	109,	'Yorumlar (her satıra bir tane)'),
(126,	1,	110,	'E-posta Adresi'),
(127,	1,	111,	'Kullanıcı Adı'),
(128,	1,	112,	'Adınız'),
(129,	1,	113,	'Soyadınız'),
(130,	1,	114,	'Skype'),
(131,	1,	115,	'Hesabım'),
(132,	1,	116,	'Hesap Bilgileri'),
(133,	1,	117,	'Bu bilgileri güncellemek için destek bölümünden iletişime geçiniz.'),
(134,	1,	118,	'API KEY'),
(135,	1,	119,	'Yeni Üret'),
(136,	1,	120,	'Parola Güncelle'),
(137,	1,	121,	'Yeni Parola'),
(138,	1,	122,	'Yeni Parola(tekrar)'),
(139,	1,	123,	'Güncel Parola'),
(140,	1,	124,	'Güncelle'),
(143,	1,	125,	'S.S.S.'),
(144,	1,	126,	'S.S.S.'),
(145,	1,	127,	'Destek'),
(146,	1,	128,	'Destek'),
(147,	1,	129,	'Konu'),
(148,	1,	130,	'Mesaj'),
(149,	1,	131,	'Gönder'),
(150,	1,	132,	'Açık'),
(151,	1,	133,	'Kapalı'),
(152,	1,	134,	'Başlık'),
(153,	1,	135,	'Durum'),
(154,	1,	136,	'API'),
(155,	1,	137,	'API'),
(156,	1,	138,	'Parolamı unuttum'),
(157,	1,	139,	'Parolamı Sıfırla'),
(158,	1,	140,	'E-posta adresi'),
(159,	1,	141,	'Parolamı Sıfırla'),
(160,	1,	142,	'Parolamı Sıfırla'),
(161,	1,	143,	'Parolamı Sıfırla'),
(162,	1,	144,	'Yeni parola'),
(163,	1,	145,	'Yeni parola(tekrar)'),
(164,	1,	146,	'Parolamı Sıfırla'),
(165,	1,	147,	'Parolamı Sıfırla'),
(166,	1,	148,	'Bakiye Yükle'),
(167,	1,	149,	'Ödeme Yöntemi'),
(168,	1,	150,	'Tutar'),
(169,	1,	151,	'Ödeme Sayfasına Git'),
(170,	1,	152,	'Kredi/Banka Kartı'),
(171,	1,	153,	'Bakiye Yükle'),
(172,	1,	154,	'Telefon numarası'),
(173,	1,	155,	'Bakiye Ekle'),
(174,	1,	156,	'Tarih'),
(175,	1,	157,	'Tutar'),
(176,	1,	158,	'Durum'),
(177,	1,	159,	'Beklemede'),
(178,	1,	160,	'Onaylandı'),
(179,	1,	161,	'Onaylanmadı'),
(180,	2,	3,	'Wrong request!'),
(367,	2,	1,	'An unknown error occurred'),
(368,	2,	2,	'Your process is in progress'),
(369,	2,	4,	'You entered an empty or incorrect value!'),
(370,	2,	5,	'There was a technical failure. Try again later.'),
(371,	2,	6,	'Service'),
(372,	2,	7,	'Link'),
(373,	2,	8,	'Price'),
(374,	2,	9,	'Quantity'),
(375,	2,	10,	'Completed'),
(376,	2,	12,	'Interval'),
(377,	2,	13,	'Last Trading Time'),
(378,	2,	14,	'Status'),
(379,	2,	15,	'All'),
(380,	2,	16,	'Completed'),
(381,	2,	17,	'Canceled'),
(382,	2,	18,	'Partial'),
(383,	2,	19,	'Pending'),
(384,	2,	20,	'In progress'),
(385,	2,	21,	'Processing'),
(386,	2,	22,	'Date'),
(387,	2,	23,	'Link'),
(388,	2,	24,	'Price'),
(389,	2,	25,	'Start Count'),
(390,	2,	26,	'Quantity'),
(391,	2,	27,	'Service'),
(392,	2,	28,	'Status'),
(393,	2,	29,	'Remains'),
(394,	1,	162,	'İptal Edildi'),
(395,	1,	163,	'Hatalı parola'),
(396,	1,	164,	'Hatalı kullanıcı adı'),
(397,	1,	165,	'Skype adresi zaten kayıtlı'),
(398,	1,	166,	'Kullanıcı adı zaten kayıtlı'),
(399,	1,	167,	'E-posta adresi zaten kayıtlı'),
(400,	1,	168,	'Parolalar eşleşmiyor'),
(401,	1,	169,	'Kullanıcı adı çok uzun'),
(402,	1,	170,	'Parolanız güncellendi'),
(403,	1,	171,	'Parolalar eşleşmiyor'),
(404,	1,	172,	'Güncel parolanızı hatalı girdiniz'),
(405,	1,	173,	'Siparişiniz alındı'),
(406,	1,	174,	'Yetersiz bakiye'),
(407,	1,	175,	'Miktar minimum ve maksimum değerler arasında olmalı'),
(408,	1,	176,	'Siparişiniz alındı'),
(409,	1,	177,	'Sipariş güncellendi'),
(410,	1,	179,	'Parola sıfırlama bağlantısı e-postanıza gönderildi'),
(411,	1,	180,	'Parolanız değiştirildi'),
(412,	1,	182,	'Ödeme alımı kapalı'),
(413,	1,	183,	'Minimum yükleme miktarına dikkat ediniz.'),
(414,	1,	184,	'Kullanıcı bulunamadı'),
(415,	1,	185,	'Toplam Harcanan'),
(416,	1,	186,	'Toplam Yatırılan'),
(417,	1,	187,	'Açıklama'),
(418,	1,	188,	'Göster'),
(419,	1,	189,	'Referanslar'),
(420,	1,	190,	'Referans Bağlantınız'),
(421,	1,	191,	'Kullanıcı adı'),
(422,	1,	192,	'Kazanç'),
(423,	1,	193,	'Referans'),
(424,	2,	30,	'In Progress'),
(425,	2,	31,	'Completed'),
(426,	2,	32,	'New Order'),
(427,	2,	33,	'Orders'),
(428,	2,	34,	'Drip-Feeds'),
(429,	2,	35,	'Login'),
(430,	2,	36,	'Register'),
(431,	2,	37,	'Logout'),
(432,	2,	38,	'Order Form'),
(433,	2,	39,	'Category'),
(434,	2,	40,	'Service'),
(435,	2,	41,	'Description'),
(436,	2,	42,	'Link'),
(437,	2,	43,	'Quantity'),
(438,	2,	44,	'Drip-Feed Order'),
(439,	2,	45,	'How Many Times Will You Send?'),
(440,	2,	46,	'Interval'),
(441,	2,	47,	'Choose how many minutes to send.'),
(442,	2,	48,	'Total quantity'),
(443,	2,	49,	'Charge'),
(444,	2,	50,	'Order'),
(445,	2,	51,	'Login'),
(446,	2,	52,	'Username'),
(447,	2,	53,	'Password'),
(448,	2,	54,	'Login'),
(449,	2,	55,	'Register'),
(450,	2,	56,	'EMail'),
(451,	2,	57,	'Username'),
(452,	2,	58,	'Password'),
(453,	2,	59,	'Password (again)'),
(454,	2,	60,	'Name'),
(455,	2,	61,	'Surname'),
(456,	2,	62,	'Cell Phone'),
(457,	2,	63,	'Register'),
(458,	2,	64,	'By clicking the sign up button, you accept the agreement.'),
(459,	2,	65,	'New Order'),
(460,	2,	66,	'Login'),
(461,	2,	67,	'Register'),
(462,	2,	68,	'Orders'),
(463,	2,	69,	'Drip-Feeds'),
(464,	2,	70,	'Page not found'),
(465,	2,	71,	'The page you are looking for could not be found. <br /> This may be because: <br /> • The link you clicked has expired, <br /> • The link you clicked is incorrect, <br /> • This page has been deleted or <br /> • Such a page has never it may not exist.'),
(466,	2,	72,	'Price list'),
(467,	2,	73,	'Price list'),
(468,	2,	74,	'Contract'),
(469,	2,	75,	'Service Name'),
(470,	2,	76,	'Service Charge'),
(471,	2,	77,	'Minimum order'),
(472,	2,	78,	'Maximum order'),
(473,	2,	79,	'Auto Order'),
(474,	2,	80,	'Auto Order'),
(475,	2,	81,	'Auto Order Form'),
(476,	2,	82,	'Category'),
(477,	2,	83,	'Service'),
(478,	2,	84,	'Service Description'),
(479,	2,	85,	'Username'),
(480,	2,	86,	'Quantity'),
(481,	2,	87,	'Order'),
(482,	2,	88,	'Expiry Date (Optional)'),
(483,	2,	89,	'Post Limit (Optional)'),
(484,	2,	90,	'Auto Orders'),
(485,	2,	91,	'Service'),
(486,	2,	92,	'Link'),
(487,	2,	93,	'Quantity'),
(488,	2,	94,	'Date'),
(489,	2,	95,	'Status'),
(490,	2,	96,	'Process'),
(491,	2,	97,	'Continues...'),
(492,	2,	98,	'Completed'),
(493,	2,	99,	'Stopped'),
(494,	2,	100,	'Auto Orders'),
(495,	2,	101,	'Stop'),
(496,	2,	102,	'Contract'),
(497,	2,	103,	'Completed'),
(498,	2,	104,	'Cancelled'),
(499,	2,	105,	'Partial'),
(500,	2,	106,	'Pending'),
(501,	2,	107,	'Loading'),
(502,	2,	108,	'In Progress'),
(503,	2,	109,	'Comments (one per line)'),
(504,	2,	110,	'E-mail address'),
(505,	2,	111,	'Username'),
(506,	2,	112,	'Name'),
(507,	2,	113,	'Surname'),
(508,	2,	114,	'Skype'),
(509,	2,	115,	'My Account'),
(510,	2,	116,	'Account info'),
(511,	2,	117,	'Please contact support to update this information.'),
(512,	2,	118,	'API KEY'),
(513,	2,	119,	'New Api Key'),
(514,	2,	120,	'Update Password'),
(515,	2,	121,	'New Password'),
(516,	2,	122,	'New Password (again)'),
(517,	2,	123,	'Current Password'),
(518,	2,	124,	'Update'),
(519,	2,	125,	'FAQ'),
(520,	2,	126,	'FAQ'),
(521,	2,	127,	'Support'),
(522,	2,	128,	'Support'),
(523,	2,	129,	'Subject'),
(524,	2,	130,	'Message'),
(525,	2,	131,	'Send'),
(526,	2,	132,	'Open'),
(527,	2,	133,	'Closed'),
(528,	2,	134,	'Title'),
(529,	2,	135,	'Status'),
(530,	2,	136,	'API'),
(531,	2,	137,	'API'),
(532,	2,	138,	'I forgot my password'),
(533,	2,	139,	'Reset My Password'),
(534,	2,	140,	'E-mail address'),
(535,	2,	141,	'Reset My Password'),
(536,	2,	142,	'Reset My Password'),
(537,	2,	143,	'Reset My Password'),
(538,	2,	144,	'New Password'),
(539,	2,	145,	'New Password(again)'),
(540,	2,	146,	'Reset My Password'),
(541,	2,	147,	'Reset My Password'),
(542,	2,	148,	'Add Funds'),
(543,	2,	149,	'Payment method'),
(544,	2,	150,	'Amount'),
(545,	2,	151,	'Go to Payment Page'),
(546,	2,	152,	'Credit / Debit Card'),
(547,	2,	153,	'Add Funds'),
(548,	2,	154,	'Cell Phone'),
(549,	2,	155,	'Add Funds'),
(550,	2,	156,	'Date'),
(551,	2,	157,	'Amount'),
(552,	2,	158,	'Status'),
(553,	2,	159,	'Pending'),
(554,	2,	160,	'Approved'),
(555,	2,	161,	'Unapproved'),
(556,	2,	162,	'Cancelled'),
(557,	2,	163,	'Incorrect password'),
(558,	2,	164,	'Incorrect username'),
(559,	2,	165,	'Skype address is already registered'),
(560,	2,	166,	'Username already registered'),
(561,	2,	167,	'Email address is already registered'),
(562,	2,	168,	'Passwords do not match'),
(563,	2,	169,	'Username is too long'),
(564,	2,	170,	'Your password has been updated'),
(565,	2,	171,	'Passwords do not match'),
(566,	2,	172,	'You entered your current password incorrectly'),
(567,	2,	173,	'Your order has been received'),
(568,	2,	174,	'Insufficient balance'),
(569,	2,	175,	'The quantity must be between the minimum and maximum values.'),
(570,	2,	176,	'Your order has been received'),
(571,	2,	177,	'Order updated'),
(572,	2,	179,	'The password reset link has been sent to your email'),
(573,	2,	180,	'Your password has been changed'),
(574,	2,	182,	'Receiving payment off'),
(575,	2,	183,	'Pay attention to the minimum loading amount.'),
(576,	2,	184,	'User not found'),
(577,	2,	185,	'Total Spent'),
(578,	2,	186,	'Total Deposited'),
(579,	2,	187,	'Description'),
(580,	2,	188,	'Show'),
(581,	2,	189,	'References'),
(582,	2,	190,	'Your Reference Link'),
(583,	2,	191,	'User name'),
(584,	2,	192,	'Gain'),
(585,	2,	193,	'Reference'),
(586,	1,	194,	'Banka Hesaplarımız'),
(587,	1,	195,	'Banka İsmi'),
(588,	1,	196,	'Hesap IBAN'),
(589,	1,	197,	'Hesap Numarası'),
(590,	1,	198,	'Şube Kodu'),
(591,	1,	199,	'İsim Soyisim'),
(592,	1,	200,	'Ödeme Bildirimi Yap'),
(593,	1,	201,	'Yatırılan Tutar'),
(594,	1,	202,	'Ödeme Bildirimi Yap'),
(595,	1,	203,	'Bakiyeniz'),
(596,	1,	204,	'Duyurular'),
(597,	2,	194,	'Our Bank Accounts'),
(598,	2,	195,	'Bank name'),
(599,	2,	196,	'Account IBAN'),
(600,	2,	197,	'Account number'),
(601,	2,	198,	'Branch code'),
(602,	2,	199,	'Name Surname'),
(603,	2,	200,	'Make Payment Notification'),
(604,	2,	201,	'Amount Deposited'),
(605,	2,	202,	'Make Payment Notification'),
(606,	2,	203,	'Balance'),
(607,	2,	204,	'Announcements'),
(608,	2,	205,	'My Account'),
(609,	2,	206,	'Site Language'),
(610,	2,	207,	'Internal Links'),
(611,	2,	208,	'About Us'),
(612,	2,	209,	'Useful Links'),
(613,	2,	210,	'Contact Number'),
(614,	2,	211,	'EMail Adress'),
(615,	2,	214,	'Contact'),
(616,	1,	205,	'Hesabım'),
(617,	1,	206,	'Site Dili'),
(618,	1,	207,	'Site İçi Bağlantılar'),
(619,	1,	208,	'Hakkımızda'),
(620,	1,	209,	'Yararlı Bağlantılar'),
(621,	1,	210,	'İletişim Numarası'),
(622,	1,	211,	'EMail Adresimiz'),
(623,	1,	214,	'İletişim'),
(624,	1,	212,	'Çıkış Yap'),
(625,	1,	213,	'İletişim'),
(626,	2,	212,	'Logout'),
(627,	2,	213,	'Contact'),
(628,	2,	215,	'is a fully automatic 24/7 social media panel that provides social media services. Your orders start automatically and are completed quickly. You can track your past orders and the status of your active orders from the Orders page, and you can start your own sales thanks to our advanced API system!'),
(629,	2,	216,	'Why Us?'),
(630,	2,	217,	'Hello, Welcome'),
(631,	2,	218,	'Turkey\'s No. 1 SMM Panel'),
(632,	2,	219,	'get ready to rise thanks to!'),
(633,	2,	220,	'For Your Business'),
(634,	2,	221,	'Affordable Prices'),
(635,	2,	222,	'offers affordable services for every budget!'),
(636,	2,	223,	'Save Time'),
(637,	2,	224,	'Fast Services'),
(638,	2,	225,	'Avoid waiting 2 days, 3 days thanks to our fast services!'),
(639,	2,	226,	'7/24'),
(640,	2,	227,	'Online Payment'),
(641,	2,	228,	'Upload your balance whenever you want securely, 24/7 thanks to online payment'),
(642,	2,	229,	'Difference'),
(643,	1,	215,	'sosyal medya hizmetleri sunan 7/24 tam otomatik bir sosyal medya panelidir. Siparişleriniz otomatik olarak başlar ve hızlı bir şekilde tamamlanır. Siparişler sayfasından geçmiş siparişlerinizi ve aktif olan siparişlerinizin durumunu takip edebilir, gelişmiş API sistemimiz sayesinde siz de kendi satışlarınıza başlayabilirsiniz!'),
(644,	1,	216,	'Neden Biz?'),
(645,	1,	217,	'Merhaba, Hoşgeldin'),
(646,	1,	218,	'Türkiye\'nin 1 Numaralı SMM Paneli'),
(647,	1,	219,	'ile yükselişe geçmeye hazır olun!'),
(648,	1,	220,	'İşiniz İçin'),
(649,	1,	221,	'Uygun Fiyatlar'),
(650,	1,	222,	'uygun fiyatlarıyla her bütçeye uygun servisler sunuyor!'),
(651,	1,	223,	'Zamandan Kazanın'),
(652,	1,	224,	'Hızlı Servisler'),
(653,	1,	225,	'Hızlı servislerimiz sayesinde 2 gün, 3 gün beklemekten kurtulun!'),
(654,	1,	226,	'7/24'),
(655,	1,	227,	'Online Ödeme'),
(656,	1,	228,	'Online ödeme sayesinde 7/24 güvenli bir şekilde istediğiniz zaman bakiye yükleyin.'),
(657,	1,	229,	'Farkı'),
(658,	1,	230,	'Blog'),
(659,	1,	231,	'Henüz blog yazısı yayınlanmamış, lütfen daha sonra tekrar kontrol ediniz.'),
(660,	2,	230,	'Blog'),
(661,	2,	231,	'No blog post has been published yet, please check back later.'),
(662,	1,	232,	'Mesajınız'),
(663,	1,	233,	'Cevapla'),
(664,	2,	232,	'Your Message'),
(665,	2,	233,	'Reply'),
(666,	1,	234,	'Yanıtlandı'),
(667,	1,	235,	'Beklemede'),
(668,	1,	236,	'Mail Onay'),
(669,	1,	237,	'Gönder'),
(670,	1,	238,	'Telefon Doğrulama');

DROP TABLE IF EXISTS `translation_codes`;
CREATE TABLE `translation_codes` (
  `code_id` int(11) NOT NULL AUTO_INCREMENT,
  `code_text` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`code_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `translation_codes` (`code_id`, `code_text`) VALUES
(1,	'UNKNOWN_ERROR'),
(2,	'PROCESS_ERROR'),
(3,	'MESSAGE_WRONG_REQUEST'),
(4,	'MESSAGE_NULL_OR_WRONG_VALUE'),
(5,	'TECHNICAL_FAILURE'),
(6,	'DRIPS_SERVICE'),
(7,	'DRIPS_LINK'),
(8,	'DRIPS_AMOUNT'),
(9,	'DRIPS_QUANTITY'),
(10,	'DRIPS_COMPLETED'),
(12,	'DRIPS_INTERVAL'),
(13,	'DRIPS_LAST_ACTION'),
(14,	'DRIPS_STATUS'),
(15,	'ORDERS_ALL'),
(16,	'ORDERS_COMPLETED'),
(17,	'ORDERS_CANCELED'),
(18,	'ORDERS_PARTIAL'),
(19,	'ORDERS_PENDING'),
(20,	'ORDERS_INPROGRESS'),
(21,	'ORDERS_PROCESSING'),
(22,	'ORDERS_DATE'),
(23,	'ORDERS_LINK'),
(24,	'ORDERS_AMOUNT'),
(25,	'ORDERS_START_COUNT'),
(26,	'ORDERS_QUANTITY'),
(27,	'ORDERS_SERVICE'),
(28,	'ORDERS_STATUS'),
(29,	'ORDERS_REMAINS'),
(30,	'DRIP_STATUS_PROCESSING'),
(31,	'DRIP_STATUS_COMPLETED'),
(32,	'NAVBAR_NEW_ORDER'),
(33,	'NAVBAR_ORDERS'),
(34,	'NAVBAR_DRIP_ORDERS'),
(35,	'NAVBAR_LOGIN'),
(36,	'NAVBAR_REGISTER'),
(37,	'NAVBAR_LOGOUT'),
(38,	'ORDER_FORM_TITLE'),
(39,	'ORDER_FORM_CATEGORY_TITLE'),
(40,	'ORDER_FORM_SERVICE_TITLE'),
(41,	'ORDER_FORM_DESC_TITLE'),
(42,	'ORDER_FORM_LINK_TITLE'),
(43,	'ORDER_FORM_QUANTITY_TITLE'),
(44,	'ORDER_FORM_DRIP_CHECK_TITLE'),
(45,	'ORDER_FORM_DRIP_RUNS_TITLE'),
(46,	'ORDER_FORM_DRIP_INTERVAL_TITLE'),
(47,	'ORDER_FORM_DRIP_INTERVAL_MESSAGE_TITLE'),
(48,	'ORDER_FORM_DRIP_TOTAL_QUANTITY_TITLE'),
(49,	'ORDER_FORM_AMOUNT_TITLE'),
(50,	'ORDER_FORM_SUBMIT'),
(51,	'LOGIN_FORM_TITLE'),
(52,	'LOGIN_USERNAME_TITLE'),
(53,	'LOGIN_PASSWORD_TITLE'),
(54,	'LOGIN_SUBMIT'),
(55,	'REGISTER_FORM_TITLE'),
(56,	'REGISTER_EMAIL_TITLE'),
(57,	'REGISTER_USERNAME_TITLE'),
(58,	'REGISTER_PASSWORD_TITLE'),
(59,	'REGISTER_RE_PASSWORD_TITLE'),
(60,	'REGISTER_FIRST_NAME_TITLE'),
(61,	'REGISTER_LAST_NAME_TITLE'),
(62,	'REGISTER_SKYPE_TITLE'),
(63,	'REGISTER_SUBMIT'),
(64,	'REGISTER_SUBMIT_MESSAGE_TITLE'),
(65,	'INDEX_PAGE_TITLE'),
(66,	'LOGIN_PAGE_TITLE'),
(67,	'REGISTER_PAGE_TITLE'),
(68,	'ORDERS_PAGE_TITLE'),
(69,	'DRIPS_PAGE_TITLE'),
(70,	'404_PAGE_TITLE'),
(71,	'404_PAGE_CONTENT'),
(72,	'NAVBAR_SERVICES'),
(73,	'SERVICES_PAGE_TITLE'),
(74,	'NAVBAR_TERMS'),
(75,	'SERVICES_NAME'),
(76,	'SERVICES_CHARGE'),
(77,	'SERVICES_MIN'),
(78,	'SERVICES_MAX'),
(79,	'NAVBAR_AUTO_ORDER'),
(80,	'AUTO_PAGE_TITLE'),
(81,	'AUTO_FORM_TITLE'),
(82,	'AUTO_FORM_CATEGORY_TITLE'),
(83,	'AUTO_FORM_SERVICE_TITLE'),
(84,	'AUTO_FORM_DESC_TITLE'),
(85,	'AUTO_FORM_LINK_TITLE'),
(86,	'AUTO_FORM_QUANTITY_TITLE'),
(87,	'AUTO_FORM_SUBMIT'),
(88,	'AUTO_FORM_EXPIRATION'),
(89,	'AUTO_FORM_POST_LIMIT'),
(90,	'NAVBAR_AUTO_ORDERS'),
(91,	'AUTOS_SERVICE'),
(92,	'AUTOS_LINK'),
(93,	'AUTOS_QUANTITY'),
(94,	'AUTOS_DATE'),
(95,	'AUTOS_STATUS'),
(96,	'AUTOS_EDIT'),
(97,	'AUTO_STATUS_PROCESSING'),
(98,	'AUTO_STATUS_COMPLETED'),
(99,	'AUTO_STATUS_CANCELED'),
(100,	'AUTOS_PAGE_TITLE'),
(101,	'STOP_AUTO'),
(102,	'TERMS_PAGE_TITLE'),
(103,	'ORDERS_STATUS_COMPLETED'),
(104,	'ORDERS_STATUS_CANCELED'),
(105,	'ORDERS_STATUS_PARTIAL'),
(106,	'ORDERS_STATUS_PENDING'),
(107,	'ORDERS_STATUS_INPROGRESS'),
(108,	'ORDERS_STATUS_PROCESSING'),
(109,	'ORDER_FORM_COMMENTS_TITLE'),
(110,	'USER_EMAIL_TITLE'),
(111,	'USER_USERNAME_TITLE'),
(112,	'USER_FIRST_NAME_TITLE'),
(113,	'USER_LAST_NAME_TITLE'),
(114,	'USER_SKYPE_TITLE'),
(115,	'ACCOUNT_PAGE_TITLE'),
(116,	'ACCOUNT_INFORMATION_TITLE'),
(117,	'ACCOUNT_UPDATE_INFORMATION'),
(118,	'API_KEY_TITLE'),
(119,	'UPDATE_API_KEY_SUBMIT'),
(120,	'UPDATE_PASSWORD_TITLE'),
(121,	'USER_NEW_PASSWORD_TITLE'),
(122,	'USER_RE_NEW_PASSWORD_TITLE'),
(123,	'USER_PASSWORD_TITLE'),
(124,	'UPDATE_PASSWORD_SUBMIT'),
(125,	'NAVBAR_FAQ'),
(126,	'FAQ_PAGE_TITLE'),
(127,	'TICKETS_PAGE_TITLE'),
(128,	'NAVBAR_TICKETS'),
(129,	'TICKET_FORM_TITLE'),
(130,	'TICKET_FORM_MESSAGE'),
(131,	'TICKET_SUBMIT'),
(132,	'TICKET_OPEN'),
(133,	'TICKET_CLOSED'),
(134,	'TICKETS_TABLE_TITLE'),
(135,	'TICKETS_TABLE_STATUS'),
(136,	'NAVBAR_API'),
(137,	'API_PAGE_TITLE'),
(138,	'LOGIN_FORM_FORGOT_PASSWORD'),
(139,	'FORGOT_PASSWORD_FORM_TITLE'),
(140,	'FORGOT_PASSWORD_EMAIL'),
(141,	'FORGOT_PASSWORD_SUBMIT'),
(142,	'FORGOT_PAGE_TITLE'),
(143,	'RESET_PASSWORD_FORM_TITLE'),
(144,	'RESET_PASSWORD_NEW_PASSWORD'),
(145,	'RESET_PASSWORD_RE_NEW_PASSWORD'),
(146,	'RESET_PASSWORD_SUBMIT'),
(147,	'RESET_PAGE_TITLE'),
(148,	'ADD_FUNDS_FORM_TITLE'),
(149,	'ADD_FUNDS_METHOD'),
(150,	'ADD_FUNDS_AMOUNT'),
(151,	'ADD_FUNDS_SUBMIT'),
(152,	'CREDIT_CARD'),
(153,	'ADD_FUNDS_PAGE_TITLE'),
(154,	'ADD_FUNDS_PHONE'),
(155,	'NAVBAR_ADD'),
(156,	'DEPOSIT_TABLE_DATE_TITLE'),
(157,	'DEPOSIT_TABLE_AMOUNT_TITLE'),
(158,	'DEPOSIT_TABLE_STATUS_TITLE'),
(159,	'PAYMENT_WAIT'),
(160,	'PAYMENT_SUCCESS'),
(161,	'PAYMENT_FAILED'),
(162,	'DRIP_STATUS_CANCELED'),
(163,	'LOGIN_MESSAGE_WRONG_PASSWORD'),
(164,	'LOGIN_MESSAGE_WRONG_USERNAME'),
(165,	'REGISTER_MESSAGE_TAKEN_SKYPE'),
(166,	'REGISTER_MESSAGE_TAKEN_USERNAME'),
(167,	'REGISTER_MESSAGE_TAKEN_EMAIL'),
(168,	'REGISTER_MESSAGE_PASSWORD_DONT_MATCH'),
(169,	'REGISTER_MESSAGE_TOO_LONG_USERNAME'),
(170,	'UPDATE_PASSWORD_MESSAGE_SUCCESS'),
(171,	'UPDATE_PASSWORD_MESSAGE_DONT_MATCH'),
(172,	'UPDATE_PASSWORD_MESSAGE_WRONG_PASSWORD'),
(173,	'ORDER_MESSAGE_SUCCESS'),
(174,	'INSUFFICIENT_BALANCE'),
(175,	'ORDER_MESSAGE_QUANTITY'),
(176,	'AUTO_MESSAGE_SUCCESS'),
(177,	'AUTO_UPDATE_SUCCESS_MESSAGE'),
(179,	'FORGOT_MESSAGE_SUCCESS'),
(180,	'RESET_PASSWORD_SUCCESS'),
(182,	'MESSAGE_PAYMENT_CLOSED'),
(183,	'ADD_FUNDS_MESSAGE_LEAST'),
(184,	'FORGOT_MESSAGE_NOT_FOUND'),
(185,	'TOTAL_SPENT_TITLE'),
(186,	'TOTAL_DEPOSITED_TITLE'),
(187,	'SERVICES_DESC'),
(188,	'SERVICES_DESC_SHOW'),
(189,	'ACCOUNT_REFERENCE_TITLE'),
(190,	'USER_REFERENCE_LINK_TITLE'),
(191,	'REFERENCE_TABLE_USERNAME_TITLE'),
(192,	'REFERENCE_TABLE_EARNINGS_TITLE'),
(193,	'REFF_TITLE'),
(194,	'ADD_FUNDS_BANK_ACCOUNTS'),
(195,	'ADD_FUNDS_ACCOUNT_TITLE'),
(196,	'ADD_FUNDS_ACCOUNT_IBAN'),
(197,	'ADD_FUNDS_ACCOUNT_NUMBER'),
(198,	'ADD_FUNDS_ACCOUNT_BRANCH'),
(199,	'ADD_FUNDS_ACCOUNT_NAME'),
(200,	'ADD_FUNDS_BANK_FORM_TITLE'),
(201,	'ADD_FUNDS_BANK_AMOUNT'),
(202,	'ADD_FUNDS_BANK_SUBMIT'),
(203,	'INDEX_BALANCE_INFO'),
(204,	'INDEX_ANNOUCEMENTS_TITLE'),
(205,	'MY_ACCOUNT'),
(206,	'FOOTER_ONE'),
(207,	'FOOTER_TWO'),
(208,	'FOOTER_THREE'),
(209,	'FOOTER_FOUR'),
(210,	'FOOTER_PHONE_TITLE'),
(211,	'FOOTER_EMAIL_TITLE'),
(212,	'LOGOUT_TITLE'),
(213,	'NAVBAR_CONTACT'),
(215,	'INDEX_WHY_US_CONTENT'),
(216,	'INDEX_WHY_US_TITLE'),
(217,	'INDEX_LOGIN_HELLO'),
(218,	'INDEX_LOGIN_TITLE'),
(219,	'INDEX_LOGIN_SUBTITLE'),
(220,	'INDEX_CONTENT_ONE_SUBTITLE'),
(221,	'INDEX_CONTENT_ONE_TITLE'),
(222,	'INDEX_CONTENT_ONE_CONTENT'),
(223,	'INDEX_CONTENT_TWO_SUBTITLE'),
(224,	'INDEX_CONTENT_TWO_TITLE'),
(225,	'INDEX_CONTENT_TWO_CONTENT'),
(226,	'INDEX_CONTENT_THREE_SUBTITLE'),
(227,	'INDEX_CONTENT_THREE_TITLE'),
(228,	'INDEX_CONTENT_THREE_CONTENT'),
(229,	'INDEX_CONTENTS_TITLE'),
(230,	'NAVBAR_BLOG'),
(231,	'BLOG_NOT_FOUND'),
(232,	'TICKET_FORM_MESSAGE'),
(233,	'TICKET_SUBMIT'),
(234,	'TICKET_ANS_TWO'),
(235,	'TICKET_ANS_ONE'),
(236,	'MAIL_VERIFY_TITLE'),
(237,	'SKYPE_VERIFY_SUBMIT'),
(238,	'SKYPE_VERIFY_TITLE');

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_authority` tinyint(4) DEFAULT '0',
  `user_perms` text,
  `user_email` varchar(255) DEFAULT NULL,
  `user_username` varchar(40) DEFAULT NULL,
  `user_password` varchar(255) DEFAULT NULL,
  `user_first_name` varchar(255) DEFAULT NULL,
  `user_last_name` varchar(255) DEFAULT NULL,
  `user_skype` varchar(50) DEFAULT NULL,
  `user_balance` double DEFAULT '0',
  `user_spent` double NOT NULL DEFAULT '0',
  `user_key` varchar(32) DEFAULT NULL,
  `user_verify` text,
  `user_verify_code` int(11) DEFAULT NULL,
  `user_status` tinyint(1) DEFAULT '1',
  `reg_date` int(11) DEFAULT NULL,
  `last_date` int(11) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `users` (`user_id`, `user_authority`, `user_perms`, `user_email`, `user_username`, `user_password`, `user_first_name`, `user_last_name`, `user_skype`, `user_balance`, `user_spent`, `user_key`, `user_verify`, `user_verify_code`, `user_status`, `reg_date`, `last_date`) VALUES
(1,	2,	'{\"access\":{\"dashboard\":\"1\",\"users\":\"1\",\"orders\":\"1\",\"autos\":\"1\",\"drips\":\"1\",\"logs\":\"1\",\"services\":\"1\",\"payments\":\"1\",\"support\":\"1\",\"appearence\":\"1\",\"tasks\":\"1\",\"settings\":\"1\",\"pages\":\"1\",\"fields\":\"1\",\"blog\":\"1\",\"announcements\":\"1\",\"themes\":\"1\",\"bonuses\":\"1\",\"links\":\"1\",\"menus\":\"1\",\"files\":\"1\",\"language\":\"1\",\"reports\":\"1\",\"plugins\":\"1\",\"payment\":\"1\",\"api\":\"1\",\"integrations\":\"1\",\"accounts\":\"1\",\"smtp\":\"1\",\"delete\":\"1\",\"edit\":\"1\",\"root\":\"1\"}}',	'admin@mail.com',	'admin',	'$2y$10$XA6Ng.zF8h912GVqB6RhtemPvf7fvn9.uRGCC05s68n5I.56NPGfm',	'Admin',	'Hesabı',	'05000000000',	0,	0,	'7b0d32c90aba92a7f22787082db50882',	'{\"email\":0,\"skype\":0}',	349519,	1,	1612395082,	1681792342),
(2,	0,	'0',	'dfgdfgdfgd@gmail.com',	'qdfasf',	'$2y$10$XjqLWBwyqRiGK7xK11y3GuO8RV6mQvDcD6qFmrZAjJA/FHos3/drO',	'sgsdfg',	'dfgdfg',	'05352635584',	0,	0,	'513aedb2662a3242694a6bc7118ed235',	'{\"email\":0,\"skype\":0}',	NULL,	1,	1681727197,	1681727198),
(3,	0,	'0',	'faikb7935@gmail.com',	'ixibilmem.06',	'$2y$10$r4BRHe8xA3HUCTh1P7oIZ.I9E6PgDOJgievgyecgT7l46r9HRKbx6',	'Faik',	'Baş',	'5362827478',	0,	0,	'95c5a0d6bc88c1dfecc50de11039516d',	'{\"email\":0,\"skype\":0}',	NULL,	1,	1709899968,	1709900081);

DROP TABLE IF EXISTS `user_logs`;
CREATE TABLE `user_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `log_ip` varchar(255) DEFAULT NULL,
  `log_time` varchar(20) DEFAULT NULL,
  `log_content` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `user_logs` (`log_id`, `user_id`, `log_ip`, `log_time`, `log_content`) VALUES
(1,	1,	'88.226.129.46',	'1681647117',	'Giriş yapıldı.'),
(2,	1,	'88.226.129.46',	'1681647432',	'Giriş yapıldı.'),
(3,	1,	'88.226.129.46',	'1681648751',	'Giriş yapıldı.'),
(4,	1,	'88.226.129.46',	'1681648893',	'Giriş yapıldı.'),
(5,	1,	'88.226.129.46',	'1681651505',	'Giriş yapıldı.'),
(6,	1,	'88.226.129.46',	'1681651751',	'Giriş yapıldı.'),
(7,	1,	'88.226.129.46',	'1681651948',	'Giriş yapıldı.'),
(8,	1,	'88.226.129.46',	'1681652376',	'Giriş yapıldı.'),
(9,	1,	'78.174.114.252',	'1681657487',	'Giriş yapıldı.'),
(10,	1,	'88.226.129.46',	'1681657793',	'Giriş yapıldı.'),
(11,	2,	'195.155.176.165',	'1681727197',	'Kayıt olundu.'),
(12,	1,	'88.234.231.255',	'1681792193',	'Giriş yapıldı.'),
(13,	3,	'46.154.170.186',	'1709899968',	'Kayıt olundu.');

DROP TABLE IF EXISTS `user_references`;
CREATE TABLE `user_references` (
  `reference_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `reference_user_id` varchar(255) DEFAULT NULL,
  `reference_earnings` double DEFAULT '0',
  PRIMARY KEY (`reference_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- 2024-03-27 08:37:16