<?php
require_once 'includes/database_master.inc.php';
require_once 'includes/page_master.inc.php';
require_once 'includes/session_master.inc.php';
$database_master = new DatabaseMaster();
$page_master = new PageMaster();
$session_master = new SessionMaster();
$query = "DELETE FROM users WHERE idNo=" . $_GET['idNo'];
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?user_delete=success&user='******'idNo']);
} else {
$page_master->redirectUser('index.php?user_delete=failed');
}
<?php
require_once 'includes/database_master.inc.php';
require_once 'includes/page_master.inc.php';
require_once 'includes/session_master.inc.php';
$database_master = new DatabaseMaster();
$page_master = new PageMaster();
$idNo = $_POST['idNo'];
$idNo = $database_master->escapeString($idNo);
$password = $_POST['password'];
$password = $database_master->escapeString($password);
$query = "SELECT idNo FROM users WHERE idNo = '{$idNo}' AND password = SHA('{$password}')";
$queryResult = $database_master->querySelect($query);
if (is_array($queryResult) && count($queryResult)) {
$session_master = new SessionMaster();
$session_master->logUserIn($idNo);
$page_master->redirectUser("index.php");
} else {
$page_master->redirectUser('index.php?error=login');
}
<?php
require_once 'includes/database_master.inc.php';
require_once 'includes/session_master.inc.php';
require_once 'includes/page_master.inc.php';
$database_master = new DatabaseMaster();
$page_master = new PageMaster();
$session_master = new SessionMaster();
$cabinetNo = $_POST['cabinetNo'];
$nodeName = $_POST['nodeName'];
$nodeType = $_POST['nodeType'];
$sinNumber = $_POST['sinNumber'];
$ElectricMeterNo = $_POST['ElectricMeterNo'];
$office = $_POST['office'];
$nodeLocation = $_POST['nodelocation'];
$cabinetNo = $database_master->escapeString($cabinetNo);
$nodeName = $database_master->escapeString($nodeName);
$sinNumber = $database_master->escapeString($sinNumber);
$ElectricMeterNo = $database_master->escapeString($ElectricMeterNo);
$office = $database_master->escapeString($office);
$nodeLocation = $database_master->escapeString($nodeLocation);
$nodeName = $database_master->escapeString($nodeName);
$query = "INSERT INTO node (nodeName, sinNo, electricMeterNo, node_type, cabinetNo, central_officeName, nodeLocation)\n\t\t\t VALUES ('{$nodeName}','{$sinNumber}', '{$ElectricMeterNo}','{$node_type}','{$cabinetNo}','{$office}','{$nodeLocation}')";
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?add_node=success');
} else {
$page_master->redirectUser('index.php?add_node=failed');
}
<?php
require_once 'includes/database_master.inc.php';
require_once 'includes/page_master.inc.php';
require_once 'includes/session_master.inc.php';
$database_master = new DatabaseMaster();
$page_master = new PageMaster();
$session_master = new SessionMaster();
$query = "DELETE FROM node WHERE nodeName='" . $_GET['node'] . "'";
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?node_delete=success');
} else {
$page_master->redirectUser('index.php?node_delete=failed');
}
$nodeName = 'null';
}
$faultDescription = $_POST['faultDescription'];
$faultDescription = $database_master->escapeString($faultDescription);
$redirectPage = 'index.php?';
if ($database_master->checkIdNo($idNo)) {
$errors['idNo'] = $idNo;
$redirectPage .= 'id=' . $idNo;
}
if (isset($_POST['nodeName']) && $database_master->checkNodeName($nodeName)) {
$errors['nodeName'] = $nodeName;
$redirectPage .= 'nodeName=' . $nodeName;
}
if (isset($_POST['cabinetNo']) && $database_master->checkCabinetNo($cabinetNo)) {
$errors['cabinetNo'] = $cabinetNo;
$redirectPage .= 'cabinetNo=' . $cabinetNo;
}
if (empty($title) || empty($nodeName) && empty($cabinetNo)) {
$errors['empty'] = "true";
$redirectPage .= '&error=empty';
}
if (empty($errors)) {
$query = "INSERT INTO reports VALUES((SELECT MAX(reportId)+1 FROM reports as r),\n\t\t '{$title}',\n\t\t {$idNo}, \n\t\t {$idNoFrom}, \n\t\t {$nodeName}, \n\t\t {$cabinetNo}, '{$faultDescription}', now(), 'pending')";
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?add_report=success');
} else {
$page_master->redirectUser('index.php?add_report=failed');
}
} else {
$page_master->redirectUser($redirectPage);
}
<?php require_once 'includes/database_master.inc.php'; require_once 'includes/page_master.inc.php'; require_once 'includes/session_master.inc.php'; $database_master = new DatabaseMaster(); $session_master = new SessionMaster(); $session_master->logUserOut(); $page_master = new PageMaster(); $page_master->redirectUser();
$redirectPage = 'index.php?';
if (!$database_master->checkIdNo($idNo)) {
$errors['idNo'] = $idNo;
$redirectPage .= 'id=' . $idNo;
}
if ($password != $repass) {
$errors['password'] = "******";
$redirectPage .= '&password=nomatch';
}
if (empty($idNo) || empty($password) || empty($repass) || empty($user_type) || empty($position)) {
$errors['empty'] = "true";
$redirectPage .= '&error=empty';
}
if (!$database_master->checkUser_type($user_type)) {
$errors['user_type'] = $user_type;
$redirectPage .= '&user_type=' . $user_type;
}
if (!$database_master->checkOffice($office)) {
$errors['office'] = $office;
$redirectPage .= '&office=' . $office;
}
if (empty($errors)) {
$query = "INSERT INTO users VALUES ('{$idNo}', '{$user_type}', SHA('{$password}'), '{$firstName}', '{$lastName}', \n\t\t\t'{$position}', '{$office}')";
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?register=success&new_user='******'index.php?register=failed');
}
} else {
$page_master->redirectUser($redirectPage);
}
<?php
require_once 'includes/database_master.inc.php';
require_once 'includes/session_master.inc.php';
require_once 'includes/page_master.inc.php';
$database_master = new DatabaseMaster();
$page_master = new PageMaster();
$session_master = new SessionMaster();
$cabinetNo = $_POST['cabinetNo'];
$cabinetType = $_POST['cabinetType'];
$cabinetNo = $database_master->escapeString($cabinetNo);
$cabinetType = $database_master->escapeString($cabinetType);
$query = "INSERT INTO cabinet (cabinetNo, cabinet_type) VALUES ('{$cabinetNo}', '{$cabinetType}')";
if ($database_master->queryUpdate($query)) {
$page_master->redirectUser('index.php?cab_add=success');
} else {
$page_master->redirectUser('index.php?cab_add=failed');
}
