INSERT INTO `blog_posts` (`blog_id`, `blog_category`, `blog_title`, `blog_content`, `posted_by`, `post_thumb`, `post_image`, `status`, `date_posted`, `post_link`) VALUES
(38, '', 'Vice Presidents Say on Current Floods', '<div>\r\n  <div dir=\"auto\">\r\n    <div>\r\n      <div dir=\"auto\"><a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZYAxfYVc5nePp45CiMdUshhYWgBMVdFSUyYCZy9ziGuRnERc9D9umouCSRiO6icHdvLmMa6B40hMF-TTVqgtGEc25cyAcHGfiQ569WQ-jrmkxQosxFqc96jFFEvI6LElPtpPLHhaPivSKmB1ArqQ5YAEVCWt3xXoo874H0-DacCcGM4z1qyy406Kvn_HtLqdZa0TGw_nlf86pLxP1QNjFpg5wS6QwmkR007qy0ciqE8tsVXJQ8z5RWxyuUdh9zu0xNJ2NgrSjKaBgxBNyPYKUkzfUi1d9FZbPnMpjX9KDsfi2VjZoZbF9mPWBo-7_ZIpz7k3jAyEK7JOt4FZKo8LN40vCC6INTETlc5qOt6juiRMSGVGyTY3SqcEbgTP71Ko3BfieiIEVp4HO5UC77X_10jqhguYv4FA9sVyPwUgjB6C9raFOyfda-wno1luFFTD4u78Q_IvtAXSWFU37gRbw9bIv8wLZz6V_wNbrJV0pgj7Jwu-oqKyiUZrnilFNOcJAKld6VCb6Ya3d3G493ZPkTfGmxvbSLKZynxyJndhEvNRsXQgR5V5Ju1oYWFrbAtVCVtx_8yRp5mNOm0fPnfmHIminS527obVGK-Ojs2pkFyCQ82s7dr7enAZeWkRCQU1mRR10lgDTSUYtW201hQJo9rduSc26VBefB-1wq5CoJhHLJuvOOaAA9d9gG8_nrT5wrzielGEPKnJsG9eAEwGwQPSvG7zQic1Isu5GvOD8aKpjubFMuKcZfHapkUm9cVPpOHSaBMUN8Lft633oyJMUyMdfT3H_TY8JzhQ5lkKc5PYtlmkLCcRTo4aWSP4rhrhCGK2BWwtd1B5SD8mwC3jwfjZynzMLWbwNNOKp5y85bhl7aamlu58jSlP3ODux4Dd3jpF0n9f-KOgGOrT9OfBdt0T3r8L6ArolgF2CAlnQHjNfJfzPJnzrwGHCYHjY0cHniNRi60DRRNK41npZNAQTCMBSgJuq_CaVlYJj8JKELKj9Avfe_mIFyYRqDoLGvigWe_ODO8MxMWkJOgomRiadjML4W90kjHDHWqwcSAO3z9uoKD7hMAkBOsOFvwdGDW7NLiBmYn0ovBmYkCEeNhPAmAxxcEMmkVrme9BDDfCyx7mhNSX-phw04OK7mVHz_fCsGabG72Wn-HKzjwsnExi0XX-nrz2x5yBe4i4n7BbD-F5FG2QVwohb5kynjXpBT-RJ4PVNKLEtvVqYJa5_YquUND6qdiLN6KSIQ4ebzQ1Q8yt_QTvxSC3znNMDjFhkQtFt4Q30q2YRKUYVhTi184ERW169HR6uUGgGS2OQ1-kgNyB4AGTMh9fDrPTWcY-kPS1JoyWfUTnNKNvoAPep_2rZMj\" href=\"https://web.facebook.com/hashtag/zbsnews?__eep__=6&amp;__cft__[0]=AZb8H7HYkZ7v-uxkSK7ddM6IhorSMnH1ucBZR4JE5RBj82Q6lfJATFvsTZyDYWxDFE6QM9jcooHbd4T1H6WZgjOqtpcgwen3L_BU8LXe14IDoePU9cVkjK1aQbF_FWBIxVnILduH3M-saroFappoB8Z2F1XnAWh3mRjWR-7RR4jCdvDwFIOjgGT2yobbxGcwUcc&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#ZBSNews</a> </div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\"><a tabindex=\"-1\"></a>Vice-President, Dr Jane Mayemu Ansah, says government has strengthened contingency measures as heavy rains continue to devastate the country, affecting more than 42,000 people in over 9,300 households, with four people dead and 101 injured.</div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\">In a Facebook post, Dr Ansah said relief supplies have been moved closer to high-risk areas, rescue teams placed on standby, and public awareness campaigns intensified to reduce the impact of floods.</div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\">She said the situation remains serious, with homes, roads and crops damaged, and livestock swept away in several districts.</div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\">The Vice-President added that the Department of Disaster Management Affairs is coordinating response efforts, organising rescues, setting up emergency centres, and working closely with security agencies in affected communities.</div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\">Dr Ansah has urged citizens and development partners to follow weather advisories and support affected families, stressing that effective disaster response requires collective action.</div>\r\n    </div>\r\n    <div>\r\n      <div dir=\"auto\">(by Chisomo Chingwalu – Lilongwe: 12/31/25) <a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZYAxfYVc5nePp45CiMdUshhYWgBMVdFSUyYCZy9ziGuRnERc9D9umouCSRiO6icHdvLmMa6B40hMF-TTVqgtGEc25cyAcHGfiQ569WQ-jrmkxQosxFqc96jFFEvI6LElPtpPLHhaPivSKmB1ArqQ5YAEVCWt3xXoo874H0-DacCcGM4z1qyy406Kvn_HtLqdZa0TGw_nlf86pLxP1QNjFpg5wS6QwmkR007qy0ciqE8tsVXJQ8z5RWxyuUdh9zu0xNJ2NgrSjKaBgxBNyPYKUkzfUi1d9FZbPnMpjX9KDsfi2VjZoZbF9mPWBo-7_ZIpz7k3jAyEK7JOt4FZKo8LN40vCC6INTETlc5qOt6juiRMSGVGyTY3SqcEbgTP71Ko3BfieiIEVp4HO5UC77X_10jqhguYv4FA9sVyPwUgjB6C9raFOyfda-wno1luFFTD4u78Q_IvtAXSWFU37gRbw9bIv8wLZz6V_wNbrJV0pgj7Jwu-oqKyiUZrnilFNOcJAKld6VCb6Ya3d3G493ZPkTfGmxvbSLKZynxyJndhEvNRsXQgR5V5Ju1oYWFrbAtVCVtx_8yRp5mNOm0fPnfmHIminS527obVGK-Ojs2pkFyCQ82s7dr7enAZeWkRCQU1mRR10lgDTSUYtW201hQJo9rduSc26VBefB-1wq5CoJhHLJuvOOaAA9d9gG8_nrT5wrzielGEPKnJsG9eAEwGwQPSvG7zQic1Isu5GvOD8aKpjubFMuKcZfHapkUm9cVPpOHSaBMUN8Lft633oyJMUyMdfT3H_TY8JzhQ5lkKc5PYtlmkLCcRTo4aWSP4rhrhCGK2BWwtd1B5SD8mwC3jwfjZynzMLWbwNNOKp5y85bhl7aamlu58jSlP3ODux4Dd3jpF0n9f-KOgGOrT9OfBdt0T3r8L6ArolgF2CAlnQHjNfJfzPJnzrwGHCYHjY0cHniNRi60DRRNK41npZNAQTCMBSgJuq_CaVlYJj8JKELKj9Avfe_mIFyYRqDoLGvigWe_ODO8MxMWkJOgomRiadjML4W90kjHDHWqwcSAO3z9uoKD7hMAkBOsOFvwdGDW7NLiBmYn0ovBmYkCEeNhPAmAxxcEMmkVrme9BDDfCyx7mhNSX-phw04OK7mVHz_fCsGabG72Wn-HKzjwsnExi0XX-nrz2x5yBe4i4n7BbD-F5FG2QVwohb5kynjXpBT-RJ4PVNKLEtvVqYJa5_YquUND6qdiLN6KSIQ4ebzQ1Q8yt_QTvxSC3znNMDjFhkQtFt4Q30q2YRKUYVhTi184ERW169HR6uUGgGS2OQ1-kgNyB4AGTMh9fDrPTWcY-kPS1JoyWfUTnNKNvoAPep_2rZMj\" href=\"https://web.facebook.com/hashtag/malawismostfollowedpage?__eep__=6&amp;__cft__[0]=AZb8H7HYkZ7v-uxkSK7ddM6IhorSMnH1ucBZR4JE5RBj82Q6lfJATFvsTZyDYWxDFE6QM9jcooHbd4T1H6WZgjOqtpcgwen3L_BU8LXe14IDoePU9cVkjK1aQbF_FWBIxVnILduH3M-saroFappoB8Z2F1XnAWh3mRjWR-7RR4jCdvDwFIOjgGT2yobbxGcwUcc&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#malawismostfollowedpage</a></div>\r\n    </div>\r\n\r\n    <br /></div>\r\n</div>', 34, '251231071721_1111.jpg', '251231071721_1111.jpg', 1, '2025-12-31 19:17:21', '4Cn3IQ5'),
(39, '11', 'Effect of Current Heavy Rain', '<div>\r\n  <div dir=\"auto\"><a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZbWEIyGDOyyQZgvAAosj5TqMJaTjd3uH_eDWzrh-QOEhxttFDw-8olHXDuQ_y1-IcSQnTBE6ZvexWdT_H-Idt5HCkqHLe6OnaM-H8En1p39ucbZriJ9fZYMLmI7umrE1EkdMyUTcVotUJ22WbeHezQBs1rQ7uBVNiELpL03MVmIJavUiuRQ38Nq5UwG3q8nhksC3AKGd6e4T8ZQl9NiBbyxQ6QwN6vEvKAI4hKcKy2m1nQLgrdQrTL0_K55S7wUKYTk5lEJihuOgLBn5X-1NoEkJYT9QCMhTWCTWIiUM0G7nZYANtmyglpHrjavXV0_W1gjgiwtE3e4HIX3rj2zsM81EmJSzZJhPOWwxLDzQ5QIae2f8hsf18pdabmWfP8ms2FNMXEYZe7Qy59AIAYwhbHcqcKO3iBm2I3GhxVTxZWHSoQUOLRl-UW5tV9EAHMGQM6t6xFlYQXYcPle1wV8RhaL35ZcRyYTQzEIfU0KddhpN8ftPXMK5c6CuR-7SIqWGzWBMZqcmiY0cMG7YfMaj6-tLKdHBXWqj0iUJYkzEzC-_ZUQhfSzcEv7TnH1Humsi-LFpqf9Srf6-CJZ4cV0JPLuM_xdQqOSs5RVCLrNd4VvXTq7emOcY05U-4yDOIVS3D2FdMRpfgeES80PfumbRYqlVccKe9Z4q35PpjaJ49AyJtK1awI-TP9uOns5EPgLk0q_YJP1pkfDitSL05ZPGAKK8gwxWemBemDQG0_M5pOEFhdYHjXlYo5BSvtPos43PQwh5xpwnYJUarJudH-x_je8d2dIfbKZLYS1geLs160HaKWO7jnk_xUYLSJIekhKUDcCw6281TpaZBkZby1sQXNFqBu9RSpm62wmr4v4ie28I5DTCTZtgyt5_4lkbs52J_GfUAGEJCzS2cigxzRnCXj6KSGq3_puZqIrixPYtklILuOJ2JC9zAuDjCiNG-pxdykx2qlB9ioBiGiBRrOpE9_2SMra7LIVKrOxNj93DhFOyA_Q4xK5QrwC5T5aR4imXRqza4T2uK_W4AI3LOgkK26lSthh9ggMqNwavmYRZ8T55vqokNKDqz-FqLX8b6VDofx9n-CZXmiqH-n8xgoEmqNiNq9GLsdSG6oQJrAunxlcgrlB4noJtBRkMGOqXNA9tz-ULSFqqb0H-bSsUCE25zPzm6UOVNwlG81dI51ZkExQiuGiEmn1WKjKfdj6G8OwG7IGEraArp-I6CWZ2OSUrIFao1Z6pUPQ_4o2hlikySQZNuRycGHtEcmAOQR-XK7rB3yojg9dhJfqElY7bV1GMCP1qxxs8dWjeUSY2axaYnwW_R3l1U5GYFbdfjuNRL09OMd0JIkIRD3CmyuUdJ9iU6oiyVgMH9D2P2VOw9CbhDTBfzFSoo49v4XFFcUqlhrMhq5bA4-IfsgWVGCWAaVbu_HYsU4ZFVlqtxUgvVNdA9KTCg\" href=\"https://web.facebook.com/hashtag/zbsnews?__eep__=6&amp;__cft__[0]=AZatMuZZK3Q_DwRXOLenrq_SdwiIZ6EilobLauidDBxR58jSeBd3WzYyQWwvQKV2bSyDgYSsFUQD3OYwjUtm8eEUhDrXzSWHCjJsMxxTRA6FW048HeKHnVnnM30kSGUfLa3f_nl-IHL3L3geZcMBRjcezT2hCFY9Qh6tz2CxyVkQXSJa_49aHO0NBQ7bRYSB3DE&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#ZBSNews</a></div>\r\n  <div dir=\"auto\">The Malawi Engineering Institution has called for a review of bridge design, construction management, and environmental oversight after heavy rains and floods caused widespread damage to roads and bridges. </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Its CEO, Engineer Arthur Wengawenga, says the extreme weather exposed the limits of current infrastructure. </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">“Several bridges could not handle the volume of water, leading to significant destruction,” Wengawenga explained. </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">He warned that climate change is increasing rainfall intensity, noting that Kasungu Station may have recorded such heavy rainfall for the first time in years. </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Wengawenga has also blamed environmental degradation upstream, including deforestation, which worsens runoff and amplifies flood damage to roads and bridges. </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">(by Chisomo Chingwalu-Lilongwe: 12/31/25)</div>\r\n  <div dir=\"auto\"><a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZbWEIyGDOyyQZgvAAosj5TqMJaTjd3uH_eDWzrh-QOEhxttFDw-8olHXDuQ_y1-IcSQnTBE6ZvexWdT_H-Idt5HCkqHLe6OnaM-H8En1p39ucbZriJ9fZYMLmI7umrE1EkdMyUTcVotUJ22WbeHezQBs1rQ7uBVNiELpL03MVmIJavUiuRQ38Nq5UwG3q8nhksC3AKGd6e4T8ZQl9NiBbyxQ6QwN6vEvKAI4hKcKy2m1nQLgrdQrTL0_K55S7wUKYTk5lEJihuOgLBn5X-1NoEkJYT9QCMhTWCTWIiUM0G7nZYANtmyglpHrjavXV0_W1gjgiwtE3e4HIX3rj2zsM81EmJSzZJhPOWwxLDzQ5QIae2f8hsf18pdabmWfP8ms2FNMXEYZe7Qy59AIAYwhbHcqcKO3iBm2I3GhxVTxZWHSoQUOLRl-UW5tV9EAHMGQM6t6xFlYQXYcPle1wV8RhaL35ZcRyYTQzEIfU0KddhpN8ftPXMK5c6CuR-7SIqWGzWBMZqcmiY0cMG7YfMaj6-tLKdHBXWqj0iUJYkzEzC-_ZUQhfSzcEv7TnH1Humsi-LFpqf9Srf6-CJZ4cV0JPLuM_xdQqOSs5RVCLrNd4VvXTq7emOcY05U-4yDOIVS3D2FdMRpfgeES80PfumbRYqlVccKe9Z4q35PpjaJ49AyJtK1awI-TP9uOns5EPgLk0q_YJP1pkfDitSL05ZPGAKK8gwxWemBemDQG0_M5pOEFhdYHjXlYo5BSvtPos43PQwh5xpwnYJUarJudH-x_je8d2dIfbKZLYS1geLs160HaKWO7jnk_xUYLSJIekhKUDcCw6281TpaZBkZby1sQXNFqBu9RSpm62wmr4v4ie28I5DTCTZtgyt5_4lkbs52J_GfUAGEJCzS2cigxzRnCXj6KSGq3_puZqIrixPYtklILuOJ2JC9zAuDjCiNG-pxdykx2qlB9ioBiGiBRrOpE9_2SMra7LIVKrOxNj93DhFOyA_Q4xK5QrwC5T5aR4imXRqza4T2uK_W4AI3LOgkK26lSthh9ggMqNwavmYRZ8T55vqokNKDqz-FqLX8b6VDofx9n-CZXmiqH-n8xgoEmqNiNq9GLsdSG6oQJrAunxlcgrlB4noJtBRkMGOqXNA9tz-ULSFqqb0H-bSsUCE25zPzm6UOVNwlG81dI51ZkExQiuGiEmn1WKjKfdj6G8OwG7IGEraArp-I6CWZ2OSUrIFao1Z6pUPQ_4o2hlikySQZNuRycGHtEcmAOQR-XK7rB3yojg9dhJfqElY7bV1GMCP1qxxs8dWjeUSY2axaYnwW_R3l1U5GYFbdfjuNRL09OMd0JIkIRD3CmyuUdJ9iU6oiyVgMH9D2P2VOw9CbhDTBfzFSoo49v4XFFcUqlhrMhq5bA4-IfsgWVGCWAaVbu_HYsU4ZFVlqtxUgvVNdA9KTCg\" href=\"https://web.facebook.com/hashtag/malawismostfollowedpage?__eep__=6&amp;__cft__[0]=AZatMuZZK3Q_DwRXOLenrq_SdwiIZ6EilobLauidDBxR58jSeBd3WzYyQWwvQKV2bSyDgYSsFUQD3OYwjUtm8eEUhDrXzSWHCjJsMxxTRA6FW048HeKHnVnnM30kSGUfLa3f_nl-IHL3L3geZcMBRjcezT2hCFY9Qh6tz2CxyVkQXSJa_49aHO0NBQ7bRYSB3DE&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#malawismostfollowedpage</a></div>\r\n</div>\r\n\r\n<p><br /></p>', 34, '251231072602_3333.jpg', '251231072602_2222.jpg', 1, '2025-12-31 19:26:02', 'kEh6Q4zqsS9fqmbleXGLi8QfdCq30yEO'),
(40, '11', 'Summary of Disasters Following Incessant Rains', '<p data-start=\"0\" data-end=\"533\">The Department of Disaster Management Affairs (DoDMA) reports that between 22nd and 30th December 2025, Malawi experienced widespread disasters following incessant rains, which affected a total of 9,143 households across the country. During this period, 101 people were injured, 4 lives were lost, and 354 people were successfully rescued, while no persons were reported missing. This shows that although the impacts were serious, emergency response and rescue efforts helped prevent further loss of life.</p>\r\n<p data-start=\"535\" data-end=\"951\">The majority of the affected households were impacted by stormy rains, which accounted for 8,191 households, making it the most significant hazard during this period. Heavy rains affected 521 households, while flooding impacted 426 households. Overall, rainfall-related hazards were the main drivers of destruction, with stormy conditions causing the greatest damage to homes and livelihoods.</p>\r\n<p data-start=\"953\" data-end=\"1633\">In terms of geographic distribution, the Southern Region was the most affected. Nsanje District recorded the highest number of affected households at 2,549, followed by Chikwawa with 1,913. Other heavily affected districts included Karonga (1,031), Dedza (711), Chiradzulu (597), and Blantyre (516). Moderate impacts were reported in Dowa, Nkhotakota, Likoma, Lilongwe, and Mulanje, while lower numbers were recorded in Zomba City, Kasungu, Lilongwe City, Chitipa, Nkhata Bay, and Salima. The spatial pattern confirms that flood- and storm-prone areas, especially in southern Malawi, remain highly vulnerable to extreme rainfall events.</p>\r\n<p data-start=\"1635\" data-end=\"1966\" data-is-last-node=\"\" data-is-only-node=\"\">Overall, the information highlights the continued exposure of communities to climate-related disasters in Malawi and underscores the importance of strengthening early warning systems, community preparedness, and disaster risk reduction measures, particularly in districts that are repeatedly affected by heavy and stormy rains.</p>\r\n\r\n<p><br /></p>', 34, '251231073858_44444.jpg', '251231073858_44444.jpg', 1, '2025-12-31 19:38:58', 'ucmJqYFTorZStCZOBBd00L3JezboVViDeoiGADz'),
(41, '11', 'MDF Joins Flood Rescue Efforts in Nkhotakota', '<div>\r\n  <div dir=\"auto\"><a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZY7I0dRdvPizpKlWXDAV4qymXNJYVdpwIRy2SCJCqTLNgvP2sdvPmvdLa1tCO5LgXZxAMR29Y6M0vkbMDf016UKr5q4mB50MK_iwEuScvBxI9b8Z7gaRaRfC47T2-Z8_MWWwmZWREXjJWZGHdgtb_WJz1KHPl6dUcyi9O2rjXa_bCZIhxavCwnK9tzHd-Tn-J6aagS2U2UHJj-_yRJriuJeTcbhqkkqwfbbJe5MdlAReKYEb1crIjUaJsAfLuDSH7KpOou96DPs4Nx58yYzvaFKzQE9ILReaS-NMWoXgx7oi5KlNEQxzDxT7l9fmZ3RcIczPAZrWJCDXTdS50hpRchooYg4o3ISBJqzrC7CXAkru0OSL6EthxceiDnIIcbHlKa00rUMPwIEqZAhAphe30UPKD7pWnVfj4zOX8cDnCsoU2i5iNilPwVsOcl6pnI-Y2g6f_sb1zc68j9cq54aAiv1rqQMGuG9XKSHLr0ODjSOYeWqOA7vol9oRKJP5MiCwM07L-fHR9q_WqxffGVZt6N1MYiR55MUze90bapgaxFrf5JgX-8h1xfb0EtT5Qmz-7k4q1LRXUJZGsNt18dHjc1QNwbPLeZe3XsDNY9Gg_o7n_DeOYfUrEQ0NYGfTCsxAwTxcNmR1dYGNer5clCYFiiz7mbY9-_Y88gCjNpdDsbPtK7VucOeGIztAEagtsmbUEutUtpugDMJ2PlcyQjXu2jUGtc2SmUhDyxCnOAAqLWllYxkEa5t5JvDibyzmaZomVciVM52Kqu8gy1UHlUHjY4As_Xz9gggmkEQH6EUv_zJnkU52cDE0ZV6yNzWEZbvQUu2hPCT0jg7jA_8dUYNi4bR0V2hj0NUP3m0rgw5PW0OXiINuEHMrYlehgNGTzISQksyEk5bR_kEe8Rl_rIz3UcZOfiCPp1Wvh0CGe3tp_wJHIEbn0VHTsJ0qr3buUR5t8KfI1j8AGT7venwyAtA_mdEJKbQbKYbeQSDLaf_8An_zvvHd-_psN6gvPEWvw1cV7UWg0C1ZR7JX7BCoHAvFipTZgiS3xTVkNJp37VVUYNn_y54TuX7eEWyrB09VSwiexkqGNNRAwL_L9iZWrsXYBmy-ddRarmDoxmQgWEUWuvWh1VhtzwPcHRcw-peqejIRNakNb-WhFFnLzR9NbEz-wi6eTpFqLV6knOiiowLfYHJcpnsY9OO4j0m9LOvurCmJ2HLmdXZDJF9WGEC96iYg-L04YGSZzHNW5ri9JBoQ3JZcKaqtBDQ_Wkx3ZYl-LIv1UJsvwCm6XwEszFIgpihGyBQLpC6tMH35y6_jOmE0UwGUuq2NVuvT6AdsHSSwG7yCJq03Ut4OEfDgMRrx3jwony_ul3bsBfE0NjCa9pzd2PsxtMAQMYaunuUV5-WwGgGew3SWfTMTYyJ4lWN9KRvySHQCXvEQALWnTp-81SxFGU2UA\" href=\"https://web.facebook.com/hashtag/times360malawi?__eep__=6&amp;__cft__[0]=AZb02nnK9o5AezgbqqrY2nErTcie8Bi6qhJ2dlraHEZGvaTW1G4dSBcCE129YR8vxhF6Ja5OhD0Ayom-4s4yyCisy-wSZJ7c3qkoIMfLD3PxeKXJ3ykEnKhjhoKcu1-arUW8mgBNKwBidWUfr21nSdC8pHup3ucfVQ99n0xW-wDBNNiFXa6cBxkqV-o39nnDAsk&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#Times360Malawi</a></div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><a tabindex=\"-1\"></a>The Malawi Defence Force (MDF) has stepped up rescue and evacuation operations in Nkhotakota District following five consecutive days of heavy rainfall that triggered widespread flooding.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Nkhotakota District Council Spokesperson, Wongani Mkandawire, said the soldiers have been deployed to work alongside disaster response teams from the Department of Disaster Management Affairs (DoDMA) to support emergency rescue efforts in the worst-hit areas.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">He said the MDF’s involvement is aimed at reinforcing evacuation operations and ensuring that affected residents are safely relocated to designated evacuation camps.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Mkandawire said preliminary assessments indicate that about 30,000 people have been affected by the floods, while five people including a pregnant woman are still missing in Dwangwa, under the jurisdiction of Senior Chief Kanyenda.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Reported Innocent Chunga</div>\r\n</div>\r\n\r\n<p><br /></p>', 34, '260102115953_66666.jpg', '260102115953_77777.jpg', 1, '2026-01-02 11:59:53', 'NNvbI'),
(43, '11', 'Destructive Hailstorm Leaves Trail of Damage in T/A Mwabulambya', '<div>\r\n  <div dir=\"auto\"><a attributionsrc=\"/privacy_sandbox/comet/register/source/?xt=AZaJWAO6mSfTMKfqgI6OkMly0s_kISU4RGwzPz2JqmiqORG5o-Bxni1A7-fN5RFMrkUPp0LGCfz95ZjTvbeexNas4mlWq4X_Qtzh9aEaR8-UqJVFakR4wXFfW5J2bcTQfmNk3kiV2jzOp_A9yfbMa03xS16ESfxf0IIIpOLLCKPs--M32d73qJ2jl4XxDggmJTntNMD2Cqeg9yKiCmjttzvLvdqigu9d9pIA4IOj2rISCfZR6NjazS3UddHj33za06Zpbno4Is5tHMakrRd7EAAsZRhXxV8JaWlmE_ZQyNq6JyhaTvlEFHKMbU10MYjbdXmb7NblhpQ5gsoul2J2sO4S9LEBvqsKW3fUYN7sOGztFKja8iIA7--4vl7lCO3C0RSTQfVnoOLF_Qu8oqm2L8At3TX46v5d69LDIEi9NK_PHqD1SKYuK0JXrr__DDRlC73PQAAo6v7ksoQiXMCCl43AmS3eLMrUloDWwE1HuRIf0Y62YIGFtcrPv4qjn0I-5AmPlmvANt6ognnxSR1ZO1bDi_aZZkVWbaVfzCYrL1SSA0xd8ZchzAkn-Ixp6MkCkH-TfgAc3vqfkg4SNnKM-_9EADy39ZOyc7wKnYJBNgKSDvUiodBZNGrdi46EyycXzjR8yY9nKUrt8aBiPq--4Pewpo4-Xzqv6OeUwMjcbTOBktzGNOzBXkdHT-k6pzUbonRC3b0sCVvXLFs3t7iA5ZrgGqnJcv_wVhwGupC-vncRiO7cnudXKkrvvao8z3X3feumPT163FmzE0P_UbeSk8gvQd6SkxTOC8WiYvGEjQuLJofTxDAjN3aZxdKMnxq9zmILqNWH9BuYLgqGmd4LzkCD4UISOttz67aDmR-rmpkjWH6Ywipxg9KSBno2YSA_-tiD44OdyOSaHWgdhLO1AE6r9FoevnwOaNIt9zzvKL78xCjBfZUaFsWG_hJZAKtmJxxC9v7NOLDKsFQt91FJpkotOoyJWfjpJOlUDNzzMp6V9GkvENJZN0ljTR3uj3w9kvEvzG4ZL-GgK-FxKK-jgJ59tAOcHutiawwe5H4VNfpVs0rnBor90cBJcyj9CsKtQoW4vaivDnaJIdVZ_jAyaVOxEMB6pJUV8WvWzGJFypEBzcqYZlH4hzVle7NF4hhqXgYpBYiACP-wDZDqAwGhsJc1eBKhrhpL69P2j1jqpB9gXbOO1k1M_5hOOpTv7o6WFtrfWZfJ_egmTBMOc0La-EvQhjCKVwpEzZbvTsCDLaFnqrX3dnof_6K13pPqbTZsEpxTD2-szJLzDkzWIU6gpJEu-5mvJ9eeKW5X6W4RndRHGpiDFeN-RYqlw-I0UyWqVLC2WomswsY4FSZ7Eu900ZcOYGEtfMyLQFIzUIoV0gIX0sS1B59Gb51p6CHyfl1kYgkvnxPgBqfgU0rIPoJKnW9vDKiBXWbyuOxQ7LyNUCi1fsA7cGahFZYVjuZZVjU8SRQ\" href=\"https://web.facebook.com/hashtag/times360malawi?__eep__=6&amp;__cft__[0]=AZYdhweEUw_27zZMzfbyF6ukp2HSyuT3QW4NVJyyk6MmEl0EignSi2IERh8zugO3vMoNk2yMPtcgd1IVO5qfdwjtP3CxfUTPy5YbCJNEHc0yqVVqF44XcLu31JXIlnEfINS3PnamQNRgo3dsh8s3WAjXhzka_vhlj8QGD9Nr_K3LZlvcSweEFpURyicjK7isPr8&amp;__tn__=*NK-R\" role=\"link\" tabindex=\"0\" style=\"list-style-type: none;\">#Times360Malawi</a> </div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">A <a tabindex=\"-1\"></a>hailstorm that struck Traditional Authority Mwabulambya in Chitipa District on January 2, 2026, around 3pm has affected 23 households and one church in seven villages: Stanford, Laban, Mweningala, Alufeyo, Namwalika, James and Henry.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Chitipa District Council PRO Aliko Munde said some houses had roofs blown off while others partially collapsed, while the Pentecostal Holiness Church completely collapsed. One 78 year old woman sustained injuries, and farmland growing maize, beans and soya was destroyed.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Munde said the affected households urgently need assistance in the form of food, shelter and agricultural inputs, and appealed to the corporate world and other well-wishers to support the victims as they recover from the disaster.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Vinjeru Betera Mkandawire</div>\r\n</div>\r\n\r\n<p><br /></p>', 34, '260104113329_8888.jpg', '260104113329_9999.jpg', 1, '2026-01-04 23:33:29', 'AwEWr3NCr28cBuW8tmvRTfskok1tP6WBit6evYQ'),
(44, '11', 'UPDATE ON DISASTERS AND RESPONSE OPERATIONS', '<p data-start=\"0\" data-end=\"435\">The Department of Disaster Management Affairs (DoDMA) reports that during the 2025/26 rainy season, Malawi has been affected by stormy rains, strong winds, flash floods, and lightning. These hazards have impacted 36,283 households, representing about 163,274 people, across 29 districts. As a result, 40 people lost their lives and 209 were injured, mainly due to lightning strikes and collapsing walls.</p>\r\n<p data-start=\"437\" data-end=\"782\">Flooding alone affected 1,912 households and displaced 2,132 people, who were sheltered in 14 temporary camps. By 19 January 2026, DoDMA had successfully closed 13 of the 14 camps and supported affected families with return-home packages, including food and basic household items. One camp in Nkhata Bay remains open.</p>\r\n<p data-start=\"784\" data-end=\"1113\" data-is-last-node=\"\" data-is-only-node=\"\">To respond to the disasters, K8.6 billion has been mobilized for relief and recovery efforts, but there is still a funding gap of K4 billion. DoDMA is therefore appealing to donors, organizations, and individuals to provide additional support to help restore services, prevent further impacts, and support early recovery</p>\r\n\r\n<p><br /></p>', 34, '260126052958_121212121212121212.jpg', '260126052958_121212121212121212.jpg', 1, '2026-01-26 17:29:58', 'x3VEysGTPQ5fSeF0gDkhxf9y5nm1aosC5ZjAkkrKFIpFfkxuoc'),
(45, '11', 'Chinese Chamber of Commerce Donates maize worth K80 million and K20 million Cash', '<div>\r\n  <div dir=\"auto\">The Chinese community plying their businesses in the country under the banner Chinese Chamber of Commerce on Thursday 22nd January, 2026, donated maize worth K80 million and cash amounting to K20 million towards the 2025-26 Lean Season Food Insecurity Response Programme.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Speaking at Capital Hill, Lilongwe during a symbolic handover ceremony, Chinese Chambers of Commerce’s Chairperson Zhou Shanjian said they felt compelled to make the donation.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">“This [Malawi] is our second home. We hope that the donation will continue restoring hope to vulnerable communities affected by food insecurity,” said Shanjian.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">In his appreciation speech, Chief Secretary in the Office of the President and Cabinet Dr. Justin Adack Saidi said the gesture is an act of responsibility, solidarity and oneness towards the provision of assistance to households affected by food insecurity.</div>\r\n</div>\r\n\r\n<p><br /></p>', 34, '260126053630_131313131313131313.jpg', '260126053630_14141414141414.jpg.jpg', 1, '2026-01-26 17:36:30', 'XBsJ6Plw7Bdko7G5vFkFxOLHzQhZCEx4NEo'),
(46, '11', 'Zimbabwe Donates Assorted Relief Items to Malawi', '<div>\r\n  <div dir=\"auto\">“INSEPARABLE TWINS”</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">…Zimbabwe Donates Assorted Relief Items to Malawi</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">…“This is a demonstration of goodwill and solidarity,”-Chaponda</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">“Zimbabwe and Malawi are inseparable twins and the former’s shoulder is always available for the latter to lean on in her time of need,” said Dr. Nancy Saungweme, Zimbabwe Ambassador to Malawi.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">She made the remarks at Capital Hill, Lilongwe when her Government donated assorted relief items that include 300 tons of red sorghum, 800kgs of mealie-mill, 280kgs of sugar, 144 litres of cooking oil, 322 cabin tents and 697 blankets.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">She quoted President Emmerson Mnagwagwa’s remarks, stressing that in times of adversity, the spirit of Pan-African solidarity must guide people’s actions.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">In his remarks, Minister of Foreign Affairs and International Cooperation Dr. George Thapatula Chaponda described the gesture as a deep of relief.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">“We are deeply grateful for this demonstration of goodwill and solidarity which will be remembered as a testament to the strong bonds of our bilateral relations. On behalf of the State President H.E. Prof. Arthur Peter Mutharika and the people of Malawi, kindly extend our heartfelt gratitude to H.E Comrade Dr. Emmerson Dambudzo Mnangagwa and the people of Zimbabwe,” said Chaponda.</div>\r\n</div>\r\n\r\n<p><br /></p>', 35, '260129090150_620026979_1206202291704222_5600150379910019643_n.jpg', '260129090150_622949355_1206201808370937_221573478448841241_n..jpg', 1, '2026-01-29 09:01:50', 'X851'),
(47, '11', 'Information on Tropical Storm Fytia', '<p data-start=\"140\" data-end=\"636\">The Department of Climate Change and Meteorological Services (DCCMS) issued an update on Tropical Storm Fytia on 30 January 2026 at 12:00. The storm developed in the Mozambique Channel and, at the time of the report, was located at 15.7° South, 47.2° East, with a central pressure of 987 hPa and moving east–south-east at 24 knots (about 44 km/h). According to the forecast track, the storm was expected to move towards landfall in Madagascar within the next 24 hours.</p>\r\n<p data-start=\"638\" data-end=\"854\">DCCMS indicated that Tropical Storm Fytia was not expected to have a direct impact on Malawi’s weather, but the department committed to continue monitoring the situation and provide updates if conditions changed.</p>\r\n<p data-start=\"856\" data-end=\"1115\">However, the bulletin warned that localized heavy rainfall would still likely occur over central, northern, and parts of lakeshore areas of Malawi over the next three days, while conditions in the southern areas were expected to remain mostly dry</p>\r\n\r\n<p><br /></p>', 34, '260131092900_623367064_1209289658048099_5091167717726718092_n.jpg', '260131092900_623367064_1209289658048099_5091167717726718092_n.jpg', 1, '2026-01-31 21:29:00', 'T9kXWaBA0hjHJPUygYhxyMnXvIRVnyW5P2h'),
(48, '11', 'DRY SPELL ADVISORY FOR SOUTHERN MALAWI', '<div>\r\n  <div dir=\"auto\">Issued: 31/01/2026</div>\r\n  <div dir=\"auto\">Valid: Next 7 days</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Situation Overview</div>\r\n  <div dir=\"auto\">The southern areas of Malawi have experienced a prolonged dry spell over the past week or more. Current weather analysis and forecast indicate that these conditions are likely to persist over the next 7 days.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">Areas Most Affected</div>\r\n  <div dir=\"auto\">• Category 9: Chikwawa, Nsanje, Blantyre, Thyolo, Mwanza, Neno, Zomba, Pha-lombe, Mulanje, Balaka, Machinga, Mangochi, Salima, Dedza, Ntcheu </div>\r\n  <div dir=\"auto\">• Category 4: Parts of Lilongwe, Mchinji, Dowa and Ntchisi.</div>\r\n</div>\r\n\r\n<p><br /></p>', 34, '260131093653_624779037_1209805781329820_3170629057910721708_n.jpg', '260131093653_624779037_1209805781329820_3170629057910721708_n.jpg', 1, '2026-01-31 21:36:53', 'EX1oaGE1Un1RwaBSULmsps4bmMFLbFtTZA4jpshiG3IjWFXNS6H');

-- --------------------------------------------------------

--
-- Table structure for table `drm_projects`
--

CREATE TABLE `drm_projects` (
  `newsletter_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `file` varchar(128) NOT NULL,
  `link` varchar(60) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `drm_projects`
--

INSERT INTO `drm_projects` (`newsletter_id`, `title`, `file`, `link`, `posted_by`, `date`) VALUES
(43, 'DRM NATIONAL ', '250424034346_DRM NATIONAL .pdf', 'T7oxYKiUVkwFO2cW4hojAlAATUj1apOsrcNq6eXH1W06nLqTdfh', 44, '2025-04-24 15:43:46'),
(44, 'YY', '250424034358_YY.pdf', 'SXcbaGzTPZ4', 44, '2025-04-24 15:43:58'),
(45, 'National 1', '250424061234_National 1.pdf', '7ubrFByiH2WA0YD0KWh1BrQu7U8HWRaLwI3cotQPlTG', 44, '2025-04-24 18:12:34'),
(46, 'NATO', '250424061906_NATO.pdf', 'MfGAZq1lsk7X4DgQmlB996IQatBzW23UyoiD2fBnl8hwHj5CvUszaav', 44, '2025-04-24 18:19:06');

-- --------------------------------------------------------

--
-- Table structure for table `drm_publications`
--

CREATE TABLE `drm_publications` (
  `report_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `file` varchar(128) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `drm_publications`
--

INSERT INTO `drm_publications` (`report_id`, `title`, `file`, `date`) VALUES
(20, 'DRM iNTERNATIONAL', '250424035536_DRM iNTERNATIONAL.pdf', '2025-04-24 15:55:36'),
(21, 'International 1', '250424061315_International 1.pdf', '2025-04-24 18:13:15'),
(23, 'yyyyy', '250424082646_yyyyy.pdf', '2025-04-24 20:26:46'),
(24, 'ttttoooooooooooo', '250424082806_ttttoooooooooooo.pdf', '2025-04-24 20:28:06'),
(25, 'ttttoooooooooooo', '250424082938_ttttoooooooooooo.pdf', '2025-04-24 20:29:38'),
(26, '88888 ppppp', '250424082958_88888 ppppp.pdf', '2025-04-24 20:29:58');

-- --------------------------------------------------------

--
-- Table structure for table `drm_reports`
--

CREATE TABLE `drm_reports` (
  `newsletter_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `file` varchar(128) NOT NULL,
  `link` varchar(60) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `event_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `venue` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `thumb` varchar(128) NOT NULL,
  `image` varchar(128) NOT NULL,
  `details` longtext NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date_posted` timestamp NOT NULL DEFAULT current_timestamp(),
  `posted_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`event_id`, `title`, `venue`, `date`, `thumb`, `image`, `details`, `status`, `date_posted`, `posted_by`) VALUES
(12, 'WARNING ON MWERA WINDS 12TH MAY TO 15TH MAY 2025', 'Lakeshore Areas', '2025-05-10', '250510031450_DCCMS.jpg', '250510031450_DCCMS.jpg', '<p>???<br />The Department of Climate Change and Meteorological Services would like to warn the Malawi nation that Mwera winds are expected blow on Lake Malawi and other lake water bodies from Monday night 12th May 2025 with a speed of more than<br />50 km/h. High water waves of more than 2 meters in height. These winds are expected to subside by Thursday 15th May 2025.</p>\r\n<p>Consequently, we are also likely to experience Chiperoni weather, which is associated with rainy, windy, cloudy, and chilly conditions, including fog patches over many areas beginning from the southern Malawi progressing northwards.</p>\r\n<p>WhatsApp: <a href=\"https://whatsapp.com/channel/0029VaT21WW8PgsBmJWWGc1A\">https://whatsapp.com/channel/0029VaT21WW8PgsBmJWWGc1A</a></p>\r\n<p>Website: <a href=\"https://www.metmalawi.gov.mw/weather-warnings/mphepo-mwera-pa-nyanja-zathu-zonse/\">https://www.metmalawi.gov.mw/weather-warnings/mphepo-mwera-pa-nyanja-zathu-zonse/</a></p>\r\n<p><br /></p>', 1, '2025-05-10 15:14:50', 34),
(13, 'FLASH FLOOD WARNING (29 Dec 2025 – 01 Jan 2026)', 'lakeshore, northern and central Areas', '2025-12-29', '251231075204_555.jpg', '251231075204_555.jpg', '<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"??\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/tdc/1/16/26a0.png\" style=\"border-width: 0px; border-image-width: initial;\" /> FLASH FLOOD WARNING (29 Dec 2025 – 01 Jan 2026)</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><a tabindex=\"-1\"></a><img height=\"16\" width=\"16\" alt=\"??\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/td0/1/16/1f327.png\" style=\"border-width: 0px; border-image-width: initial;\" /> Persistent heavy rainfall expected across lakeshore, northern and central Malawi</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"?\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/tbc/1/16/1f30a.png\" style=\"border-width: 0px; border-image-width: initial;\" /> High risk of flash flooding in low-lying and flood-prone areas</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"??\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/tfc/1/16/1f32c.png\" style=\"border-width: 0px; border-image-width: initial;\" /> Weather conditions include intense downpours, moderate Mwera winds, and frequent lightning <img height=\"16\" width=\"16\" alt=\"?\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/t5d/1/16/26a1.png\" style=\"border-width: 0px; border-image-width: initial;\" /></div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"?\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/t45/1/16/1f6a8.png\" style=\"border-width: 0px; border-image-width: initial;\" /> Category 10 alerts issued for Nkhata Bay and Nkhotakota</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"??\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/tdc/1/16/26a0.png\" style=\"border-width: 0px; border-image-width: initial;\" /> Category 6 and 2 warnings in parts of Karonga, Mzimba, Mzuzu, Likoma, and Kasungu</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\"><img height=\"16\" width=\"16\" alt=\"?\" referrerpolicy=\"origin-when-cross-origin\" src=\"https://static.xx.fbcdn.net/images/emoji.php/v9/t3f/1/16/1f30d.png\" style=\"border-width: 0px; border-image-width: initial;\" /> The hazardous weather is due to the prolonged presence of the Inter-Tropical Convergence Zone (ITCZ) over northern Malawi</div>\r\n  <div dir=\"auto\">#Department of Climate Change &amp; Meteorological Services#&nbsp;</div>\r\n</div>\r\n\r\n<p><br /></p>', 1, '2025-12-31 19:52:04', 34),
(14, 'HEAVY RAINS WARNING FROM 07TH JANUARY TO 9TH JANUARY 2026.', 'Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi', '2026-04-01', '260106072800_WhatsApp Image 2026-01-06 at 9.20.58 PM.jpeg', '260106072800_WhatsApp Image 2026-01-06 at 9.20.58 PM.jpeg', '<div>DCCMS is issuing a warning of heavy rainfall expected to affect lakeshore areas and several parts of the country. The adverse weather, characterized by intense downpours accompanied by strong winds and frequent lightning is likely impact Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi which are failing under category 10 alerts. Mzuzu, Likoma, Machinga, Mangochi, parts of Zomba, and Balaka which are under falling under category 6 while the remaining districts are under category 5 of warnings. These risky conditions are due to the low-pressure system which is in the Mozambique channel and currently enhancing Congo air mass but expected to pass through Malawi on Wednesday.</div>\r\n<div><br /></div>\r\n<div>DCCMS wishes also to inform Malawians that the Tropical Storm GRANT which was coming from Australia side has now weakened and is moving towards Madagascar. With the projected path and intensity, GRANT has no direct impact over Malawi.</div>', 1, '2026-01-06 19:28:00', 35),
(15, 'UPDATE ON HEAVY RAINS WARNING EXPECTED OVER MOST AREAS FROM 07TH JANUARY TO 9TH JANUARY 2026.', 'Nkhotakota, Salima, parts of Mzimba, Chitipa, Nkhata Bay, Dowa Mchinji, Mulanje and Phalombe.', '2026-01-06', '260106075959_WhatsApp Image 2026-01-06 at 8.33.45 PM.jpeg', '260106075959_WhatsApp Image 2026-01-06 at 8.33.45 PM.jpeg', '<div>Date of issue: 6 January, 2026. Issue no: 2025/2026-3</div>\r\n<div><br /></div>\r\n<div>The Department of Climate Change and Meteorological Services would like to update the nation on the heavy rainfall which is expected to affect lakeshore areas and several parts of the country due to the low-pressure system that is going to pass through the country. The adverse weather, characterized by intense downpours is expected to be accompanied by strong winds and frequent lightning.</div>\r\n<div>&nbsp;</div>\r\n<div>&nbsp;&nbsp;</div>\r\n<div><br /></div>\r\n<div>Category 10 alerts are currently likely to affect Nkhotakota, Salima, parts of Mzimba, Chitipa, Nkhata Bay, Dowa Mchinji, Mulanje and Phalombe.</div>\r\n<div><br /></div>\r\n<div>Category 6 covers most of northern, central areas and also Machinga, Mangochi, parts of Zomba, and Balaka while the remaining districts are under category 5 of warnings.</div>\r\n<p><br /></p>', 1, '2026-01-06 19:59:59', 35),
(16, 'HEAVY RAINS WARNING FROM 07TH JANUARY TO 9TH JANUARY 2026', 'Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi', '2026-01-07', '260106080200_101010101010.jpg', '260106080200_101010101010.jpg', '<div>\r\n  <div dir=\"auto\">DCCMS is issuing a warning of heavy rainfall expected to affect lakeshore areas and several parts of the country. The adverse weather, characterized by intense downpours accompanied by strong winds and frequent lightning is likely impact Nkhotakota, Salima, parts of Mzimba, Kasungu, Nkhata Bay, Dowa Mchinji, and Ntchisi which are failing under category 10 alerts. Mzuzu, Likoma, Machinga, Mangochi, parts of Zomba, and Balaka which are under falling under category 6 while the remaining districts are under category 5 of warnings. These risky conditions are due to the low-pressure system which is in the Mozambique channel and currently enhancing Congo air mass but expected to pass through Malawi on Wednesday.</div>\r\n</div>\r\n<div>\r\n  <div dir=\"auto\">DCCMS wishes also to inform Malawians that the Tropical Storm GRANT which was coming from Australia side has now weakened and is moving towards Madagascar. With the projected path and intensity, GRANT has no direct impact over Malawi.</div>\r\n</div>\r\n\r\n<p><br /></p>', 0, '2026-01-06 20:02:00', 34);

-- --------------------------------------------------------

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `faq_id` int(11) NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`faq_id`, `question`, `answer`, `date`) VALUES
(8, 'WHAT IS A COOPERATIVE SOCIETY?', 'A cooperative is an autonomous association of persons united voluntarily to meet their common economic and social needs through a jointly-owned and democratically-controlled enterprise/business.', '2023-08-22 05:38:33'),
(9, 'WHAT ARE THE COOPERATIVE PRINCIPLES?', 'Voluntary and Open Membership Democratic Member Control Member Economic Participation Autonomy and Independence Education, Training and Information Cooperation amongst Cooperatives Concern for Community', '2023-08-22 05:39:11'),
(10, 'WHAT IS A SACCO', 'A Savings and Credit Cooperative Society (SACCO) is a member-owned financial cooperative whose primary objective is to mobilise savings and afford members access to loans (productive and provident) on competitive terms as a way of enhancing their socio-economic well being. It is formed by people having a common bond.', '2023-08-22 05:39:35'),
(13, 'HOW DIFFERENT IS A SACCO FROM OTHER BANKS OR MICROFINANCE INSTITUTIONS?', 'SACCOs are member-owned and not profit-oriented. Their philosophy is â€œpeople helping peopleâ€.', '2023-08-22 05:40:59'),
(14, 'WHAT ARE THE BENEFITS OF KEEPING MONEY IN A SACCO?', 'Members have a voice in the running of the SACCO since they own the institution; Members receive dividends at the end of the financial year;  Access to financial services is non-discriminatory and affordable Contribution to a positive community', '2023-08-22 05:41:34'),
(15, 'HOW SAFE IS ONE&apos;S MONEY IN A SACCO?', 'The SACCO mechanism provides for the safety of membersâ€™ money i.e. controls and procedures, committees and reporting structures all provide for the safety of the membersâ€™ money.', '2023-08-22 05:41:59'),
(16, 'WHERE CAN I FIND A SACCO NEAR ME?', 'Please see our list of affiliated SACCOs and our SACCO map. If you want to form a SACCO see Contacts.', '2023-08-22 05:42:27'),
(17, 'WHAT IS A COMMON BOND', 'A common bond is a unifying factor (that which brings people together). Two types of bonds generally exist as follows: Community bond The bond exists where members are resident in a particular locality or neighbourhood. A community bond caters to all people within the community. Occupational or associational bond The bond provides for people of the same occupation or for those employed by a common employer or who belongs to the same profession. *Open Bond SACCOs can be comprised of both Community and Occupational Bonds.', '2023-08-22 05:44:24'),
(18, 'WHO CAN JOIN A SACCO', 'Joining a SACCO is easy. Membership is open to all regardless of sex, race, religion or political affiliation. It is voluntary within the SACCOâ€™s common bond. Each SACCO has a membership qualification process, common ones being that you are a member of a particular grouping or company, e.g. if you are a teacher or an employee of a particular organization, or if you belong to a certain community. Everyone from a Farmer to a CEO is able to join a SACCO!', '2023-08-27 12:31:37');

-- --------------------------------------------------------

--
-- Table structure for table `inquiries`
--

CREATE TABLE `inquiries` (
  `id` int(11) NOT NULL,
  `link` varchar(60) NOT NULL,
  `name` varchar(128) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(32) DEFAULT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `inquiries`
--

INSERT INTO `inquiries` (`id`, `link`, `name`, `email`, `phone`, `subject`, `message`, `date`, `status`) VALUES
(21, 'gvcQQzPiFOqypJ', 'Wezzie Mhango', 'wezmhango@hotmail.com', '0991603780', 'Information Inquiry', 'rree', '2023-07-25 12:31:23', 0),
(22, 'kzIzJp3KigK57v', 'Dan Imfa', 'bandaowen89@gmail.com', '099882297414', 'system issue', 'How can i join Sacco', '2023-08-21 23:55:20', 0);

-- --------------------------------------------------------

--
-- Table structure for table `job_categories`
--

CREATE TABLE `job_categories` (
  `category_id` int(11) NOT NULL,
  `category` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `job_categories`
--

INSERT INTO `job_categories` (`category_id`, `category`) VALUES
(1, 'Full Time'),
(2, 'Part Time'),
(3, 'Temporary'),
(4, 'Internship'),
(5, 'Volunteer');

-- --------------------------------------------------------

--
-- Table structure for table `leadership`
--

CREATE TABLE `leadership` (
  `leader_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `name` varchar(64) NOT NULL,
  `type` varchar(32) NOT NULL,
  `image` varchar(128) NOT NULL,
  `facebook` varchar(1028) DEFAULT NULL,
  `twitter` varchar(1028) DEFAULT NULL,
  `linkedin` varchar(1028) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `leadership`
--

INSERT INTO `leadership` (`leader_id`, `title`, `name`, `type`, `image`, `facebook`, `twitter`, `linkedin`, `date`) VALUES
(24, 'Chief Executive Officer ', 'Fumbani Nyangulu', 'Management', '1691651634_Fumbani Nyangulu.jpg', 'https://www.facebook.com/   ', 'https://twitter.com/', 'https://www.linkedin.com/', '2023-08-10 07:13:54'),
(25, 'Head of Cooperatives Development & Projects', 'Leroy Banda', 'Management', '1691680208_LEROY BANDA .jpg', 'https://www.facebook.com/   ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-10 15:10:08'),
(27, 'IT Manager', 'Daniel Imfa', 'Management', '1692359518_Daniel Imfa .jpg', 'https://www.facebook.com/   ', 'https://twitter.com/?lang=en', 'https://www.instagram.com/', '2023-08-18 11:51:58'),
(28, 'Business Development Manager', 'Ezikiel Thindwa', 'Management', '1692359743_Ezikiel Thindwa.jpg', 'https://www.facebook.com/   ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-18 11:55:43'),
(29, 'Finance Manager', 'Rose Chalendewa', 'Management', '1692359809_Rose Chalendewa.jpg', 'https://www.facebook.com/   ', 'https://twitter.com/?lang=en', 'https://www.linkedin.com/', '2023-08-18 11:56:49'),
(31, 'Board President ', 'Alex Ntungama', 'Board Member', '1732872389_Alex Ntungama.JPG', 'https://www.facebook.com/   ', 'https://twitter.com/', 'https://www.linkedin.com/', '2023-08-22 03:33:51'),
(41, 'Head of Finance and Administration', 'Kingsley Mulewa', 'Management', '1733808384_Kingsley Mulewa.jpg', '', '', '', '2024-12-10 05:26:24'),
(42, 'Board Vice President', 'Mrs. Jessie Eneya', 'Board Member', '1733811601_Mrs. Jessie Eneya.jpg', '', '', '', '2024-12-10 06:20:01'),
(43, 'Board Treasurer', 'Col. Alinine Simwaka', 'Board Member', '1733812553_Col. Alinine Simwaka.jpg', '', '', '', '2024-12-10 06:35:53'),
(44, 'Board Secretary', 'His Worship Mphalulo Fatch', 'Board Member', '1733812668_His Worship Mphalulo Fatch.jpg', '', '', '', '2024-12-10 06:37:48'),
(45, 'Board Member', 'Mrs. Slyvia Chisama', 'Board Member', '1733812728_Mrs. Slyvia Chisama .jpg', '', '', '', '2024-12-10 06:38:48'),
(46, 'Technical Director', 'Mr. Zamdziko Makhambo', 'Board Member', '1733812771_Mr. Zamdziko Makhambo.jpg', '', '', '', '2024-12-10 06:39:31'),
(47, 'Technical Director', 'Mr. Makwemba Malonje', 'Board Member', '1733812800_Mr. Makwemba Malonje.jpg', '', '', '', '2024-12-10 06:40:00'),
(48, 'Technical Director', 'Mrs. Zaithwa Phambana', 'Board Member', '1733812844_Mrs. Zaithwa Phambana.jpg', '', '', '', '2024-12-10 06:40:44'),
(49, 'Registrar Of Cooperatives ', 'Mr. Limbikani Kachiwaya', 'Board Member', '1733812885_Mr. Limbikani Kachiwaya.jpg', '', '', '', '2024-12-10 06:41:25');

-- --------------------------------------------------------

--
-- Table structure for table `newsletters`
--

CREATE TABLE `newsletters` (
  `newsletter_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `file` varchar(128) NOT NULL,
  `link` varchar(60) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `newsletters`
--

INSERT INTO `newsletters` (`newsletter_id`, `title`, `file`, `link`, `posted_by`, `date`) VALUES
(87, 'The Disaster Preparedness and Relief Act 1991 ', '250430120455_The Disaster Preparedness and Relief Act 1991 .pdf', '4wpwBBUwLx50Cf3h', 35, '2025-04-30 12:04:55'),
(88, 'MALAWI NATIONAL DRR FRAMEWORK (2010-2015)', '250430120750_MALAWI NATIONAL DRR FRAMEWORK (2010-2015).pdf', 'SjZmJRHUlauplux7pAR0hmIJ81', 35, '2025-04-30 12:07:50'),
(89, 'Climate Change and Disaster Risk Management Advocacy Strategy (2012-2015)', '250430120840_Climate Change and Disaster Risk Management Advocacy Strategy (2012-2015).pdf', 'K0uecjPpZjgsIZIvEzp', 35, '2025-04-30 12:08:40'),
(90, 'Climate Change Policy and Legal Framework in Malawi- Towards a Comprehensive Policy Framework', '250430120933_Climate Change Policy and Legal Framework in Malawi- Towards a Comprehensive Policy Framework.pdf', 'eBaviCw1g6z4LWiAs21m3mwILBJC0XZIEyJU9pq5X5KR0fhdffmd4vURLUJa', 35, '2025-04-30 12:09:33'),
(91, 'National ClimateChange Investment Plan (2013-18)', '250430121102_National ClimateChange Investment Plan (2013-18).pdf', 'PMmMKR9ZRbbQZMPNgMgIbwx3lQ1UcVggAlmY45', 35, '2025-04-30 12:11:02'),
(92, 'National Disaster Risk Management Communication Strategy 2014-2018', '250430121136_National Disaster Risk Management Communication Strategy 2014-2018.pdf', 'pJZrJMab5F5k9nWAy3LnmE4iiKUQxg8h6FZLZSvE3lsMU10SGpsGvI', 35, '2025-04-30 12:11:36'),
(93, 'Malawi National Disaster Recovery Framework ', '250430121521_Malawi National Disaster Recovery Framework .pdf', 'p8Z6ZCH1WaCOwewsw6tiJqzG1KRYsGfOZhP', 35, '2025-04-30 12:15:21'),
(94, 'Malawi DRM Policy 2015', '250430121546_Malawi DRM Policy 2015.pdf', 'Cg8uKlR8RsNBFZngIhGGrQL57YZjY77Kya0EitFMbKLnVTnhJ', 35, '2025-04-30 12:15:46'),
(95, 'Devolution Plan-DoDMA 2016', '250430121627_Devolution Plan-DoDMA 2016.pdf', '0AoFJjMj0XIbMg5ZgAMHorsjkVz2Df9QTs', 35, '2025-04-30 12:16:27'),
(96, 'Malawi Food Insecurity Response Plan FIRP (2016-2017)', '250430121706_Malawi Food Insecurity Response Plan FIRP (2016-2017).pdf', 'oKWkubT', 35, '2025-04-30 12:17:06'),
(97, 'National Climate Change Management Policy 2016', '250430121755_National Climate Change Management Policy 2016.pdf', 'sh9KiucY3sYFnRCh1', 35, '2025-04-30 12:17:55'),
(98, 'National Disaster Recovery Framework. Volume 2-Drought(2017)', '250430121952_National Disaster Recovery Framework. Volume 2-Drought(2017).pdf', 'zQWS60rYMNI511cD7qVVGClSDfO4JuARej37iCymaqza0oZi5wN45', 35, '2025-04-30 12:19:52'),
(99, 'National Training Manual on DRM', '250430122151_National Training Manual on DRM.pdf', 'DWvaMunDEW1ckOdUTuY0wyEsUpgdQWUej2tg531Sbo', 35, '2025-04-30 12:21:51'),
(100, 'National Guidelines for Community Based Early Warning Systems', '250430122243_National Guidelines for Community Based Early Warning Systems.pdf', 'Fw3MhwvU8hUmXK7zSs3HoHEdjiUbiR9QU85a4ht8ayvSgoZpM', 35, '2025-04-30 12:22:43'),
(101, 'National Disaster Risk Management Communication Strategy 2019-2022', '250430122320_National Disaster Risk Management Communication Strategy 2019-2022.pdf', 'MP4QKUh21FjFLX9XG8AxsmtUeWSONkGrsA6UHxN5MUV9ZDQ1', 35, '2025-04-30 12:23:20'),
(102, 'National Resilience Strategy (2018-2030)', '250430122445_National Resilience Strategy (2018-2030).pdf', 'bUbhsyl5IrdYtORwJAmWHEQcfTkw7HtR4FHUKEYlqlq', 35, '2025-04-30 12:24:45'),
(103, 'DRM Bill, 2019', '250430122525_DRM Bill, 2019.pdf', 'nMeINKF1qJRPZco8hydpQJPMMlwiacwOWVr', 35, '2025-04-30 12:25:25'),
(104, 'Disaster Risk Financing Strategy 2019-2024', '250430122545_Disaster Risk Financing Strategy 2019-2024.pdf', '2hnsQACKBjXJ', 35, '2025-04-30 12:25:45'),
(105, '2019 Flood Response Plan and Appeal', '250430123101_2019 Flood Response Plan and Appeal.pdf', 'k6sXlK', 35, '2025-04-30 12:31:01'),
(106, 'Development of Malawi’s  Disaster Risk Management Act 2023', '250430123346_Development of Malawi’s  Disaster Risk Management Act 2023.pdf', '1mIbawSlxJ8vik7946NVRUCMFE', 35, '2025-04-30 12:33:46'),
(107, 'Tropical Cyclone Freddy Response (2023)', '250430123439_Tropical Cyclone Freddy Response (2023).pdf', 'mLGeEGzx5CWK8kxQzHdfjKjyf', 35, '2025-04-30 12:34:39'),
(108, 'The national multihazard contingency plan (2023-2024)', '250430123517_The national multihazard contingency plan (2023-2024).pdf', 'cDciWbqZNUQP6gWMO1Cf5eb8FACZg', 35, '2025-04-30 12:35:17'),
(109, 'Malawi Vision 2063', '250430123634_Malawi Vision 2063.pdf', '3WDhMtWmS', 35, '2025-04-30 12:36:34');

-- --------------------------------------------------------

--
-- Table structure for table `overall_projects`
--

CREATE TABLE `overall_projects` (
  `newsletter_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `district` varchar(30) NOT NULL,
  `file` varchar(128) NOT NULL,
  `link` varchar(60) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `overall_projects`
--

INSERT INTO `overall_projects` (`newsletter_id`, `title`, `district`, `file`, `link`, `posted_by`, `date`) VALUES
(66, 'Malawi Contigency Emergency Response Project (CERP)', 'national', '250423124044_Malawi Contigency Emergency Response Project (CERP).pdf', 'O4KgeblK5XsNYNm17Uy7N3K7tgXe2A', 34, '2025-04-23 12:40:44'),
(67, 'Misuku Hills Improved Livelihood and Biodervity Conservation Project summary report', 'chitipa', '250424082250_Misuku Hills Improved Livelihood and Biodervity Conservation Project summary report.pdf', 'dcFS323', 34, '2025-04-24 08:22:50'),
(68, 'PRIDE Irrigation Schemes Project', 'national', '250424082651_PRIDE Irrigation Schemes Project.pdf', 'JAaDHQ3yda4dIjzv5LZSf5TYBudI', 34, '2025-04-24 08:26:51'),
(69, 'PRIDE Irrigation Schemes Project', 'chitipa', '250424083815_PRIDE Irrigation Schemes Project.pdf', 'WYAR0tZXlGrKSOhpricJdi2wZflBfxuBtdjdQNmUKLLoAa0', 34, '2025-04-24 08:38:15'),
(70, 'PRIDE Irrigation Schemes Project', 'karonga', '250424083937_PRIDE Irrigation Schemes Project.pdf', 'vJq0inxH9PqTRD3BSEaqBRrYNMkObkyCf0o66UKnkDHzAMiXV7sajUj1C', 34, '2025-04-24 08:39:37'),
(71, 'PRIDE Irrigation Schemes Project', 'nkhatabay', '250424084005_PRIDE Irrigation Schemes Project.pdf', 'oJ6ZzRHFx9ychOHCD8wtBheIWi8Q7', 34, '2025-04-24 08:40:05'),
(72, 'Dedza -TA Kachere Integrated Sustainable Water and Sanitation Project-Jan-Nov, 2010 Report', 'dedza', '250424085233_Dedza -TA Kachere Integrated Sustainable Water and Sanitation Project-Jan-Nov, 2010 Report.pdf', 'I1qMOwTEZ', 34, '2025-04-24 08:52:33'),
(77, 'MALAWI WATER AND SANITATION PROJECT – 1', 'blantyre', '250425085147_MALAWI WATER AND SANITATION PROJECT – 1.pdf', 'B0HKM3v6tu2oMzt4Ap4o2r5EfabCXchmtmyt', 35, '2025-04-25 08:51:47'),
(78, 'Disaster Risk Reduction and Response in Chikwawa, Malawi', 'chikwawa', '250425085500_Disaster Risk Reduction and Response in Chikwawa, Malawi.pdf', 'rHN0MCjzVH0Oqj', 35, '2025-04-25 08:55:00'),
(79, 'DoDMA Intensifies Preparedness Interventions, Dredges Rivers In Lower Shire', 'nsanje', '250425090121_DoDMA Intensifies Preparedness Interventions, Dredges Rivers In Lower Shire.pdf', 'nfSc0FbUTFGArKWXpw3wrBBVQOPN7xVPX1orv9sa', 35, '2025-04-25 09:01:21'),
(80, 'Pamawa Project (2016)', 'machinga', '250425090540_Pamawa Project (2016).pdf', 'c82gamhGFPpQxZdWWdgjped31czhATWAP6EPzqiXLamiH', 35, '2025-04-25 09:05:40'),
(82, 'Appraisal of the Karonga Rural  Development Project-phase II', 'karonga', '250425090936_Appraisal of the Karonga Rural  Development Project-phase II.pdf', 'ICAHxL0Isv5S1vJM7uMAdiBy1WM9j', 34, '2025-04-25 09:09:36'),
(84, 'Climate Adaptation for Rural Livelihood and Agricuture(CARLA)', 'national', '250425092103_Climate Adaptation for Rural Livelihood and Agricuture(CARLA).pdf', 'vYihApWsedVI', 34, '2025-04-25 09:21:03'),
(85, 'The Songwe River Basin Development Programme', 'karonga', '250425092429_The Songwe River Basin Development Programme.pdf', '6ZjqyBFm863WgbPbWPO139Sng', 34, '2025-04-25 09:24:29'),
(86, 'Part II of the Mangochi Basic Services Programme (MBSP)', 'mangochi', '250425092738_Part II of the Mangochi Basic Services Programme (MBSP).pdf', 'lhed', 35, '2025-04-25 09:27:38'),
(87, 'Climate Proofing Local Development Gains in Urban and Rural areas of Machinga and Mangochi; 2019 Annual Workplan', 'mangochi', '250425093607_Climate Proofing Local Development Gains in Urban and Rural areas of Machinga and Mangochi; 2019 Annual Workplan.pd', 'PC4UdsRRh1oD7', 35, '2025-04-25 09:36:07'),
(89, 'Climate Resilience Initiative in Malawi (CRIM)', 'kasungu', '250425094232_Climate Resilience Initiative in Malawi (CRIM).pdf', 'W6yRhwSKsZvrQfmNCPvEjOUEHbQs', 34, '2025-04-25 09:42:32'),
(90, 'Climate Resilience Initiative in Malawi (CRIM)', 'mzimba', '250425094317_Climate Resilience Initiative in Malawi (CRIM).pdf', 'f66PgqGFT4ZfeEdiktWWB05nbkf1H4O6D', 34, '2025-04-25 09:43:17'),
(91, 'Social Support for Resilient Livelihoods Support (SSRLP).mw', 'national', '250425095054_Social Support for Resilient Livelihoods Support (SSRLP).mw.pdf', 'QDoav9HtuaJgS01408nCt', 34, '2025-04-25 09:50:54'),
(92, 'Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Document (2014) ', 'mangochi', '250425095615_Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Docume', 'AXW4nsgDStRFGVseCOhKTIYfH540fehr2RPgI', 35, '2025-04-25 09:56:15'),
(95, 'Management Response to Midterm Review of Climate Proofing Project', 'mangochi', '250425100737_Management Response to Midterm Review of Climate Proofing Project.pdf', 'lZ5EjMAnwFe7GAy3ZShVVAHzJluRpgArpDucw8GJjL8MpFtbYpfnPD3L4', 35, '2025-04-25 10:07:37'),
(96, 'Ttukulane Program Q1 Report', 'mangochi', '250425100911_Ttukulane Program Q1 Report.pdf', 'z4h8ErcXorNPENyjEfykjRAssgRt0Y2iByYyheabLzuuK', 35, '2025-04-25 10:09:11'),
(97, 'Lilongwe water and saninitation project', 'lilongwe', '250425101010_Lilongwe water and saninitation project.pdf', '4O3j2dRUCypBtdH2lwOV6LEUT5g', 34, '2025-04-25 10:10:10'),
(98, 'Titukulane Project', 'mangochi', '250425101033_Titukulane Project.pdf', 'bzEytGH7iW2', 35, '2025-04-25 10:10:33'),
(99, 'Titukulane Baseline Study Malawi Vol. I', 'mangochi', '250425101233_Titukulane Baseline Study Malawi Vol. I.pdf', 'uyPKW5H9MFeJ9yZ', 35, '2025-04-25 10:12:33'),
(100, 'Titukulane Baseline Study Malawi Vol. II', 'mangochi', '250425101336_Titukulane Baseline Study Malawi Vol. II.pdf', 'sF7icy', 35, '2025-04-25 10:13:36'),
(102, 'Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Document (2014) ', 'machinga', '250425101737_Climate Proofing Local Development Gains in Rural and Urban Areas of Machinga and Mangochi Districts-Project Docume', 'ZotAhaTkM', 35, '2025-04-25 10:17:37'),
(103, 'Management Response to Midterm Review of Climate Proofing Project', 'machinga', '250425102403_Management Response to Midterm Review of Climate Proofing Project.pdf', 'KrRaMpPm8U', 35, '2025-04-25 10:24:03'),
(104, 'MASAF Community Development Projects Handbook', 'national', '250425102424_MASAF Community Development Projects Handbook.pdf', '7Cr7eMriLxzcMNiBEvR1I01MUZD4L', 34, '2025-04-25 10:24:24'),
(105, 'The Mwanalundu disaster risk reduction project', 'mwanza', '250425103839_The Mwanalundu disaster risk reduction project.pdf', '9akX1FQR6UHC2lZBSCKbf2VXjbzna9MP9eOS10ZPwUy6gqFj2SFv2ppL', 35, '2025-04-25 10:38:39'),
(111, 'Titukulane Project', 'zomba', '250425105059_Titukulane Project.pdf', '63fZ0Ds4Il1FFZvf2b9nueVY1CcRXGvJ', 35, '2025-04-25 10:50:59'),
(112, 'Ttukulane Program Q1 Report', 'zomba', '250425105146_Ttukulane Program Q1 Report.pdf', 'rnZMT5f63jAumSmB8Kr7rAt8XPWF4tfIdsPha5lbD', 35, '2025-04-25 10:51:46'),
(113, 'Titukulane Baseline Study Malawi Vol. I', 'zomba', '250425105324_Titukulane Baseline Study Malawi Vol. I.pdf', 'EXsM4QTb7ivgvKeQm0PWH5P6cWPM', 35, '2025-04-25 10:53:24'),
(115, 'Maintenance System Project', 'salima', '250425105620_Maintenance System Project.pdf', 'mb9BGtm', 34, '2025-04-25 10:56:20'),
(116, 'Maintenance System Project', 'dowa', '250425105709_Maintenance System Project.pdf', 'TaCbeS1pe8fjbRYDiVu4Vg3clI93V65qIb9KpV5BnbBpTw2pZoC5H31q', 34, '2025-04-25 10:57:09'),
(117, 'Maintenance System Project', 'kasungu', '250425105848_Maintenance System Project.pdf', 'hVQAJ1BkeICuiqaZZYsotPtkLjxM33qaBPdYo5yPTQ31HYU79mLYq0Mt', 34, '2025-04-25 10:58:48'),
(118, 'Titukulane Baseline Study Malawi Vol. II', 'zomba', '250425110235_Titukulane Baseline Study Malawi Vol. II.pdf', 'TTEiDhaymppGTvIkHMqDAE6m6f1MW', 35, '2025-04-25 11:02:35'),
(119, 'Malawi Agricultrual Commercialization Project', 'national', '250425110658_Malawi Agricultrual Commercialization Project.pdf', 'VGX1WR', 34, '2025-04-25 11:06:58'),
(122, 'Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report', 'mzimba', '250425115017_Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report.pdf', 'sWJPrLQ9J19lhbNWo3TPJnxmXNHAHNkhywdxLPHtVEYmDAu', 34, '2025-04-25 11:50:17'),
(123, 'Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report', 'ntchisi', '250425115128_Integrated Water Supply and Sanitation for Ntchisi and Mzimba-Appraisal Report.pdf', 'fa6L9wnmZHMUIXPTnhrDbPF8VfDheWlv', 34, '2025-04-25 11:51:28'),
(127, 'Nkhata Bay Town Water Supply and Sanitation- Appraisal Report', 'nkhatabay', '250425122801_Nkhata Bay Town Water Supply and Sanitation- Appraisal Report.pdf', '3jdsZxnYSNyzxFOlhEza4UCQFNkJqTFycmEDuRiDWm', 34, '2025-04-25 12:28:01'),
(128, 'Effective Management of Mchinji Ecosystems for Restoration of Upper Bua River Catchment (2023)', 'mchinji', '250425123945_Effective Management of Mchinji Ecosystems for Restoration of Upper Bua River Catchment (2023).pdf', 'q7gUKpJOmpeo3btVqEcPrTPRLVV4cTMD4F9IUN3RW0kNOgcF', 35, '2025-04-25 12:39:45'),
(131, 'Technical Assistance for Catchment-Based Climate Resilient Water Security in Northern Malawi (Nkhata Bay, Rumphi, and Chitipa)', 'chitipa', '250425124446_Technical Assistance for Catchment-Based Climate Resilient Water Security in Northern Malawi (Nkhata Bay, Rumphi, a', '0ij5kks5gF1GdzF3haHmKscVRVUT37ZV02D3i7t9vm0VQJTp', 34, '2025-04-25 12:44:46'),
(132, 'The NkhataBay Cook Stove Project', 'nkhatabay', '250425010729_The NkhataBay Cook Stove Project.pdf', '1j8ucyPKyhEE3koUkDQ63KUAqtc1qxSLWvK1OFYkmld1', 34, '2025-04-25 13:07:29'),
(133, 'Smart Climate Project', 'karonga', '250425011727_Smart Climate Project.pdf', 'bRVJNZ2IuzhdmBono90PG0TvOvDczzv140Q75', 34, '2025-04-25 13:17:27'),
(134, 'Smart Climate Project', 'nkhotakota', '250425011815_Smart Climate Project.pdf', 'MEnAlvdxWjX26QVnbJbkf19p55bWDS', 34, '2025-04-25 13:18:15'),
(135, 'Effective Management of Nkhotakota Wildlife Reserve Project', 'nkhotakota', '250425012247_Effective Management of Nkhotakota Wildlife Reserve Project.pdf', 'rhim6vFukHyvYOgWSMmyCvKYir', 34, '2025-04-25 13:22:47'),
(139, 'Recent-and-ongoing-projects', 'mzimba', '250425014713_Recent-and-ongoing-projects.pdf', 'VWWo4Qoec0hD', 34, '2025-04-25 13:47:13'),
(140, 'Water, Sanitation and Hygiene Promotion Project (1994)', 'ntchisi', '250425015351_Water, Sanitation and Hygiene Promotion Project (1994).pdf', 'vdU96Nu2etYO2IMZ91TlwQZHRQHfYNiTktpnWiqXI', 35, '2025-04-25 13:53:51'),
(142, 'INTEGRATED RURAL WATER SUPPLY AND SANITATION PROJECT FOR NTCHISI AND MZIMBA DISTRICTS', 'ntchisi', '250425114954_INTEGRATED RURAL WATER SUPPLY AND SANITATION PROJECT FOR NTCHISI AND MZIMBA DISTRICTS.pdf', 'sjirwy0ECT', 35, '2025-04-25 23:49:54'),
(144, 'the Malawi Livestock for Resilience (L4R) project', 'ntchisi', '250425115142_the Malawi Livestock for Resilience (L4R) project.pdf', 'TpqDI90iBvjhziSgDm1uuseM', 35, '2025-04-25 23:51:42'),
(146, 'Karonga-Floods-Response-Malawi', 'karonga', '250513093112_Karonga-Floods-Response-Malawi.pdf', 'eYnRlkAyXAwJVronhBoq6bfcG8so0XXKgA4av9Gmw', 34, '2025-05-13 09:31:12'),
(147, 'AFB.PPRC_.35.Inf_.35.-Proposal-for-Malawi-Mozambique-Zimbabwe', 'national', '251109092312_AFB.PPRC_.35.Inf_.35.-Proposal-for-Malawi-Mozambique-Zimbabwe.pdf', 'rdZYepWbiS3GcKUl4ZjaisaVBPbYssiYa', 34, '2025-11-09 21:23:12'),
(148, 'AFB.PPRC_.33.Inf_.12-Proposal-for-Malawi', 'national', '251109092424_AFB.PPRC_.33.Inf_.12-Proposal-for-Malawi.pdf', 'ClTssQtY1R1bZQycizzG079keaYoYtd711b0OmvP3UF75SP1j', 34, '2025-11-09 21:24:24');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `project_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `details` text NOT NULL,
  `posted_by` varchar(60) NOT NULL,
  `thumb` varchar(128) NOT NULL,
  `image` varchar(128) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `active` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`project_id`, `title`, `details`, `posted_by`, `thumb`, `image`, `status`, `active`, `date`) VALUES
(17, 'Enhanced Aggregation and Market Linkages among Smallholder Poultry Farmers', '<p>Malawi Union of Savings and Credit Cooperatives (MUSCCO) and The Commercial Agriculture for Smallholders and Agribusiness (CASA) partnered to implement an <i>Enhanced Aggregation and\r\nMarket Linkages among Smallholder Poultry Farmers Project </i>in Mzimba, Mchinji and Lilongwe.\r\n</p>\r\n<p>\r\n  The project is expected to increase incentives for the poultry marketing system to improve performance, and trade, and ultimately economic returns for smallholder poultry famers and agribusinesses. </p>\r\n<p>This will be achieved through interventions in improved aggregation services among poultry groups, self-financing among poultry producers and linkages to stable markets.\r\n\r\n\r\n</p>\r\n\r\n<p><br /></p>', '23', '1692649100_OWENB.jpg', '1692649100_Untit.jpg', 1, 0, '2023-08-21 20:18:20'),
(18, 'Community Economic Participation Enhancement Support to Farmers, Farmer Organizations and Trade Associations', '<p>Malawi Union of Savings and Credit Cooperatives (MUSCCO) is partnering with We Effect with financial support from Swedish International Development Cooperation Agency (SIDA) to implement a project called community economic participation enhancement support to farmers, farmer organizations and trade associations across the country aimed at addressing challenges of lack access to financial services and weak farmer organizations that limit productivity as well as adaptation of rural communities to impacts of climate change resulting into farming as a non-commercial undertaking across.\r\n\r\n  <br /></p>', '23', '1692649259_OWENB.jpg', '1692649259_servi.jpg', 1, 0, '2023-08-21 20:20:59'),
(19, 'Promotion of Agricultural Finance for agri-based Enterprises in Rural Areas partners', '<p>Malawi Union of Savings and Credit Cooperatives (MUSCCO) partnered with GIZ to implement a project called Promotion of agricultural finance for Agri based enterprises in rural areas in Mchinji, Lilongwe and Dowa districts aimed at contributing to improving formal agricultural financing by Savings and Credit Cooperatives Societies (SACCOs) to farmers and agri-based enterprises in rural areas in the country.\r\n\r\n\r\n  <br /></p>', '23', '1692650013_OWENB.jpg', '1692650013_servi.jpg', 1, 0, '2023-08-21 20:33:33');

-- --------------------------------------------------------

--
-- Table structure for table `publications`
--

CREATE TABLE `publications` (
  `publication_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `file` varchar(128) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `link` varchar(60) NOT NULL,
  `posted_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `publications`
--

INSERT INTO `publications` (`publication_id`, `title`, `file`, `date`, `link`, `posted_by`) VALUES
(87, 'Mzuzu University Biogas Strategic Energy Project', '250430080203_Mzuzu University Biogas Strategic Energy Project.pdf', '2025-04-30 08:02:03', '8tT7Pk3rjg8iy', 34),
(88, 'Flood Vulnerability Assessment in Rural and Urban Informal Settlements- Case Study of Karonga Districts and Lilongwe City', '250430080344_Flood Vulnerability Assessment in Rural and Urban Informal Settlements- Case Study of Karonga Districts and Lilongw', '2025-04-30 08:03:44', 'RD4HbspCn4OkjJkidLmhlxx7KlidbJsjYRHBudUw5', 34),
(89, 'COMDEKS Project Tukombo-Kande Region-IPSI Case Study Summary Sheet', '250430080514_COMDEKS Project Tukombo-Kande Region-IPSI Case Study Summary Sheet.pdf', '2025-04-30 08:05:14', 'eTD4aDJHZnQOGdwiWQgH1PDTrrCWbutr', 34),
(90, 'Climate and mobility case study (Chikwawa) January 2023', '250430020233_Climate and mobility case study (Chikwawa) January 2023.pdf', '2025-04-30 14:02:33', '9hwnvVJOeBk05fzo', 35),
(91, 'Malawi Transforming Disaster Response', '250430020539_Malawi Transforming Disaster Response.pdf', '2025-04-30 14:05:39', 'BTxZod53V0LLDoPDRGZZSWO6kI3ycbG5XX57UO9IHGX1JKR151QODXlgOFi', 35),
(92, 'Developments of the Nationwide Earthquake Early Warning System in Japan After the 2011 Mw9.0 Tohoku-Oki Earthquake', '251123071513_Developments of the Nationwide Earthquake Early Warning System in Japan After the 2011 Mw9.0 Tohoku-Oki Earthquake.', '2025-11-23 19:15:13', 'ANF6T', 35),
(93, 'Learning from Megadisasters; Lessons from the Great East Japan Earthquake', '251123071900_Learning from Megadisasters; Lessons from the Great East Japan Earthquake.pdf', '2025-11-23 19:19:00', 'Y216SuoNuNTpdTZgK7dYX', 35),
(94, 'Lessons Learned from the 2011 Tohoku Tsunami', '251123072149_Lessons Learned from the 2011 Tohoku Tsunami.pdf', '2025-11-23 19:21:49', 'KG1rEVWaoGCElfVoh5bDZclZYx0he', 35),
(95, 'Adaptive Social Protection and Disaster Risk Management: A Case Study of Japan', '251123072244_Adaptive Social Protection and Disaster Risk Management: A Case Study of Japan.pdf', '2025-11-23 19:22:44', 'w7DbYMdy5jS5VTWEzy0I52UyFBzuUr2HiXNPuZsO4sL1fpyNhctPQ1yc80n', 35);

-- --------------------------------------------------------

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `region_id` int(11) NOT NULL,
  `region_name` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`region_id`, `region_name`) VALUES
(1, 'Southern Region (Chapter 1)'),
(2, 'Central Region (Chapter 2)'),
(3, 'Northern Region (Chapter 3)');

-- --------------------------------------------------------

--
-- Table structure for table `report`
--

CREATE TABLE `report` (
  `report_id` int(11) NOT NULL,
  `title` varchar(128) NOT NULL,
  `file` varchar(128) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `report`
--

INSERT INTO `report` (`report_id`, `title`, `file`, `date`) VALUES
(27, 'Yokohama Strategy and Plan of Action for Safer World', '250429082314_Yokohama Strategy and Plan of Action for Safer World.pdf', '2025-04-29 08:23:14'),
(30, 'AFRICA  Disaster Risk Disaster Risk Reduction, Reduction, Governance Governance and Development', '250429082836_AFRICA  Disaster Risk Disaster Risk Reduction, Reduction, Governance Governance and Development.pdf', '2025-04-29 08:28:36'),
(31, 'Hyogo Framework for Action (2005-2015)', '250429083005_Hyogo Framework for Action (2005-2015).pdf', '2025-04-29 08:30:05'),
(32, 'Sendai Framework for Disaster Risk Reduction. 2015-2030', '250429083041_Sendai Framework for Disaster Risk Reduction. 2015-2030.pdf', '2025-04-29 08:30:41'),
(33, 'The 2030 Agenda For Sustainable Development', '250429083116_The 2030 Agenda For Sustainable Development.pdf', '2025-04-29 08:31:16'),
(34, 'Sustainable Development Goals (SDGs)', '250429083139_Sustainable Development Goals (SDGs).pdf', '2025-04-29 08:31:39');

-- --------------------------------------------------------

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `resource_id` int(11) NOT NULL,
  `resource_title` varchar(128) NOT NULL,
  `resource_file` varchar(128) NOT NULL,
  `posted_date` timestamp NOT NULL DEFAULT current_timestamp(),
  `link` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` (`resource_id`, `resource_title`, `resource_file`, `posted_date`, `link`) VALUES
(113, 'Malawi Food and Security Assessment Report August 2003', '250429093059_Malawi Food and Security Assessment Report August 2003.pdf', '2025-04-29 09:30:59', 'P4K39M8zCpOaCiQ9YIhEnZ2iR6gbnOL'),
(114, 'FAO-WFP Crop and Food Supply Assessment Mission to Malawi Special Report-2004', '250429093315_FAO-WFP Crop and Food Supply Assessment Mission to Malawi Special Report-2004.pdf', '2025-04-29 09:33:16', '7mfPOMppVObVnEaknAbs3oGKnOhQT8U5Y3Gn5j6AyEIkB4CRhjiWasjDV'),
(115, 'Malawi Food Security Monitoring Report-May 2004', '250429093642_Malawi Food Security Monitoring Report-May 2004.pdf', '2025-04-29 09:36:42', 'uB9du9db7sgKu'),
(116, 'Malawi Food Security Update Report November 2005', '250429093817_Malawi Food Security Update Report November 2005.pdf', '2025-04-29 09:38:17', 'TcEfPbJAWwHOJVUb2FJ0K9Wh0Zy8wL7xJe7'),
(117, 'Malawi Community and Household Surveillance CHS October 2007', '250429093940_Malawi Community and Household Surveillance CHS October 2007.pdf', '2025-04-29 09:39:40', 'feXTrVXOMXc1uVhMF'),
(118, 'Situation Analysis of Disaster Risk Management Programmes and Practices Final Report. Malawi Final Volume 1-Nov 2008', '250429100539_Situation Analysis of Disaster Risk Management Programmes and Practices Final Report. Malawi Final Volume 1-Nov 200', '2025-04-29 10:05:39', 'nAHAd5s9Kz2yY6ump'),
(119, 'International Federation of Red Cross and Red Crescent Societies Annual Report 30-April 2010', '250429100711_International Federation of Red Cross and Red Crescent Societies Annual Report 30-April 2010.pdf', '2025-04-29 10:07:11', 'deZwSoVBaCaSA1Sg6VQHSdTnOmV8dpreO'),
(120, 'Participatory Vulnerability Assessment (PVA) Consolidated Report- Dec 2011', '250429101245_Participatory Vulnerability Assessment (PVA) Consolidated Report- Dec 2011.pdf', '2025-04-29 10:12:45', 'dk9viBh70rw02JSkn1esD2kxTb2F73'),
(121, 'DISCOVER Participatory Vulnerability and Capacity Assessment Report', '250429101402_DISCOVER Participatory Vulnerability and Capacity Assessment Report.pdf', '2025-04-29 10:14:02', 'rZj6fgfLjn3LxqIVaRdpkSuOzdy8XGHxhp4YKT'),
(122, 'CEPA ECRP DISCOVER Advocacy Report - Year 2 Quarter 2-2013', '250429102032_CEPA ECRP DISCOVER Advocacy Report - Year 2 Quarter 2-2013.pdf', '2025-04-29 10:20:32', '5FC1d4OmJoiTySuLZLyuxyZZvsVUmvezGy3'),
(123, 'DISCOVER Narrative Report - Year 2 Quarter 2', '250429102127_DISCOVER Narrative Report - Year 2 Quarter 2.pdf', '2025-04-29 10:21:27', 'GtFSz5XTdOpfFhloK6Lug5oXaqLRhstN92s0KWENy5SF'),
(124, 'Malawi Vulnerability Assessment Committee Report_June-13 2013', '250429102237_Malawi Vulnerability Assessment Committee Report_June-13 2013.pdf', '2025-04-29 10:22:37', 'anoUpD4sB9F'),
(125, 'Malawi Nutrition Rehabilitation Units NRUs Assessment Report September 2015', '250429102713_Malawi Nutrition Rehabilitation Units NRUs Assessment Report September 2015.pdf', '2025-04-29 10:27:13', 'myWav7zEqearEFDkyKFX9NVJ4F5h'),
(126, 'UNDAC 2015 Floods Assessment Report-Feb 6 2015 ', '250429102951_UNDAC 2015 Floods Assessment Report-Feb 6 2015 .pdf', '2025-04-29 10:29:51', 'HROkTPIGicEvcUXCDmMznxyrtfTOcOtS2jtuI0NaUxB7voD2PKDk0fvv2'),
(127, 'National progress report on the implementation of the Hyogo Framework for Action-March ', '250429103101_National progress report on the implementation of the Hyogo Framework for Action-March .pdf', '2025-04-29 10:31:01', 'G9o4HLfT5dA9MAp7kWTSYiHI'),
(128, 'Malawi International Disaster Response Law Report Draft LR-2015', '250429103511_Malawi International Disaster Response Law Report Draft LR-2015.pdf', '2025-04-29 10:35:11', 'iy0QOyIFtbsKf51zjifHfS8bqYK7ZDJflusYjxwQ'),
(129, 'Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi', '250429103652_Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi.pdf', '2025-04-29 10:36:52', 's6r0gNfNOyI8NzxVckHUmeuYaKEruERzx1fpf7zm'),
(130, 'Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi', '250429103745_Assessment report on mainstreaming and implementing disaster risk reduction measures in Malawi.pdf', '2025-04-29 10:37:45', '2OKsGblTuxyOnt6tz1cpDSBuYdaJIxrC7aak4XG3e829KIwOy8H8'),
(131, 'Malawi 2015 Floods Post Disaster Needs Assessment Report', '250429104032_Malawi 2015 Floods Post Disaster Needs Assessment Report.pdf', '2025-04-29 10:40:32', '4zmvuQE79X'),
(132, 'Second quartery Progress Report on The Disaster Risk Management Programme Support-August 25 2016', '250429104244_Second quartery Progress Report on The Disaster Risk Management Programme Support-August 25 2016.pdf', '2025-04-29 10:42:44', 'pLrsOccV1YljH3'),
(133, 'Malawi Drought 2015-2016 Post-Disaster Needs Assessment (PDNA)', '250429110924_Malawi Drought 2015-2016 Post-Disaster Needs Assessment (PDNA).pdf', '2025-04-29 11:09:24', 'Aca5ZY578Ly'),
(134, 'Enhancing Communities’ Resilience Programme (ECRP) in Malawi-2017', '250429111303_Enhancing Communities’ Resilience Programme (ECRP) in Malawi-2017.pdf', '2025-04-29 11:13:03', 'cyavFy03XOCcbLFNl1Hx2sjTjDieWNA7VijxHK'),
(135, 'Malawi Community Based Resilience Analysis (CoBRA) Assessment Report - Zomba, Nkhata Bay and Ntcheu_Final_May2017', '250429111631_Malawi Community Based Resilience Analysis (CoBRA) Assessment Report - Zomba, Nkhata Bay and Ntcheu_Final_May2017.p', '2025-04-29 11:16:31', '3SGpcKHaqbLvSe4PjsrDQzlp0hz8wNldL9C494WqDs'),
(136, 'UNDP-Final Evaluation Report of the Disaster Risk Management Programme August 12 2017', '250429111906_UNDP-Final Evaluation Report of the Disaster Risk Management Programme August 12 2017.pdf', '2025-04-29 11:19:06', '8BTuGIhzxScAmruCjxaFQjhmER9CEwaycduyOpduGLODVc3jWxSYwi7KPKoa'),
(137, 'DoDMA Capacity Assessment - Final Report- 2017', '250429112012_DoDMA Capacity Assessment - Final Report- 2017.pdf', '2025-04-29 11:20:12', 'R4XA0Kd8h0P7J8vkhJ5V79pNjzTcEfNoccvTu0ZRMDAZ'),
(142, 'UNICEF WFP Collaboration Emergency Nutrition Response-Nov 2018', '250429114534_UNICEF WFP Collaboration Emergency Nutrition Response-Nov 2018.pdf', '2025-04-29 11:45:34', 'acazxCzHR0pBNIzfPDJJd1kF5Di'),
(143, 'Comprehensive Baseline Assessment of Disaster Risk Management in Malawi-2018', '250429114730_Comprehensive Baseline Assessment of Disaster Risk Management in Malawi-2018.pdf', '2025-04-29 11:47:30', 'JPUwiQ4uKUHMCQoMBJcoQ8TQMbw22MGqo7cMjvt8r5uwyo0Bgnx6'),
(144, 'Chikwawa District Floods Situation report 11th March 2019', '250429114817_Chikwawa District Floods Situation report 11th March 2019.pdf', '2025-04-29 11:48:17', 'H406pS9K8sNcbOJcvyVmCPpqOcKDLvHjWhvWVedGL'),
(145, 'Adaptation to Climate Change in the Nkhota-kota District of Malawi-April 2019', '250429114852_Adaptation to Climate Change in the Nkhota-kota District of Malawi-April 2019.pdf', '2025-04-29 11:48:52', 'O6Oiu0VprJkdYWZy9deYsZfZ677wJIxfAR5FDkRPTfa'),
(146, 'Climate Change Adaptation Funding Mechanisms in Malawi Report-April 2019', '250429115003_Climate Change Adaptation Funding Mechanisms in Malawi Report-April 2019.pdf', '2025-04-29 11:50:03', 'V5SKWub5tLMLEv0ToG5fSMCHcaIeeztip7BChQRCgYKqvJx2OPHAieuFoG1V'),
(147, 'IPC Integrated Food Security Phase Classification _August-2019', '250429115220_IPC Integrated Food Security Phase Classification _August-2019.pdf', '2025-04-29 11:52:20', 'qKmH0GRKpryOVrmsd4uVjOMo'),
(148, 'Humanitarian Coordinator Report on the Use of Cerf Funds; Rapid Response Cyclone Idai- 2019', '250429115535_Humanitarian Coordinator Report on the Use of Cerf Funds; Rapid Response Cyclone Idai- 2019.pdf', '2025-04-29 11:55:35', '9MXuq36NTtb'),
(150, 'Tropical Cyclone IDAI Multi-Sectral Location Assessment-Chikwawa, Nsanje, Phalombe, Zomba Districts-Round III-May-3 2019', '250429115915_Tropical Cyclone IDAI Multi-Sectral Location Assessment-Chikwawa, Nsanje, Phalombe, Zomba Districts-Round III-May-3', '2025-04-29 11:59:15', 'KMGGXdfQEKr73vIBOTtKPAbzO9S9aPdnu3T8MxWLwArpy'),
(151, 'Malawi 2019 Floods Post Disaster Needs Assessment Report', '250429120027_Malawi 2019 Floods Post Disaster Needs Assessment Report.pdf', '2025-04-29 12:00:27', '4UpkxEFNho59jec185hneiQND'),
(152, 'The Integrated Risk Management Programme. lessons from mw-June 2020', '250429120313_The Integrated Risk Management Programme. lessons from mw-June 2020.pdf', '2025-04-29 12:03:13', 'zRJXg4srFOv61YXTh2FAJSToKfNaRcOX'),
(153, 'The impact of Cyclone Idai Final- 2020', '250429120412_The impact of Cyclone Idai Final- 2020.pdf', '2025-04-29 12:04:12', '8XUDa4DWtRfLvOJEICClDkE2jrK0F3Q5hT8SFk1Xip0LXkcE8iC'),
(154, 'Malawi The Cost of Hunger Summary Report ', '250429120606_Malawi The Cost of Hunger Summary Report .pdf', '2025-04-29 12:06:06', 'WanQSmZPattf3MAmQlWJJ6jWOXAyeGC3gZozynlTfFVE'),
(155, 'Evaluation of the project Strengthening Community Resilience to Climate Change in Blantyre, Zomba, Neno and Phalombe-2021', '250429121148_Evaluation of the project Strengthening Community Resilience to Climate Change in Blantyre, Zomba, Neno and Phalomb', '2025-04-29 12:11:48', 'zgiOieniksrDK3nrwessejjJaWUyO6wi65b2rdfo'),
(156, 'An assessment of Malawi Media in Disaster Risk Reduction- The Case of Cyclone IDAI 2021', '250429121347_An assessment of Malawi Media in Disaster Risk Reduction- The Case of Cyclone IDAI 2021.pdf', '2025-04-29 12:13:47', 'jWrbZPZI1nRp2JxGAuE6v9vPJ'),
(157, 'A Cost-Benefit Analysis of Environmental Management and Disaster Risk Reduction in Malawi - Technical Report 2021', '250429121429_A Cost-Benefit Analysis of Environmental Management and Disaster Risk Reduction in Malawi - Technical Report 2021.p', '2025-04-29 12:14:29', 'njSQYk7bql9'),
(158, 'Malawi National Human Development Report 2021', '250429121613_Malawi National Human Development Report 2021.pdf', '2025-04-29 12:16:13', 'T6G8YpBc'),
(159, 'UNICEF Malawi Emergency Response Situation Report 28 January 2022', '250429121950_UNICEF Malawi Emergency Response Situation Report 28 January 2022.pdf', '2025-04-29 12:19:50', 'jum6qzrpIzH8sxR9wD7jSls69KFaVvFfgQACUaRqH'),
(160, 'Rapid Gender Analysis of Disaster Risk Management in Malawi-2022', '250429122123_Rapid Gender Analysis of Disaster Risk Management in Malawi-2022.pdf', '2025-04-29 12:21:23', '3cSYqhC0CwlpyWm1PZ6CHmtYJTedLO8s2IVs4uJFK'),
(161, 'Consolidated Report CYCLONE ANA 2022. 2.1', '250429122321_Consolidated Report CYCLONE ANA 2022. 2.1.pdf', '2025-04-29 12:23:21', 'pU8PrdF4CiBkV3OBEgRgidH'),
(162, 'Malawi 2022 Voluntary National Review Report for Sustainable Development Goals (SDGs)', '250429122806_Malawi 2022 Voluntary National Review Report for Sustainable Development Goals (SDGs).pdf', '2025-04-29 12:28:06', 'OJi5'),
(163, 'Cyclone-Freddy-Mapping-Final-Report 2023', '250429122944_Cyclone-Freddy-Mapping-Final-Report 2023.pdf', '2025-04-29 12:29:44', 'JxKDxgqXUDlwOjF96A0P'),
(164, 'Strengthening Smallholder Farmer Resilience, Responding to COVID-19 and Eliminating Food Poverty Impact Evaluation Report-', '250429123109_Strengthening Smallholder Farmer Resilience, Responding to COVID-19 and Eliminating Food Poverty Impact Evaluation ', '2025-04-29 12:31:09', 'p78jBIrcsO5gqH3i6PSq3lxnUyv7YF1g'),
(165, 'UNICEF Malawi Humanitarian Situation Report No 1 Updates from 1 January to 15 March 2023', '250429123316_UNICEF Malawi Humanitarian Situation Report No 1 Updates from 1 January to 15 March 2023.pdf', '2025-04-29 12:33:16', '7KOy4h4xPRaTZ'),
(166, 'IFRC Tropical Storm Ana Report 2023', '250429123442_IFRC Tropical Storm Ana Report 2023.pdf', '2025-04-29 12:34:42', 'rNYrx'),
(167, 'Community-led Resource Mobilization and Early Warning Systems Process Assessment Report ', '250429123606_Community-led Resource Mobilization and Early Warning Systems Process Assessment Report .pdf', '2025-04-29 12:36:06', 'kEchjlZpIaPvLPgzcsk3YNFuMH8ORvFwOsa5RRqLMndHmoxZ77k1PgV'),
(168, 'Economic Impacts of Climate Change.', '250429123710_Economic Impacts of Climate Change..pdf', '2025-04-29 12:37:10', '1YE5n3YrvJ'),
(169, 'Malawi Climate and Health Vulnerability Assessment', '250429123930_Malawi Climate and Health Vulnerability Assessment.pdf', '2025-04-29 12:39:30', 'Na4S0MEIuV5czRpzLf24XLIzCLWPLqsarJ5'),
(170, 'Malawi_ Tropical Cyclone Freddy Flash Update No. 1 16 March', '250429124018_Malawi_ Tropical Cyclone Freddy Flash Update No. 1 16 March.pdf', '2025-04-29 12:40:18', 'cnQw'),
(171, 'Tropical Cyclone Freddy After Action Review Report 2023', '250429124621_Tropical Cyclone Freddy After Action Review Report 2023.pdf', '2025-04-29 12:46:21', 'nI3wbWLERlRsZOdv794oOcIXCFuhKoktucmKWmD9FiWk31gF1wEgbb'),
(172, 'Tropical Cyclone Freedy Inter Agency Assessment Report_March-13 2023', '250429124739_Tropical Cyclone Freedy Inter Agency Assessment Report_March-13 2023.pdf', '2025-04-29 12:47:39', 'K1Z7gUPbLBqM8FSjf85HUvhF38ttmYne7FqmuXI9i4qCcofbYuESttsr9lVd'),
(173, 'Tropical Cyclone Freddy Post Disaster Needs Assessment Government of Malawi', '250429124846_Tropical Cyclone Freddy Post Disaster Needs Assessment Government of Malawi.pdf', '2025-04-29 12:48:46', '47gdE0DBAslud7gdJ'),
(174, 'MRC Multi-Sectoral Detailed Needs Assessment Report on Floods in Karonga District-Feb 2024', '250429125030_MRC Multi-Sectoral Detailed Needs Assessment Report on Floods in Karonga District-Feb 2024.pdf', '2025-04-29 12:50:30', 'lSBSB9QwIZPGxPaLoXuzN11KEZD'),
(175, 'Malawi-El-Nino-Situation Report-May 2024', '250429125155_Malawi-El-Nino-Situation Report-May 2024.pdf', '2025-04-29 12:51:55', 'qhMZhPHaBSLIwAzuFSAd89iDr3RprRCIQ'),
(176, 'Assessment Mechanisms for Supporting Loss and Damage Financing - 2024', '250429125409_Assessment Mechanisms for Supporting Loss and Damage Financing - 2024.pdf', '2025-04-29 12:54:09', 'bKw6p4ywLFSTyMzjZvnFqqKP8g'),
(177, 'Emergency Preparedness and Response Roadmap 2023 to 2025 yr 1 Progress Report', '250429125520_Emergency Preparedness and Response Roadmap 2023 to 2025 yr 1 Progress Report.pdf', '2025-04-29 12:55:20', 'AagpB7493XJIONiPPUfLDbOB8'),
(178, 'UNDRR Annual Report- 2024', '250429125630_UNDRR Annual Report- 2024.pdf', '2025-04-29 12:56:30', 'XMBXr079zMG4cozyRXV9xBEyOnf5ex2YK'),
(181, 'Malawi Floods 2024 - DREF Final Report (MDRMW020)', '250513094558_Malawi Floods 2024 - DREF Final Report (MDRMW020).pdf', '2025-05-13 09:45:58', 'USwbt1eDUxD5QUUj6UDBsLNrahICWNJPLVlFmI'),
(182, 'Baseline Assessment of Drought Impact Monitoring', '250527101132_Baseline Assessment of Drought Impact Monitoring.pdf', '2025-05-27 10:11:32', 'Bbt1c6dDCdzsYRdE'),
(183, 'Tropical Cyclone Jude Situation Report-11_03_2025', '250617015933_Tropical Cyclone Jude Situation Report-11_03_2025.pdf', '2025-06-17 13:59:33', 'OI1lqjLsANHCivnWS74iclgb9BV67vLLoERQiCIA2nCSYDfhzacBoX4oIIa'),
(184, 'UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025', '251109094020_UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025.pdf', '2025-11-09 21:40:20', 'j5Fn6qEosE6How8T32K087xtRDAFCeoJpXrKSN8'),
(191, 'Final Evaluation of Adapting to Climate Change through Integrated Risk Management Strategies and Enhanced Market Opportunities f', '251109095628_Final Evaluation of Adapting to Climate Change through Integrated Risk Management Strategies and Enhanced Market Op', '2025-11-09 21:56:28', '0nP9EgeaYcs8IKZyT1UVgR8r72'),
(192, 'Malawi AA National Dialogue Platform 2024 FINAL Report', '251109095711_Malawi AA National Dialogue Platform 2024 FINAL Report.pdf', '2025-11-09 21:57:11', 'l3nT7cWeVUOe3ef9NcykGoMwqYj6XA9YkLIX'),
(193, 'WFP Malawi Country Brief - January 2025', '251109095730_WFP Malawi Country Brief - January 2025.pdf', '2025-11-09 21:57:30', 'k5b0D3YfYL6cJVMy6rnR'),
(194, 'Malawi-Humanitarian-SitRep-No.1-01-January-31-March-2025.pdf', '251109095829_Malawi-Humanitarian-SitRep-No.1-01-January-31-March-2025.pdf.pdf', '2025-11-09 21:58:29', 'x5bG'),
(195, 'Malawi Resilience and Disaster Risk Management Project Implementation Completion and Results Report 2025', '251109095912_Malawi Resilience and Disaster Risk Management Project Implementation Completion and Results Report 2025.pdf', '2025-11-09 21:59:12', 'uC2eZ1IKB7LEp8f5yX'),
(196, 'Gap Analysis Report- Climate and Disaster Risk Finance in Malawi-2025', '251109095940_Gap Analysis Report- Climate and Disaster Risk Finance in Malawi-2025.pdf', '2025-11-09 21:59:40', 'RR3v1xjPZ82AMJibQ95skhPMI4TOI3WY0fOoHigWwooIIMD'),
(197, 'UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025', '251109100121_UNICEF Malawi Humanitarian Situation Report No. 3, July - September 2025.pdf', '2025-11-09 22:01:21', 'Hw24hIMeVfMwkfeK8WFeZHeNpL'),
(198, 'DREF 2025 Food Insecurity Report', '251109100219_DREF 2025 Food Insecurity Report.pdf', '2025-11-09 22:02:19', 'TVZ5uhz'),
(199, 'World Risk Report (Floods)', '251123063840_World Risk Report (Floods).pdf', '2025-11-23 18:38:40', 'W3X1Zf6to1T9da3BCwDapScxRsEysMyfMpZNO');

-- --------------------------------------------------------

--
-- Table structure for table `saccos`
--

CREATE TABLE `saccos` (
  `sacco_id` int(11) NOT NULL,
  `sacco_name` varchar(128) NOT NULL,
  `region_id` int(11) NOT NULL,
  `location` varchar(128) NOT NULL,
  `address` varchar(1028) DEFAULT NULL,
  `phone` varchar(60) DEFAULT NULL,
  `email` varchar(60) DEFAULT NULL,
  `contact_person` varchar(60) NOT NULL,
  `url` varchar(128) DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `saccos`
--

INSERT INTO `saccos` (`sacco_id`, `sacco_name`, `region_id`, `location`, `address`, `phone`, `email`, `contact_person`, `url`, `date`) VALUES
(23, 'YATHU SACCO', 1, 'Blantyre', 'P.O. Box 5052, Limbe', '0888860680', 'cmotomoto@yahoo.co.uk', 'Chrissie Motomoto', 'https://admarcsacco.com/', '2023-08-28 19:10:07'),
(24, 'FUTURE SACCO', 1, 'Blantyre', 'P.O. Box 30548, Chichiri, Blantyre 3', '0888987790', 'tmindozo@futuresacco.com', 'Tendai Mindozo', 'http://www.futuresacco.com/', '2023-08-28 19:12:19'),
(25, 'MUDI SACCO', 1, 'Chichiri', 'P.O. Box 31229, Chichiri, Blantyre 3', '0999920954/0111625354', 'tsigat@yahoo.com', 'Triza Magreta', 'http://www.mudisaccomw.com/', '2023-08-28 19:13:53'),
(26, 'POLYMED SACCO', 1, 'Blantyre', 'P/B 303, Chichiri, Blantyre 3', '0999688710', 'mtbokosi@gmail.com', 'Mary Bokosi Musona', '', '2023-08-28 19:15:55'),
(27, 'PCL GROUP SACCO', 1, 'Blantyre', 'P.O. Box 30402, Chichiri, Blantyre 3', '0882228419', 'info@pclgroupsacco.com', 'Brandy Bande', 'https://www.pclgroupsacco.com/', '2023-08-28 19:17:34'),
(28, 'SUNBIRD SACCO', 1, 'Blantyre', 'P.O. Box 284, Blantyre', '01820804/ 0995105213', 'sharon@sunbirdsacco.com', 'Sharon Taona Kalea', 'http://sunbirdsacco.com/', '2023-08-28 19:39:15'),
(29, 'Mphuzitsi SACCO', 1, 'Thyolo', 'P.O. Box 175, Thyolo', '+265888066900', 'Jptembo@thyoloteacherssacco.mw', 'James Tembo', '', '2023-08-28 19:41:26'),
(34, 'CHILUNGAMO SACCO', 1, '-', '', '0999615677', 'pchimukho@gmail.com', 'Pilirani Chimukho', '', '2023-08-28 19:45:53'),
(36, 'CHITUKUKO SACCO', 2, 'Lilongwe', 'P.O. Box 651, Lilongwe', '0999042232', 'eveness.mtowa@chitukukosacco.mw', 'Eveness Butawo Mtowa', 'http://www.chitukukosacco.com/', '2023-08-28 20:33:51'),
(38, 'MZINDA SACCO', 2, 'Lilongwe', 'P.O. Box 30396, Lilongwe', '0888546399', 'amaznyale@yahoo.co.uk', 'Maxwel Nyale', '', '2023-08-28 21:13:26'),
(39, 'KANDIYA SACCO', 2, 'Lilongwe', 'P/B 6, Lilongwe', '0997221980', 'pmwankenja@gmail.com', 'Paul Mwankenja', '', '2023-08-28 21:14:42'),
(40, 'FODYA SACCO', 2, 'Lilongwe', 'P.O. Box 40048, Lilongwe', '888364205', 'loycechinangwa@gmail.com', 'Loyce Chinangwa', 'http://www.fodyasacco.com/', '2023-08-28 21:17:30'),
(41, 'UN SACCO', 2, 'Lilongwe', 'P.O. Box 30135, Lilongwe', '+265888528873', 'jaymaluwa899@gmail.com', 'Jayne Maluwa', '', '2023-08-28 21:24:06'),
(42, 'UMODZI SACCO', 2, 'Lilongwe', 'P.O. Box 709, Lilongwe', '0995500454', 'echinjala@yahoo.com', 'Eliza Chinjala', '', '2023-08-28 21:25:01'),
(43, 'DWANGWA SACCO', 2, 'Dwangwa', 'P.O. Box 46, Dwangwa', '0999248724', 'trezamalata@broadbandmw.com', 'Treza Malata', '', '2023-08-28 21:25:58'),
(44, 'TIPINDULE COMMUNITY SACCO', 2, 'Mponela', 'P.O. Box 131, Mponela', '0999314796', 'tipindulesacco@gmail.com', 'Atusaye Mwakhwawa', '', '2023-08-28 21:26:59'),
(45, 'Dedza Teachers SACCO', 2, 'Lilongwe', 'P.O. Box 459, Lilongwe', '0995496135', 'jlonjezo@gmail.com', 'Lonjezo Josiah', '', '2023-08-28 21:27:47'),
(46, 'Mchinji Civil Service SACCO', 2, 'Mchinji', '', '0999953992', 'manganimike@gmail.com', 'Michael Mangani', '', '2023-08-28 21:28:59'),
(47, 'Kuwala SACCO', 2, 'Lilongwe', 'P.O. Box 40035, Lilongwe', '0888727318', 'gkandiona@yahoo.com', 'Grace Kandiwona', 'http://www.ahlsaccomw.com/', '2023-08-28 21:40:31'),
(49, 'LIMBE LEAF SACCO', 2, '-', 'Christobel Mbeya		0882211491', '0882211491', 'info@lltcsacco.mw', 'Christobel Mbeya', '', '2023-08-28 21:44:00'),
(50, 'POLICE SACCO', 2, 'Lilongwe', '', '0997245286', 'ianmwalungila@gmail.com', 'Ian Mwalungila', 'http://www.malawipolicesacco.com/', '2023-08-28 21:45:11'),
(51, 'PLAN MALAWI SACCO', 2, 'Lilongwe', 'Jimmy Kanyangala', '0991656969', 'kanyangalaj@gmail.com', 'Jimmy Kanyangala', '', '2023-08-28 21:49:20'),
(52, 'LUANAR SACCO', 2, 'Bunda, Lilongwe', 'Bunda, Lilongwe', '0999375014', 'vincentchinomba@gmail.com', 'Vincent Chinomba', '', '2023-08-28 21:50:21'),
(53, 'KASUPE SACCO', 2, '-', '', '0882364515', 'kasupesacco@yahoo.com', 'Florence Mtika', '', '2023-08-28 21:51:32'),
(54, 'M-UNITY SACCO', 2, 'Lilongwe', '', '0999922870', 'neema.kachali@yahoo.com', 'Neema Kachali', '', '2023-08-28 21:53:39'),
(55, 'MSILIKALI SACCO', 2, 'Lilongwe', '', '0887099426', 'vtembo@msilikalisacco.org', 'Venge Tembo', 'http://msilikalisacco.org/', '2023-08-28 21:55:06'),
(59, 'Rumphi Teachers SACCO', 3, 'Rumphi', 'P.O. Box 26, Rumphi', '0888571773', 'kumwendaulemu@yahoo.com', 'Ulemu Kumwenda', '', '2023-08-28 22:24:29'),
(61, 'United Civil Servants SACCO', 3, 'Mzimba', 'P.O. Box 194, Mzimba', '0888544765', 'fwaliwa@gmail.com', 'Francis Waliwa', '', '2023-08-28 22:30:22'),
(62, 'MZUZU UNIVERSITY SACCO', 3, 'Mzuzu', 'P.O. Box 2, Luwinga, Mzuzu', '0999667738/ 0888940696', 'kachondekathy@yahoo.com', 'Catherine Kachonde', '', '2023-08-28 22:31:24'),
(63, 'Kawiruwiru SACCO', 3, 'Mzuzu', 'P/B 94, Mzuzu', '0888300444', 'kayangejoyce@yahoo.com', 'Joyce Kayange', '', '2023-08-28 22:32:50'),
(66, 'SUCOMA SACCO', 1, 'Chikhwawa', 'Private Bag 50 Nchalo', '01425215/0888861133', 'sucomasacco@gmail.com', 'Malizani Gamaliel', '', '2023-11-15 14:07:00'),
(72, 'KASO Sacco', 2, 'Lilongwe', 'P.O.Box 132 Lilongwe', '0997002288', 'mawangaprecious@gmail.com', 'Precious Mawanga', '', '2024-06-24 09:59:01'),
(73, 'Chipatala Sacco', 2, 'Lilongwe', '', '0993040426', 'manenomzumala@gmail.com', 'Maneno Mzumara', '', '2024-06-24 10:00:10'),
(74, 'Febco SACCO', 2, 'Lilongwe Old Town', '', '0993705679', '', 'Ethel Musopole', '', '2024-06-24 10:04:47'),
(75, 'Light House Sacco', 2, 'Lilongwe Kamuzu Central Premises', '', '0993994445', 'mayendaj@gmail.com', 'Josephine Mayenda', '', '2024-06-24 10:06:07'),
(76, 'UNC Sacco', 2, 'Lilongwe UNC Premises', '', '0992657413', 'mhangosolister56@gmail.com', 'Solicitor Mhango', '', '2024-06-24 10:07:08'),
(77, 'Mwato Sacco', 3, 'Nkhatabay', '', '0888859089', 'bmzumara@gmail.com', 'Blessings mzumara', '', '2024-06-24 10:12:23'),
(78, 'Fincoop SACCO', 2, 'Lilongwe', 'P.O.Box 651 Lilongwe', '0999395098', 'mnankhonya@fincoopmw.org', 'McMillan Nankhonya', 'https://www.fincoopmw.org', '2024-06-24 10:24:14'),
(79, 'Solinica SACCO', 3, 'Mzuzu', '', '0999707472', '', 'Rev Vunda Mhango', '', '2024-06-24 10:34:37');

-- --------------------------------------------------------

--
-- Table structure for table `sacco_statistics`
--

CREATE TABLE `sacco_statistics` (
  `stat_id` int(11) NOT NULL,
  `title` varchar(1028) NOT NULL,
  `file` varchar(128) NOT NULL,
  `type` int(11) NOT NULL DEFAULT 1,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `sacco_statistics`
--

INSERT INTO `sacco_statistics` (`stat_id`, `title`, `file`, `type`, `date`) VALUES
(70, '30 Innovations for Disaster Risk Reduction', '250429064052_30 Innovations for Disaster Risk Reduction.pdf', 2, '2025-04-29 06:40:52'),
(72, 'Status of Science and Technology in Disaster Risk Reduction in Asia Pacific 2024', '250429093736_Status of Science and Technology in Disaster Risk Reduction in Asia Pacific 2024.pdf', 2, '2025-04-29 09:37:36'),
(73, 'Innovation in Disaster Management (UNDP , OCHA)', '250429093919_Innovation in Disaster Management (UNDP , OCHA).pdf', 2, '2025-04-29 09:39:19');

-- --------------------------------------------------------

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `service_id` int(11) NOT NULL,
  `title` text NOT NULL,
  `details` longtext NOT NULL,
  `posted_by` varchar(60) NOT NULL,
  `image` varchar(128) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`service_id`, `title`, `details`, `posted_by`, `image`, `status`, `date`) VALUES
(19, 'Capacity Building ', '<p><strong>CDI</strong> capacity building provision for solicited courses/sessions uses three consultations levels which are;&nbsp;Basic Technical Capacity Building,&nbsp;Technical Capacity Development, and&nbsp;Intensive Technical Capacity Development.&nbsp;Costs for such services are varied depending on customer needs.&nbsp;<br /></p>\r\n<p>General cooperatives and financial cooperatives specific training are delivered following a pre designed curriculum which clients can apply or request to delivered as inhouse or attending an arranged training session. Provision for online or virtual session are provided on need basis for this capacity building component.</p>\r\n\r\n<p><br /></p>', '23', '1692639412_service.jpg', 1, '2023-08-21 17:36:52'),
(20, 'Central Finance Facility', '<p>The purpose of the CFF is to provide the affiliate SACCOs with a liquidity management system and a source of short-term financing.&nbsp; It also affords the affiliated SACCOs main banking facilities where they invest and borrow at a competitive rate of return.&nbsp; The facility is also designed to mop up liquidity (in both shares and deposits) from SACCOs and to pay a competitive rate of return.&nbsp; CFF products and services include;\r\n\r\n  <br /></p>', '23', '1692639655_service 2.jpg', 1, '2023-08-21 17:40:55'),
(21, 'Consultancy Service', '<p>CDIâ€™s consulting service is to provide expert cooperatives, organizational and consulting solutions to ensure our clients make informed decisions, based on reliable information. We assist our clients in increasing the top-line as well as the bottom-line by improving processes and approaches in line with clientâ€™s business philosophy. With many years of experience in Cooperatives development that CDI Consultants have drawn from a wider Malawi Cooperative sector, we optimize and problem-solve any process.\r\n\r\n  <br /></p>', '23', '1692639819_service.jpg', 1, '2023-08-21 17:43:39'),
(22, 'Research', '<p>The institute undertakes research in a wide range of areas besides cooperatives. On cooperatives CDI continue to search for approaches that can support sustainable growth of cooperatives in Malawi and contribute to continental cooperative development. To this end, CDI liaises with the continental Africa Cooperative Development Foundation (ACDF) and local universities for knowledge sharing in in-depth policy and problem â€“centred research with a view of providing recommendations that refocus member-based organizations options and direction.&nbsp;&nbsp;<br />\r\n\r\n  <br /></p>', '23', '1692639935_research .jpg', 1, '2023-08-21 17:45:35'),
(23, 'Cooperatives Development Institute (CDI)', '<p><b>COOPERATIVES DEVELOPMENT INSTITUTE (CDI)</b> is a skills development hub and research institute established based on the long experience of cooperatives development, research and training in Malawi and abroad by cooperatives practitioners. The institute has a broaden delivery scope to ably contribute to domestic driven development founded on self help and support. CDI services are for member-based organizations at both micro and macro levels, programmes/projects, trade associations, individuals and researchers.&nbsp; To capacitate micro level member-based organizations, <b>Cooperatives\r\nDevelopment Institute (CDI)</b> uses rights based and participatory approaches to mobilize, advocate for and facilitate community dialogue and action. For general cooperatives training, a modular course has been designed that is delivered in workshops and also with an option of online/virtual delivery.&nbsp; </p>\r\n<h4>&nbsp;WHY WORK WITH COOPERATIVES DEVELOPMENT INSTITUTE\r\n\r\n</h4>\r\n<p>CDI has pooled experts from both public and private sector in and not limited to cooperatives development, academia, research, strategy development, rural outreach approaches, finance, agriculture, gender and climate financing.</p>\r\n\r\n<p><br /></p>', '23', '1692640260_research .jpg', 1, '2023-08-21 17:51:00'),
(24, 'Technical and Administrative Support', '<p>MUSCCO provide technical and administrative support through facilitation of technology transfer, staff search and placements, products design, business strategies reviews, advisory services, standardization of operations and systems.\r\n\r\n  <br /></p>', '23', '1692640331_service.jpg', 1, '2023-08-21 17:52:11'),
(25, 'Representation and Advocacy', '<p>MUSCCO as part of strengthening the financial cooperatives sector, does represent its members in different fora both local and international where sector interests are presented through dialogue and position papers presentation, and also advocate for an enabling operating environment by ensuring that the legal framework is supportive of growth of SACCOs.&nbsp;\r\n\r\n  <br /></p>', '23', '1692640589_Untitled-4.jpg', 1, '2023-08-21 17:56:29');

-- --------------------------------------------------------

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` int(11) NOT NULL,
  `link` varchar(60) NOT NULL,
  `email` varchar(128) NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `subscribers`
--

INSERT INTO `subscribers` (`id`, `link`, `email`, `status`, `date`) VALUES
(1, '3yvU1gc5xH7k1hVsRiCBKK31qnCBR0ak3j6iT2ToW', 'chawe@hotmail.com', 0, '2022-05-23 12:24:20'),
(2, 'nzcQ3TWMhaGfVQ4lOfZ', 'wezmhango@hotmail.com', 1, '2022-05-24 11:22:09'),
(3, 'VRWNBHrn9', 'mwezzie@gmail.com', 0, '2022-05-24 11:22:16'),
(4, 'jyVwEJ5EnpK35XulGtY9N8xBKbalP9PPRgyX6Er9qFq', 'khumbiro@gmail.com', 0, '2022-05-30 09:18:15'),
(5, '3HwrA', '', 0, '2023-07-25 11:36:05'),
(6, 'dKnwtzKyq1G0tJhBJufDjKfGYOo79afjg6n7oZr5Sz37Fex0QAvE', '', 0, '2023-07-25 11:37:10'),
(7, 'R80ww8hO60WjpnJsje0G', '', 0, '2023-07-25 11:38:03'),
(8, 'Il6sBJ8ByUHrd5BD6DFSFS84m0W8x9R1VL5T0lux7afAXBJ05mAiywnsiok0', 'wezmhango@hotmail.com', 0, '2023-07-25 11:38:15'),
(9, 'ZAa4V6PKcF', 'ametakpaul@icloud.com', 0, '2023-07-25 11:40:20'),
(10, 'C9wrasfRnXF8fWNu', 'ametakpaul@icloud.com', 0, '2023-07-25 11:40:53'),
(11, 'Sx77r2s32', 'francis@macoha.mw', 0, '2023-07-25 11:41:14'),
(12, 'yrU1vWtKNHZNuqB6ZQxXdxkDiWUk', 'chikandakondwani@gmail.com', 0, '2023-07-25 11:42:01'),
(13, 'NLy964mPWxO8aWmRNUtlQRJHC9595ZXuj2okChsCYTWAW', 'ametakpaul@icloud.com', 0, '2023-07-25 11:42:16'),
(14, 'tPijyfDtVumMtD4F9263g9GvnQgzRvoe3P5wZPhD68Y0UL0v2T4v2z3hm', 'ametakpaul@icloud.com', 0, '2023-07-25 11:44:27'),
(15, 'G3u4Ai2pv9IIC37gc1cVCVD17x', 'eve@macoha.mw', 0, '2023-07-25 11:45:11'),
(16, '2bZaQoA6b5nDd2zKyoy53IW46T', 'wezmhango@hotmail.com', 0, '2023-07-25 11:45:37'),
(17, '1ho29PAat7jYu0BwO0gR7OhwSfiYVyBhUQh1KaTLGxzyIRtA9GA4Un0k', 'dkananza@quantacubeenergy.com', 0, '2023-07-25 11:53:51'),
(18, 'u86fbdxKnapErTjzkEi7VXwIqOlE', 'ob@gmail.com', 0, '2023-08-04 21:21:53'),
(19, 'MhwE7OR', 'kg@gmail.com', 0, '2023-08-19 12:15:15'),
(20, '2T4DDG9Xc4OTQxx01ADDSi3sIbT7HVpHBjJ9BncDB', 'kh6@yahoo.com', 0, '2023-08-19 12:15:28'),
(21, 'ihAQNs0zvAyry1Pm06oJC4ywXrzAynEm4DKvS5cyG', 'cathy@obdesign.com', 0, '2023-08-20 19:22:04'),
(22, 'gcLNo07qQwwSMV3neR8h', 'owen89@gmail.com', 0, '2023-08-21 22:57:51');

-- --------------------------------------------------------

--
-- Table structure for table `success_stories`
--

CREATE TABLE `success_stories` (
  `story_id` int(11) NOT NULL,
  `link` varchar(60) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `details` longtext NOT NULL,
  `thumb` varchar(128) NOT NULL,
  `image` varchar(128) NOT NULL,
  `posted_by` int(11) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp(),
  `status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `success_stories`
--

INSERT INTO `success_stories` (`story_id`, `link`, `title`, `details`, `thumb`, `image`, `posted_by`, `date`, `status`) VALUES
(1, 'oiqipUomPfrngrRBoKm', 'Chawezi the brains behind tikhute app', '<div>\r\n  <p><strong>Malawi Blood Transfusion Service (MBTS)</strong></p>\r\n</div>\r\n<div>\r\n  <p>Malawi Blood Transfusion Service (MBTS) is a Trust&nbsp;that was established to provide a safe and adequate&nbsp;supply of blood and blood products to meet the needs&nbsp;of all patients in authorised hospitals in Malawi. It&nbsp;is committed to meet its objective of collecting,&nbsp;processing and testing all blood from voluntary non-remunerated blood donors in low-risk populations to&nbsp;international standards, in a cost efficient manner.</p>\r\n  <p>The MBTS is seeking suitable candidates to fill the following vacant post:</p>\r\n  <p><strong>Driver (3 Positions)</strong>&nbsp;tenable at Lilongwe Office</p>\r\n  <p><strong>Job Summary</strong><br />Reporting to the Human Resources and&nbsp;Administration officer. Driving assigned MBTS&nbsp;vehicles with responsibility and avoid putting the&nbsp;vehicles with responsibility and avoid putting the<br />lives of the passengers in danger.</p>\r\n  <p><strong>Qualifications, Experience and Competencies</strong><br />Â» Malawi School Certificate of Education<br />Â» Driving License<br />Â» Having worked in this position for not less than&nbsp;one year</p>\r\n  <p><strong>Responsibilities</strong></p>\r\n  <ul style=\"list-style-type: disc;\">\r\n    <li>Safely transporting staff and visitors, as well as&nbsp;various products to and from specified locations<br />in a timely manner.</li>\r\n    <li>Carrying out daily security, care and routine&nbsp;vehicle checks.</li>\r\n    <li>Maintaining travel log books</li>\r\n    <li>Advising Human Resources and Administration&nbsp;Officer on the road worthiness of the vehicles.</li>\r\n    <li>Performing any other duties as assigned by&nbsp;Management.</li>\r\n  </ul>\r\n  <p>Application letters, copies of certificates and Curriculum&nbsp;Vitae with at least three traceable referees from&nbsp;suitably qualified persons should be addressed to;</p>\r\n  <p>The Chief Executive Officer<br />Malawi Blood Transfusion Services</p>\r\n  <p>P.O.Box 2681\r\n\r\n  </p>\r\n  <p><br /><img src=\"data:image/jpeg;base64,[BLOB]\"\r\n      style=\"width: 306px; height: 229px;\" />&nbsp; <img src=\"data:image/jpeg;base64,[BLOB]