- // post categories and "save to file" use the same item.file table for storage.
- // We will differentiate the different uses by wrapping categories in angle brackets
- // and save to file categories in square brackets.
- // To do this we need to escape these characters if they appear in our tag.
-
- /**
- * @brief URL encode <, >, left and right brackets
- *
- * @param string $s String to be URL encoded.
- *
- * @return string The URL encoded string.
- */
- public static function encode($s)
- {
- return str_replace(['<', '>', '[', ']'], ['%3c', '%3e', '%5b', '%5d'], $s);
- }
-
- /**
- * @brief URL decode <, >, left and right brackets
- *
- * @param string $s The URL encoded string to be decoded
- *
- * @return string The decoded string.
- */
- public static function decode($s)
- {
- return str_replace(['%3c', '%3e', '%5b', '%5d'], ['<', '>', '[', ']'], $s);
- }
-
- /**
- * @brief Query files for tag
- *
- * @param string $table The table to be queired.
- * @param string $s The search term
- * @param string $type Optional file type.
- *
- * @return string Query string.
- */
- public static function fileQuery($table, $s, $type = 'file')
- {
- if ($type == 'file') {
- $str = preg_quote('[' . str_replace('%', '%%', self::encode($s)) . ']');
- } else {
- $str = preg_quote('<' . str_replace('%', '%%', self::encode($s)) . '>');
- }
-
- return " AND " . (($table) ? DBA::escape($table) . '.' : '') . "file regexp '" . DBA::escape($str) . "' ";
- }
-
- /**
- * @brief Get file tags from list
- *
- * ex. given music,video return <music><video> or [music][video]
- * @param string $list A comma delimited list of tags.
- * @param string $type Optional file type.
- *
- * @return string A list of file tags.
- */
- public static function listToFile($list, $type = 'file')
- {
- $tag_list = '';
- if (strlen($list)) {
- $list_array = explode(",", $list);
- if ($type == 'file') {
- $lbracket = '[';
- $rbracket = ']';
- } else {
- $lbracket = '<';
- $rbracket = '>';
- }
-
- foreach ($list_array as $item)
- {
- if (strlen($item))
- {
- $tag_list .= $lbracket . self::encode(trim($item)) . $rbracket;
- }
- }
- }
-
- return $tag_list;
- }
-
- /**
- * @brief Get list from file tags
- *
- * ex. given <music><video>[friends], return music,video or friends
- * @param string $file File tags
- * @param string $type Optional file type.
- *
- * @return string Comma delimited list of tag names.
- */
- public static function fileToList($file, $type = 'file')
- {
- $matches = false;
- $list = '';
-
- if ($type == 'file') {
- $cnt = preg_match_all('/\[(.*?)\]/', $file, $matches, PREG_SET_ORDER);
- } else {
- $cnt = preg_match_all('/<(.*?)>/', $file, $matches, PREG_SET_ORDER);
- }
-
- if ($cnt)
- {
- foreach ($matches as $mtch)
- {
- if (strlen($list))
- {
- $list .= ',';
- }
-
- $list .= self::decode($mtch[1]);
- }
- }
-
- return $list;
- }
-