One Hat Cyber Team
Your IP :
216.73.216.186
Server IP :
147.79.69.120
Server :
Linux in-mum-web1837.main-hosting.eu 5.14.0-503.34.1.el9_5.x86_64 #1 SMP PREEMPT_DYNAMIC Thu Mar 27 06:00:50 EDT 2025 x86_64
Server Software :
LiteSpeed
PHP Version :
8.2.28
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
u322583024
/
domains
/
jimmy2chs.in
/
public_html
/
Edit File:
chs.sql
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 11, 2024 at 02:14 PM -- Server version: 10.4.27-MariaDB -- PHP Version: 8.0.25 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: `chs` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE `admin` ( `id` int(11) NOT NULL, `username` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `role` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `username`, `password`, `role`) VALUES (1, 'admin', 'chs@2024', 'admin'), (2, 'superadmin', 'superadmin', 'superadmin'); -- -------------------------------------------------------- -- -- Table structure for table `contact` -- CREATE TABLE `contact` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `msg` text NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `contact` -- INSERT INTO `contact` (`id`, `name`, `email`, `phone`, `msg`, `added_on`) VALUES (1, 'kamal', 'hsdigitalmediaindia@gmail.com', '9021698293', 'testtt', '2024-04-05 09:34:17'), (2, 'kml', 'hsdigitalmediaindia@gmail.com', '9021698293', 'hsdigitalmediaindia@gmail.com test mail', '2024-04-05 09:38:12'), (3, 'Mohan', 'mohan', 'shhhejjshhkk', 'This is a test report', '2024-05-13 03:22:45'), (4, 'Mohan', 'Testing', 'shhwggajhj', 'This is a testing request', '2024-05-13 03:23:36'), (11, 'frefxser', 'infomedia15@gmail.vom', '8452962642', 'sfzgvfxdg', '2024-05-29 09:33:25'), (12, 'shital', 'shital@gmail.com', '9517538521', 'testing', '2024-05-29 09:41:37'), (13, 'testshital', 'shital@gmail.com', '9517532584', 'testtest', '2024-05-29 09:44:58'), (14, 'testshital', 'shital@gmail.com', '9517532584', 'testtest', '2024-05-29 09:45:02'), (15, 'testshital', 'shital', '9517532584', 'testtest', '2024-05-29 09:45:53'), (16, 'Mohan', 'mohan', '999', 'Testing', '2024-05-29 11:32:37'), (17, 'Mohan', 'Mohan', '666', 'Just checking from home page visitor contact form...got redirected here from member dashboard contact button!', '2024-05-30 10:54:55'), (18, 'Mohan', 'Mohan@gmail.com', '6667766555', 'Just checking from home page visitor contact form...got redirected here from member dashboard contact button!', '2024-05-30 10:55:22'), (19, 'mohan', 'mohan@gmail.com', '9820215487', 'Hello...I AM VISITOR CHECKING IF YOU ARE GETTING THIS MESSAGE FROM OUTER SPACE', '2024-05-30 12:02:42'), (20, 'mohan', 'mohan@gmail.com', '9820215487', 'Hello...I AM VISITOR CHECKING IF YOU ARE GETTING THIS MESSAGE FROM OUTER SPACE', '2024-05-30 12:03:00'), (21, 'mohan', 'mohan@gmail.com', '9820215487', 'Hello...I AM VISITOR CHECKING IF YOU ARE GETTING THIS MESSAGE FROM OUTER SPACE', '2024-05-30 12:03:14'), (22, 'mohan', 'mohan@gmail.com', '9820215487', 'Hello...I AM VISITOR CHECKING IF YOU ARE GETTING THIS MESSAGE FROM OUTER SPACE', '2024-05-30 12:03:33'), (23, 'kmm', 'k@gmail.com', '1234567890', 'aaaaaaaaaaaaaa', '2024-05-31 07:04:49'), (24, 'kmm', 'k@gmail.com', '1234567890', 'aaaaaaaaaaaaaa', '2024-05-31 07:04:53'), (25, 'kmm', 'k@gmail.com', '1234567890', 'aaaaaaaaaaaaaa', '2024-05-31 07:04:56'), (26, 'kmm', 'k@gmail.com', '1234567890', 'aaaaaaaaaaaaaa', '2024-05-31 07:05:00'), (27, 'kmm', 'k@gmail.com', '1234567890', 'aaaaaaaaaaaaaa', '2024-05-31 07:05:03'), (28, 'shital', 'sp666712@gmail.com', '9517538524', 'testing for contact form\r\n', '2024-06-08 06:10:40'); -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `desc` longtext NOT NULL, `img` varchar(255) NOT NULL, `datetime` date NOT NULL, `event_status` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `name`, `desc`, `img`, `datetime`, `event_status`, `status`) VALUES (1, 'test1', 'test', 'img-01.jpg', '2024-04-19', 'completed', 1), (2, 'Testing Time Season', 'This is a sample event to check if it works', 'Nimishamba3.jpg', '2024-06-01', '', 1), (3, 'test event', 'for testing purpose', '8 april main.png', '2024-06-05', 'adjourned', 1), (4, 'test_new', 'test_new', 'nailart1.png', '0000-00-00', '', 1); -- -------------------------------------------------------- -- -- Table structure for table `hd_departments` -- CREATE TABLE `hd_departments` ( `id` int(11) NOT NULL, `name` varchar(250) NOT NULL, `status` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `hd_departments` -- INSERT INTO `hd_departments` (`id`, `name`, `status`) VALUES (1, 'Technical', 1), (2, 'Testing', 1), (3, 'Automation', 1), (4, 'Design', 1), (5, 'Programming', 1), (7, 'Security', 1); -- -------------------------------------------------------- -- -- Table structure for table `hd_tickets` -- CREATE TABLE `hd_tickets` ( `id` int(11) NOT NULL, `uniqid` varchar(20) NOT NULL, `user` int(11) NOT NULL, `title` varchar(250) NOT NULL, `init_msg` text NOT NULL, `img` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `date` varchar(250) NOT NULL, `last_reply` int(11) NOT NULL, `user_read` int(11) NOT NULL, `admin_read` int(11) NOT NULL, `resolved` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `hd_tickets` -- INSERT INTO `hd_tickets` (`id`, `uniqid`, `user`, `title`, `init_msg`, `img`, `department`, `date`, `last_reply`, `user_read`, `admin_read`, `resolved`) VALUES (1, '65fd805a15ad3', 1, 'Society Complaint', 'I am writing to bring to your attention certain issues/concerns that I have observed within our society/community. [Briefly describe the problem or problems you are experiencing.]\r\n\r\n[Provide specific details regarding the issue, including dates, times, locations, and any individuals involved if applicable.]', '', '', '1711112282', 1, 1, 1, 1), (2, '664190bed77ea', 1, 'Test Complaint', 'Complaining to check the complaint module', '', '', '1715572926', 1, 1, 0, 0), (3, '66508ad43e6b6', 7, 'ddhhd', 'rfdfsdf', '', '', '1716554452', 7, 1, 0, 0), (4, '665170f84c6d7', 7, 'test', 'shital test', '', '', '1716613368', 7, 0, 0, 0), (5, '66517139d1ae4', 7, 'gfsehfuksnfkj', 'gdrhdh', '', '', '1716613433', 7, 0, 1, 0), (6, '66585daa3d31d', 1, 'New Test Ticket', 'This just too checking from member dashboard regarding a complaint that I have', '', '', '1717067178', 2, 1, 1, 0), (7, '665eedecdea48', 9, 'I want to access cpanel what is process for that', 'hdtrhydhyr6 nu67iu', '', '', '1717497324', 9, 1, 1, 0), (8, '665f0ba09d314', 7, 'shital', 'shital teset', '', '', '1717504928', 7, 0, 0, 0), (9, '6663ee0b52232', 1, 'test 6/8', 'testing ', '', '', '1717825035', 1, 1, 0, 1), (10, '6663f081b06e5', 9, 'shital test from 2nd user', 'testing by shital ', '', '', '1717825665', 9, 0, 0, 0), (11, '666423776431f', 9, 'img testing', 'testing for image', '', '', '1717838711', 9, 0, 0, 0), (12, '6664250095603', 9, 'img testing 2', 'fdzsesregdrhtg', '', '', '1717839104', 9, 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `hd_ticket_replies` -- CREATE TABLE `hd_ticket_replies` ( `id` int(11) NOT NULL, `user` varchar(255) NOT NULL, `text` text NOT NULL, `ticket_id` text NOT NULL, `date` varchar(20) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `hd_ticket_replies` -- INSERT INTO `hd_ticket_replies` (`id`, `user`, `text`, `ticket_id`, `date`) VALUES (1, 'admin', 'I will Try to Solved', '1', '1711112376'), (2, 'admin', 'Yes...we have solved it', '1', '1715570212'), (3, '7', 'gdgdf', '3', '1716554585'), (4, '1', 'I have still not got a response. Please respond at the earliest', '2', '1717066095'), (5, 'admin', 'Your test complaint has been received...do see if you are getting the reply as well.', '6', '1717070435'); -- -------------------------------------------------------- -- -- Table structure for table `members` -- CREATE TABLE `members` ( `id` int(11) NOT NULL, `role` varchar(255) NOT NULL, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `phone` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `pass` varchar(255) NOT NULL, `passwordcode` int(11) NOT NULL, `status` int(11) NOT NULL, `added_on` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `members` -- INSERT INTO `members` (`id`, `role`, `name`, `email`, `phone`, `img`, `pass`, `passwordcode`, `status`, `added_on`) VALUES (1, 'Member', 'Kamal Sawan', 'kishorisawant57@gmail.com', '9021698293', '6663eee4ddd2b.png', 'kml@28', 313968, 1, '2024-03-22 00:00:00'), (3, 'Member', 'kamal sawant', 'hsdigitalmediaindia@gmail.com', '9021698299', '', 'hs@123', 205505, 1, '2024-04-04 00:00:00'), (5, 'Member', 'ABC XYZ', 'abcxyz@gmail.com', '9820215487', '', '', 0, 1, '2024-05-12 00:00:00'), (7, 'Member', 'Vaishnavi', 'patil.vaishnavi2053@gmail.com', '2012365478', '66508b9da2c83.jpg', 'vp1234', 0, 1, '2024-05-24 00:00:00'), (8, 'Member', 'Rajesh R', 'mogun07@gmail.com', '9326394465', '', '', 0, 1, '2024-05-30 00:00:00'), (9, 'Admin', 'test_s', 'shital.patil230598@gmail.com', '9594219364', '665ee80ae3bc7.jpeg', '123456', 0, 0, '2024-06-03 00:00:00'), (10, 'Member', 'shital patil', 'sital@gmail.com', '9874563210', '', '', 0, 1, '2024-06-03 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `messages` -- CREATE TABLE `messages` ( `msg_id` int(11) NOT NULL, `incoming_msg_id` int(255) NOT NULL, `outgoing_msg_id` int(255) NOT NULL, `msg` varchar(1000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `notice` -- CREATE TABLE `notice` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `desc` longtext NOT NULL, `img` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `notice` -- INSERT INTO `notice` (`id`, `name`, `desc`, `img`, `status`) VALUES (3, 'Notice Regarding [Specify Reason]', 'This notice is to inform all members of [Your Cooperative Housing Society Name] about [Specify Reason]. Please review the details provided below carefully.', 'Nimishamba3.jpg', 1), (4, 'Brief Description of the Notice Topic', '\r\n[Your Co-operative Housing Society Limited Logo/Heading]\r\n\r\n[Date]\r\n\r\nNotice\r\n\r\nDear Residents/Members,\r\n\r\nSubject: [Brief Description of the Notice Topic]\r\n\r\nThis is to inform all residents/members of [Your Co-operative Housing Society Limited Name] that [specific information or announcement]. The details are as follows:\r\n\r\n[Provide detailed information about the subject matter, including dates, timings, locations, and any other relevant information.]\r\n\r\nWe kindly request all residents/members to [action required, if any] and cooperate with the managing committee to ensure smooth functioning and adherence to the society\'s regulations.\r\n\r\nFor any queries or clarifications regarding this notice, please feel free to contact the managing committee at [contact details].\r\n\r\nThank you for your attention and cooperation.', 'cement-street-financial-downtown-shanghai-travel.jpg', 1), (5, 'Sample Notice', 'This is just to check what gets displayed', '8 april main.png', 1), (6, 'test_new', 'wrzsegsrdg', 'Untitled-1 copy.jpg', 1), (7, 'shital tesing notice', 'shital tesing notice', '3-may-solution-main.jpg', 1); -- -------------------------------------------------------- -- -- Table structure for table `resources` -- CREATE TABLE `resources` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `status` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `resources` -- INSERT INTO `resources` (`id`, `name`, `img`, `status`) VALUES (1, 'test', 'bg.jpg', 1), (4, 'test2', 'bangalore.png', 1), (6, 'Grand Opening Ceremony of Swarn Bhairav Jewellers in Karjat', 'skys.jpg', 1), (7, 'dsdsd', 'skys.jpg', 1), (8, 'sital', 'SAVE_20240228_155358.jpg', 1), (9, 'testing purpose', 'coupleslider.jpg', 1), (10, 'resources testing by shital', 'Screenshot 2024-06-07 184845.png', 1); -- -------------------------------------------------------- -- -- Table structure for table `ticket` -- CREATE TABLE `ticket` ( `id` int(11) NOT NULL, `mem-id` int(11) NOT NULL, `sub` text NOT NULL, `msg` longtext NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_event_read` -- CREATE TABLE `user_event_read` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `event_id` int(11) NOT NULL, `read_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user_event_read` -- INSERT INTO `user_event_read` (`id`, `user_id`, `event_id`, `read_at`) VALUES (1, 9, 1, '2024-06-11 09:04:37'); -- -------------------------------------------------------- -- -- Table structure for table `user_notice_read` -- CREATE TABLE `user_notice_read` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `notice_id` int(11) NOT NULL, `read_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user_notice_read` -- INSERT INTO `user_notice_read` (`id`, `user_id`, `notice_id`, `read_at`) VALUES (15, 9, 7, '0000-00-00 00:00:00'), (16, 9, 4, '0000-00-00 00:00:00'), (17, 9, 3, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `user_resource_read` -- CREATE TABLE `user_resource_read` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `resource_id` int(11) NOT NULL, `read_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -- Dumping data for table `user_resource_read` -- INSERT INTO `user_resource_read` (`id`, `user_id`, `resource_id`, `read_at`) VALUES (1, 9, 4, '2024-06-11 09:27:15'), (2, 9, 8, '2024-06-11 09:28:44'); -- -- Indexes for dumped tables -- -- -- Indexes for table `admin` -- ALTER TABLE `admin` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contact` -- ALTER TABLE `contact` ADD PRIMARY KEY (`id`); -- -- Indexes for table `events` -- ALTER TABLE `events` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hd_departments` -- ALTER TABLE `hd_departments` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hd_tickets` -- ALTER TABLE `hd_tickets` ADD PRIMARY KEY (`id`); -- -- Indexes for table `hd_ticket_replies` -- ALTER TABLE `hd_ticket_replies` ADD PRIMARY KEY (`id`); -- -- Indexes for table `members` -- ALTER TABLE `members` ADD PRIMARY KEY (`id`); -- -- Indexes for table `messages` -- ALTER TABLE `messages` ADD PRIMARY KEY (`msg_id`); -- -- Indexes for table `notice` -- ALTER TABLE `notice` ADD PRIMARY KEY (`id`); -- -- Indexes for table `resources` -- ALTER TABLE `resources` ADD PRIMARY KEY (`id`); -- -- Indexes for table `ticket` -- ALTER TABLE `ticket` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_event_read` -- ALTER TABLE `user_event_read` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_notice_read` -- ALTER TABLE `user_notice_read` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_resource_read` -- ALTER TABLE `user_resource_read` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `admin` -- ALTER TABLE `admin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `contact` -- ALTER TABLE `contact` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- AUTO_INCREMENT for table `events` -- ALTER TABLE `events` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `hd_departments` -- ALTER TABLE `hd_departments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `hd_tickets` -- ALTER TABLE `hd_tickets` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `hd_ticket_replies` -- ALTER TABLE `hd_ticket_replies` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `members` -- ALTER TABLE `members` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `messages` -- ALTER TABLE `messages` MODIFY `msg_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `notice` -- ALTER TABLE `notice` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `resources` -- ALTER TABLE `resources` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `ticket` -- ALTER TABLE `ticket` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_event_read` -- ALTER TABLE `user_event_read` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `user_notice_read` -- ALTER TABLE `user_notice_read` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- AUTO_INCREMENT for table `user_resource_read` -- ALTER TABLE `user_resource_read` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; 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 */;
Simpan