page_player.py

#!/usr/bin/python3
#
# page_player
# mperron (2019)
#
# Read a player's data from the endless-war database and present an HTML view.
import html
import sys

import ew.backend.core as bknd_core
import ew.static.cfg as ewcfg
from ew.backend.player import EwPlayer
from ew.utils import cmd as cmd_utils
from ew.utils.combat import EwUser


def faction(faction, life_state):
    url = "<img src=/img/icons/{}.png style=\"height: 1em;\"> "

    if life_state == 2:
        if faction == "killers" or faction == "rowdys":
            return url.format(faction)
    elif life_state == 1:
        return url.format("juveniles")
    elif life_state == 0:
        return url.format("ghost")

    return ""


if len(sys.argv) >= 3:
    id_server = sys.argv[1]
    id_user = sys.argv[2]
else:
    print("<p><i>Nothing but dust...</i></p>")
    sys.exit(0)

print("<article class=story>")

user_data = EwUser(id_user=id_user, id_server=id_server)
player = EwPlayer(id_user=id_user)

# Floating profile section
print("<div class=profile_float><img src=\"{avatar_url}\" class=profile_avatar>".format(
    avatar_url=player.display_avatar.url
))

print("<table>")
print("<tr><td>Faction</td><td>{icon}{faction}</td></tr>".format(
    icon=faction(user_data.faction, user_data.life_state),
    faction=user_data.faction

))
print("<tr><td>Slime</td><td>{slime:,}</td></tr>".format(slime=user_data.slimes))
print("<tr><td>SlimeCoin</td><td>{slimecoin:,}</td></tr>".format(slimecoin=user_data.slimecoin))
print("<tr><td>Bounty</td><td>{bounty:,}</td></tr>".format(bounty=int((user_data.bounty + 1) / ewcfg.slimecoin_exchangerate)))
print("</table>")

print("</div>")

# Header bar
print("<header><h2>{faction}<a href=player.html?pl={id_user}>{display_name}</a></h2></header>".format(
    id_user=id_user,
    display_name=html.escape(player.display_name),
    faction=faction(user_data.faction, user_data.life_state)
))

# Main body
print("<div>")

print("<p>{}</p>".format(html.escape("".join(cmd_utils.gen_data_text(
    id_user=id_user,
    id_server=id_server,
    display_name=player.display_name
)
))))

print("<h3>Statistics</h3>")
try:
    conn_info = bknd_core.databaseConnect()
    conn = conn_info.get('conn')
    cursor = conn.cursor();

    cursor.execute("SELECT {metric}, {value} FROM stats WHERE {id_server} = %s AND {id_user} = %s ORDER BY {metric}".format(
        value=ewcfg.col_stat_value,
        metric=ewcfg.col_stat_metric,
        id_server=ewcfg.col_id_server,
        id_user=ewcfg.col_id_user
    ), (
        id_server,
        id_user
    ))

    print("<table style=\"display: inline-block;\">")
    rows = cursor.fetchall()
    for row in rows:
        print("<tr><td>{metric}</td><td>{value:,}</td></tr>".format(
            metric=row[0],
            value=row[1]
        ))

    print("</table>")

except:
    print("<p><i>Failed to load stats.</i></p>");
finally:
    # Clean up the database handles.
    cursor.close()
    bknd_core.databaseClose(conn_info)

print("</div>")
print("</article>")