1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104
| <? include 'getConnection.php'; $str = $_POST['str']; $url = $_POST['url'];
parse_str(parse_url(htmlspecialchars_decode(urldecode($url)),PHP_URL_QUERY ),$query); $biz = $query['__biz'];
$pdo = getConnection(); $sql = 'SELECT * FROM weixin WHERE biz = ?'; $stmt = $pdo->prepare($sql); $stmt->bindParam(1, $biz); $stmt->execute(); $res = $stmt->fetch(PDO::FETCH_ASSOC); if (!$res) { $sql = 'INSERT INTO weixin (biz, collect) VALUES (?, ?)'; $stmt = $pdo->prepare($sql); $stmt->execute(array($biz, strtotime("now"))); }
$json = urldecode($str); file_put_contents('./his.txt', $json);
$json = json_decode($json, true); if(!$json){ $json = json_decode(htmlspecialchars_decode($str),true); }
foreach($json['list'] as $k=>$v){ $type = $v['comm_msg_info']['type']; if($type==49){ $content_url = str_replace("\\", "", htmlspecialchars_decode($v['app_msg_ext_info']['content_url'])); $is_multi = $v['app_msg_ext_info']['is_multi']; $datetime = $v['comm_msg_info']['datetime']; $sql = 'SELECT id FROM tmplist WHERE content_url = ?'; $stmt = $pdo->prepare($sql); $stmt->bindParam(1, $content_url); $stmt->execute(); $res = $stmt->fetch(PDO::FETCH_ASSOC); if (!$res) { $sql = 'INSERT INTO tmplist (content_url) VALUES (?)'; $stmt = $pdo->prepare($sql); $stmt->bindParam(1, $content_url); $res = $stmt->execute(); $post = array(); $post['field_id'] = $v['app_msg_ext_info']['fileid']; $post['title'] = $v['app_msg_ext_info']['title']; $post['title_encode'] = urlencode(str_replace(" ", "", $post['title'])); $post['digest'] = $v['app_msg_ext_info']['digest']; $post['source_url'] = str_replace("\\", "", htmlspecialchars_decode($v['app_msg_ext_info']['source_url'])); $post['cover'] = str_replace("\\", "", htmlspecialchars_decode($v['app_msg_ext_info']['cover']));
$post['is_top'] = 1; $post['is_multi'] = $is_multi; $post['biz'] = $biz; $post['content_url'] = $content_url; $post['zdatetime'] = $datetime; $sql = 'INSERT INTO post (biz, field_id, title, title_encode, digest, content_url, source_url, cover, is_top, is_multi, zdatetime) VALUES (:biz, :field_id, :title, :title_encode, :digest, :content_url, :source_url, :cover, :is_top, :is_multi, :zdatetime)'; $stmt = $pdo->prepare($sql); $res = $stmt->execute($post); } if($is_multi==1){ foreach($v['app_msg_ext_info']['multi_app_msg_item_list'] as $kk=>$vv){ $content_url = str_replace("\\","",htmlspecialchars_decode($vv['content_url'])); $sql = 'SELECT id FROM tmplist WHERE content_url = ?'; $stmt = $pdo->prepare($sql); $stmt->bindParam(1, $content_url); $stmt->execute(); $res = $stmt->fetch(PDO::FETCH_ASSOC); if (!$res) { $sql = 'INSERT INTO tmplist (content_url) VALUES (?)'; $stmt = $pdo->prepare($sql); $stmt->bindParam(1, $content_url); $res = $stmt->execute(); $post = array(); $post['title'] = $vv['title']; $post['field_id'] = $vv['fileid']; $post['title_encode'] = urlencode(str_replace(" ","",$post['title'])); $post['digest'] = htmlspecialchars($vv['digest']); $post['source_url'] = str_replace("\\","",htmlspecialchars_decode($vv['source_url'])); $post['cover'] = str_replace("\\","",htmlspecialchars_decode($vv['cover'])); $post['zdatetime'] = $datetime; $post['is_multi'] = $is_multi; $post['is_top'] = 0; $post['biz'] = $biz; $post['content_url'] = $content_url; $sql = 'INSERT INTO post (biz, field_id, title, title_encode, digest, content_url, source_url, cover, is_multi, is_top, zdatetime) VALUES (:biz, :field_id, :title, :title_encode, :digest, :content_url, :source_url, :cover, :is_multi, :is_top, :zdatetime)'; $stmt = $pdo->prepare($sql); $res = $stmt->execute($post); } } } } }
|