public function getList($table, $sort_col = "id", $sort_dir = "up", $page = 0, $limit = 100, $fields = NULL, $safe_fields = false, $where = array(), $search = "") { $table_whitelist = array("team", "organization_user", "feed_entry"); if (!in_array($table, $table_whitelist)) { return array(); } if (is_null($fields)) { $fields = "t.*"; $safe_fields = true; } $fields_q = DBHandler::createFieldString($fields, "t", $safe_fields); $sort_dir = $sort_dir == "up" ? "ASC" : "DESC"; $limit = DBHandler::createLimitString($page, $limit); $where["organization_id"] = $this->organization_id; if ($table !== "organization_user") { $where["organization_domain_id"] = $this->organization_domain_id; } $where = DBHandler::createWhereString($where, "t"); if (strlen($search)) { $where = DBHandler::addSearchToWhere($where, "t", $fields, $search); } return $this->dbh->query("SELECT {$fields_q} FROM `{$table}` t WHERE {$where[0]} ORDER BY t.`{$sort_col}` {$sort_dir} LIMIT {$limit}", $where[1]); }