LSteam

Project made in colaboration with Adrià Arroyo (@Arrooy) and Miquel Saula (@MSaula)

Com executar la AC.

1. Obrir una terminal i buscar la carpeta del projecte
2. docker-compose up -d
3. configurar adminer:
   1. Crear la Base de Dades anomenada "lsteam" amb les taules

   CREATE DATABASE lsteam;
   
   DROP TABLE IF EXISTS Game;
   CREATE TABLE Game(
   id Serial,
   gameId int,
   titol varchar(1000),
   price float,
   thumbnail varchar(1000),
   metacriticStore int,
   releaseDate DateTime,
   cheapestPrice float,
   wished BOOL
   );
   
   DROP TABLE IF EXISTS users;
   CREATE TABLE users (
   id int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   username varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   password varchar(255) NOT NULL,
   birthday datetime NOT NULL,
   phone varchar(20) NOT NULL,
   profilePic varchar(255),
   money int
   );
   
   DROP TABLE IF EXISTS usersPending;
   CREATE TABLE usersPending (
   token int NOT NULL AUTO_INCREMENT PRIMARY KEY,
   username varchar(255) NOT NULL,
   email varchar(255) NOT NULL,
   password varchar(255) NOT NULL,
   birthday datetime NOT NULL,
   phone varchar(20) NOT NULL
   );
   
   DROP TABLE IF EXISTS ownedGames;
   CREATE TABLE ownedGames (
   gameId int NOT NULL,
   userId int NOT NULL,
   PRIMARY KEY(gameId, userId),
   FOREIGN KEY (userId) REFERENCES users(id)
   );
   
   DROP TABLE IF EXISTS friendRequests;
   CREATE TABLE friendRequests (
   id_orig int,
   id_dest int,
   state int DEFAULT '0',
   accept_time timestamp NULL,
   PRIMARY KEY (id_orig, id_dest),
   FOREIGN KEY (id_orig) REFERENCES users (id),
   FOREIGN KEY (id_dest) REFERENCES users (id)
   );
   
   DROP TABLE IF EXISTS wishedGames;
   CREATE TABLE wishedGames (
   gameId int NOT NULL,
   userId int NOT NULL,
   PRIMARY KEY(gameId, userId),
   FOREIGN KEY (userId) REFERENCES users(id)
   );
   

4 -

sudo chmod 777 public/*   

5 - Ja hauria de funcionar tot.

Login: http://localhost:8030/login
Registre: http://localhost:8030/register
Search: http://localhost:8030/search
Landing Page: http://localhost:8030/

Nota. L'entorn php requereix de la llibreria composer.

Comandos útils per Docker

Eliminar tots els containers

sudo docker rm $(sudo docker ps -aq)

Parar tots els containers

sudo docker stop $(sudo docker ps -aq)

Per iniciar el composer

Per iniciar el composer i intalar-ho tot:

composer dump-autoload

Per carregar el DotENV:

composer require "symfony/dotenv"

.env File

Probablement per iniciar el sistema haureu de ficar al .env un format semblant al següent:

MYSQL_USER=root
MYSQL_ROOT_PASSWORD=admin
MYSQL_HOST=db
MYSQL_PORT=3306
MYSQL_DATABASE=lsteam
GIPHY_API_KEY=<TOKEN>