def discoveredNewItem(context, **kwargs):
if "item" in kwargs:
item = kwargs["item"]
if "type" in item:
itemType = item["type"]
else:
itemType = ""
if "image" in item:
image = item["image"]
else:
image = ""
if "autosell" in item:
autosell = item["autosell"]
else:
autosell = 0
db = MySQLDatabaseManager.getDatabase("system")
c = db.cursor()
c.execute("INSERT INTO item (item_id, desc_id, name, image, autosell, type) values (%s, %s, %s, %s, %s, %s)", \
(item["id"], item["descId"], item["name"], image, autosell, itemType))
c.close()
db.commit()
return FilterManager.CONTINUE
def discoveredNewItem(context, **kwargs):
if "item" in kwargs:
item = kwargs["item"]
if "type" in item:
itemType = item["type"]
else:
itemType = ""
if "image" in item:
image = item["image"]
else:
image = ""
if "autosell" in item:
autosell = item["autosell"]
else:
autosell = 0
db = MySQLDatabaseManager.getDatabase("system")
c = db.cursor()
c.execute("INSERT INTO item (item_id, desc_id, name, image, autosell, type) values (%s, %s, %s, %s, %s, %s)", \
(item["id"], item["descId"], item["name"], image, autosell, itemType))
c.close()
db.commit()
return FilterManager.CONTINUE
def preInitializeItemDatabase(context, **kwargs):
db = MySQLDatabaseManager.getDatabase("system")
c = db.cursor()
c.execute("SELECT * FROM item")
row = c.fetchone()
while row != None:
item = {}
item["id"] = row["item_id"]
item["descId"] = row["desc_id"]
item["name"] = row["name"]
item["image"] = row["image"]
item["autosell"] = row["autosell"]
item["type"] = row["type"]
ItemDatabase.addItem(item)
row = c.fetchone()
c.close()
return FilterManager.FINISHED
def preInitializeItemDatabase(context, **kwargs):
db = MySQLDatabaseManager.getDatabase("system")
c = db.cursor()
c.execute("SELECT * FROM item")
row = c.fetchone()
while row != None:
item = {}
item["id"] = row["item_id"]
item["descId"] = row["desc_id"]
item["name"] = row["name"]
item["image"] = row["image"]
item["autosell"] = row["autosell"]
item["type"] = row["type"]
ItemDatabase.addItem(item)
row = c.fetchone()
c.close()
context["returnCode"] = FilterManager.FINISHED
def receivedDonation(context, **kwargs):
bot = kwargs["bot"]
meat = kwargs["meat"]
items = kwargs["items"]
message = kwargs["kmail"]
state = bot.states["job"]
# Get the full information about the current user.
currentUser = state["currentUser"]
# Update the user's rating.
if "updatedUserRatingForDonation" not in state:
db = MySQLDatabaseManager.getDatabase("system")
c = db.cursor()
newRating = currentUser["user_rating"] + meat
c = db.cursor()
setUserRatingTo(newRating, currentUser["user_id"], c)
c.close()
db.commit()
state["updatedUserRatingForDonation"] = 1
state["newUserRating"] = newRating
bot.writeState("job")
else:
newRating = state["newUserRating"]
# Send confirmation to the user.
if "sentDonationThankYou" not in state:
txt = "Thank you for the kind donation! Your user rating has increased by %s points. Your new user rating is %s." \
% (NumberUtils.formatNumberWithCommas(meat), NumberUtils.formatNumberWithCommas(newRating))
bot.quoteKmail(message, txt)
state["sentDonationThankYou"] = 1
bot.writeState("job")
return FilterManager.CONTINUE