* 一次采集全部歌手
*/
if (!defined('APP_PATH')) {
exit("Access is denied.");
}
require_once APP_PATH . 'util/db.php';
require_once APP_PATH . 'util/Collect.class.php';
$con = get_con();
$collect = new Collect();
//$artistAreaCodeArr = array('cn', 'western', 'kr', 'jp');
$artistAreaCodeArr = array('cn');
//$artistTypeArr = array('male', 'female', 'group');
$artistTypeArr = array('male');
//$indexLetterArr = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'other');
$indexLetterArr = array('A');
$artistArr = $collect->artistList($artistAreaCodeArr, $artistTypeArr, $indexLetterArr);
if (!empty($artistArr)) {
foreach ($artistArr as $artist) {
$data['id'] = $artist['id'];
$data['index_letter'] = $artist['index_letter'];
$data['area_code'] = $artist['area_code'];
$data['type'] = $artist['type'];
$result = mysql_query("select id from " . DBPREFIX . "artist where id={$data['id']}", $con);
if (!($row = mysql_fetch_array($result))) {
// 数据库不存在该歌手 -> insert
$sql = "insert into\n " . DBPREFIX . "artist\n (id,\n index_letter,\n area_code,\n type)\n values\n ({$data['id']},\n '{$data['index_letter']}',\n '{$data['area_code']}',\n '{$data['type']}')";
} else {
// 数据库已存在该歌手 -> update
$sql = "update\n " . DBPREFIX . "artist\n set\n index_letter = '{$data['index_letter']}',\n area_code = '{$data['area_code']}',\n type = '{$data['type']}'\n where\n id = {$data['id']}";
}
mysql_query($sql, $con);
