public function getByParent($parent, $order = NULL) { $sql = "SELECT * FROM " . $this->tableName . " WHERE rid = '" . $parent . "'"; if ($order) { $sql .= " ORDER BY " . $order; } else { $sql .= " ORDER BY date DESC"; } $messages = $this->connect->queryAll($sql); return $messages; }
private function filterDeleted($files, $user) { $sql = "SELECT * " . " FROM oc_activity " . " WHERE user = '******' AND type = 'file_deleted'"; $deletedfiles = $this->connect->queryAll($sql); $diff_keys = array(); foreach ($files as $f => $file) { if (in_array($file['file'], array_column($deletedfiles, 'file'))) { $diff_keys[] = $f; } } $filtered = array_diff_key($files, $diff_keys); return $filtered; }
public function getByAuthorOrSubscriber($subscriber = NULL, $parent = NULL) { $userid = !empty($subscriber) ? $subscriber : $this->user; if ($userid) { $sql = "SELECT um.id as id, m.id as messageid, m.date, m.title, m.text, m.attachements, m.author, m.subscribers, um.status" . " FROM " . $this->tableName . " um" . " INNER JOIN *PREFIX*collab_messages m ON m.id = um.mid" . " WHERE (m.author = '" . $userid . "' OR m.subscribers LIKE '%" . $userid . "%')"; if (!($parent == NULL)) { $sql .= " AND m.rid = " . $parent; } $sql .= " GROUP BY m.id" . " ORDER BY m.date DESC"; $messages = $this->connect->queryAll($sql); return $messages; } else { return false; } }
/** * Get correct userid by given * @param $user string * @return array */ public function getCaseInsensitiveId($user) { $sql = "SELECT uid" . " FROM " . $this->tableName . " WHERE LOWER(uid) = LOWER('" . $user . "')"; $res = $this->connect->queryAll($sql); $row = $res[0]; return $row['uid']; }
public function getUsersEmails($uidsString) { if (is_string($uidsString)) { $sql = "SELECT p.configvalue as email, u.uid, u.displayname as name\n FROM oc_preferences p\n LEFT JOIN oc_users u ON (u.uid = p.userid)\n WHERE p.configkey = 'email' AND p.appid = 'settings' AND p.userid IN ({$uidsString});"; $result = $this->connect->queryAll($sql); return $result; } }
/** * Get all group names * @return array */ public function getAllGroups() { $sql = "SELECT gid FROM *PREFIX*group_user"; $res = $this->connect->queryAll($sql); foreach ($res as $r => $row) { $groups[] = $row['gid'] . '-group'; } return $groups; }
/** * @param bool $refresh * @return mixed|null */ public function getUngroupUsers($refresh = false) { static $usersData = null; if ($usersData === null || $refresh) { $sql = "SELECT u.uid, u.displayname, p.configvalue as email\n FROM *PREFIX*users u\n LEFT OUTER JOIN *PREFIX*group_user gu ON (gu.uid = u.uid)\n LEFT JOIN *PREFIX*preferences p ON (p.userid = u.uid AND p.appid = 'settings' AND p.configkey = 'email')\n WHERE gu.uid IS NULL"; $usersData = $this->connect->queryAll($sql); } return $usersData; }
public function getAllIds() { $users = $this->connect->queryAll("SELECT uid FROM " . $this->tableName); return is_array($users) ? $users : []; }