| Server IP : 127.0.0.1 / Your IP : 216.73.216.48 Web Server : Apache/2.4.58 (Win64) OpenSSL/3.1.3 PHP/8.2.12 System : Windows NT DESKTOP-3H4FHQJ 10.0 build 19045 (Windows 10) AMD64 User : win 10 ( 0) PHP Version : 8.2.12 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : D:/coming/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Sep 13, 2022 at 09:15 PM -- Server version: 10.4.24-MariaDB -- PHP Version: 7.4.29 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `cbimage_db` -- -- -------------------------------------------------------- -- -- Table structure for table `categorytb` -- CREATE TABLE `categorytb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `category` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `categorytb` -- INSERT INTO `categorytb` (`id`, `my_id`, `category`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '1', 'Select Category', '', '', '2021-06-30', '15:26:03'), (2, '1', 'Food', '', '', '2021-06-27', '16:00:26'), (4, '1', 'Drinks', '', '', '2021-06-28', '12:08:58'), (5, '1', 'Water', '', '', '2021-06-28', '12:10:26'); -- -------------------------------------------------------- -- -- Table structure for table `crane_imgtb` -- CREATE TABLE `crane_imgtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `image_url` varchar(255) NOT NULL, `category` text NOT NULL, `describe_actions` text NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `crane_imgtb` -- INSERT INTO `crane_imgtb` (`id`, `my_id`, `image_url`, `category`, `describe_actions`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '2', '231597301.jpg', 'Food', 'Wonman on chiar', '', '', '2021-06-30', '21:36:29'), (2, '2', '1449335932.jpg', 'Drinks', 'Wonman on chiar', '', '', '2021-06-30', '21:38:38'), (30, '2', '911785578.jpg', 'Food', 'Wonman on chiar', '', '', '2021-06-30', '22:46:06'), (31, '2', '1065894941.jfif', 'Food', 'Wonman on chiar', '', '', '2021-06-30', '22:48:44'), (32, '2', '279370025.jfif', 'Food', 'Wonman on chiar', '', '', '2021-06-30', '23:00:27'), (33, '2', '1382395553.jfif', 'Drinks', 'Wonman on chiar', '', '', '2021-06-30', '23:01:57'), (34, '2', '1141678431.jpg', 'Food', 'Wonman on chiar', '', '', '2021-07-02', '00:14:47'), (35, '2', '668403706.jpg', 'Food', 'Wonman on chiar', '', '', '2021-07-02', '00:16:10'), (36, '2', '578396044.jpg', 'Food', 'Wonman on chiar', '', '', '2021-07-02', '00:18:16'), (37, '2', '600037703.jfif', 'Food', 'Wonman on chiar', '', '', '2021-08-20', '16:55:00'), (38, '2', '536876623.jpeg', 'Drinks', 'Wonman on chiar', '', '', '2021-08-20', '16:55:15'), (39, '2', '2066474972.jfif', 'Water', 'Wonman on chiar', '', '', '2021-08-20', '17:12:02'), (40, '1', '1265565670.png', 'Food', 'Man on chiar', '', '', '2021-08-20', '17:12:17'); -- -------------------------------------------------------- -- -- Table structure for table `describe_actiontb` -- CREATE TABLE `describe_actiontb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `describe_action` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_date` date NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `describe_actiontb` -- INSERT INTO `describe_actiontb` (`id`, `my_id`, `describe_action`, `cur_country`, `cur_city`, `cur_date`, `cur_time`) VALUES (1, '1', 'Wonman on chiar', '', '', '2021-06-27', '16:16:12'), (2, '1', 'Wonman on chiar', '', '', '2021-06-28', '12:40:08'); -- -------------------------------------------------------- -- -- Table structure for table `img_down_counttb` -- CREATE TABLE `img_down_counttb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `my_ip` varchar(255) NOT NULL, `img_id` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `img_down_counttb` -- INSERT INTO `img_down_counttb` (`id`, `my_id`, `my_ip`, `img_id`, `cur_country`, `cur_city`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '1', '127.0.0.1', '2', '', '', '19', '08', '2021', '16:04:48'), (2, '1', '127.0.0.1', '35', '', '', '19', '08', '2021', '21:05:00'), (3, '1', '127.0.0.1', '36', '', '', '19', '08', '2021', '21:12:43'), (4, '1', '127.0.0.1', '35', '', '', '19', '08', '2021', '21:36:24'), (5, '1', '127.0.0.1', '35', '', '', '19', '08', '2021', '21:43:25'), (6, '1', '127.0.0.1', '35', '', '', '19', '08', '2021', '21:43:54'), (7, '1', '192.168.1.46', '35', '', '', '19', '08', '2021', '22:50:13'), (8, '1', '192.168.1.101', '40', '', '', '05', '11', '2021', '13:11:22'), (9, '1', '127.0.0.1', '31', '', '', '06', '02', '2022', '14:18:04'), (10, '1', '127.0.0.1', '<br /><b>Warning</b>: Undefined variable $post_img_id in <b>E:xampphtdocscrane_imageauto_page.php</b> on line <b>341</b><br />', '', '', '21', '03', '2022', '12:20:52'); -- -------------------------------------------------------- -- -- Table structure for table `img_viewtb` -- CREATE TABLE `img_viewtb` ( `id` int(11) NOT NULL, `my_id` varchar(255) NOT NULL, `my_ip` varchar(255) NOT NULL, `img_id` varchar(255) NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `img_viewtb` -- INSERT INTO `img_viewtb` (`id`, `my_id`, `my_ip`, `img_id`, `cur_country`, `cur_city`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:26:36'), (2, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:33:51'), (3, '1', '127.0.0.1', '2', '', '', '19', '08', '2021', '22:33:55'), (4, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:34:45'), (5, '1', '127.0.0.1', '2', '', '', '19', '08', '2021', '22:34:50'), (6, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:36:19'), (7, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:39:03'), (8, '1', '127.0.0.1', '1', '', '', '19', '08', '2021', '22:39:09'), (9, '1', '127.0.0.1', '2', '', '', '19', '08', '2021', '22:39:23'), (10, '1', '127.0.0.1', '2', '', '', '19', '08', '2021', '22:39:29'), (11, '1', '127.0.0.1', '30', '', '', '19', '08', '2021', '22:40:44'), (12, '1', '127.0.0.1', '35', '', '', '19', '08', '2021', '22:41:32'), (13, '1', '192.168.1.46', '1', '', '', '19', '08', '2021', '22:49:44'), (14, '1', '192.168.1.46', '2', '', '', '19', '08', '2021', '22:49:50'), (15, '1', '192.168.1.46', '35', '', '', '19', '08', '2021', '22:49:58'), (16, '1', '192.168.1.46', '33', '', '', '19', '08', '2021', '22:50:46'), (17, '1', '192.168.1.46', '31', '', '', '19', '08', '2021', '22:51:08'), (18, '1', '192.168.1.46', '30', '', '', '20', '08', '2021', '12:21:08'), (19, '1', '192.168.1.46', '36', '', '', '20', '08', '2021', '12:22:20'), (20, '1', '192.168.1.46', '32', '', '', '20', '08', '2021', '12:23:42'), (21, '1', '192.168.1.46', '34', '', '', '20', '08', '2021', '12:25:20'), (22, '1', '127.0.0.1', '31', '', '', '20', '08', '2021', '12:27:51'), (23, '1', '127.0.0.1', '32', '', '', '20', '08', '2021', '12:27:54'), (24, '1', '127.0.0.1', '34', '', '', '20', '08', '2021', '12:27:58'), (25, '1', '127.0.0.1', '36', '', '', '20', '08', '2021', '12:28:04'), (26, '1', '127.0.0.1', '33', '', '', '20', '08', '2021', '12:30:18'), (27, '1', '127.0.0.1', '37', '', '', '20', '08', '2021', '16:55:27'), (28, '1', '192.168.1.46', '38', '', '', '20', '08', '2021', '17:08:56'), (29, '1', '192.168.1.46', '37', '', '', '20', '08', '2021', '17:09:02'), (30, '1', '192.168.1.46', '39', '', '', '20', '08', '2021', '17:12:28'), (31, '1', '192.168.1.46', '40', '', '', '20', '08', '2021', '17:12:55'), (32, '1', '127.0.0.1', '39', '', '', '20', '08', '2021', '17:16:47'), (33, '1', '127.0.0.1', '40', '', '', '20', '08', '2021', '17:35:46'), (34, '1', '192.168.1.52', '37', '', '', '20', '08', '2021', '17:59:16'), (35, '1', '192.168.1.52', '1', '', '', '20', '08', '2021', '17:59:34'), (36, '1', '192.168.1.52', '31', '', '', '20', '08', '2021', '17:59:43'), (37, '1', '192.168.1.52', '2', '', '', '20', '08', '2021', '17:59:55'), (38, '1', '192.168.1.52', '36', '', '', '20', '08', '2021', '18:00:12'), (39, '1', '127.0.0.1', '38', '', '', '09', '10', '2021', '14:03:03'), (40, '1', '192.168.1.101', '1', '', '', '05', '11', '2021', '13:10:25'), (41, '1', '192.168.1.101', '33', '', '', '05', '11', '2021', '13:10:42'), (42, '1', '192.168.1.101', '37', '', '', '05', '11', '2021', '13:10:59'), (43, '1', '192.168.1.101', '40', '', '', '05', '11', '2021', '13:11:09'), (44, '1', '::1', '35', '', '', '05', '11', '2021', '13:26:46'), (45, '1', '::1', '1', '', '', '05', '11', '2021', '13:39:35'), (46, '1', '::1', '40', '', '', '05', '11', '2021', '13:40:16'), (47, '1', '::1', '31', '', '', '05', '11', '2021', '13:43:47'), (48, '1', '192.168.1.101', '31', '', '', '05', '11', '2021', '14:48:55'), (49, '1', '192.168.1.101', '2', '', '', '05', '11', '2021', '14:49:00'), (50, '1', '192.168.1.101', '35', '', '', '05', '11', '2021', '14:49:07'), (51, '1', '192.168.1.101', '30', '', '', '05', '11', '2021', '14:49:29'), (52, '1', '192.168.1.101', '36', '', '', '05', '11', '2021', '14:49:32'), (53, '1', '192.168.1.101', '38', '', '', '05', '11', '2021', '14:49:36'), (54, '1', '192.168.1.101', '39', '', '', '05', '11', '2021', '14:49:39'), (55, '1', '192.168.1.101', '34', '', '', '05', '11', '2021', '15:03:54'), (56, '1', '192.168.1.101', '32', '', '', '05', '11', '2021', '15:03:57'), (57, '1', '192.168.1.100', '30', '', '', '09', '11', '2021', '12:14:52'), (58, '1', '192.168.1.100', '31', '', '', '09', '11', '2021', '12:14:55'), (59, '1', '192.168.1.100', '2', '', '', '09', '11', '2021', '12:15:01'), (60, '1', '192.168.1.100', '34', '', '', '09', '11', '2021', '12:15:05'), (61, '1', '192.168.1.100', '35', '', '', '09', '11', '2021', '12:20:32'), (62, '1', '192.168.1.100', '32', '', '', '09', '11', '2021', '12:20:39'), (63, '1', '192.168.1.100', '1', '', '', '09', '11', '2021', '13:05:40'), (64, '1', '192.168.1.102', '1', '', '', '09', '11', '2021', '16:12:09'), (65, '1', '192.168.1.102', '2', '', '', '10', '11', '2021', '12:58:13'), (66, '1', '192.168.1.102', '31', '', '', '10', '11', '2021', '12:58:27'), (67, '1', '192.168.1.103', '2', '', '', '10', '11', '2021', '13:46:58'), (68, '1', '192.168.1.103', '1', '', '', '10', '11', '2021', '13:47:02'), (69, '1', '192.168.1.104', '33', '', '', '10', '11', '2021', '13:56:45'), (70, '1', '192.168.1.104', '2', '', '', '10', '11', '2021', '13:57:39'), (71, '1', '192.168.1.104', '32', '', '', '10', '11', '2021', '13:57:51'), (72, '1', '192.168.1.104', '1', '', '', '10', '11', '2021', '13:57:53'), (73, '1', '192.168.1.104', '35', '', '', '10', '11', '2021', '13:57:58'), (74, '1', '192.168.1.103', '35', '', '', '13', '11', '2021', '09:44:47'), (75, '1', '192.168.1.103', '31', '', '', '13', '11', '2021', '09:44:54'), (76, '1', '192.168.1.103', '30', '', '', '13', '11', '2021', '09:44:56'), (77, '1', '192.168.1.104', '40', '', '', '13', '11', '2021', '09:50:18'), (78, '1', '192.168.1.104', '37', '', '', '13', '11', '2021', '09:51:11'), (79, '1', '192.168.1.104', '36', '', '', '13', '11', '2021', '09:51:16'), (80, '1', '192.168.1.104', '31', '', '', '13', '11', '2021', '09:52:41'); -- -------------------------------------------------------- -- -- Table structure for table `studio_usertb` -- CREATE TABLE `studio_usertb` ( `id` int(11) NOT NULL, `my_id_studio` varchar(255) NOT NULL, `channel_name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `image_url` text NOT NULL, `cur_country` varchar(255) NOT NULL, `cur_city` varchar(255) NOT NULL, `cur_day` varchar(255) NOT NULL, `cur_month` varchar(255) NOT NULL, `cur_year` varchar(255) NOT NULL, `cur_time` time NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `studio_usertb` -- INSERT INTO `studio_usertb` (`id`, `my_id_studio`, `channel_name`, `description`, `image_url`, `cur_country`, `cur_city`, `cur_day`, `cur_month`, `cur_year`, `cur_time`) VALUES (1, '2', 'Better cave', 'Better Place For rivers', 'avatar2.jpg', 'Uganda', 'Kampala', '7', '11', '2021', '00:00:00'), (3, '1', 'My Healing', 'The best healing solution for both women and children', 'avatar2.jpg', '', '', '', '', '', '00:00:00'); -- -- Indexes for dumped tables -- -- -- Indexes for table `categorytb` -- ALTER TABLE `categorytb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `crane_imgtb` -- ALTER TABLE `crane_imgtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `describe_actiontb` -- ALTER TABLE `describe_actiontb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `img_down_counttb` -- ALTER TABLE `img_down_counttb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `img_viewtb` -- ALTER TABLE `img_viewtb` ADD PRIMARY KEY (`id`); -- -- Indexes for table `studio_usertb` -- ALTER TABLE `studio_usertb` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `categorytb` -- ALTER TABLE `categorytb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `crane_imgtb` -- ALTER TABLE `crane_imgtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `describe_actiontb` -- ALTER TABLE `describe_actiontb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `img_down_counttb` -- ALTER TABLE `img_down_counttb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `img_viewtb` -- ALTER TABLE `img_viewtb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81; -- -- AUTO_INCREMENT for table `studio_usertb` -- ALTER TABLE `studio_usertb` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;