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 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 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 checkHashExist($hash)
{
$query = "select uid from activationHash where hash = '" . $hash . "'";
$queryResult = parent::query($query);
if (parent::rowExist($queryResult)) {
return parent::queryResult($queryResult, 'uid');
} else {
return false;
}
}
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;
}
}
}
public function checkRegisterData($input)
{
$query = "select uid from users where email = '" . $input['email'] . "'";
$queryResult = parent::query($query);
return parent::rowExist($queryResult);
}
public function checkEmailExist($email)
{
$query = "select uid from users where email = '" . $email . "'";
$queryResult = parent::query($query);
return parent::rowExist($queryResult);
}
public function checkUserExist($uid)
{
$query = "select uid from users where uid = " . $uid;
$queryResult = self::query($query);
return parent::rowExist($queryResult);
}
public function getEmailCommentUser($cid, $uid)
{
$query = "select u.email, u.uid, u.firstname from users as u, commentSub as cs, notificationSetting as ns where u.uid = cs.wid and u.uid = ns.uid and ns.commentSub = 1 and cs.wid != " . $uid . " and cs.cid = " . $cid . " 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']);
}
$query = "select u.email, u.uid, u.firstname from users as u, comments as c, notificationSetting as ns where u.uid = c.wid and c.wid != " . $uid . " and u.uid = ns.uid and ns.commentSub = 1 and c.cid = " . $cid;
$queryResult = parent::query($query);
if (parent::rowExist($queryResult)) {
$sendEmailToArray[] = array('uid' => parent::queryResult($queryResult, 'uid'), 'firstname' => parent::queryResult($queryResult, 'firstname'), 'email' => parent::queryResult($queryResult, 'email'));
}
return $sendEmailToArray;
}
public function getSendEmailUser($uid)
{
$query = "select u.email, u.firstname, ns.eventInvite 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('eventInvite' => parent::queryResult($queryResult, 'eventInvite'), 'email' => parent::queryResult($queryResult, 'email'), 'firstname' => parent::queryResult($queryResult, 'firstname'));
}
return $user;
}
