database_real_escape_string($search_text)."%' "; // GET TOTAL RESULTS $total_music = $database->database_num_rows($database->database_query($sql." LIMIT 201")); // IF NOT TOTAL ONLY //if( $t=="music" ) { // MAKE MUSIC PAGES $start = ($p - 1) * $results_per_page; $limit = $results_per_page+1; // Lang for download song SE_Language::_preload(4000095); SE_Language::load(); // SEARCH MUSIC $sql .= " ORDER BY se_music.music_id DESC LIMIT $start, $limit"; $resource = $database->database_query($sql) or die($database->database_error()); while( $music_info=$database->database_fetch_assoc($resource) ) { // CREATE AN OBJECT FOR USER $profile = new se_user(); $profile->user_info['user_id'] = $music_info['user_id']; $profile->user_info['user_username'] = $music_info['user_username']; $profile->user_info['user_fname'] = $music_info['user_fname']; $profile->user_info['user_lname'] = $music_info['user_lname']; $profile->user_info['user_photo'] = $music_info['user_photo']; $profile->user_displayname(); $result_url = $url->url_create('profile', $music_info['user_username']); $result_name = 4000105; $result_desc = 4000106; $userdir = $url->url_userdir($music_info['user_id']); $music_path = "{$userdir}{$music_info['music_id']}.{$music_info['music_ext']}"; // IF NO TITLE if( !trim($music_info['music_title']) ) { SE_Language::_preload(589); SE_Language::load(); $music_info['music_title'] = SE_Language::_get(589); } $dl_lv = SE_Language::_get(4000095); $desc3 = << EOF; if( $user->user_exists && $user->level_info['level_music_allow_downloads'] ) $desc3 .= << {$dl_lv} EOF; $desc3 .= "
"; $results[] = array( 'result_url' => $result_url, 'result_icon' => './images/icons/music_music48.gif', 'result_name' => $result_name, 'result_name_1' => $music_info['music_title'], 'time' => $music_info['music_date'], 'result_desc' => $result_desc, 'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']), 'result_desc_2' => $profile->user_displayname, 'user_id' => $profile->user_info["user_id"], 'user_photo' => $profile->user_info["user_photo"], 'result_desc_3' => $desc3 ); } // SET TOTAL RESULTS $total_results = $total_music; } // SET ARRAY VALUES SE_Language::_preload_multi(4000104, 4000105, 4000106); if($total_music > 200) { $total_music = "200+"; } $search_objects[] = array( 'search_type' => 'music', 'search_lang' => 4000104, 'search_total' => $total_music ); } function search_music_new(){ global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $user; // CONSTRUCT QUERY $sql = " SELECT se_music.*, se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname FROM se_music LEFT JOIN se_users ON se_users.user_id=se_music.music_user_id WHERE se_music.music_title LIKE '%".$database->database_real_escape_string($search_text)."%' "; // GET TOTAL RESULTS $total_music = $database->database_num_rows($database->database_query($sql." LIMIT 201")); // IF NOT TOTAL ONLY //if( $t=="music" ) { // MAKE MUSIC PAGES $start = ($p - 1) * $results_per_page; $limit = $results_per_page+1; // Lang for download song SE_Language::_preload(4000095); SE_Language::load(); // SEARCH MUSIC $sql .= " ORDER BY se_music.music_id DESC LIMIT $start, $limit"; $resource = $database->database_query($sql) or die($database->database_error()); while( $music_info=$database->database_fetch_assoc($resource) ) { // CREATE AN OBJECT FOR USER $profile = new se_user(); $profile->user_info['user_id'] = $music_info['user_id']; $profile->user_info['user_username'] = $music_info['user_username']; $profile->user_info['user_fname'] = $music_info['user_fname']; $profile->user_info['user_lname'] = $music_info['user_lname']; $profile->user_info['user_photo'] = $music_info['user_photo']; $profile->user_displayname(); $result_url = $url->url_create('profile', $music_info['user_username']); $result_name = 4000105; $result_desc = 4000106; $userdir = $url->url_userdir($music_info['user_id']); $music_path = "{$userdir}{$music_info['music_id']}.{$music_info['music_ext']}"; // IF NO TITLE if( !trim($music_info['music_title']) ) { SE_Language::_preload(589); SE_Language::load(); $music_info['music_title'] = SE_Language::_get(589); } $dl_lv = SE_Language::_get(4000095); $desc3 = << EOF; if( $user->user_exists && $user->level_info['level_music_allow_downloads'] ) $desc3 .= << {$dl_lv} EOF; $desc3 .= "
"; $results[] = array( 'result_url' => $result_url, 'result_icon' => './images/icons/music_music48.gif', 'result_name' => $result_name, 'result_name_1' => $music_info['music_title'], 'time' => $music_info['music_date'], 'result_desc' => $result_desc, 'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']), 'result_desc_2' => $profile->user_displayname, 'user_id' => $profile->user_info["user_id"], 'user_photo' => $profile->user_info["user_photo"], 'result_desc_3' => $desc3 ); } // SET TOTAL RESULTS $total_results = $total_music; } // SET ARRAY VALUES SE_Language::_preload_multi(4000104, 4000105, 4000106); if($total_music > 200) { $total_music = "200+"; } $search_objects[] = array( 'search_type' => 'music', 'search_lang' => 4000104, 'search_total' => $total_music ); } // THIS FUNCTION IS RUN DURING THE SEARCH PROCESS TO SEARCH THROUGH ALBUMS AND MEDIA // INPUT: // OUTPUT: function search_music() { global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results, $user; // CONSTRUCT QUERY $sql = " SELECT se_music.*, se_users.user_id, se_users.user_username, se_users.user_photo, se_users.user_fname, se_users.user_lname FROM se_music LEFT JOIN se_users ON se_users.user_id=se_music.music_user_id WHERE se_music.music_title LIKE '%".$database->database_real_escape_string($search_text)."%' "; // GET TOTAL RESULTS $total_music = $database->database_num_rows($database->database_query($sql." LIMIT 201")); // IF NOT TOTAL ONLY if( $t=="music" ) { // MAKE MUSIC PAGES $start = ($p - 1) * $results_per_page; $limit = $results_per_page+1; // Lang for download song SE_Language::_preload(4000095); SE_Language::load(); // SEARCH MUSIC $sql .= " ORDER BY se_music.music_id DESC LIMIT $start, $limit"; $resource = $database->database_query($sql) or die($database->database_error()); while( $music_info=$database->database_fetch_assoc($resource) ) { // CREATE AN OBJECT FOR USER $profile = new se_user(); $profile->user_info['user_id'] = $music_info['user_id']; $profile->user_info['user_username'] = $music_info['user_username']; $profile->user_info['user_fname'] = $music_info['user_fname']; $profile->user_info['user_lname'] = $music_info['user_lname']; $profile->user_info['user_photo'] = $music_info['user_photo']; $profile->user_displayname(); $result_url = $url->url_create('profile', $music_info['user_username']); $result_name = 4000105; $result_desc = 4000106; $userdir = $url->url_userdir($music_info['user_id']); $music_path = "{$userdir}{$music_info['music_id']}.{$music_info['music_ext']}"; // IF NO TITLE if( !trim($music_info['music_title']) ) { SE_Language::_preload(589); SE_Language::load(); $music_info['music_title'] = SE_Language::_get(589); } $dl_lv = SE_Language::_get(4000095); $desc3 = << EOF; if( $user->user_exists && $user->level_info['level_music_allow_downloads'] ) $desc3 .= << {$dl_lv} EOF; $desc3 .= "
"; $results[] = array( 'result_url' => $result_url, 'result_icon' => './images/icons/music_music48.gif', 'result_name' => $result_name, 'result_name_1' => $music_info['music_title'], 'time' => $music_info['music_date'], 'result_desc' => $result_desc, 'result_desc_1' => $url->url_create('profile', $profile->user_info['user_username']), 'result_desc_2' => $profile->user_displayname, 'result_desc_3' => $desc3 ); } // SET TOTAL RESULTS $total_results = $total_music; } // SET ARRAY VALUES SE_Language::_preload_multi(4000104, 4000105, 4000106); if($total_music > 200) { $total_music = "200+"; } $search_objects[] = array( 'search_type' => 'music', 'search_lang' => 4000104, 'search_total' => $total_music ); } // END search_album() FUNCTION // THIS FUNCTION IS RUN WHEN A USER IS DELETED // INPUT: $user_id REPRESENTING THE USER ID OF THE USER BEING DELETED // OUTPUT: function deleteuser_music($user_id) { global $database; // DELETE ALBUMS, MEDIA, AND COMMENTS $database->database_query("DELETE FROM se_music WHERE se_music.music_user_id='$user_id'"); } // END deleteuser_music() FUNCTION // THIS FUNCTION IS RUN WHEN GENERATING SITE STATISTICS // INPUT: // OUTPUT: function site_statistics_music(&$args) { global $database; $statistics =& $args['statistics']; // NOTE: CACHING WILL BE HANDLED BY THE FUNCTION THAT CALLS THIS $total = $database->database_fetch_assoc($database->database_query("SELECT COUNT(music_id) AS total FROM se_music")); $statistics['music'] = array( 'title' => 4000107, 'stat' => (int) ( isset($total['total']) ? $total['total'] : 0 ) ); } // END site_statistics_music() FUNCTION ?>