def decode(self):
self.iscommand = False
self.string = self.read_string()
if self.string.lower() == 'reset':
DataBase.replaceValue(self, 'gold', 99999)
DataBase.replaceValue(self, 'gems', 99999)
self.iscommand = True
def get_more_restaurants(query,num):
db=DataBase()
morequery = query.replace('DESC LIMIT 5',f'DESC LIMIT 5 OFFSET {num}')
df=db.fetch_restaurants_by_sql(morequery)
print("SQL Query: " + morequery)
return df
def encode(self):
self.writeVint(1)
self.writeVint(0)
self.writeVint(1)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
if (self.player.roomID == 0):
self.player.roomID = random.randint(0, 2147483647)
self.writeInt(self.player.roomID)
DataBase.replaceValue(self, 'roomID', self.player.roomID)
else:
self.writeInt(self.player.roomID)
self.writeVint(1557129593)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(15)
self.writeVint(self.player.mapID) # map ID
self.writeVint(1)
self.writeVint(1)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0) # high id
self.writeInt(1) # low id
self.writeVint(16)
self.writeVint(self.player.brawlerID)
self.writeVint(0)
self.writeVint(99999)
self.writeVint(99999)
self.writeVint(1)
self.writeVint(3)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeString(self.player.name) # player name
self.writeVint(100)
self.writeVint(28000000)
self.writeVint(43000000)
self.writeVint(23)
self.writeVint(self.player.starpower)
if self.player.useGadget == 1:
self.writeVint(23)
self.writeVint(self.player.gadget)
else:
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(6)
self.writeHexa('''FF-FF-00-00-00-00-00''')
print("[INFO] Message GameroomData has been sent.")
def get_restaurant(type,region,aspects):
db=DataBase()
query = "SELECT rest_name, rest_address, rest_region, AVG(rest_food_rating) as rest_food_rating, AVG(rest_srvc_rating) as rest_srvc_rating, AVG(rest_ambi_rating) as rest_ambi_rating, AVG(rest_prce_rating) as rest_prce_rating, AVG(w_rest_rating) as w_rest_rating FROM restaurant"
query = query + searchby_foodtype_region(type,region) + sort_by_aspect(aspects)
df=db.fetch_restaurants_by_sql(query)
print("SQL Query: " + query)
return df,query
def encode(self):
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
if self.player.roomID == 0:
self.player.roomID = random.randint(0, 2147483647)
self.writeInt(self.player.roomID)
DataBase.replaceValue(self, 'roomID', self.player.roomID)
else:
self.writeInt(self.player.roomID)
self.writeVInt(1557129593)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeScID(15, self.player.mapID) # map ID
self.writeVInt(1)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0) # high id
self.writeInt(1) # low id
self.writeScID(16, self.player.brawlerID)
self.writeVInt(0)
self.writeVInt(99999)
self.writeVInt(99999)
self.writeVInt(1)
self.writeVInt(3)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeString(self.player.name) # player name
self.writeVInt(100)
self.writeVInt(28000000)
self.writeVInt(43000000)
self.writeVInt(23)
self.writeVInt(self.player.starpower)
if self.player.useGadget == 1:
self.writeVInt(23)
self.writeVInt(self.player.gadget)
else:
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(6)
print("[*] Message TeamMessage has been sent.")
def encode(self):
self.writeVint(201)
self.writeString(self.player.name)
self.writeVint(0)
self.writeVint(1)
self.writeVint(-1)
self.writeVint(-1)
self.writeVint(0)
self.writeVint(0)
DataBase.replaceValue(self, 'name', self.player.name)
print("[INFO] Message SetNameResponse has been sent.")
def encode(self):
self.writeVInt(201)
self.writeString(self.player.name)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(-1)
self.writeVInt(-1)
self.writeVInt(0)
self.writeVInt(0)
DataBase.replaceValue(self, 'name', self.player.name)
print("[*] Message SetNameCallback has been sent.")
def process(self):
if self.player.LowID != 0:
LoginOkMessage(self.client, self.player).send()
DataBase.loadAccount(self) # load account
OwnHomeData(self.client, self.player).send()
else:
self.player.LowID = Helpers.randomID(self)
self.player.HighID = 0
self.player.Token = Helpers.randomStringDigits(self)
LoginOkMessage(self.client, self.player).send()
OwnHomeData(self.client, self.player).send()
def process(self, crypter):
if len(self.player.Token) == 40:
LoginOkMessage(self.client, self.player).send(crypter)
DataBase.loadAccount(self)
OwnHomeDataMessage(self.client, self.player).send(crypter)
MyAllianceMessage(self.client, self.player).send(crypter)
else:
self.player.LowID = random.randint(0, 2147483647)
self.player.HighID = 0
self.player.Token = Helpers.randomStringDigits(self)
LoginOkMessage(self.client, self.player).send(crypter)
DataBase.createAccount(self)
OwnHomeDataMessage(self.client, self.player).send(crypter)
MyAllianceMessage(self.client, self.player).send(crypter)
def process(self):
if self.commandID == 506:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.brawlerID = self.read_Vint()
DataBase.replaceValue(self, 'brawlerID', self.player.brawlerID)
def process(self):
if self.major != 27:
LoginFailed(self.client, self.player).send()
elif self.player.LowID != 0:
LoginOk(self.client, self.player).send()
DataBase.loadAccount(self) # load account
OwnHomeData(self.client, self.player).send()
if self.player.DoNotDistrub == 1:
DoNotDistrubServer(self.client, self.player).send()
if self.player.roomID > 0:
GameroomData(self.client, self.player).send()
else:
self.player.LowID = Helpers.randomID(self)
self.player.HighID = 0
self.player.Token = Helpers.randomStringDigits(self)
LoginOk(self.client, self.player).send()
OwnHomeData(self.client, self.player).send()
def process(self):
if self.mapID == 1:
self.player.mapID = 7
elif self.mapID == 2:
self.player.mapID = 32
elif self.mapID == 3:
self.player.mapID = 17
elif self.mapID == 4:
self.player.mapID = 57
elif self.mapID == 5:
self.player.mapID = 38
elif self.mapID == 6:
self.player.mapID = 24
elif self.mapID == 7:
self.player.mapID = 202
elif self.mapID == 8:
self.player.mapID = 97
elif self.mapID == 9:
self.player.mapID = 167
DataBase.replaceValue(self, 'mapID', self.player.mapID)
GameroomData(self.client, self.player).send()
def routine():
# url = ['https://store.steampowered.com/app/578080/PLAYERUNKNOWNS_BATTLEGROUNDS/',
# 'https://store.steampowered.com/app/570/Dota_2/']
HC = HeadLessChrome()
SP = SoupParser()
DB = DataBase()
# TEST HERE
# HC.get_soup('https://store.steampowered.com/app/671210/FINAL_FANTASY_XV_WINDOWS_EDITION_PLAYABLE_DEMO/')
applist = DB.get_applist(table='watching_games')
num_applist = len(applist)
for idx, app in enumerate(applist):
appid, name = app
if idx % 50 == 0: HC.reconn()
print('--------------', idx, '/', num_applist, '--------------')
try:
print(appid, name)
url = 'https://store.steampowered.com/app/' + str(appid)
soup = HC.get_soup(url)
if soup is None:
continue
result = SP.parse(soup)
result['appid'] = appid
result['name'] = name
try:
DB.insert_data(result)
except:
# logging
print('DB ERROR')
except:
print("skip ", appid, name, '\n')
HC.reconn()
continue
print(datetime.now())
def process(self, crypter):
DataBase.replaceValue(self, 'name', self.player.name)
LogicChangeAvatarNameCommand(self.client, self.player).send(crypter)
def encode(self):
reward_list = [2, 3, 8]
if self.player.boxID == 5:
newBrawlBox = self.player.brawlBoxes - 100
DataBase.replaceValue(self, 'brawlBoxes', newBrawlBox)
self.writeVint(203)
self.writeVint(0)
self.writeVint(1)
self.writeVint(10)
self.writeVint(2)
GoldValue = random.randrange(1, 1000)
self.writeVint(GoldValue)
newGold = self.player.gold + GoldValue
DataBase.replaceValue(self, 'gold', newGold)
self.writeVint(0)
self.writeVint(7)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
value = random.randrange(1, 20)
self.writeVint(value)
self.writeVint(0)
reward = random.choice(reward_list)
self.writeVint(reward)
if reward == 8:
newGems = self.player.gems + value
DataBase.replaceValue(self, 'gems', newGems)
elif reward == 3:
newTickets = self.player.tickets + value
DataBase.replaceValue(self, 'tickets', newTickets)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
self.writeVint(-1)
self.writeVint(-1)
self.writeVint(0)
self.writeVint(0)
if self.player.boxID == 4:
newBigBox = self.player.bigBoxes - 10
DataBase.replaceValue(self, 'bigBoxes', newBigBox)
self.writeVint(203)
self.writeVint(0)
self.writeVint(1)
self.writeVint(12)
self.writeVint(2)
GoldValue = random.randrange(1, 2500)
self.writeVint(GoldValue)
newGold = self.player.gold + GoldValue
DataBase.replaceValue(self, 'gold', newGold)
self.writeVint(0)
self.writeVint(7)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
value = random.randrange(1, 50)
self.writeVint(value)
self.writeVint(0)
reward = random.choice(reward_list)
self.writeVint(reward)
if reward == 8:
newGems = self.player.gems + value
DataBase.replaceValue(self, 'gems', newGems)
elif reward == 3:
newTickets = self.player.tickets + value
DataBase.replaceValue(self, 'tickets', newTickets)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
self.writeVint(-1)
self.writeVint(-1)
self.writeVint(0)
self.writeVint(0)
if self.player.boxID == 3 or self.player.boxID == 9:
self.writeVint(203)
self.writeVint(0)
self.writeVint(1)
self.writeVint(11)
self.writeVint(2)
GoldValue = random.randrange(1, 5000)
self.writeVint(GoldValue)
newGold = self.player.gold + GoldValue
DataBase.replaceValue(self, 'gold', newGold)
self.writeVint(0)
self.writeVint(7)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
value = random.randrange(1, 100)
self.writeVint(value)
self.writeVint(0)
reward = random.choice(reward_list)
self.writeVint(reward)
if reward == 8:
newGems = self.player.gems + value - 80
DataBase.replaceValue(self, 'gems', newGems)
elif reward == 3:
newTickets = self.player.tickets + value
newGems = self.player.gems - 80
DataBase.replaceValue(self, 'tickets', newTickets)
DataBase.replaceValue(self, 'gems', newGems)
else:
newGems = self.player.gems - 80
DataBase.replaceValue(self, 'gems', newGems)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
self.writeVint(-1)
self.writeVint(-1)
self.writeVint(0)
self.writeVint(0)
if self.player.boxID == 1 or self.player.boxID == 10:
self.writeVint(203)
self.writeVint(0)
self.writeVint(1)
self.writeVint(12)
self.writeVint(2)
GoldValue = random.randrange(1, 2500)
self.writeVint(GoldValue)
newGold = self.player.gold + GoldValue
DataBase.replaceValue(self, 'gold', newGold)
self.writeVint(0)
self.writeVint(7)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
value = random.randrange(1, 50)
self.writeVint(value)
self.writeVint(0)
reward = random.choice(reward_list)
self.writeVint(reward)
if reward == 8:
newGems = self.player.gems + value - 30
DataBase.replaceValue(self, 'gems', newGems)
elif reward == 3:
newTickets = self.player.tickets + value
newGems = self.player.gems - 30
DataBase.replaceValue(self, 'tickets', newTickets)
DataBase.replaceValue(self, 'gems', newGems)
else:
newGems = self.player.gems - 30
DataBase.replaceValue(self, 'gems', newGems)
self.writeVint(0)
self.writeVint(0)
self.writeVint(0)
self.writeVint(1)
self.writeVint(-1)
self.writeVint(-1)
self.writeVint(0)
self.writeVint(0)
from database.DataBase import DataBase
from generator.Simulator import Simulator
from acqusition.Station import Station
from storage.Storage import Storage
from query.Query import Query
from analysis.Analysis import Analysis
db = DataBase()
# generate dataset
generators = []
for i in range(2):
generator = Simulator(type='simulator', item='item_A', name='Temperature')
generator.encode()
generators.append(generator)
# acqusition
station = Station(generators)
station.collect_station_datas()
# storage
storage = Storage(db, station)
storage.storage()
# query
query = Query(storage.session)
query.query()
# Analysis
analysis = Analysis(query.data_frame)
analysis.analysis()
def process(self):
if self.Unk != 23:
if self.BrawlerSkinId == 0:
self.player.brawlerID = 0
elif self.BrawlerSkinId == 29:
self.player.brawlerID = 0
elif self.BrawlerSkinId == 52:
self.player.brawlerID = 0
elif self.BrawlerSkinId == 122:
self.player.brawlerID = 0
elif self.BrawlerSkinId == 159:
self.player.brawlerID = 0
elif self.BrawlerSkinId == 14:
self.player.brawlerID = 8
elif self.BrawlerSkinId == 15:
self.player.brawlerID = 8
elif self.BrawlerSkinId == 60:
self.player.brawlerID = 8
elif self.BrawlerSkinId == 79:
self.player.brawlerID = 8
elif self.BrawlerSkinId == 148:
self.player.brawlerID = 8
elif self.BrawlerSkinId == 1:
self.player.brawlerID = 1
elif self.BrawlerSkinId == 2:
self.player.brawlerID = 1
elif self.BrawlerSkinId == 69:
self.player.brawlerID = 1
elif self.BrawlerSkinId == 103:
self.player.brawlerID = 1
elif self.BrawlerSkinId == 135:
self.player.brawlerID = 1
elif self.BrawlerSkinId == 3:
self.player.brawlerID = 2
elif self.BrawlerSkinId == 25:
self.player.brawlerID = 2
elif self.BrawlerSkinId == 64:
self.player.brawlerID = 2
elif self.BrawlerSkinId == 102:
self.player.brawlerID = 2
elif self.BrawlerSkinId == 178:
self.player.brawlerID = 2
elif self.BrawlerSkinId == 13:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 44:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 47:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 123:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 162:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 174:
self.player.brawlerID = 7
elif self.BrawlerSkinId == 4:
self.player.brawlerID = 3
elif self.BrawlerSkinId == 5:
self.player.brawlerID = 3
elif self.BrawlerSkinId == 58:
self.player.brawlerID = 3
elif self.BrawlerSkinId == 72:
self.player.brawlerID = 3
elif self.BrawlerSkinId == 91:
self.player.brawlerID = 3
elif self.BrawlerSkinId == 6:
self.player.brawlerID = 9
elif self.BrawlerSkinId == 56:
self.player.brawlerID = 9
elif self.BrawlerSkinId == 57:
self.player.brawlerID = 9
elif self.BrawlerSkinId == 97:
self.player.brawlerID = 9
elif self.BrawlerSkinId == 160:
self.player.brawlerID = 9
elif self.BrawlerSkinId == 22:
self.player.brawlerID = 14
elif self.BrawlerSkinId == 94:
self.player.brawlerID = 14
elif self.BrawlerSkinId == 98:
self.player.brawlerID = 14
elif self.BrawlerSkinId == 99:
self.player.brawlerID = 14
elif self.BrawlerSkinId == 163:
self.player.brawlerID = 14
elif self.BrawlerSkinId == 86:
self.player.brawlerID = 22
elif self.BrawlerSkinId == 106:
self.player.brawlerID = 27
elif self.BrawlerSkinId == 109:
self.player.brawlerID = 27
elif self.BrawlerSkinId == 143:
self.player.brawlerID = 27
elif self.BrawlerSkinId == 119:
self.player.brawlerID = 30
elif self.BrawlerSkinId == 167:
self.player.brawlerID = 30
elif self.BrawlerSkinId == 7:
self.player.brawlerID = 10
elif self.BrawlerSkinId == 28:
self.player.brawlerID = 10
elif self.BrawlerSkinId == 30:
self.player.brawlerID = 10
elif self.BrawlerSkinId == 128:
self.player.brawlerID = 10
elif self.BrawlerSkinId == 12:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 27:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 59:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 90:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 92:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 116:
self.player.brawlerID = 6
elif self.BrawlerSkinId == 21:
self.player.brawlerID = 13
elif self.BrawlerSkinId == 71:
self.player.brawlerID = 13
elif self.BrawlerSkinId == 140:
self.player.brawlerID = 13
elif self.BrawlerSkinId == 77:
self.player.brawlerID = 24
elif self.BrawlerSkinId == 9:
self.player.brawlerID = 4
elif self.BrawlerSkinId == 26:
self.player.brawlerID = 4
elif self.BrawlerSkinId == 68:
self.player.brawlerID = 4
elif self.BrawlerSkinId == 130:
self.player.brawlerID = 4
elif self.BrawlerSkinId == 171:
self.player.brawlerID = 4
elif self.BrawlerSkinId == 34:
self.player.brawlerID = 18
elif self.BrawlerSkinId == 70:
self.player.brawlerID = 18
elif self.BrawlerSkinId == 158:
self.player.brawlerID = 18
elif self.BrawlerSkinId == 41:
self.player.brawlerID = 19
elif self.BrawlerSkinId == 61:
self.player.brawlerID = 19
elif self.BrawlerSkinId == 88:
self.player.brawlerID = 19
elif self.BrawlerSkinId == 165:
self.player.brawlerID = 19
elif self.BrawlerSkinId == 73:
self.player.brawlerID = 25
elif self.BrawlerSkinId == 93:
self.player.brawlerID = 25
elif self.BrawlerSkinId == 104:
self.player.brawlerID = 25
elif self.BrawlerSkinId == 132:
self.player.brawlerID = 25
elif self.BrawlerSkinId == 134:
self.player.brawlerID = 25
elif self.BrawlerSkinId == 142:
self.player.brawlerID = 34
elif self.BrawlerSkinId == 176:
self.player.brawlerID = 34
elif self.BrawlerSkinId == 23:
self.player.brawlerID = 15
elif self.BrawlerSkinId == 108:
self.player.brawlerID = 15
elif self.BrawlerSkinId == 120:
self.player.brawlerID = 15
elif self.BrawlerSkinId == 147:
self.player.brawlerID = 15
elif self.BrawlerSkinId == 24:
self.player.brawlerID = 16
elif self.BrawlerSkinId == 179:
self.player.brawlerID = 16
elif self.BrawlerSkinId == 42:
self.player.brawlerID = 20
elif self.BrawlerSkinId == 45:
self.player.brawlerID = 20
elif self.BrawlerSkinId == 125:
self.player.brawlerID = 20
elif self.BrawlerSkinId == 81:
self.player.brawlerID = 26
elif self.BrawlerSkinId == 146:
self.player.brawlerID = 26
elif self.BrawlerSkinId == 114:
self.player.brawlerID = 29
elif self.BrawlerSkinId == 139:
self.player.brawlerID = 29
elif self.BrawlerSkinId == 156:
self.player.brawlerID = 36
elif self.BrawlerSkinId == 18:
self.player.brawlerID = 11
elif self.BrawlerSkinId == 50:
self.player.brawlerID = 11
elif self.BrawlerSkinId == 63:
self.player.brawlerID = 11
elif self.BrawlerSkinId == 75:
self.player.brawlerID = 11
elif self.BrawlerSkinId == 173:
self.player.brawlerID = 11
elif self.BrawlerSkinId == 32:
self.player.brawlerID = 17
elif self.BrawlerSkinId == 111:
self.player.brawlerID = 17
elif self.BrawlerSkinId == 145:
self.player.brawlerID = 17
elif self.BrawlerSkinId == 67:
self.player.brawlerID = 21
elif self.BrawlerSkinId == 117:
self.player.brawlerID = 21
elif self.BrawlerSkinId == 172:
self.player.brawlerID = 21
elif self.BrawlerSkinId == 127:
self.player.brawlerID = 32
elif self.BrawlerSkinId == 137:
self.player.brawlerID = 32
elif self.BrawlerSkinId == 121:
self.player.brawlerID = 31
elif self.BrawlerSkinId == 152:
self.player.brawlerID = 31
elif self.BrawlerSkinId == 157:
self.player.brawlerID = 37
elif self.BrawlerSkinId == 177:
self.player.brawlerID = 37
elif self.BrawlerSkinId == 10:
self.player.brawlerID = 5
elif self.BrawlerSkinId == 11:
self.player.brawlerID = 5
elif self.BrawlerSkinId == 96:
self.player.brawlerID = 5
elif self.BrawlerSkinId == 19:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 20:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 49:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 95:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 100:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 101:
self.player.brawlerID = 12
elif self.BrawlerSkinId == 62:
self.player.brawlerID = 23
elif self.BrawlerSkinId == 110:
self.player.brawlerID = 23
elif self.BrawlerSkinId == 126:
self.player.brawlerID = 23
elif self.BrawlerSkinId == 131:
self.player.brawlerID = 23
elif self.BrawlerSkinId == 113:
self.player.brawlerID = 28
elif self.BrawlerSkinId == 118:
self.player.brawlerID = 28
elif self.BrawlerSkinId == 155:
self.player.brawlerID = 35
elif self.BrawlerSkinId == 180:
self.player.brawlerID = 35
if self.player.brawlerID == 0: #Shelly
self.player.starpower = 76
self.player.gadget = 255
elif self.player.brawlerID == 1: #Colt
self.player.starpower = 77
self.player.gadget = 273
elif self.player.brawlerID == 2: #Bull
self.player.starpower = 78
self.player.gadget = 272
elif self.player.brawlerID == 3: #Brock
self.player.starpower = 79
self.player.gadget = 245
elif self.player.brawlerID == 4: #Rico
self.player.starpower = 80
self.player.gadget = 246
elif self.player.brawlerID == 5: #Spike
self.player.starpower = 81
self.player.gadget = 247
elif self.player.brawlerID == 6: #Barley
self.player.starpower = 82
self.player.gadget = 273
elif self.player.brawlerID == 7: #Jessie
self.player.starpower = 83
self.player.gadget = 251
elif self.player.brawlerID == 8: #Nita
self.player.starpower = 84
self.player.gadget = 249
elif self.player.brawlerID == 9: #Dynamike
self.player.starpower = 85
self.player.gadget = 258
elif self.player.brawlerID == 10: #El Primo
self.player.starpower = 86
self.player.gadget = 264
elif self.player.brawlerID == 11: #Mortis
self.player.starpower = 87
self.player.gadget = 265
elif self.player.brawlerID == 12: #Crow
self.player.starpower = 88
self.player.gadget = 243
elif self.player.brawlerID == 13: #Poco
self.player.starpower = 89
self.player.gadget = 267
elif self.player.brawlerID == 14: #Bo
self.player.starpower = 90
self.player.gadget = 263
elif self.player.brawlerID == 15: #Piper
self.player.starpower = 91
self.player.gadget = 268
elif self.player.brawlerID == 16: #PAM
self.player.starpower = 92
self.player.gadget = 257
elif self.player.brawlerID == 17: #Tara
self.player.starpower = 93
self.player.gadget = 266
elif self.player.brawlerID == 18: #Darryl
self.player.starpower = 94
self.player.gadget = 260
elif self.player.brawlerID == 19: #Penny
self.player.starpower = 99
self.player.gadget = 248
elif self.player.brawlerID == 20: #Frank
self.player.starpower = 104
self.player.gadget = 261
elif self.player.brawlerID == 21: #Gene
self.player.starpower = 109
self.player.gadget = 252
elif self.player.brawlerID == 22: #Tick
self.player.starpower = 114
self.player.gadget = 253
elif self.player.brawlerID == 23: #Leon
self.player.starpower = 119
self.player.gadget = 276
elif self.player.brawlerID == 24: #Rosa
self.player.starpower = 124
self.player.gadget = 242
elif self.player.brawlerID == 25: #Carl
self.player.starpower = 129
self.player.gadget = 262
elif self.player.brawlerID == 26: #Bibi
self.player.starpower = 134
self.player.gadget = 275
elif self.player.brawlerID == 27: #8-Bit
self.player.starpower = 168
self.player.gadget = 259
elif self.player.brawlerID == 28: #Sandy
self.player.starpower = 186
self.player.gadget = 270
elif self.player.brawlerID == 29: #Bea
self.player.starpower = 192
self.player.gadget = 271
elif self.player.brawlerID == 30: #EMZ
self.player.starpower = 198
self.player.gadget = 274
elif self.player.brawlerID == 31: #Mr. P
self.player.starpower = 204
self.player.gadget = 269
elif self.player.brawlerID == 32: #Max
self.player.starpower = 210
self.player.gadget = 254
elif self.player.brawlerID == 34: #Jacky
self.player.starpower = 222
self.player.gadget = 256
elif self.player.brawlerID == 35: #Gale
self.player.starpower = 228
self.player.gadget = 277
elif self.player.brawlerID == 36: #Nani
self.player.starpower = 234
self.player.gadget = 278
elif self.player.brawlerID == 37: #Sprout
self.player.starpower = 240
self.player.gadget = 244
DataBase.replaceValue(self, 'starpower', self.player.starpower)
DataBase.replaceValue(self, 'gadget', self.player.gadget)
GameroomData(self.client, self.player).send()
def classify(self, dataSet):
"""
Recebe um dataSet e aplica o extrairFrase para o dataSet
:param dataSet:
:return:
"""
return nltk.classify.apply_features(self.extrairFrase, dataSet)
from database.DataBase import DataBase
db = DataBase()
dataSet=db.get_all_data_set(['vaticannews', 'semprequestione'])
# data=db.get_all_news_from('vaticannews')
p = Process(dataSet)
sp =p.stemmerAplay()
# print(p.extrairFrase())
print(type(p.extrairFrase(dataSet)))
print(type(p.freqWords(p.buscaPalavras()).values()))
# d=p.freqWords(p.buscaPalavras()).
# classificador=nltk.NaiveBayesClassifier.train(d)
# #
# print(classificador.show_most_informative_features(10))
def encode(self):
DataBase.loadAccount(self)
self.writeVInt(2020260)
self.writeVInt(67238)
self.writeVInt(self.player.trophies)
self.writeVInt(self.player.trophies)
self.writeVInt(122)
self.writeVInt(200)
self.writeVInt(1200) #exp
self.writeScID(28, self.player.profileIcon) #player thumbnails.csv
self.writeScID(43, self.player.namecolor) #name colors
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(122)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(1)
self.writeVInt(256)
self.writeVInt(590552)
self.writeVInt(50552)
self.writeVInt(6037352)
self.writeVInt(200)
self.writeVInt(200)
self.writeVInt(5)
self.writeVInt(77)
self.writeVInt(180)
self.writeVInt(430)
self.writeVInt(975)
self.writeVInt(2238)
self.writeVInt(4)
self.writeVInt(2)
self.writeVInt(2)
self.writeVInt(2)
self.writeVInt(60)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(200)
self.writeVInt(-1)
self.writeVInt(0)
self.writeVInt(99999)
self.writeVInt(0)
self.writeScID(16, self.player.brawlerID) # selected brawler
self.writeString("CA")
self.writeString("v29")
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(1)
for x in range(1):
self.writeVInt(2) # current season [0 - tara bazaar, 1 - monsters summer, 2 - STARR Park]
self.writeVInt(0) # brawl pass tokens
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(4)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(2020260) # shop timestamp
self.writeVInt(100) # 100
self.writeVInt(10) # 10
self.writeVInt(30) # big box price
self.writeVInt(3) # big box multiplier
self.writeVInt(80) # mega box price
self.writeVInt(10) # mega box multiplier
self.writeVInt(40) # token doubler price
self.writeVInt(1000) # token doubler amount
self.writeVInt(550) # ??
self.writeVInt(0)
self.writeVInt(999900)
self.writeVInt(6)
for x in [0, 30, 80, 170, 350, 0]:
self.writeVInt(x)
self.writeVInt(16)
for x in [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 20, 21, 22, 23, 24]:
self.writeVInt(x)
self.writeVInt(4)
for x in self.maps:
self.writeVInt(1883183565) # timestamp
self.writeVInt(self.maps.index(x) + 1) # slot
self.writeVInt(0)
self.writeVInt(75992) # time left
self.writeVInt(10)
self.writeScID(15, x) # mapID
self.writeVInt(3) # state
self.writeInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0) # events empty
self.writeVInt(8)
for x in [20, 35, 75, 140, 290, 480, 800, 1250]:
self.writeVInt(x)
self.writeVInt(8)
for x in [1, 2, 3, 4, 5, 10, 15, 20]:
self.writeVInt(x)
self.writeVInt(0) # tickets price (useless)
self.writeVInt(0) # tickets count (useless)
self.writeVInt(4)
for x in [20, 50, 140, 280]: # coins price
self.writeVInt(x)
self.writeVInt(4)
for x in [150, 400, 1200, 2600]: # coins count
self.writeVInt(x)
self.writeVInt(2)
self.writeVInt(200)
self.writeVInt(20)
self.writeVInt(8640)
self.writeVInt(10)
self.writeVInt(5)
self.writeVInt(6)
self.writeVInt(50)
self.writeVInt(604800)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(3)
self.writeVInt(0)
self.writeVInt(900104)
self.writeVInt(0)
self.writeVInt(-1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
# LogicClientAvatar #
self.writeVInt(0)
self.writeVInt(1)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
self.writeVInt(0)
if self.player.name is None:
self.writeString("nullptr")
self.writeBool(False) # name set
DataBase.createAccount(self) # create new account
else:
self.writeString(self.player.name)
self.writeBool(True)
self.writeInt(0)
self.writeVInt(8) # commodity array count
self.writeHexa(
'''2a170001170401170801170c01171001171401171801171c01172001172401172801172c01173001173401173801173c01178001011784010117880101179f010117a4010117a9010117ae010117b3010117b8010117bd01011782020117b1020117b6020117bc02011782030117880301178e0301179a030117a0030117a6030117ac03011797040117a8040105019f9a0c05089f9a0c05099f9a0c2710009f9a0c10019f9a0c10029f9a0c10039f9a0c10049f9a0c10059f9a0c10069f9a0c10079f9a0c10089f9a0c10099f9a0c100a9f9a0c100b9f9a0c100c9f9a0c100d9f9a0c100e9f9a0c100f9f9a0c10109f9a0c10119f9a0c10129f9a0c10139f9a0c10149f9a0c10159f9a0c10169f9a0c10179f9a0c10189f9a0c10199f9a0c101a9f9a0c101b9f9a0c101c9f9a0c101d9f9a0c101e9f9a0c101f9f9a0c10209f9a0c10229f9a0c10239f9a0c10249f9a0c10259f9a0c10269f9a0c10279f9a0c2710009f9a0c10019f9a0c10029f9a0c10039f9a0c10049f9a0c10059f9a0c10069f9a0c10079f9a0c10089f9a0c10099f9a0c100a9f9a0c100b9f9a0c100c9f9a0c100d9f9a0c100e9f9a0c100f9f9a0c10109f9a0c10119f9a0c10129f9a0c10139f9a0c10149f9a0c10159f9a0c10169f9a0c10179f9a0c10189f9a0c10199f9a0c101a9f9a0c101b9f9a0c101c9f9a0c101d9f9a0c101e9f9a0c101f9f9a0c10209f9a0c10229f9a0c10239f9a0c10249f9a0c10259f9a0c10269f9a0c10279f9a0c00271000a0161001a0161002a0161003a0161004a0161005a0161006a0161007a0161008a0161009a016100aa016100ba016100ca016100da016100ea016100fa0161010a0161011a0161012a0161013a0161014a0161015a0161016a0161017a0161018a0161019a016101aa016101ba016101ca016101da016101ea016101fa0161020a0161022a0161023a0161024a0161025a0161026a0161027a01627100008100108100208100308100408100508100608100708100808100908100a08100b08100c08100d08100e08100f08101008101108101208101308101408101508101608101708101808101908101a08101b08101c08101d08101e08101f081020081022081023081024081025081026081027088402178c0101178d0101178e0101178f010117900101179101011792010117930101179401011795010117960101179701011798010117990101179a0101179b0101179c0101179d0101179e010117a3010117a8010117ad010117b2010117b7010117bc01011781020117860201178702011788020117890201178a0201178b0201178c0201178d0201178e0201178f020117900201179102011792020117930201179402011795020117960201179702011798020117990201179a0201179b0201179c0201179d0201179e0201179f020117a0020117a1020117a2020117a3020117a4020117a5020117a6020117a7020117a8020117a9020117aa020117ac020117ae020117af020117b0020117b5020117ba020117bb020117800301178103011786030117870301178c0301178d030117920301179303011798030117990301179e0301179f030117a4030117a5030117aa030117ab030117b0030117b10301179b040117ac040117b3040117b4040117b2030117b3030117b4030117b5030117b6030117b7030117b8030117b9030117ba030117bb030117bc030117bd030117be030117bf030117800401178104011782040117830401178404011785040117860401178704011788040117890401178a0401178b0401178c0401178d0401178e0401178f040117900401179104011792040117930401179404011795040117960401179d040117ae040117b5040127100002100102100202100302100402100502100602100702100802100902100a02100b02100c02100d02100e02100f02101002101102101202101302101402101502101602101702101802101902101a02101b02101c02101d02101e02101f021020021022021023021024021025021026021027029f9a0c00a301a40100000000000000''')
self.writeVInt(2) # tutorial state
self.writeVInt(0)
print("[*] Message OwnHomeData has been sent.")
def process(self, crypter):
if self.player.tutorial < 2:
self.player.tutorial += 1
DataBase.replaceValue(self, 'tutorial', self.player.tutorial)
OwnHomeDataMessage(self.client, self.player).send(crypter)
print("Starting to re-populate DB.")
else:
print("Bye!")
sys.exit()
else:
print("Bye!")
sys.exit()
db = None
_i = None
try:
# create BERT model for Sentiment Analysis
bert_sentiment = BertSentiment()
# create DataBase object
db = DataBase()
# empty table before (re)populating data
db.empty_table()
# read the file with reviews and respective aspects
df = pd.read_csv('./data/reviews_with_aspects_full.csv',
engine='python')
#df = pd.read_csv('./data/aspects-top55k.csv', engine='python')
#df = pd.read_csv('./data/test.csv', engine='python')
df = df.reset_index(drop=True)
print(df.shape)
df = df.iloc[55800:len(df), :]
df = df.reset_index(drop=True)
def process(self):
self.player.roomID = 0
DataBase.replaceValue(self, 'roomID', self.player.roomID)
TeamLeaveOkMessage(self.client, self.player).send()
# -*- coding: utf-8 -*-
"""
Created on Sat Oct 24 21:05:15 2020
@author: rajpaul
"""
from database.DataBase import DataBase
if __name__ == "__main__":
db = None
try:
# create DataBase object
db = DataBase()
conn = db.connect_to_db()
# select max record id
id_sql = " SELECT MAX(id) FROM restaurant; "
cur = conn.cursor()
cur.execute(id_sql)
rows = cur.fetchall()
last_row_id = rows[0][0]
print("last_row_id:", last_row_id)
for i in range(1, last_row_id + 1):
print("updating row with id:", i)
def process(self):
self.player.roomID = 0
DataBase.replaceValue(self, 'roomID', self.player.roomID)
RoomDisconnect(self.client, self.player).send()
def process(self):
DataBase.replaceValue(self, 'mapID', self.player.mapID)
GameroomData(self.client, self.player).send()
def process(self):
DataBase.replaceValue(self, 'DoNotDistrub', self.player.DoNotDistrub)
DoNotDistrubServer(self.client, self.player).send()
import nltk
from database.DataBase import DataBase
from sklearn.model_selection import train_test_split
from facebookapi.publushFacebook import PublishFacebook
from preprocess.Process import Process
from util.Character import removerAcentosECaracteresEspeciais
from sklearn.naive_bayes import MultinomialNB
from sklearn.pipeline import Pipeline
from sklearn.feature_extraction.text import TfidfVectorizer
from nltk.corpus import stopwords
db = DataBase()
data = db.get_all_data_set(
['vaticannews', 'semprequestione', 'acidigital', 'cancaonova'])
y = [clazz for (title, news, clazz) in data]
X = [news for (title, news, clazz) in data]
def train(classifier, X, y):
X_train, X_test, y_train, y_test = train_test_split(X,
y,
test_size=0.25,
random_state=33)
classifier.fit(X_train, y_train)
print("Accuracy: %s" % classifier.score(X_test, y_test))
return classifier
def process(self):
if self.commandID == 500 or self.commandID == 517 or self.commandID == 535:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.boxID = self.read_Vint()
print("Command ID", self.commandID, "has been handled")
ServerBox(self.client, self.player).send()
elif self.commandID == 505:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.profileIcon = self.read_Vint()
DataBase.replaceValue(self, 'profileIcon', self.player.profileIcon)
print("Command ID", self.commandID, "has been handled")
elif self.commandID == 506:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.skinID = self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.brawlerID = self.read_Vint()
DataBase.replaceValue(self, 'skinID', self.player.skinID)
if self.player.brawlerID == 0:
DataBase.replaceValue(self, 'shellySkin', self.player.skinID)
elif self.player.brawlerID == 1:
DataBase.replaceValue(self, 'coltSkin', self.player.skinID)
elif self.player.brawlerID == 2:
DataBase.replaceValue(self, 'bullSkin', self.player.skinID)
elif self.player.brawlerID == 3:
DataBase.replaceValue(self, 'brockSkin', self.player.skinID)
elif self.player.brawlerID == 4:
DataBase.replaceValue(self, 'ricoSkin', self.player.skinID)
elif self.player.brawlerID == 5:
DataBase.replaceValue(self, 'spikeSkin', self.player.skinID)
elif self.player.brawlerID == 6:
DataBase.replaceValue(self, 'barleySkin', self.player.skinID)
elif self.player.brawlerID == 7:
DataBase.replaceValue(self, 'jessieSkin', self.player.skinID)
elif self.player.brawlerID == 8:
DataBase.replaceValue(self, 'nitaSkin', self.player.skinID)
elif self.player.brawlerID == 9:
DataBase.replaceValue(self, 'dynamikeSkin', self.player.skinID)
elif self.player.brawlerID == 10:
DataBase.replaceValue(self, 'elprimoSkin', self.player.skinID)
elif self.player.brawlerID == 11:
DataBase.replaceValue(self, 'mortisSkin', self.player.skinID)
elif self.player.brawlerID == 12:
DataBase.replaceValue(self, 'crowSkin', self.player.skinID)
elif self.player.brawlerID == 13:
DataBase.replaceValue(self, 'pocoSkin', self.player.skinID)
elif self.player.brawlerID == 14:
DataBase.replaceValue(self, 'boSkin', self.player.skinID)
elif self.player.brawlerID == 15:
DataBase.replaceValue(self, 'piperSkin', self.player.skinID)
elif self.player.brawlerID == 16:
DataBase.replaceValue(self, 'pamSkin', self.player.skinID)
elif self.player.brawlerID == 17:
DataBase.replaceValue(self, 'taraSkin', self.player.skinID)
elif self.player.brawlerID == 18:
DataBase.replaceValue(self, 'darrylSkin', self.player.skinID)
elif self.player.brawlerID == 19:
DataBase.replaceValue(self, 'pennySkin', self.player.skinID)
elif self.player.brawlerID == 20:
DataBase.replaceValue(self, 'frankSkin', self.player.skinID)
elif self.player.brawlerID == 21:
DataBase.replaceValue(self, 'geneSkin', self.player.skinID)
elif self.player.brawlerID == 22:
DataBase.replaceValue(self, 'tickSkin', self.player.skinID)
elif self.player.brawlerID == 23:
DataBase.replaceValue(self, 'leonSkin', self.player.skinID)
elif self.player.brawlerID == 24:
DataBase.replaceValue(self, 'rosaSkin', self.player.skinID)
elif self.player.brawlerID == 25:
DataBase.replaceValue(self, 'carlSkin', self.player.skinID)
elif self.player.brawlerID == 26:
DataBase.replaceValue(self, 'bibiSkin', self.player.skinID)
elif self.player.brawlerID == 27:
DataBase.replaceValue(self, '8bitSkin', self.player.skinID)
elif self.player.brawlerID == 28:
DataBase.replaceValue(self, 'sandySkin', self.player.skinID)
elif self.player.brawlerID == 29:
DataBase.replaceValue(self, 'beaSkin', self.player.skinID)
elif self.player.brawlerID == 30:
DataBase.replaceValue(self, 'emzSkin', self.player.skinID)
elif self.player.brawlerID == 31:
DataBase.replaceValue(self, 'mrpSkin', self.player.skinID)
elif self.player.brawlerID == 32:
DataBase.replaceValue(self, 'maxSkin', self.player.skinID)
elif self.player.brawlerID == 34:
DataBase.replaceValue(self, 'jackySkin', self.player.skinID)
elif self.player.brawlerID == 35:
DataBase.replaceValue(self, 'galeSkin', self.player.skinID)
elif self.player.brawlerID == 36:
DataBase.replaceValue(self, 'naniSkin', self.player.skinID)
elif self.player.brawlerID == 37:
DataBase.replaceValue(self, 'sproutSkin', self.player.skinID)
if self.player.brawlerID == 0: #Shelly
self.player.starpower = 76
self.player.gadget = 255
elif self.player.brawlerID == 1: #Colt
self.player.starpower = 77
self.player.gadget = 273
elif self.player.brawlerID == 2: #Bull
self.player.starpower = 78
self.player.gadget = 272
elif self.player.brawlerID == 3: #Brock
self.player.starpower = 79
self.player.gadget = 245
elif self.player.brawlerID == 4: #Rico
self.player.starpower = 80
self.player.gadget = 246
elif self.player.brawlerID == 5: #Spike
self.player.starpower = 81
self.player.gadget = 247
elif self.player.brawlerID == 6: #Barley
self.player.starpower = 82
self.player.gadget = 273
elif self.player.brawlerID == 7: #Jessie
self.player.starpower = 83
self.player.gadget = 251
elif self.player.brawlerID == 8: #Nita
self.player.starpower = 84
self.player.gadget = 249
elif self.player.brawlerID == 9: #Dynamike
self.player.starpower = 85
self.player.gadget = 258
elif self.player.brawlerID == 10: #El Primo
self.player.starpower = 86
self.player.gadget = 264
elif self.player.brawlerID == 11: #Mortis
self.player.starpower = 87
self.player.gadget = 265
elif self.player.brawlerID == 12: #Crow
self.player.starpower = 88
self.player.gadget = 243
elif self.player.brawlerID == 13: #Poco
self.player.starpower = 89
self.player.gadget = 267
elif self.player.brawlerID == 14: #Bo
self.player.starpower = 90
self.player.gadget = 263
elif self.player.brawlerID == 15: #Piper
self.player.starpower = 91
self.player.gadget = 268
elif self.player.brawlerID == 16: #PAM
self.player.starpower = 92
self.player.gadget = 257
elif self.player.brawlerID == 17: #Tara
self.player.starpower = 93
self.player.gadget = 266
elif self.player.brawlerID == 18: #Darryl
self.player.starpower = 94
self.player.gadget = 260
elif self.player.brawlerID == 19: #Penny
self.player.starpower = 99
self.player.gadget = 248
elif self.player.brawlerID == 20: #Frank
self.player.starpower = 104
self.player.gadget = 261
elif self.player.brawlerID == 21: #Gene
self.player.starpower = 109
self.player.gadget = 252
elif self.player.brawlerID == 22: #Tick
self.player.starpower = 114
self.player.gadget = 253
elif self.player.brawlerID == 23: #Leon
self.player.starpower = 119
self.player.gadget = 276
elif self.player.brawlerID == 24: #Rosa
self.player.starpower = 124
self.player.gadget = 242
elif self.player.brawlerID == 25: #Carl
self.player.starpower = 129
self.player.gadget = 262
elif self.player.brawlerID == 26: #Bibi
self.player.starpower = 134
self.player.gadget = 275
elif self.player.brawlerID == 27: #8-Bit
self.player.starpower = 168
self.player.gadget = 259
elif self.player.brawlerID == 28: #Sandy
self.player.starpower = 186
self.player.gadget = 270
elif self.player.brawlerID == 29: #Bea
self.player.starpower = 192
self.player.gadget = 271
elif self.player.brawlerID == 30: #EMZ
self.player.starpower = 198
self.player.gadget = 274
elif self.player.brawlerID == 31: #Mr. P
self.player.starpower = 204
self.player.gadget = 269
elif self.player.brawlerID == 32: #Max
self.player.starpower = 210
self.player.gadget = 254
elif self.player.brawlerID == 34: #Jacky
self.player.starpower = 222
self.player.gadget = 256
elif self.player.brawlerID == 35: #Gale
self.player.starpower = 228
self.player.gadget = 277
elif self.player.brawlerID == 36: #Nani
self.player.starpower = 234
self.player.gadget = 278
elif self.player.brawlerID == 37: #Sprout
self.player.starpower = 240
self.player.gadget = 244
DataBase.replaceValue(self, 'starpower', self.player.starpower)
DataBase.replaceValue(self, 'gadget', self.player.gadget)
DataBase.replaceValue(self, 'brawlerID', self.player.brawlerID)
print("Command ID", self.commandID, "has been handled")
elif self.commandID == 521:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.gold = self.read_Vint()
if self.gold == 0:
newGold = self.player.gold + 150
newGems = self.player.gems - 20
DataBase.replaceValue(self, 'gold', newGold)
DataBase.replaceValue(self, 'gems', newGems)
elif self.gold == 1:
newGold = self.player.gold + 400
newGems = self.player.gems - 50
DataBase.replaceValue(self, 'gold', newGold)
DataBase.replaceValue(self, 'gems', newGems)
elif self.gold == 2:
newGold = self.player.gold + 1200
newGems = self.player.gems - 140
DataBase.replaceValue(self, 'gold', newGold)
DataBase.replaceValue(self, 'gems', newGems)
print("Command ID", self.commandID, "has been handled")
elif self.commandID == 509:
newGems = self.player.gems - 50
DataBase.replaceValue(self, 'gems', newGems)
print("Command ID", self.commandID, "has been handled")
elif self.commandID == 527:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.namecolor = self.read_Vint()
DataBase.replaceValue(self, 'namecolor', self.namecolor)
print("Command ID", self.commandID, "has been handled")
elif self.commandID == 529:
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.read_Vint()
self.player.starpower = self.read_Vint()
DataBase.replaceValue(self, 'starpower', self.player.starpower)
if self.player.roomID > 0:
GameroomData(self.client, self.player).send()
print("Command ID", self.commandID, "has been handled")
elif self.commandID >= 0:
print("Command ID", self.commandID, "is not handled!")
def process(self):
DataBase.replaceValue(self, 'mapID', self.player.mapID)
TeamMessage(self.client, self.player).send()
# Prompt user before re-scoring DB
_in1 = input(
"Do you really want to re-score the current DB? Enter yes/no: ")
if _in1.lower() == 'yes':
print("Starting to re-score DB.")
else:
print("Bye!")
sys.exit()
db = None
try:
# create DataBase object
db = DataBase(
'C:\\NUS_ISS_MTech\Year 2\Semester 2 - Practical Natural Language Processing\PLP CA\database\gastrotommy_v3.db'
)
conn = db.connect_to_db()
# select max record id
id_sql = " SELECT MAX(id) FROM restaurant; "
cur = conn.cursor()
cur.execute(id_sql)
rows = cur.fetchall()
last_row_id = rows[0][0]
print("last_row_id:", last_row_id)
for i in range(1, last_row_id + 1):
print("updating row with id:", i)