def __init__(self, userId): self.userId = userId dbinfo = config.getInfoToConnectDB() self.connection = pymysql.connect(host = dbinfo['host'], user = dbinfo['user_name'], password = dbinfo['password'], db = dbinfo['db_name'], charset = 'utf8', cursorclass = pymysql.cursors.DictCursor) with self.connection.cursor() as cursor: cursor.execute("SELECT * from USER WHERE id = %s", (self.userId)) userInfo = cursor.fetchone() self.__hp = userInfo['hp'] self.name = userInfo['name'] self.__money = userInfo['money'] self.__position_x = userInfo['position_x'] self.__position_y = userInfo['position_y'] self.__state = userInfo['state'] self.__battleID = userInfo['battleID'] self.equipment = userInfo['equipment'] cursor.execute("SELECT * from EQUIPMENT WHERE id = %s", (self.equipment)) equipInfo = cursor.fetchone() cursor.execute("SELECT attack from WEAPON WHERE id = %s", (equipInfo['equip_weapon'])) weaponInfo = cursor.fetchone() self.attack = weaponInfo['attack'] cursor.execute("SELECT * from ARMOR WHERE id = %s", (equipInfo['equip_armor'])) armorInfo = cursor.fetchone() self.defense = armorInfo['defense'] self.speed = armorInfo['speed']
def __init__(self, userID): self.player = None dbinfo = config.getInfoToConnectDB() self.connection = pymysql.connect( host=dbinfo['host'], user=dbinfo['user_name'], password=dbinfo['password'], db=dbinfo['db_name'], charset='utf8', cursorclass=pymysql.cursors.DictCursor) if self._exist(userID): self.player = Player(userID) self.Registered = True else: self.Registered = False
def spawnNewBattle(self, enemyID): enemy = Enemy(enemyID) dbinfo = config.getInfoToConnectDB() connection = pymysql.connect(host = dbinfo['host'], user = dbinfo['user_name'], password = dbinfo['password'], db = dbinfo['db_name'], charset = 'utf8', cursorclass = pymysql.cursors.DictCursor) with connection.cursor() as cursor: sql = "INSERT INTO BATTLEINFO (enemyHP, enemyAttack, enemyDefense, enemySpeed, enemyMoney, enemyName, enemyId) VALUES (%s, %s, %s, %s, %s, %s, %s)" values = (enemy.hp, enemy.attack, enemy.defense, enemy.speed, enemy.money, enemy.name, enemyID) cursor.execute(sql, values) battleID = cursor.lastrowid connection.commit() connection.close() return battleID
def _randomEnemyID(self): enemyIDs = [] dbinfo = config.getInfoToConnectDB() connection = pymysql.connect(host = dbinfo['host'], user = dbinfo['user_name'], password = dbinfo['password'], db = dbinfo['db_name'], charset = 'utf8', cursorclass = pymysql.cursors.DictCursor) with connection.cursor() as cursor: sql = "SELECT id FROM ENEMY" cursor.execute(sql) results = cursor.fetchall() for r in results: enemyIDs.append(r['id']) connection.close() index = random.randint(0, len(enemyIDs)-1) return enemyIDs[index]
def __init__(self, enemyID): self.enemyID = enemyID dbinfo = config.getInfoToConnectDB() connection = pymysql.connect(host = dbinfo['host'], user = dbinfo['user_name'], password = dbinfo['password'], db = dbinfo['db_name'], charset = 'utf8', cursorclass = pymysql.cursors.DictCursor) with connection.cursor() as cursor: cursor.execute("SELECT * from ENEMY WHERE id = %s", (self.enemyID)) enemyInfo = cursor.fetchone() self.name = enemyInfo['name'] self.hp = enemyInfo['hp'] self.attack = enemyInfo['attack'] self.defense = enemyInfo['defense'] self.speed = enemyInfo['speed'] self.money = enemyInfo['money'] self.imagePath = enemyInfo['imagePath'] connection.close()
def randomEncount(self): rnd = random.random() if rnd < 0.2: battle = Battle(self.userID) text = battle.enemy.name + "が現れた!" dbinfo = config.getInfoToConnectDB() self.connection = pymysql.connect( host=dbinfo['host'], user=dbinfo['user_name'], password=dbinfo['password'], db=dbinfo['db_name'], charset='utf8', cursorclass=pymysql.cursors.DictCursor) with self.connection.cursor() as cursor: cursor.execute("SELECT * FROM ENEMY WHERE id = %s", (battle.enemy.enemyId)) enemyInfo = cursor.fetchone() imageURI = "https://nozawa-linebot.tk/" + enemyInfo['imagePath'] return True, {"img": imageURI, "text": text} return False, {}
def __init__(self, battleID): self.battleID = battleID dbinfo = config.getInfoToConnectDB() self.connection = pymysql.connect( host=dbinfo['host'], user=dbinfo['user_name'], password=dbinfo['password'], db=dbinfo['db_name'], charset='utf8', cursorclass=pymysql.cursors.DictCursor) with self.connection.cursor() as cursor: cursor.execute("SELECT * FROM BATTLEINFO WHERE id = %s", (battleID)) enemyInfo = cursor.fetchone() self.__hp = enemyInfo['enemyHP'] self.attack = enemyInfo['enemyAttack'] self.defense = enemyInfo['enemyDefense'] self.speed = enemyInfo['enemySpeed'] self.money = enemyInfo['enemyMoney'] self.name = enemyInfo['enemyName'] self.enemyId = enemyInfo['enemyId']