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 = 300;
// 采集数量
$con = get_con();
$collect = new Collect();
$result = mysql_query("select album_id from {DBPREFIX}album where album_title='' or album_title is null limit {$collect_size}", $con);
$albumIdArr = array();
while (!!($row = mysql_fetch_array($result))) {
$albumIdArr[] = $row['album_id'];
}
if (!empty($albumIdArr)) {
$albumInfoArr = $collect->albumInfo($albumIdArr, COVERSAVEPATH, COVERRELATIVEPATH);
if (!empty($albumInfoArr)) {
foreach ($albumInfoArr as $album) {
$data['album_id'] = $album['album_id'];
$data['album_title'] = $album['album_title'];
$data['album_cover'] = $album['album_cover'];
$data['time'] = $album['time'];
$data['styles'] = $album['styles'];
$data['company'] = $album['company'];
$data['description'] = $album['description'];
$data['status'] = 1;
// 已审核
$data['create_time'] = time();
$albumSql = "update\n " . DBPREFIX . "album\n set\n album_title = '{$data['album_title']}',\n album_cover = '{$data['album_cover']}',\n time = '{$data['time']}',\n styles = '{$data['styles']}',\n company = '{$data['company']}',\n\t\t\t\t\t\t\t\tdescription='{$data['description']}',\n\t\t\t\t\t\t\t\tstatus='{$data['status']}',\n\t\t\t\t\t\t\t\tcreate_time='{$data['create_time']}'\n where\n album_id = {$data['album_id']}";
// echo $albumSql;die;
mysql_query($albumSql, $con);
