基于Python+Html的番剧更新表及番剧详情数据库

心已赠人 2024-04-06 09:35 81阅读 0赞

番剧更新表及番剧详情数据库  
目录  
番剧更新表及番剧详情数据库 1  
一、实验题目 1  
二、开发环境 1  
三、数据库设计 1  
3.1 需求分析 2  
3.2 数据库概念设计 2  
3.3 数据库结构 3  
3.4 数据库实现 5  
四、系统设计 7  
4.1 系统后端 7  
4.2 Web服务 17  
4.3 系统前端 17  
4.4 程序模拟图 25  
五、特色和创新点 26  
六、实验分工 26  
七、提交文件说明 26  
八、实验总结 28

一、实验题目  
实验背景：  
该项目立足于目前各大平台网站的番剧信息较为分散，用户需要辗转多个平台才能获取较为完整的番剧信息的背景下，实现了各大平台网站番剧信息的整合。将各大平台网站的番剧更新信息及番剧详情信息整合制表，展现在我们的网页上。  
二、开发环境  
系统：Ubuntu 20.08  
数据库：mysql 8.0.23  
编程语言： 【后端】 python, mysql 【前端】 html+css+js  
三、数据库设计  
3.1 需求分析  
3.1.1 番剧更新表  
系统维护在播新番的当前更新集数，播放地址链接，宣传图等内容。  
番剧更新主要来源于`bilibili`，`ACfun`两个个网站。  
所有信息均通过爬虫以及python脚本进行动态维护。  
3.1.2 番剧详情表  
针对每个番剧，提供该番剧的详情信息，包括制作公司，监督，声优等内容。  
番剧详情主要来自于萌娘百科。  
信息通过爬虫python脚本动态维护  
3.1.1 用户管理  
系统用户分为超级管理员用户和普通用户。  
普通用户  
可查看数据库中的内容，可被授予删除、修改、添加番剧信息等权力。  
超级管理员  
拥有数据库的完全控制权，包括查看所有用户资料，创建新用户，用户授权等操作。

# 该模块是用户管理模块
    # 主要提供数据库中的用户管理功能
    # 实现在数据库中进行用户创建、授权、修改、删除等具体操作
    # 该模块实现的功能供user模块封装调用
    
    
    import pymysql
    import traceback
    from pymysql import cursors
    from werkzeug.security import check_password_hash, generate_password_hash
    from itertools import chain
    
    
    #默认创建普通用户，授权select
    def createUser(name,password):
        returnStatus=1
        db = pymysql.connect(host="localhost", port=3306, db="mysql", user="root", password="123456",charset='utf8')
        cursor = db.cursor()
        host = '%'
        sql1 = "create user '%s'@'%s' identified by '%s';"%\
            (name,host,password)
        sql11="grant select on yukiyu.* to '%s'@'%s';"%\
        (name, host)
       
        cursor.execute("select user from db")
        elems = cursor.fetchall()
        res = list(chain.from_iterable(elems))
        print('现有用户：')
        print(res)
        if name in res:
            print("用户%s已存在"/(name))
            return -5
    
        try:
            print('start to execute:')
            print(sql1)
            print(sql11)
            cursor.execute(sql1)
            cursor.execute(sql11)
            db.commit()
            print('create success !')
        except:
            returnStatus=0
            print('create user error!')
            db.rollback()
            traceback.print_exc()
            
        db.close()
    
    
        #在yukiyu库中的user插入同样
        db = pymysql.connect(host="localhost", port=3306, db="yukiyu", user="root", password="123456",charset='utf8')
        cursor=db.cursor()
        # data = privilegeOfUser(name)
        priv = 'YNNN'
        sql2 = """
        insert into user_list(name,password,privilege) 
        values
        ('%s','%s','%s');"""%\
        (name,generate_password_hash(password),priv)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('insert success !')
        except:
            print('insert error!')
            db.rollback()
            traceback.print_exc()
            returnStatus=0
    
        cursor.close()
        db.close()
        return returnStatus
    
    #删除用户
    def dropUser(name):
        returnStatus=1
        db = pymysql.connect(host="localhost", port=3306, db="mysql", user="root", password="123456",charset='utf8')
        cursor = db.cursor()
        host = '%'
        sql="drop user '%s'@'%s';"%\
        (name,host)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            db.commit()
            print('drop success !')
            returnStatus=1
        except:
            print('drop user error!')
            db.rollback()
            traceback.print_exc()
            returnStatus =0
    
        sql2 = """
        delete from yukiyu.user_list
        where name = '%s';
        """%\
        (name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('delete user success !')
        except:
            print('delete user error!')
            db.rollback()
            traceback.print_exc()
            returnStatus=0
    
    
        cursor.close()
        db.close()
    
        return returnStatus
    
    
    def ifManage(name):
        db = pymysql.connect(host="localhost", port=3306, db="yukiyu",user="root", password="123456", charset="utf8")
        sql = """
            select if_manager 
            from user_list
            where name = '%s';
        """%\
            (name)
        cursor=db.cursor(pymysql.cursors.DictCursor)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            data = cursor.fetchall()
            print('success !')
            print(data)
        except:
            print('error!')
            traceback.print_exc()
        
        return data[0]['if_manager']
    
    
    #授权为管理员用户，实现所有权限
    def grantSuperUser(name):
        if ifManage(name)=='Y':
            print("success")
            return 1
    
        host='%'
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor = db.cursor()
        sql="""
        grant all privileges on yukiyu.* to '%s'@'%s';
        """%\
        (name,host)
        sql2="""
        grant all privileges on *.* to '%s'@'%s';
        """%\
        (name,host)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql2)
            db.commit()
            cursor.execute(sql)
            db.commit()
            print('grant success !')
        except:
            print('grant error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
    
        data = privilegeOfUser(name)
        priv = data['privilege']
        sql2 = """
        update yukiyu.user_list
        set privilege = '%s'
        where name = '%s';
        """%\
        (priv,name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
        sql3 = """
            update yukiyu.user_list
            set if_manager = 'Y'
            where name = '%s';
        """%\
            (name)
        try:
            print('start to execute:')
            print(sql3)
            cursor.execute(sql3)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
    
        cursor.close()
        db.close()
        return 1
    
    #授权为普通用户，select权限
    def grantOrdinartUser(name):
    
        returnStatus=1
        if(ifManage(name)=='N'):
            print("grant success")
            return 1
        
    
        host = '%'
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor = db.cursor()
        sql1="revoke all privileges on yukiyu.* from '%s'@'%s';"%\
        (name,host)
        sql11="grant select on yukiyu.* to '%s'@'%s';"%\
            (name,host)
        try:
            print('start to execute:')
            print(sql1)
            print(sql11)
            cursor.execute(sql1)
            cursor.execute(sql11)
            db.commit()
            print('revoke success !')
        except:
            print('revoke error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
        sql2 = """
        update yukiyu.user_list
        set privilege = 'YNNN'
        where name = '%s';
        """%\
            (name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
    
    
        sql3 = """
            update yukiyu.user_list
            set if_manager = 'N'
            where name = '%s';
        """%\
            (name)
        try:
            print('start to execute:')
            print(sql3)
            cursor.execute(sql3)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            db.rollback()
            traceback.print_exc()
            return 0
    
        changePrivilege(name, 'YYYY')
        
        cursor.close()
        db.close()
        return returnStatus
    
    
    # 查看指定权限
    def checkOnePriv(name, privilege):
        s = privilege+'_priv'
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor=db.cursor(pymysql.cursors.DictCursor)
        sql = """
            select %s_priv
            from db
            where Db = 'yukiyu' and User = '%s';
        """%\
        (privilege,name)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            data = cursor.fetchall()
            print('success !')
        except:
            print('error!')
            db.rollback()
            traceback.print_exc()
        
        return data[0][s]
    
    
    #为指定用户增加指定权限
    def addPrivForUser(name,privilege):
    
        
        if checkOnePriv(name,privilege)=='Y':
            print("succsee")
            return 1
    
    
        host='%'
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor = db.cursor()
        sql1 = "grant %s on yukiyu.* to '%s'@'%s';"%\
            (privilege,name,host)
        try:
            print('start to execute:')
            print(sql1)
            cursor.execute(sql1)
            db.commit()
            print('grant success !')
        except:
            print('grant error!')
            traceback.print_exc()
    
        data = privilegeOfUser(name)
        priv = data['privilege']
        sql2 = """
        update yukiyu.user_list
        set privilege = '%s'
        where name = '%s';
        """%\
        (priv,name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            traceback.print_exc()
        
        cursor.close()
        db.close()
        return 1
    
    #删除指定用户的某权限
    def delPrivForUser(name,privilege):
    
        if(checkOnePriv(name , privilege)=='N'):
            print("success")
            return 1
    
        host='%'
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor = db.cursor()
        sql1 = "revoke %s on yukiyu.* from '%s'@'%s';"%\
            (privilege,name,host)
        try:
            print('start to execute:')
            print(sql1)
            cursor.execute(sql1)
            db.commit()
            print('grant success !')
        except:
            print('grant error!')
            traceback.print_exc()
        
        data = privilegeOfUser(name)
        priv = data['privilege']
        sql2 = """
        update yukiyu.user_list
        set privilege = '%s'
        where name = '%s';
        """%\
        (priv,name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('update success !')
        except:
            print('update error!')
            traceback.print_exc()
    
        cursor.close()
        db.close()
    
    
    #查询指定用户权限
    def privilegeOfUser(name):
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor=db.cursor(pymysql.cursors.DictCursor)
        sql = """
            select User, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv
            from db
            where Db = 'yukiyu' and User = '%s';
        """%\
        (name)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            print('success !')
        except:
            print('error!')
            traceback.print_exc()
        
        data = cursor.fetchall()
    
        a=data[0]["select_priv"]
        b=data[0]["insert_priv"]
        c=data[0]["update_priv"]
        d=data[0]["delete_priv"]
    
        s=a+b+c+d
    
        dict = {
        'name': data[0]['User'],'privilege':s}
    
        print(dict)
        return dict
    
    
    
    #查看所有用户及权限
    def privilegeOfAllUser():
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor=db.cursor(pymysql.cursors.DictCursor)
    
        sql = """
            select User, select_priv, insert_priv, update_priv, delete_priv, create_priv, drop_priv
            from db
            where Db = 'yukiyu';
        """
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            print('success !')
        except:
            print('error!')
            traceback.print_exc()
    
        data = cursor.fetchall()
        cursor.close()
        db.close()
        list = []
        for item in data:
            a=item['select_priv']
            b=item['insert_priv']
            c=item['update_priv']
            d=item['delete_priv']
            s=a+b+c+d
            list.append({
        'name': item['User'],'privilege':s})
    
    
        print(list)
        return list
    
    def printAllUser():
        db = pymysql.connect(host="localhost", port=3306, db="mysql",user="root", password="123456", charset="utf8")
        cursor=db.cursor(pymysql.cursors.DictCursor)
        sql = "select if_manager, user_id, name, privilege  from yukiyu.user_list;"
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            print('success !')
        except:
            print('error!')
            traceback.print_exc()
        data = cursor.fetchall()
        print(data)
    
    #返回用户密码hash值
    def getPassword(name):
        db = pymysql.connect(host="localhost", port=3306, db="yukiyu",user="root", password="123456", charset="utf8")
        cursor=db.cursor(pymysql.cursors.DictCursor)
        sql = "select password from yukiyu.user_list where name = '%s'"%\
            (name)
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            print('success !')
        except:
            print('error!')
            traceback.print_exc()
        
        data = cursor.fetchall()
        password_hash = data[0]['password']
        
        print(password_hash)
        return password_hash
    
    
    def changePrivilege(name,priv):
        
        if priv[0]=='Y':
            addPrivForUser(name,'select')
        else:
            delPrivForUser(name,'select')
    
        if priv[1]=='Y':
            addPrivForUser(name,'insert')
        else:
            delPrivForUser(name,'insert')
        
        if priv[2]=='Y':
            addPrivForUser(name,'update')
        else:
            delPrivForUser(name,'update')
    
        if priv[3]=='Y':
            addPrivForUser(name,'delete')
        else:
            delPrivForUser(name,'delete')
        
        return 1
    
    
    
    
    #包装函数
    # info中的password为明文密码
    # info = ['Y',id,'name','password','priv']
    def commmitChangeToUserlist(oldInfo, newInfo):
        db = pymysql.connect(host="localhost", port=3306, db="yukiyu", user="root", password="123456",charset='utf8')
        
        if oldInfo != None and newInfo != None:
            if oldInfo[0]=='N' and newInfo[0]=='Y':
                newInfo[4]='YYYY'
            if oldInfo[0]=='Y'and newInfo[0]=='Y' and newInfo[4]!='YYYY':
                print('privilege error')
                return -4
            
    
        sql1 = "savepoint x;"
        cursor=db.cursor()
        cursor.execute(sql1)
        print(sql1)
    
        if oldInfo == None:
            print('insert')
            returnStatus = insertItem(newInfo)
        elif newInfo==None:
            print('delete')
            returnStatus = deleteItem(oldInfo)
        else:
            print('update')
            returnStatus = updateItem(newInfo, oldInfo)
        
        if(returnStatus!=1):
            print('error')
            sql2 = "rollback to x;"
            cursor.execute(sql2)
            db.commit()
            print(sql2)
    
        sql3="release savepoint x;"
        cursor.execute(sql3)
        db.commit()
        print(sql3)
    
        return returnStatus
    
    
    
    
    #插入新用户
    def insertItem(newInfo):
        status=1
        ifManage = newInfo[0]
        name = newInfo[2]
        password = newInfo[3]
        privilege = newInfo[4]
    
        status = createUser(name,password)
        if(status!=1):
            return status
    
        if(ifManage=='Y'):
            status= grantSuperUser(name)
        else:
            status = grantOrdinartUser(name)
        
        if status!=1:
            return status
    
        status = changePrivilege(name,privilege)
        if status!=1:
            return status
        
        print('insert item success')
        return 1
    
    # 删除某用户
    def deleteItem(oldInfo):
        status=1
        name = oldInfo[2]
    
        status = dropUser(name)
    
        if status==0:
            print('delete item error')
            return 0
        
        print('delete item success')
        return status
    
    #更新信息
    
    def updateItem(newInfo, oldInfo):
        returnStatus = 1
    
        nifManage=newInfo[0]
        nname=newInfo[2]
        npassword=newInfo[3]
        npriv=newInfo[4]
    
        oifManage=oldInfo[0]
        oname=oldInfo[2]
        opassword=oldInfo[3]
        opriv=oldInfo[4]
        
        if(npriv != opriv):
            returnStatus = changePrivilege(oname,npriv)
            if returnStatus != 1:
                print('change privilege error')
                return returnStatus
            print('change privilege success')
        if(nifManage!=oifManage):
            returnStatus = changeIfManage(oname,nifManage)
            if returnStatus != 1:
                print('change ifManager error')
                return returnStatus
            print('change ifManager success')
        if(npassword!=opassword):
            returnStatus = changePassword(oname,npassword)
            if returnStatus != 1:
                print('change password error')
                return returnStatus
            print('change password success')
        if(oname != nname):
            returnStatus = changeName(oname,nname)
            if returnStatus != 1:
                print('change name error')
                return returnStatus
            print('change name success')
    
        print('update item success')
        return returnStatus
    
    
    #用户改姓名
    def changeName(oname,nname):
        returnStatus = 1
        db = pymysql.connect(host="localhost", port=3306, db="mysql", user="root", password="123456",charset='utf8')
        cursor=db.cursor()
    
        cursor.execute("select user from db")
        elems = cursor.fetchall()
        res = list(chain.from_iterable(elems))
        print('现有用户：')
        print(res)
        if nname in res:
            print("用户%s已存在"/(nname))
            return -5
    
        sql1 = """
        update db 
        set user='%s' 
        where user = '%s';"""%\
            (nname, oname)
        sql11 = """
        update user 
        set user='%s' 
        where user = '%s';"""%\
            (nname, oname)
        try:
            print('start to execute:')
            print(sql1)
            print(sql11)
            cursor.execute(sql1)
            cursor.execute(sql11)
            db.commit()
            print('success !')
            returnStatus = 1
        except:
            print('updata user error !')
            db.rollback()
            traceback.print_exception()
            returnStatus = 0
            return returnStatus
    
        sql2="""
        update yukiyu.user_list 
        set name = '%s'
        where name = '%s';"""%\
            (nname,oname)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('success !')
            returnStatus = 1
        except:
            print('updata user error !')
            db.rollback()
            traceback.print_exception()
            returnStatus = 0
            return returnStatus
    
        return 1
    
    # 用户改管理权限
    def changeIfManage(name,nIfMnage):
        db = pymysql.connect(host="localhost", port=3306, db="mysql", user="root", password="123456",charset='utf8')
        cursor=db.cursor()
    
        if(nIfMnage=='Y'):
            returnStatus = grantSuperUser(name)
        else:
            returnStatus = grantOrdinartUser(name)
    
        
        return returnStatus
    
    #用户改密码
    def changePassword(name,password):
        db = pymysql.connect(host="localhost", port=3306, db="mysql", user="root", password="123456",charset='utf8')
        cursor = db.cursor()
    
        sql = "ALTER USER '%s'@'%s' IDENTIFIED WITH mysql_native_password BY '%s';"%\
            (name,'%',password)
        
        try:
            print('start to execute:')
            print(sql)
            cursor.execute(sql)
            db.commit()
            print('success !')
            returnStatus = 1
        except:
            print('updata error !')
            db.rollback()
            traceback.print_exc()
            returnStatus = 0
    
        if(returnStatus==0):
            return returnStatus
    
        password_hash = generate_password_hash(password)
        sql2 = """
        update yukiyu.user_list
        set password = '%s'
        where name = '%s';
        """%\
            (password_hash,name)
        try:
            print('start to execute:')
            print(sql2)
            cursor.execute(sql2)
            db.commit()
            print('success !')
            returnStatus = 1
        except:
            print('updata error !')
            db.rollback()
            traceback.print_exception()
            returnStatus = 0
    
        db.close()
        return returnStatus
    
    def test1():
        
        newInfo = ['N',2,'ddd','123456','YNNN']
        commmitChangeToUserlist(None,newInfo)
        print('success')
        return
    
    def test2():
        oldInfo = ['N',2,'ddd','123456','YNNN']
        newInfo = ['Y',2,'ddd','123456','YNNN']
        commmitChangeToUserlist(oldInfo,newInfo)
    
    def test3():
        oldInfo = ['Y',2,'ddd','123456','YYYY']
        newInfo = ['Y',2,'xx','123456','YYYY']
        commmitChangeToUserlist(oldInfo,newInfo)
    
    def test4():
        oldInfo = ['N',2,'xx','123456','YNNN']
        commmitChangeToUserlist(oldInfo,None)
    
    def test5():
        oldInfo = ['N',2,'xx','123456789','YNNN']
        newInfo = ['Y',2,'xxyy','123456789','YYYY']
        commmitChangeToUserlist(oldInfo,newInfo)
    
    
    if __name__ == '__main__':
        #dropUser('xxy')
        #test1()
        #test2()
        test3()
        #test4()
    
        #test5()
        
        db = pymysql.connect(host="localhost", port=3306, db="yukiyu", user="root", password="123456",charset='utf8')
        #dropUser('xxx')
        #createUser('xxx','123456')
        #grantSuperUser('cy')
        #grantOrdinartUser('cyy')
        #addPrivForUser('cyy','delete')
        #delPrivForUser('cyy','delete')
        #privilegeOfAllUser()
        #privilegeOfUser('cyy')
        
        # printAllUser()
        # getPassword('xxx')
    
        db.close()

![在这里插入图片描述][8b938baba29a4023b02e96ef70e21bc9.png_pic_center]  
![在这里插入图片描述][8a2b31db221a4d78a3bb2db232a23cd0.png_pic_center]  
![在这里插入图片描述][42b4a300503844eab20c6bc3278db33a.png_pic_center]  
![在这里插入图片描述][6cae6f8add384b88aaec5fd7350fdf92.png_pic_center]  
![在这里插入图片描述][7ac21bca08f5497da7eafbbf9feb5064.png_pic_center]  
![在这里插入图片描述][9285c93abfca40fa80d6e53261737afe.png_pic_center]  
![在这里插入图片描述][5deb60ae640e4e3488433508f2b69535.png_pic_center]  
![在这里插入图片描述][d388d52d88ec412b82ce21e2f7f45861.png_pic_center]  
![在这里插入图片描述][5ae9d187ae4744ab93012eecaddaa64b.png_pic_center]  
![在这里插入图片描述][b9eac79194fe4458ae73cbf18ee0d16a.png_pic_center]  
![在这里插入图片描述][6ef0ebe48de8429688fce5af5ee5e9ec.png_pic_center]  
![在这里插入图片描述][641c1864fbc040fb938f9ee75f83188a.png_pic_center]  
![在这里插入图片描述][c526a26282ef40cebd26962f4ab34481.png_pic_center]  
![在这里插入图片描述][eece29da6e9a4a2797076bcf31964750.png_pic_center]  
![在这里插入图片描述][d64b20cbc858493ca79538e832501988.png_pic_center]  
![在这里插入图片描述][c9b9e2a946904f588a142543eda0dc50.png_pic_center]  
![在这里插入图片描述][5670a3687c7541d49d099e20e04f0598.png_pic_center]  
![在这里插入图片描述][11333602d1a340c6b014430fb77a2ec7.png_pic_center]  
![在这里插入图片描述][4bcd596368ba469ea82ecb0ffc0e836a.png_pic_center]

[8b938baba29a4023b02e96ef70e21bc9.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/fc65a0e826b9473ebcd9e3db662e2fe1.png
[8a2b31db221a4d78a3bb2db232a23cd0.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/7214da5b75174c7d8c61acb3b0e7f1e0.png
[42b4a300503844eab20c6bc3278db33a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/1f8ab756091743ea9f5d2b1903dc138a.png
[6cae6f8add384b88aaec5fd7350fdf92.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/d700f2fb087d42c4a01382ff3c949b81.png
[7ac21bca08f5497da7eafbbf9feb5064.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/8c1c4d061f26426ca9247c23e600e584.png
[9285c93abfca40fa80d6e53261737afe.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/f0125b116ebb40868387000153eab8fa.png
[5deb60ae640e4e3488433508f2b69535.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/3ea475de1c284f9c9e496682469a2925.png
[d388d52d88ec412b82ce21e2f7f45861.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/46ab2e335ab14229be7e35eb066eb053.png
[5ae9d187ae4744ab93012eecaddaa64b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/fd1b1fc72d904f66a4779b81a9d3e39b.png
[b9eac79194fe4458ae73cbf18ee0d16a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/b50af2e5fc3b48b4b6bf2c9a0b591be2.png
[6ef0ebe48de8429688fce5af5ee5e9ec.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/72b8942081bf4a1e8c3666ce7101350b.png
[641c1864fbc040fb938f9ee75f83188a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/a01253326fc54f86805870790615628a.png
[c526a26282ef40cebd26962f4ab34481.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/ff60773ba4144a22ba5c42dc028c5dfd.png
[eece29da6e9a4a2797076bcf31964750.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/e1f515f6e156451b81406ceb9ccc1200.png
[d64b20cbc858493ca79538e832501988.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/8b4726ee6c4e4a1e99478722afa080c4.png
[c9b9e2a946904f588a142543eda0dc50.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/a1b84748deaf4b47a989260a5d98df3b.png
[5670a3687c7541d49d099e20e04f0598.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6b23e0b2ea564ec097ab6779794a2528.png
[11333602d1a340c6b014430fb77a2ec7.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/6e6cbc435e6d4d1d9ccc9694fc10d6a7.png
[4bcd596368ba469ea82ecb0ffc0e836a.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/06/27d863816dd94b9d908a32e296a8e37d.png