1 import { db } from './lib/db';
2 import {Player, maxHp} from "../shared/player";
3 import { random } from 'lodash';
4 import { Skills } from '../shared/skills';
5 import {Profession} from 'shared/profession';
6 import {logger} from './lib/logger';
8 export async function loadPlayer(authToken: string): Promise<Player> {
9 const res = await db.first()
10 .select('players.*', 'profession_levels.level', 'profession_levels.exp')
11 .from<Player>('players')
12 .join('profession_levels', function() {
14 this.on('profession_levels.player_id', '=', 'players.id')
15 this.andOn('profession_levels.profession', '=', 'players.profession')
19 'players.id': authToken
25 export async function createPlayer(): Promise<Player> {
26 const raw: Partial<Player> = {
27 username: `Player${Date.now().toString().substr(-7)}`,
28 strength: random(3, 5),
29 constitution: random(3, 5),
30 dexterity: random(3, 5),
31 intelligence: random(3, 5),
34 raw.hp = maxHp(raw.constitution, 1);
36 const res = await db('players').insert(raw).returning<Player[]>('*');
37 const player = res.pop();
39 logger.log(`Created player [${player.id}]`);
44 const sql = `insert into player_skills (id, player_id) values `;
46 logger.log(`Inserted base skills for [${player.id}]`)
48 Skills.forEach(skill => {
50 values.push(skill.id, player.id);
53 await db.raw(sql + pairs.join(','), values);
55 // create the profession level
56 await db('profession_levels').insert({
58 profession: 'Wanderer',
63 logger.log(`Inserted base profession level [${player.id}]`);
69 export async function updatePlayer(player: Player) {
75 strength: player.strength,
76 constitution: player.constitution,
77 dexterity: player.dexterity,
78 intelligence: player.intelligence,
79 stat_points: player.stat_points,
82 db('profession_levels').where({
84 profession: player.profession
92 export async function movePlayer(cityId: number, playerId: string) {
93 return db('players').where({
95 }).update({city_id: cityId})
98 export async function changeProfession(player_id: string, newProfession: Profession): Promise<{level: number, exp: number}> {
102 await db('profession_levels').insert({
104 profession: newProfession,
111 const res = await db.first().select('*').from('profession_levels').where({
113 profession: newProfession
118 // profession already exists, wahtever yo!
121 await db('players').where({
123 }).update({ profession: newProfession });