function Collections()
{
$array = array();
$query = "select * from library where on_shelf = 1 order by title ASC";
$link = UserUtility::getDefaultDBConnection();
$result = mysqli_query($link, $query);
if ($result) {
while ($row = mysqli_fetch_array($result)) {
array_push($array, $row);
}
} else {
//Log error
UserUtility::logMySQLError($link);
}
$this->books = $array;
}
function isClassRep($regno)
{
$query = "select * from admins where username = '******'";
$link = UserUtility::getDefaultDBConnection();
$result = mysqli_query($link, $query);
if ($result) {
return mysqli_num_rows($result) > 0;
} else {
return false;
}
}
/**
* Verifies and changes User's password (This is supported on php version >= 5.5.0)
* @param type $oldPassword
* @param type $newPassword1
* @param type $newPassword2
* @return type
* @throws Exception
*/
public function changePassword($oldPassword, $newPassword1, $newPassword2)
{
if ($this->verifyPassword($oldPassword, $this->getUserPassword())) {
//Check password
$this->validatePassword($newPassword1);
$ok = strcmp($newPassword1, $newPassword2) === 0;
if ($ok) {
$link = UserUtility::getDefaultDBConnection();
$pwd = crypt($newPassword1);
$query = "update users set password='******' where regno='" . $this->getUserID() . "'";
mysqli_query($link, $query);
//Log error
UserUtility::logMySQLError($link);
//Reload
$this->userInfo = $this->getUserData();
$ok = $this->setUserCookies($this->userInfo['regno'], $this->userInfo['password']);
return $ok;
} else {
throw new Exception("Passwords do not match");
}
} else {
throw new Exception("Wrong password");
}
}
public function plusOneHit($id)
{
$query = "update news set hits = hits + 1 where id = '{$id}'";
$link = UserUtility::getDefaultDBConnection();
$result = mysqli_query($link, $query);
//Log error
UserUtility::logMySQLError($link);
return $result;
}
function storeFeedBack()
{
$link = UserUtility::getDefaultDBConnection();
$query = "insert INTO feedbacks(ip,message,img,browser,page,is_mobile_browser) VALUES('{$this->ip}','{$this->message}','{$this->img}','{$this->browser}','{$this->url}','{$this->isBrowserMobile}')";
$result = mysqli_query($link, $query);
if ($result) {
return 1;
} else {
return 0;
}
}
public static function getExecutives($session = "")
{
$executives = array();
$query = "select e.id, u.regno, u.first_name, u.last_name, u.other_names, u.department, u.pic_url, e.post, e.session " . "from users u join executives e " . "on (u.regno = e.user_id) ";
if (!empty($session)) {
$query .= "where e.session = '{$session}' ";
}
$query .= "order by session desc";
$link = UserUtility::getDefaultDBConnection();
$result = mysqli_query($link, $query);
if ($result) {
while ($row = mysqli_fetch_array($result)) {
$executives[] = $row;
}
}
//Log error
UserUtility::logMySQLError($link);
return $executives;
}
