/** * getUsers() * Get information from all users or if an id is specified just get the information from that user * * @param(int) if none specified just get all the users * @param(slug) if slug given in we get the user by its slug * @return(array) or (false) return a array with all the users information in it */ public function getUsers($idFromSlug = null, $sSlug = NULL) { # if there is a slug escape it if ($sSlug) { $sSlug = $this->mysqli->real_escape_string($sSlug); } # query $query = 'SELECT users.id, users.username, users.access, users.processed, users.active, users.deleted,users.last_active,users.delete_date,users.admin, users_info.firstname, users_info.lastname, users_info.email, users_info.lang,users_info.img,users_info.register_date,users_info.job_title,users_info.mobile, users_info.about,users_info.page_slug,users_social.facebook,users_social.instagram,users_social.twitter,users_social.website,users_social.linkedin, files.new_name, files_extensions.extension FROM users LEFT JOIN users_info on users_info.users_id = users.id LEFT JOIN users_social on users_social.users_id = users.id LEFT JOIN files on files.id = users_info.img LEFT JOIN files_extensions on files_extensions.id = files.extension '; # if id is set we want a specific user if ($idFromSlug) { $query .= 'WHERE users.id = ' . $idFromSlug; } # only use slug if slug is specified but no id is given in if ($sSlug && !$idFromSlug) { $query .= 'Where users_info.page_slug = "' . $sSlug . '"'; } # execute the query $oResult = $this->mysqli->query($query); # fetch the result associative $aResult = parent::fetchResultAssoc($oResult); # return the result return $aResult; }
/** * count all the files a user have * if and id is givin in it will get them from a specific user otherwise it will get them from the current user * if we also want to count the deleted files we can assign true to also get them * @param(int) * @return(int) */ public function countFiles($idFromSlug = null, $deleted = false) { $oUser = singleton::getInstance('User'); # the query $query = 'SELECT count(*) as countFiles FROM files LEFT JOIN users on users.id = files.users_id '; # if idFromSlug specified get them from the user id if ($idFromSlug) { $query .= ' WHERE users.id = ' . $idFromSlug; } else { $query .= ' WHERE users.id = ' . $oUser->getUserId(); } # get deleted files? if ($deleted) { $query .= ' and files.deleted = 0 '; } echo $query; exit; # execute $oResult = $this->mysqli->query($query); # fetch it $result = parent::fetchResultAssoc($oResult); # and return return $result[0]['countFiles']; }
public function countSessions() { # the query $query = $this->mysqli->query('SELECT count(*) as amount FROM `sessions` WHERE `remote_ip` != \'localhost\''); # the result $result = parent::fetchResultAssoc($query); # return result return $result; }