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); }