예제 #1
0
require_once 'Snoopy.class.php';
$sg = new sogouwx();
for (;;) {
    $time = date("Hi");
    $sql = mysqli_query($connect, "SELECT * FROM `wx_pinfo` WHERE `updates`=1 AND `ntime`<={$time};");
    while ($row = mysqli_fetch_assoc($sql)) {
        if ($row) {
            if ($row['ntime'] > 2400) {
                $ntime = 0 + $row['numbers'] * 100;
            } else {
                $ntime = $row['ntime'] + $row['numbers'] * 100;
            }
            $newsql = mysqli_query($connect, "SELECT `wzurl` FROM `wx_article` WHERE `uid`='{$row['id']}' order by `ctime` desc;");
            $newrow = mysqli_fetch_row($newsql);
            $openid = $sg->get_openid($row['gname'], $row['gnumber']);
            $articles = $sg->list_article($openid, $newrow[0]);
            for ($i = 0; $i < count($articles); $i++) {
                mysqli_query($connect, "INSERT INTO `wx_article` (`uid`,`wzurl`,`imgurl`,`wztitle`,`description`,`ctime`,`gtime`,`numbers`,`days`,`uctime`,`ntime`) VALUES('{$row['id']}','{$articles[$i]['url']}','{$articles[$i]['imgurl']}','{$articles[$i]['title']}','{$articles[$i]['description']}','{$articles[$i]['ctime']}','{$row['gtime']}','{$row['numbers']}','{$row['days']}','" . time() . "','{$row['gtime']}')");
            }
            mysqli_query($connect, "UPDATE `wx_reads`.`wx_pinfo` SET `ntime`='{$ntime}' WHERE (`id`='{$row['id']}');");
        }
    }
    sleep(1);
}
class sogouwx
{
    private $userAgent = 'Mozilla/5.0 (Windows NT 6.1; rv:31.0) Gecko/20100101 Firefox/31.0';
    private $UserURL = 'http://weixin.sogou.com/';
    private $cookiepath = '/cti/html/';
    function __construct()
    {
예제 #2
0
파일: getinfo.php 프로젝트: uuking/test
<?php 
if ($_GET['level'] == "first") {
    $sg = new sogouwx();
    $wxname = trim($_GET['name']);
    $weixin = trim($_GET['weixin']);
    $type = trim($_GET['type']);
    $sql = mysqli_query($connect, "SELECT * FROM `wx_pinfo` WHERE `gnumber`='{$weixin}';");
    $row = mysqli_fetch_array($sql);
    if ($row) {
        echo "该公众号已经收录,文章会定期更新.";
    } else {
        $openid = $sg->get_openid($wxname, $weixin);
        if (!$openid) {
            die("没有找到微信号,请使用搜狗搜索微信公众号确认微信号是否正确.");
        }
        $articles = $sg->list_article($openid);
        mysqli_query($connect, "INSERT INTO `wx_pinfo` (`gname`,`gnumber`,`tid`) VALUES('{$wxname}','{$weixin}','{$type}')");
        for ($i = 0; $i < count($articles); $i++) {
            $sql = mysqli_query($connect, "SELECT * FROM `wx_pinfo` WHERE `gnumber`='{$weixin}';");
            $row = mysqli_fetch_array($sql);
            mysqli_query($connect, "INSERT INTO `wx_article` (`uid`,`wzurl`,`imgurl`,`wztitle`,`description`,`ctime`) VALUES('{$row['id']}','{$articles[$i]['url']}','{$articles[$i]['imgurl']}','{$articles[$i]['title']}','{$articles[$i]['description']}','{$articles[$i]['ctime']}')");
        }
    }
    // $openid = $sg->get_openid($wxname, $weixin);
    // if(!$openid) die("没有找到微信号:$weixin 的OPENID!<br>");
    // echo "openid=$openid<br>";
    // $articles = $sg->list_article($openid);
    // foreach ($articles as $art) {
    //     echo "<br>"."标题:".$art['title']."<br>";
    //     echo "url:".$art['url']."<br>";
    //     echo "imgurl:".$art['imgurl']."<br>";