![\"\"](\"http://odisha1.designtoday.net.in/images/about-image.jpg\")
DI TECHNICAL
', NULL, NULL, '2021-11-23 14:01:47'), (5, '1', 'meta_keyword', 'site', 'meta keyword', 'Ditechnical
', NULL, NULL, '2021-11-09 13:03:13'), (6, '1', 'meta_description', 'site', 'meta description', 'Ditechnical
', NULL, NULL, '2021-11-09 13:03:21'), (7, '2', 'og_image', 'site', 'og image', 'c2M07CuDxRwnOdz1k3Ba.png', 'please use 40x40 image', NULL, '2021-11-09 13:03:58'), (8, '1', 'og_title', 'site', 'Og title', 'DI TECHNICAL
', NULL, NULL, '2021-12-12 15:09:33'), (9, '1', 'og_description', 'site', 'og description', 'Ditechnical
', NULL, NULL, '2021-11-09 13:04:07'); -- -------------------------------------------------------- -- -- Table structure for table `contact_us` -- CREATE TABLE `contact_us` ( `id` bigint(20) UNSIGNED NOT NULL, `services` varchar(100) DEFAULT NULL, `name` varchar(150) NOT NULL, `email` varchar(150) NOT NULL, `phone` varchar(15) NOT NULL, `message` text NOT NULL, `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0=>New,1=>Read,3=>Delete', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `contact_us` -- INSERT INTO `contact_us` (`id`, `services`, `name`, `email`, `phone`, `message`, `status`, `created_at`, `updated_at`) VALUES (1, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'cfsavfafv', 0, '2021-11-10 19:22:51', '2021-11-10 19:22:51'), (2, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'ergsdrg', 0, '2021-11-10 19:27:24', '2021-11-10 19:27:24'), (3, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'csacfascf', 0, '2021-11-12 16:04:54', '2021-11-12 16:04:54'), (4, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'hsbcbadshibfvhia', 0, '2021-11-12 16:05:24', '2021-11-12 16:05:24'), (5, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'cascacas', 0, '2021-11-12 16:09:06', '2021-11-12 16:09:06'); -- -------------------------------------------------------- -- -- Table structure for table `courses` -- CREATE TABLE `courses` ( `id` bigint(20) NOT NULL, `name` varchar(255) DEFAULT NULL, `no_of_reviews` varchar(20) DEFAULT NULL, `students_enrolled` varchar(20) DEFAULT NULL, `course_language` varchar(100) DEFAULT NULL, `course_level` varchar(100) DEFAULT NULL, `what_you_will_learn` text DEFAULT NULL, `jobs_that_require_this_skill` text DEFAULT NULL, `requirements` text DEFAULT NULL, `time` bigint(20) DEFAULT NULL, `image` varchar(50) DEFAULT NULL, `price` varchar(20) DEFAULT NULL, `original_price` varchar(100) DEFAULT NULL, `discount_percentage` varchar(10) DEFAULT NULL, `hours_left_for_this_price` varchar(10) DEFAULT NULL, `course_type` text DEFAULT NULL, `short_description` text DEFAULT NULL, `long_description` text DEFAULT NULL, `featured` enum('0','1') NOT NULL DEFAULT '0', `video` varchar(50) DEFAULT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `courses` -- INSERT INTO `courses` (`id`, `name`, `no_of_reviews`, `students_enrolled`, `course_language`, `course_level`, `what_you_will_learn`, `jobs_that_require_this_skill`, `requirements`, `time`, `image`, `price`, `original_price`, `discount_percentage`, `hours_left_for_this_price`, `course_type`, `short_description`, `long_description`, `featured`, `video`, `status`, `created_at`, `updated_at`) VALUES (1, '(DCA) Fundamental of Computer, MS-Office Package, Internet, Typing.', '265', '956', 'Hindi & English', 'Beginner to Advance', '\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n\r\n
\r\n
Students Facilities: -
\r\n\r\nLONG DESCRIPTION
', '1', '163765819300 Adhar Card Aman.pdf', '1', '2021-11-23 14:33:13', '2021-12-11 11:01:03'), (5, '(ADCA) Fundamentals of Computer MS-Office, internet, Tally, DTP', '65', '86', 'Hindi & English', 'Beginner to advanced', 'bsbvsb
', 'bsbsb
', 'bsbs
', 365, '163784447220211125_181643.jpg', '7000', '8000', '12', '24', 'Advanced Diploma in Computer Application', 'Now offline Available only', 'ydtgh
\r\n\r\ncfbdf
\r\n\r\ncvb
', '1', '1637838504I-card (2).pdf', '1', '2021-11-25 16:38:24', '2021-12-15 22:49:45'), (11, 'C Programming', '133', '1231', NULL, 'wqrqrqw qq', 'ad
', 'qeq
', 'qe
', 60, '163784857920211125_192437.jpg', '999', '1331', '213', '311', 'adad', 'C Programming', 'fgdf
', '1', '1638976027Untitled.mp4', '1', '2021-11-25 19:26:19', '2021-12-08 20:37:07'), (12, 'English Typing 40 WPM (Word Per Minutes)', '25', '50', 'English', 'Beginner to Advance', 'English Typing Practice and Test
', '1', '1639108076WhatsApp Video 2021-12-10 at 9.01.06 AM.', '1', '2021-12-10 09:02:07', '2021-12-16 15:40:10'), (13, 'Hindi Typing 40 WPM ( Kruti Dev 010, Kruti Dev 016, Kruti Dev 020)', '36', '68', 'Hindi', 'Beginner to Advance', 'Hindi Typing
', 'Visit Nearest Branch for Learing Hindi Typing
', '1', '1639107852WhatsApp Video 2021-12-10 at 9.01.06 AM.', '1', '2021-12-10 09:14:12', '2021-12-16 15:40:40'), (14, '(DCA & TALLY) Fundamental, MS- Office, Internet, Stock Maintain, Transactions with GST.', '80', '556', 'Hindi & English', 'Beginner to Advance', NULL, NULL, NULL, 180, '163964945420211211_120029.jpg', '5500', '7000', '21', '5', 'DCA & TALLY', 'Now Offline Available Only', 'DCA & Tally
', '1', '1639204605WhatsApp Video 2021-12-10 at 9.01.06 AM.', '1', '2021-12-11 12:06:45', '2021-12-16 15:40:54'); -- -------------------------------------------------------- -- -- Table structure for table `course_modules` -- CREATE TABLE `course_modules` ( `id` bigint(20) NOT NULL, `course_id` bigint(20) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `course_modules` -- INSERT INTO `course_modules` (`id`, `course_id`, `name`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'Course Content', '1', '2021-12-03 14:54:05', '2021-12-12 19:40:05'), (2, 1, 'Module Two', '1', '2021-12-03 14:55:53', '2021-12-03 14:55:53'), (3, 1, 'Module Threes', '1', '2021-12-03 15:08:27', '2021-12-03 15:47:38'), (5, 11, 'Module 1', '1', '2021-12-03 17:58:17', '2021-12-03 17:58:17'); -- -------------------------------------------------------- -- -- Table structure for table `course_module_videos` -- CREATE TABLE `course_module_videos` ( `id` bigint(20) NOT NULL, `course_id` bigint(20) DEFAULT NULL, `module_id` bigint(20) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `video` varchar(50) DEFAULT NULL, `time` varchar(10) DEFAULT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `course_module_videos` -- INSERT INTO `course_module_videos` (`id`, `course_id`, `module_id`, `name`, `video`, `time`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 1, 'Introduction One', '1638800840Untitled.mp4', '18', '1', '2021-12-03 17:39:33', '2021-12-06 19:57:20'), (3, 11, 5, 'OPerator', '1638534543SampleVideo_1280x720_2mb.mp4', '120', '1', '2021-12-03 17:59:03', '2021-12-03 17:59:03'), (4, 1, 2, 'test', '1638542383SampleVideo_1280x720_2mb.mp4', '15', '1', '2021-12-03 20:09:43', '2021-12-03 20:09:43'), (5, 1, 3, 'basic', '1638969867DSC_0045.MOV', '18', '1', '2021-12-08 18:54:27', '2021-12-08 18:54:27'); -- -------------------------------------------------------- -- -- Table structure for table `email_content` -- CREATE TABLE `email_content` ( `id` int(11) NOT NULL, `email_code` varchar(250) DEFAULT NULL, `about` text DEFAULT NULL, `subject` text DEFAULT NULL, `body` text DEFAULT NULL, `status` enum('0','1','3') DEFAULT '0', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_content` -- INSERT INTO `email_content` (`id`, `email_code`, `about`, `subject`, `body`, `status`, `created_at`, `updated_at`) VALUES (1, 'new_account_create_for_student', 'A new student account create by Admin', 'New Account Create', 'Hello {{NAME}},
\r\n\r\nCongratulations!! Your new account successfully created by admin as a Student.
\r\n\r\nYour login credentials are given:
\r\n\r\nRegistration Id: {{REGISTRATIONID}}
\r\nLogin Email: {{EMAIL}}
\r\nLogin Password: {{PASSWORD}}
\r\nLogin Link: {{URL}}
Hello {{NAME}},
\r\n\r\nPlease click the below link to change reset your password.
\r\n ', '1', NULL, NULL), (3, 'user_registration', 'Student Registration', 'Student Registration', 'Hello {{NAME}},
\r\n\r\nCongratulations!! You have successfully registered for The DI TECHNICAL as a Student.
\r\n\r\nRegistration Id: {{REGISTRATIONID}}
\r\n\r\nPlease click on the link below to activate your account.
\r\n\r\n', '0', NULL, '2021-12-12 15:11:43'), (5, 'contact_us', 'Contact Us', 'Contact To Admin', 'Hello {{ADMIN}},
\r\n\r\nSomeone contacting you. Please see the below details and reply on it.
\r\n\r\nService: {{SERVICE}}
\r\n\r\nName: {{NAME}}
\r\n\r\nEmail: {{EMAIL}}
\r\n\r\nPhone: {{PHONE}}
\r\n\r\nMessage: {{MESSAGE}}
', '1', '2020-03-28 00:00:00', '2021-12-08 18:29:26'), (6, 'purchase_course', 'Purchase Course', 'Purchase Course to student', '\r\n\r\n
Hello {{NAME}},
\r\n\r\nYour course order has been placed successfully.
\r\n\r\nPlease check your dashboard to start the journey.
\r\n\r\nThanking You,
\r\n\r\n{{TITLE}}
', '1', '2020-03-28 00:00:00', '2021-12-12 15:16:47'), (7, 'purchase_course_admin', 'Purchase Course Admin', 'Purchase Course', 'Hello Admin!!,
\r\n\r\nCongratulations.
\r\nSomeone has placed an order on your website.
Order amount: {{TOTALAMOUNT}}
\r\n\r\nPlease look into it.
\r\n\r\nThanking You,
\r\n\r\n{{TITLE}}
', '1', '2020-03-28 00:00:00', '2021-12-12 15:14:34'), (9, 'admin_pass_exam', 'Admin Pass Exam Notification', 'Admin Pass Exam Notification', 'Hello Admin,
\r\n\r\nCongratulations!! {{STUDENT_NAME}} succesfully cleared the exam for {{COURSENAME}} course with below marks.
\r\n\r\nTheory Marks: {{THEORY}}
\r\n\r\nPractical Marks: {{PRACTICAL}}
\r\n\r\nViva Marks: {{VIVA}}
\r\n\r\n
\r\n
Hello {{NAME}},
\r\n\r\nCongratulations!! You are succesfully cleared the exam for {{COURSENAME}} course with below marks.
\r\n\r\nTheory Marks: {{THEORY}}
\r\n\r\nPractical Marks: {{PRACTICAL}}
\r\n\r\nViva Marks: {{VIVA}}
\r\n\r\nYou can download your marksheet and certificate from courses section of your dashboard.
\r\n\r\n
\r\n
Hello {{ADMIN}},
\r\n\r\nSomeone request for franchise. Please see the below details and reply on it.
\r\n\r\nName: {{NAME}}
\r\n\r\nEmail: {{EMAIL}}
\r\n\r\nPhone: {{PHONE}}
\r\n\r\nAddress: {{ADDRESS}}
', '1', '2020-03-28 00:00:00', '2021-11-10 13:52:30'), (12, 'enquiry', 'Enquiry', 'Contact To Admin', 'Hello {{ADMIN}},
\r\n\r\nSomeone enquire you. Please see the below details and reply on it.
\r\n\r\nService: {{SERVICE}}
\r\n\r\nName: {{NAME}}
\r\n\r\nEmail: {{EMAIL}}
\r\n\r\nPhone: {{PHONE}}
\r\n\r\nAddress: {{ADDRESS}}
\r\n\r\nMessage: {{MESSAGE}}
', '1', '2020-03-28 00:00:00', '2021-12-08 18:27:02'); -- -------------------------------------------------------- -- -- Table structure for table `enquiry` -- CREATE TABLE `enquiry` ( `id` bigint(20) NOT NULL, `services` varchar(100) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(15) DEFAULT NULL, `address` text DEFAULT NULL, `message` text DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `enquiry` -- INSERT INTO `enquiry` (`id`, `services`, `name`, `email`, `phone`, `address`, `message`, `created_at`, `updated_at`) VALUES (1, NULL, 'dsg', 'as173533@gmail.com', '8981365361', 'gsdgsgsg', 'gsgsgs', '2021-11-10 16:54:40', '2021-11-10 16:54:40'), (2, NULL, 'terst', 'as173533@gmail.com', '8981365361', 'sadfas', 'cfascfas', '2021-11-10 17:04:29', '2021-11-10 17:04:29'), (3, NULL, 'terst', 'as173533@gmail.com', '8981365361', 'dcasc', 'ascaca', '2021-11-10 17:34:18', '2021-11-10 17:34:18'), (4, NULL, 'terst', 'albert@yopmail.com', '8981365361', 'hcjhvbsd', 'chvshjvbjs', '2021-11-10 18:44:40', '2021-11-10 18:44:40'), (5, NULL, 'Sunil Kumar', 'sunilv1615@gmail.com', '7870177147', 'DT-780 DAM SIDE DHURWA RANCHI', 'Sir mere ko admission lena hai kaise le ( Testing)', '2021-11-24 09:25:16', '2021-11-24 09:25:16'), (6, NULL, 'ranjan kumar', 'sunilv1615@gmail.com', '7870177147', 'Dhurwa ranchi Jharkhand', 'Help me Course purchasing', '2021-12-07 18:05:01', '2021-12-07 18:05:01'), (7, 'New Franchise', 'Test', 'albert@yopmail.com', '9876543210', 'sdvbs', 'sdgbsw', '2021-12-08 18:46:54', '2021-12-08 18:46:54'), (8, 'New Franchise', 'AVINASH', 'anilv1615@gmail.com', '7870177147', 'fhurwa busstand ranchi\r\nSHIV GANJ HARMU\r\nGPO RANCHI', 'for new franchise', '2021-12-09 08:54:59', '2021-12-09 08:54:59'), (9, 'Student', 'AVINASH', 'anilv1615@gmail.com', '7870177147', '81\r\nSHIV GANJ HARMU\r\nGPO RANCHI', 'testing', '2021-12-09 21:00:48', '2021-12-09 21:00:48'); -- -------------------------------------------------------- -- -- Table structure for table `exams` -- CREATE TABLE `exams` ( `id` bigint(20) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `course_id` bigint(20) DEFAULT NULL, `q1_id` int(10) DEFAULT NULL, `q1_answer` varchar(10) DEFAULT NULL, `q2_id` int(10) DEFAULT NULL, `q2_answer` varchar(10) DEFAULT NULL, `q3_id` int(10) DEFAULT NULL, `q3_answer` varchar(10) DEFAULT NULL, `q4_id` int(10) DEFAULT NULL, `q4_answer` varchar(10) DEFAULT NULL, `q5_id` int(10) DEFAULT NULL, `q5_answer` varchar(10) DEFAULT NULL, `q6_id` int(10) DEFAULT NULL, `q6_answer` varchar(10) DEFAULT NULL, `q7_id` int(10) DEFAULT NULL, `q7_answer` varchar(10) DEFAULT NULL, `q8_id` int(10) DEFAULT NULL, `q8_answer` varchar(10) DEFAULT NULL, `q9_id` int(10) DEFAULT NULL, `q9_answer` varchar(10) DEFAULT NULL, `q10_id` int(10) DEFAULT NULL, `q10_answer` varchar(10) DEFAULT NULL, `q11_id` int(10) DEFAULT NULL, `q11_answer` varchar(10) DEFAULT NULL, `q12_id` int(10) DEFAULT NULL, `q12_answer` varchar(10) DEFAULT NULL, `q13_id` int(10) DEFAULT NULL, `q13_answer` varchar(10) DEFAULT NULL, `q14_id` int(10) DEFAULT NULL, `q14_answer` varchar(10) DEFAULT NULL, `q15_id` int(10) DEFAULT NULL, `q15_answer` varchar(10) DEFAULT NULL, `q16_id` int(10) DEFAULT NULL, `q16_answer` varchar(10) DEFAULT NULL, `q17_id` int(10) DEFAULT NULL, `q17_answer` varchar(10) DEFAULT NULL, `q18_id` int(10) DEFAULT NULL, `q18_answer` varchar(10) DEFAULT NULL, `q19_id` int(10) DEFAULT NULL, `q19_answer` varchar(10) DEFAULT NULL, `q20_id` int(10) DEFAULT NULL, `q20_answer` varchar(10) DEFAULT NULL, `q21_id` int(10) DEFAULT NULL, `q21_answer` varchar(10) DEFAULT NULL, `q22_id` int(10) DEFAULT NULL, `q22_answer` varchar(10) DEFAULT NULL, `q23_id` int(10) DEFAULT NULL, `q23_answer` varchar(10) DEFAULT NULL, `q24_id` int(10) DEFAULT NULL, `q24_answer` varchar(10) DEFAULT NULL, `q25_id` int(10) DEFAULT NULL, `q25_answer` varchar(10) DEFAULT NULL, `q26_id` int(10) DEFAULT NULL, `q26_answer` varchar(10) DEFAULT NULL, `q27_id` int(10) DEFAULT NULL, `q27_answer` varchar(10) DEFAULT NULL, `q28_id` int(10) DEFAULT NULL, `q28_answer` varchar(10) DEFAULT NULL, `q29_id` int(10) DEFAULT NULL, `q29_answer` varchar(10) DEFAULT NULL, `q30_id` int(10) DEFAULT NULL, `q30_answer` varchar(10) DEFAULT NULL, `q31_id` int(10) DEFAULT NULL, `q31_answer` varchar(10) DEFAULT NULL, `q32_id` int(10) DEFAULT NULL, `q32_answer` varchar(10) DEFAULT NULL, `q33_id` int(10) DEFAULT NULL, `q33_answer` varchar(10) DEFAULT NULL, `q34_id` int(10) DEFAULT NULL, `q34_answer` varchar(10) DEFAULT NULL, `q35_id` int(10) DEFAULT NULL, `q35_answer` varchar(10) DEFAULT NULL, `q36_id` int(10) DEFAULT NULL, `q36_answer` varchar(10) DEFAULT NULL, `q37_id` int(10) DEFAULT NULL, `q37_answer` varchar(10) DEFAULT NULL, `q38_id` int(10) DEFAULT NULL, `q38_answer` varchar(10) DEFAULT NULL, `q39_id` int(10) DEFAULT NULL, `q39_answer` varchar(10) DEFAULT NULL, `q40_id` int(10) DEFAULT NULL, `q40_answer` varchar(10) DEFAULT NULL, `q41_id` int(10) DEFAULT NULL, `q41_answer` varchar(10) DEFAULT NULL, `q42_id` int(10) DEFAULT NULL, `q42_answer` varchar(10) DEFAULT NULL, `q43_id` int(10) DEFAULT NULL, `q43_answer` varchar(10) DEFAULT NULL, `q44_id` int(10) DEFAULT NULL, `q44_answer` varchar(10) DEFAULT NULL, `q45_id` int(10) DEFAULT NULL, `q45_answer` varchar(10) DEFAULT NULL, `q46_id` int(10) DEFAULT NULL, `q46_answer` varchar(10) DEFAULT NULL, `q47_id` int(10) DEFAULT NULL, `q47_answer` varchar(10) DEFAULT NULL, `q48_id` int(10) DEFAULT NULL, `q48_answer` varchar(10) DEFAULT NULL, `q49_id` int(10) DEFAULT NULL, `q49_answer` varchar(10) DEFAULT NULL, `q50_id` int(10) DEFAULT NULL, `q50_answer` varchar(10) DEFAULT NULL, `supply_exam_fees` enum('0','1') NOT NULL DEFAULT '0', `status` enum('0','1') NOT NULL DEFAULT '0', `admin_marks_submit` enum('0','1') NOT NULL DEFAULT '0', `next_exam_date` datetime DEFAULT NULL, `theory` varchar(10) DEFAULT NULL, `practical` varchar(10) DEFAULT NULL, `viva` varchar(10) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `exams` -- INSERT INTO `exams` (`id`, `user_id`, `course_id`, `q1_id`, `q1_answer`, `q2_id`, `q2_answer`, `q3_id`, `q3_answer`, `q4_id`, `q4_answer`, `q5_id`, `q5_answer`, `q6_id`, `q6_answer`, `q7_id`, `q7_answer`, `q8_id`, `q8_answer`, `q9_id`, `q9_answer`, `q10_id`, `q10_answer`, `q11_id`, `q11_answer`, `q12_id`, `q12_answer`, `q13_id`, `q13_answer`, `q14_id`, `q14_answer`, `q15_id`, `q15_answer`, `q16_id`, `q16_answer`, `q17_id`, `q17_answer`, `q18_id`, `q18_answer`, `q19_id`, `q19_answer`, `q20_id`, `q20_answer`, `q21_id`, `q21_answer`, `q22_id`, `q22_answer`, `q23_id`, `q23_answer`, `q24_id`, `q24_answer`, `q25_id`, `q25_answer`, `q26_id`, `q26_answer`, `q27_id`, `q27_answer`, `q28_id`, `q28_answer`, `q29_id`, `q29_answer`, `q30_id`, `q30_answer`, `q31_id`, `q31_answer`, `q32_id`, `q32_answer`, `q33_id`, `q33_answer`, `q34_id`, `q34_answer`, `q35_id`, `q35_answer`, `q36_id`, `q36_answer`, `q37_id`, `q37_answer`, `q38_id`, `q38_answer`, `q39_id`, `q39_answer`, `q40_id`, `q40_answer`, `q41_id`, `q41_answer`, `q42_id`, `q42_answer`, `q43_id`, `q43_answer`, `q44_id`, `q44_answer`, `q45_id`, `q45_answer`, `q46_id`, `q46_answer`, `q47_id`, `q47_answer`, `q48_id`, `q48_answer`, `q49_id`, `q49_answer`, `q50_id`, `q50_answer`, `supply_exam_fees`, `status`, `admin_marks_submit`, `next_exam_date`, `theory`, `practical`, `viva`, `created_at`, `updated_at`) VALUES (1, 5, 1, 5, 'option1', 6, 'option1', 7, 'option1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '1', '2021-12-20 00:00:00', '65', '15', '8', '2021-11-20 20:36:53', '2021-12-06 21:00:58'), (2, 7, 2, 5, 'option2', 1, 'option2', 2, 'option4', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', '0', '2021-12-23 00:00:00', '0', NULL, NULL, '2021-11-23 14:17:29', '2021-11-23 14:20:57'), (3, 10, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0', '0', '2021-12-23 00:00:00', NULL, NULL, NULL, '2021-11-23 20:42:16', '2021-11-23 20:44:19'), (4, 69, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '1', '1', '2021-12-16 00:00:00', '60', '15', '9', '2021-12-09 18:21:31', '2021-12-09 18:23:33'), (5, 70, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', '0', '0', '2021-12-16 00:00:00', NULL, NULL, NULL, '2021-12-09 19:39:12', '2021-12-09 19:39:12'); -- -------------------------------------------------------- -- -- Table structure for table `franchise_request` -- CREATE TABLE `franchise_request` ( `id` bigint(20) NOT NULL, `name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(15) DEFAULT NULL, `address` text DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `franchise_request` -- INSERT INTO `franchise_request` (`id`, `name`, `email`, `phone`, `address`, `created_at`, `updated_at`) VALUES (1, 'test', 'albert@yopmail.com', '8981365361', 'tsatduyqaygdag,vashciasg', '2021-11-10 13:56:23', '2021-11-10 13:56:23'), (2, 'terst', 'as173533@gmail.com', '8981365361', 'gvsdvsvsd', '2021-11-10 13:57:36', '2021-11-10 13:57:36'), (3, 'terst', 'as173533@gmail.com', '8981365361', 'gvsdvsvsd', '2021-11-10 13:59:11', '2021-11-10 13:59:11'), (4, 'PRAMOD KUMAR SAH', 'sahu199pk@gmail.com', '7482841044', 'PAKTOLA BOKHRA SITAMARHI BIHAR', '2021-12-13 12:57:50', '2021-12-13 12:57:50'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` bigint(20) NOT NULL, `image` varchar(50) DEFAULT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`id`, `image`, `status`, `created_at`, `updated_at`) VALUES (2, '163911712320211210_084034.jpg', '1', '2021-11-27 18:21:46', '2021-12-10 11:48:43'), (3, '163911829420211125_175315.jpg', '1', '2021-11-27 18:21:59', '2021-12-10 12:08:14'), (4, '163911833820211125_181643.jpg', '1', '2021-12-10 12:08:58', '2021-12-10 12:08:58'), (5, '163911835820211125_181241.jpg', '0', '2021-12-10 12:09:18', '2021-12-10 12:10:01'), (6, '163911837420211125_180630.jpg', '1', '2021-12-10 12:09:34', '2021-12-10 12:09:34'); -- -------------------------------------------------------- -- -- Table structure for table `login_history` -- CREATE TABLE `login_history` ( `id` bigint(20) UNSIGNED NOT NULL, `type` enum('login','logout') NOT NULL DEFAULT 'login', `user_master_id` bigint(20) UNSIGNED NOT NULL, `ip` varchar(255) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `login_history` -- INSERT INTO `login_history` (`id`, `type`, `user_master_id`, `ip`, `created_at`) VALUES (1, 'login', 1, '116.206.202.40', '2021-10-11 19:16:44'), (2, 'logout', 1, '116.206.202.40', '2021-10-19 16:12:27'), (3, 'login', 1, '116.206.202.40', '2021-10-19 16:12:27'), (4, 'login', 1, '103.101.212.213', '2021-10-20 13:44:32'), (5, 'logout', 1, '103.101.212.213', '2021-10-20 21:20:31'), (6, 'login', 1, '103.101.212.213', '2021-10-20 21:21:01'), (7, 'login', 1, '115.187.42.209', '2021-10-20 21:21:09'), (8, 'login', 1, '106.202.42.88', '2021-10-21 01:38:34'), (9, 'logout', 1, '103.101.212.213', '2021-10-21 14:55:04'), (10, 'login', 1, '103.101.212.213', '2021-10-21 14:55:04'), (11, 'login', 1, '116.206.202.29', '2021-10-21 19:06:57'), (12, 'logout', 1, '116.206.202.29', '2021-10-21 19:07:36'), (13, 'login', 1, '116.206.202.29', '2021-10-21 19:08:04'), (14, 'logout', 1, '103.101.212.213', '2021-10-22 12:37:10'), (15, 'login', 1, '103.101.212.213', '2021-10-22 12:37:10'), (16, 'logout', 1, '103.101.212.213', '2021-10-22 18:24:22'), (17, 'login', 1, '103.101.212.213', '2021-10-22 18:24:22'), (18, 'logout', 1, '103.101.212.213', '2021-10-23 16:24:58'), (19, 'login', 1, '103.101.212.213', '2021-10-23 16:24:58'), (20, 'login', 1, '103.87.143.157', '2021-10-25 13:49:40'), (21, 'logout', 1, '115.187.42.209', '2021-10-25 18:30:25'), (22, 'login', 1, '115.187.42.209', '2021-10-25 18:30:25'), (23, 'login', 1, '103.101.212.133', '2021-10-27 11:31:43'), (24, 'login', 1, '146.196.45.2', '2021-10-27 12:03:48'), (25, 'login', 1, '115.187.42.192', '2021-10-27 14:02:31'), (26, 'logout', 1, '103.101.212.133', '2021-10-27 21:05:35'), (27, 'login', 1, '103.101.212.133', '2021-10-27 21:05:35'), (28, 'logout', 1, '103.101.212.133', '2021-11-02 14:41:12'), (29, 'login', 1, '103.101.212.133', '2021-11-02 14:41:12'), (30, 'logout', 1, '103.101.212.133', '2021-11-02 14:41:22'), (31, 'login', 1, '103.101.212.133', '2021-11-02 14:41:22'), (32, 'login', 1, '::1', '2021-11-08 18:50:57'), (33, 'logout', 1, '::1', '2021-11-08 19:23:47'), (34, 'login', 1, '::1', '2021-11-08 19:24:05'), (35, 'logout', 1, '::1', '2021-11-08 20:48:39'), (36, 'login', 1, '::1', '2021-11-08 20:48:39'), (37, 'logout', 1, '::1', '2021-11-09 12:40:50'), (38, 'login', 1, '::1', '2021-11-09 12:40:50'), (39, 'logout', 1, '::1', '2021-11-10 12:56:42'), (40, 'login', 1, '::1', '2021-11-10 12:56:43'), (41, 'logout', 1, '::1', '2021-11-10 17:00:44'), (42, 'login', 1, '::1', '2021-11-10 17:00:44'), (43, 'logout', 1, '::1', '2021-11-11 12:48:59'), (44, 'login', 1, '::1', '2021-11-11 12:48:59'), (45, 'logout', 1, '::1', '2021-11-11 17:40:56'), (46, 'login', 1, '::1', '2021-11-11 17:40:57'), (47, 'logout', 1, '::1', '2021-11-12 16:11:32'), (48, 'login', 1, '::1', '2021-11-12 16:11:32'), (49, 'logout', 1, '::1', '2021-11-17 10:18:53'), (50, 'login', 1, '::1', '2021-11-17 10:18:53'), (51, 'logout', 1, '::1', '2021-11-17 15:48:22'), (52, 'login', 1, '::1', '2021-11-17 15:48:22'), (53, 'logout', 1, '::1', '2021-11-18 13:44:48'), (54, 'login', 1, '::1', '2021-11-18 13:44:48'), (55, 'logout', 1, '146.196.45.2', '2021-11-18 20:23:51'), (56, 'login', 1, '146.196.45.2', '2021-11-18 20:23:51'), (57, 'login', 1, '103.87.143.152', '2021-11-18 20:38:19'), (58, 'logout', 1, '103.87.143.152', '2021-11-19 10:27:11'), (59, 'login', 1, '103.87.143.152', '2021-11-19 10:27:11'), (60, 'logout', 1, '103.87.143.152', '2021-11-19 11:57:04'), (61, 'login', 1, '103.87.143.152', '2021-11-19 11:57:04'), (62, 'logout', 1, '103.87.143.152', '2021-11-19 12:22:08'), (63, 'login', 1, '103.87.143.152', '2021-11-19 12:22:08'), (64, 'login', 1, '115.187.42.224', '2021-11-19 12:22:09'), (65, 'logout', 1, '146.196.45.2', '2021-11-19 16:16:05'), (66, 'login', 1, '146.196.45.2', '2021-11-19 16:16:05'), (67, 'logout', 1, '103.87.143.152', '2021-11-19 19:40:15'), (68, 'login', 1, '103.87.143.152', '2021-11-19 19:40:15'), (69, 'logout', 1, '103.87.143.152', '2021-11-20 17:35:14'), (70, 'login', 1, '103.87.143.152', '2021-11-20 17:35:14'), (71, 'logout', 1, '146.196.45.2', '2021-11-20 18:32:53'), (72, 'login', 1, '146.196.45.2', '2021-11-20 18:32:53'), (73, 'login', 1, '223.228.248.118', '2021-11-23 13:51:25'), (74, 'login', 1, '157.119.104.254', '2021-11-23 13:52:08'), (75, 'logout', 1, '103.87.143.152', '2021-11-23 14:02:28'), (76, 'login', 1, '103.87.143.152', '2021-11-23 14:02:28'), (77, 'logout', 1, '157.119.104.254', '2021-11-23 14:08:13'), (78, 'login', 1, '157.119.104.254', '2021-11-23 14:08:19'), (79, 'login', 1, '223.228.235.104', '2021-11-24 09:12:56'), (80, 'login', 1, '223.228.243.83', '2021-11-25 15:56:40'), (81, 'login', 1, '27.61.125.94', '2021-11-26 19:41:47'), (82, 'logout', 1, '146.196.45.2', '2021-11-27 11:18:05'), (83, 'login', 1, '146.196.45.2', '2021-11-27 11:18:05'), (84, 'logout', 1, '103.87.143.152', '2021-11-27 11:58:26'), (85, 'login', 1, '103.87.143.152', '2021-11-27 11:58:26'), (86, 'login', 1, '27.61.122.63', '2021-11-27 12:03:51'), (87, 'logout', 1, '27.61.122.63', '2021-11-27 12:22:35'), (88, 'login', 1, '106.206.194.194', '2021-11-27 17:56:13'), (89, 'logout', 1, '103.87.143.152', '2021-11-27 18:12:58'), (90, 'login', 1, '103.87.143.152', '2021-11-27 18:12:58'), (91, 'login', 1, '106.206.199.99', '2021-11-29 07:17:38'), (92, 'login', 1, '223.228.247.117', '2021-11-29 18:41:39'), (93, 'logout', 1, '::1', '2021-11-30 16:24:22'), (94, 'login', 1, '::1', '2021-11-30 16:24:22'), (95, 'logout', 1, '::1', '2021-11-30 19:27:27'), (96, 'login', 1, '::1', '2021-11-30 19:27:27'), (97, 'logout', 1, '::1', '2021-12-02 15:32:06'), (98, 'login', 1, '::1', '2021-12-02 15:32:06'), (99, 'logout', 1, '::1', '2021-12-03 11:40:10'), (100, 'login', 1, '::1', '2021-12-03 11:40:10'), (101, 'logout', 1, '::1', '2021-12-04 16:58:27'), (102, 'login', 1, '::1', '2021-12-04 16:58:27'), (103, 'logout', 1, '103.87.143.152', '2021-12-06 13:08:24'), (104, 'login', 1, '103.87.143.152', '2021-12-06 13:08:24'), (105, 'logout', 1, '103.87.143.152', '2021-12-06 18:05:32'), (106, 'login', 1, '103.87.143.152', '2021-12-06 18:05:32'), (107, 'logout', 1, '146.196.45.2', '2021-12-06 18:43:49'), (108, 'login', 1, '146.196.45.2', '2021-12-06 18:43:49'), (109, 'login', 1, '27.60.238.50', '2021-12-07 09:47:35'), (110, 'logout', 1, '27.60.238.50', '2021-12-07 17:57:50'), (111, 'login', 1, '27.60.238.50', '2021-12-07 17:57:51'), (112, 'login', 1, '115.187.42.253', '2021-12-08 13:07:23'), (113, 'logout', 1, '27.60.238.50', '2021-12-08 17:59:25'), (114, 'login', 1, '27.60.238.50', '2021-12-08 17:59:25'), (115, 'logout', 1, '27.60.238.50', '2021-12-09 08:33:40'), (116, 'login', 1, '27.60.238.50', '2021-12-09 08:33:40'), (117, 'logout', 1, '115.187.42.253', '2021-12-09 18:14:13'), (118, 'login', 1, '115.187.42.253', '2021-12-09 18:14:13'), (119, 'logout', 1, '115.187.42.253', '2021-12-09 18:17:35'), (120, 'logout', 1, '27.60.238.50', '2021-12-10 21:16:04'), (121, 'login', 1, '27.60.238.50', '2021-12-10 21:16:04'), (122, 'logout', 1, '27.60.238.50', '2021-12-11 06:58:00'), (123, 'login', 1, '27.60.238.50', '2021-12-11 06:58:00'), (124, 'login', 1, '223.228.238.229', '2021-12-12 15:04:17'), (125, 'logout', 1, '223.228.238.229', '2021-12-12 19:38:52'), (126, 'login', 1, '223.228.238.229', '2021-12-12 19:38:52'), (127, 'login', 1, '106.208.194.221', '2021-12-15 17:32:43'), (128, 'logout', 1, '106.208.194.221', '2021-12-15 22:42:14'), (129, 'login', 1, '106.208.194.221', '2021-12-15 22:42:14'); -- -------------------------------------------------------- -- -- Table structure for table `module_view_video` -- CREATE TABLE `module_view_video` ( `id` bigint(20) NOT NULL, `user_id` bigint(20) DEFAULT NULL, `video_id` bigint(20) DEFAULT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `module_view_video` -- INSERT INTO `module_view_video` (`id`, `user_id`, `video_id`, `created_at`, `updated_at`) VALUES (1, 5, 1, '2021-12-09 16:47:05', '2021-12-09 16:47:05'), (2, 5, 7, '2021-12-09 21:29:39', '2021-12-09 21:29:39'); -- -------------------------------------------------------- -- -- Table structure for table `orders` -- CREATE TABLE `orders` ( `id` bigint(20) NOT NULL, `order_number` varchar(50) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `course_id` bigint(20) DEFAULT NULL, `full_name` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `phone` varchar(15) DEFAULT NULL, `pay_amount` varchar(50) DEFAULT NULL, `payment_id` varchar(100) DEFAULT NULL, `status` enum('0','1','3') NOT NULL DEFAULT '0', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `orders` -- INSERT INTO `orders` (`id`, `order_number`, `user_id`, `course_id`, `full_name`, `email`, `phone`, `pay_amount`, `payment_id`, `status`, `created_at`, `updated_at`) VALUES (1, '69fWIi1C', 5, 2, 'Akash Sarkar', 'albert@yopmail.com', '8981365361', '321', 'pay_IKeys8nTax5CRm', '0', '2021-11-12 16:01:26', '2021-11-12 16:01:26'), (2, 'M1KIcRZY', 7, 2, 'SUNIL KUMAR', 'anilv1615@gmail.com', '7870177147', '321', 'pay_IOz1qhDUoQw3YO', '0', '2021-11-23 14:14:09', '2021-11-23 14:14:09'), (3, 'DKOWgL7I', 10, 2, 'Anil Kumar', 'alkasinha0000@gmail.com', '7488535331', '321', 'pay_IP5aiCXLXhbslK', '0', '2021-11-23 20:39:24', '2021-11-23 20:39:24'), (5, 'Um69x8K2', 5, 1, 'Akash Sarkar', 'albert@yopmail.com', '8981365361', '1299', '01ed6c06fd83669ad385', '1', '2021-12-04 18:07:12', '2021-12-04 18:07:12'), (6, 'bO68qZo1', 69, 5, 'Sougat Basu', 'albert1@yopmail.com', '989898987', '1999', 'ba83f4ed51bde2c793c2', '1', '2021-12-09 18:19:51', '2021-12-09 18:19:51'); -- -------------------------------------------------------- -- -- Table structure for table `questions_answers` -- CREATE TABLE `questions_answers` ( `id` bigint(20) NOT NULL, `course` bigint(20) DEFAULT NULL, `question` text DEFAULT NULL, `option1` text DEFAULT NULL, `option2` text DEFAULT NULL, `option3` text DEFAULT NULL, `option4` text DEFAULT NULL, `answer` varchar(10) DEFAULT NULL, `status` enum('0','1') NOT NULL DEFAULT '1', `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `questions_answers` -- INSERT INTO `questions_answers` (`id`, `course`, `question`, `option1`, `option2`, `option3`, `option4`, `answer`, `status`, `created_at`, `updated_at`) VALUES (5, 2, 'Related to unit of not memory capicity ?
', 'GB', 'TB', 'HB', 'ZB', 'option3', '1', '2021-10-06 23:57:34', '2021-11-24 09:32:32'), (6, 2, 'Which categories of computers does pc belong to ?
', 'mini computer', 'mainframe computer', 'supper computer', 'Micro computer', 'option4', '1', '2021-11-24 09:38:04', '2021-11-24 09:38:04'), (7, 2, 'File system permanently save in which memory ?
', 'primary', 'Secondry', 'Device', 'Direct memory', 'option2', '1', '2021-11-24 09:45:56', '2021-11-24 09:45:56'); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` int(10) UNSIGNED NOT NULL, `slug` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `type` set('text','textarea','password','select','select-multiple','radio','checkbox') COLLATE utf8_unicode_ci NOT NULL, `default` text COLLATE utf8_unicode_ci NOT NULL, `value` text COLLATE utf8_unicode_ci NOT NULL, `options` text COLLATE utf8_unicode_ci NOT NULL, `is_required` int(1) NOT NULL, `is_gui` int(1) NOT NULL, `module` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `row_order` int(10) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `slug`, `title`, `description`, `type`, `default`, `value`, `options`, `is_required`, `is_gui`, `module`, `row_order`) VALUES (1, 'admin_email', 'Admin Email', 'Admin Email', 'text', 'admin@odishaone.com', 'info@ditechnical.in', '', 1, 1, 'General', 1), (2, 'admin_contact', 'Admin Contact', 'Admin Contact', 'text', '+9198454646474', '8210066756', '', 1, 1, 'General', 2), (3, 'facebook_url', 'Facebook', '', 'text', 'https://www.facebook.com/', 'https://www.facebook.com/people/Anil-Verma/100018097200701/', '', 1, 1, 'Social Link', 5), (4, 'whatsapp_url', 'Whatsapp', '', 'text', 'https://whatsapp.com/', 'http://wa.me/918210066756', '', 1, 1, 'Social Link', 0), (5, 'instagram_url', 'Instagram', '', 'text', 'https://instragram.com/', 'https://www.instagram.com/di__technical/?utm_medium=copy_link', '', 1, 1, 'Social Link', 0), (6, 'youtube_url', 'Youtube', '', 'text', 'https://youtube.com/', 'https://www.youtube.com/channel/UC37J_56JK4-7JKlZyX4eJGQ', '', 1, 1, 'Social Link', 0), (7, 'telegram_url', 'Telegram', '', 'text', 'https://telegram.com/', 'https://t.me/ditechnical', '', 1, 1, 'Social Link', 0), (14, 'support_email', 'Support Email', 'This would be used as a sender email.', 'text', 'support@ditachnical.in', 'info@ditechnical.in', '', 1, 1, 'Support', 4), (15, 'support_name', 'Support Name', 'In mail this name will be use a sender name', 'text', 'admin', 'DITECHNICAL Support', '', 1, 1, 'Support', 3), (20, 'site_location', 'Site Location', 'Site Location', 'text', 'Shop 1050,Westfield Hornsby 2077', 'Dhurwa Bus Stand Ranchi (Near Loyola Nursery school) Dhurwa, Ranchi 834004, Jharkhand, india', '', 1, 1, 'Location', 1), (21, 'site_phone', 'Site Phone No', 'Site Phone No', 'text', '0451 771 768', '+91 8210066756', '', 1, 1, 'Location', 2), (22, 'site_email', 'Site Contact Email', 'Site Contact Email', 'text', 'info@ditachnical.in', 'info@ditechnical.in', '', 1, 1, 'Location', 3), (23, 'site_phone_two', 'Site Phone No Two', 'Site Phone No Two', 'text', '0451 771 768', '+91 7870177197', '', 1, 1, 'Location', 2), (24, 'merchant_key', 'MERCHANT KEY', 'MERCHANT KEY', 'text', '', 'Ft8Oi5', '', 1, 1, 'PayuMoney', 0), (25, 'salt', 'SALT', 'SALT', 'text', '', 't11J4953', '', 1, 1, 'PayuMoney', 1), (26, 'pass_marks', 'EXAM PASS MARKS(70)', 'EXAM PASS MARKS(70)', 'text', '', '30', '', 1, 1, 'Exam', 1), (27, 'exam_time', 'EXAM TIME(Minute)', 'EXAM TIME(Minute)', 'text', '', '30', '', 1, 1, 'Exam', 2), (28, 'supply_exam_fees', 'Supply Exam Fees', 'Supply Exam Fees', 'text', '', '100', '', 1, 1, 'Exam', 2), (29, 'supply_exam_duration', 'Supply Exam Duration(Days)', 'Supply Exam Duration(Days)', 'text', '', '7', '', 1, 1, 'Exam', 2), (35, 'test_mode', 'Test Mode', 'Test Mode', 'radio', 'Yes', '0', '1=YES|0=NO', 1, 1, 'PayuMoney', 2), (36, 'old_version', 'Old Version', 'Old Version', 'text', 'http://www.ditechnicalofficial.com', 'http://www.ditechnicalofficial.com', '', 1, 1, 'Old Version', 2); -- -------------------------------------------------------- -- -- Table structure for table `sliders` -- CREATE TABLE `sliders` ( `id` int(191) UNSIGNED NOT NULL, `title_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `details_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `link` text DEFAULT NULL, `photo` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` enum('0','1','3') NOT NULL DEFAULT '1' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `sliders` -- INSERT INTO `sliders` (`id`, `title_text`, `details_text`, `link`, `photo`, `status`) VALUES (15, 'First Slider', '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."
\r\n\r\n"Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?"
\r\n\r\n"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?"
', NULL, '2020-09-03 06:03:22'), (2, 'how_it_works', 'How It Works', '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum."
"Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur?"
"But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth, the master-builder of human happiness. No one rejects, dislikes, or avoids pleasure itself, because it is pleasure, but because those who do not know how to pursue pleasure rationally encounter consequences that are extremely painful. Nor again is there anyone who loves or pursues or desires to obtain pain of itself, because it is pain, but because occasionally circumstances occur in which toil and pain can procure him some great pleasure. To take a trivial example, which of us ever undertakes laborious physical exercise, except to obtain some advantage from it? But who has any right to find fault with a man who chooses to enjoy a pleasure that has no annoying consequences, or one who avoids a pain that produces no resultant pleasure?"
', NULL, NULL), (3, 'privacy_policy', 'Privacy Policy', 'Last updated: November 20, 2021
\r\n\r\nThis Privacy Policy describes Our policies and procedures on the collection, use and disclosure of Your information when You use the Service and tells You about Your privacy rights and how the law protects You.
\r\n\r\nWe use Your Personal data to provide and improve the Service. By using the Service, You agree to the collection and use of information in accordance with this Privacy Policy.
\r\n\r\nThe words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.
\r\n\r\nFor the purposes of this Privacy Policy:
\r\n\r\nAccount means a unique account created for You to access our Service or parts of our Service.
\r\nCompany (referred to as either "the Company", "We", "Us" or "Our" in this Agreement) refers to ditechnical.in.
\r\nCookies are small files that are placed on Your computer, mobile device or any other device by a website, containing the details of Your browsing history on that website among its many uses.
\r\nCountry refers to: Jharkhand, India
\r\nDevice means any device that can access the Service such as a computer, a cellphone or a digital tablet.
\r\nPersonal Data is any information that relates to an identified or identifiable individual.
\r\nService refers to the Website.
\r\nService Provider means any natural or legal person who processes the data on behalf of the Company. It refers to third-party companies or individuals employed by the Company to facilitate the Service, to provide the Service on behalf of the Company, to perform services related to the Service or to assist the Company in analyzing how the Service is used.
\r\nUsage Data refers to data collected automatically, either generated by the use of the Service or from the Service infrastructure itself (for example, the duration of a page visit).
\r\nWebsite refers to ditechnical.in, accessible from ditechnical.in
\r\nYou means the individual accessing or using the Service, or the company, or other legal entity on behalf of which such individual is accessing or using the Service, as applicable.
\r\nWhile using Our Service, We may ask You to provide Us with certain personally identifiable information that can be used to contact or identify You. Personally identifiable information may include, but is not limited to:
\r\n\r\nType: Session Cookies
\r\n\r\nAdministered by: Us
\r\n\r\nPurpose: These Cookies are essential to provide You with services available through the Website and to enable You to use some of its features. They help to authenticate users and prevent fraudulent use of user accounts. Without these Cookies, the services that You have asked for cannot be provided, and We only use these Cookies to provide You with those services.
\r\nCookies Policy / Notice Acceptance Cookies
\r\n\r\nType: Persistent Cookies
\r\n\r\nAdministered by: Us
\r\n\r\nPurpose: These Cookies identify if users have accepted the use of cookies on the Website.
\r\nFunctionality Cookies
\r\n\r\nType: Persistent Cookies
\r\n\r\nAdministered by: Us
\r\n\r\nPurpose: These Cookies allow us to remember choices You make when You use the Website, such as remembering your login details or language preference. The purpose of these Cookies is to provide You with a more personal experience and to avoid You having to re-enter your preferences every time You use the Website.
\r\nFor more information about the cookies we use and your choices regarding cookies, please visit our Cookies Policy or the Cookies section of our Privacy Policy.
\r\n\r\nThe Company may use Personal Data for the following purposes:
\r\n\r\nTo provide and maintain our Service, including to monitor the usage of our Service.
\r\nTo manage Your Account: to manage Your registration as a user of the Service. The Personal Data You provide can give You access to different functionalities of the Service that are available to You as a registered user.
\r\nFor the performance of a contract: the development, compliance and undertaking of the purchase contract for the products, items or services You have purchased or of any other contract with Us through the Service.
\r\nTo contact You: To contact You by email, telephone calls, SMS, or other equivalent forms of electronic communication, such as a mobile application's push notifications regarding updates or informative communications related to the functionalities, products or contracted services, including the security updates, when necessary or reasonable for their implementation.
\r\nTo provide You with news, special offers and general information about other goods, services and events which we offer that are similar to those that you have already purchased or enquired about unless You have opted not to receive such information.
\r\nTo manage Your requests: To attend and manage Your requests to Us.
\r\nFor business transfers: We may use Your information to evaluate or conduct a merger, divestiture, restructuring, reorganization, dissolution, or other sale or transfer of some or all of Our assets, whether as a going concern or as part of bankruptcy, liquidation, or similar proceeding, in which Personal Data held by Us about our Service users is among the assets transferred.
\r\nFor other purposes: We may use Your information for other purposes, such as data analysis, identifying usage trends, determining the effectiveness of our promotional campaigns and to evaluate and improve our Service, products, services, marketing and your experience.
\r\nWe may share Your personal information in the following situations:
\r\n\r\nThe Company will retain Your Personal Data only for as long as is necessary for the purposes set out in this Privacy Policy. We will retain and use Your Personal Data to the extent necessary to comply with our legal obligations (for example, if we are required to retain your data to comply with applicable laws), resolve disputes, and enforce our legal agreements and policies.
\r\n\r\nThe Company will also retain Usage Data for internal analysis purposes. Usage Data is generally retained for a shorter period of time, except when this data is used to strengthen the security or to improve the functionality of Our Service, or We are legally obligated to retain this data for longer time periods.
\r\n\r\nYour information, including Personal Data, is processed at the Company's operating offices and in any other places where the parties involved in the processing are located. It means that this information may be transferred to — and maintained on — computers located outside of Your state, province, country or other governmental jurisdiction where the data protection laws may differ than those from Your jurisdiction.
\r\n\r\nYour consent to this Privacy Policy followed by Your submission of such information represents Your agreement to that transfer.
\r\n\r\nThe Company will take all steps reasonably necessary to ensure that Your data is treated securely and in accordance with this Privacy Policy and no transfer of Your Personal Data will take place to an organization or a country unless there are adequate controls in place including the security of Your data and other personal information.
\r\n\r\nIf the Company is involved in a merger, acquisition or asset sale, Your Personal Data may be transferred. We will provide notice before Your Personal Data is transferred and becomes subject to a different Privacy Policy.
\r\n\r\nUnder certain circumstances, the Company may be required to disclose Your Personal Data if required to do so by law or in response to valid requests by public authorities (e.g. a court or a government agency).
\r\n\r\nThe Company may disclose Your Personal Data in the good faith belief that such action is necessary to:
\r\n\r\nThe security of Your Personal Data is important to Us, but remember that no method of transmission over the Internet, or method of electronic storage is 100% secure. While We strive to use commercially acceptable means to protect Your Personal Data, We cannot guarantee its absolute security.
\r\n\r\nThe Service Providers We use may have access to Your Personal Data. These third-party vendors collect, store, use, process and transfer information about Your activity on Our Service in accordance with their Privacy Policies.
\r\n\r\nOur Service does not address anyone under the age of 13. We do not knowingly collect personally identifiable information from anyone under the age of 13. If You are a parent or guardian and You are aware that Your child has provided Us with Personal Data, please contact Us. If We become aware that We have collected Personal Data from anyone under the age of 13 without verification of parental consent, We take steps to remove that information from Our servers.
\r\n\r\nIf We need to rely on consent as a legal basis for processing Your information and Your country requires consent from a parent, We may require Your parent's consent before We collect and use that information.
\r\n\r\nOur Service may contain links to other websites that are not operated by Us. If You click on a third party link, You will be directed to that third party's site. We strongly advise You to review the Privacy Policy of every site You visit.
\r\n\r\nWe have no control over and assume no responsibility for the content, privacy policies or practices of any third party sites or services.
\r\n\r\nWe may update Our Privacy Policy from time to time. We will notify You of any changes by posting the new Privacy Policy on this page.
\r\n\r\nWe will let You know via email and/or a prominent notice on Our Service, prior to the change becoming effective and update the "Last updated" date at the top of this Privacy Policy.
\r\n\r\nYou are advised to review this Privacy Policy periodically for any changes. Changes to this Privacy Policy are effective when they are posted on this page.
\r\n\r\nIf you have any questions about this Privacy Policy, You can contact us:
\r\n\r\nLast updated: November 20, 2021
\r\n\r\nPlease read these terms and conditions carefully before using Our Service.
\r\n\r\nThe words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.
\r\n\r\nFor the purposes of these Terms and Conditions:
\r\n\r\nAffiliate means an entity that controls, is controlled by or is under common control with a party, where "control" means ownership of 50% or more of the shares, equity interest or other securities entitled to vote for election of directors or other managing authority.
\r\nCountry refers to: Jharkhand, India
\r\nCompany (referred to as either "the Company", "We", "Us" or "Our" in this Agreement) refers to ditechnical.in.
\r\nDevice means any device that can access the Service such as a computer, a cellphone or a digital tablet.
\r\nService refers to the Website.
\r\nTerms and Conditions (also referred as "Terms") mean these Terms and Conditions that form the entire agreement between You and the Company regarding the use of the Service. This Terms and Conditions agreement has been created with the help of the Terms and Conditions Generator.
\r\nThird-party Social Media Service means any services or content (including data, information, products or services) provided by a third-party that may be displayed, included or made available by the Service.
\r\nWebsite refers to ditechnical.in, accessible from ditechnical.in
\r\nYou means the individual accessing or using the Service, or the company, or other legal entity on behalf of which such individual is accessing or using the Service, as applicable.
\r\nThese are the Terms and Conditions governing the use of this Service and the agreement that operates between You and the Company. These Terms and Conditions set out the rights and obligations of all users regarding the use of the Service.
\r\n\r\nYour access to and use of the Service is conditioned on Your acceptance of and compliance with these Terms and Conditions. These Terms and Conditions apply to all visitors, users and others who access or use the Service.
\r\n\r\nBy accessing or using the Service You agree to be bound by these Terms and Conditions. If You disagree with any part of these Terms and Conditions then You may not access the Service.
\r\n\r\nYou represent that you are over the age of 18. The Company does not permit those under 18 to use the Service.
\r\n\r\nYour access to and use of the Service is also conditioned on Your acceptance of and compliance with the Privacy Policy of the Company. Our Privacy Policy describes Our policies and procedures on the collection, use and disclosure of Your personal information when You use the Application or the Website and tells You about Your privacy rights and how the law protects You. Please read Our Privacy Policy carefully before using Our Service.
\r\n\r\nOur Service may contain links to third-party web sites or services that are not owned or controlled by the Company.
\r\n\r\nThe Company has no control over, and assumes no responsibility for, the content, privacy policies, or practices of any third party web sites or services. You further acknowledge and agree that the Company shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with the use of or reliance on any such content, goods or services available on or through any such web sites or services.
\r\n\r\nWe strongly advise You to read the terms and conditions and privacy policies of any third-party web sites or services that You visit.
\r\n\r\nWe may terminate or suspend Your access immediately, without prior notice or liability, for any reason whatsoever, including without limitation if You breach these Terms and Conditions.
\r\n\r\nUpon termination, Your right to use the Service will cease immediately.
\r\n\r\nNotwithstanding any damages that You might incur, the entire liability of the Company and any of its suppliers under any provision of this Terms and Your exclusive remedy for all of the foregoing shall be limited to the amount actually paid by You through the Service or 100 USD if You haven't purchased anything through the Service.
\r\n\r\nTo the maximum extent permitted by applicable law, in no event shall the Company or its suppliers be liable for any special, incidental, indirect, or consequential damages whatsoever (including, but not limited to, damages for loss of profits, loss of data or other information, for business interruption, for personal injury, loss of privacy arising out of or in any way related to the use of or inability to use the Service, third-party software and/or third-party hardware used with the Service, or otherwise in connection with any provision of this Terms), even if the Company or any supplier has been advised of the possibility of such damages and even if the remedy fails of its essential purpose.
\r\n\r\nSome states do not allow the exclusion of implied warranties or limitation of liability for incidental or consequential damages, which means that some of the above limitations may not apply. In these states, each party's liability will be limited to the greatest extent permitted by law.
\r\n\r\nThe Service is provided to You "AS IS" and "AS AVAILABLE" and with all faults and defects without warranty of any kind. To the maximum extent permitted under applicable law, the Company, on its own behalf and on behalf of its Affiliates and its and their respective licensors and service providers, expressly disclaims all warranties, whether express, implied, statutory or otherwise, with respect to the Service, including all implied warranties of merchantability, fitness for a particular purpose, title and non-infringement, and warranties that may arise out of course of dealing, course of performance, usage or trade practice. Without limitation to the foregoing, the Company provides no warranty or undertaking, and makes no representation of any kind that the Service will meet Your requirements, achieve any intended results, be compatible or work with any other software, applications, systems or services, operate without interruption, meet any performance or reliability standards or be error free or that any errors or defects can or will be corrected.
\r\n\r\nWithout limiting the foregoing, neither the Company nor any of the company's provider makes any representation or warranty of any kind, express or implied: (i) as to the operation or availability of the Service, or the information, content, and materials or products included thereon; (ii) that the Service will be uninterrupted or error-free; (iii) as to the accuracy, reliability, or currency of any information or content provided through the Service; or (iv) that the Service, its servers, the content, or e-mails sent from or on behalf of the Company are free of viruses, scripts, trojan horses, worms, malware, timebombs or other harmful components.
\r\n\r\nSome jurisdictions do not allow the exclusion of certain types of warranties or limitations on applicable statutory rights of a consumer, so some or all of the above exclusions and limitations may not apply to You. But in such a case the exclusions and limitations set forth in this section shall be applied to the greatest extent enforceable under applicable law.
\r\n\r\nThe laws of the Country, excluding its conflicts of law rules, shall govern this Terms and Your use of the Service. Your use of the Application may also be subject to other local, state, national, or international laws.
\r\n\r\nIf You have any concern or dispute about the Service, You agree to first try to resolve the dispute informally by contacting the Company.
\r\n\r\nIf You are a European Union consumer, you will benefit from any mandatory provisions of the law of the country in which you are resident in.
\r\n\r\nYou represent and warrant that (i) You are not located in a country that is subject to the United States government embargo, or that has been designated by the United States government as a "terrorist supporting" country, and (ii) You are not listed on any United States government list of prohibited or restricted parties.
\r\n\r\nIf any provision of these Terms is held to be unenforceable or invalid, such provision will be changed and interpreted to accomplish the objectives of such provision to the greatest extent possible under applicable law and the remaining provisions will continue in full force and effect.
\r\n\r\nExcept as provided herein, the failure to exercise a right or to require performance of an obligation under this Terms shall not effect a party's ability to exercise such right or require such performance at any time thereafter nor shall be the waiver of a breach constitute a waiver of any subsequent breach.
\r\n\r\nThese Terms and Conditions may have been translated if We have made them available to You on our Service. You agree that the original English text shall prevail in the case of a dispute.
\r\n\r\nWe reserve the right, at Our sole discretion, to modify or replace these Terms at any time. If a revision is material We will make reasonable efforts to provide at least 30 days' notice prior to any new terms taking effect. What constitutes a material change will be determined at Our sole discretion.
\r\n\r\nBy continuing to access or use Our Service after those revisions become effective, You agree to be bound by the revised terms. If You do not agree to the new terms, in whole or in part, please stop using the website and the Service.
\r\n\r\nIf you have any questions about these Terms and Conditions, You can contact us:
\r\n\r\nLast updated: November 20, 2021
\r\n\r\nThank you for shopping at ditechnical.in.
\r\n\r\nIf, for any reason, You are not completely satisfied with a purchase We invite You to review our policy on refunds and returns.
\r\n\r\nThe following terms are applicable for any products that You purchased with Us.
\r\n\r\nThe words of which the initial letter is capitalized have meanings defined under the following conditions. The following definitions shall have the same meaning regardless of whether they appear in singular or in plural.
\r\n\r\nFor the purposes of this Return and Refund Policy:
\r\n\r\nCompany (referred to as either "the Company", "We", "Us" or "Our" in this Agreement) refers to ditechnical.in.
\r\nGoods refer to the items offered for sale on the Service.
\r\nOrders mean a request by You to purchase Goods from Us.
\r\nService refers to the Website.
\r\nWebsite refers to ditechnical.in, accessible from ditechnical.in
\r\nYou means the individual accessing or using the Service, or the company, or other legal entity on behalf of which such individual is accessing or using the Service, as applicable.
\r\nYou are entitled to cancel Your Order within 7 days without giving any reason for doing so.
\r\n\r\nThe deadline for cancelling an Order is 7 days from the date on which You received the Goods or on which a third party you have appointed, who is not the carrier, takes possession of the product delivered.
\r\n\r\nIn order to exercise Your right of cancellation, You must inform Us of your decision by means of a clear statement. You can inform us of your decision by:
\r\n\r\nWe will reimburse You no later than 14 days from the day on which We receive the returned Goods. We will use the same means of payment as You used for the Order, and You will not incur any fees for such reimbursement.
\r\n\r\nIn order for the Goods to be eligible for a return, please make sure that:
\r\n\r\nThe following Goods cannot be returned:
\r\n\r\nWe reserve the right to refuse returns of any merchandise that does not meet the above return conditions in our sole discretion.
\r\n\r\nOnly regular priced Goods may be refunded. Unfortunately, Goods on sale cannot be refunded. This exclusion may not apply to You if it is not permitted by applicable law.
\r\n\r\nYou are responsible for the cost and risk of returning the Goods to Us. You should send the Goods at the following address:
\r\n\r\nCenter
\r\n\r\nWe cannot be held responsible for Goods damaged or lost in return shipment. Therefore, We recommend an insured and trackable mail service. We are unable to issue a refund without actual receipt of the Goods or proof of received return delivery.
\r\n\r\nIf the Goods were marked as a gift when purchased and then shipped directly to you, You'll receive a gift credit for the value of your return. Once the returned product is received, a gift certificate will be mailed to You.
\r\n\r\nIf the Goods weren't marked as a gift when purchased, or the gift giver had the Order shipped to themselves to give it to You later, We will send the refund to the gift giver.
\r\n\r\nIf you have any questions about our Returns and Refunds Policy, please contact us:
\r\n\r\n