public function getExplanation($type)
{
$query = "select explanation from explanation where type = '" . $type . "'";
$queryResult = parent::query($query);
$explanation = NULL;
if (parent::rowExist($queryResult)) {
$explanation = parent::queryResult($queryResult, 'explanation');
}
return $explanation;
}
public function getAttenderCount($eid)
{
$query = "select uid from userEvent where eid = " . $eid . " group by uid";
$queryResult = parent::query($query);
$attenderCount = 0;
if (parent::rowExist($queryResult)) {
$attenderCount = parent::numRows($queryResult);
}
return $attenderCount;
}
public function getEventFromWeek($firstDayOfWeek, $lastDayOfWeek)
{
$query = "select ue.id, ue.eid, ue.attending, e.owner, e.name, e.address, e.adjustable, e.location, e.description, e.joinable, ue.dateFrom, ue.timeFrom, ue.timeTo, ue.privacy, ue.remember, ue.modify\n from userEvent as ue, event as e\n where ue.eid = e.eid and ue.dateFrom >= '" . $firstDayOfWeek . "' and ue.dateFrom <= '" . $lastDayOfWeek . "' and ue.uid = " . $this->user['uid'] . " and " . $this->user['relation'] . " <= ue.privacy\n order by timeFrom";
$queryResult = parent::query($query);
$event = array();
while ($result = parent::fetchArray($queryResult)) {
$event[] = array('id' => $result['id'], 'eid' => $result['eid'], 'attending' => $result['attending'], 'owner' => $result['owner'], 'name' => $result['name'], 'address' => $result['address'], 'adjustable' => $result['adjustable'], 'location' => $result['location'], 'description' => $result['description'], 'joinable' => $result['joinable'], 'dateFrom' => $result['dateFrom'], 'timeFrom' => $result['timeFrom'], 'timeTo' => $result['timeTo'], 'privacy' => $result['privacy'], 'remember' => $result['remember'], 'modify' => $result['modify']);
}
return $event;
}
public function getUser($uid)
{
$query = "select firstname, lastname, email from users where uid = " . $uid;
$queryResult = parent::query($query);
$userData = array();
while ($result = parent::fetchArray($queryResult)) {
$userData = array('name' => $result['firstname'] . ' ' . $result['lastname'], 'firstname' => $result['firstname'], 'lastname' => $result['lastname'], 'email' => $result['email']);
}
return $userData;
}
public function getEventSearchResult($searchKeyword)
{
$query = "select e.eid, e.owner, e.name, e.description, e.dateFrom, e.timeFrom, e.timeTo, e.joinable, u.firstname, u.lastname\n from event as e, users as u\n where e.owner = u.uid and e.searchable = 1 and (e.name like '%" . $searchKeyword . "%' or e.description like '%" . $searchKeyword . "%') group by e.eid desc limit 0, 200";
$queryResult = parent::query($query);
$eventSearch = array();
while ($result = parent::fetchArray($queryResult)) {
$eventSearch[] = array('eid' => $result['eid'], 'owner' => $result['owner'], 'eventName' => $result['name'], 'name' => $result['firstname'] . ' ' . $result['lastname'], 'description' => $result['description'], 'joinable' => $result['joinable'], 'dateFrom' => $result['dateFrom'], 'timeFrom' => $result['timeFrom'], 'timeTo' => $result['timeTo']);
}
return $eventSearch;
}
public function getEventName($eid)
{
$query = "select name from event where eid = " . $eid;
$queryResult = parent::query($query);
$eventName = NULL;
if (parent::rowExist($queryResult)) {
$eventName = parent::queryResult($queryResult, 'name');
}
return $eventName;
}
public function getFriendInvitationFromHash($hash)
{
$query = "select uid, email from friendEmailInvitation where hash = '" . $hash . "'";
$queryResult = parent::query($query);
$invitation = array();
while ($result = parent::fetchArray($queryResult)) {
$invitation = array('uid' => $result['uid'], 'email' => $result['email']);
}
return $invitation;
}
public function checkUserActivation($uid)
{
$query = "select activation from users where uid = " . $uid;
$queryResult = parent::query($query);
if (parent::rowExist($queryResult)) {
$activation = parent::queryResult($queryResult, 'activation');
if ($activation == '1') {
return true;
} else {
//return false -> if activation is needed
return true;
}
}
}
private function insertProfile($uid, $input)
{
$query = "insert into profilePrivacy (uid, modify) values ('" . $uid . "', now())";
parent::query($query);
$query = "insert into profileBasic (uid, gender, email) values ('" . $uid . "', '" . $input['gender'] . "', '" . $input['email'] . "')";
parent::query($query);
$query = "insert into profileInterest (uid) values ('" . $uid . "')";
parent::query($query);
$query = "insert into profileEducation (uid) values ('" . $uid . "')";
parent::query($query);
$query = "insert into userPrivacy (uid, calendar, status, comment, friend) values ('" . $uid . "', 3, 3, 3, 3)";
parent::query($query);
$query = "insert into friends (uid, friendlist) values ('" . $uid . "', '')";
parent::query($query);
$query = "insert into pageView (uid, view) values ('" . $uid . "', 0)";
parent::query($query);
$query = "insert into notificationSetting (uid, modify) values ('" . $uid . "', now())";
parent::query($query);
}
public function setNewPassword($newPassword, $email)
{
$query = "update users set password = '******' where email = '" . $email . "'";
parent::query($query);
}
public function updatePageView($uid)
{
$query = "update pageView set view = view + 1 where uid = " . $uid;
parent::query($query);
}
public function getEmailEventUser($eid, $uid)
{
$query = "select u.email, u.uid, u.firstname from users as u, userEvent as ue, notificationSetting as ns where u.uid = ns.uid and u.uid = ue.uid and ns.eventComment = 1 and ue.uid != " . $uid . " and ue.eid = " . $eid . " group by u.uid";
$queryResult = parent::query($query);
$sendEmailToArray = array();
while ($result = parent::fetchArray($queryResult)) {
$sendEmailToArray[] = array('uid' => $result['uid'], 'firstname' => $result['firstname'], 'email' => $result['email']);
}
return $sendEmailToArray;
}
public function getStatus($uid)
{
$query = "select comment from comments where uid = " . $uid . " and wid = " . $uid . " and date_add(created, interval 1 day) > now() order by created desc limit 0,1";
$queryResult = parent::query($query);
return parent::queryResult($queryResult, 'comment');
}
public function getSendEmailUser($uid)
{
$query = "select u.email, u.firstname, ns.friendRequest from users as u, notificationSetting as ns where u.uid = ns.uid and u.uid = " . $uid;
$queryResult = parent::query($query);
$user = array();
if (parent::rowExist($queryResult)) {
$user = array('friendRequest' => parent::queryResult($queryResult, 'friendRequest'), 'email' => parent::queryResult($queryResult, 'email'), 'firstname' => parent::queryResult($queryResult, 'firstname'));
}
return $user;
}
public function saveNotificationSetting($input)
{
$query = "update notificationSetting set comment = '" . $input['commentPage'] . "', commentSub = '" . $input['commentSub'] . "', eventInvite = '" . $input['eventInvite'] . "', eventComment = '" . $input['eventComment'] . "', eventRequest = '" . $input['eventRequest'] . "', eventUpdate = '" . $input['eventUpdate'] . "', privateMessage = '" . $input['privateMessage'] . "', friendRequest = '" . $input['friendRequest'] . "' where uid = " . $this->user['myuid'];
parent::query($query);
}
