Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Greetings world, we are #LulzSec and we are here to "do it for Lulz" like we always do!!
- Nothing is personal, we just want to fuck around looooooooooool
- Those are infos leaked from many companies and organizations from India, enjoy!!!
- #Chaos_Soldier
- http://vlabs.iitb.ac.in
- `iitb_admin`
- (`id`, `name`, `password`, `status`)
- (1, 'admin', 'admin', 1)
- `iitb_condition` (`id`, `conditionss`, `date`) VALUES
- (1, 'To support learning in traditional labsAugment physical labs- Use vlab after plab', '2016-03-28 17:34:57'),
- (2, 'To support learning in traditional labs - Augment physical labs - Use vlab before plab', '2016-03-29 18:11:49'),
- (3, 'To achieve something that is not possible in traditional labs', '2016-03-26 17:24:44'),
- (4, 'Perform such experiments for which physical lab does not exist due to various constraints', '2016-03-26 17:24:44'),
- (5, 'To support introvert students', '2016-03-26 17:25:04')
- `iitb_experiments` (`id`, `lab_id`, `experiments`, `date`)
- (1, 2, 'Stability Factor for different biasing circuits', '2016-04-27 18:33:32'),
- (2, 3, 'Stability Factor for different biasing circuits', '2016-04-27 18:33:38'),
- (3, 4, 'Stability Factor for different biasing circuits', '2016-04-27 18:33:44'),
- (4, 2, 'Clipper circuit.', '2016-04-27 18:34:14'),
- (5, 1, 'Clipper circuit.', '2016-04-27 18:34:19'),
- (6, 2, 'Clamper circuit.', '2016-04-27 18:34:34'),
- (7, 5, 'Clamper circuit.', '2016-04-27 18:34:48'),
- (8, 2, 'Zener Voltage regulator', '2016-04-27 18:35:03'),
- (9, 4, 'Zener Voltage regulator', '2016-04-27 18:35:08'),
- (10, 2, 'Input and output characteristic for CE configuration', '2016-04-27 18:35:22'),
- (11, 5, 'Input and output characteristic for CE configuration', '2016-04-27 18:35:26'),
- (12, 1, 'Input and output characteristic for CE configuration', '2016-04-27 18:35:31'),
- (13, 2, 'Voltage gain and resistance of BJT amplifier', '2016-04-27 18:35:42'),
- (14, 4, 'Voltage gain and resistance of BJT amplifier', '2016-04-27 18:35:48'),
- (15, 2, 'JFET Biasing', '2016-04-27 18:36:04'),
- (16, 3, 'JFET Biasing', '2016-04-27 18:36:09'),
- (17, 2, 'JFET characteristics for Common Source configuration', '2016-04-27 18:36:21'),
- (18, 4, 'JFET characteristics for Common Source configuration', '2016-04-27 18:36:27')
- `iitb_lab` (`id`, `lab`, `date`)
- (1, 'Basic Electronics Lab', '2016-03-28 19:00:32'),
- (2, 'Analog Electronics I Lab', '2016-04-26 17:04:22'),
- (3, 'Analog Electronics II Lab', '2016-03-26 17:42:42'),
- (4, 'Digital Logic Design Lab', '2016-03-26 17:42:42'),
- (5, 'Electrical Networks Lab', '2016-03-26 17:43:04')
- `iitb_objectives` (`id`, `objective`, `date`)
- (1, 'Instrumentation', '2016-03-26 17:32:14'),
- (2, 'Models', '2016-03-26 17:32:14'),
- (3, 'Experiment', '2016-03-26 17:34:03'),
- (4, 'Data Analysis', '2016-03-26 17:34:03'),
- (5, 'Design', '2016-03-26 17:34:37'),
- (6, 'Learn from Failure', '2016-03-26 17:34:37'),
- (7, 'Creativity', '2016-03-26 17:35:22'),
- (8, 'Psychomotor', '2016-03-26 17:35:22'),
- (9, 'Safety', '2016-03-26 17:36:52'),
- (10, 'Communication', '2016-03-26 17:36:52'),
- (11, 'Teamwork', '2016-03-26 17:37:51'),
- (12, 'Ethics in the Lab', '2016-03-28 18:11:38'),
- (13, 'Sensory Awareness', '2016-03-26 17:38:15')
- `iitb_objectives` (`id`, `objective`, `date`) VALUES
- (1, 'Instrumentation', '2016-03-26 17:32:14'),
- (2, 'Models', '2016-03-26 17:32:14'),
- (3, 'Experiment', '2016-03-26 17:34:03'),
- (4, 'Data Analysis', '2016-03-26 17:34:03'),
- (5, 'Design', '2016-03-26 17:34:37'),
- (6, 'Learn from Failure', '2016-03-26 17:34:37'),
- (7, 'Creativity', '2016-03-26 17:35:22'),
- (8, 'Psychomotor', '2016-03-26 17:35:22'),
- (9, 'Safety', '2016-03-26 17:36:52'),
- (10, 'Communication', '2016-03-26 17:36:52'),
- (11, 'Teamwork', '2016-03-26 17:37:51'),
- (12, 'Ethics in the Lab', '2016-03-28 18:11:38'),
- (13, 'Sensory Awareness', '2016-03-26 17:38:15');
- http://www.ecil.co.in
- `ecil_admin` (`user_name`, `password`, `active_status`, `sec_level`, `type`)
- ('admin', 'àvÝX/ÙÈ\0ÇRÈ', 'Y', '01', 'admin'),
- ('vigilance', ' îS¬¤¶†¡Ò’ê', 'Y', '02', 'vigilance');
- `vigilance` (`vigilance_id`, `name`, `city`, `address`, `pin`, `std_code`, `phone`, `mobile`, `email_id`, `details`, `vig_file`, `vig_status`, `vig_reply`, `internal_reply`, `last_update_date`)
- ('EC1636250310', 'sdfsd', 'sdfsd', 'sdfsd', '', '', '', '', '', 'sdfsd', 'vigilance/complaint.doc', 'noted', '', '', '2010-03-25 19:09:57'),
- ('EC2338250310', 'sdfsd', 'sdfsd', 'sdfsd ', '', '', '', '', '', 'sdfsd', 'vigilance/complaint1.doc', '', 'sdfasas', '', '2010-03-25 19:05:02'),
- ('EC4496240310', 'sdf', 'sdf', 'dfdsf ', '', '', '', '', '', 'sdfdsf', '', '', 'sdgsgsdfg', '', '2010-03-24 20:57:53'),
- ('EC4552310310', 'sateesh', 'hyderabad', 'punjagutta', '500062', '08402', '223355', '991659878', 'cvsatees@gmail.com', 'applied for job in ecil .and got selected in ecil.this is the complaint for not getting proper response from officers regarding offer letter ', '', 'underprogress', '', '', '2010-03-31 07:21:47'),
- ('EC6567250310', 'ssdfs', 'sdfs', 'werwe ', '', '', '', '', '', 'sdfsd ', '', 'disposed', 'sdfasdfsda', '', '2010-03-25 19:13:50'),
- ('EC7106240310', 'sdf', 'sdf', 'dfdsf ', '', '', '', '', '', 'sdfdsf', '', '', 'sdfasdfasd', '', '2010-03-24 21:00:32'),
- ('EC7530240310', 'sdf', 'sdf', 'dfdsf ', '', '', '', '', '', 'sdfdsf', '', '', '', '', '2010-03-24 20:59:46'),
- ('EC8071240310', 'rajest', 'hyd', 'punjagutta ', '', '', '', '', '', 'complaint against security depot', '', '', '', '', '2010-03-24 21:08:31'),
- ('EC8289240310', 'sdf', 'sdf', 'dfdsf ', '', '', '', '', '', 'sdfdsf', '', '', '', '', '2010-03-24 21:01:54'),
- ('EC8390010410', 'ramraji', 'delhi', 'chandinichowk', '', '', '', '', '', 'applied for tender ', '', 'noted', 'under progress', '', '2010-04-01 10:11:45'),
- ('EC8736240310', 'sdf', 'sdf', 'sdfsdf ', '', '', '', '', '', 'sdfsdfsd', '', '', '', '', '2010-03-24 21:05:11'),
- ('EC9591240310', 'sdf', 'sdf', 'asdasd', '', '', '', '', '', 'asdasd', '', '', '', '', '2010-03-24 21:02:42'),
- ('EC9873310310', 'rahul', 'bangalore', 'jp nagar ', '', '', '', '', '', 'complaint against transportation of eciil ', '', 'pending', 'action taken', '', '2010-03-31 08:15:55')
- http://pavansms.in
- `admin` (`admin_id`, `firstname`, `admin_cellno`, `username`, `password`, `user_added`, `admin_mailid`, `smsusername`, `smspassword`, `smssenderid`, `smscredits`, `smsstatus`, `reseller_id`, `smsfooter`) VALUES
- (1, 'www.accnzb.com, PRABHAKAR-9908302604', '9908302604', 'admin1', 'AdmiN1', '2015-11-10 14:01:56', 'aa', 'sharonsys', 'sharonsys7', 'PRABKR', 365839, 'Active', 1, 'www.pavansms.com, PRABHAKAR-9908302604'),
- (58, 'www.accnzb.com, PRABHAKAR-9908302604', '9000605878', 'admin2', 'Kumar750', '2015-11-10 14:01:56', 'jyothikumuram@gmail.com', 'sharonsys', 'sharonsys7', 'KUMRAM', 367839, 'Active', 1, 'www.pavansms.com, JyothiKumar-9014750750,9000605878');
- `adminsmscredithistory` (`history_id`, `date`, `action_username`, `credited`, `debited`, `smsbalance`, `login_name`, `login_id`) VALUES
- (58, '2016-08-01 02:45:20', 'asmncl', 77335, 0, 922665, 'admin1', '1'),
- (59, '2016-08-01 02:50:22', 'ramesh', 9826, 0, 912839, 'admin1', '1'),
- (60, '2016-08-01 02:57:41', 'indian', 15000, 0, 897839, 'admin1', '1'),
- (61, '2016-08-01 03:08:37', 'srkems', 25000, 0, 872839, 'admin1', '1'),
- (62, '2016-08-01 07:25:25', 'tejaem', 0, 0, 872839, 'admin1', '1'),
- (63, '2016-08-01 07:27:09', 'newkerala', 10000, 0, 862839, 'admin1', '1'),
- (64, '2016-08-01 10:35:36', 'vhsem', 10000, 0, 852839, 'admin1', '1'),
- (65, '2016-08-01 10:42:44', 'gulshan', 10000, 0, 842839, 'admin1', '1'),
- (66, '2016-08-02 16:31:24', 'aiems', 0, 0, 842839, 'admin1', '1'),
- (67, '2016-08-03 17:32:09', 'intense', 200000, 0, 642839, 'admin1', '1'),
- (68, '2016-08-03 17:32:51', 'intense', 200000, 0, 442839, 'Aurobindo School', '1'),
- (69, '2016-08-03 17:45:33', 'cmps', 0, 0, 442839, 'admin1', '1'),
- (70, '2016-08-03 17:46:48', 'creativemncl', 25000, 0, 417839, 'admin1', '1'),
- (71, '2016-08-03 17:47:22', 'divinity', 0, 0, 417839, 'admin1', '1'),
- (72, '2016-08-03 17:48:09', 'rkhs', 0, 0, 417839, 'admin1', '1'),
- (73, '2016-08-03 17:49:43', 'global', 10000, 0, 407839, 'admin1', '1'),
- (74, '2016-08-03 17:50:22', 'gracemm', 0, 0, 407839, 'admin1', '1'),
- (75, '2016-08-04 04:10:46', 'ahsguntur', 10000, 0, 397839, 'admin1', '1'),
- (76, '2016-08-04 18:45:35', 'gracenaspur', 0, 0, 397839, 'admin1', '1'),
- (77, '2016-08-04 18:48:19', 'gracemm', 0, 0, 397839, 'admin1', '1'),
- (78, '2016-08-04 18:50:21', 'littlekidz', 0, 0, 397839, 'admin1', '1'),
- (79, '2016-08-04 18:50:48', 'newslate', 0, 0, 397839, 'admin1', '1'),
- (80, '2016-08-04 18:51:24', 'pattana', 0, 0, 397839, 'admin1', '1'),
- (81, '2016-08-04 18:52:03', 'rktechno', 0, 0, 397839, 'admin1', '1'),
- (82, '2016-08-04 18:52:32', 'saischool', 0, 0, 397839, 'admin1', '1'),
- (83, '2016-08-04 18:53:01', 'shivanimm', 0, 0, 397839, 'admin1', '1'),
- (84, '2016-08-04 18:53:32', 'slatemncl', 0, 0, 397839, 'admin1', '1'),
- (85, '2016-08-04 18:54:08', 'spoorthimncl', 0, 0, 397839, 'admin1', '1'),
- (86, '2016-08-04 18:55:04', 'srvngdk', 0, 0, 397839, 'admin1', '1'),
- (87, '2016-08-04 18:55:54', 'sshsgdk', 0, 0, 397839, 'admin1', '1'),
- (88, '2016-08-04 18:56:26', 'stagnes', 0, 0, 397839, 'admin1', '1'),
- (89, '2016-08-04 18:57:00', 'stjohnrkp', 0, 0, 397839, 'admin1', '1'),
- (90, '2016-08-04 18:57:28', 'suffah', 0, 0, 397839, 'admin1', '1'),
- (91, '2016-08-04 18:57:53', 'tawakkalrkp', 0, 0, 397839, 'admin1', '1'),
- (92, '2016-08-04 18:59:00', 'trinitylp', 0, 0, 397839, 'admin1', '1'),
- (93, '2016-08-04 18:59:29', 'trinitymncl', 0, 0, 397839, 'admin1', '1'),
- (94, '2016-08-04 19:00:04', 'vaagdevischool', 0, 0, 397839, 'admin1', '1'),
- (95, '2016-08-04 19:00:35', 'vasavi111', 0, 0, 397839, 'admin1', '1'),
- (96, '2016-08-04 19:01:09', 'Vidyabharathi ', 0, 0, 397839, 'admin1', '1'),
- (97, '2016-08-04 19:01:54', 'zphsu', 0, 0, 397839, 'admin1', '1'),
- (98, '2016-08-05 15:14:22', 'gulsan', 0, 0, 397839, 'admin2', '58'),
- (99, '2016-08-05 15:14:56', 'gulsan', 10000, 0, 387839, 'Gulshan School', '58'),
- (100, '2016-08-09 07:01:36', 'global model', 0, 0, 387839, 'admin2', '58'),
- (101, '2016-08-09 10:38:52', 'bharathi', 0, 0, 387839, 'admin2', '58'),
- (102, '2016-08-17 05:33:07', 'ssvm', 0, 0, 387839, 'admin2', '58'),
- (103, '2016-08-17 11:44:07', 'Aditya School', 0, 0, 397839, 'admin1', '1'),
- (104, '2016-08-17 11:56:31', 'Bharathi Grammar', 0, 0, 397839, 'admin1', '1'),
- (105, '2016-08-17 12:13:03', 'littlestar', 0, 0, 397839, 'admin1', '1'),
- (106, '2016-08-17 12:16:08', 'matrusri', 0, 0, 397839, 'admin1', '1'),
- (107, '2016-08-17 12:18:08', 'montesory', 0, 0, 397839, 'admin1', '1'),
- (108, '2016-08-17 13:34:08', 'ssvm utr', 0, 0, 397839, 'admin1', '1'),
- (109, '2016-08-17 13:47:31', 'sunstar', 0, 0, 397839, 'admin1', '1'),
- (110, '2016-08-17 13:52:09', 'happyscholor`', 0, 0, 397839, 'admin1', '1'),
- (111, '2016-08-17 14:01:30', 'viswabharathi', 0, 0, 397839, 'admin1', '1'),
- (112, '2016-08-17 14:20:40', 'new kerala', 10000, 0, 377839, 'admin2', '58'),
- (113, '2016-08-17 14:33:35', 'tejaem', 0, 0, 397839, 'admin1', '1'),
- (114, '2016-08-19 05:20:27', 'ktsntpc', 0, 0, 397839, 'admin1', '1'),
- (115, '2016-08-19 13:14:32', 'SKTS School, Mandamarri', 0, 0, 397839, 'admin1', '1'),
- (116, '2016-08-19 13:18:49', 'lakeshore', 0, 0, 397839, 'admin1', '1'),
- (117, '2016-08-19 13:42:43', 'RBHV SCHOOL, mancheiral', 0, 0, 397839, 'admin1', '1'),
- (118, '2016-08-19 13:46:13', 'revulation school', 0, 0, 397839, 'admin1', '1'),
- (119, '2016-08-19 13:48:00', 'Little Flower School, mm', 0, 0, 397839, 'admin1', '1'),
- (120, '2016-08-19 16:15:33', 'Risingsun School', 0, 0, 397839, 'admin1', '1'),
- (121, '2016-08-19 16:41:46', 'radiantschool', 0, 0, 397839, 'admin1', '1'),
- (122, '2016-08-19 16:44:02', 'annapuran', 0, 0, 397839, 'admin1', '1'),
- (123, '2016-08-19 16:46:24', 'St Josheps ', 0, 0, 397839, 'admin1', '1'),
- (124, '2016-08-21 03:22:05', 'New kerala', 0, 0, 377839, 'admin2', '58'),
- (125, '2016-08-21 03:27:28', 'New kerala', 10000, 0, 367839, 'Gulshan High School', '58'),
- (126, '2016-08-21 06:21:07', 'Vivekananda', 0, 0, 367839, 'admin2', '58'),
- (127, '2016-08-21 12:35:54', 'hitechmncl', 12000, 0, 385839, 'admin1', '1'),
- (128, '2016-08-24 13:00:19', 'indian', 10000, 0, 375839, 'Aurobindo School, Mancherial', '1'),
- (129, '2016-08-29 06:46:34', 'bcdpl', 10000, 0, 365839, 'admin1', '1')
- `admintopayuserbills` (`pay_id`, `pay_date`, `pay_name`, `pay_amount`, `user_name`, `user_id`, `admin_id`) VALUES
- (230, '2016-08-21 00:00:00', 'Id cards ', 1500, 'New kerala', 111, 58),
- (201, '2016-08-05 00:00:00', 'Dairys', 50000, 'Chinnamunshi Public School', 57, 1),
- (231, '2016-08-21 00:00:00', 'Id Cards', 5000, 'Krishnaveni talent school, NTPC', 101, 1),
- (203, '2016-08-05 00:00:00', 'Dairys', 5000, 'grace School, Srirampur', 64, 1),
- (204, '2016-08-05 00:00:00', 'Id Cards', 500, 'Little Kidz Play School', 66, 1),
- (205, '2016-08-05 00:00:00', 'Dairys', 17400, 'New Slate School', 67, 1),
- (206, '2016-08-05 00:00:00', 'Dairys', 20000, 'R K Techno School', 69, 1),
- (207, '2016-08-05 00:00:00', 'Dairys', 510, 'Sai School For the Blind', 70, 1),
- (208, '2016-08-05 00:00:00', 'Dairys', 10000, 'Sri Sidhartha High School', 75, 1),
- (209, '2016-08-05 00:00:00', 'Dairys', 40000, 'Trinity High School Luxettipet', 80, 1),
- (210, '2016-08-05 00:00:00', 'Dairys', 29900, 'Trinity High School Luxettipet', 80, 1),
- (211, '2016-08-05 00:00:00', 'Dairys', 35000, 'Trinity High School Mancherial', 81, 1),
- (212, '2016-08-05 00:00:00', 'Con', 5385, 'Trinity High School Mancherial', 81, 1),
- (213, '2016-08-05 00:00:00', 'Dairys', 64400, 'Trinity High School Mancherial', 81, 1),
- (214, '2016-08-05 00:00:00', 'Bulk SMS', 3000, 'Global School ', 61, 1),
- (215, '2016-08-05 00:00:00', 'Id Cards', 1980, 'Zphs Sirpur (U)', 85, 1),
- (216, '2016-08-09 00:00:00', '', 3000, 'Global Model School', 87, 58),
- (217, '2016-08-09 00:00:00', '', 3000, 'Global Model School', 87, 58),
- (218, '2016-08-09 00:00:00', 'Dairys', 8000, 'St Agnes High School', 76, 1),
- (219, '2016-08-15 00:00:00', 'Id Cards', 5000, 'Bharathi Grammar School', 88, 58),
- (220, '2016-08-17 00:00:00', 'id cards', 5000, 'Bharathi Grammar School', 91, 1),
- (221, '2016-08-17 00:00:00', 'id cards', 3000, 'Gulshan High School', 86, 58),
- (223, '2016-08-17 00:00:00', 'Id Cards', 1500, 'New Kerala School', 52, 1),
- (224, '2016-08-19 00:00:00', 'Dairys', 7000, 'St John E Techno School', 77, 1),
- (225, '2016-08-19 00:00:00', 'Dairys', 10000, 'St John E Techno School', 77, 1),
- (226, '2016-08-19 00:00:00', 'Dairys', 10000, 'Sri Rama Vidyanikethan School', 74, 1),
- (227, '2016-08-19 00:00:00', 'Id Cards', 200, 'Teja E/M School', 100, 1),
- (228, '2016-08-19 00:00:00', 'Dairys', 5000, 'Vaagdevi School', 82, 1),
- (229, '2016-08-19 00:00:00', 'Id Cards', 5000, 'Vaagdevi School', 82, 1),
- (232, '2016-08-22 00:00:00', 'Id cards ', 2000, 'Global Model School', 87, 58),
- (233, '2016-08-22 00:00:00', 'Id cards ', 9000, 'Gulshan High School', 86, 58),
- (234, '2016-08-22 00:00:00', 'Id Cards', 12000, 'Gulshan School, Jainoor', 54, 1),
- (235, '2016-08-24 00:00:00', 'Id cards ', 5000, 'Bharathi Grammar School', 88, 58)
- `admintopayusersmsbills` (`pay_id`, `pay_date`, `pay_name`, `pay_amount`, `user_name`, `user_id`, `admin_id`) VALUES
- (4, '2016-08-02 00:00:00', 'Bulk SMS', 2000, 'Ramesh', 48, 1),
- (5, '2016-08-04 00:00:00', 'Bulk SMS', 2000, 'st alphonsa school, Guntur', 63, 1),
- (6, '2016-08-17 00:00:00', 'SMS', 2000, 'Gulshan High School', 86, 58),
- (7, '2016-08-17 00:00:00', 'SMS', 1500, 'New Kerala E/M School', 99, 58),
- (8, '2016-08-17 00:00:00', 'Bulk SMS', 2000, 'New Kerala School', 52, 1),
- (9, '2016-08-19 00:00:00', 'Id Cards', 5000, 'Krishnaveni talent school, NTPC', 101, 1),
- (10, '2016-08-21 00:00:00', 'SMS ', 2000, 'New kerala', 111, 58),
- (11, '2016-08-23 00:00:00', 'SMS', 2000, 'Gulshan School, Jainoor', 54, 1);
- `reseller` (`reseller_id`, `firstname`, `middlename`, `lastname`, `username`, `password`, `user_added`, `admin_mailid`, `smsusername`, `smspassword`, `smssenderid`, `smscredits`, `smsstatus`, `smsfooter`) VALUES
- (1, 'John', 'M.', 'Doe', 'r', 'r', '2015-11-10 14:01:56', '', 'sharonsys', 'sharonsys7', 'SCHOOL', -809, 'Active', ''),
- (2, 'Prabhakar', 'M.', 'japathi', 'rr', 'rr', '2015-11-10 14:01:56', '', 'sharonsys', 'sharonsys7', 'SCHOOL', -1277, 'Active', '')
- `smshistory` (`smssent_id`, `smssent_id_id`, `date`, `action`, `cellnos`, `sentmsg`, `user_name`, `user_id`, `msg_id`) VALUES
- (411, 0, '2016-08-21 06:34:35', 'send sms to select student', '9908302604', 'Demo Msg\r\n-ramesh', 'Ramesh ', '48', ''),
- (412, 0, '2016-08-21 06:36:31', 'send sms to select student', '9908302604', 'demo msg\r\n-ramesh', 'Ramesh ', '48', ''),
- (413, 0, '2016-08-21 06:38:33', 'send sms to select student', '9908302604', 'demo msg\r\n-ramesh', 'Ramesh ', '48', ''),
- (414, 0, '2016-08-21 06:40:41', 'send sms to select student', '9908302604', 'Demo msg2\r\n\r\n', 'Ramesh ', '48', ''),
- (415, 0, '2016-08-21 15:23:35', 'send sms to select student', '9059210823', 'Dear%20prabhakar%20you%20have%20Paid%20Rs%20500%20on%20dt%3A%202016-08-21.%20Remain%20Due%20Amount%20is%201000.%20Thank%20You%20From%3A%20-Ramesh%209908302604%20', 'Ramesh', '48', ''),
- (416, 0, '2016-08-21 16:59:28', 'send sms to select student', '9059210823', 'Dear%20prabhakar%20you%20have%20Paid%20Rs%201000%20on%20dt%3A%202016-08-21.%20Remain%20Due%20Amount%20is%200.%20Thank%20You%20From%3A%20-Ramesh%209908302604%20', 'Ramesh', '48', ''),
- (417, 0, '2016-08-21 17:05:55', 'send sms to select student', '9059210823', 'Demo msg \r\n-prabhakar', 'Ramesh ', '48', ''),
- (418, 0, '2016-08-21 17:08:38', 'send sms to select student', '9', 'Dear%204567%20you%20have%20Paid%20Rs%20200%20on%20dt%3A%202016-08-21.%20Remain%20Due%20Amount%20is%20-182.%20Thank%20You%20From%3A%20-Ramesh%209908302604%20', 'Ramesh', '48', ''),
- (419, 0, '2016-08-21 17:10:46', 'send sms to select student', '9', 'Dear%204567%20you%20have%20Paid%20Rs%20100%20on%20dt%3A%202016-08-21.%20Remain%20Due%20Amount%20is%20-282.%20Thank%20You%20From%3A%20-Ramesh%209908302604%20', 'Ramesh', '48', ''),
- (420, 0, '2016-08-22 05:55:35', 'send sms to select student', '9550393837', 'Dear%20A.%20Palavi%20you%20have%20Paid%20Rs%20500%20on%20dt%3A%202016-08-22.%20Remain%20Due%20Amount%20is%20-500.%20Thank%20You%20From%3A%20-Teja%20EM%20School%2C%20Shivvaram%20', 'Teja E/M School, Shi', '100', ''),
- (421, 0, '2016-08-22 06:00:43', 'send sms to select student', '9550393837', 'Demo msg\r\n-teja school', 'Teja E/M School, Shi', '100', ''),
- (422, 0, '2016-08-22 06:50:32', 'send sms to select student', '7396502547', 'Dear%20G.%20ASHWITHA%20you%20have%20Paid%20Rs%203000%20on%20dt%3A%202016-08-22.%20Remain%20Due%20Amount%20is%204000.%20Thank%20You%20From%3A%20-SKTS%20SCHOOL%2C%20Mandamarri%20', 'Tawakkal krishnaveni', '102', ''),
- (423, 0, '2016-08-22 06:53:02', 'send sms to select student', '7396502547', 'DEAR PARENT', 'Tawakkal krishnaveni', '102', ''),
- (424, 0, '2016-08-22 06:58:14', 'send sms to select student', '9908302604', 'Dear%20manohar%20you%20have%20Paid%20Rs%202000%20on%20dt%3A%202016-08-22.%20Remain%20Due%20Amount%20is%205500.%20Thank%20You%20From%3A%20-SKTS%20SCHOOL%2C%20Mandamarri%20', 'Tawakkal krishnaveni', '102', ''),
- (425, 0, '2016-08-27 13:56:40', 'send sms to select student', '9', 'Dear%20prabhakar%20japathi%20you%20have%20Paid%20Rs%208000%20on%20dt%3A%202016-08-27.%20Remain%20Due%20Amount%20is%206000.%20Thank%20You%20From%3A%20-Ramesh%209908302604%20', 'Ramesh', '48', '');
- `user` (`user_id`, `firstname`, `user_cellno`, `username`, `password`, `user_added`, `user_mailid`, `smsusername`, `smspassword`, `smssenderid`, `smscredits`, `smsstatus`, `admin_id`, `smsfooter`, `amountdesc`, `dueamount`, `smsdueamount`) VALUES
- (47, 'Aurobindo School, Mancherial', '9848962385', 'asmncl', 'asmncl', '2016-08-01 02:45:20', '23', 'a', 'a', 'a', 77335, 'Active', '1', '-Aurobindo School', 'Bulk SMS', 0, 2000),
- (48, 'Ramesh', '9908302604', 'ramesh', 'ramesh', '2016-08-01 02:50:22', 'a', 'sharonsys', 'sharonsys7', 'PRABKR', 9991, 'Active', '1', '-Ramesh 9908302604', 'Bulk SMS', 0, 0),
- (49, 'Indian School', '9652533309', 'indian', 'indian', '2016-08-01 02:57:41', 'a', 'a', 'a', 'aa', 25000, 'Active', '1', '-Indian School', 'pearls-5000 indian-10000 msgs', 0, 3750),
- (50, 'SRK School, RKP', '9949450939', 'srkems', 'srkems68', '2016-08-01 03:08:37', '40', 'a', 'a', 'a', 25000, 'Active', '1', 'a', 'Bulk SMS', 0, 5000),
- (52, 'New Kerala School, Kadem', '9490980735', 'newkerala', 'newkerala', '2016-08-01 07:27:09', '20', 'a', 'a', 'a', 9024, 'Active', '1', 'aa', 'a', 10650, 0),
- (53, 'Vivekananda School,Kalamadugu', '9492132722', 'vhsem', 'vhsem', '2016-08-01 10:35:36', '15', 'a', 'a', 'a', 10000, 'Active', '1', 'a', 'Bulk SMS', 23500, 2000),
- (54, 'Gulshan School, Jainoor', '9440386036', 'gulshan', 'gulshan', '2016-08-01 10:42:44', '23', 'a', 'a', 'a', 10000, 'Active', '1', 'a', 'Bulk SMS', 900, 0),
- (55, 'AIEMS School', '9010686013', 'aiems', 'aiems', '2016-08-02 16:31:24', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 36168, 0),
- (100, 'Teja E/M School, Shivvaram', '9959711305', 'tejaem', 'tejaem', '2016-08-17 14:33:35', '8', 'sharonsys', 'sharonsys7', 'SCHOOL', 4998, 'Active', '1', '-Teja EM School, Shivvaram', 'a', 5750, 0),
- (56, 'Intense', '9030580833', 'intense', 'intense', '2016-08-03 17:32:09', 'a', 'a', 'a', 'a', 400000, 'Active', '1', 'a', 'bulksms', 0, 38000),
- (57, 'Chinnamunshi Public School, Chennur', '9908302604', 'cmps', 'cmps', '2016-08-03 17:45:33', '75', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 25540, 0),
- (58, 'Creative EM School, Mancheiral', '7386519525', 'creativemncl', 'creativemncl', '2016-08-03 17:46:48', '30', 'a', 'a', 'a', 25000, 'Active', '1', 'a', 'a', 40578, 5000),
- (59, 'Divinity School, RKP', '9908302604', 'divinity', 'divinity', '2016-08-03 17:47:22', '20', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 9690, 0),
- (60, 'Dr.Radhakrishnan High School, Mancherial', '9908302604', 'rkhs', 'rksh', '2016-08-03 17:48:09', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 25040, 0),
- (61, 'Global School, Jainoor', '9553035995', 'global', 'global', '2016-08-03 17:49:43', '15', 'a', 'a', 'a', 10000, 'Active', '1', 'a', 'bulksms', 6690, 2000),
- (63, 'st alphonsa school, Guntur', '8008316630', 'ahsguntur', 'ahsguntur', '2016-08-04 04:10:46', 'a', 'a', 'a', 'a', 10000, 'Active', '1', 'a', 'Bulk SMS', 0, 0),
- (65, 'grace Little Hearts, Mandamarri', '9908302604', 'gracemm', 'gracemm', '2016-08-04 18:48:19', '25', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 13850, 0),
- (64, 'Grace School, Srirampur', '9052433836', 'gracenaspur', 'gracenaspur', '2016-08-04 18:45:35', '18', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 12500, 0),
- (66, 'Little Kidz Play School, Mancherial', '9908302604', 'littlekidz', 'littlekidz', '2016-08-04 18:50:21', '8', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 1440, 0),
- (67, 'New Slate School, Chennur', '9908302604', 'newslate', 'newslate', '2016-08-04 18:50:48', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 9600, 0),
- (68, 'Pattana Arya Vyashna Sangam', '9908302604', 'pattana', 'pattana', '2016-08-04 18:51:24', 'a', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 9480, 0),
- (69, 'R K Techno School, luxettipet', '9908302604', 'rktechno', 'rktechno', '2016-08-04 18:52:03', '25', 'a', 'a', 'a', 0, 'Active', '1', 'aa', '0', 15000, 0),
- (70, 'Sai School For the Blind, Mancherial', '9908302604', 'saischool', 'saischool', '2016-08-04 18:52:32', '8', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 0, 0),
- (71, 'Shivani High School, Mandamarri', '9908302604', 'shivanimm', 'shivanimm', '2016-08-04 18:53:01', '20', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 33813, 0),
- (72, 'Slate High School, Mancherial', '9908302604', 'slatemncl', 'slatemncl', '2016-08-04 18:53:32', '22', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 23750, 0),
- (73, 'Spoorthi School, Mancherial', '9989165321', 'spoorthimncl', 'spoorthimncl', '2016-08-04 18:54:08', '15', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 5940, 0),
- (74, 'Sri Rama Vidyanikethan School', '7686036411', 'srvngdk', 'srvngdk', '2016-08-04 18:55:04', '55', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 21640, 0),
- (75, 'Sri Sidhartha High School, GDK', '9849266400', 'sshsgdk', 'sshsgdk', '2016-08-04 18:55:54', '40', 'a', 'a', 'a', 0, 'Active', '1', '0', '0', 36600, 0),
- (76, 'St Agnes High School, Goleti', '9908313202', 'stagnes', 'stagnes', '2016-08-04 18:56:26', '16', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 11500, 0),
- (77, 'St John E Techno School, RKP', '9989236655', 'stjohnrkp', 'stjohnrkp', '2016-08-04 18:57:00', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 28110, 0),
- (78, 'Suffah School,Mancherial', '9849161512', 'suffah', 'suffah786', '2016-08-04 18:57:28', '28', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 11400, 0),
- (79, 'Tawakkal High school , RKP', '9908302604', 'tawakkalrkp', 'tawakkalrkp', '2016-08-04 18:57:53', '38', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 25860, 0),
- (80, 'Trinity High School Luxettipet', '9908302604', 'trinitylp', 'trinitylp', '2016-08-04 18:59:00', '33', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 0, 0),
- (81, 'Trinity High School Mancherial', '9908302604', 'trinitymncl', 'trinitymncl', '2016-08-04 18:59:29', '60', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', -375, 0),
- (82, 'Vaagdevi School, Mancherial', '9290465772', 'vaagdevischool', 'vaagdevischool', '2016-08-04 19:00:04', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 5558, 0),
- (83, 'Vasavi Couples Club Tandur', '9908302604', 'vasavi111', 'vasavi111', '2016-08-04 19:00:35', 'a', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 480, 0),
- (84, 'Vidyabharathi High School, Tandoor', '9908302604', 'Vidyabharathi ', 'Vidyabharathi ', '2016-08-04 19:01:09', '65', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 87300, 0),
- (85, 'Zphs Sirpur (U)', '9441394431', 'zphsu', 'zphsu', '2016-08-04 19:01:54', '15', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 0, 0),
- (86, 'Gulshan High School', '9440386036', 'gulsan', 'gulsan', '2016-08-05 15:14:22', '9014750750', 'a', 'a', 'a', 10000, 'Active', '58', 'a', 'aa', 1350, 0),
- (87, 'Global Model School', '9553035995', 'global model', 'global model', '2016-08-09 07:01:36', 'a', 'a', 'a', 'a', 0, 'Active', '58', 'a', 'a', 3690, 0),
- (88, 'Bharathi Grammar School', '9440441652', 'bharathi', 'bharathi', '2016-08-09 10:38:52', 'a', 'a', 'a', 'a', 0, 'Active', '58', 'a', 'a', 10880, 0),
- (89, 'Shri Sharadha Vidya Mandiram', '8500513191', 'ssvm', 'ssvm', '2016-08-17 05:33:07', 'a', 'aa', 'a', 'a', 0, 'Active', '58', 'a', 'a', 9380, 0),
- (90, 'Aditya High School, CCC', '9908302604', 'Aditya School', 'aditya school', '2016-08-17 11:44:07', '26', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 13510, 0),
- (91, 'Bharathi Grammar School, Jainoor', '9014750750', 'Bharathi Grammar', 'Bharathi Grammar', '2016-08-17 11:56:31', '15', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 15100, 0),
- (92, 'Little Star School, Srirampur', '9908302604', 'littlestar', 'littlestar', '2016-08-17 12:13:03', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 16350, 0),
- (93, 'Matrusri Play School, Mancherial', '9908302604', 'matrusri', 'matrusri', '2016-08-17 12:16:08', '20', 'aa', 'a', 'a', 0, 'Active', '1', 'a', 'a', 2100, 0),
- (94, 'montessori school, Mandamarri', '9908302604', 'montesory', 'montesory', '2016-08-17 12:18:08', '30', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 14150, 0),
- (102, 'Tawakkal krishnaveni talent school, mandamarri', '9908302604', 'sktsmm', 'sktsmm', '2016-08-19 13:14:32', '32', 'sharonsys', 'sharonsys7', 'SCHOOL', -3, 'Active', '1', '-SKTS SCHOOL, Mandamarri', '0', 22500, 0),
- (95, 'Sri Sharada Vidya Mandiram, Utnoor', '9014750750', 'ssvm utr', 'ssvm', '2016-08-17 13:34:08', '12', 'aa', 'a', 'a', 0, 'Active', '1', 'a', 'a', 9380, 0),
- (96, 'Sun Star School, Srirampur', '9908302604', 'sunstar', 'sunstar', '2016-08-17 13:47:31', '13', 'aa', 'a', 'a', 0, 'Active', '1', 'a', 'a', 5820, 0),
- (97, 'The Happy Scholor School, Mancherial', '9989150085', 'happyscholor`', 'happyscholor', '2016-08-17 13:52:09', '19', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 10770, 0),
- (98, 'Vishwa Bharathi High School', '9059160954', 'viswabharathi', 'viswabharathi', '2016-08-17 14:01:30', '58', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 24400, 0),
- (101, 'Krishnaveni talent school, NTPC', '9440447929', 'ktsntpc', 'ktsntpc', '2016-08-19 05:20:27', '38', 'a', 'a', 'a', 0, 'Active', '1', 'a', 'a', 15250, -5000),
- (103, 'Lakeshore School, Mancheiral', '9908302604', 'lakeshore', 'lakeshore', '2016-08-19 13:18:49', '10', 'a', 'a', 'a', 0, 'Active', '1', 'a', '0', 1625, 0),
- (104, 'RBHV SCHOOL, mancheiral', '9908302604', 'RBHV SCHOOL, mancheiral', 'RBHV SCHOOL, mancheiral', '2016-08-19 13:42:43', '50', 'a', '0', '0', 0, 'Active', '1', '0', '0', 0, 0),
- (105, 'Revulation School, MNCL', '9908302604', 'revulation school', 'revulation school', '2016-08-19 13:46:13', '40', 'A', 'A', 'A', 0, 'Active', '1', 'A0', '0', 0, 0),
- (106, 'Little Flower School, Mandamarri', '9908302604', 'Little Flower School, mm', 'lfs', '2016-08-19 13:48:00', '45', '0', '0', '0', 0, 'Active', '1', '0', '0', 0, 0),
- (107, 'Risingsun School, Mancherial', '9908302604', 'Risingsun School', 'Risingsun School', '2016-08-19 16:15:33', '25', '0', '0', '0', 0, 'Active', '1', '0', '0', 0, 0),
- (108, 'Radiant School, CCC', '9908302604', 'radiantschool', 'radiantschool', '2016-08-19 16:41:46', '35', 'a', 'a', 'a', 0, 'Active', '1', '0', '0', 0, 0),
- (109, 'Annapurna School, Rebenna', '9908302604', 'annapuran', 'Annapurna School', '2016-08-19 16:44:02', '35', '0', '0', '0', 0, 'Active', '1', '0', '0', 0, 0),
- (110, 'St Josheps School, Ramakrishnapur', '9908302604', 'St Josheps ', 'St Josheps ', '2016-08-19 16:46:24', '20', '0', '0', '0', 0, 'Active', '1', '0', '0', 0, 0),
- (111, 'New Kerala E/M School', '9014750750', 'New kerala', 'New kerala ', '2016-08-21 03:22:05', 'A', 'A', 'A', 'A', 10000, 'Active', '58', 'A', 'A', 10650, 0),
- (112, 'Vivekananda', '9014750750', 'Vivekananda', 'vivekananda', '2016-08-21 06:21:07', 'A', 'A', 'A', 'A', 0, 'Active', '58', 'A', 'A', 0, 0),
- (113, 'Hitech City, MNCl', '9885282233', 'hitechmncl', 'hitechmncl', '2016-08-21 12:35:54', 'a', 'a', 'a', 'a', 12000, 'Active', '1', 'a', 'Bulk SMS', 0, 2000),
- (114, 'Brightway', '9866033600', 'bcdpl', 'bcdpl', '2016-08-29 06:46:34', '0', '0', '0', '0', 10000, 'Active', '1', '0', 'bulk sms', 0, 1500);
- http://sbt.co.in
- `users` VALUES (0,'admin','14e6ec9940863408','CSD Dept'),(1,'dgmtvm','0fa6d97274dde249','DGM TRIVANDRUM'),(3,'dgmekm','0fa6d97274dde249','DGM ERNAKULAM'),(2,'dgmktm','0fa6d97274dde249','DGM KOTTAYAM'),(4,'dgmkkd','0fa6d97274dde249','DGM KOZHIKODE'),(5,'dgmchennai','0fa6d97274dde249','DGM CHENNAI'),(6,'dgmdelhi','0fa6d97274dde249','DGM DELHI'),(7,'dgmtsr','0fa6d97274dde249','DGM THRISSUR');
- http://www.tiplindia.in
- `radio` (`Name`, `ContactID`, `Address`, `Email`, `Comment`) VALUES
- ('asjskja', NULL, 'jakjsa', 'asjksja', 'kjajksa'),
- ('sajksa', NULL, 'jskakjsa', 'rittiz.mitra@gmail.com', 'skajkjas'),
- ('Ritiz Mitra', NULL, 'Flat-F,3rd Floor,15A/2,Gokuldham Complex,Dharmatala Road,Kasba', 'rittiz.mitra@g', 'ksajjaks'),
- ('Ritiz Mitra', NULL, 'Flat-F,3rd Floor,15A/2,Gokuldham Complex,Dharmatala Road,Kasba', 'rittiz.mitra@gmail.com', 'ksajjaks'),
- ('adskjsadj', NULL, 'adskjsad', 'dskjjkds@gmail.com', 'kjdajksd'),
- ('daskdk', NULL, 'sdajkad', 'djas@gmail.com', 'hjdsahdas'),
- ('asdadskj', NULL, 'jkadskjad', 'kjaja@gmail.com', 'jdhjdsajh'),
- ('Ritiz', NULL, 'sakjas', 'sakjjsa@gmail.com', 'jajsjksa'),
- ('devjyoti', NULL, 'salt lake', 'devjyoti@gmail.com', 'this is is a test message'),
- ('jaksjks', '932932983298', 'akjakj', 'dskh@gmail.com', 'ioiodajkjsaksa');
- http://www.gjust.ac.in
- `tblstaff` (`catid`, `sid`, `s_name`, `designation`, `quali`, `special`, `phone`, `email`, `s_img`) VALUES
- (1, 1, 'Prof. (Dr.) B. K. PUNIA', 'Director', 'Ph. D. (Management)', NULL, '01662-263573, 263311', 'bkpunia@rediffmail.com', 'Prof. (Dr.) B. K. PUNIA.jpg'),
- (1, 2, 'Dr. (Mrs.) VANDANA PUNIA', 'Associate Professor', 'Ph. D. (Education)', NULL, '01662-263199', 'vbpunia@rediffmail.com', 'Dr. Vandana Punia.jpg'),
- (1, 3, 'Er. ANURAG SANGWAN', 'Assistant Professor', 'M. Tech.', NULL, '01662-263164', 'anuragsangwan@gjust.org', 'Anurag Sangwan.jpg'),
- (2, 1, 'Mr. KARAMVIR RANGA', 'Assistant', NULL, NULL, '9416590593', 'kaviranga2010@gmail.com', 'Mr. Karamvir Ranga.jpg'),
- (2, 2, 'Mr. JITENDER', 'Librarian/Technician', NULL, NULL, '8950059008', 'jitenderpawdia@gmail.com', 'Mr. Jitender.jpg'),
- (2, 3, 'Mr. SUNDER SINGH', 'Assistant', NULL, NULL, '9355555364', 'sundersinghkohar@yahoo.com', 'Mr. Sunder Kohar.jpg'),
- (2, 4, 'Mr. ABHISHEK', 'Clerk-cum-JDEO', NULL, NULL, '8295522224', 'a.abhishek22@rediffmail.com', 'Mr. Abhishek.jpg'),
- (2, 5, 'Mr. RAJENDER KUMAR', 'Hostel Attendant', NULL, '', '9416786971', NULL, 'Mr. Rajinder Jangra.jpg'),
- (3, 1, 'JAGDISH KUMAR', 'Peon', NULL, NULL, '9416528260', NULL, 'Mr. Jagdish Kumar.jpg'),
- (3, 2, 'SAJJAN KUMAR', 'Sweeper-cum-Cleaner', NULL, NULL, '9728205779', NULL, 'Mr. Sajjan.jpg');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement