【loc新注册用户邀请人】爬虫脚本 运行前准 - Assbbs
【loc新注册用户邀请人】爬虫脚本 运行前准备： 1. 创建一个 mysql 数据库，并且选 utf8mb4编码 ，并修改 pymysql.connect 这一行的配置 2. 脚本最后面添加自己的用户名密码 - - coding=utf-8 - - import requests import re import pymysql import sys db=…
【loc新注册用户邀请人】爬虫脚本 运行前准备： 1. 创建一个 mysql 数据库，并且选 utf8mb4编码 ，并修改 pymysql.connect 这一行的配置 2. 脚本最后面添加自己的用户名密码 - - coding=utf-8 - - import requests import re import pymysql import sys db=pymysql.connect & 39;127.0.0.1& 39;,& 39;loc reg& 39;,& 39;passwd& 39;,& 39;loc reg& 39;,charset=& 39;utf8mb4& 39; cur=db.cursor db.ping try: sql=""" create table if not exists loc reg relation uid bigint ,username varchar 64 ,regtime varchar 64 ,puid bigint ,pusername varchar 64 ; """ cur.execute sql db.commit except Exception as e: print e sys.exit 0 home=& 39;https://www.hostloc.com& 39; forum home=home+& 39;/forum.php?mod=forumdisplay&fid=45&orderby=dateline&filter=author&orderby=dateline&page={}& 39; login url=home+& 39;/member.php?mod=logging&action=login&loginsubmit=yes&infloat=yes&lssubmit=yes&inajax=1& 39; login data={ & 39;fastloginfield& 39;:& 39;username& 39; ,& 39;username& 39;:& 39;& 39; ,& 39;cookietime& 39;:& 39;2592000& 39; ,& 39;password& 39;:& 39;& 39; ,& 39;quickforward& 39;:& 39;yes& 39; ,& 39;handlekey& 39;:& 39;ls& 39; } headers={ & 39;Accept& 39;:& 39;text/html,application/xhtml+xml,application/xml;q=0.9,image/webp, / ;q=0.8& 39; ,& 39;Accept-Encoding& 39;:& 39;gzip, deflate, sdch& 39; ,& 39;Accept-Language& 39;:& 39;zh-CN,zh;q=0.8,en;q=0.6& 39; ,& 39;Host& 39;:& 39;www.hostloc.com& 39; ,& 39;Referer& 39;:& 39;https://www.hostloc.com/forum.php& 39; ,& 39;Upgrade-Insecure-Requests& 39;:& 39;1& 39; ,& 39;User-Agent& 39;:& 39;Mozilla/5.0 Windows NT 6.1; WOW64 AppleWebKit/537.36 KHTML, like Gecko Chrome/50.0.2661.102 Safari/537.36& 39; } class HostLoc : def init self,username,passwd : self.username=username self.passwd=passwd self.session=requests.Session self.session.headers=headers login data & 39;username& 39; =username login data & 39;password& 39; =passwd login data & 39;formhash& 39; =self.get hidden value home,& 39;formhash& 39; self.login def login self : self.session.post login url,data=login data,verify=False def isLogin self : url=& 39;https://w…