/**
*导入用户头像
*@date 2010-7-20
*@time 下午02:14:37
*/
function ex_avatar()
{
//导入用户头像
$dao = new Model();
$count = $dao->Table("cdb_memberfields")->count();
import("ORG.Util.Page");
//引用分页类
$p = new page($count, 200);
$page = $p->show();
//显示分页
$this->assign("showpage_bot", $page);
//显示分页
$limit = $p->firstRow . "," . $p->listRows;
//设定分面的大小
$limit = $limit == "," ? '' : $limit;
//分页的大小
$data = $dao->Table("cdb_memberfields")->limit($limit)->findAll();
$member = D("Members");
echo $page;
foreach ($data as $v) {
//dump($v['avatar']);
if ($v['avatar']) {
$info = array();
$info['id'] = $v['uid'];
$info['avatar'] = $v['avatar'];
$member->save($info);
dump($member->getLastSql());
} else {
continue;
}
}
echo $page;
}
/**
*导出城市指南内容
*@date 2010-5-12
*@time 下午04:58:29
*/
function get_cityguide()
{
load("extend");
$cid = array(1 => '2', 2 => '3', 27 => '1', 28 => '4');
$p = $_GET['page'];
//导出城市指南内容
$dao = new Model();
//$sql="SELECT a.*,b.my_content FROM bfc_article AS a LEFT JOIN bfc_article_content_4 AS b ON a.aid=b.aid";
$p1 = empty($p) ? 0 : $p * 50;
$p2 = ($p + 1) * 50;
$sqlc = "SELECT count(*) c FROM bfc_article AS a LEFT JOIN bfc_article_content_4 AS b ON a.aid=b.aid LEFT JOIN bfc_reply AS r ON b.rid=r.rid";
$list = $dao->query($sqlc);
if ($list[0]['c'] > $p2) {
$np = empty($p) ? 2 : $p + 1;
$limit = "LIMIT {$p1},50";
echo $limit . "<hr>";
$sql = "SELECT a.*,b.my_content,r.content FROM bfc_article AS a LEFT JOIN bfc_article_content_4 AS b ON a.aid=b.aid LEFT JOIN bfc_reply AS r ON b.rid=r.rid ORDER BY a.aid {$limit}";
echo $sql . '<br>';
echo '<a href="' . __URL__ . '/get_cityguide/page/' . $np . '">下一页</a>';
$list = $dao->query($sql);
echo $dao->getLastSql();
$i = 1;
//dump(empty($list));
if (!empty($list)) {
foreach ($list as $v) {
$t = time();
$v['fid'] = $v['fid'] + 1000;
$data = array();
$data['typeid'] = $v['fid'];
//$data['cid']=$cid[$v['city_id']];
$data['uid'] = $v['uid'];
$data['channel'] = 2;
$data['click'] = $v['hits'];
$data['title'] = $v['title'];
$data['pubdate'] = $v['posttime'];
$data['senddate'] = $v['posttime'];
$data['senddate'] = $v['posttime'];
$data['showstart'] = $v['posttime'];
$kw = str_word_count($v['title'], 1);
$keywords = "";
foreach ($kw as $vkw) {
$keywords .= $vkw . ',';
}
$data['keywords'] = empty($v['keywords']) ? trim($keywords, ',') : $v['keywords'];
$data['comments'] = $v['comments'];
$data['picurl'] = $v['picurl'];
$data['my_content'] = empty($v['my_content']) ? '' : nl2br(strip_tags($v['my_content']));
$data['uip'] = $v['ip'];
$data['uid'] = $v['uid'];
$data['lastview'] = $v['lastview'];
$data['editpwd'] = $v['edittime'];
$data['ismake'] = $v['yz'];
$data['description'] = msubstr(strip_tags($v['my_content']), 0, 200);
$aid = $dao->Table('iic_archives')->add($data);
if ($aid) {
$article = array();
$article['aid'] = $aid;
$article['content'] = $v['content'];
$article_id = $dao->Table('iic_addon_article')->add($article);
if ($article_id) {
echo '执行成功!<br>';
} else {
echo '<b>附加表写入失败！!<b><br>';
//$this->error('附加表写入失败！');
}
} else {
echo '<b>档案表写入失败！!<b><br>';
}
}
echo '<script>setTimeout(window.location.href="' . __URL__ . '/get_cityguide/page/' . $np . '",300000);</script>';
echo '<a href="' . __URL__ . '/get_cityguide/page/' . $np . '">下一页</a>';
} else {
echo '<b>数据查询失败！!<b><br>';
}
} else {
exit('导出结束');
}
}
