/** * @access public */ function searchCategoryByName($name) { $query = 'SELECT id FROM ' . OOMedia::getTableName() . ' WHERE name = "' . addslashes($name) . '"'; $sql = new sql(); $result = $sql->get_array($query); $media = array(); foreach ($result as $line) { $media[] = OOMediaCategory::getCategoryById($line['id']); } return $media; }
/** * @access public */ function searchMediaByFileName($name) { $query = 'SELECT file_id FROM ' . OOMedia::getTableName() . ' WHERE filename = "' . addslashes($name) . '"'; $sql = new sql(); $result = $sql->get_array($query); $media = array(); foreach ($result as $line) { $media[] = OOMedia::getMediaById($line['file_id']); } return $media; }