function resultsToArray(&$results, $type = false) { global $backend; if ($type === false) { $arr = array(); $hash = array(); for ($i = 0; $i < $results->rows; $i++) { if (isset($results->data[$i]['leaf']) && $results->data[$i]['leaf'] == "false") { $me =& new jzMediaNode(jz_db_unescape($results->data[$i]['path'])); $me->leafcount = $results->data[$i]['leafcount']; $me->nodecount = $results->data[$i]['nodecount']; $me->artpath = jz_db_unescape($results->data[$i]['main_art']); $me->myid = $results->data[$i]['my_id']; if ($me->artpath == "") { $me->artpath = false; } $me->playcount = $results->data[$i]['playcount']; $me->dlcount = $results->data[$i]['dlcount']; $me->longdesc = jz_db_unescape($results->data[$i]['longdesc']); // Gross hack to follow; // Fixes case where an album is in 2 genres from 1 artist: if ($backend == "id3-database") { if (!isset($hash[pathize(strtolower($me->getName()))])) { $arr[] = $me; $hash[pathize(strtolower($me->getName()))] = true; } } else { $arr[] = $me; } } else { $arr[] =& new jzMediaTrack(jz_db_unescape($results->data[$i]['path'])); } } return $arr; } else { if ($type == 'tracks') { $arr = array(); for ($i = 0; $i < $results->rows; $i++) { $me =& new jzMediaTrack(jz_db_unescape($results->data[$i]['path'])); // FILL META HERE. ***// if (isset($results->data[$i]['filepath']) && $results->data[$i]['filepath'] != "") { $me->playpath = $results->data[$i]['filepath']; } if ($results->data[$i]['trackname'] != "" && $results->data[$i]['trackname'] != "-") { $me->title = jz_db_unescape($results->data[$i]['trackname']); } $arr[] = $me; } return $arr; } } }
function resultsToArray(&$results, $type = false) { global $backend; if ($type === false) { $arr = array(); $hash = array(); for ($i = 0; $i < $results->rows; $i++) { if (isset($results->data[$i]['leaf']) && $results->data[$i]['leaf'] == "false") { $me =& new jzMediaNode(jz_db_unescape($results->data[$i]['path'])); $me->leafcount = $results->data[$i]['leafcount']; $me->nodecount = $results->data[$i]['nodecount']; $me->artpath = jz_db_unescape($results->data[$i]['main_art']); $me->myid = $results->data[$i]['my_id']; if ($me->artpath == "") { $me->artpath = false; } $me->playcount = $results->data[$i]['playcount']; $me->dlcount = $results->data[$i]['dlcount']; $me->longdesc = jz_db_unescape($results->data[$i]['longdesc']); $me->ptype = jz_db_unescape($results->data[$i]['ptype']); // Gross hack to follow; // Fixes case where an album is in 2 genres from 1 artist: if ($backend == "id3-database") { if (!isset($hash[pathize(strtolower($me->getName()))])) { $arr[] = $me; $hash[pathize(strtolower($me->getName()))] = true; } } else { $arr[] = $me; } } else { $r = $results->data[$i]; $track =& new jzMediaTrack(jz_db_unescape($r['path'])); // we never query for just bitrate, so if it's returned, we have all meta. if (isset($r['bitrate']) && $r['bitrate'] != '-') { $meta = array(); $meta['title'] = jz_db_unescape($r['trackname']); $meta['bitrate'] = jz_db_unescape($r['bitrate']); $meta['frequency'] = jz_db_unescape($r['frequency']); $meta['filename'] = jz_db_unescape($r['name']); $meta['size'] = jz_db_unescape($r['filesize']); $meta['year'] = jz_db_unescape($r['year']); if (isset($r['descr'])) { $meta['comment'] = jz_db_unescape($r['descr']); } $meta['length'] = jz_db_unescape($r['length']); $meta['number'] = jz_db_unescape($r['number']); $meta['genre'] = jz_db_unescape($r['genre']); $meta['artist'] = jz_db_unescape($r['artist']); $meta['album'] = jz_db_unescape($r['album']); $meta['lyrics'] = jz_db_unescape($r['lyrics']); $meta['type'] = jz_db_unescape($r['extension']); $track->meta = $meta; } $arr[] = $track; } } return $arr; } else { if ($type == 'tracks') { $arr = array(); for ($i = 0; $i < $results->rows; $i++) { $me =& new jzMediaTrack(jz_db_unescape($results->data[$i]['path'])); // FILL META HERE. ***// if (isset($results->data[$i]['filepath']) && $results->data[$i]['filepath'] != "") { $me->playpath = $results->data[$i]['filepath']; } if ($results->data[$i]['trackname'] != "" && $results->data[$i]['trackname'] != "-") { $me->title = jz_db_unescape($results->data[$i]['trackname']); } $arr[] = $me; } return $arr; } } }
/** * Returns a string that points to the location * where this node's non-jinzora-specific data should be stored * (album art, text, etc.) * * @author Ben Dodson * @version 9/18/04 * @since 9/18/04 */ function getFilePath() { global $sql_type, $sql_pw, $sql_usr, $sql_socket, $sql_db, $allow_filesystem_modify; $path = jz_db_escape($this->getPath("String")); $results = jz_db_simple_query("SELECT filepath FROM jz_nodes WHERE path = '{$path}'"); return jz_db_unescape($results['filepath']); }