diff options
Diffstat (limited to 'sassbot')
| -rw-r--r-- | sassbot/modules/artifact2-0/EquipmentCreate.py | 139 | ||||
| -rw-r--r-- | sassbot/modules/artifact2.py | 54 |
2 files changed, 193 insertions, 0 deletions
diff --git a/sassbot/modules/artifact2-0/EquipmentCreate.py b/sassbot/modules/artifact2-0/EquipmentCreate.py new file mode 100644 index 0000000..e1520d7 --- /dev/null +++ b/sassbot/modules/artifact2-0/EquipmentCreate.py @@ -0,0 +1,139 @@ +import MySQLdb
+import random
+
+def GenerateItem(phenny, parameters, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ intIteration=0
+ itemName=strRaritySpacing='';
+
+ #Generate Rarity
+ itemGenRarity = CreateItemRarity(phenny, parameters, itemCode[0])
+
+ #Generate Item
+ itemGenEquipment = CreateItemName(phenny, parameters, itemCode[1])
+
+ #Generate Enchantment
+ itemGenEnchantment = CreateItemEnchantment(phenny, parameters, itemCode[2])
+
+ #Generate Element
+ itemGenElement = CreateItemElement(phenny, parameters, itemCode[3])
+
+ #Attempt creating an Artifact
+ itemGenEquipment = CreateItemArtifact(phenny, parameters, itemGenEquipment, itemCode[4])
+
+ strRaritySpacing = "" if len(itemGenRarity['RarityName']) == 0 else " "
+
+ itemGen={}
+ itemGen['EquipmentName'] = "\x03"+itemGenRarity['RarityColor'] + itemGenEquipment['FabledPrefix'] + itemGenRarity['RarityName'] + strRaritySpacing + itemGenElement['EffectName'] + " " + itemGenEquipment['EquipmentName'] + " " + itemGenEnchantment['Name']+"\x0399"
+ #itemGen['EquipmentName']
+ #itemGen['EquipmentSlot']
+ #itemGen['EquipmentType']
+ #itemGen['HandsReq']
+ #itemGen['Strength']
+ #itemGen['Dexterity']
+ #itemGen['Constitution']
+ #itemGen['Intelligence']
+ #itemGen['Dodge']
+ #itemGen['Crit']
+ #itemGen['Armor']
+ #itemGen['Precision']
+ #itemGen['Resistance']
+ #itemGen['Luck']
+ #itemGen['BlockitemGen']
+
+ return itemGen
+
+def CreateItemName(phenny, parameters, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ itemGenEquipment = {}
+
+ #Item by ID
+ if int(itemCode) is not 0:
+ c.execute("SELECT `EquipmentName`, `EquipmentSlot`, `EquipmentType`, `HandsReq`, `Strength`, `Dexterity`, `Constitution`, `Intelligence`, `Dodge`, `Crit`, `Armor`, `Precision`, `Resistance`, `Luck`, `Block` FROM `Items_Master` WHERE `ID` = " + str(itemCode))
+ itemGenEquipment = c.fetchone()
+ return itemGenEquipment
+
+ #Item by Random
+ elif int(itemCode) is 0:
+ #UPDATE: Should be able to generate an available weapon with just one query
+ # Pick random item that is available to the player
+ c.execute("SELECT `Items_PlayerPool`.`Nick`, `Items_PlayerPool`.`EquipmentName`, `Items_Master`.`Locked` FROM `Items_PlayerPool` INNER JOIN `Items_Master` ON `Items_PlayerPool`.`EquipmentName` = `Items_Master`.`EquipmentName` WHERE `Nick`=%s AND `Locked`=0 ORDER BY RAND() LIMIT 1",parameters['Nick'])
+ sqlItemPlayer = c.fetchone()
+
+ # Get information from randomly picked weapon
+ c.execute("SELECT `EquipmentName`, `EquipmentSlot`, `EquipmentType`, `HandsReq`, `Strength`, `Dexterity`, `Constitution`, `Intelligence`, `Dodge`, `Crit`, `Armor`, `Precision`, `Resistance`, `Luck`, `Block` FROM `Items_Master` WHERE `EquipmentName`=%s",sqlItemPlayer['EquipmentName'])
+ itemGenEquipment = c.fetchone()
+ itemGenEquipment['Permanent'] = 0
+ return itemGenEquipment
+
+def CreateItemElement(phenny, parameters, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ itemGenElement = {}
+ if int(itemCode) is not 0:
+ c.execute("SELECT `EffectName`, `Strength`, `Dexterity`, `Constitution`, `Intelligence`, `Dodge`, `Crit`, `Armor` FROM `GenElement` WHERE `ID` = %s",itemCode)
+ itemGenElement = c.fetchone()
+ elif int(itemCode) is 0:
+ c.execute("SELECT `EffectName`, `Strength`, `Dexterity`, `Constitution`, `Intelligence`, `Dodge`, `Crit`, `Armor` FROM `GenElement` ORDER BY RAND() LIMIT 1")
+ itemGenElement = c.fetchone()
+ return itemGenElement
+
+def CreateItemRarity(phenny, parameters, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ itemGenRarity = {}
+ if int(itemCode) is not 0:
+ c.execute("SELECT `ID`,`RarityName`,`RarityColor`,`RarityModifier`,`RarityChance`,`RarityCost` FROM `GenRarity` WHERE `ID` = " + str(itemCode))
+ itemGenRarity = c.fetchone()
+ elif int(itemCode) is 0:
+ # Obtain sum of all rarities
+ c.execute("SELECT SUM(`RarityChance`) AS RarityTotal FROM `GenRarity`")
+ intRarityTotal = c.fetchone()['RarityTotal']
+
+ # Variable declaration
+ intIteration = 0
+ intRandom = random.randint(1, intRarityTotal)
+
+ while True:
+ intIteration = intIteration + 1
+
+ # Obtain Rarity in order of lowest to highest with each iteration
+ c.execute("SELECT `ID`,`RarityName`,`RarityColor`,`RarityModifier`,`RarityChance` FROM `GenRarity` WHERE `ID` = " + str(intIteration))
+ itemGenRarity = c.fetchone()
+
+ # Subtract the current iterations rarity from the random roll
+ # If intRandom becomes negative, our item rarity has been found. End the loop.
+ intRandom = intRandom - itemGenRarity['RarityChance']
+ if intRandom <= 0:
+ break
+ return itemGenRarity
+ db.close()
+
+def CreateItemEnchantment(phenny, parameters, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ itemGenElement = {}
+ if int(itemCode) is not 0:
+ c.execute("SELECT `Name`,`Strength`,`Dexterity`,`Constitution`,`Intelligence`,`Dodge`, `Crit`, `Armor` FROM `GenEnchantment` WHERE `ID` = %s", str(itemCode))
+ itemGenEnchantment = c.fetchone()
+ elif int(itemCode) is 0:
+ c.execute("SELECT `Name`,`Strength`,`Dexterity`,`Constitution`,`Intelligence`,`Dodge`, `Crit`, `Armor` FROM `GenEnchantment` ORDER BY RAND() LIMIT 1")
+ itemGenEnchantment = c.fetchone()
+ return itemGenEnchantment
+
+def CreateItemArtifact(phenny, parameters, itemGenEquipment, itemCode):
+ db = MySQLdb.connect(host="localhost", user=phenny.config.mysql_username, passwd=phenny.config.mysql_password,db=parameters['LiveDB'])
+ c = db.cursor(MySQLdb.cursors.DictCursor)
+ # Gen for Artifact item:
+ if random.randint(1, 150) == 1 or int(itemCode) == 1:
+ if itemGenEquipment['EquipmentType'] == 'Armor' or itemGenEquipment['EquipmentType'] == 'Weapon':
+ c.execute("SELECT COUNT(`Permanent`) AS `Artifacts` FROM `Items_PlayerInventory` WHERE `Nick`=%s AND `Permanent`=1;",parameters['Nick'])
+ sqlCountArtifacts = c.fetchone()
+ if sqlCountArtifacts['Artifacts'] < 2:
+ itemGenEquipment['FabledPrefix'] = 'Fabled '
+ itemGenEquipment['Permanent'] = 1
+ else:
+ itemGenEquipment['FabledPrefix'] = ''
+ return itemGenEquipment
\ No newline at end of file diff --git a/sassbot/modules/artifact2.py b/sassbot/modules/artifact2.py new file mode 100644 index 0000000..bddd968 --- /dev/null +++ b/sassbot/modules/artifact2.py @@ -0,0 +1,54 @@ +import sys
+import MySQLdb
+import random
+import math
+import re
+
+sys.path.insert(0, '/home/bouncer/sassbot/modules/artifact2-0/')
+import EquipmentCreate
+
+
+def adventurersinc(phenny, input):
+ #Variables
+ if input.sender.lower() == "#fromsteamland":
+ strInputGroup = input.group().split(" ")
+ try:
+ strCmd1 = strInputGroup[1]
+ except:
+ strCmd1 = ""
+ try:
+ strCmd2 = strInputGroup[2]
+ except:
+ strCmd2 = ""
+
+ strPlayerState="debug"
+ parameters = {}
+ parameters['LiveDB'] = 'Artifact2.0'
+ parameters['LiveVersion'] = '2.0'
+ parameters['Nick'] = input.nick
+
+
+ #Actions based on player state
+ if strPlayerState == "newchar":
+ phenny.say("New Character")
+
+ elif strPlayerState == "rest":
+ phenny.say("Resting")
+
+ elif strPlayerState == "adventuring":
+ phenny.say("Exploring")
+
+ elif strPlayerState == "combat":
+ phenny.say("Combat")
+
+ elif strPlayerState == "debug":
+ itemCode = input.group(2).split(':')
+ #phenny.say(str(input.group(2)))
+ NewItem = EquipmentCreate.GenerateItem(phenny, parameters, itemCode)
+ phenny.say(NewItem["EquipmentName"])
+
+adventurersinc.commands = ['a']
+adventurersinc.priority = 'high'
+
+
+#https://stackoverflow.com/questions/4340793/how-to-find-gaps-in-sequential-numbering-in-mysql
\ No newline at end of file |