def deleteCharacter(self, character_Name=None):
myDB = DBConnection(dwarfBeard.DB_FILE)
queryString = "DELETE FROM characterNames WHERE characterName=?"
myDB.action(queryString,(character_Name,))
queryString = "DELETE FROM tasks WHERE characterName=?"
myDB.action(queryString,(character_Name,))
redirect("/manage/")
def index(self):
#get a db connection
myDB = DBConnection(dwarfBeard.DB_FILE)
#load the page template
t = PageTemplate(file="manage.tmpl")
#get a list of the character names as strings
results = myDB.action('SELECT * FROM characterNames')
charList = []
for eachName in results:
charList.append(str(eachName['characterName']))
#set the character name list to the page template
t.characterResults = charList
#create a blank task list to hold tasks sorted by character
characterTasksList = []
#get a seperate task list for each character
for eachName in charList:
results = myDB.action('SELECT * FROM tasks WHERE characterName=?', (eachName,))
taskList = []
for eachTask in results:
taskList.append(eachTask)
#append each characters task list to the main list sorted by character
characterTasksList.append([eachName, taskList])
#set the sorted task list to the tamplate
t.taskResults = characterTasksList
return _munge(t)
def addNewTask(self, character_Name=None, task_Name=None, task_Level=None, task_Profession="Alchemy"):
myDB = DBConnection(dwarfBeard.DB_FILE)
queryString = "INSERT INTO tasks (characterName, taskName, taskLevel, taskProfession) VALUES (?,?,?,?)"
myDB.action(queryString,(character_Name, task_Name, task_Level, task_Profession))
redirect("/manage/")
def logZenExchange(browser, characterName):
#first we get the purchase price
#wait for the page to load
reissueCount = 0
while browser.is_text_not_present("Top ZEN Listings"):
x = randint(3,10)
#go to professions
print ' attempting to navigate to zen exchange'
browser.visit('http://gateway.playneverwinter.com/#char(' + characterName + '@' + dwarfBeard.NW_ACCOUNT_NAME + ')/exchange')
reissueCount += 1
if reissueCount > 4:
browser.reload()
x = 20
reissueCount = 0
print ' trying browser reload and sleeping for 20s'
time.sleep(x)
#collect the data from the zen purchase table, we only need the lowest price
data = browser.find_by_css('TABLE#gatewayTableBuyZen.dataTable')
purchaseText = str(data.text).split(" ")
#pull out the lowest price
lowZenPurchasePrice = filter(None, re.split(r'(\d+)', purchaseText[3]))[0]
print ' lowest zen purchase price = ', lowZenPurchasePrice
#now we get the sell price
#wait for the page to load
reissueCount = 0
while browser.is_text_not_present("Top ZEN Purchase Requests"):
x = randint(3,10)
#go to professions
print ' attempting to navigate to ad exchange'
browser.visit('http://gateway.playneverwinter.com/#char(' + characterName + '@' + dwarfBeard.NW_ACCOUNT_NAME + ')/exchange-sellzen')
if reissueCount > 4:
browser.reload()
x = 20
reissueCount = 0
print ' trying browser reload and sleeping for 20s'
time.sleep(x)
#collect the data from the zen purchase table, we only need the lowest price
#this one is much easier to grab
data = browser.find_by_css('TABLE#gatewayTableSellZen.dataTable')
sellText = str(data.text).split(" ")
lowAdPurchasePrice = sellText[8]
print ' higest zen sell price = ', lowAdPurchasePrice
#save the data to the db
#make connection to db
myDB = DBConnection(dwarfBeard.DB_FILE)
queryString = "INSERT INTO adExchange (adPrice, zenPrice) VALUES (?,?)"
myDB.action(queryString,(lowAdPurchasePrice, lowZenPurchasePrice))
return
def getTaskPriorityArray(characterName): #make connection to db mydb = DBConnection(dwarfBeard.DB_FILE) #query string query = "SELECT * FROM tasks WHERE characterName=?" #create an array with the task info from the db taskArray = mydb.action(query, (characterName,)).fetchall() return taskArray
def index(self):
t = PageTemplate(file="adexchange.tmpl")
myDB = DBConnection(dwarfBeard.DB_FILE)
results = myDB.action('SELECT * FROM adExchange')
adData = []
for eachRow in results:
adData.append({'adPrice': int(eachRow['adPrice']), 'zenPrice': int(eachRow['zenPrice']), 'timestamp': str(eachRow['timestamp'])})
t.adData = adData
return _munge(t)
def deleteTask(self, character_Name=None, task_Name=None, task_Level=None):
myDB = DBConnection(dwarfBeard.DB_FILE)
queryString = "DELETE FROM tasks WHERE characterName=? AND taskName=? AND taskLevel=?"
myDB.action(queryString,(character_Name, task_Name, task_Level))
redirect("/manage/")
def addNewCharacter(self, character_Name=None):
myDB = DBConnection(dwarfBeard.DB_FILE)
queryString = "INSERT INTO characterNames (characterName) VALUES (?)"
myDB.action(queryString,(character_Name,))
redirect("/manage/")
def executeTaskActionList(timer):
#signal the task is in execution
dwarfBeard.taskExecRunning = 1
#stop the task timer during execution
#this is done to prevent a second execution from firing while we are still executing and
#the timer will be restarted when this function is finished which will result in a
#more accurate logout time
timer.stop()
#get a connection to the db
mainDB = DBConnection(dwarfBeard.DB_FILE)
#get character names from the db
cnDict = mainDB.action('SELECT * FROM characterNames')
#put the character names into a list
characterList = []
for row in cnDict:
characterList.append(str(row['characterName']))
#open a browser
print 'running openAbrowser'
browser = browserControl.openAbrowser(dwarfBeard.FF_PROFILE_PATH)
#login
print 'running loginToSite'
browserControl.loginToSite(browser, dwarfBeard.NW_USER_NAME, dwarfBeard.NW_PASSWORD)
#manage the tasks for each character
for eachCharacter in characterList:
#run the manager
professionGeneral.runTaskManagment(browser, eachCharacter)
#poll ad exchange rates, only one character name is needed
print 'running logZenExchange'
general.logZenExchange(browser, characterList[0])
#running decide log out time
print 'running decideLogoutTime'
logoutTime = professionGeneral.decideLogoutTime(browser, characterList)
#running endSession
print 'running end session'
browserControl.closeAbrowser(browser)
#calculate out the h, m, s, for the logout to make a nice message
h = logoutTime / 3600
m = (logoutTime % 3600) / 60
s = (logoutTime % 3600) % 60
#sleep until next run
print 'sleeping for', h, 'h', m, 'm', s, 's', ' @', strftime("%Y-%m-%d %H:%M:%S")
#set the timer interval to the logoutTime
timer.interval = logoutTime
if dwarfBeard.runTasks:
#start the timer
timer.start()
else:
print 'run tasks disabled. not starting login timer'
#signal the task is finished
dwarfBeard.taskExecRunning = 0
return
def main():
#initial settings
dwarfBeard.MY_FULLNAME = os.path.normpath(os.path.abspath(__file__))
dwarfBeard.MY_NAME = os.path.basename(dwarfBeard.MY_FULLNAME)
dwarfBeard.PROG_DIR = os.path.dirname(dwarfBeard.MY_FULLNAME)
dwarfBeard.DATA_DIR = dwarfBeard.PROG_DIR
#load the config file path if it is not loaded
if not dwarfBeard.CONFIG_FILE:
dwarfBeard.CONFIG_FILE = os.path.join(dwarfBeard.DATA_DIR, "config.ini")
#load the path to the db if it is not loaded
if not dwarfBeard.DB_FILE:
dwarfBeard.DB_FILE = os.path.join(dwarfBeard.DATA_DIR, "dwarf.db")
# Make sure that we can create the data dir
if not os.access(dwarfBeard.DATA_DIR, os.F_OK):
try:
os.makedirs(dwarfBeard.DATA_DIR, 0744)
except os.error:
sys.exit("Unable to create data directory: " + dwarfBeard.DATA_DIR + " Exiting.")
# Make sure we can write to the data dir
if not os.access(dwarfBeard.DATA_DIR, os.W_OK):
sys.exit("Data directory: " + dwarfBeard.DATA_DIR + " must be writeable (write permissions). Exiting.")
# Make sure we can write to the config file
if not os.access(dwarfBeard.CONFIG_FILE, os.W_OK):
if os.path.isfile(dwarfBeard.CONFIG_FILE):
sys.exit("Config file: " + dwarfBeard.CONFIG_FILE + " must be writeable (write permissions). Exiting.")
elif not os.access(os.path.dirname(dwarfBeard.CONFIG_FILE), os.W_OK):
sys.exit("Config file directory: " + os.path.dirname(dwarfBeard.CONFIG_FILE) + " must be writeable (write permissions). Exiting")
#change the working directory
os.chdir(dwarfBeard.DATA_DIR)
# Load the config and publish it to the dwarfBeard package
dwarfBeard.CFG = ConfigObj(dwarfBeard.CONFIG_FILE)
#if the db does not exist create it.
if not os.path.isfile(dwarfBeard.DB_FILE):
dbConn = sqlite3.connect(dwarfBeard.DB_FILE)
dbConn.close()
#init the db if needed
myDb = DBConnection(dwarfBeard.DB_FILE)
if not myDb.initTest():
myDb.createInitialSchema()
# Initialize dwarfBeard and the config
dwarfBeard.initialize()
# Use this PID for everything
dwarfBeard.PID = os.getpid()
#set the log dir
if dwarfBeard.WEB_LOG:
log_dir = dwarfBeard.LOG_DIR
else:
log_dir = None
#try to init the web server
try:
initWebServer({
'port': dwarfBeard.WEB_PORT,
'host': dwarfBeard.WEB_HOST,
'data_root': os.path.join(dwarfBeard.PROG_DIR, 'webData'),
'web_root': dwarfBeard.WEB_ROOT,
'log_dir': log_dir,
'username': dwarfBeard.WEB_USERNAME,
'password': dwarfBeard.WEB_PASSWORD,
})
except IOError:
dwarfBeard.launchBrowser(dwarfBeard.WEB_PORT)
print "Unable to start web server, is something else running on port: " + str(dwarfBeard.WEB_PORT)
# Launch browser if we're supposed to
if dwarfBeard.LAUNCH_BROWSER:
dwarfBeard.launchBrowser(dwarfBeard.WEB_PORT)
#create a task timer that executes the task action list at a set interval
#this is how we will control the time between profession jobs
taskActionTimer = TaskTimer(1, executeTaskActionList)
#create a bool for use during blackout hours
#this is to simulate the user getting some sleep
blackoutActive = False
blackoutActiveLastScan = False #used for edge detection
#here is the run loop
while True:
#decide if the current local time is within the black out time
blackoutActive = ((time.localtime()[3] >= int(dwarfBeard.BLACKOUT_START_HOUR)) or (time.localtime()[3] < int(dwarfBeard.BLACKOUT_END_HOUR))) and dwarfBeard.BLACKOUT_EN
#signal when black out becomes active
if blackoutActive and not blackoutActiveLastScan:
print 'Blackout just became active @', time.localtime()[3]
elif blackoutActiveLastScan and not blackoutActive:
print 'Blackout just ended @', time.localtime()[3]
#when we get the runTasks signal start the task timer
#if its not already running
#if task collection is in progress the timer will not be running
if dwarfBeard.runTasks and not blackoutActive:
if not (taskActionTimer.running or dwarfBeard.taskExecRunning):
print 'starting task timer'
#set a default interval. this will be reset by the log out function
taskActionTimer.interval = 1
taskActionTimer.start()
else:
if taskActionTimer.running:
if blackoutActive:
print 'stopping task timer during blackout period'
else:
print 'stopping task timer'
taskActionTimer.stop()
#set any vars for edge detection
blackoutActiveLastScan = blackoutActive
#sleep at the end of each scan so processor time is not consumed
time.sleep(1.0)