<!-- ======= Footer ======= -->
<footer id="footer" class="footer">

<div class="footer-content">
  <div class="container">

	<div class="row g-5">
	  <div class="col-lg-4">
		<a href="index.php" class="logo d-flex align-items-center">
        <!-- Uncomment the line below if you also wish to use an image logo -->
        <img src="assets/img/favicon.png" alt="">       
      </a>
		<p>#Ielewe Mitaa</p>
		<p><a href="./index.php?page=about" class="footer-link-more">Ijue Ndondo Cup</a></p>
	  </div>
	  <div class="col-6 col-lg-2">
		<h3 class="footer-heading">Kurasa Muhimu</h3>
		<ul class="footer-links list-unstyled">
		  <li><a href="./index.php"><i class="bi bi-chevron-right"></i> Home</a></li>
		  <li><a href="./index.php?page=tournaments"><i class="bi bi-chevron-right"></i> Tournaments</a></li>
		  <li><a href="./index.php?page=matokeo"><i class="bi bi-chevron-right"></i> Matokeo</a>
		  <li><a href="./index.php?page=category"><i class="bi bi-chevron-right"></i>Habari</a></li>
		  <li><a href="./index.php?page=about"><i class="bi bi-chevron-right"></i> Ijue Ndondo</a></li>
		  <li><a href="./index.php?page=contact"><i class="bi bi-chevron-right"></i> Mawasiliano</a></li>
		  <li><a href="./admin/login.php" target="_blank"><i class="bi bi-chevron-right"></i> Staff Login</a></li>
		</ul>
	  </div>
	  <div class="col-6 col-lg-2">
		<h3 class="footer-heading">Categories</h3>
		<ul class="footer-links list-unstyled">
		<?php 
	            $categories = $conn->query("SELECT * FROM category_list where category != 'hero' AND id !=6 order by category asc");
	                while($row=$categories->fetch_assoc()):
	                  ?>
	                  <li><a href="./index.php?page=category&cat=<?php echo md5($row['id']) ?>" data-id = '<?php echo $row['id'] ?>'><i class="bi bi-chevron-right"></i><?php echo ucwords($row['category']) ?></a></li>
	             <?php      
	                endwhile;
	            ?>
		</ul>
	  </div>

	  <div class="col-lg-4">
		<h3 class="footer-heading">Recent Posts</h3>

		<ul class="footer-links footer-blog-entry list-unstyled">
		<?php 
                $recent = $conn->query("SELECT p.*,c.category from post_list p inner join category_list c on c.id = p.category_id where status = 1  AND c.id !=7 order by unix_timestamp(date_published) desc limit 4");
                while($row=$recent->fetch_assoc()):
	                  ?>
	                 <li>
						<a href="./index.php?page=read_news&c=<?php echo md5($row['id']) ?>" class="d-flex align-items-center">
							<img src="assets/uploads/content_images/<?php echo $row['cover_img'] ?>" alt="" class="img-fluid me-3">
							<div>
								<div class="post-meta d-block"><span class="date"><?php echo ucwords($row['category']) ?></span> <span class="mx-1">&bullet;</span> <span><?php echo date("F d,Y", strtotime($row['date_published'])) ?></span></div>
				<span><?php echo ucwords($row['title']) ?></span>
			  </div>
			</a>
		  </li>

	             <?php      
	                endwhile;
	            ?>
		

		  

		</ul>

	  </div>

	  <div class="col-lg-12 ft-sponsor"><img src="assets/img/sponsor.png" alt="" class="img-ft">  </div>
	</div>
  </div>
</div>

<div class="footer-legal">
  <div class="container">

	<div class="row justify-content-between">
	  <div class="col-md-6 text-center text-md-start mb-3 mb-md-0">
		<div class="copyright">
		  © Copyright 2024 <strong><span>Ndondo Cup</span></strong>. All Rights Reserved
		</div>

		<div class="credits">
		
		  Designed & Hosted by <a href="https://sisihub.co.tz/">Sisihub</a>
		</div>

	  </div>

	  <div class="col-md-6">
		<div class="social-links mb-3 mb-lg-0 text-center text-md-end">
		  <a href="https://x.com/NdondoCup?t=LSFLUrvupRpFppICi0RLmw&s=08" class="twitter" target="_blank"><i class="bi bi-twitter"></i></a>
		  <a href="https://www.facebook.com/NdondoCup?mibextid=ZbWKwL" class="facebook" target="_blank"><i class="bi bi-facebook"></i></a>
		  <a href="https://www.instagram.com/ndondo_cup?igsh=MWU3Mm5jeGNsd2pmeA==" class="instagram" target="_blank"><i class="bi bi-instagram"></i></a>
		</div>

	  </div>

	</div>

  </div>
</div>

</footer>

<a href="#" class="scroll-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

<!-- Vendor JS Files -->
<script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="assets/vendor/swiper/swiper-bundle.min.js"></script>
<script src="assets/vendor/glightbox/js/glightbox.min.js"></script>
<script src="assets/vendor/aos/aos.js"></script>
<script src="assets/vendor/php-email-form/validate.js"></script>

<!-- Template Main JS File -->
<script src="assets/js/main.js"></script>

</body>

</html>