def spells(cursor):
output = {}
spell_dict = spell_q.get_all_spells(cursor)
for s, the_spell in spell_dict.items():
output[s] = {
"spell_id": s,
"name": the_spell.name,
"tier": the_spell.tier,
"max_level": the_spell.max_level,
"category": spell.categories[the_spell.category],
"cooldown": the_spell.cooldown,
"cast_time": the_spell.cast_time,
"tradable": the_spell.tradable,
"description": the_spell.description,
}
return json.dumps(output)
def spells(cursor):
output = {}
id_list = []
spell_dict = spell_q.get_all_spells(cursor)
for s, the_spell in spell_dict.items():
id_list.append(s)
output[s] = {
"spell_id": s,
"name": the_spell.name,
"tier": the_spell.tier,
"max_level": the_spell.max_level,
"category": spell.categories[the_spell.category],
# "cooldown": the_spell.cooldown,
# "cast_time": the_spell.cast_time,
"tradable": the_spell.tradable,
}
return "spells = %s; spell_list = %s;" % (json.dumps(output), id_list)
import database from classes import world, res_dict from classes import team, city, squad, army, unit from queries import equipment_q, building_q, deity_q, evolution_q, tech_q, spell_q, artefact_q, wonder_q # Need some live data for things like buildings etc temp_cursor = database.get_cursor() equipment_dict = equipment_q.get_all_equipment(temp_cursor) building_dict = building_q.get_all_buildings(temp_cursor) deity_dict = deity_q.get_all_deities(temp_cursor) evolution_dict = evolution_q.get_all_evolutions(temp_cursor) spell_dict = spell_q.get_all_spells(temp_cursor) tech_dict = tech_q.get_all_techs(temp_cursor) artefact_dict = artefact_q.get_all_artefacts(temp_cursor) wonder_dict = wonder_q.get_all_wonders(temp_cursor) def dummy_world(): w = world.World(Dead_cursor()) # LISTS #------------------------ w._equipment = equipment_dict w._buildings = building_dict w._deities = deity_dict w._evolutions = evolution_dict w._spells = spell_dict w._techs = tech_dict w._artefacts = artefact_dict # TEAMS #------------------------
def main(cursor):
# Get team Id
team_id = int(common.get_val('team', 0))
if team_id < 1:
return "<div style='padding: 5px;'>%s</div>" % common.select_team_form(cursor, 'list_spells')
# Build team item
the_team = team_q.get_one_team(cursor, team_id)
spell_dict = spell_q.get_all_spells(cursor)
output = []
the_team.get_spells(cursor)
output.append("""
<table style="width: 100%;" border="0" cellspacing="0" cellpadding="5">
<tr class="row2">
<th>#</th>
<th> </th>
</tr>
""")
max_spell_level = 1
skip_spell_list = {}
table_dict = {}
spell_points_spent = 0
for spell_id, spell_level in the_team.spell_levels.items():
if spell_level not in table_dict:
table_dict[spell_level] = []
skip_spell_list[spell_level] = []
max_spell_level = max(max_spell_level, spell_level)
# Total that they've spent
the_spell = spell_dict[spell_id]
spell_points_spent += spell_rules.cost_to_get_to_level(cursor, the_spell, spell_level, in_spell_points=True).get("Spell points", 0)
spell_points_spent += the_team.spell_points[spell_id]
skip_spell_list[spell_level].append(spell_id)
table_dict[spell_level].append("""%(name)s <a class="red_link" href="exec.py?mode=set_spell&spell=%(spell_id)s&team=%(team_id)s&level=%(level_down)s&points=0"> < </a>
%(points)s/%(points_to_next)s
<a class="green_link" href="exec.py?mode=set_spell&spell=%(spell_id)s&team=%(team_id)s&level=%(level_up)s&points=0"> > </a>""" % {
"name": the_spell.name,
"spell_id": spell_id,
"team_id": team_id,
"points": the_team.spell_points[spell_id],
"points_to_next": spell_rules.cost_for_next_level(cursor, the_spell, spell_level, in_spell_points=True).get("Spell points"),
"level_down": spell_level-1,
"level_up": spell_level+1,
})
for i in range(0, max_spell_level+1):
if i not in table_dict:
table_dict[i] = []
skip_spell_list[i] = []
output.append("""
<tr class="row%(row_count)s">
<td width="15">%(i)s</td>
<td style="padding: 5px 2px 0 2px;">%(spells)s
<!--
<form id="spell_form_%(i)s" style="float: right;" action="exec.py" method="post" accept-charset="utf-8">
<input type="hidden" name="mode" value="set_spell" />
<input type="hidden" name="team" value="%(team_id)s" />
<input type="hidden" name="points" value="0" />
<input type="hidden" name="level" value="%(i)s" />
<a href="#" onclick="$('#spell_form_%(i)s').submit();" class="block_link" style="float: right;">Add</a>
<select style="float: right;" name="spell">%(new_spell)s</select></form>
-->
</td>
</tr>
""" % {
"i": i,
"team_id": team_id,
"row_count": (i%2),
"spells": ", ".join(table_dict[i]),
"new_spell": spell_f.spell_option_list(cursor, skip_spell_list[i]),
})
# Add spells
output.append("""
<tr class="row%(row_count)s">
<td colspan="2">
<form action="exec.py" method="post" accept-charset="utf-8">
<input type="hidden" name="mode" value="set_spell" />
<input type="hidden" name="team" value="%(team_id)s" />
<select name="spell" id="new_spell">
%(spell_list)s
</select>
L: <input type="text" name="level" id="new_level" value="" onblur="$('#points_to_next').load('web.py', {'ajax':'True','mode':'spell_points_for_next','spell':$('#new_spell').val(), 'level':$('#new_level').val()});" size="5"/>
P: <input type="text" name="points" value="" size="5" />/<span id="points_to_next">0</span>
<input type="submit" value="Add" />
</form>
</td>
</tr>
%(onload)s
""" % {
"team_id": team_id,
"row_count": ((i+1)%2),
"spell_list": spell_f.spell_option_list(cursor),
"onload": common.onload("$('#new_spell').focus();"),
})
output.append("</table>")
output.append("<br /> Total spell points spent: %d" % spell_points_spent)
return "".join(output)