One Hat Cyber Team

Your IP : 216.73.216.84
Server IP : 50.6.229.107
Server : Linux server.hostburly.com 5.14.0-611.38.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 10 17:21:28 EDT 2026 x86_64
Server Software : Apache
PHP Version : 8.2.30
Buat File | Buat Folder
Dir : ~/home/andjemzt/niqs.andjemztech.com.ng/
View File Name : logbookfailedstart.php

<?php 

header("Expires: Tue, 12 Jul 2011 06:00:00 GMT"); // *

header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");

header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");

header("Cache-Control: post-check=0, pre-check=0", false);

header("Pragma: no-cache");



$con = mysqli_connect('localhost','niqsorgn_portal','@Xchange69!') or die("Technical Error - 1001");

$con2 = mysqli_connect('localhost','niqsorgn_portal','@Xchange69!') or die("Technical Error - 1001");



$db =  mysqli_select_db($con, 'niqsorgn_exams') or die("Not Connected: Contact Programmer");

$db2 =  mysqli_select_db($con2, 'niqsorgn_pota1969') or die("Not Connected: Contact Programmer");





$mycount = 0;

if(isset($_POST["myset"])){

    //get results

    $set = $_POST["myset"];

    $q = "select * from logbookresult where session='$set' AND status != 'SUCCESSFUL' and clearRecord!='YES' limit 10";

    $r = mysqli_query($con, $q);

    



    if($r){

        while($row = mysqli_fetch_array($r)){        

            

            //print_r($row);

            $mymemberNo =  $row["memberNo"];

            $mystage =  $row["stage"];

            $mystatus =  $row["status"];

            $mydateApproved =  $row["dateApproved"];

            $myresultID = $row["id"];

            

            //get member id from members table

            

            $q2 = "select memberID, memberSurname, logbook from members where memberNo='$mymemberNo' limit 1";

            $r2 = mysqli_query($con2, $q2);

            if($r2){ 

                $row2 = mysqli_fetch_array($r2);

                $mymemberID = $row2["memberID"];

                //print_r($row2);



            }

            //update members table

            $q3 = "UPDATE members SET logbook='0' WHERE memberID='$mymemberID' limit 1";

            $r3 = mysqli_query($con2, $q3);



            //delete from logbook table

            $q4 = "delete from logbook WHERE candidate_id='$mymemberID' AND stage='$mystage' AND graded='1' limit 1";

            $r4 = mysqli_query($con2, $q4);



            if($r4){

				//delete uploads - diary entries

				$q6 = "delete from log_uploads WHERE uploader_id='$mymemberID' AND stage='$mystage'";

				$r6 = mysqli_query($con2, $q6);



				

				

                 echo "<br><br> $mymemberNo record deleted successfully ";    

                $q5 = "UPDATE logbookresult SET clearRecord='YES' WHERE id='$myresultID' limit 1";

                $r5 = mysqli_query($con, $q5);

                $mycount = $mycount + 1;

                }

        }

                echo "<h3> $mycount candidate(s) record deleted successfully </h3>";

    }

} 





?>



<h3>Delete Record for Non-Successful Candidates</h3>



<h3>Select the Diet and Proceed</h3>

<form method="post">

<select name="myset" required="required" style="height:auto;">

<option value=""> -- SELECT --</option>

<?php



    $x = date('Y');

        

    for($i=2023; $i<=$x; $i++){

        echo "<option>FEBRUARY $i</option>";

        echo "<option>JULY $i</option>";

        

    }

?>

</select>

<input type="submit" name="oksubmit" value="Reset Logbook" />