DROP TABLE mod_MSG91sms_messages; CREATE TABLE `mod_MSG91sms_messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sender` varchar(40) NOT NULL, `to` varchar(15) DEFAULT NULL, `text` text DEFAULT NULL, `msgid` varchar(50) DEFAULT NULL, `status` varchar(10) DEFAULT NULL, `errors` text DEFAULT NULL, `logs` text DEFAULT NULL, `user` int(11) DEFAULT NULL, `datetime` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=147 DEFAULT CHARSET=utf8; INSERT INTO mod_MSG91sms_messages VALUES("27","msg91","8801836722508","Hi Md. Arif , the payment associated with your account with date 17.02.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18119","2019-02-18 09:00:15"); INSERT INTO mod_MSG91sms_messages VALUES("24","msg91","8801818917810","Dear Md. Tajul islam, payment for due date, 30.11.2018 is done! Thank you.","","error","
","
Debug Result
","1","2019-02-17 21:02:25"); INSERT INTO mod_MSG91sms_messages VALUES("4","msg91","880181891781","Dear Md. Tajul islam, OTP generated for your mobile phone verification is 404401 for Request # Bg2yUIUXl3ycjL4xw9kc.","","error","
","
Debug Result
","1","2019-02-01 15:18:05"); INSERT INTO mod_MSG91sms_messages VALUES("26","msg91","8801815044284","Hi Md. Abdul Hannan , The due date for the payment is 25.02.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18124","2019-02-18 09:00:13"); INSERT INTO mod_MSG91sms_messages VALUES("8","msg91","8801770044004","Dear Abu Naser Bhuiyan , OTP generated for your mobile phone verification is 973190 for Request # QyBoUEU1gxDRNIM9l83n.","","error","
","
Debug Result
","18121","2019-02-10 14:51:25"); INSERT INTO mod_MSG91sms_messages VALUES("25","msg91","8801815044284","Hi Md. Abdul Hannan , The due date for the payment is 25.02.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18124","2019-02-18 09:00:12"); INSERT INTO mod_MSG91sms_messages VALUES("10","msg91","8801818917810","Dear Md. Tajul islam, OTP generated for your mobile phone verification is 619367 for Request # p7ilx6TtTe2pSsjl7MH0.","","error","
","
Debug Result
","1","2019-02-17 15:08:33"); INSERT INTO mod_MSG91sms_messages VALUES("11","msg91","8801701665700","Dear Md. salauddin Sahin, OTP generated for your mobile phone verification is 621831 for Request # x5JGxeJ0A3iRRLKJ3IGh.","","error","
","
Debug Result
","2","2019-02-17 15:08:56"); INSERT INTO mod_MSG91sms_messages VALUES("12","msg91","880880191147942","Dear Rowshan Akhter Khan , OTP generated for your mobile phone verification is 398179 for Request # lSLu4G7yLf0ZHFnRNOw2.","","error","
","
Debug Result
","18114","2019-02-17 15:10:18"); INSERT INTO mod_MSG91sms_messages VALUES("13","msg91","8801723737262","Dear Md. Sanaullah , OTP generated for your mobile phone verification is 595292 for Request # kXrsbhDiUykSVqhZZ2k2.","","error","
","
Debug Result
","18125","2019-02-17 15:10:33"); INSERT INTO mod_MSG91sms_messages VALUES("14","msg91","8801815044284","Dear Md. Abdul Hannan , OTP generated for your mobile phone verification is 789728 for Request # RCmDAo4RS4KAhhK7TvGj.","","error","
","
Debug Result
","18124","2019-02-17 15:10:47"); INSERT INTO mod_MSG91sms_messages VALUES("15","msg91","8801711188780","Dear Professor Md. Abdur Razzak , OTP generated for your mobile phone verification is 451845 for Request # J8MJT406d7F8YB70cbRX.","","error","
","
Debug Result
","18123","2019-02-17 15:11:15"); INSERT INTO mod_MSG91sms_messages VALUES("16","msg91","8801719344678","Dear Saidur rahman , OTP generated for your mobile phone verification is 852835 for Request # L4rQKxVxRzW0pE6nmkF5.","","error","
","
Debug Result
","18115","2019-02-17 15:11:39"); INSERT INTO mod_MSG91sms_messages VALUES("17","msg91","8801727099248","Dear Md. Hasan , OTP generated for your mobile phone verification is 217750 for Request # nxtElFBlqwoLiOULC7ZG.","","error","
","
Debug Result
","18122","2019-02-17 15:12:23"); INSERT INTO mod_MSG91sms_messages VALUES("18","msg91","8801770044004","Dear Abu Naser Bhuiyan , OTP generated for your mobile phone verification is 917285 for Request # SdpRpZ83fbZhaqjOeWH6.","","error","
","
Debug Result
","18121","2019-02-17 15:12:39"); INSERT INTO mod_MSG91sms_messages VALUES("19","msg91","8801639146778","Dear Md. Rakib , OTP generated for your mobile phone verification is 956332 for Request # EDbo9hba7cICeUJcrywN.","","error","
","
Debug Result
","18120","2019-02-17 15:12:55"); INSERT INTO mod_MSG91sms_messages VALUES("20","msg91","8801836722508","Dear Md. Arif , OTP generated for your mobile phone verification is 495174 for Request # 4vRvvtzEbfsqWnnH7o44.","","error","
","
Debug Result
","18119","2019-02-17 15:13:09"); INSERT INTO mod_MSG91sms_messages VALUES("21","msg91","8801712034040","Dear Md. Taslim Mia Readoy, OTP generated for your mobile phone verification is 261247 for Request # qL8Ypla0Supzz8GVzy8R.","","error","
","
Debug Result
","18118","2019-02-17 15:13:23"); INSERT INTO mod_MSG91sms_messages VALUES("22","msg91","8801922332421","Dear Md. Tareq , OTP generated for your mobile phone verification is 266885 for Request # FVxpyzkGi7Few6lbryYx.","","error","
","
Debug Result
","18117","2019-02-17 15:13:39"); INSERT INTO mod_MSG91sms_messages VALUES("23","msg91","8801838460778","Dear Syed Samshoddoha Bony , OTP generated for your mobile phone verification is 064150 for Request # 0j31fewcfTpJ0IaeheA8.","","error","
","
Debug Result
","18116","2019-02-17 15:13:52"); INSERT INTO mod_MSG91sms_messages VALUES("31","msg91","8801818917810","Hi Md. Tajul islam, the payment associated with your account with date 18.02.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","1","2019-02-19 09:00:16"); INSERT INTO mod_MSG91sms_messages VALUES("30","E1brand","+8801818-917810"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tajul (Tellbd), TK 10.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561240 +8801818-917810 ","190234","Send","","","1","2019-02-17 21:02:19"); INSERT INTO mod_MSG91sms_messages VALUES("32","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 300000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561273 +8801922-332421 ","190235","Send","","","18117","2019-02-19 18:29:13"); INSERT INTO mod_MSG91sms_messages VALUES("33","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 50000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561274 +8801922-332421 ","190236","Send","","","18117","2019-02-19 18:37:28"); INSERT INTO mod_MSG91sms_messages VALUES("34","msg91","8801836722508","Dear Md. Arif , payment for due date, 05.02.2019 is done! Thank you.","","error","
","
Debug Result
","18119","2019-02-20 08:33:59"); INSERT INTO mod_MSG91sms_messages VALUES("35","E1brand","+8801836-722508"," tellbd24 f6ImimnX bdNewsClub Dear Md. Arif (Social Trust Development ORG), TK 2000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561259 +8801836-722508 ","190237","Send","","","18119","2019-02-20 08:33:57"); INSERT INTO mod_MSG91sms_messages VALUES("36","msg91","8801922332421","Hi Md. Tareq , The due date for the payment is 05.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18117","2019-02-26 09:00:16"); INSERT INTO mod_MSG91sms_messages VALUES("37","msg91","8801922332421","Hi Md. Tareq , The due date for the payment is 05.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18117","2019-02-26 09:00:18"); INSERT INTO mod_MSG91sms_messages VALUES("38","msg91","8801815044284","Hi Md. Abdul Hannan , the payment associated with your account with date 25.02.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18124","2019-02-26 09:00:19"); INSERT INTO mod_MSG91sms_messages VALUES("39","msg91","8801815044284","Hi Md. Abdul Hannan , the payment associated with your account with date 25.02.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18124","2019-02-26 09:00:20"); INSERT INTO mod_MSG91sms_messages VALUES("40","msg91","8801836722508","Hi Md. Arif , The due date for the payment is 06.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18119","2019-02-27 09:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("41","E1brand","+8801836-722508"," tellbd24 f6ImimnX bdNewsClub Dear Md. Arif (Social Trust Development ORG), TK 2000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561275 +8801836-722508 ","190238","Send","","","18119","2019-02-27 17:41:57"); INSERT INTO mod_MSG91sms_messages VALUES("42","msg91","8801836722508","Dear Md. Arif , payment for due date, 06.03.2019 is done! Thank you.","","error","
","
Debug Result
","18119","2019-02-27 17:42:03"); INSERT INTO mod_MSG91sms_messages VALUES("43","msg91","8801836722508","Dear Md. Arif , payment for due date, 17.02.2019 is done! Thank you.","","error","
","
Debug Result
","18119","2019-02-27 17:42:05"); INSERT INTO mod_MSG91sms_messages VALUES("44","E1brand","+8801836-722508"," tellbd24 f6ImimnX bdNewsClub Dear Md. Arif (Social Trust Development ORG), TK 2000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561267 +8801836-722508 ","190239","Send","","","18119","2019-02-27 17:42:03"); INSERT INTO mod_MSG91sms_messages VALUES("45","msg91","8801818917810","Dear Md. Tajul islam, payment for due date, 18.02.2019 is done! Thank you.","","error","
","
Debug Result
","1","2019-02-27 17:47:10"); INSERT INTO mod_MSG91sms_messages VALUES("46","E1brand","+8801818-917810"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tajul (Tellbd), TK 11.85 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561268 +8801818-917810 ","190240","Send","","","1","2019-02-27 17:47:09"); INSERT INTO mod_MSG91sms_messages VALUES("47","msg91","8801818917810","Dear Md. Tajul islam, payment for due date, 18.02.2019 is done! Thank you.","","error","
","
Debug Result
","1","2019-02-27 17:48:10"); INSERT INTO mod_MSG91sms_messages VALUES("48","msg91","8801818917810","Dear Md. Tajul islam, payment for due date, 10.02.2019 is done! Thank you.","","error","
","
Debug Result
","1","2019-02-27 17:50:40"); INSERT INTO mod_MSG91sms_messages VALUES("49","msg91","8801836722508","Dear Md. Arif , OTP generated for your mobile phone verification is 022407 for Request # S6LVXNdmMR7PCqDxlaF2.","","error","
","
Debug Result
","18119","2019-03-01 19:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("50","msg91","8801836722508","Dear Md. Arif , OTP generated for your mobile phone verification is 054949 for Request # 4crLioWOo7H2Cxfs3qNN.","","error","
","
Debug Result
","18119","2019-03-01 19:00:23"); INSERT INTO mod_MSG91sms_messages VALUES("51","msg91","8801922332421","Hi Md. Tareq , the payment associated with your account with date 05.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18117","2019-03-06 09:00:20"); INSERT INTO mod_MSG91sms_messages VALUES("52","msg91","8801922332421","Hi Md. Tareq , the payment associated with your account with date 05.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18117","2019-03-06 09:00:22"); INSERT INTO mod_MSG91sms_messages VALUES("53","msg91","8801836722508","Hi Md. Arif , The due date for the payment is 15.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18119","2019-03-08 09:00:15"); INSERT INTO mod_MSG91sms_messages VALUES("54","msg91","","Hi Secretary general, administration department , Thank you for registering with us. The details of your account are- Email: nom@gdh.vv Password: 123456","","error","
","
Debug Result
","18126","2019-03-10 04:52:19"); INSERT INTO mod_MSG91sms_messages VALUES("55","msg91","","","","error","
","
Debug Result
","0","2019-03-11 14:30:36"); INSERT INTO mod_MSG91sms_messages VALUES("56","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 500000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561371 +8801922-332421 ","190243","Send","","","18117","2019-03-12 15:28:42"); INSERT INTO mod_MSG91sms_messages VALUES("57","msg91","8801836722508","Hi Md. Arif , the payment associated with your account with date 15.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18119","2019-03-16 09:02:13"); INSERT INTO mod_MSG91sms_messages VALUES("58","msg91","","Hi Secretary general, Administration Department , The due date for the payment is 24.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18126","2019-03-17 09:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("59","msg91","","Hi Secretary general, Administration Department , The due date for the payment is 24.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18126","2019-03-17 09:00:15"); INSERT INTO mod_MSG91sms_messages VALUES("60","msg91","8801922332421","Hi Md. Tareq , The due date for the payment is 26.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18117","2019-03-19 09:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("61","E1brand","+8801838-460778"," tellbd24 f6ImimnX bdNewsClub Dear Syed Samshoddoha Bony (Global Electronics.eng), TK 40000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561248 +8801838-460778 ","190244","Send","","","18116","2019-03-19 14:02:13"); INSERT INTO mod_MSG91sms_messages VALUES("62","msg91","","","","error","
","
Debug Result
","0","2019-03-19 14:16:35"); INSERT INTO mod_MSG91sms_messages VALUES("63","msg91","8801701665700","Hi Md. salauddin Sahin, The due date for the payment is 28.03.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","2","2019-03-21 09:00:16"); INSERT INTO mod_MSG91sms_messages VALUES("64","msg91","8801836722508","Dear Md. Arif , OTP generated for your mobile phone verification is 496045 for Request # 7Ae8zpWxN5Fk2Bf0c1lx.","","error","
","
Debug Result
","18119","2019-03-24 14:09:15"); INSERT INTO mod_MSG91sms_messages VALUES("65","msg91","","Hi Secretary general, Administration Department , the payment associated with your account with date 24.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18126","2019-03-25 09:00:13"); INSERT INTO mod_MSG91sms_messages VALUES("66","msg91","","Hi Secretary general, Administration Department , the payment associated with your account with date 24.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18126","2019-03-25 09:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("67","msg91","8801922332421","Hi Md. Tareq , the payment associated with your account with date 26.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18117","2019-03-27 09:00:17"); INSERT INTO mod_MSG91sms_messages VALUES("68","msg91","8801701665700","Hi Md. salauddin Sahin, the payment associated with your account with date 28.03.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","2","2019-03-29 09:00:14"); INSERT INTO mod_MSG91sms_messages VALUES("69","msg91","8801712866957","Hi Md. Mahmudul hasan , Thank you for registering with us. The details of your account are- Email: Mahamadulhasan1978@gmail.com Password: 123456","","error","
","
Debug Result
","18127","2019-04-01 17:50:23"); INSERT INTO mod_MSG91sms_messages VALUES("70","E1brand","+8801712-866957"," tellbd24 f6ImimnX bdNewsClub Dear Md. Mahmudul hasan (MS. L R Traders Ltd.), TK 15000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561428 +8801712-866957 ","190245","Send","","","18127","2019-04-01 18:19:57"); INSERT INTO mod_MSG91sms_messages VALUES("71","E1brand","+8801712-866957"," tellbd24 f6ImimnX bdNewsClub Dear Md. Mahmudul hasan (MS. L R Traders Ltd.), TK 15000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561428 +8801712-866957 ","190246","Send","","","18127","2019-04-01 18:46:08"); INSERT INTO mod_MSG91sms_messages VALUES("72","msg91","","","","error","
","
Debug Result
","0","2019-04-01 18:56:59"); INSERT INTO mod_MSG91sms_messages VALUES("73","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 20000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561409 +8801815-044284 ","190247","Send","","","18124","2019-04-01 09:35:36"); INSERT INTO mod_MSG91sms_messages VALUES("74","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 8000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561447 +8801922-332421 ","190248","Send","","","18117","2019-04-02 10:15:25"); INSERT INTO mod_MSG91sms_messages VALUES("75","msg91","8801922332421","Dear Md. Tareq , payment for due date, 16.04.2019 is done! Thank you.","","error","
","
Debug Result
","18117","2019-04-02 16:36:41"); INSERT INTO mod_MSG91sms_messages VALUES("76","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 500.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561466 +8801922-332421 ","190249","Send","","","18117","2019-04-02 16:36:36"); INSERT INTO mod_MSG91sms_messages VALUES("77","msg91","8801922332421","Dear Md. Tareq , payment for due date, 16.04.2019 is done! Thank you.","","error","
","
Debug Result
","18117","2019-04-02 16:40:05"); INSERT INTO mod_MSG91sms_messages VALUES("78","E1brand","+8801922-332421"," tellbd24 f6ImimnX bdNewsClub Dear Md. Tareq (indesk), TK 2760.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561447 +8801922-332421 ","190250","Send","","","18117","2019-04-02 16:40:04"); INSERT INTO mod_MSG91sms_messages VALUES("79","msg91","","","","error","
","
Debug Result
","0","2019-04-02 17:51:23"); INSERT INTO mod_MSG91sms_messages VALUES("80","msg91","8801922332421","Dear Md. Tareq , OTP generated for your mobile phone verification is 071640 for Request # CxuW7Yz3eXy45vmzT9Vj.","","error","
","
Debug Result
","18117","2019-04-02 17:53:46"); INSERT INTO mod_MSG91sms_messages VALUES("81","msg91","","Hi Md. Jafor Saheb , Thank you for registering with us. The details of your account are- Email: noma@gdh.vv Password: 123456","","error","
","
Debug Result
","18128","2019-04-07 07:22:35"); INSERT INTO mod_MSG91sms_messages VALUES("82","msg91","8801922103466","Dear Md. Jafor Saheb , OTP generated for your mobile phone verification is 655478 for Request # Rp8cWik3utdeCInLuMdW.","","error","
","
Debug Result
","18128","2019-04-07 07:30:11"); INSERT INTO mod_MSG91sms_messages VALUES("83","msg91","8801922103466","Dear Md. Jafor Saheb , OTP generated for your mobile phone verification is 106200 for Request # jO6LqVbF7hMXsMmftPQU.","","error","
","
Debug Result
","18128","2019-04-07 07:30:21"); INSERT INTO mod_MSG91sms_messages VALUES("84","msg91","8801922103466","Dear Md. Jafor Saheb , OTP generated for your mobile phone verification is 101994 for Request # zVL1PGyPxxoUCGlBoZ2R.","","error","
","
Debug Result
","18128","2019-04-07 07:31:13"); INSERT INTO mod_MSG91sms_messages VALUES("85","msg91","8801922103466","Dear Md. Jafor Saheb , OTP generated for your mobile phone verification is 647023 for Request # 33LS4719JO67Nc6qoYcV.","","error","
","
Debug Result
","18128","2019-04-07 08:46:13"); INSERT INTO mod_MSG91sms_messages VALUES("86","msg91","8801815044284","Hi Md. Abdul Hannan , The due date for the payment is 15.04.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18124","2019-04-08 09:00:10"); INSERT INTO mod_MSG91sms_messages VALUES("87","msg91","8801712866957","Hi Md. Mahmudul hasan , The due date for the payment is 15.04.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18127","2019-04-08 09:00:12"); INSERT INTO mod_MSG91sms_messages VALUES("88","msg91","","Hi Md. Shawon , Thank you for registering with us. The details of your account are- Email: shaown@tvsl-bd.com Password: 12345","","error","
","
Debug Result
","18129","2019-04-11 06:13:07"); INSERT INTO mod_MSG91sms_messages VALUES("89","msg91","","Hi Md. Ariful islam , Thank you for registering with us. The details of your account are- Email: ariful.islam@tvsl-bd.com Password: ","","error","
","
Debug Result
","18130","2019-04-11 06:14:11"); INSERT INTO mod_MSG91sms_messages VALUES("90","msg91","8801970092454","Dear Md. Shawon , OTP generated for your mobile phone verification is 541528 for Request # 4hmT0pNxPWvXE6pNp0Qi.","","error","
","
Debug Result
","18129","2019-04-11 06:15:06"); INSERT INTO mod_MSG91sms_messages VALUES("91","msg91","8801626690009","Hi Dr Asif , Thank you for registering with us. The details of your account are- Email: Likhonahmed105@gmail.com Password: 123456","","error","
","
Debug Result
","18131","2019-04-13 06:22:58"); INSERT INTO mod_MSG91sms_messages VALUES("92","msg91","8801626690009","Dear Dr Asif , OTP generated for your mobile phone verification is 814324 for Request # DO1pOIX95VMn5bEm7q9M.","","error","
","
Debug Result
","18131","2019-04-15 09:44:37"); INSERT INTO mod_MSG91sms_messages VALUES("93","msg91","8801815044284","Dear Md. Abdul Hannan , payment for due date, 15.04.2019 is done! Thank you.","","error","
","
Debug Result
","18124","2019-04-15 14:55:48"); INSERT INTO mod_MSG91sms_messages VALUES("94","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 30000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561409 +8801815-044284 ","190251","Send","","","18124","2019-04-15 14:55:41"); INSERT INTO mod_MSG91sms_messages VALUES("95","msg91","8801703261707","Hi Mahedi Hasan , Thank you for registering with us. The details of your account are- Email: mh816899@gmail.com Password: 123456","","error","
","
Debug Result
","18132","2019-04-16 08:42:02"); INSERT INTO mod_MSG91sms_messages VALUES("96","msg91","8801712866957","Hi Md. Mahmudul hasan , the payment associated with your account with date 15.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18127","2019-04-16 09:00:06"); INSERT INTO mod_MSG91sms_messages VALUES("97","msg91","8801819117226","Hi Md. Kamal Hoshen , Thank you for registering with us. The details of your account are- Email: no@gfh.vv Password: 123456","","error","
","
Debug Result
","18133","2019-04-16 09:52:29"); INSERT INTO mod_MSG91sms_messages VALUES("98","msg91","8801708488437","Hi Khan Mohammad Asaduzzaman , Thank you for registering with us. The details of your account are- Email: km.asad.zaman@gmail.com Password: 123456","","error","
","
Debug Result
","18134","2019-04-16 12:37:09"); INSERT INTO mod_MSG91sms_messages VALUES("99","msg91","8801793315642","Hi Showkat Heyet , Thank you for registering with us. The details of your account are- Email: ssconsumer2014@gmail.com Password: ","","error","
","
Debug Result
","18135","2019-04-16 13:33:41"); INSERT INTO mod_MSG91sms_messages VALUES("100","msg91","8801793315642","Dear Showkat Heyet , OTP generated for your mobile phone verification is 492924 for Request # X4EaGc5Qq50HrezstxpE.","","error","
","
Debug Result
","18135","2019-04-16 13:35:14"); INSERT INTO mod_MSG91sms_messages VALUES("101","msg91","8801819117226","Dear Md. Kamal Hoshen , OTP generated for your mobile phone verification is 379155 for Request # NZ3clkAjEGBtlvDXa2JC.","","error","
","
Debug Result
","18133","2019-04-16 13:36:00"); INSERT INTO mod_MSG91sms_messages VALUES("102","msg91","8801622222330","Hi Mahmud Ahmmad , Thank you for registering with us. The details of your account are- Email: opal.engineers7@gmail.com Password: ","","error","
","
Debug Result
","18136","2019-04-16 15:40:06"); INSERT INTO mod_MSG91sms_messages VALUES("103","E1brand","+8801836-722508"," tellbd24 f6ImimnX bdNewsClub Dear Md. Arif (Social Trust Development ORG), TK 2000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561314 +8801836-722508 ","190252","Send","","","18119","2019-04-10 18:59:59"); INSERT INTO mod_MSG91sms_messages VALUES("104","msg91","8801836722508","Dear Md. Arif , payment for due date, 15.03.2019 is done! Thank you.","","error","
","
Debug Result
","18119","2019-04-16 19:00:05"); INSERT INTO mod_MSG91sms_messages VALUES("105","msg91","","Hello Md. Ariful islam , Your invoice with id 561523 has been generated. Total amount is 48500.00. The last day of payment is 17.04.2019. Kindly pay your bill before due date to use services without interruption","","error","
","
Debug Result
","18130","2019-04-17 09:45:27"); INSERT INTO mod_MSG91sms_messages VALUES("106","msg91","8801819805109","Hi Sagar Matha , Thank you for registering with us. The details of your account are- Email: sagor08@gmail.com Password: ","","error","
","
Debug Result
","18137","2019-04-17 14:43:26"); INSERT INTO mod_MSG91sms_messages VALUES("107","msg91","8801819805109","Dear Sagar Matha , OTP generated for your mobile phone verification is 492400 for Request # obuOnu5LnSK4mnstM3KQ.","","error","
","
Debug Result
","18137","2019-04-17 14:44:46"); INSERT INTO mod_MSG91sms_messages VALUES("108","msg91","88028332298","Hi Principal , Thank you for registering with us. The details of your account are- Email: info@motijheelmodelschoolandcollege.edu.bd Password: 123456","","error","
","
Debug Result
","18138","2019-04-18 04:55:05"); INSERT INTO mod_MSG91sms_messages VALUES("109","msg91","","Hi Md. Ariful islam , the payment associated with your account with date 17.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18130","2019-04-18 09:00:07"); INSERT INTO mod_MSG91sms_messages VALUES("110","msg91","8801819805109","Hello Sagar Matha , Your invoice with id 561542 has been generated. Total amount is 5650.00. The last day of payment is 18.04.2019. Kindly pay your bill before due date to use services without interruption","","error","
","
Debug Result
","18137","2019-04-18 10:09:06"); INSERT INTO mod_MSG91sms_messages VALUES("111","msg91","8801626690009","Dear Dr Asif , payment for due date, 27.04.2019 is done! Thank you.","","error","
","
Debug Result
","18131","2019-04-18 10:22:21"); INSERT INTO mod_MSG91sms_messages VALUES("112","E1brand","+8801626-690009"," tellbd24 f6ImimnX bdNewsClub Dear Dr Asif (Mosasharaf High School), TK 3600.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561485 +8801626-690009 ","190254","Send","","","18131","2019-04-13 10:22:19"); INSERT INTO mod_MSG91sms_messages VALUES("113","E1brand","+8801819-805109"," tellbd24 f6ImimnX bdNewsClub Dear Sagar Matha , TK 1250.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561542 +8801819-805109 ","190255","Send","","","18137","2019-04-18 15:42:03"); INSERT INTO mod_MSG91sms_messages VALUES("114","msg91","8801819805109","Hi Sagar Matha , the payment associated with your account with date 18.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18137","2019-04-19 09:00:17"); INSERT INTO mod_MSG91sms_messages VALUES("115","msg91","8801710974178","Hi Md. Sabbir Hosen , Thank you for registering with us. The details of your account are- Email: eshaenterprise65@gmail.com Password: 123456","","error","
","
Debug Result
","18139","2019-04-20 12:50:13"); INSERT INTO mod_MSG91sms_messages VALUES("116","msg91","8801710974178","Dear Md. Sabbir Hosen , OTP generated for your mobile phone verification is 091792 for Request # ed1vPl8dmnNTEVvBFeIy.","","error","
","
Debug Result
","18139","2019-04-20 12:50:35"); INSERT INTO mod_MSG91sms_messages VALUES("117","msg91","","","","error","
","
Debug Result
","0","2019-04-20 13:46:54"); INSERT INTO mod_MSG91sms_messages VALUES("118","msg91","8801710974178","Hello Md. Sabbir Hosen , Your invoice with id 561561 has been generated. Total amount is 192500.00. The last day of payment is 30.04.2019. Kindly pay your bill before due date to use services without interruption","","error","
","
Debug Result
","18139","2019-04-20 15:49:48"); INSERT INTO mod_MSG91sms_messages VALUES("119","msg91","8801710974178","Dear Md. Sabbir Hosen , OTP generated for your mobile phone verification is 711385 for Request # APyqv9XAHAgoeEadNqAg.","","error","
","
Debug Result
","18139","2019-04-20 15:55:08"); INSERT INTO mod_MSG91sms_messages VALUES("120","msg91","8801815044284","Hello Md. Abdul Hannan , Your invoice with id 561580 has been generated. Total amount is 69600.00. The last day of payment is 20.04.2019. Kindly pay your bill before due date to use services without interruption","","error","
","
Debug Result
","18124","2019-04-20 17:13:31"); INSERT INTO mod_MSG91sms_messages VALUES("121","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 50000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561580 +8801815-044284 ","190256","Send","","","18124","2019-04-18 17:14:07"); INSERT INTO mod_MSG91sms_messages VALUES("122","msg91","8801819805109","Dear Sagar Matha , OTP generated for your mobile phone verification is 964757 for Request # YTNNJr8lT0SrIh1QZ8sx.","","error","
","
Debug Result
","18137","2019-04-20 18:31:36"); INSERT INTO mod_MSG91sms_messages VALUES("123","msg91","8801819805109","Dear Sagar Matha , payment for due date, 18.04.2019 is done! Thank you.","","error","
","
Debug Result
","18137","2019-04-20 18:34:44"); INSERT INTO mod_MSG91sms_messages VALUES("124","E1brand","+8801819-805109"," tellbd24 f6ImimnX bdNewsClub Dear Sagar Matha , TK 4400.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561542 +8801819-805109 ","190257","Send","","","18137","2019-04-21 18:34:41"); INSERT INTO mod_MSG91sms_messages VALUES("125","msg91","","","","error","
","
Debug Result
","0","2019-04-20 18:35:42"); INSERT INTO mod_MSG91sms_messages VALUES("126","msg91","8801626690009","Dear Dr Asif , OTP generated for your mobile phone verification is 360795 for Request # ecXF9ZRorFaYVs75Jwy2.","","error","
","
Debug Result
","18131","2019-04-20 18:58:40"); INSERT INTO mod_MSG91sms_messages VALUES("127","msg91","8801755551924","Dear Md. Ariful islam , OTP generated for your mobile phone verification is 951700 for Request # 8AiVTTGoBxKSEK5XuJZK.","","error","
","
Debug Result
","18130","2019-04-21 04:23:33"); INSERT INTO mod_MSG91sms_messages VALUES("128","msg91","8801815044284","Hi Md. Abdul Hannan , the payment associated with your account with date 20.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18124","2019-04-21 09:00:17"); INSERT INTO mod_MSG91sms_messages VALUES("129","msg91","8801724549347","Hi Rokonuzzaman Rokon , Thank you for registering with us. The details of your account are- Email: no@gfaah.vv Password: ","","error","
","
Debug Result
","18140","2019-04-21 09:01:50"); INSERT INTO mod_MSG91sms_messages VALUES("130","msg91","8801911712418","Hi Al Masum , Thank you for registering with us. The details of your account are- Email: maksud.alam19@yahoo.com Password: ","","error","
","
Debug Result
","18141","2019-04-21 09:04:52"); INSERT INTO mod_MSG91sms_messages VALUES("131","msg91","8801750090383","Hi Najmul Hudda , Thank you for registering with us. The details of your account are- Email: Najmulhudda20@gmail.com Password: ","","error","
","
Debug Result
","18142","2019-04-21 09:12:52"); INSERT INTO mod_MSG91sms_messages VALUES("132","msg91","","","","error","
","
Debug Result
","0","2019-04-21 10:05:04"); INSERT INTO mod_MSG91sms_messages VALUES("133","E1brand","+8801710-974178"," tellbd24 f6ImimnX bdNewsClub Dear Md. Sabbir Hosen (Esha Enterprice), TK 50000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561561 +8801710-974178 ","190258","Send","","","18139","2019-04-21 13:42:29"); INSERT INTO mod_MSG91sms_messages VALUES("134","msg91","8801710974178","Dear Md. Sabbir Ahmed , OTP generated for your mobile phone verification is 272164 for Request # cPW800Mn2IyfrmRQEPrm.","","error","
","
Debug Result
","18139","2019-04-21 13:43:10"); INSERT INTO mod_MSG91sms_messages VALUES("135","msg91","8801836722508","Hi Md. Arif , The due date for the payment is 30.04.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18119","2019-04-23 09:00:10"); INSERT INTO mod_MSG91sms_messages VALUES("136","msg91","8801710974178","Hi Md. Sabbir Ahmed , The due date for the payment is 30.04.2019. Kindly make the payment for uninterrupted services.","","error","
","
Debug Result
","18139","2019-04-23 09:00:12"); INSERT INTO mod_MSG91sms_messages VALUES("137","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 18500.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561580 +8801815-044284 ","190259","Send","","","18124","2019-04-24 16:32:40"); INSERT INTO mod_MSG91sms_messages VALUES("138","msg91","8801815044284","Dear Md. Abdul Hannan , payment for due date, 20.04.2019 is done! Thank you.","","error","
","
Debug Result
","18124","2019-04-24 16:36:33"); INSERT INTO mod_MSG91sms_messages VALUES("139","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 20000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561580 +8801815-044284 ","190260","Send","","","18124","2019-04-25 16:36:31"); INSERT INTO mod_MSG91sms_messages VALUES("140","msg91","8801836722508","Hi Md. Arif , the payment associated with your account with date 30.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18119","2019-05-01 09:00:12"); INSERT INTO mod_MSG91sms_messages VALUES("141","msg91","8801710974178","Hi Md. Sabbir Ahmed , the payment associated with your account with date 30.04.2019 is not done yet. Kindly make the payment at the earliest to enjoy the services.","","error","
","
Debug Result
","18139","2019-05-01 09:00:13"); INSERT INTO mod_MSG91sms_messages VALUES("142","msg91","8801710974178","Dear Md. Sabbir Ahmed , payment for due date, 30.04.2019 is done! Thank you.","","error","
","
Debug Result
","18139","2019-05-07 06:57:51"); INSERT INTO mod_MSG91sms_messages VALUES("143","E1brand","+8801710-974178"," tellbd24 f6ImimnX bdNewsClub Dear Md. Sabbir Ahmed (Esha Enterprice), TK 130000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561561 +8801710-974178 ","190261","Send","","","18139","2019-05-07 06:57:47"); INSERT INTO mod_MSG91sms_messages VALUES("144","msg91","8801836722508","Dear Md. Arif , OTP generated for your mobile phone verification is 939085 for Request # I40Rqa7LYbyVuFa9Rbgu.","","error","
","
Debug Result
","18119","2019-05-07 07:02:14"); INSERT INTO mod_MSG91sms_messages VALUES("145","msg91","8801815044284","Dear Md. Abdul Hannan , OTP generated for your mobile phone verification is 624176 for Request # b4kqDCTFltKxAmBGBHID.","","error","
","
Debug Result
","18124","2019-05-08 13:19:34"); INSERT INTO mod_MSG91sms_messages VALUES("146","E1brand","+8801815-044284"," tellbd24 f6ImimnX bdNewsClub Dear Md. Abdul Hannan (Amin Enterprice), TK 15000.00 Invoice Payment successful. For More Information See http://e1brand.com/corporate/viewinvoice.php?id=561270 +8801815-044284 ","190262","Send","","","18124","2019-05-06 13:20:11"); DROP TABLE mod_MSG91sms_otp; CREATE TABLE `mod_MSG91sms_otp` ( `id` int(11) NOT NULL AUTO_INCREMENT, `otp` varchar(50) CHARACTER SET utf8 NOT NULL, `type` enum('client','admin') CHARACTER SET utf8 DEFAULT 'client', `relid` int(10) DEFAULT 0, `request` varchar(50) CHARACTER SET utf8 NOT NULL, `text` text DEFAULT NULL, `status` tinyint(1) DEFAULT 0, `datetime` datetime NOT NULL, `phonenumber` text DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE mod_MSG91sms_settings; CREATE TABLE `mod_MSG91sms_settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `api` varchar(40) CHARACTER SET utf8 NOT NULL, `apiparams` varchar(500) CHARACTER SET utf8 NOT NULL, `wantsmsfield` int(11) DEFAULT NULL, `gsmnumberfield` int(11) DEFAULT NULL, `dateformat` varchar(12) CHARACTER SET utf8 DEFAULT NULL, `version` varchar(6) CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; INSERT INTO mod_MSG91sms_settings VALUES("1","msg91","{\"senderid\":\"E1brand\",\"authkey\":\"\",\"signature\":\"\"}","0","0","%d.%m.%y","1.1.3"); DROP TABLE mod_MSG91sms_templates; CREATE TABLE `mod_MSG91sms_templates` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 NOT NULL, `type` enum('client','admin') CHARACTER SET utf8 NOT NULL, `admingsm` varchar(255) CHARACTER SET utf8 NOT NULL, `template` varchar(240) CHARACTER SET utf8 NOT NULL, `variables` varchar(500) CHARACTER SET utf8 NOT NULL, `active` tinyint(1) NOT NULL, `extra` varchar(3) CHARACTER SET utf8 NOT NULL, `description` text CHARACTER SET utf8 DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1; INSERT INTO mod_MSG91sms_templates VALUES("1","AfterRegistrarRenewal","client","","Dear {firstname} {lastname}, Your domain {domain} is successfully renewed.","{firstname},{lastname},{domain}","1","","{\"english\":\"After domain renewal\"}"); INSERT INTO mod_MSG91sms_templates VALUES("2","AdminLogin_admin","admin","","A user with the username {username} has entered the admin panel.","{username}","1","","null"); INSERT INTO mod_MSG91sms_templates VALUES("3","AfterRegistrarRegistrationFailed_admin","admin","","An error occurred while recording the domain {domain}","{domain}","1","","{\"english\":\"When client login.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("4","TicketUserReply_admin","admin","","User has replied on the ticket with the subject ({subject})","{subject}","1","","{\"english\":\"When user has replied on the ticket.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("5","DomainRenewalNotice","client","","Hi {firstname} {lastname}, your domain- {domain} will expire in {x} days i.e. on {expirydate} . Kindly visit site to renew it. Thank You!","{firstname}, {lastname}, {domain},{expirydate},{x}","1","15","{\"english\":\"Domain Renewal Notice before {x} days.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("6","AfterModuleUnsuspend","client",""," Hello! The services for the domain ({domain}) have now been made active.","{firstname},{lastname},{domain}","1","","{\"english\":\"After module unsuspend\"}"); INSERT INTO mod_MSG91sms_templates VALUES("7","TicketClose","client","","Hello {firstname} {lastname}, The ticket with the ticket number ({ticketno}) has been successfully closed. In case of any issue, kindly contact us.","{firstname}, {lastname}, {ticketno}","1","","{\"english\":\"Ticket Closure\"}"); INSERT INTO mod_MSG91sms_templates VALUES("8","ClientAdd_admin","admin","","New customer has been added to the website.","","1","","{\"english\":\"When client is added.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("9","AfterRegistrarRegistration_admin","admin","","New domain named {domain} have been registered.","{domain}","1","","{\"english\":\"When domain registered.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("10","ClientChangePassword","client","","Hi {firstname} {lastname}, password has been changed successfully.","{firstname},{lastname}","1","","{\"english\":\"After client change password\"}"); INSERT INTO mod_MSG91sms_templates VALUES("11","InvoicePaid","client","","Dear {firstname} {lastname}, payment for due date, {duedate} is done! Thank you.","{firstname}, {lastname}, {duedate},{invoiceid}","1","","{\"english\":\"Post Payment\"}"); INSERT INTO mod_MSG91sms_templates VALUES("12","AfterRegistrarRenewal_admin","admin","","The domain name {domain} has been renewed.","{domain}","1","","{\"english\":\"When domain is renewed.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("13","InvoiceCreated","client","","Hello {firstname} {lastname}, Your invoice with id {invoiceid} has been generated. Total amount is {total}. The last day of payment is {duedate}. Kindly pay your bill before due date to use services without interruption","{firstname}, {lastname}, {duedate}, {total}, {invoiceid}","1","","{\"english\":\"After Invoice Creation\"}"); INSERT INTO mod_MSG91sms_templates VALUES("14","AfterModuleCreate_Hosting","client","","Hello! The services for the domain ({domain}) have now been made active . The login details for the accounts are- Username:{username} Password: {password}","{firstname}, {lastname}, {domain}, {username}, {password}","1","","{\"english\":\"Post Service Activation\"}"); INSERT INTO mod_MSG91sms_templates VALUES("15","TicketOpen_admin","admin","","A new ticket with the subject ({subject}) has been created.","{subject}","1","","{\"english\":\"When new ticket is created.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("16","AfterRegistrarRegistration","client","","Hi {firstname} {lastname}, Entries in the name field for the domain name ({domain}) have been successfully made.","{firstname},{lastname},{domain}","1","","{\"english\":\"After Domain Registration\"}"); INSERT INTO mod_MSG91sms_templates VALUES("17","InvoicePaymentReminder_secondoverdue","client","","Hi {firstname} {lastname}, the payment for date {duedate}, associated with your is due. Kindly make the payment at the earliest to enjoy the services.","{firstname}, {lastname}, {duedate}","1","","{\"english\":\"Invoice payment reminder for second overdue\"}"); INSERT INTO mod_MSG91sms_templates VALUES("18","AfterModuleSuspend","client","","Hi {firstname} {lastname}, The service for your account associated with the domain ({domain}) has been paused. Kindly contact us for more details.","{firstname},{lastname},{domain}","1","","{\"english\":\"After Module Suspension\"}"); INSERT INTO mod_MSG91sms_templates VALUES("19","InvoicePaymentReminder_Firstoverdue","client","","Hi {firstname} {lastname}, the payment associated with your account with date {duedate} is not done yet. Kindly make the payment at the earliest to enjoy the services.","{firstname}, {lastname}, {duedate}","1","","{\"english\":\"Invoice payment reminder for first overdue\"}"); INSERT INTO mod_MSG91sms_templates VALUES("20","InvoicePaymentReminder_thirdoverdue","client","","Hi {firstname} {lastname}, the payment for date {duedate}, associated with your is due. Kindly make the payment at the earliest to enjoy the services.","{firstname}, {lastname}, {duedate}","1","","{\"english\":\"Invoice payment reminder for third overdue\"}"); INSERT INTO mod_MSG91sms_templates VALUES("21","ClientAreaRegister_clientarea","client","","Dear {firstname} {lastname}, OTP generated for your mobile phone verification is {otp} for Request # {request}.","{firstname},{lastname},{otp},{request}","1","","{\"english\":\"After Client Registration (OTP) Mobile Verification\"}"); INSERT INTO mod_MSG91sms_templates VALUES("22","InvoicePaymentReminder_Reminder","client","","Hi {firstname} {lastname}, The due date for the payment is {duedate}. Kindly make the payment for uninterrupted services.","{firstname}, {lastname}, {duedate}","1","","{\"english\":\"Invoice Payment Reminder\"}"); INSERT INTO mod_MSG91sms_templates VALUES("23","AfterModuleChangePassword","client","","Hi {firstname} {lastname}, password for the {domain} has been changed successfully. Here are the details- Username: {username} Password: {password}","{firstname}, {lastname}, {domain}, {username}, {password}","1","","{\"english\":\"After module password changed\"}"); INSERT INTO mod_MSG91sms_templates VALUES("24","TicketAdminReply","client","","Dear {firstname} {lastname}, ({ticketsubject}) has been responded by admin.","{firstname}, {lastname}, {ticketsubject}","1","","{\"english\":\"After Reply By Admin\"}"); INSERT INTO mod_MSG91sms_templates VALUES("25","AfterModuleChangePackage","client","","Hello {firstname} {lastname}, The product/service package for your domain {domain} is changed. Kindly contact us for more details","{firstname},{lastname},{domain}","1","","{\"english\":\"Following Module Package Change\"}"); INSERT INTO mod_MSG91sms_templates VALUES("26","ClientLogin_admin","admin","","Client with the name- ({firstname} {lastname} made entrance to the site.","{firstname},{lastname}","1","","{\"english\":\"When client login.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("27","AfterRegistrarRegistrationFailed","client","","Hi {firstname} {lastname}, Your domain name could not be registered.","{firstname},{lastname},{domain}","1","","{\"english\":\"Domain Registration Failure\"}"); INSERT INTO mod_MSG91sms_templates VALUES("28","AcceptOrder_SMS","client","","Dear {firstname} {lastname}, Your order associated with the ID {orderid} has been approved.","{firstname},{lastname},{orderid}","1","","{\"english\":\"Post Order Acceptance\"}"); INSERT INTO mod_MSG91sms_templates VALUES("29","AfterRegistrarRenewalFailed_admin","admin","","An error occurred while updating the domain {domain}","{domain}","1","","{\"english\":\"When domain registration failed.\"}"); INSERT INTO mod_MSG91sms_templates VALUES("30","ClientAdd","client","","Hi {firstname} {lastname}, Thank you for registering with us. The details of your account are- Email: {email} Password: {password}","{firstname},{lastname},{email},{password}","1","","{\"english\":\"After Client Registration\"}"); INSERT INTO mod_MSG91sms_templates VALUES("31","ClientEdit_clientarea","client","","Dear {firstname} {lastname}, OTP generated for your mobile phone verification is {otp} for Request # {request}.","{firstname},{lastname},{otp},{request}","1","","{\"english\":\"After Client Edit (OTP) Mobile Verification\"}"); DROP TABLE mod_account_summary_configuration; CREATE TABLE `mod_account_summary_configuration` ( `setting` text COLLATE utf8_unicode_ci DEFAULT NULL, `value` text COLLATE utf8_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO mod_account_summary_configuration VALUES("PDFPaperSize","A4","2019-02-01 02:24:44","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("TCPDFFont","helvetica","2019-02-01 02:24:44","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("TCPDFCoustomFont","","2019-02-01 02:24:44","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("EnablePDFInvoices","on","2019-02-01 02:24:44","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("PDFInvoiceType","all","2019-02-01 02:24:44","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("EnableAutoStatement","on","2019-02-01 02:31:54","2019-04-02 05:51:03"); INSERT INTO mod_account_summary_configuration VALUES("IncludeUnpaidInvoices","on","2019-02-01 02:31:54","2019-04-02 05:51:03"); DROP TABLE mod_account_summary_pdf; CREATE TABLE `mod_account_summary_pdf` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `userid` int(11) NOT NULL, `title` text COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO mod_account_summary_pdf VALUES("1","1","Account_Summary_1_2019-02-01_02-26-05.pdf"); INSERT INTO mod_account_summary_pdf VALUES("2","18117","Account_Summary_18117_2019-05-05_11-55-02.pdf"); INSERT INTO mod_account_summary_pdf VALUES("3","18115","Account_Summary_18115_2019-05-06_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("4","18119","Account_Summary_18119_2019-05-08_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("5","18120","Account_Summary_18120_2019-05-10_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("6","18121","Account_Summary_18121_2019-05-11_04-45-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("7","18131","Account_Summary_18131_2019-04-13_11-55-10.pdf"); INSERT INTO mod_account_summary_pdf VALUES("8","18139","Account_Summary_18139_2019-04-20_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("9","2","Account_Summary_2_2019-04-22_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("10","18124","Account_Summary_18124_2019-04-26_11-55-03.pdf"); INSERT INTO mod_account_summary_pdf VALUES("11","18127","Account_Summary_18127_2019-05-01_11-55-05.pdf"); DROP TABLE mod_invoicedata; CREATE TABLE `mod_invoicedata` ( `invoiceid` int(10) NOT NULL, `clientsdetails` text COLLATE utf8_unicode_ci NOT NULL, `customfields` text COLLATE utf8_unicode_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO mod_invoicedata VALUES("561270","{\"userid\":18124,\"id\":18124,\"uuid\":\"947f9f2d-9ed8-45a3-8398-aa4384c94ef2\",\"firstname\":\"Md. Abdul Hannan\",\"lastname\":\"\",\"fullname\":\"Md. Abdul Hannan \",\"companyname\":\"Amin Enterprice\",\"email\":\"aminen107@gmail.com\",\"address1\":\"GPO\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1815044284\",\"password\":\"$2y$10$chBvNj\\/rEkApFRAKkUchA.D3ZKx.hWTgUGDKP0T1aabIQWZRT7F0K\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1815044284\",\"telephoneNumber\":\"+880.1815044284\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"Date: 26\\/12\\/2018 17:04
IP Address: 103.248.236.1
Host: 103.248.236.1\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561271","{\"userid\":18124,\"id\":18124,\"uuid\":\"947f9f2d-9ed8-45a3-8398-aa4384c94ef2\",\"firstname\":\"Md. Abdul Hannan\",\"lastname\":\"\",\"fullname\":\"Md. Abdul Hannan \",\"companyname\":\"Amin Enterprice\",\"email\":\"aminen107@gmail.com\",\"address1\":\"GPO\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1815044284\",\"password\":\"$2y$10$chBvNj\\/rEkApFRAKkUchA.D3ZKx.hWTgUGDKP0T1aabIQWZRT7F0K\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1815044284\",\"telephoneNumber\":\"+880.1815044284\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"Date: 26\\/12\\/2018 17:04
IP Address: 103.248.236.1
Host: 103.248.236.1\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561272","{\"userid\":18124,\"id\":18124,\"uuid\":\"947f9f2d-9ed8-45a3-8398-aa4384c94ef2\",\"firstname\":\"Md. Abdul Hannan\",\"lastname\":\"\",\"fullname\":\"Md. Abdul Hannan \",\"companyname\":\"Amin Enterprice\",\"email\":\"aminen107@gmail.com\",\"address1\":\"GPO\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1815044284\",\"password\":\"$2y$10$chBvNj\\/rEkApFRAKkUchA.D3ZKx.hWTgUGDKP0T1aabIQWZRT7F0K\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1815044284\",\"telephoneNumber\":\"+880.1815044284\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"Date: 26\\/12\\/2018 17:04
IP Address: 103.248.236.1
Host: 103.248.236.1\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561273","{\"userid\":18117,\"id\":18117,\"uuid\":\"78cb7c78-daf0-44af-b47b-1f1e91aed351\",\"firstname\":\"Md. Tareq\",\"lastname\":\"\",\"fullname\":\"Md. Tareq \",\"companyname\":\"indesk\",\"email\":\"indesk.bd@gmail.com\",\"address1\":\"Arambag\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1922332421\",\"password\":\"d112a2cbee77a622f706e0a086277aa6:Pcwey\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1922332421\",\"telephoneNumber\":\"+880.1922332421\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"46690.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561274","{\"userid\":18117,\"id\":18117,\"uuid\":\"78cb7c78-daf0-44af-b47b-1f1e91aed351\",\"firstname\":\"Md. Tareq\",\"lastname\":\"\",\"fullname\":\"Md. Tareq \",\"companyname\":\"indesk\",\"email\":\"indesk.bd@gmail.com\",\"address1\":\"Arambag\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1922332421\",\"password\":\"d112a2cbee77a622f706e0a086277aa6:Pcwey\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1922332421\",\"telephoneNumber\":\"+880.1922332421\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"46690.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561275","{\"userid\":18119,\"id\":18119,\"uuid\":\"8b9a169f-96dd-467b-81d7-5f4b05086410\",\"firstname\":\"Md. Arif\",\"lastname\":\"\",\"fullname\":\"Md. Arif \",\"companyname\":\"Social Trust Development ORG\",\"email\":\"tsdo8811@gmail.com\",\"address1\":\"62\\/63c ,Amin Cort Vabon\",\"address2\":\"Motijoil\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1836722508\",\"password\":\"8a431bffbe371265df31412e7bb174d3:UiT#S\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1836722508\",\"telephoneNumber\":\"+880.1836722508\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561276","{\"userid\":1,\"id\":1,\"uuid\":\"477521b1-eb17-4dff-b974-3803ad50d8fb\",\"firstname\":\"Md. Tajul\",\"lastname\":\"islam\",\"fullname\":\"Md. Tajul islam\",\"companyname\":\"Tellbd\",\"email\":\"riyadh1bd@gmail.com\",\"address1\":\"\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1818917810\",\"password\":\"2b05cf3405696947df0ab05ee8e78f8c:P%FJX\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1818917810\",\"telephoneNumber\":\"+880.1818917810\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":0,\"status\":\"Active\",\"credit\":\"177.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561295","{\"userid\":1,\"id\":1,\"uuid\":\"477521b1-eb17-4dff-b974-3803ad50d8fb\",\"firstname\":\"Md. Tajul\",\"lastname\":\"islam\",\"fullname\":\"Md. Tajul islam\",\"companyname\":\"Tellbd\",\"email\":\"riyadh1bd@gmail.com\",\"address1\":\"\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1818917810\",\"password\":\"2b05cf3405696947df0ab05ee8e78f8c:P%FJX\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1818917810\",\"telephoneNumber\":\"+880.1818917810\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":0,\"status\":\"Active\",\"credit\":\"177.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561314","{\"userid\":18119,\"id\":18119,\"uuid\":\"8b9a169f-96dd-467b-81d7-5f4b05086410\",\"firstname\":\"Md. Arif\",\"lastname\":\"\",\"fullname\":\"Md. Arif \",\"companyname\":\"Social Trust Development ORG\",\"email\":\"tsdo8811@gmail.com\",\"address1\":\"62\\/63c ,Amin Cort Vabon, L-7\",\"address2\":\"Motijoil\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1836722508\",\"password\":\"8a431bffbe371265df31412e7bb174d3:UiT#S\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1836722508\",\"telephoneNumber\":\"+880.1836722508\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561333","{\"userid\":18126,\"id\":18126,\"uuid\":\"f428659b-e083-486f-b55c-cddbe5a30724\",\"firstname\":\"Secretary general, administration department\",\"lastname\":\"\",\"fullname\":\"Secretary general, administration department \",\"companyname\":\"Ministry of Shipping\",\"email\":\"nom@gdh.vv\",\"address1\":\"Bangladesh Secretariat\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"dhaka\",\"state\":\"dhaka\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"\",\"password\":\"$2y$10$iK8XYKU1PIsQYVCXObQJ4eRUo3Nb\\/bsDsmEUiQv7oiMtTq8OU6PTK\",\"statecode\":\"dhaka\",\"countryname\":\"Bangladesh\",\"phonecc\":880,\"phonenumberformatted\":\"\",\"telephoneNumber\":\"\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561352","{\"userid\":18126,\"id\":18126,\"uuid\":\"f428659b-e083-486f-b55c-cddbe5a30724\",\"firstname\":\"Secretary general\",\"lastname\":\"Administration Department\",\"fullname\":\"Secretary general Administration Department\",\"companyname\":\"Ministry of Shipping\",\"email\":\"nom@gdh.vv\",\"address1\":\"Bangladesh Secretariat\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"dhaka\",\"state\":\"dhaka\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"\",\"password\":\"$2y$10$iK8XYKU1PIsQYVCXObQJ4eRUo3Nb\\/bsDsmEUiQv7oiMtTq8OU6PTK\",\"statecode\":\"dhaka\",\"countryname\":\"Bangladesh\",\"phonecc\":880,\"phonenumberformatted\":\"\",\"telephoneNumber\":\"\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561371","{\"userid\":18117,\"id\":18117,\"uuid\":\"78cb7c78-daf0-44af-b47b-1f1e91aed351\",\"firstname\":\"Md. Tareq\",\"lastname\":\"\",\"fullname\":\"Md. Tareq \",\"companyname\":\"indesk\",\"email\":\"indesk.bd@gmail.com\",\"address1\":\"Arambag\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1922332421\",\"password\":\"d112a2cbee77a622f706e0a086277aa6:Pcwey\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1922332421\",\"telephoneNumber\":\"+880.1922332421\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"46690.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561390","{\"userid\":2,\"id\":2,\"uuid\":\"e21c97d0-512d-4256-9859-56cbb6eb3498\",\"firstname\":\"Md. salauddin\",\"lastname\":\"Sahin\",\"fullname\":\"Md. salauddin Sahin\",\"companyname\":\"Al-Shifa Medical Services LTD\",\"email\":\"alshifa.dhaka@gmail.com\",\"address1\":\"22 East Madartek\",\"address2\":\"Sobujbag\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1214\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1701665700\",\"password\":\"49b7af8488de47d5888fe4707d7ca555:e%pK(\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1701665700\",\"telephoneNumber\":\"+880.1701665700\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":0,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561409","{\"userid\":18124,\"id\":18124,\"uuid\":\"947f9f2d-9ed8-45a3-8398-aa4384c94ef2\",\"firstname\":\"Md. Abdul Hannan\",\"lastname\":\"\",\"fullname\":\"Md. Abdul Hannan \",\"companyname\":\"Amin Enterprice\",\"email\":\"aminen107@gmail.com\",\"address1\":\"GPO\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1815044284\",\"password\":\"$2y$10$chBvNj\\/rEkApFRAKkUchA.D3ZKx.hWTgUGDKP0T1aabIQWZRT7F0K\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1815044284\",\"telephoneNumber\":\"+880.1815044284\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"Date: 26\\/12\\/2018 17:04
IP Address: 103.248.236.1
Host: 103.248.236.1\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561428","{\"userid\":18127,\"id\":18127,\"uuid\":\"859c3b5a-9c39-4771-a940-dfa0e7a49e43\",\"firstname\":\"Md. Mahmudul hasan\",\"lastname\":\"\",\"fullname\":\"Md. Mahmudul hasan \",\"companyname\":\"MS. L R Traders Ltd.\",\"email\":\"Mahamadulhasan1978@gmail.com\",\"address1\":\"New 60\\/E (3rd floor), Dewan Monzil\",\"address2\":\"56, purana Paltan\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1712866957\",\"password\":\"$2y$10$ieZe0utbtuFpBPxuGw6QyOjDo6Y8AVyAii1p.izl0rJgEGghS\\/qTS\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1712866957\",\"telephoneNumber\":\"+880.1712866957\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"+88029550941\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"+88029550941\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561447","{\"userid\":18117,\"id\":18117,\"uuid\":\"78cb7c78-daf0-44af-b47b-1f1e91aed351\",\"firstname\":\"Md. Tareq\",\"lastname\":\"\",\"fullname\":\"Md. Tareq \",\"companyname\":\"indesk\",\"email\":\"indesk.bd@gmail.com\",\"address1\":\"Arambag\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1922332421\",\"password\":\"d112a2cbee77a622f706e0a086277aa6:Pcwey\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1922332421\",\"telephoneNumber\":\"+880.1922332421\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"46690.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561466","{\"userid\":18117,\"id\":18117,\"uuid\":\"78cb7c78-daf0-44af-b47b-1f1e91aed351\",\"firstname\":\"Md. Tareq\",\"lastname\":\"\",\"fullname\":\"Md. Tareq \",\"companyname\":\"indesk\",\"email\":\"indesk.bd@gmail.com\",\"address1\":\"Arambag\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1922332421\",\"password\":\"d112a2cbee77a622f706e0a086277aa6:Pcwey\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1922332421\",\"telephoneNumber\":\"+880.1922332421\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"46690.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561485","{\"userid\":18131,\"id\":18131,\"uuid\":\"d670522a-a535-44e9-8488-513dd3209f25\",\"firstname\":\"Dr Asif\",\"lastname\":\"\",\"fullname\":\"Dr Asif \",\"companyname\":\"\",\"email\":\"Likhonahmed105@gmail.com\",\"address1\":\"Road 1 (at the end of Road 1) Mosasharaf High School\",\"address2\":\"Sector 10, Uttara\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1626690009\",\"password\":\"$2y$10$ua4tk0oO8FHrWHuQ1HdrU.7dBEAcbkl98yHuPZTGioxoeTLWDYwv.\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1626690009\",\"telephoneNumber\":\"+880.1626690009\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":0,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561504","{\"userid\":18119,\"id\":18119,\"uuid\":\"8b9a169f-96dd-467b-81d7-5f4b05086410\",\"firstname\":\"Md. Arif\",\"lastname\":\"\",\"fullname\":\"Md. Arif \",\"companyname\":\"Social Trust Development ORG\",\"email\":\"tsdo8811@gmail.com\",\"address1\":\"62\\/63c ,Amin Cort Vabon, L-7\",\"address2\":\"Motijoil\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1836722508\",\"password\":\"8a431bffbe371265df31412e7bb174d3:UiT#S\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1836722508\",\"telephoneNumber\":\"+880.1836722508\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":1,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":true,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"},{\"id\":4,\"value\":\"<\\/a>\"},{\"id\":5,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\",\"customfields4\":\"<\\/a>\",\"customfields5\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561523","{\"userid\":18130,\"id\":18130,\"uuid\":\"ea9305ef-1ceb-483f-a272-d5b0eb63481a\",\"firstname\":\"Md. Ariful islam\",\"lastname\":\"\",\"fullname\":\"Md. Ariful islam \",\"companyname\":\"BIWTA\",\"email\":\"ariful.islam@tvsl-bd.com\",\"address1\":\"BIWTA\",\"address2\":\"Motijhil\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"\",\"password\":\"$2y$10$Wdlizt3S7TGUhmMutZFPF.QsRbeHkjhchrOt0t2aYAddcGkmp6hJO\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":880,\"phonenumberformatted\":\"\",\"telephoneNumber\":\"\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":0,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"},{\"id\":4,\"value\":\"<\\/a>\"},{\"id\":5,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\",\"customfields4\":\"<\\/a>\",\"customfields5\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561542","{\"userid\":18137,\"id\":18137,\"uuid\":\"80336c50-010f-496d-a044-2863d6f19584\",\"firstname\":\"Sagar Matha\",\"lastname\":\"\",\"fullname\":\"Sagar Matha \",\"companyname\":\"\",\"email\":\"sagor08@gmail.com\",\"address1\":\"160 Elephant Road\",\"address2\":\"Hatirpool\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1819805109\",\"password\":\"$2y$10$wHaaE5B8z0THqAJj\\/bXcFuD3iWkgW01bdusFw43gfB2KmUhUmm2gq\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1819805109\",\"telephoneNumber\":\"+880.1819805109\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":8,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"},{\"id\":4,\"value\":\"<\\/a>\"},{\"id\":5,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\",\"customfields4\":\"<\\/a>\",\"customfields5\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561561","{\"userid\":18139,\"id\":18139,\"uuid\":\"5cc8ba67-0fc7-4b09-b2b7-d3bb9f12b77c\",\"firstname\":\"Md. Sabbir Hosen\",\"lastname\":\"\",\"fullname\":\"Md. Sabbir Hosen \",\"companyname\":\"Esha Enterprice\",\"email\":\"eshaenterprise65@gmail.com\",\"address1\":\"16\\/2, Ruhul Amin Electric Market\",\"address2\":\"Kazi abdul hanid lan, Noabpur\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1710974178\",\"password\":\"$2y$10$8W4f2inO83l28XL2ds24N.dEUSV60hG3foFKMwhG\\/yWLdGen.xgLm\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1710974178\",\"telephoneNumber\":\"+880.1710974178\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":7,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"No Login Logged\",\"customfields1\":\"01916631012\",\"customfields\":[{\"id\":1,\"value\":\"01916631012\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"},{\"id\":4,\"value\":\"<\\/a>\"},{\"id\":5,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\",\"customfields4\":\"<\\/a>\",\"customfields5\":\"\"}","[]"); INSERT INTO mod_invoicedata VALUES("561580","{\"userid\":18124,\"id\":18124,\"uuid\":\"947f9f2d-9ed8-45a3-8398-aa4384c94ef2\",\"firstname\":\"Md. Abdul Hannan\",\"lastname\":\"\",\"fullname\":\"Md. Abdul Hannan \",\"companyname\":\"Amin Enterprice\",\"email\":\"aminen107@gmail.com\",\"address1\":\"GPO\",\"address2\":\"\",\"city\":\"Dhaka\",\"fullstate\":\"\",\"state\":\"\",\"postcode\":\"1000\",\"countrycode\":\"BD\",\"country\":\"BD\",\"phonenumber\":\"1815044284\",\"password\":\"$2y$10$chBvNj\\/rEkApFRAKkUchA.D3ZKx.hWTgUGDKP0T1aabIQWZRT7F0K\",\"statecode\":\"\",\"countryname\":\"Bangladesh\",\"phonecc\":\"880\",\"phonenumberformatted\":\"+880.1815044284\",\"telephoneNumber\":\"+880.1815044284\",\"billingcid\":0,\"notes\":\"\",\"twofaenabled\":false,\"currency\":1,\"defaultgateway\":\"cashPay\",\"cctype\":\"\",\"cclastfour\":\"\",\"gatewayid\":\"\",\"securityqid\":0,\"securityqans\":\"\",\"groupid\":5,\"status\":\"Active\",\"credit\":\"0.00\",\"taxexempt\":false,\"latefeeoveride\":false,\"overideduenotices\":false,\"separateinvoices\":false,\"disableautocc\":false,\"emailoptout\":false,\"overrideautoclose\":false,\"allowSingleSignOn\":1,\"language\":\"\",\"lastlogin\":\"Date: 26\\/12\\/2018 17:04
IP Address: 103.248.236.1
Host: 103.248.236.1\",\"customfields1\":\"\",\"customfields\":[{\"id\":1,\"value\":\"\"},{\"id\":2,\"value\":\"\"},{\"id\":3,\"value\":\"\"},{\"id\":4,\"value\":\"<\\/a>\"},{\"id\":5,\"value\":\"\"}],\"customfields2\":\"\",\"customfields3\":\"\",\"customfields4\":\"<\\/a>\",\"customfields5\":\"\"}","[]"); DROP TABLE mod_onlinenic; CREATE TABLE `mod_onlinenic` ( `id` int(10) NOT NULL AUTO_INCREMENT, `domain` varchar(255) NOT NULL, `lockstatus` tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY `domainid` (`domain`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; DROP TABLE mod_project; CREATE TABLE `mod_project` ( `id` int(10) NOT NULL AUTO_INCREMENT, `userid` int(10) NOT NULL, `title` text NOT NULL, `ticketids` text NOT NULL, `invoiceids` text NOT NULL, `notes` text NOT NULL, `adminid` int(10) NOT NULL, `status` varchar(255) NOT NULL, `created` date NOT NULL, `duedate` date NOT NULL, `completed` int(1) NOT NULL, `lastmodified` datetime NOT NULL, `watchers` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=190132 DEFAULT CHARSET=latin1; INSERT INTO mod_project VALUES("190127","18116","Matarbari","","561248","","1","In Progress","2018-12-01","2019-01-31","1","2019-01-27 19:36:34",""); INSERT INTO mod_project VALUES("190128","18121","Saldah Eco Resort - Gazipur","","561239,561262,561263,561264,561265","","1","In Progress","2018-10-14","2019-02-28","1","2019-01-28 05:37:14",""); INSERT INTO mod_project VALUES("190129","18127","Mohammadpur Office","","561428","","0","Pending","2019-04-01","2019-04-01","0","2019-04-01 18:56:20",""); INSERT INTO mod_project VALUES("190130","18139","Room interior decoration of Chairman Sir at Motijheel Model School and College.","","561561","","0","In Progress","2019-04-20","2019-04-30","1","2019-04-20 15:56:06",""); INSERT INTO mod_project VALUES("190131","18124","File - Amin Enterprise","","","","0","Pending","2019-04-24","2020-04-24","0","2019-04-24 16:46:56",""); DROP TABLE mod_project_management_files; CREATE TABLE `mod_project_management_files` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `project_id` int(10) unsigned NOT NULL, `message_id` int(10) unsigned NOT NULL, `filename` varchar(256) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `admin_id` int(10) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; INSERT INTO mod_project_management_files VALUES("1","190128","0","943425_img20190210_20583302.pdf","1","2019-02-10 14:59:02","2019-02-10 14:59:02"); INSERT INTO mod_project_management_files VALUES("2","190129","0","874741_img20190401_23275431.pdf","1","2019-04-01 18:56:31","2019-04-01 18:56:31"); INSERT INTO mod_project_management_files VALUES("3","190130","0","512952_img20190420_19495973.pdf","1","2019-04-20 15:47:52","2019-04-20 15:47:52"); INSERT INTO mod_project_management_files VALUES("4","190131","0","704465_img20190424_22355366.pdf","1","2019-04-24 16:47:16","2019-04-24 16:47:16"); DROP TABLE mod_projectlog; CREATE TABLE `mod_projectlog` ( `id` int(255) NOT NULL AUTO_INCREMENT, `projectid` int(11) NOT NULL, `date` datetime NOT NULL, `msg` varchar(255) NOT NULL, `adminid` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1; INSERT INTO mod_projectlog VALUES("1","1","2019-01-27 19:32:37","Created Project","1"); INSERT INTO mod_projectlog VALUES("2","1","2019-01-27 19:36:34","Invoice Associated: Invoice #561248","1"); INSERT INTO mod_projectlog VALUES("3","2","2019-01-28 04:23:48","Created Project","1"); INSERT INTO mod_projectlog VALUES("4","190128","2019-01-28 04:26:52","Invoice Associated: Invoice #561239","1"); INSERT INTO mod_projectlog VALUES("5","190128","2019-01-28 04:42:49","Invoice Created: Invoice #561262","1"); INSERT INTO mod_projectlog VALUES("6","190128","2019-01-28 05:37:08","Invoice Associated: Invoice #561263","1"); INSERT INTO mod_projectlog VALUES("7","190128","2019-01-28 05:37:11","Invoice Associated: Invoice #561264","1"); INSERT INTO mod_projectlog VALUES("8","190128","2019-01-28 05:37:14","Invoice Associated: Invoice #561265","1"); INSERT INTO mod_projectlog VALUES("9","190128","2019-02-10 14:59:02","File Uploaded: img20190210_20583302.pdf","1"); INSERT INTO mod_projectlog VALUES("10","190129","2019-04-01 18:55:53","Created Project","1"); INSERT INTO mod_projectlog VALUES("11","190129","2019-04-01 18:56:20","Invoice Associated: Invoice #561428","1"); INSERT INTO mod_projectlog VALUES("12","190129","2019-04-01 18:56:31","File Uploaded: img20190401_23275431.pdf","1"); INSERT INTO mod_projectlog VALUES("13","190130","2019-04-20 15:47:05","Created Project","1"); INSERT INTO mod_projectlog VALUES("14","190130","2019-04-20 15:47:52","File Uploaded: img20190420_19495973.pdf","1"); INSERT INTO mod_projectlog VALUES("15","190130","2019-04-20 15:55:39","Invoice Associated: Invoice #561561","1"); INSERT INTO mod_projectlog VALUES("16","190131","2019-04-24 16:46:56","Created Project","1"); INSERT INTO mod_projectlog VALUES("17","190131","2019-04-24 16:47:16","File Uploaded: img20190424_22355366.pdf","1"); DROP TABLE mod_projectmessages; CREATE TABLE `mod_projectmessages` ( `id` int(10) NOT NULL AUTO_INCREMENT, `projectid` int(10) NOT NULL, `date` datetime NOT NULL, `message` text NOT NULL, `adminid` int(10) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;