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); ?>