超级卵杰的自动脚本（4）积分管理系统

管理系统"/>

超级卵杰的自动脚本（4）积分管理系统

我这用MySQL来储存积分信息。（建议用老版本的MySQL，新版本加密方式变了，pymysql连不上。即使改了加密方式，每次开机都要重启MySQL才行。）

至于mysql安装配置，百度一下，你就知道。

sql语句也是，百度一下，你就知道。

我是提前把表建好：

使用pymysql可以用python操作MySQL

卵杰的积分库时常抽风或挂掉，这时就要调用数据库中的积分。

import pymysql
try:credit = requests.get('.do?nickName=')credit.encoding = 'utf-8'CREDIT = credit.textpattern = '"credit":(.*?),"'CREDIT = re.findall(pattern, CREDIT)CREDIT = int(CREDIT[0])
except:con = pymysql.connect(host='localhost', port=3306, user='root', password='Sars@945945', charset='utf8')cur = con.cursor()cur.execute('use xiaojie')sql_insert = 'select * from xiaojie order by time desc limit 1'cur.execute(sql_insert)data_one = cur.fetchone()CREDIT = data_one[1]

而且数据库需要时时更新：

将网上获取积分与数据库对比，若不同，则添加最新积分数据。并添加新的线程。

def point():con = pymysql.connect(host='localhost', port=3306, user='root', password='Sars@945945', charset='utf8')cur = con.cursor()cur.execute('use xiaojie')sql_insert = 'select * from xiaojie order by time desc limit 1'cur.execute(sql_insert)data_one = cur.fetchone()old_point = data_one[1]while 1:try:point = requests.get('.do?nickName=')point.encoding = 'utf-8'POINT = point.textpattern = '"credit":(.*?),"'Point = re.findall(pattern, POINT)point = int(Point[0])except:print('服务器繁忙')if point != old_point:differential = point - old_pointsql_insert = 'insert into xiaojie(time,point,difference) values (%s,%s,%s);'DATA = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())DATA = str(DATA)POINT = pointDIFFERENCE = differentialcur.execute(sql_insert, [DATA, POINT, DIFFERENCE])conmit()old_point = pointprint(old_point)time.sleep(60)
def main():init()t1 = Thread(target=get_dm)t2 = Thread(target=keep_live)t3 = Thread(target=sign)t4 = Thread(target=point)t1.start()t2.start()t3.start()t4.strat()
if __name__ == '__main__':main()

同样在nickName=后面添加自己斗鱼id

把上述代码加到原代码中就可以了。