<?php /** * 歌手资料采集 * 包括歌手姓名、头像、生日、地区 * 此采集较慢,因为要下载歌手头像到本地 * 最好每次只采 500 位歌手的资料 */ if (!defined('APP_PATH')) { exit("Access is denied."); } require_once APP_PATH . 'util/db.php'; require_once APP_PATH . 'util/Collect.class.php'; $collect_size = 500; // 采集数量 $con = get_con(); $collect = new Collect(); $result = mysql_query("select id from {DBPREFIX}artist where name='' or name is null limit {$collect_size}", $con); $artistIdArr = array(); while (!!($row = mysql_fetch_array($result))) { $artistIdArr[] = $row['id']; } if (!empty($artistIdArr)) { $artistInfoArr = $collect->artistInfo($artistIdArr, AVATARSAVEPATH, AVATARRELATIVEPATH); if (!empty($artistInfoArr)) { foreach ($artistInfoArr as $artist) { $data['id'] = $artist['id']; $data['name'] = $artist['name']; $data['avatar'] = $artist['avatar']; $data['area'] = $artist['area']; $data['birth'] = $artist['birth'];
function delete_user($uid) { $stmnt = "delete from users where id={$uid}"; return query_or_die($stmnt, get_con()); }
unset($get_copy['q']); $uid = NULL; if (isset($_SESSION['user_id'])) { $uid = $_SESSION['user_id']; } $start = NULL; $limit = 100; if (isset($_GET['start'])) { $start = $_GET['start']; } if (isset($_GET['limit'])) { $limit = $_GET['limit']; } unset($get_copy['start']); unset($get_copy['limit']); $result_array = filtered_search($query, $get_copy, $uid, $limit, $start, get_con()); $result = $result_array['result']; $num_rows = $result_array['count']; $num_returned = mysql_num_rows($result); ob_start(); //echos the result into a variable if (!$start) { $count = 0; } else { $count = $start; } while ($row = mysql_fetch_array($result)) { include 'prof_box.php'; $count++; } $html = ob_get_contents();
function data_count() { global $g_config; $con = get_con(); $count = mysqli_query($con, 'SELECT COUNT(*) FROM `' . $g_config['database']['db_prefix'] . 'accounting`'); return mysqli_fetch_assoc($count)['COUNT(*)']; }