public function getUserTypeById($usertypeid)
{
$query = "SELECT * FROM " . USER_TYPE . " WHERE utp_usertype_id = " . "'{$usertypeid}'";
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
$user = $this->getUserType($result);
return $user->getuserTypeName();
}
public function Login($uname, $upwd)
{
$uname = $uname;
$upwd = sha1($upwd);
// returns all users with the names passed
//$query = "SELECT * FROM ".USER. " WHERE upper(usr_first_name) like " ."%JOHN%";
$query = "SELECT * FROM " . USER . " WHERE usr_login = '******' and usr_password='******'";
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
$Users = $this->getLogin($result);
return $Users;
}
public function getEntryDislikeNumByEntry($entryId)
{
$query = "SELECT count(rating.rat_dislike_user_id) AS dislikeNum\n FROM " . ENTRY . " AS entry INNER JOIN " . RATING . " AS rating\n ON rating.rat_entity_id = CONCAT('ent', '" . $entryId . "') \n AND rating.rat_dislike_user_id IS NOT NULL AND rating.rat_dislike_user_id >0\n GROUP BY entry.ent_entry_id \n HAVING entry.ent_entry_id='" . $entryId . "'";
//echo "<br/>EAD getEntryDislikeNum query: ".$query;
$dbHelper = new DBHelper();
$resultOfSelect = $dbHelper->executeSelect($query);
$dislike_num = "";
$count = 0;
while ($list = mysqli_fetch_assoc($resultOfSelect)) {
$dislike_num = $list['dislikeNum'];
$count++;
}
return $dislike_num;
}
data="views/entry/search_phrase_examples.html">
</object>
</div><!--LeftCol-->
<div id="MidCol">
<div>
<div class="container" style="border-collapse: inherit; width: 99%; font-size: 20px;">
<div class="heading">
<div class="col_33">
<h3 class="t_title">Top 10 Translations</h3>
<div class="mid_scoll">
<ol type="circle" style="padding: 0px 5px; margin: 0px">
<!-Display top 10 translations-->
<?php
$query = "SELECT *, count(rating.rat_like_user_id) AS num_like\n FROM \n (SELECT orig.ent_entry_id AS orig_entry_id, orig.ent_entry_text AS orig_phrase, \n trans.ent_entry_id AS trans_entry_id, trans.ent_entry_text AS trans_phrase,\n trans.ent_entry_creation_date AS trans_date\n FROM \n (SELECT ent_entry_id, ent_entry_text, ent_entry_verbatim, ent_entry_translit, ent_entry_authen_status_id, \n ent_entry_translation_of, ent_entry_creation_date\n FROM tbl_entry where ent_entry_authen_status_id = 1) AS orig\n INNER JOIN \n (SELECT ent_entry_id, ent_entry_text, ent_entry_verbatim, ent_entry_translit, ent_entry_authen_status_id, \n ent_entry_translation_of, ent_entry_creation_date\n FROM tbl_entry where ent_entry_authen_status_id = 2) AS trans\n ON orig.ent_entry_id = trans.ent_entry_translation_of\n ) AS sub_entry\n LEFT JOIN tbl_rating AS rating\n ON rating.rat_entity_id = CONCAT('ent', sub_entry.trans_entry_id) \n AND rating.rat_like_user_id IS NOT NULL AND rating.rat_like_user_id >0\n GROUP BY sub_entry.trans_entry_id\n ORDER BY num_like DESC, sub_entry.trans_date DESC, sub_entry.trans_entry_id ASC";
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
$count = 0;
while ($list = mysqli_fetch_assoc($result)) {
$trans_phrase = $list['trans_phrase'];
$orig_phrase = $list['orig_phrase'];
$trans_entry_id = $list['trans_entry_id'];
$num_like = $list['num_like'];
if ($count < 10) {
?>
<li>
<!-- <div>-->
<div class="text_shortcut"><a href="entryview.php?id=<?php
echo $trans_entry_id;
?>
"><?php
echo $trans_phrase;
public function getLocationBylocationId($locationId)
{
$query = "select * from " . LOCATION . " where loc_location_id = " . $locationId;
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
$loc = $this->getAddressList($result);
return $loc;
}
public function LoginReset($resetcode)
{
if (isset($resetcode)) {
//object that holds the password and user id for the resetter
//Retrieving the data from the table, based on the data sent
$Reset = new ResetPassword();
$query = "SELECT * FROM " . PASSWORD_RESET . " WHERE reset_code = '{$resetcode}' ";
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
// 30
//getting the object of PasswordReset
$Reset = $this->getReset($result);
}
return $Reset;
}
public function getUserByUserId($userId)
{
// returns returns all users with the names passed
$query = "SELECT * FROM " . USER . " WHERE usr_user_id = '{$userId}' ";
$dbHelper = new DBHelper();
$result = $dbHelper->executeSelect($query);
$Users = $this->getUser($result);
return $Users;
}
