- while ($item = $_SGLOBAL['db'] -> fetch_array($query)) {
- $item = saddslashes($item);
- $_SGLOBAL['supe_uid'] = $item['uid'];
- $_SGLOBAL['supe_username'] = $item['username'];
- $_SGLOBAL['timestamp'] = time();
- $tag_itemid = $item['itemid'];
- $tag_subject = $item['subject'];
- $tag_message = $item['message'];
- $subjectenc = rawurlencode(strip_tags($tag_subject));
- $messageenc = rawurlencode(strip_tags($tag_message));
- $tag_keyword = '';
- echo $tag_itemid;
- echo "<br>";
- $data = @implode('', file("http://www.xxx.com/kw.html?title=$subjectenc&content=$messageenc&ics=$charset&ocs=$charset"));
- if($data) {
- $parser = xml_parser_create();
- xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, 0);
- xml_parser_set_option($parser, XML_OPTION_SKIP_WHITE, 1);
- xml_parse_into_struct($parser, $data, $values);
- xml_parser_free($parser);
- $kws = array();
- foreach($values as $valuearray) {
- if($valuearray['tag'] == 'kw' || $valuearray['tag'] == 'ekw') {
- if(PHP_VERSION > '5' && $charset != 'utf-8') {
- $valuearray['value'] = encodeconvert("UTF-8", $valuearray['value']);
- } else {
- $valuearray['value'] = trim($valuearray['value']);
- }
- $kws[] = $valuearray['value'];
- }
- }
- if($kws) {
- foreach($kws as $kw) {
- $kw = htmlspecialchars($kw);
- $tag_keyword .= $kw.' ';
- }
- $tag_keyword = htmlspecialchars($tag_keyword);
- }
- }
- $tagarr = posttag($tag_keyword);
- postspacetag( "add", $tag_type, $tag_itemid, $tagarr );
- $tagnamearr = array_merge( $tagarr['existsname'], $tagarr['nonename'] );
- $setsqlarr['relativetags'] = addslashes( serialize( $tagnamearr ) );
- $setsqlarr['relativeitemids'] = getrelativeitemids( $setsqlarr['itemid'], array( "news" ) );
- $_SGLOBAL['db']->query("UPDATE ".tname('spacenews')." SET relativetags = '".$setsqlarr['relativetags']."' ,relativeitemids = '".$setsqlarr['relativeitemids']."' WHERE itemid = ".$tag_itemid."");
- echo "写入成功,继续下一个!<br>";
- }
- echo "全部完成!";
复制代码 贴出核心代码,供楼主改进使用 |