/** *导入用户头像 *@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('导出结束'); } }