DiscordDigimonBot/items.py at master · zyonwee/DiscordDigimonBot · GitHub

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
105
106
107
108
109
import db
import random
from KoGDAO.allPetsDAO import get_allStage


def get_all_eggshop():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM items WHERE shop = 'egg'")
    cursor.execute(query)
    for i in cursor:
        names.append(i[1])
        # print(i[0])

    cursor.close()
    cnx.close()
    # print(names)
    return names

# print(get_all_eggshop())


def get_all_item_exist_name_lower():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM items")
    cursor.execute(query)
    for i in cursor:
        names.append(i[1].lower())
        # print(i[0])
    cursor.close()
    cnx.close()
    # print(names)
    return names


def get_all_monsters_exist_name_lower():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM monsters")
    cursor.execute(query)
    for i in cursor:
        names.append(i[0].lower())
        # print(i[0])
    cursor.close()
    cnx.close()
    # print(names)
    return names


def get_all_lootshop():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM items WHERE shop = 'lb' ORDER BY `id` ASC")
    cursor.execute(query)
    for i in cursor:
        names.append(i[1])
        # print(i[0])
    cursor.close()
    cnx.close()
    # print(names)
    return names


def get_all_shop():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM items WHERE shop = 'basic' ORDER BY `id` ASC")
    cursor.execute(query)
    for i in cursor:
        names.append(i[1])
        # print(i[0])
    cursor.close()
    cnx.close()
    # print(names)
    return names

def get_all_petshop():
    names = []
    cnx = db.cnx()
    cursor = cnx.cursor()
    query = (f"SELECT * FROM items WHERE shop = 'pet' ORDER BY `id` ASC")
    cursor.execute(query)
    for i in cursor:
        names.append(i[1])
        # print(i[0])
    cursor.close()
    cnx.close()
    # print(names)
    return names


def random_pet(i):
    if i == "egg common":
        pets = random.choice(get_allStage("Baby"))
        return pets
    if i == "egg uncommon":
        pets = random.choice(get_allStage("In-Training"))
        return pets


# print(get_Equipped("OneForFourKay#5753"))