-- Adminer 4.8.1 MySQL 8.0.16 dump

SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

CREATE DATABASE `script` /*!40100 DEFAULT CHARACTER SET utf8 */ /*!80016 DEFAULT ENCRYPTION='N' */;
USE `script`;

CREATE TABLE `chat` (
  `id` int(10) unsigned NOT NULL,
  `from` varchar(255) NOT NULL DEFAULT '',
  `to` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `recd` int(10) unsigned NOT NULL DEFAULT '0',
  `from_name` varchar(100) NOT NULL,
  `to_name` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `chat` (`id`, `from`, `to`, `message`, `sent`, `recd`, `from_name`, `to_name`) VALUES
(104,	'23',	'82',	'sad',	'2018-02-16 15:46:33',	0,	'ProWriters',	'C82'),
(105,	'23',	'82',	'asd',	'2018-02-16 15:46:34',	0,	'ProWriters',	'C82'),
(106,	'23',	'82',	'said it is well',	'2018-02-16 15:46:39',	0,	'ProWriters',	'C82'),
(107,	'23',	'88',	'kk',	'2018-02-16 15:48:15',	0,	'ProWriters',	'C88'),
(108,	'23',	'65',	'yes 65',	'2018-02-16 15:49:05',	0,	'ProWriters',	'C65'),
(109,	'31',	'11',	'writer 11',	'2018-02-16 15:52:08',	0,	'C31',	'W11'),
(110,	'31',	'5',	'prowriters',	'2018-02-16 15:52:15',	0,	'C31',	'Prowritero'),
(111,	'23',	'31',	'yes',	'2018-02-16 15:53:09',	0,	'ProWriters',	'C31'),
(112,	'23',	'31',	'yes',	'2018-02-16 15:53:35',	0,	'ProWriters',	'C31'),
(113,	'31',	'23',	'yes',	'2018-02-16 15:53:46',	0,	'C31',	'ProWriters'),
(114,	'23',	'31',	'ih',	'2018-02-16 15:54:01',	0,	'ProWriters',	'C31'),
(115,	'23',	'31',	'yes',	'2018-02-16 15:54:14',	0,	'ProWriters',	'C31'),
(116,	'31',	'23',	'yes',	'2018-02-16 15:54:32',	0,	'C31',	'ProWriters'),
(117,	'31',	'23',	'this is c31',	'2018-02-16 15:54:40',	0,	'C31',	'ProWriters'),
(118,	'23',	'31',	'I am writer prowriters',	'2018-02-16 15:55:16',	0,	'ProWriters',	'C31'),
(119,	'23',	'76',	'when you are online tell me',	'2018-02-16 15:56:34',	0,	'ProWriters',	'C76'),
(120,	'23',	'31',	'seen this?',	'2018-02-16 15:57:20',	0,	'ProWriters',	'C31'),
(121,	'23',	'31',	'are you there?',	'2018-02-16 15:59:58',	0,	'ProWriters',	'C31'),
(122,	'31',	'23',	'one',	'2018-02-16 16:00:49',	0,	'C31',	'ProWriters'),
(123,	'23',	'31',	'two',	'2018-02-16 16:00:54',	0,	'ProWriters',	'C31'),
(124,	'31',	'23',	'three',	'2018-02-16 16:00:59',	0,	'C31',	'ProWriters'),
(125,	'23',	'31',	'four',	'2018-02-16 16:01:03',	0,	'ProWriters',	'C31'),
(134,	'23',	'31',	'good',	'2018-02-16 16:10:08',	0,	'ProWriters',	'C31'),
(135,	'23',	'31',	'sooner it will be ok',	'2018-02-16 16:12:02',	0,	'ProWriters',	'C31'),
(136,	'23',	'31',	'what about now',	'2018-02-16 16:12:25',	0,	'ProWriters',	'C31'),
(137,	'31',	'23',	'hehe',	'2018-02-16 16:16:08',	0,	'C31',	'ProWriters'),
(138,	'23',	'31',	'here',	'2018-02-16 16:16:15',	0,	'ProWriters',	'C31'),
(139,	'23',	'31',	'yes yes',	'2018-02-16 16:16:32',	0,	'ProWriters',	'C31'),
(140,	'23',	'31',	'true',	'2018-02-16 16:19:18',	0,	'ProWriters',	'C31'),
(141,	'23',	'31',	'yes',	'2018-02-16 16:20:04',	0,	'ProWriters',	'C31'),
(142,	'23',	'31',	'thehe',	'2018-02-16 16:20:20',	0,	'ProWriters',	'C31'),
(143,	'31',	'2',	'dfg',	'2018-02-16 16:20:54',	0,	'C31',	'W2'),
(144,	'31',	'2',	'ds',	'2018-02-16 17:07:53',	0,	'C31',	'W2'),
(145,	'31',	'2',	'das',	'2018-02-16 17:07:54',	0,	'C31',	'W2'),
(146,	'23',	'31',	'true',	'2018-02-16 17:08:41',	0,	'ProWriters',	'C31'),
(104,	'23',	'82',	'sad',	'2018-02-16 15:46:33',	0,	'ProWriters',	'C82'),
(105,	'23',	'82',	'asd',	'2018-02-16 15:46:34',	0,	'ProWriters',	'C82'),
(106,	'23',	'82',	'said it is well',	'2018-02-16 15:46:39',	0,	'ProWriters',	'C82'),
(107,	'23',	'88',	'kk',	'2018-02-16 15:48:15',	0,	'ProWriters',	'C88'),
(108,	'23',	'65',	'yes 65',	'2018-02-16 15:49:05',	0,	'ProWriters',	'C65'),
(109,	'31',	'11',	'writer 11',	'2018-02-16 15:52:08',	0,	'C31',	'W11'),
(110,	'31',	'5',	'prowriters',	'2018-02-16 15:52:15',	0,	'C31',	'Prowritero'),
(111,	'23',	'31',	'yes',	'2018-02-16 15:53:09',	0,	'ProWriters',	'C31'),
(112,	'23',	'31',	'yes',	'2018-02-16 15:53:35',	0,	'ProWriters',	'C31'),
(113,	'31',	'23',	'yes',	'2018-02-16 15:53:46',	0,	'C31',	'ProWriters'),
(114,	'23',	'31',	'ih',	'2018-02-16 15:54:01',	0,	'ProWriters',	'C31'),
(115,	'23',	'31',	'yes',	'2018-02-16 15:54:14',	0,	'ProWriters',	'C31'),
(116,	'31',	'23',	'yes',	'2018-02-16 15:54:32',	0,	'C31',	'ProWriters'),
(117,	'31',	'23',	'this is c31',	'2018-02-16 15:54:40',	0,	'C31',	'ProWriters'),
(118,	'23',	'31',	'I am writer prowriters',	'2018-02-16 15:55:16',	0,	'ProWriters',	'C31'),
(119,	'23',	'76',	'when you are online tell me',	'2018-02-16 15:56:34',	0,	'ProWriters',	'C76'),
(120,	'23',	'31',	'seen this?',	'2018-02-16 15:57:20',	0,	'ProWriters',	'C31'),
(121,	'23',	'31',	'are you there?',	'2018-02-16 15:59:58',	0,	'ProWriters',	'C31'),
(122,	'31',	'23',	'one',	'2018-02-16 16:00:49',	0,	'C31',	'ProWriters'),
(123,	'23',	'31',	'two',	'2018-02-16 16:00:54',	0,	'ProWriters',	'C31'),
(124,	'31',	'23',	'three',	'2018-02-16 16:00:59',	0,	'C31',	'ProWriters'),
(125,	'23',	'31',	'four',	'2018-02-16 16:01:03',	0,	'ProWriters',	'C31'),
(134,	'23',	'31',	'good',	'2018-02-16 16:10:08',	0,	'ProWriters',	'C31'),
(135,	'23',	'31',	'sooner it will be ok',	'2018-02-16 16:12:02',	0,	'ProWriters',	'C31'),
(136,	'23',	'31',	'what about now',	'2018-02-16 16:12:25',	0,	'ProWriters',	'C31'),
(137,	'31',	'23',	'hehe',	'2018-02-16 16:16:08',	0,	'C31',	'ProWriters'),
(138,	'23',	'31',	'here',	'2018-02-16 16:16:15',	0,	'ProWriters',	'C31'),
(139,	'23',	'31',	'yes yes',	'2018-02-16 16:16:32',	0,	'ProWriters',	'C31'),
(140,	'23',	'31',	'true',	'2018-02-16 16:19:18',	0,	'ProWriters',	'C31'),
(141,	'23',	'31',	'yes',	'2018-02-16 16:20:04',	0,	'ProWriters',	'C31'),
(142,	'23',	'31',	'thehe',	'2018-02-16 16:20:20',	0,	'ProWriters',	'C31'),
(143,	'31',	'2',	'dfg',	'2018-02-16 16:20:54',	0,	'C31',	'W2'),
(144,	'31',	'2',	'ds',	'2018-02-16 17:07:53',	0,	'C31',	'W2'),
(145,	'31',	'2',	'das',	'2018-02-16 17:07:54',	0,	'C31',	'W2'),
(146,	'23',	'31',	'true',	'2018-02-16 17:08:41',	0,	'ProWriters',	'C31');

CREATE TABLE `ops_aclevel` (
  `aclevel_id` int(11) NOT NULL AUTO_INCREMENT,
  `aclevel_value` double NOT NULL,
  `aclevel_name` varchar(150) NOT NULL,
  `aclevel_checked` varchar(20) NOT NULL,
  PRIMARY KEY (`aclevel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_aclevel` (`aclevel_id`, `aclevel_value`, `aclevel_name`, `aclevel_checked`) VALUES
(1,	1.2,	'High School',	''),
(2,	1.2,	'Undergrad. (yrs 1-4)',	'checked'),
(3,	1.35,	'Masters',	''),
(4,	1.6,	'PhD',	'');

CREATE TABLE `ops_affiliates` (
  `affl_id` int(11) NOT NULL AUTO_INCREMENT,
  `affl_user` int(11) NOT NULL,
  `affl_customer` varchar(45) NOT NULL,
  `affl_orderid` int(11) NOT NULL,
  `affl_orderamnt` float NOT NULL,
  `affl_useramnt` float NOT NULL,
  `affl_status` varchar(25) NOT NULL,
  `affs_userpaiddate` datetime NOT NULL,
  `affl_date` datetime NOT NULL,
  `affl_type` varchar(25) NOT NULL,
  PRIMARY KEY (`affl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_affiliates` (`affl_id`, `affl_user`, `affl_customer`, `affl_orderid`, `affl_orderamnt`, `affl_useramnt`, `affl_status`, `affs_userpaiddate`, `affl_date`, `affl_type`) VALUES
(25,	99,	'100',	21171,	37.5,	0.75,	'success',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(26,	96,	'98',	21172,	726,	14.52,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(27,	96,	'98',	21174,	70,	1.4,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(28,	96,	'98',	21176,	354.2,	7.084,	'success',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(29,	98,	'103',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(30,	98,	'103',	21177,	27.6,	0.552,	'success',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(31,	98,	'93',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(32,	99,	'108',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(33,	99,	'108',	21189,	12.5,	1.25,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(34,	99,	'108',	21190,	55,	5.5,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(35,	99,	'108',	21191,	23,	2.3,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(36,	99,	'108',	21192,	36.5,	3.65,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(37,	99,	'108',	21196,	26.5,	2.65,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(38,	99,	'108',	21197,	35,	3.5,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(39,	99,	'108',	21198,	20.25,	2.025,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(40,	99,	'108',	21199,	16.2,	1.62,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(41,	99,	'108',	21200,	31.55,	3.155,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(42,	99,	'108',	21201,	25,	2.5,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(43,	99,	'108',	21202,	64.5,	6.45,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(44,	99,	'108',	21203,	52.75,	5.275,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(45,	99,	'108',	21204,	23.5,	2.35,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(46,	99,	'108',	21205,	32.5,	3.25,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(47,	99,	'108',	21206,	26.25,	2.625,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(48,	99,	'108',	21207,	31.05,	3.105,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(49,	99,	'108',	21208,	23,	2.3,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(50,	99,	'108',	21209,	23,	2.3,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(51,	99,	'108',	21210,	23,	2.3,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(52,	98,	'120',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(53,	98,	'120',	21228,	261.17,	26.117,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(54,	99,	'126',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(55,	99,	'126',	21233,	20.99,	2.099,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(56,	98,	'127',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(57,	98,	'127',	21234,	239.13,	23.913,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(58,	99,	'129',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(59,	99,	'129',	21238,	40.98,	4.098,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(60,	99,	'131',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(61,	98,	'144',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(62,	98,	'144',	21256,	191.44,	19.144,	'pending',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(63,	98,	'160',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(64,	98,	'161',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(65,	98,	'172',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(66,	102,	'184',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(67,	245,	'246',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(68,	245,	'247',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(69,	245,	'247',	21445,	1345.21,	201.78,	'pending',	'0000-00-00 00:00:00',	'2018-06-30 16:42:03',	'order'),
(70,	254,	'255',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(71,	254,	'255',	21455,	5880.45,	882.07,	'pending',	'0000-00-00 00:00:00',	'2018-07-02 16:39:07',	'order'),
(72,	271,	'272',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(73,	271,	'272',	21482,	8137.79,	1220.67,	'pending',	'0000-00-00 00:00:00',	'2018-07-09 06:21:44',	'order'),
(74,	274,	'275',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(75,	274,	'275',	21487,	7033.31,	1055,	'pending',	'0000-00-00 00:00:00',	'2018-07-10 03:31:51',	'order'),
(76,	17471,	'17472',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(77,	17471,	'17472',	21500,	4814.14,	722.12,	'pending',	'0000-00-00 00:00:00',	'2018-07-13 12:13:35',	'order'),
(78,	17475,	'17476',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(79,	17475,	'17476',	21508,	8019.71,	1202.96,	'pending',	'0000-00-00 00:00:00',	'2018-07-16 18:28:55',	'order'),
(80,	17480,	'17481',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(81,	17480,	'17481',	21513,	8497.59,	1274.64,	'pending',	'0000-00-00 00:00:00',	'2018-07-17 08:24:44',	'order'),
(82,	17482,	'17483',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(83,	17482,	'17483',	21515,	7842.6,	1176.39,	'paid',	'0000-00-00 00:00:00',	'2018-07-17 08:30:29',	'order'),
(84,	17484,	'17485',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(85,	17484,	'17485',	21517,	10800.7,	1620.1,	'paid',	'0000-00-00 00:00:00',	'2018-07-17 15:03:13',	'order'),
(86,	17502,	'17503',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(87,	17502,	'17503',	21547,	8452.83,	1267.92,	'paid',	'0000-00-00 00:00:00',	'2018-07-22 04:56:52',	'order'),
(88,	17502,	'17529',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(89,	17502,	'17529',	21653,	299.94,	44.99,	'pending',	'0000-00-00 00:00:00',	'2018-08-08 04:44:48',	'order'),
(90,	17502,	'17531',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	''),
(91,	17502,	'17531',	21658,	602.78,	90.42,	'pending',	'0000-00-00 00:00:00',	'2018-08-08 14:58:14',	'order'),
(92,	122,	'123',	0,	0,	0.15,	'paid',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'');

CREATE TABLE `ops_affinvoice` (
  `affi_id` int(11) NOT NULL AUTO_INCREMENT,
  `affi_userid` int(11) NOT NULL,
  `affi_affids` varchar(50) NOT NULL,
  `affi_username` varchar(50) NOT NULL,
  `affi_amnt` float NOT NULL,
  `affi_status` varchar(20) NOT NULL,
  `affi_requestdate` datetime NOT NULL,
  `affi_payday` datetime NOT NULL,
  `affi_paymethod` varchar(30) NOT NULL,
  `affi_paydetails` text NOT NULL,
  PRIMARY KEY (`affi_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_affinvoice` (`affi_id`, `affi_userid`, `affi_affids`, `affi_username`, `affi_amnt`, `affi_status`, `affi_requestdate`, `affi_payday`, `affi_paymethod`, `affi_paydetails`) VALUES
(5,	31,	'1',	'C31',	5.76,	'paid',	'2018-04-12 15:11:27',	'2018-04-12 17:00:19',	'payPaly',	'info@opskill.com'),
(7,	17482,	'83',	'C17482',	1176.39,	'paid',	'2018-07-17 14:35:06',	'2018-07-17 14:37:31',	'Paypal',	'jhff@gmail.com'),
(8,	17484,	'85',	'C17484',	1620.1,	'paid',	'2018-07-17 15:25:51',	'2018-07-17 15:27:02',	'Paypal',	'jhffyy@gmail.com'),
(9,	17502,	'87',	'C17499',	1267.92,	'paid',	'2018-07-22 04:58:57',	'2018-07-22 04:59:38',	'Paypal',	'top@gmail.com');

CREATE TABLE `ops_affsettings` (
  `affs_id` int(11) NOT NULL AUTO_INCREMENT,
  `affs_affnumorders` int(11) NOT NULL,
  `affs_paylead` varchar(5) NOT NULL,
  `affs_payday` varchar(100) NOT NULL,
  `affs_rateperaffiliate` float NOT NULL,
  `affs_rateperlead` float NOT NULL,
  `affs_minpay` float NOT NULL,
  PRIMARY KEY (`affs_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_affsettings` (`affs_id`, `affs_affnumorders`, `affs_paylead`, `affs_payday`, `affs_rateperaffiliate`, `affs_rateperlead`, `affs_minpay`) VALUES
(1,	1,	'YES',	'15, 16, 17, 18, 19, 20',	0.15,	0.15,	100);

CREATE TABLE `ops_citations` (
  `citation_id` int(11) NOT NULL AUTO_INCREMENT,
  `citation_name` varchar(50) NOT NULL,
  PRIMARY KEY (`citation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_clientcat` (
  `cat_id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(25) NOT NULL,
  `cat_orders` int(11) NOT NULL,
  `cat_freeorders` int(11) NOT NULL,
  `cat_text` text NOT NULL,
  PRIMARY KEY (`cat_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `ops_clientcat` (`cat_id`, `cat_name`, `cat_orders`, `cat_freeorders`, `cat_text`) VALUES
(1,	'Silver category',	15,	2,	'You qualify for 2 free pages per month. You must have ordered atleast 5 papers within the month to qualify'),
(2,	'Gold category',	30,	3,	'You qualify for 3 free pages per month. You must have ordered at least 5 papers within the month to qualify\r\n'),
(3,	'Platinum category',	60,	5,	'You qualify for 5 free pages per month. You must have ordered at least 5 papers within the month to qualify'),
(4,	'Standard',	0,	0,	'You will qualify for discounts once you have completed at least 5 orders');

CREATE TABLE `ops_countries` (
  `cntry_id` int(11) NOT NULL AUTO_INCREMENT,
  `cntry_iso` char(2) NOT NULL,
  `cntry_name` varchar(80) NOT NULL,
  `cntry_nicename` varchar(80) NOT NULL,
  `cntry_iso3` char(3) DEFAULT NULL,
  `cntry_numcode` smallint(6) DEFAULT NULL,
  `cntry_phonecode` int(5) NOT NULL,
  PRIMARY KEY (`cntry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_countries` (`cntry_id`, `cntry_iso`, `cntry_name`, `cntry_nicename`, `cntry_iso3`, `cntry_numcode`, `cntry_phonecode`) VALUES
(1,	'AF',	'AFGHANISTAN',	'Afghanistan',	'AFG',	4,	93),
(2,	'AL',	'ALBANIA',	'Albania',	'ALB',	8,	355),
(3,	'DZ',	'ALGERIA',	'Algeria',	'DZA',	12,	213),
(4,	'AS',	'AMERICAN SAMOA',	'American Samoa',	'ASM',	16,	1684),
(5,	'AD',	'ANDORRA',	'Andorra',	'AND',	20,	376),
(6,	'AO',	'ANGOLA',	'Angola',	'AGO',	24,	244),
(7,	'AI',	'ANGUILLA',	'Anguilla',	'AIA',	660,	1264),
(8,	'AQ',	'ANTARCTICA',	'Antarctica',	NULL,	NULL,	0),
(9,	'AG',	'ANTIGUA AND BARBUDA',	'Antigua and Barbuda',	'ATG',	28,	1268),
(10,	'AR',	'ARGENTINA',	'Argentina',	'ARG',	32,	54),
(11,	'AM',	'ARMENIA',	'Armenia',	'ARM',	51,	374),
(12,	'AW',	'ARUBA',	'Aruba',	'ABW',	533,	297),
(13,	'AU',	'AUSTRALIA',	'Australia',	'AUS',	36,	61),
(14,	'AT',	'AUSTRIA',	'Austria',	'AUT',	40,	43),
(15,	'AZ',	'AZERBAIJAN',	'Azerbaijan',	'AZE',	31,	994),
(16,	'BS',	'BAHAMAS',	'Bahamas',	'BHS',	44,	1242),
(17,	'BH',	'BAHRAIN',	'Bahrain',	'BHR',	48,	973),
(18,	'BD',	'BANGLADESH',	'Bangladesh',	'BGD',	50,	880),
(19,	'BB',	'BARBADOS',	'Barbados',	'BRB',	52,	1246),
(20,	'BY',	'BELARUS',	'Belarus',	'BLR',	112,	375),
(21,	'BE',	'BELGIUM',	'Belgium',	'BEL',	56,	32),
(22,	'BZ',	'BELIZE',	'Belize',	'BLZ',	84,	501),
(23,	'BJ',	'BENIN',	'Benin',	'BEN',	204,	229),
(24,	'BM',	'BERMUDA',	'Bermuda',	'BMU',	60,	1441),
(25,	'BT',	'BHUTAN',	'Bhutan',	'BTN',	64,	975),
(26,	'BO',	'BOLIVIA',	'Bolivia',	'BOL',	68,	591),
(27,	'BA',	'BOSNIA AND HERZEGOVINA',	'Bosnia and Herzegovina',	'BIH',	70,	387),
(28,	'BW',	'BOTSWANA',	'Botswana',	'BWA',	72,	267),
(29,	'BV',	'BOUVET ISLAND',	'Bouvet Island',	NULL,	NULL,	0),
(30,	'BR',	'BRAZIL',	'Brazil',	'BRA',	76,	55),
(31,	'IO',	'BRITISH INDIAN OCEAN TERRITORY',	'British Indian Ocean Territory',	NULL,	NULL,	246),
(32,	'BN',	'BRUNEI DARUSSALAM',	'Brunei Darussalam',	'BRN',	96,	673),
(33,	'BG',	'BULGARIA',	'Bulgaria',	'BGR',	100,	359),
(34,	'BF',	'BURKINA FASO',	'Burkina Faso',	'BFA',	854,	226),
(35,	'BI',	'BURUNDI',	'Burundi',	'BDI',	108,	257),
(36,	'KH',	'CAMBODIA',	'Cambodia',	'KHM',	116,	855),
(37,	'CM',	'CAMEROON',	'Cameroon',	'CMR',	120,	237),
(38,	'CA',	'CANADA',	'Canada',	'CAN',	124,	1),
(39,	'CV',	'CAPE VERDE',	'Cape Verde',	'CPV',	132,	238),
(40,	'KY',	'CAYMAN ISLANDS',	'Cayman Islands',	'CYM',	136,	1345),
(41,	'CF',	'CENTRAL AFRICAN REPUBLIC',	'Central African Republic',	'CAF',	140,	236),
(42,	'TD',	'CHAD',	'Chad',	'TCD',	148,	235),
(43,	'CL',	'CHILE',	'Chile',	'CHL',	152,	56),
(44,	'CN',	'CHINA',	'China',	'CHN',	156,	86),
(45,	'CX',	'CHRISTMAS ISLAND',	'Christmas Island',	NULL,	NULL,	61),
(46,	'CC',	'COCOS (KEELING) ISLANDS',	'Cocos (Keeling) Islands',	NULL,	NULL,	672),
(47,	'CO',	'COLOMBIA',	'Colombia',	'COL',	170,	57),
(48,	'KM',	'COMOROS',	'Comoros',	'COM',	174,	269),
(49,	'CG',	'CONGO',	'Congo',	'COG',	178,	242),
(50,	'CD',	'CONGO, THE DEMOCRATIC REPUBLIC OF THE',	'Congo, the Democratic Republic of the',	'COD',	180,	242),
(51,	'CK',	'COOK ISLANDS',	'Cook Islands',	'COK',	184,	682),
(52,	'CR',	'COSTA RICA',	'Costa Rica',	'CRI',	188,	506),
(53,	'CI',	'COTE D\'IVOIRE',	'Cote D\'Ivoire',	'CIV',	384,	225),
(54,	'HR',	'CROATIA',	'Croatia',	'HRV',	191,	385),
(55,	'CU',	'CUBA',	'Cuba',	'CUB',	192,	53),
(56,	'CY',	'CYPRUS',	'Cyprus',	'CYP',	196,	357),
(57,	'CZ',	'CZECH REPUBLIC',	'Czech Republic',	'CZE',	203,	420),
(58,	'DK',	'DENMARK',	'Denmark',	'DNK',	208,	45),
(59,	'DJ',	'DJIBOUTI',	'Djibouti',	'DJI',	262,	253),
(60,	'DM',	'DOMINICA',	'Dominica',	'DMA',	212,	1767),
(61,	'DO',	'DOMINICAN REPUBLIC',	'Dominican Republic',	'DOM',	214,	1809),
(62,	'EC',	'ECUADOR',	'Ecuador',	'ECU',	218,	593),
(63,	'EG',	'EGYPT',	'Egypt',	'EGY',	818,	20),
(64,	'SV',	'EL SALVADOR',	'El Salvador',	'SLV',	222,	503),
(65,	'GQ',	'EQUATORIAL GUINEA',	'Equatorial Guinea',	'GNQ',	226,	240),
(66,	'ER',	'ERITREA',	'Eritrea',	'ERI',	232,	291),
(67,	'EE',	'ESTONIA',	'Estonia',	'EST',	233,	372),
(68,	'ET',	'ETHIOPIA',	'Ethiopia',	'ETH',	231,	251),
(69,	'FK',	'FALKLAND ISLANDS (MALVINAS)',	'Falkland Islands (Malvinas)',	'FLK',	238,	500),
(70,	'FO',	'FAROE ISLANDS',	'Faroe Islands',	'FRO',	234,	298),
(71,	'FJ',	'FIJI',	'Fiji',	'FJI',	242,	679),
(72,	'FI',	'FINLAND',	'Finland',	'FIN',	246,	358),
(73,	'FR',	'FRANCE',	'France',	'FRA',	250,	33),
(74,	'GF',	'FRENCH GUIANA',	'French Guiana',	'GUF',	254,	594),
(75,	'PF',	'FRENCH POLYNESIA',	'French Polynesia',	'PYF',	258,	689),
(76,	'TF',	'FRENCH SOUTHERN TERRITORIES',	'French Southern Territories',	NULL,	NULL,	0),
(77,	'GA',	'GABON',	'Gabon',	'GAB',	266,	241),
(78,	'GM',	'GAMBIA',	'Gambia',	'GMB',	270,	220),
(79,	'GE',	'GEORGIA',	'Georgia',	'GEO',	268,	995),
(80,	'DE',	'GERMANY',	'Germany',	'DEU',	276,	49),
(81,	'GH',	'GHANA',	'Ghana',	'GHA',	288,	233),
(82,	'GI',	'GIBRALTAR',	'Gibraltar',	'GIB',	292,	350),
(83,	'GR',	'GREECE',	'Greece',	'GRC',	300,	30),
(84,	'GL',	'GREENLAND',	'Greenland',	'GRL',	304,	299),
(85,	'GD',	'GRENADA',	'Grenada',	'GRD',	308,	1473),
(86,	'GP',	'GUADELOUPE',	'Guadeloupe',	'GLP',	312,	590),
(87,	'GU',	'GUAM',	'Guam',	'GUM',	316,	1671),
(88,	'GT',	'GUATEMALA',	'Guatemala',	'GTM',	320,	502),
(89,	'GN',	'GUINEA',	'Guinea',	'GIN',	324,	224),
(90,	'GW',	'GUINEA-BISSAU',	'Guinea-Bissau',	'GNB',	624,	245),
(91,	'GY',	'GUYANA',	'Guyana',	'GUY',	328,	592),
(92,	'HT',	'HAITI',	'Haiti',	'HTI',	332,	509),
(93,	'HM',	'HEARD ISLAND AND MCDONALD ISLANDS',	'Heard Island and Mcdonald Islands',	NULL,	NULL,	0),
(94,	'VA',	'HOLY SEE (VATICAN CITY STATE)',	'Holy See (Vatican City State)',	'VAT',	336,	39),
(95,	'HN',	'HONDURAS',	'Honduras',	'HND',	340,	504),
(96,	'HK',	'HONG KONG',	'Hong Kong',	'HKG',	344,	852),
(97,	'HU',	'HUNGARY',	'Hungary',	'HUN',	348,	36),
(98,	'IS',	'ICELAND',	'Iceland',	'ISL',	352,	354),
(99,	'IN',	'INDIA',	'India',	'IND',	356,	91),
(100,	'ID',	'INDONESIA',	'Indonesia',	'IDN',	360,	62),
(101,	'IR',	'IRAN, ISLAMIC REPUBLIC OF',	'Iran, Islamic Republic of',	'IRN',	364,	98),
(102,	'IQ',	'IRAQ',	'Iraq',	'IRQ',	368,	964),
(103,	'IE',	'IRELAND',	'Ireland',	'IRL',	372,	353),
(104,	'IL',	'ISRAEL',	'Israel',	'ISR',	376,	972),
(105,	'IT',	'ITALY',	'Italy',	'ITA',	380,	39),
(106,	'JM',	'JAMAICA',	'Jamaica',	'JAM',	388,	1876),
(107,	'JP',	'JAPAN',	'Japan',	'JPN',	392,	81),
(108,	'JO',	'JORDAN',	'Jordan',	'JOR',	400,	962),
(109,	'KZ',	'KAZAKHSTAN',	'Kazakhstan',	'KAZ',	398,	7),
(110,	'KE',	'KENYA',	'Kenya',	'KEN',	404,	254),
(111,	'KI',	'KIRIBATI',	'Kiribati',	'KIR',	296,	686),
(112,	'KP',	'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF',	'Korea, Democratic People\'s Republic of',	'PRK',	408,	850),
(113,	'KR',	'KOREA, REPUBLIC OF',	'Korea, Republic of',	'KOR',	410,	82),
(114,	'KW',	'KUWAIT',	'Kuwait',	'KWT',	414,	965),
(115,	'KG',	'KYRGYZSTAN',	'Kyrgyzstan',	'KGZ',	417,	996),
(116,	'LA',	'LAO PEOPLE\'S DEMOCRATIC REPUBLIC',	'Lao People\'s Democratic Republic',	'LAO',	418,	856),
(117,	'LV',	'LATVIA',	'Latvia',	'LVA',	428,	371),
(118,	'LB',	'LEBANON',	'Lebanon',	'LBN',	422,	961),
(119,	'LS',	'LESOTHO',	'Lesotho',	'LSO',	426,	266),
(120,	'LR',	'LIBERIA',	'Liberia',	'LBR',	430,	231),
(121,	'LY',	'LIBYAN ARAB JAMAHIRIYA',	'Libyan Arab Jamahiriya',	'LBY',	434,	218),
(122,	'LI',	'LIECHTENSTEIN',	'Liechtenstein',	'LIE',	438,	423),
(123,	'LT',	'LITHUANIA',	'Lithuania',	'LTU',	440,	370),
(124,	'LU',	'LUXEMBOURG',	'Luxembourg',	'LUX',	442,	352),
(125,	'MO',	'MACAO',	'Macao',	'MAC',	446,	853),
(126,	'MK',	'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF',	'Macedonia, the Former Yugoslav Republic of',	'MKD',	807,	389),
(127,	'MG',	'MADAGASCAR',	'Madagascar',	'MDG',	450,	261),
(128,	'MW',	'MALAWI',	'Malawi',	'MWI',	454,	265),
(129,	'MY',	'MALAYSIA',	'Malaysia',	'MYS',	458,	60),
(130,	'MV',	'MALDIVES',	'Maldives',	'MDV',	462,	960),
(131,	'ML',	'MALI',	'Mali',	'MLI',	466,	223),
(132,	'MT',	'MALTA',	'Malta',	'MLT',	470,	356),
(133,	'MH',	'MARSHALL ISLANDS',	'Marshall Islands',	'MHL',	584,	692),
(134,	'MQ',	'MARTINIQUE',	'Martinique',	'MTQ',	474,	596),
(135,	'MR',	'MAURITANIA',	'Mauritania',	'MRT',	478,	222),
(136,	'MU',	'MAURITIUS',	'Mauritius',	'MUS',	480,	230),
(137,	'YT',	'MAYOTTE',	'Mayotte',	NULL,	NULL,	269),
(138,	'MX',	'MEXICO',	'Mexico',	'MEX',	484,	52),
(139,	'FM',	'MICRONESIA, FEDERATED STATES OF',	'Micronesia, Federated States of',	'FSM',	583,	691),
(140,	'MD',	'MOLDOVA, REPUBLIC OF',	'Moldova, Republic of',	'MDA',	498,	373),
(141,	'MC',	'MONACO',	'Monaco',	'MCO',	492,	377),
(142,	'MN',	'MONGOLIA',	'Mongolia',	'MNG',	496,	976),
(143,	'MS',	'MONTSERRAT',	'Montserrat',	'MSR',	500,	1664),
(144,	'MA',	'MOROCCO',	'Morocco',	'MAR',	504,	212),
(145,	'MZ',	'MOZAMBIQUE',	'Mozambique',	'MOZ',	508,	258),
(146,	'MM',	'MYANMAR',	'Myanmar',	'MMR',	104,	95),
(147,	'NA',	'NAMIBIA',	'Namibia',	'NAM',	516,	264),
(148,	'NR',	'NAURU',	'Nauru',	'NRU',	520,	674),
(149,	'NP',	'NEPAL',	'Nepal',	'NPL',	524,	977),
(150,	'NL',	'NETHERLANDS',	'Netherlands',	'NLD',	528,	31),
(151,	'AN',	'NETHERLANDS ANTILLES',	'Netherlands Antilles',	'ANT',	530,	599),
(152,	'NC',	'NEW CALEDONIA',	'New Caledonia',	'NCL',	540,	687),
(153,	'NZ',	'NEW ZEALAND',	'New Zealand',	'NZL',	554,	64),
(154,	'NI',	'NICARAGUA',	'Nicaragua',	'NIC',	558,	505),
(155,	'NE',	'NIGER',	'Niger',	'NER',	562,	227),
(156,	'NG',	'NIGERIA',	'Nigeria',	'NGA',	566,	234),
(157,	'NU',	'NIUE',	'Niue',	'NIU',	570,	683),
(158,	'NF',	'NORFOLK ISLAND',	'Norfolk Island',	'NFK',	574,	672),
(159,	'MP',	'NORTHERN MARIANA ISLANDS',	'Northern Mariana Islands',	'MNP',	580,	1670),
(160,	'NO',	'NORWAY',	'Norway',	'NOR',	578,	47),
(161,	'OM',	'OMAN',	'Oman',	'OMN',	512,	968),
(162,	'PK',	'PAKISTAN',	'Pakistan',	'PAK',	586,	92),
(163,	'PW',	'PALAU',	'Palau',	'PLW',	585,	680),
(164,	'PS',	'PALESTINIAN TERRITORY, OCCUPIED',	'Palestinian Territory, Occupied',	NULL,	NULL,	970),
(165,	'PA',	'PANAMA',	'Panama',	'PAN',	591,	507),
(166,	'PG',	'PAPUA NEW GUINEA',	'Papua New Guinea',	'PNG',	598,	675),
(167,	'PY',	'PARAGUAY',	'Paraguay',	'PRY',	600,	595),
(168,	'PE',	'PERU',	'Peru',	'PER',	604,	51),
(169,	'PH',	'PHILIPPINES',	'Philippines',	'PHL',	608,	63),
(170,	'PN',	'PITCAIRN',	'Pitcairn',	'PCN',	612,	0),
(171,	'PL',	'POLAND',	'Poland',	'POL',	616,	48),
(172,	'PT',	'PORTUGAL',	'Portugal',	'PRT',	620,	351),
(173,	'PR',	'PUERTO RICO',	'Puerto Rico',	'PRI',	630,	1787),
(174,	'QA',	'QATAR',	'Qatar',	'QAT',	634,	974),
(175,	'RE',	'REUNION',	'Reunion',	'REU',	638,	262),
(176,	'RO',	'ROMANIA',	'Romania',	'ROM',	642,	40),
(177,	'RU',	'RUSSIAN FEDERATION',	'Russian Federation',	'RUS',	643,	70),
(178,	'RW',	'RWANDA',	'Rwanda',	'RWA',	646,	250),
(179,	'SH',	'SAINT HELENA',	'Saint Helena',	'SHN',	654,	290),
(180,	'KN',	'SAINT KITTS AND NEVIS',	'Saint Kitts and Nevis',	'KNA',	659,	1869),
(181,	'LC',	'SAINT LUCIA',	'Saint Lucia',	'LCA',	662,	1758),
(182,	'PM',	'SAINT PIERRE AND MIQUELON',	'Saint Pierre and Miquelon',	'SPM',	666,	508),
(183,	'VC',	'SAINT VINCENT AND THE GRENADINES',	'Saint Vincent and the Grenadines',	'VCT',	670,	1784),
(184,	'WS',	'SAMOA',	'Samoa',	'WSM',	882,	684),
(185,	'SM',	'SAN MARINO',	'San Marino',	'SMR',	674,	378),
(186,	'ST',	'SAO TOME AND PRINCIPE',	'Sao Tome and Principe',	'STP',	678,	239),
(187,	'SA',	'SAUDI ARABIA',	'Saudi Arabia',	'SAU',	682,	966),
(188,	'SN',	'SENEGAL',	'Senegal',	'SEN',	686,	221),
(189,	'CS',	'SERBIA AND MONTENEGRO',	'Serbia and Montenegro',	NULL,	NULL,	381),
(190,	'SC',	'SEYCHELLES',	'Seychelles',	'SYC',	690,	248),
(191,	'SL',	'SIERRA LEONE',	'Sierra Leone',	'SLE',	694,	232),
(192,	'SG',	'SINGAPORE',	'Singapore',	'SGP',	702,	65),
(193,	'SK',	'SLOVAKIA',	'Slovakia',	'SVK',	703,	421),
(194,	'SI',	'SLOVENIA',	'Slovenia',	'SVN',	705,	386),
(195,	'SB',	'SOLOMON ISLANDS',	'Solomon Islands',	'SLB',	90,	677),
(196,	'SO',	'SOMALIA',	'Somalia',	'SOM',	706,	252),
(197,	'ZA',	'SOUTH AFRICA',	'South Africa',	'ZAF',	710,	27),
(198,	'GS',	'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS',	'South Georgia and the South Sandwich Islands',	NULL,	NULL,	0),
(199,	'ES',	'SPAIN',	'Spain',	'ESP',	724,	34),
(200,	'LK',	'SRI LANKA',	'Sri Lanka',	'LKA',	144,	94),
(201,	'SD',	'SUDAN',	'Sudan',	'SDN',	736,	249),
(202,	'SR',	'SURINAME',	'Suriname',	'SUR',	740,	597),
(203,	'SJ',	'SVALBARD AND JAN MAYEN',	'Svalbard and Jan Mayen',	'SJM',	744,	47),
(204,	'SZ',	'SWAZILAND',	'Swaziland',	'SWZ',	748,	268),
(205,	'SE',	'SWEDEN',	'Sweden',	'SWE',	752,	46),
(206,	'CH',	'SWITZERLAND',	'Switzerland',	'CHE',	756,	41),
(207,	'SY',	'SYRIAN ARAB REPUBLIC',	'Syrian Arab Republic',	'SYR',	760,	963),
(208,	'TW',	'TAIWAN, PROVINCE OF CHINA',	'Taiwan, Province of China',	'TWN',	158,	886),
(209,	'TJ',	'TAJIKISTAN',	'Tajikistan',	'TJK',	762,	992),
(210,	'TZ',	'TANZANIA, UNITED REPUBLIC OF',	'Tanzania, United Republic of',	'TZA',	834,	255),
(211,	'TH',	'THAILAND',	'Thailand',	'THA',	764,	66),
(212,	'TL',	'TIMOR-LESTE',	'Timor-Leste',	NULL,	NULL,	670),
(213,	'TG',	'TOGO',	'Togo',	'TGO',	768,	228),
(214,	'TK',	'TOKELAU',	'Tokelau',	'TKL',	772,	690),
(215,	'TO',	'TONGA',	'Tonga',	'TON',	776,	676),
(216,	'TT',	'TRINIDAD AND TOBAGO',	'Trinidad and Tobago',	'TTO',	780,	1868),
(217,	'TN',	'TUNISIA',	'Tunisia',	'TUN',	788,	216),
(218,	'TR',	'TURKEY',	'Turkey',	'TUR',	792,	90),
(219,	'TM',	'TURKMENISTAN',	'Turkmenistan',	'TKM',	795,	7370),
(220,	'TC',	'TURKS AND CAICOS ISLANDS',	'Turks and Caicos Islands',	'TCA',	796,	1649),
(221,	'TV',	'TUVALU',	'Tuvalu',	'TUV',	798,	688),
(222,	'UG',	'UGANDA',	'Uganda',	'UGA',	800,	256),
(223,	'UA',	'UKRAINE',	'Ukraine',	'UKR',	804,	380),
(224,	'AE',	'UNITED ARAB EMIRATES',	'United Arab Emirates',	'ARE',	784,	971),
(225,	'GB',	'UNITED KINGDOM',	'United Kingdom',	'GBR',	826,	44),
(226,	'US',	'UNITED STATES',	'United States',	'USA',	840,	1),
(227,	'UM',	'UNITED STATES MINOR OUTLYING ISLANDS',	'United States Minor Outlying Islands',	NULL,	NULL,	1),
(228,	'UY',	'URUGUAY',	'Uruguay',	'URY',	858,	598),
(229,	'UZ',	'UZBEKISTAN',	'Uzbekistan',	'UZB',	860,	998),
(230,	'VU',	'VANUATU',	'Vanuatu',	'VUT',	548,	678),
(231,	'VE',	'VENEZUELA',	'Venezuela',	'VEN',	862,	58),
(232,	'VN',	'VIET NAM',	'Viet Nam',	'VNM',	704,	84),
(233,	'VG',	'VIRGIN ISLANDS, BRITISH',	'Virgin Islands, British',	'VGB',	92,	1284),
(234,	'VI',	'VIRGIN ISLANDS, U.S.',	'Virgin Islands, U.s.',	'VIR',	850,	1340),
(235,	'WF',	'WALLIS AND FUTUNA',	'Wallis and Futuna',	'WLF',	876,	681),
(236,	'EH',	'WESTERN SAHARA',	'Western Sahara',	'ESH',	732,	212),
(237,	'YE',	'YEMEN',	'Yemen',	'YEM',	887,	967),
(238,	'ZM',	'ZAMBIA',	'Zambia',	'ZMB',	894,	260),
(239,	'ZW',	'ZIMBABWE',	'Zimbabwe',	'ZWE',	716,	263);

CREATE TABLE `ops_coupons` (
  `cpn_id` int(11) NOT NULL AUTO_INCREMENT,
  `cpn_value` float NOT NULL,
  `cpn_invalue` int(11) NOT NULL,
  `cpn_name` varchar(20) NOT NULL,
  `cpn_active` int(11) NOT NULL,
  `cpn_type` varchar(25) NOT NULL,
  `cpn_times` int(11) NOT NULL,
  `cpn_mode` varchar(25) NOT NULL,
  `cpn_client` int(11) NOT NULL,
  PRIMARY KEY (`cpn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_coupons` (`cpn_id`, `cpn_value`, `cpn_invalue`, `cpn_name`, `cpn_active`, `cpn_type`, `cpn_times`, `cpn_mode`, `cpn_client`) VALUES
(150,	0.85,	15,	'welcome15',	0,	'new',	66,	'',	0),
(154,	0.85,	15,	'FIRST15',	0,	'new',	99,	'',	0),
(153,	0.85,	15,	'FIRST15',	0,	'repeat',	1,	'',	0),
(155,	0.85,	15,	'welcome15',	0,	'repeat',	894,	'',	0),
(156,	0.9,	10,	'Get10',	0,	'new',	1,	'',	0),
(157,	0.85,	15,	'welcome15 ',	0,	'new',	2,	'',	0),
(162,	0.75,	25,	'NEW25DIS',	0,	'new',	99,	'',	0),
(163,	0.75,	25,	'NEW25DIS',	0,	'repeat',	10,	'',	0);

CREATE TABLE `ops_currencies` (
  `curr_id` int(11) NOT NULL AUTO_INCREMENT,
  `curr_name` varchar(25) NOT NULL,
  `curr_value` float NOT NULL,
  `curr_symbol` varchar(25) NOT NULL,
  `curr_enabled` int(11) NOT NULL,
  PRIMARY KEY (`curr_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_currencies` (`curr_id`, `curr_name`, `curr_value`, `curr_symbol`, `curr_enabled`) VALUES
(1,	'USD',	1,	'$',	1),
(2,	'GBP',	0.83,	'£',	1),
(3,	'EUR',	0.92,	'€',	1),
(4,	'AUD',	1.44,	'',	1);

CREATE TABLE `ops_essays` (
  `essay_id` int(11) NOT NULL AUTO_INCREMENT,
  `essay_topic` varchar(225) NOT NULL,
  `essay_content` text NOT NULL,
  `essay_date` varchar(75) NOT NULL,
  PRIMARY KEY (`essay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_essays` (`essay_id`, `essay_topic`, `essay_content`, `essay_date`) VALUES
(10,	'Is academic Writing ethical?',	'<p>Is academic Writing ethical? Explain this in minimum 500 words. You MUST employ critical thinking in writing this article</p>',	'June 16, 2019, 12:26 pm');

CREATE TABLE `ops_invoices` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_from` varchar(25) NOT NULL,
  `invoice_wrid` int(11) NOT NULL,
  `invoice_edid` int(11) NOT NULL,
  `invoice_orderids` varchar(200) DEFAULT NULL,
  `invoice_wrname` varchar(100) NOT NULL,
  `invoice_orderamnt` float NOT NULL,
  `invoice_date` datetime NOT NULL,
  `invoice_ordertitles` varchar(200) NOT NULL,
  `invoice_payout` text NOT NULL,
  `invoice_paydetails` text NOT NULL,
  `invoice_status` varchar(10) NOT NULL,
  `payment_details` text NOT NULL,
  `invoice_payday` datetime NOT NULL,
  `invoice_finereason` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_news` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_date` varchar(75) NOT NULL,
  `news_department` varchar(125) NOT NULL,
  `news_subject` varchar(225) NOT NULL,
  `news_content` text NOT NULL,
  PRIMARY KEY (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_news` (`news_id`, `news_date`, `news_department`, `news_subject`, `news_content`) VALUES
(4,	'June 15, 2019, 11:23 am',	'Writers Department',	'Quality Issues',	'<p>Dear writer,</p><p>It has drawn our attention that recently we have had issues of quality, grammar and syntax errors. Kindly note we have rolled out a penalty policy for any orders with the above mentioned issues. Before submitting your paper, always ensure you have read through and correct all the mistakes. Don\\\'t be a victim of these penalties. Our point should be home now. Thank you</p><p>&nbsp;</p><p>Writers Department</p>'),
(5,	'July 3, 2019, 5:01 am',	'Payment Department',	'Payment for period 15th - 30th June',	'<p>Dear writer,</p><p>Payments will be released before the 5th of July. Kindly ensure you have updated your correct payment details preferably an account with Equity bank. Thank you for all your hard-work.</p><p>&nbsp;</p><p>Kind regards,</p><p>Payment Team</p>');

CREATE TABLE `ops_orderbids` (
  `bid_id` int(11) NOT NULL AUTO_INCREMENT,
  `bid_orderid` int(11) NOT NULL,
  `bid_writer` int(11) NOT NULL,
  `bid_wrnickname` varchar(200) NOT NULL,
  `bid_writername` int(11) NOT NULL,
  `bid_wrratings` varchar(5) NOT NULL,
  `bid_client` int(11) NOT NULL,
  `bid_adprice` varchar(50) NOT NULL,
  `bid_perpage` float NOT NULL,
  `bid_perpagetotal` float NOT NULL,
  `bid_date` datetime NOT NULL,
  PRIMARY KEY (`bid_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_orderfiles` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `file_orderid` int(11) NOT NULL,
  `file_name` varchar(255) DEFAULT NULL,
  `file_uploadertype` varchar(25) NOT NULL,
  `file_title` varchar(200) NOT NULL,
  `file_size` int(11) NOT NULL,
  `file_token` varchar(255) DEFAULT NULL,
  `file_update` datetime NOT NULL,
  `file_uploaderid` int(11) NOT NULL,
  `file_uploadername` varchar(100) NOT NULL,
  `file_url` varchar(250) NOT NULL,
  `file_userip` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`file_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Multiple File upload in Codeigniter ';


CREATE TABLE `ops_ordermsg` (
  `msg_id` int(11) NOT NULL AUTO_INCREMENT,
  `msg_orderid` int(11) NOT NULL,
  `msg_to` varchar(25) NOT NULL,
  `msg_senderid` int(11) NOT NULL,
  `msg_sendername` varchar(30) NOT NULL,
  `msg_body` text NOT NULL,
  `msg_date` datetime NOT NULL,
  `msg_sendertype` varchar(25) NOT NULL,
  `msg_adread` int(11) NOT NULL,
  `msg_clread` int(11) NOT NULL,
  `msg_wrread` int(11) NOT NULL,
  `msg_approved` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_ordermsg` (`msg_id`, `msg_orderid`, `msg_to`, `msg_senderid`, `msg_sendername`, `msg_body`, `msg_date`, `msg_sendertype`, `msg_adread`, `msg_clread`, `msg_wrread`, `msg_approved`) VALUES
(1,	70059,	'support',	58,	'C58',	'hello your paper is complete.. first file has a wordcount of 1500 words',	'2022-09-01 13:58:13',	'client',	1,	1,	0,	NULL),
(2,	70078,	'client',	53345,	'Support Team',	'thanks for placing an order. we have worked on it according to the given instructions.',	'2022-09-15 22:14:12',	'support',	1,	0,	0,	NULL),
(3,	70074,	'writer',	61,	'C61',	'Omg thank you! I didn\\\'t realise how quickly you completed it and how good it is!! I want to tip you. I will submit this soon and when i receive my mark i will tip accordingly to how well it goes. THANK YOU again! ????',	'2022-09-16 14:21:09',	'client',	1,	1,	0,	NULL),
(4,	70081,	'writer',	74,	'C74',	'Hello, do you think you will be able to complete this in the next 24 hours please?',	'2022-09-26 01:08:53',	'client',	1,	1,	0,	NULL),
(5,	70085,	'writer',	76,	'C76',	'waiting for this order files',	'2022-09-28 10:20:30',	'client',	1,	1,	0,	NULL),
(6,	70096,	'client',	53345,	'Support Team',	'working on your order',	'2022-10-04 04:01:01',	'support',	1,	1,	0,	NULL),
(29,	70118,	'client',	53345,	'Support Team',	'Yes we are redoing the paper now. You should get a completed paper in two hours or so',	'2022-12-28 09:29:24',	'support',	1,	1,	0,	'1'),
(30,	70113,	'writer',	91,	'C91',	'This is the wrong structure and answer to the case study,\r\nThe case study requires answering the following questions by dividing the essay into 5 sections:\r\n1. hypothesis on the client\\\'s presenting issue according to both theories \r\na) CBT - discuss the theory in relation to the client issue\r\nB) EFT - discuss the theory in relation to the client issue\r\n2.  each modality (CBT & EFT) specific interventions that you would employ in session with the case study - client, providing rationale for your answer\r\n3.  each modality specific case formulation for future consideration (attach each modality formulation to fill in according to the case study) and then discuss each in paragraphs.\r\n4. limitations of each modality if used slowly and separately with the case study – discussing what aspects of the client situation do you believe would not be adequately addressed by each approach solely? \r\n5. Based on your discussion, which modality would you choose to use with this client? Provide a c lear rationale for your decision.\r\nPlease note: the answer about the limitation to CBT that you provided in relation to schizophrenia was wrong and has no scientific evidence. Thanks\r\n ',	'2022-12-28 11:55:53',	'client',	1,	1,	0,	'1'),
(8,	70088,	'writer',	54,	'C54',	'Hi Gabriel.\r\nI am happy for it to be written for the new unit and to fix it to make it the best possible unit. I got permission from the instructor to work on the new unit that I will be teaching. I will get the second question on October 7th.',	'2022-10-04 09:04:52',	'client',	1,	1,	0,	NULL),
(9,	70097,	'client',	53345,	'Support Team',	'65 usd is equal to 100 aud',	'2022-10-04 09:46:05',	'support',	1,	1,	0,	NULL),
(17,	70110,	'client',	53345,	'Support Team',	'The 50% discount will be implemented on your next orders as you did not use the code during checkout. Will make sure we make up for the difference on your next assignments\r\n',	'2022-12-19 15:05:16',	'support',	1,	1,	0,	'1'),
(18,	70115,	'writer',	92,	'C92',	'Please use PsycPro software to answer ',	'2022-12-20 05:00:16',	'client',	1,	1,	0,	'1'),
(19,	70113,	'client',	53345,	'Support Team',	'Order delivered',	'2022-12-21 13:34:38',	'support',	1,	1,	0,	'1'),
(20,	70118,	'writer',	91,	'C91',	'Hi there, this is a master\\\'s degree study work not undergraduate one. how can I edit my order',	'2022-12-25 12:33:37',	'client',	1,	1,	0,	'1'),
(21,	70118,	'support',	91,	'C91',	'Hi there, this is a master\\\'s degree study work not undergraduate one. how can I edit my order',	'2022-12-25 12:34:08',	'client',	1,	1,	0,	'1'),
(22,	70118,	'client',	53345,	'Support Team',	'you can just edit it on the orders page. will work on it and tell you the difference in price',	'2022-12-27 13:14:47',	'support',	1,	1,	0,	'1'),
(23,	70118,	'writer',	91,	'C91',	'Hi there, this is not what was requested. The order was a presentation on grief parents after an autism diagnosis and how this related to working as a counsellor within the field of grief, loss and/or attachment.\r\nIt is also a PowerPoint presentation, not an essay.\r\ncould you please let me know when the requested order will be completed? Thanks',	'2022-12-28 05:23:37',	'client',	1,	1,	0,	'1'),
(24,	70119,	'writer',	91,	'C91',	'What is the reference and citation for the following paragraph:\r\nAlso, the development and prevalence of eating disorders are significantly influenced by stressful emotions. Emotions must be suppressed by those who have eating disorders because they are hazardous and intolerable. Given that the eating disorder is used to evade or soothe unpleasant feelings, therapy must explicitly pay attention to and accommodate experienced emotion to enable it to encounter and improve one\\\'s ability to embrace, modulate, soothe, and change it. Instead of believing their only option is to keep attempting harder to transform from intransigent eating patterns in the absence of an alternative to handling their distress, individuals experience rekindled hope in the prospect that they may change and enhance their eating disorder by working to recognise and alter emotion schemes.\r\nCould you please add the reference to the reference page? Thanks',	'2022-12-28 05:35:46',	'client',	1,	1,	0,	'1'),
(25,	70119,	'client',	53345,	'Support Team',	'will do. thanks',	'2022-12-28 07:51:26',	'support',	1,	1,	0,	'1'),
(26,	70119,	'client',	53345,	'Support Team',	'revised',	'2022-12-28 08:29:52',	'support',	1,	1,	0,	'1'),
(27,	70118,	'support',	91,	'C91',	'Hi there, this is not what was requested. The order was a PowerPoint presentation on how parents experience grief after their child was diagnosed with autism spectrum disorder ASD and how this related to working as a counsellor within the field of grief, loss and/or attachment. It is also a PowerPoint presentation, not an essay. Could you please let me know when the requested order will be completed? Thanks\r\n28 Dec 2022',	'2022-12-28 09:27:41',	'client',	1,	1,	0,	'1'),
(28,	70118,	'writer',	91,	'C91',	'Hi there, this is not what was requested. The order was a PowerPoint presentation on how parents experience grief after their child was diagnosed with autism spectrum disorder ASD and how this related to working as a counsellor within the field of grief, loss and/or attachment. It is also a PowerPoint presentation, not an essay. Could you please let me know when the requested order will be completed? Thanks\r\n28 Dec 2022',	'2022-12-28 09:28:02',	'client',	1,	1,	0,	'1'),
(15,	70110,	'client',	53345,	'Support Team',	'Payment received . Writer has been assigned',	'2022-12-19 14:57:35',	'support',	1,	1,	0,	'1'),
(16,	70110,	'support',	91,	'C91',	'I placed an order but am not sure why I didn\\\'t get the 50% discount. Could you please clarify?',	'2022-12-19 14:58:36',	'client',	1,	1,	0,	'1'),
(12,	70061,	'writer',	61,	'C61',	'FYI feedback report and results is attached to the Order files',	'2022-10-08 01:34:58',	'client',	1,	1,	0,	NULL),
(31,	70113,	'client',	53345,	'Support Team',	'revising accordingly',	'2022-12-28 14:12:25',	'support',	1,	1,	0,	'1'),
(32,	70118,	'support',	91,	'C91',	'Hi there,\r\nI believe the writer does not understand the topic requested.\r\nWould you please change the writer to someone who understands Autism Spectrum disorder and its grief effect on parents who receive the diagnosis for their child?\r\nI have attached an article to the writer, yet he did not use any of the information when making the presentation, even after editing it ',	'2022-12-29 04:35:44',	'client',	1,	1,	0,	'1'),
(33,	70113,	'client',	53345,	'Support Team',	'revised',	'2022-12-29 05:30:04',	'support',	1,	1,	0,	'1'),
(34,	70118,	'client',	53345,	'Support Team',	'ok changing writer',	'2022-12-29 05:31:14',	'support',	1,	1,	0,	'1'),
(35,	70118,	'client',	53345,	'Support Team',	'please attach the article here again so that the other writer can work on it',	'2022-12-29 05:35:00',	'support',	1,	1,	0,	'1'),
(36,	70118,	'support',	91,	'C91',	'https://www.adhd.com.au/autism/parental-grief-and-adaptation-asd\r\n\r\nParental Grief and Adaptation in ASD\r\nBOWLBY\\\\\\\\\\\\\\\'S ATTACHMENT THEORY\r\n\r\nDIMENSIONS OF GRIEF\r\n\r\nBEHAVIOURS\r\n\r\nDETERMINANTS OF GRIEF\r\n\r\nADAPTATION TO LOSS\r\n\r\nCOUNSELLING FOR PARENTS\r\n\r\nREQUIRED TEXTS\r\n\r\nWorden, J. (2018). Grief counselling & grief therapy: A handbook for the mental health practitioner (5th ed.). New York: Springer.\r\n\r\n \r\n\r\nRECOMMENDED TEXTS/BIBLIOGRAPHY \r\n\r\nAttig, T. (1991). The importance of conceiving of grief as an active process. Death Studies, 15 (4), 385-394 Attig, T. (2001). How we grieve: Relearning the world. In R. Neimeyer (Ed.), Meaning reconstruction & the meaning of loss (pp. 33- 53). Washington DC: American Psychological Association Fiorini, J., & Mullen, J. (2006). Counselling children and adolescents through grief and loss. Illinois: Research Press Harris, D., & Winokuer, H. (2016). Principles and practice of grief counselling. NY: Springer Publishing Company Humphrey, K.M. (2009). Counselling strategies for loss and grief. Alexandria, VA.: American Counselling Association Klass, D., Silverman, P.R. & Nickman, S.L. (1996). Continuing bonds: New understandings of grief. Philadelphia: Taylor & Francis Neimeyer, R. (2012). Techniques of grief therapy: Creative practices for counselling the bereaved. Routledge Neimeyer, R. (2016). Techniques of grief therapy: Assessment and intervention, Routledge RECOMMENDED \r\n\r\n \r\n\r\nJOURNALS Grief Matters: The Australian Journal of Grief & Bereavement Journal of Loss and Trauma RECOMMENDED \r\n\r\n \r\n\r\nWEBSITES Australian Centre for Grief and Bereavement: www.grief.org.au Centre for Loss and Life Transition https://www.centerforloss.com\r\n\r\n \r\n\r\nAlthough most people are able to independently work through the broad range of reactions that follow the diagnosis of their child, some experience difficulty in resolving their feelings and emotions and may seek counselling to help them resolve their pain and clarify their thoughts. \r\n\r\nCounselling include; \r\n\r\n(a) helping the person to accept the reality that their child has a disorder; \r\n\r\n(b) assisting the person to work through the emotions of anger, guilt, anxiety and helplessness that he or she is feeling; and \r\n\r\n(c) reassuring the person that what he or she is experiencing is normal. \r\n\r\nStudents will research and appraise grief parents after an autism diagnosis and how this related to working as a counsellor within the field of grief, loss and/or attachment. \r\n\r\nA summary of the findings will be presented to the class with reference to theoretical knowledge, critical analysis of relevant studies, implications for practice and practical applications \r\n\r\n\r\n \r\n',	'2022-12-29 16:16:06',	'client',	1,	1,	0,	'1'),
(14,	70110,	'client',	53345,	'Support Team',	'we have received the paper details',	'2022-12-19 14:40:09',	'support',	1,	1,	0,	'1'),
(37,	70113,	'writer',	91,	'C91',	'Hi there, I have attached the case formulation for both CBT and EFT to be filled and discussed in the third section of the case study, I couldn\\\'t find them. would you please let me know when will it be completed? Thanks',	'2022-12-29 16:25:34',	'client',	1,	1,	0,	'1'),
(38,	70113,	'writer',	91,	'C91',	'Also, there is no literature cited in the recommended therapy to support the therapy chosen modality?',	'2022-12-29 16:30:49',	'client',	1,	1,	0,	'1'),
(39,	70113,	'writer',	91,	'C91',	'The Hypothesis section only explains Simon\\\'s condition without being supported and cited by both theories (CBT & EFT)? \r\nAn example of a Hypothesis:\r\nPhil is experiencing (issue b), which might be explained by theoretical concept of (theoretical concept b).\r\n\r\nExample:\r\n1.	Phil is experiencing depression (issue a), which may be explained by his avoidance of responsibility (existential concept a, assuming assignment relates to the theory of existentialism. \r\n\r\n2. Phil experiences depression, guilt and distorted thoughts about his daughter\\\'s rejection that result in avoiding the responsibility to reconnect with her, which may be explained by the existential theory of accepting freedom and responsibilities.\r\n',	'2022-12-29 16:41:36',	'client',	1,	1,	0,	'1'),
(40,	70113,	'writer',	91,	'C91',	'CBT is based on the interrelations of thoughts, actions, and feelings and in order to work with people under therapy, the aim of therapy remains to identify the pattern of thoughts and feelings that underline the mood and restructuring these thoughts.',	'2022-12-29 16:45:23',	'client',	1,	1,	0,	'1'),
(41,	70113,	'writer',	91,	'C91',	'CBT: Types of dysfunctional thinking and how these might be contested\r\nCommon problem areas such as authority and intimate relationships\r\nImproving self-esteem',	'2022-12-29 16:53:46',	'client',	1,	1,	0,	'1'),
(42,	70113,	'writer',	91,	'C91',	'In the hypothesis, you need to identify distorted thoughts for Simon in order to relate it to CBT, or attachment disorder, that maybe impacted his current relationship, for example, to be associated with EFT.\r\nPlease let me know if you need further clarification. Thanks',	'2022-12-29 17:05:17',	'client',	1,	1,	0,	'1'),
(43,	70118,	'client',	53345,	'Support Team',	'working on it',	'2022-12-29 20:17:32',	'support',	1,	1,	0,	'1'),
(44,	70113,	'client',	53345,	'Support Team',	'working on it',	'2022-12-29 20:19:36',	'support',	1,	1,	0,	'1'),
(45,	70121,	'client',	53345,	'Support Team',	'50% discount has been applied to your order. please proceed to checkout. thanks',	'2022-12-31 01:40:05',	'support',	1,	1,	0,	'1'),
(46,	70121,	'support',	95,	'C95',	'Seeking a confirmation email',	'2022-12-31 01:48:09',	'client',	1,	1,	0,	'1'),
(47,	70113,	'support',	91,	'C91',	'Hi there, when will I receive the complete work, please?',	'2022-12-31 10:05:58',	'client',	1,	1,	0,	'1'),
(48,	70113,	'client',	53345,	'Support Team',	'please check we have uploaded the revised file',	'2022-12-31 10:07:44',	'support',	1,	1,	0,	'1'),
(49,	70115,	'client',	53345,	'Support Team',	'Assignment done. attached is the completed paper',	'2023-01-02 19:38:50',	'support',	1,	0,	0,	'1'),
(50,	70113,	'writer',	91,	'C91',	'Hi there,\r\nThe answer to the case study is wrong again. This case required CBT therapy as therapy will be dealing with distorted thoughts. The choosing modality in your solution is the wrong one. Could you please fix your answer with evidence-based practice?\r\nAlso, CBT is proven to be the best clinical-based practice in the therapy field. Could you please make your essay lean toward the use of CBT without underestimating the EFT, as it is also proven its benefit in the relationship and family therapy',	'2023-01-04 03:08:12',	'client',	1,	1,	0,	'1'),
(51,	70113,	'writer',	91,	'C91',	'Hi there,\r\nThe answer to the case study is wrong again. This case required CBT therapy as therapy will be dealing with distorted thoughts. The choosing modality in your solution is the wrong one. Could you please fix your answer with evidence-based practice?\r\nAlso, CBT is proven to be the best clinical-based practice in the therapy field. Could you please make your essay lean toward the use of CBT without underestimating the EFT, as it is also proven its benefit in the relationship and family therapy',	'2023-01-04 03:08:17',	'client',	1,	1,	0,	'1'),
(52,	70113,	'writer',	91,	'C91',	'Hi there,\r\nThe answer to the case study is wrong again. This case required CBT therapy as therapy will be dealing with distorted thoughts. The choosing modality in your solution is the wrong one. Could you please fix your answer with evidence-based practice?\r\nAlso, CBT is proven to be the best clinical-based practice in the therapy field. Could you please make your essay lean toward the use of CBT without underestimating the EFT, as it is also proven its benefit in the relationship and family therapy',	'2023-01-04 03:08:19',	'client',	1,	1,	0,	'1'),
(53,	70113,	'writer',	91,	'C91',	'Hi there,\r\nThe answer to the case study is wrong again. This case required CBT therapy as therapy will be dealing with distorted thoughts. The choosing modality in your solution is the wrong one. Could you please fix your answer with evidence-based practice?\r\nAlso, CBT is proven to be the best clinical-based practice in the therapy field. Could you please make your essay lean toward the use of CBT without underestimating the EFT, as it is also proven its benefit in the relationship and family therapy',	'2023-01-04 03:08:19',	'client',	1,	1,	0,	'1'),
(54,	70113,	'client',	53345,	'Support Team',	'working on the revision',	'2023-01-04 03:13:13',	'support',	1,	1,	0,	'1'),
(55,	70113,	'writer',	91,	'C91',	'Could you also please identify the reason sit in which level of the distorted thoughts, whether they are based on core beliefs - level 3, rules and assumptions id and should statement - level 2, or level one, which is NTA -  situational specific and automatic thoughts',	'2023-01-04 03:15:42',	'client',	1,	1,	0,	'1'),
(56,	70113,	'client',	53345,	'Support Team',	'noted',	'2023-01-04 03:17:09',	'support',	1,	1,	0,	'1'),
(57,	70113,	'support',	91,	'C91',	'Hi there,\r\nI am not happy and very disappointed with the academic level of the writer.\r\nI have now given him the correct answer; hopefully, he will be able to do it right this time. My assignment is due Friday, and I need to review and edit the case study before I submit it. I need the answer today to add my work to it.\r\nPlease see below my message to the writer and please make sure next time to delegate the work to someone with the same background and understanding of how to post-graduate work is done.\r\nIn my previous guidance, I had to give him an example of writing a hypothesis, although his updated work was still inaccurate. \r\n\r\nThe answer to the case study is wrong again. This case required CBT therapy as therapy will be dealing with distorted thoughts. The choosing modality in your solution is the wrong one. Could you please fix your answer with evidence-based practice?\r\nAlso, CBT is proven to be the best clinical-based practice in the therapy field. Could you please make your essay lean toward using CBT without underestimating the EFT, as it is also proven its benefit in relationship and family therapy? \r\n\r\nCould you also please identify the reason sit in which level of the distorted thoughts, whether they are based on core beliefs - level 3, rules and assumptions id and should statement - level 2, or level one, which is NTA - situational specific and automatic thoughts.',	'2023-01-04 03:23:57',	'client',	1,	1,	0,	'1'),
(58,	70113,	'writer',	91,	'C91',	'Please give me an exact time when this case study will be completed appropriately, including the professional hypothesis?',	'2023-01-04 03:26:49',	'client',	1,	1,	0,	'1'),
(59,	70113,	'client',	53345,	'Support Team',	'will be done in 24 hours',	'2023-01-04 03:34:38',	'support',	1,	1,	0,	'1'),
(60,	70118,	'writer',	91,	'C91',	'Hi there, Thank you so much for the presentation; it\\\'s much better than the first one. \r\nI have added some requests, including missing citations and other requests related to the presentation requirement mentioned in what was expected sent in my first order.\r\n\r\nI am uploading the presentation again with notes written on each slide for what needed to be edited. Could you please complete it as soon as possible? Thanks again for the production.\r\n',	'2023-01-04 03:49:05',	'client',	1,	1,	0,	'1'),
(61,	70113,	'support',	91,	'C91',	'Thanks',	'2023-01-04 03:50:12',	'client',	1,	1,	0,	'1'),
(62,	70118,	'support',	91,	'C91',	'Hi there. \r\nThanks for changing the writer. This presentation is related to the topic requested and produced in a much better way than the first one.\r\nI have uploaded the presentation with some adjustment notes to meet the academic-level requirements. (There are a few missing citations and resources needed to be added, so it should take no more than an hour to be completed).\r\nCould you please ensure this is done at the earliest convenience today? Thanks ',	'2023-01-04 04:00:18',	'client',	1,	1,	0,	'1'),
(63,	70117,	'writer',	91,	'C91',	'Please send the citation to task two in the reflection. thanks',	'2023-01-04 04:08:29',	'client',	1,	1,	0,	'1'),
(64,	70116,	'writer',	91,	'C91',	'Hi there, thanks for the essay. There are a few adjustments required to complete the work according to the academic level and to provide the correct answer.\r\nI uploaded the essay with comments in each section that need to be adjusted.\r\nPlease give me a time when the work will be completed?',	'2023-01-04 05:00:02',	'client',	1,	1,	0,	'1'),
(65,	70116,	'support',	91,	'C91',	'Hi there, the essay answer is missing two or more sections responding to the questions.\r\nIt also not following the APA7 formatting with the appendix as per the order requested in the general comment mentioned.\r\n\r\nI uploaded the essay again with comments for the required adjustments which also includes missing citations.\r\nCould you please specify a time when the work will be completed?',	'2023-01-04 05:04:52',	'client',	1,	1,	0,	'1'),
(66,	70116,	'writer',	91,	'C91',	'Hi there,\r\n\r\nPlease see below two links with helpful information on the grief theories, as what you provided were the wrong answer and the wrong therapeutic models.\r\n\r\nhttps://positivepsychology.com/grief-counseling/\r\n\r\nhttps://us.calmerry.com/blog/grief-and-loss/top-grief-theories-and-models/\r\n',	'2023-01-04 07:07:39',	'client',	1,	1,	0,	'1'),
(67,	70116,	'support',	91,	'C91',	'Hi there, I believe the writer has no counselling background and is not at the post-grade standard.\r\nThe writer provided the wrong answer and did not follow the APA formatting. \r\nCould you please change the writer to someone with psychology, psychotherapy, or counselling experience?',	'2023-01-04 07:11:18',	'client',	1,	1,	0,	'1'),
(68,	70116,	'support',	91,	'C91',	'Hi there, I believe the writer has no counselling background and is not at the post-grade standard.\r\nThe writer provided the wrong answer and did not follow the APA formatting. \r\nCould you please change the writer to someone with psychology, psychotherapy, or counselling experience?',	'2023-01-04 07:11:19',	'client',	1,	1,	0,	'1'),
(69,	70116,	'client',	53345,	'Support Team',	'working on it',	'2023-01-04 13:44:26',	'support',	1,	1,	0,	'1'),
(70,	70117,	'client',	53345,	'Support Team',	'ok',	'2023-01-04 14:10:20',	'support',	1,	1,	0,	'1'),
(72,	70118,	'client',	53345,	'Support Team',	'attached is the revised ppt',	'2023-01-04 19:14:13',	'support',	1,	1,	0,	'1'),
(73,	70117,	'client',	53345,	'Support Team',	'find attached',	'2023-01-04 19:16:50',	'support',	1,	1,	0,	'1'),
(74,	70118,	'writer',	91,	'C91',	'Thank you',	'2023-01-05 08:50:17',	'client',	1,	1,	0,	'1'),
(75,	70113,	'client',	53345,	'Support Team',	'Hi the paper has been redone according to masters level as requested. There is however a 50 aud price difference as this was charged as undergraduate. Kindly confirm we create a 50 aud order for checkout. Thanks',	'2023-01-05 10:15:58',	'support',	1,	1,	0,	'1'),
(76,	70113,	'support',	91,	'C91',	'This is the wrong answer again, it did not follow the structure I gave above and did not answer all the questions.\r\nAlso, most paragraphs are copied word for word from google search and the previous case study provided although I informed the writer, it was the wrong answer and structure.\r\n\r\nI have pointed out all the feedback below, submission is due today, so I will have to redo all the work. \r\n\r\nPlease see below the reason I am requesting a refund for this work.\r\n\r\nStructure and answer to the case study, the case study requires answering the following questions by dividing the essay into 5 sections (The essay is not structured accordingly).\r\n1. hypothesis on the client\\\'s presenting issue according to both theories a) CBT - discuss the theory in relation to the client issue B) EFT - discuss the theory in relation to the client issue (it only discussed part of CBT client\\\'s issue, and included panic and anxiety without giving example from the case study, however, the case study did not have panic symptoms - so it is very irrelevant) - (It did not discussed clients specific hypothesis for EFT with example from the case provided)\r\n2. each modality (CBT & EFT) specific interventions that you would employ in session with the case study - client, providing rationale for your answer (This has not given at all, it supposes give an intervention plan for counselling session that includes CBT and EFT techniques).\r\n3. each modality specific case formulation for future consideration (attach each modality formulation to fill in according to the case study) and then discuss each in paragraphs.  (This has not provided at all).\r\n4. limitations of each modality if used slowly and separately with the case study – discussing what aspects of the client situation do you believe would not be adequately addressed by each approach solely? (This only has been given but very briefly).\r\n5. Based on your discussion, which modality would you choose to use with this client? \r\nProvide a clear rationale for your decision. (The answer was contradictive with the discussion of the limitation) \r\nThank',	'2023-01-06 03:28:03',	'client',	1,	1,	0,	'1'),
(77,	70116,	'support',	91,	'C91',	'Hi there,\r\nWhen is it going to be completed, please?',	'2023-01-06 03:31:38',	'client',	1,	1,	0,	'1'),
(78,	70116,	'client',	53345,	'Support Team',	'revised',	'2023-01-06 06:06:25',	'support',	1,	1,	0,	'1'),
(79,	70113,	'client',	53345,	'Support Team',	'working on revision',	'2023-01-06 06:40:01',	'support',	1,	1,	0,	'1'),
(80,	70113,	'client',	53345,	'Support Team',	'regarding 70113, writer says specialization is required and he may need a lot more time to handle the order. Can you handle it yourself and let us handle the next assignment please?\r\n',	'2023-01-06 07:12:23',	'support',	1,	1,	0,	'1'),
(81,	70113,	'support',	91,	'C91',	'Do you want me to send you a new assignment instead?',	'2023-01-06 13:20:32',	'client',	1,	1,	0,	'1'),
(82,	70116,	'client',	53345,	'Support Team',	'writer highlighted the changes made in doc',	'2023-01-07 05:06:24',	'support',	1,	1,	0,	'1'),
(83,	70122,	'client',	53345,	'Support Team',	'attached is the completed order plus turnitin report',	'2023-01-10 07:44:13',	'support',	1,	1,	0,	'1'),
(84,	70122,	'client',	53345,	'Support Team',	'attached is the revised assignment',	'2023-01-12 14:18:27',	'support',	1,	1,	0,	'1'),
(85,	70122,	'client',	53345,	'Support Team',	'Done',	'2023-01-13 07:49:41',	'support',	1,	1,	0,	'1'),
(86,	70125,	'client',	53345,	'Support Team',	'working on the order',	'2023-01-17 10:01:34',	'support',	1,	1,	0,	'1'),
(87,	70126,	'client',	53345,	'Support Team',	'hello ',	'2023-01-21 12:46:19',	'support',	1,	1,	0,	'1'),
(88,	70126,	'writer',	121,	'C121',	'Hello',	'2023-01-21 12:48:53',	'client',	1,	1,	0,	'1'),
(89,	70126,	'writer',	121,	'C121',	'Please do inform me when you start my assignment\r\n',	'2023-01-21 12:51:36',	'client',	1,	1,	0,	'1'),
(90,	70126,	'client',	53345,	'Support Team',	'Ok will be here to answer any questions you have. writer is going through the instructions at the moment',	'2023-01-21 12:57:48',	'support',	1,	1,	0,	'1'),
(91,	70125,	'client',	53345,	'Support Team',	'attached is the completed paper plus turnitin report',	'2023-01-25 06:33:33',	'support',	1,	1,	0,	'1'),
(92,	70125,	'support',	118,	'C118',	'can\\\'t download ',	'2023-01-25 23:55:28',	'client',	1,	1,	0,	'1'),
(93,	70125,	'client',	53345,	'Support Team',	'sent in email too',	'2023-01-26 12:37:38',	'support',	1,	0,	0,	'1'),
(94,	70128,	'support',	122,	'C122',	'Hello',	'2023-02-11 19:10:21',	'client',	0,	1,	0,	'1');

CREATE TABLE `ops_orders` (
  `order_id` int(11) NOT NULL AUTO_INCREMENT,
  `order_title` varchar(250) DEFAULT NULL,
  `order_alias` varchar(200) DEFAULT NULL,
  `order_tpaper` varchar(30) DEFAULT NULL,
  `order_subject` varchar(200) DEFAULT NULL,
  `ops_aclevel` varchar(50) DEFAULT NULL,
  `order_pages` int(11) DEFAULT NULL,
  `order_instructions` text,
  `order_dateposted` datetime DEFAULT NULL,
  `order_timezone` varchar(100) DEFAULT NULL,
  `order_deadline` datetime DEFAULT NULL,
  `order_wrdeadline` datetime NOT NULL,
  `order_sources` int(11) DEFAULT NULL,
  `order_citation` varchar(20) DEFAULT NULL,
  `order_amount` float NOT NULL,
  `order_wramount` float NOT NULL,
  `order_wquality` varchar(15) NOT NULL,
  `order_upsells` varchar(200) NOT NULL,
  `order_paid` varchar(11) NOT NULL,
  `order_clientid` int(11) NOT NULL,
  `order_status` varchar(50) NOT NULL,
  `order_writer` int(11) NOT NULL,
  `order_wrconfirm` int(11) NOT NULL,
  `order_wrnickname` varchar(200) NOT NULL,
  `order_period` varchar(20) NOT NULL,
  `order_periodmonth` varchar(25) NOT NULL,
  `order_wrpaid` varchar(10) NOT NULL,
  `order_wrpaiddate` datetime NOT NULL,
  `order_rating` float NOT NULL,
  `order_ratecomment` text NOT NULL,
  `order_ratedate` datetime NOT NULL,
  `order_site` varchar(200) DEFAULT NULL,
  `order_pptslides` int(11) NOT NULL,
  `order_spacing` varchar(10) NOT NULL,
  `order_prefwriter` int(11) NOT NULL,
  `order_editor` int(11) NOT NULL,
  `order_edamount` float NOT NULL,
  `order_edpaid` int(11) NOT NULL,
  `order_edpaiddate` datetime NOT NULL,
  `order_coupon` varchar(25) NOT NULL,
  `order_completeddate` datetime NOT NULL,
  `order_approveddate` datetime NOT NULL,
  `order_revision` text NOT NULL,
  `order_dispute` text NOT NULL,
  `order_note` text NOT NULL,
  `order_currency` varchar(25) NOT NULL,
  `order_charts` int(11) NOT NULL,
  `order_fine` text NOT NULL,
  `order_finereason` text NOT NULL,
  `order_bamount` float NOT NULL,
  `order_assignedtime` datetime NOT NULL,
  `order_reassignreason` text NOT NULL,
  `order_editorcomment` text NOT NULL,
  `order_notewriter` text NOT NULL,
  `order_extended` int(11) NOT NULL,
  `order_payreminded` int(11) NOT NULL,
  `order_posts` varchar(255) DEFAULT NULL,
  `order_quizzes` varchar(255) DEFAULT NULL,
  `order_replies` varchar(255) DEFAULT NULL,
  `bid_writer` varchar(255) DEFAULT NULL,
  `config_clientassign` varchar(255) DEFAULT NULL,
  `writer_paid` varchar(255) DEFAULT 'unpaid',
  `order_adminr` varchar(255) DEFAULT NULL,
  `order_service` varchar(255) DEFAULT NULL,
  `order_related` varchar(255) DEFAULT NULL,
  `order_extras` varchar(255) DEFAULT NULL,
  `payment_dates` varchar(255) NOT NULL,
  PRIMARY KEY (`order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE `ops_payments` (
  `pay_id` int(11) NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_method` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_site` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_payerid` int(11) DEFAULT NULL,
  `pay_payername` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_itemname` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_itemid` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_itemprice` float(10,2) DEFAULT NULL,
  `pay_currency` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_itemcurrency` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_amount` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_txnid` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `pay_status` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT 'unpaid',
  `pay_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pay_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pay_type` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `ops_payments` (`pay_id`, `slug`, `pay_method`, `pay_site`, `pay_payerid`, `pay_payername`, `pay_email`, `pay_itemname`, `pay_itemid`, `pay_itemprice`, `pay_currency`, `pay_itemcurrency`, `pay_amount`, `pay_txnid`, `pay_status`, `pay_created`, `pay_modified`, `pay_type`) VALUES
(1,	NULL,	'System',	'localhost',	2,	'support',	'01783333945556333365555555566666665555555555666@gmail.com',	'A reflection paper (S)',	'3',	16.25,	'usd',	'usd',	'16.25',	NULL,	'succeeded',	'2022-08-04 09:50:59',	'2022-08-04 09:50:59',	NULL),
(3,	NULL,	'System',	'localhost',	2,	'support',	'01783333945556333365555555566666665555555555666@gmail.com',	'Amelinda',	'4',	16.25,	'usd',	'usd',	'16.25',	NULL,	'succeeded',	'2022-08-04 13:35:00',	'2022-08-04 13:35:00',	NULL),
(4,	NULL,	'System',	'localhost',	2,	'support',	'01783333945556333365555555566666665555555555666@gmail.com',	'tedgvhbhbhbj',	'5',	16.25,	'usd',	'usd',	'16.25',	NULL,	'succeeded',	'2022-08-04 13:56:47',	'2022-08-04 13:56:47',	NULL),
(6,	NULL,	'System',	'localhost',	3,	'support',	'admin1234@demo.com',	'tttttttttttttttttttttttttttttt',	'6',	16.25,	'usd',	'usd',	'16.25',	NULL,	'succeeded',	'2022-08-05 08:54:34',	'2022-08-05 08:54:34',	NULL),
(7,	'in1659695636vIRLt8',	'invoice',	'writers24x7.com',	NULL,	NULL,	NULL,	'45555',	NULL,	NULL,	NULL,	NULL,	'10',	NULL,	'unpaid',	'2022-08-05 10:33:56',	'2022-08-05 10:33:56',	NULL),
(15,	NULL,	'System',	'localhost',	2,	'support',	'01783333945556333365555555566666665555555555666@gmail.com',	'A reflection paper (S)',	'2',	16.25,	'usd',	'usd',	'16.25',	NULL,	'succeeded',	'2022-08-05 17:47:09',	'2022-08-05 17:47:09',	NULL),
(16,	NULL,	'System',	'localhost',	3,	'support',	'admin1234@demo.com',	'treeee',	'7',	15.60,	'usd',	'usd',	'15.6',	NULL,	'succeeded',	'2022-08-05 18:16:11',	'2022-08-05 18:16:11',	NULL),
(17,	NULL,	'Paypal',	'allassignmenthelp.com.au',	54,	'C54',	'PrincessF1969@gmail.com',	'70055',	'70055',	166.30,	'usd',	'usd',	'166.3',	NULL,	'succeeded',	'2022-08-27 04:14:54',	'2022-08-27 04:14:54',	NULL),
(18,	NULL,	'Paypal',	'allassignmenthelp.com.au',	54,	'C54',	'PrincessF1969@gmail.com',	'70058',	'70058',	166.30,	'usd',	'usd',	'166.3',	NULL,	'succeeded',	'2022-08-27 05:10:49',	'2022-08-27 05:10:49',	NULL),
(19,	NULL,	'Paypal',	'allassignmenthelp.com.au',	58,	'C58',	'chanimohammad@gmail.com',	'70059',	'70059',	61.16,	'usd',	'usd',	'61.16',	NULL,	'succeeded',	'2022-08-30 12:40:58',	'2022-08-30 12:40:58',	NULL),
(20,	NULL,	'Paypal',	'allassignmenthelp.com.au',	61,	'C61',	'ltuilaselase@gmail.com',	'70061',	'70061',	44.97,	'usd',	'usd',	'44.97',	NULL,	'succeeded',	'2022-09-04 07:58:59',	'2022-09-04 07:58:59',	NULL),
(21,	NULL,	'Paypal',	'allassignmenthelp.com.au',	58,	'C58',	'chanimohammad@gmail.com',	'70060',	'70060',	42.73,	'usd',	'usd',	'42.73',	NULL,	'succeeded',	'2022-09-04 11:26:44',	'2022-09-04 11:26:44',	NULL),
(22,	NULL,	'Paypal',	'allassignmenthelp.com.au',	63,	'C63',	'belnagle@gmail.com',	'70063',	'70063',	112.43,	'usd',	'usd',	'112.43',	NULL,	'succeeded',	'2022-09-07 00:33:14',	'2022-09-07 00:33:14',	NULL),
(23,	NULL,	'Paypal',	'allassignmenthelp.com.au',	63,	'C63',	'belnagle@gmail.com',	'70062',	'70062',	131.16,	'usd',	'usd',	'131.16',	NULL,	'succeeded',	'2022-09-07 00:37:01',	'2022-09-07 00:37:01',	NULL),
(24,	NULL,	'Paypal',	'allassignmenthelp.com.au',	64,	'C64',	'nguyenkhangtomm@gmail.com',	'70065',	'70065',	25.39,	'usd',	'usd',	'25.39',	NULL,	'succeeded',	'2022-09-07 12:55:14',	'2022-09-07 12:55:14',	NULL),
(25,	NULL,	'Paypal',	'allassignmenthelp.com.au',	64,	'C64',	'nguyenkhangtomm@gmail.com',	'70066',	'70066',	149.90,	'usd',	'usd',	'149.9',	NULL,	'succeeded',	'2022-09-07 13:23:25',	'2022-09-07 13:23:25',	NULL),
(26,	NULL,	'Paypal',	'allassignmenthelp.com.au',	67,	'C67',	'alesha.hinkley1@gmail.com',	'70073',	'70073',	157.42,	'usd',	'usd',	'157.42',	NULL,	'succeeded',	'2022-09-13 09:26:00',	'2022-09-13 09:26:00',	NULL),
(27,	NULL,	'Paypal',	'allassignmenthelp.com.au',	61,	'C61',	'ltuilaselase@gmail.com',	'70074',	'70074',	89.95,	'usd',	'usd',	'89.95',	NULL,	'succeeded',	'2022-09-13 20:27:17',	'2022-09-13 20:27:17',	NULL),
(28,	NULL,	'Paypal',	'allassignmenthelp.com.au',	70,	'C70',	'hayleyt207@gmail.com',	'70078',	'70078',	104.95,	'usd',	'usd',	'104.95',	NULL,	'succeeded',	'2022-09-15 03:46:58',	'2022-09-15 03:46:58',	NULL),
(29,	NULL,	'Paypal',	'allassignmenthelp.com.au',	74,	'C74',	'anusha735@yahoo.com.au',	'70081',	'70081',	100.72,	'usd',	'usd',	'100.72',	NULL,	'succeeded',	'2022-09-25 22:54:50',	'2022-09-25 22:54:50',	NULL),
(30,	NULL,	'Paypal',	'allassignmenthelp.com.au',	75,	'C75',	'sushilsubedi82@gmail.com',	'70082',	'70082',	104.95,	'usd',	'usd',	'104.95',	NULL,	'succeeded',	'2022-09-26 02:25:38',	'2022-09-26 02:25:38',	NULL),
(31,	NULL,	'Paypal',	'allassignmenthelp.com.au',	76,	'C76',	'antonellaianni@optusnet.com.au',	'70083',	'70083',	46.77,	'usd',	'usd',	'46.77',	NULL,	'succeeded',	'2022-09-28 02:10:10',	'2022-09-28 02:10:10',	NULL),
(32,	NULL,	'Paypal',	'allassignmenthelp.com.au',	76,	'C76',	'antonellaianni@optusnet.com.au',	'70084',	'70084',	65.49,	'usd',	'usd',	'65.49',	NULL,	'succeeded',	'2022-09-28 02:12:39',	'2022-09-28 02:12:39',	NULL),
(33,	NULL,	'Paypal',	'allassignmenthelp.com.au',	76,	'C76',	'antonellaianni@optusnet.com.au',	'70085',	'70085',	46.77,	'usd',	'usd',	'46.77',	NULL,	'succeeded',	'2022-09-28 02:14:44',	'2022-09-28 02:14:44',	NULL),
(34,	NULL,	'Paypal',	'allassignmenthelp.com.au',	77,	'C77',	'shehani.s1992@gmail.com',	'70086',	'70086',	77.47,	'usd',	'usd',	'77.47',	NULL,	'succeeded',	'2022-09-28 08:58:30',	'2022-09-28 08:58:30',	NULL),
(35,	NULL,	'Paypal',	'allassignmenthelp.com.au',	77,	'C77',	'shehani.s1992@gmail.com',	'70087',	'70087',	77.47,	'usd',	'usd',	'77.47',	NULL,	'succeeded',	'2022-09-28 20:32:45',	'2022-09-28 20:32:45',	NULL),
(36,	NULL,	'Paypal',	'allassignmenthelp.com.au',	54,	'C54',	'PrincessF1969@gmail.com',	'70089',	'70089',	283.31,	'usd',	'usd',	'283.31',	NULL,	'succeeded',	'2022-09-29 00:54:26',	'2022-09-29 00:54:26',	NULL),
(37,	NULL,	'Paypal',	'allassignmenthelp.com.au',	81,	'C81',	'jessicanewto@gmail.com',	'70093',	'70093',	52.47,	'usd',	'usd',	'52.47',	NULL,	'succeeded',	'2022-10-03 06:40:47',	'2022-10-03 06:40:47',	NULL),
(38,	NULL,	'Paypal',	'allassignmenthelp.com.au',	54,	'C54',	'PrincessF1969@gmail.com',	'70095',	'70095',	125.50,	'usd',	'usd',	'125.5',	NULL,	'succeeded',	'2022-10-03 08:54:54',	'2022-10-03 08:54:54',	NULL),
(39,	NULL,	'Paypal',	'allassignmenthelp.com.au',	82,	'C82',	'prevosa_j@yahoo.com',	'70096',	'70096',	181.29,	'usd',	'usd',	'181.29',	NULL,	'succeeded',	'2022-10-04 01:58:11',	'2022-10-04 01:58:11',	NULL),
(40,	NULL,	'Paypal',	'allassignmenthelp.com.au',	75,	'C75',	'sushilsubedi82@gmail.com',	'70091',	'70091',	104.95,	'usd',	'usd',	'104.95',	NULL,	'succeeded',	'2022-10-04 08:35:15',	'2022-10-04 08:35:15',	NULL),
(41,	NULL,	'Paypal',	'allassignmenthelp.com.au',	81,	'C81',	'jessicanewto@gmail.com',	'70099',	'70099',	74.95,	'usd',	'usd',	'74.95',	NULL,	'succeeded',	'2022-10-07 10:13:08',	'2022-10-07 10:13:08',	NULL),
(42,	NULL,	'Paypal',	'allassignmenthelp.com.au',	81,	'C81',	'jessicanewto@gmail.com',	'70100',	'70100',	22.48,	'usd',	'usd',	'22.48',	NULL,	'succeeded',	'2022-10-10 06:52:56',	'2022-10-10 06:52:56',	NULL),
(43,	NULL,	'Paypal',	'allassignmenthelp.com.au',	82,	'C82',	'prevosa_j@yahoo.com',	'70104',	'70104',	194.87,	'usd',	'usd',	'194.87',	NULL,	'succeeded',	'2022-10-22 02:12:13',	'2022-10-22 02:12:13',	NULL),
(44,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70110',	'70110',	207.08,	'usd',	'usd',	'207.08',	NULL,	'succeeded',	'2022-12-19 13:56:05',	'2022-12-19 13:56:05',	NULL),
(45,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70113',	'70113',	97.46,	'usd',	'usd',	'97.46',	NULL,	'succeeded',	'2022-12-19 15:08:21',	'2022-12-19 15:08:21',	NULL),
(46,	NULL,	'Paypal',	'assignment-help.com.au',	92,	'C92',	'gaggukahlon@gmail.com',	'70115',	'70115',	21.99,	'usd',	'usd',	'21.99',	NULL,	'succeeded',	'2022-12-20 03:59:33',	'2022-12-20 03:59:33',	NULL),
(47,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70116',	'70116',	143.91,	'usd',	'usd',	'143.91',	NULL,	'succeeded',	'2022-12-25 06:09:03',	'2022-12-25 06:09:03',	NULL),
(48,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70117',	'70117',	119.92,	'usd',	'usd',	'119.92',	NULL,	'succeeded',	'2022-12-25 06:43:08',	'2022-12-25 06:43:08',	NULL),
(49,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70118',	'70118',	97.94,	'usd',	'usd',	'97.94',	NULL,	'succeeded',	'2022-12-25 07:22:04',	'2022-12-25 07:22:04',	NULL),
(50,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70119',	'70119',	95.94,	'usd',	'usd',	'95.94',	NULL,	'succeeded',	'2022-12-25 11:54:04',	'2022-12-25 11:54:04',	NULL),
(51,	NULL,	'Paypal',	'assignment-help.com.au',	95,	'C95',	'sajidbinnasir18@gmail.com',	'70121',	'70121',	137.95,	'usd',	'usd',	'137.95',	NULL,	'succeeded',	'2022-12-31 00:45:09',	'2022-12-31 00:45:09',	NULL),
(52,	NULL,	'Paypal',	'assignment-help.com.au',	91,	'C91',	'haya.kholosy@yahoo.com.au',	'70122',	'70122',	50.00,	'usd',	'usd',	'50',	NULL,	'succeeded',	'2023-01-06 13:34:52',	'2023-01-06 13:34:52',	NULL),
(53,	NULL,	'Paypal',	'assignment-help.com.au',	95,	'C95',	'sajidbinnasir18@gmail.com',	'70123',	'70123',	50.00,	'usd',	'usd',	'50',	NULL,	'succeeded',	'2023-01-10 15:06:42',	'2023-01-10 15:06:42',	NULL),
(54,	NULL,	'Paypal',	'assignment-help.com.au',	118,	'C118',	'kavitakumar283@gmail.com',	'70125',	'70125',	359.82,	'usd',	'usd',	'359.82',	NULL,	'succeeded',	'2023-01-17 07:10:40',	'2023-01-17 07:10:40',	NULL),
(55,	NULL,	'Paypal',	'assignment-help.com.au',	121,	'C121',	'rifapauleen96@gmail.com',	'70126',	'70126',	120.00,	'usd',	'usd',	'120',	NULL,	'succeeded',	'2023-01-21 11:40:49',	'2023-01-21 11:40:49',	NULL),
(56,	NULL,	'System',	'assignment-help.com.au',	122,	'support',	'cvkjvc@aol.com',	'dfghj',	'70128',	48.55,	'usd',	'usd',	'48.55',	NULL,	'succeeded',	'2023-02-09 18:05:06',	'2023-02-09 18:05:06',	NULL);

CREATE TABLE `ops_payouts` (
  `payout_id` int(11) NOT NULL,
  `payout_name` varchar(10) NOT NULL,
  PRIMARY KEY (`payout_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_payouts` (`payout_id`, `payout_name`) VALUES
(1,	'PayPal'),
(3,	'm-pesa'),
(4,	'Skrill'),
(5,	'Bank');

CREATE TABLE `ops_paypals` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paypal_site` varchar(125) NOT NULL,
  `paypal_paypal` varchar(225) NOT NULL,
  `paypal_logo` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_pptypes` (
  `pptype_id` int(11) NOT NULL,
  `pptype_pvalue` float NOT NULL,
  `pptype_name` varchar(100) NOT NULL,
  PRIMARY KEY (`pptype_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_pptypes` (`pptype_id`, `pptype_pvalue`, `pptype_name`) VALUES
(1,	1,	'Essay (Any Type)'),
(2,	1,	'Article (Any Type)'),
(3,	1,	'Assignment'),
(4,	1,	'Content (Any Type)'),
(5,	1,	'Admission Essay'),
(6,	1,	'Annotated Bibliography'),
(7,	1,	'Argumentative Essay'),
(8,	1,	'Article Review'),
(9,	1,	'Book/Movie Review'),
(10,	1,	'Business Plan'),
(11,	1,	'Capstone Project'),
(12,	1,	'Case Study'),
(13,	1,	'Coursework'),
(14,	1,	'Creative Writing'),
(15,	1,	'Critical Thinking'),
(16,	1,	'Dissertation'),
(17,	1,	'Dissertation chapter'),
(18,	1,	'Lab Report'),
(19,	1.2,	'Math Problem'),
(20,	1,	'Research Paper'),
(21,	1,	'Research Proposal'),
(22,	1,	'Research Summary'),
(23,	1,	'Scholarship Essay'),
(24,	1,	'Speech'),
(25,	1,	'Statistic Project'),
(26,	1,	'Term Paper'),
(27,	1,	'Thesis/Thesis Chapter'),
(28,	1,	'Other'),
(29,	1,	'Presentation or Speech'),
(30,	1,	'Q&A'),
(31,	1,	'speech work'),
(32,	1,	'Application Paper'),
(33,	1,	'Analysis'),
(34,	1,	'Memo/Letter'),
(35,	0.5,	'Outline'),
(36,	1,	'Personal reflection'),
(37,	0.7,	'Presentation/PPT'),
(38,	1,	'Report (Any type)'),
(39,	1,	'Response Essay'),
(40,	1,	'Acceptance letter'),
(41,	2,	'Online Exam'),
(42,	0.8,	'Revision Paper'),
(43,	1.3,	'Blog Writing'),
(44,	1,	'Executive Summary'),
(45,	0.6,	'Extended Revision'),
(46,	1.5,	'Microsoft Project'),
(47,	0.5,	'Progressive Paper'),
(48,	0.6,	'Dissertation Editing'),
(49,	1.3,	'Grant proposal'),
(50,	0.6,	'Paraphrase'),
(51,	1.5,	'Nursing calculations'),
(52,	0.8,	'Combined Sections'),
(53,	0.5,	'Dissertation editing'),
(54,	0.5,	'Proofreading/editing'),
(55,	2,	'Brochure'),
(56,	0.5,	'Paper Editing');

CREATE TABLE `ops_pricing` (
  `pricing_id` int(11) NOT NULL AUTO_INCREMENT,
  `pricing_value` varchar(255) NOT NULL DEFAULT '13',
  `pricing_urgency` int(11) NOT NULL,
  `pricing_duration` varchar(25) NOT NULL,
  `pricing_checked` varchar(20) NOT NULL,
  `pricing_site` varchar(50) NOT NULL,
  `xx` int(11) NOT NULL,
  PRIMARY KEY (`pricing_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_pricing` (`pricing_id`, `pricing_value`, `pricing_urgency`, `pricing_duration`, `pricing_checked`, `pricing_site`, `xx`) VALUES
(15,	'40.99',	12,	'Hours',	'',	'study-nerds.local:10004',	0),
(16,	'32.99',	24,	'Hours',	'',	'study-nerds.local:10004',	0),
(17,	'29.99',	2,	'Days',	'',	'study-nerds.local:10004',	0),
(18,	'28.99',	3,	'Days',	'checked',	'study-nerds.local:10004',	0),
(19,	'27.99',	5,	'Days',	'',	'study-nerds.local:10004',	0),
(20,	'22.99',	7,	'Days',	'',	'study-nerds.local:10004',	0),
(24,	'21.99',	14,	'Days',	'',	'study-nerds.local:10004',	0);

CREATE TABLE `ops_questions` (
  `qsn_id` int(11) NOT NULL,
  `qsn_pracid` int(11) NOT NULL,
  `qsn_title` text NOT NULL,
  `qsn_a` text NOT NULL,
  `qsn_b` text NOT NULL,
  `qsn_c` text NOT NULL,
  `qsn_d` text NOT NULL,
  `qsn_answer` varchar(25) NOT NULL,
  `qsn_explanation` text NOT NULL,
  PRIMARY KEY (`qsn_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_questions` (`qsn_id`, `qsn_pracid`, `qsn_title`, `qsn_a`, `qsn_b`, `qsn_c`, `qsn_d`, `qsn_answer`, `qsn_explanation`) VALUES
(28,	0,	'Which of the following is not a citation style?',	'APA',	'MLA',	'HAVARD',	'OSKOLA',	',,,D',	'');


CREATE TABLE `ops_revisions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) DEFAULT NULL,
  `description` text,
  `hours` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `rev_from` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `ops_revisions` (`id`, `order_id`, `description`, `hours`, `status`, `rev_from`, `created_at`) VALUES
(5,	2,	'<div>\r\n<h2>Why do we use it?</h2>\r\n\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using &#39;Content here, content here&#39;, making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for &#39;lorem ipsum&#39; will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n</div>\r\n',	'6',	'revision',	NULL,	'2022-08-04 11:32:34');

CREATE TABLE `ops_service` (
  `id` int(11) NOT NULL,
  `service_names` varchar(125) NOT NULL,
  `service_price` float NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `ops_service` (`id`, `service_names`, `service_price`) VALUES
(1,	'Writing From scratch',	1),
(2,	'Editing',	0.8),
(3,	'Problem solving',	0.9),
(4,	'Paraphrasing/Rewriting',	0.5);

CREATE TABLE `ops_sms` (
  `sms_id` int(11) NOT NULL,
  `sms_neworder` int(11) NOT NULL,
  `sms_wneworder` int(11) NOT NULL,
  `sms_clorder` int(11) NOT NULL,
  `sms_unpaid` int(11) NOT NULL,
  `sms_wrdeadline` int(11) NOT NULL,
  `sms_wrorder` int(11) NOT NULL,
  `sms_edorder` int(11) NOT NULL,
  PRIMARY KEY (`sms_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_sms` (`sms_id`, `sms_neworder`, `sms_wneworder`, `sms_clorder`, `sms_unpaid`, `sms_wrdeadline`, `sms_wrorder`, `sms_edorder`) VALUES
(1,	0,	0,	0,	0,	0,	0,	0);

CREATE TABLE `ops_subjects` (
  `sub_id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_pvalue` float NOT NULL,
  `sub_name` varchar(200) NOT NULL,
  `sub_site` varchar(125) NOT NULL,
  `service_id` int(11) NOT NULL DEFAULT '1',
  `xx` int(11) NOT NULL,
  PRIMARY KEY (`sub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_subjects` (`sub_id`, `sub_pvalue`, `sub_name`, `sub_site`, `service_id`, `xx`) VALUES
(3,	1,	'Archaeology',	'study-nerds.local:10004',	1,	3),
(4,	1.1,	'Architecture',	'study-nerds.local:10004',	1,	4),
(5,	1,	'Arts',	'study-nerds.local:10004',	1,	5),
(6,	1,	'Astronomy',	'study-nerds.local:10004',	1,	6),
(7,	1.3,	'Biology',	'study-nerds.local:10004',	1,	7),
(8,	1,	'Business',	'study-nerds.local:10004',	1,	8),
(9,	1.2,	'Chemistry',	'study-nerds.local:10004',	1,	11),
(10,	1,	'Childcare',	'study-nerds.local:10004',	1,	12),
(11,	1,	'Computers',	'study-nerds.local:10004',	1,	13),
(12,	1,	'Counseling',	'study-nerds.local:10004',	1,	14),
(13,	1,	'Criminology',	'study-nerds.local:10004',	1,	15),
(14,	1,	'Economics',	'study-nerds.local:10004',	1,	16),
(15,	1,	'Education',	'study-nerds.local:10004',	1,	17),
(16,	1.1,	'Engineering',	'study-nerds.local:10004',	1,	18),
(17,	1,	'Environmental-Studies',	'study-nerds.local:10004',	1,	19),
(18,	1,	'Ethics',	'study-nerds.local:10004',	1,	20),
(19,	1,	'Ethnic-Studies',	'study-nerds.local:10004',	1,	21),
(20,	1,	'Finance',	'study-nerds.local:10004',	1,	22),
(21,	1,	'Food-Nutrition',	'study-nerds.local:10004',	1,	23),
(22,	1,	'Geography',	'study-nerds.local:10004',	1,	24),
(23,	1.3,	'Healthcare',	'study-nerds.local:10004',	1,	25),
(24,	1,	'History',	'study-nerds.local:10004',	1,	26),
(25,	1,	'Law',	'study-nerds.local:10004',	1,	27),
(26,	1,	'Linguistics',	'study-nerds.local:10004',	1,	28),
(27,	1,	'Literature',	'study-nerds.local:10004',	1,	29),
(28,	1,	'Management',	'study-nerds.local:10004',	1,	30),
(29,	1.3,	'Mathematics',	'study-nerds.local:10004',	1,	32),
(30,	1.3,	'Medicine',	'study-nerds.local:10004',	1,	33),
(31,	1,	'Music',	'study-nerds.local:10004',	1,	34),
(32,	1.3,	'Nursing',	'study-nerds.local:10004',	1,	35),
(33,	1,	'Philosophy',	'study-nerds.local:10004',	1,	36),
(34,	1,	'Physical-Education',	'study-nerds.local:10004',	1,	37),
(35,	1.2,	'Physics',	'study-nerds.local:10004',	1,	38),
(36,	1,	'Political-Science',	'study-nerds.local:10004',	1,	39),
(37,	1.2,	'Programming',	'study-nerds.local:10004',	1,	40),
(38,	1,	'Psychology',	'study-nerds.local:10004',	1,	41),
(39,	1,	'Religion',	'study-nerds.local:10004',	1,	42),
(40,	1,	'Sociology',	'study-nerds.local:10004',	1,	43),
(41,	1.6,	'Statistics',	'study-nerds.local:10004',	1,	44);

CREATE TABLE `ops_upsells` (
  `upsell_id` int(11) NOT NULL,
  `upsell_name` varchar(200) NOT NULL,
  `upsell_value` varchar(100) NOT NULL,
  `upsell_checked` varchar(255) DEFAULT NULL,
  `upsell_activated` int(11) NOT NULL,
  `upsell_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`upsell_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_upsells` (`upsell_id`, `upsell_name`, `upsell_value`, `upsell_checked`, `upsell_activated`, `upsell_type`) VALUES
(7,	'Get Writer Samples',	'5',	NULL,	0,	'perpage'),
(8,	'Get Copy of Sources',	'20',	NULL,	0,	'perpage'),
(9,	'Progressive Delivery',	'15',	NULL,	0,	'perpage');

CREATE TABLE `ops_witerquality` (
  `rate_writerid` int(11) NOT NULL AUTO_INCREMENT,
  `id` int(11) NOT NULL,
  PRIMARY KEY (`rate_writerid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `ops_wpayments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `writer_id` int(11) NOT NULL,
  `order_id` int(11) NOT NULL,
  `cost` varchar(255) DEFAULT NULL,
  `fine` varchar(255) DEFAULT '0',
  `tcost` varchar(255) DEFAULT NULL,
  `payment_date` varchar(255) DEFAULT NULL,
  `status` int(255) DEFAULT NULL,
  `order_completeddate` varchar(255) DEFAULT NULL,
  `order_approveddate` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `ops_wpayments` (`id`, `writer_id`, `order_id`, `cost`, `fine`, `tcost`, `payment_date`, `status`, `order_completeddate`, `order_approveddate`) VALUES
(1,	7871,	30153,	'3.5',	'0',	'20.52',	'21',	0,	'2022-01-03 09:37:27',	'2022-01-03 09:37:27'),
(2,	7871,	30156,	'3.5',	'0',	'16.2',	'21',	0,	'2022-01-06 10:49:30',	'2022-01-06 10:49:30');

CREATE TABLE `ops_wrcat` (
  `wrcat_id` int(11) NOT NULL,
  `wrcat_value` float NOT NULL,
  `wrcat_name` varchar(20) NOT NULL,
  `wrcat_desc` text NOT NULL,
  `wrcat_checked` varchar(10) NOT NULL,
  `wrcat_numpick` int(11) NOT NULL,
  `wrcat_pick` varchar(10) NOT NULL,
  `wrcat_perm` int(11) NOT NULL,
  `wrcat_perpage` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`wrcat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `ops_wrcat` (`wrcat_id`, `wrcat_value`, `wrcat_name`, `wrcat_desc`, `wrcat_checked`, `wrcat_numpick`, `wrcat_pick`, `wrcat_perm`, `wrcat_perpage`) VALUES
(1,	1,	'Standard',	'Standard Price writers',	'checked',	1,	'NO',	0,	'3.5'),
(2,	1.5,	'Premium',	'High-rank professional writer, proficient in the requested field of study',	'',	2,	'NO',	0,	'3.9'),
(3,	1.6,	'Platinum',	'English as a native language writer (US, UK, CA, AU writers)',	'',	3,	'YES',	0,	'4.5');

CREATE TABLE `ops_writerlevels` (
  `writerlevel_id` int(11) NOT NULL,
  `writerlevel_name` varchar(50) NOT NULL,
  `writerlevel_perm` int(11) NOT NULL,
  PRIMARY KEY (`writerlevel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_writers` (
  `writer_id` int(11) NOT NULL AUTO_INCREMENT,
  `writer_fname` varchar(250) NOT NULL,
  `writer_sname` varchar(250) NOT NULL,
  `writer_nickname` varchar(200) NOT NULL,
  `writer_email` varchar(200) NOT NULL,
  `writer_pass` varchar(200) NOT NULL,
  `writer_proimg` varchar(150) NOT NULL,
  `writer_bio` text NOT NULL,
  `writer_country` varchar(200) NOT NULL,
  `writer_city` varchar(200) NOT NULL,
  `writer_phone` varchar(50) NOT NULL,
  `writer_citation` varchar(50) NOT NULL,
  `writer_edulevel` varchar(50) NOT NULL,
  `writer_subjects` varchar(100) NOT NULL,
  `writer_lang` varchar(50) NOT NULL,
  `writer_status` varchar(10) NOT NULL,
  `writer_paymethod` varchar(50) NOT NULL,
  `writer_paydetails` text NOT NULL,
  `writer_level` varchar(30) NOT NULL,
  `writer_logged` varchar(10) NOT NULL,
  `writer_registered` datetime NOT NULL,
  `writer_site` varchar(255) NOT NULL,
  `writer_authkey` varchar(255) NOT NULL,
  `writer_available` int(11) NOT NULL,
  `writer_category` varchar(25) NOT NULL,
  `writer_qsn` int(11) NOT NULL,
  `writer_essay` text NOT NULL,
  `writer_essayupload` text NOT NULL,
  `writer_lastlogged` date DEFAULT NULL,
  `writer_activefro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`writer_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `ops_wrpay` (
  `wrpay_id` int(11) NOT NULL,
  `wrpay_orderid` int(11) NOT NULL,
  `wrpay_date` datetime NOT NULL,
  `wrpay_writer` int(11) NOT NULL,
  PRIMARY KEY (`wrpay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


CREATE TABLE `payment_dates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `payment_status` varchar(255) NOT NULL DEFAULT 'unpaid',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `payment_dates` (`id`, `name`, `status`, `payment_status`) VALUES
(7,	'5th may 2021',	0,	'unpaid'),
(8,	'20th may 2021',	0,	'unpaid'),
(9,	'20th August 2021',	0,	'unpaid'),
(10,	'5th September 2021',	0,	'unpaid'),
(11,	'20th September  2021',	0,	'unpaid'),
(12,	'5th Oct 2021',	0,	'unpaid'),
(13,	'20th Oct 2021',	0,	'unpaid'),
(14,	'5th Nov 2021',	0,	'unpaid'),
(15,	'20th Nov 2021',	0,	'unpaid'),
(16,	'5th Dec 2021',	0,	'unpaid'),
(18,	'20th Dec 2021',	0,	'unpaid'),
(20,	'5th Jan 2022',	0,	'unpaid'),
(21,	'20th jan 2022',	0,	'unpaid'),
(22,	'5th April 2022',	0,	'unpaid'),
(23,	'16th April 2022',	0,	'unpaid'),
(24,	'18th April 2022',	0,	'unpaid'),
(25,	'20th April 2022',	0,	'paid'),
(26,	'5th May 2022',	0,	'paid'),
(27,	'20th may 2022',	0,	'paid'),
(28,	'5th June 2022',	0,	'paid'),
(29,	'20th June 2022',	0,	'paid'),
(30,	'5th July 2022',	0,	'paid'),
(31,	'20th July 2022',	0,	'paid'),
(32,	'5th August 2022',	1,	'unpaid');

-- 2023-02-11 22:53:42
