/**
* @param bool|int $id
*/
public function RefreshIngredients($id = false)
{
$result = array();
$condition = $id ? "AND tblIngredients.id = " . (int) $id : false;
$queryString = "SELECT * FROM tblIngredients WHERE userID = {$this->ID} {$condition}";
$query = $this->DB->Query($queryString);
if ($query) {
while ($row = $query->Fetch()) {
$ingredient = array_key_exists($row['id'], $this->Ingredients) ? $this->Ingredients[$row['id']] : new Ingredient($this, $row);
$result[$ingredient->ID] = $ingredient;
}
}
$this->Ingredients = $result;
}
<?php
require_once "../inc/initialize.php";
//checks if admin user is logged in
if (!$session->is_admin_logged_in()) {
redirect_to('index.php');
}
$role = $_SESSION["role"];
if ($role == 4) {
$db = new MySQLDatabase();
$sql = "SELECT `department_name` from `department` WHERE `department_id` = '" . $_SESSION["department_id"] . "'";
$dept = $db->Query($sql);
$dept = $db->fetch_array($dept);
$dept = array_shift($dept);
}
function privilege()
{
global $role;
switch ($role) {
case 1:
$msg = "Main Administrative";
break;
case 2:
$msg = "Post Graduate Administrative";
break;
case 3:
$msg = "Non NUC Administrative";
break;
case 4:
$msg = "Departmental Administrative";
break;
/** @return bool */
public function UpdateDatabase()
{
$queryString = "\n UPDATE tblBars\n SET\n `type` = " . $this->DB->Quote($this->Type) . "\n , `title` = " . $this->DB->Quote($this->Title) . "\n , `description` = " . $this->DB->Quote($this->Description) . "\n , `modifyStamp` = " . microtime(true) . "\n WHERE id = " . (int) $this->ID . " AND userID = " . (int) $this->Session->ID . "\n ";
return (bool) $this->DB->Query($queryString);
}
/*
* All this crap switches the environment to run from the testing database and session pool.
* Pass in /reset, and the database and sessions will be cleared, and a default user will be created.
*
* Magic!
*/
$dbCredentials = 'UnitTestDBCredentials';
if (!file_exists(UNITTESTSESSIONPATH)) {
mkdir(UNITTESTSESSIONPATH);
}
session_save_path(UNITTESTSESSIONPATH);
if (isset($Path[0]) && $Path[0] == 'reset') {
$rm = "rm " . UNITTESTSESSIONPATH . "*";
$rm = `{$rm}`;
$db = new MySQLDatabase('UnitTestDBCredentials');
$tables = $db->Query("\n\t\tSELECT table_name AS `table`\n\t\tFROM information_schema.tables\n\t\tWHERE table_schema = " . $db->Quote($UnitTestDBCredentials['name']) . ";\n\t");
singleLog($tables);
if ($tables) {
$db->Query("SET FOREIGN_KEY_CHECKS = 0;");
while ($table = $tables->Fetch()) {
singleLog($db->Query("DROP TABLE IF EXISTS " . $table['table'] . ";"));
}
$db->Query("SET FOREIGN_KEY_CHECKS = 1;");
}
$dump = "mysqldump -u " . $DevDBCredentials['user'] . " -p" . $DevDBCredentials['pass'] . " -d " . $DevDBCredentials['name'] . " | mysql -u " . $UnitTestDBCredentials['user'] . " -p" . $UnitTestDBCredentials['pass'] . " -D" . $UnitTestDBCredentials['name'] . "";
$dump = `{$dump}`;
$makeUser = $db->Query("INSERT INTO tblUsers (username, password, accountType, displayName, email) VALUES ('joe', 'nohomohug', 'Standard', 'Joe Testmoore', '*****@*****.**');");
APIResponse(RESPONSE_200, "Cleared the database and sessions.");
exit;
}
function SelectByWhere($where)
{
App::LoadDataClass("MySQLDatabase.php");
$mydb = new MySQLDatabase($this->ConnString);
$mydb->Open();
$query = "Select * from `{$this->TableName}` {$where}";
//App::Pr($query);
$result = $mydb->Query($query);
$rows = null;
while ($row = mysql_fetch_array($result)) {
$rows[] = $row;
}
$mydb->Close();
if ($mydb->getError()) {
$this->setError($mydb->getError());
}
return $rows;
}
