User.sql.php

<?php

User::addSqlQuery('USER_LIST',
    'SELECT * FROM  USER ORDER BY USER_ID');

User::addSqlQuery('USER_GET_WITH_LOGIN',
    'SELECT * FROM USER WHERE USER_LOGIN=:login');

User::addSqlQuery('USER_CONNECT',
    'SELECT * FROM USER WHERE USER_LOGIN=:login and USER_PASSWORD=:password');

User::addSqlQuery('USER_BY_ID',
    'SELECT * FROM  USER WHERE USER_ID=:user_id');

User::addSqlQuery('USER_UPDATE',
    "UPDATE USER SET USER_LOGIN=:login, USER_EMAIL=:email, USER_LASTNAME=:lastname, USER_FIRSTNAME=:firstname, USER_ROCK=:rock, USER_SCISSORS=:scissors, USER_PAPER=:paper, USER_WIN=:win, USER_LOST=:lost WHERE USER_ID=:id");

User::addSqlQuery('USER_DELETE',
    "DELETE FROM USER WHERE USER_ID=:id");

User::addSqlQuery('USER_CREATE',
    "INSERT INTO USER (USER_ID, USER_LOGIN, USER_EMAIL, USER_ROLE, USER_PASSWORD, USER_FIRSTNAME, USER_LASTNAME) VALUES (NULL, :login, :email, :role, :password, :firstname, :lastname)");

User::addSqlQuery('USER_GET_GAMES',
    "SELECT GAME_ID FROM GAME_HISTO WHERE USER_ID=:USER_ID");