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'];
$sql = "update\n " . DBPREFIX . "artist\n set\n name = '{$data['name']}',\n avatar = '{$data['avatar']}',\n area = '{$data['area']}',\n birth = '{$data['birth']}'\n where\n id = {$data['id']}";
// echo $sql;die;
mysql_query($sql, $con);
}
}
}
close_con($con);
?>
