Esempio n. 1
0
File: Owners.php Progetto: pko22/vgs
 /**
  * Used to start/finish adding a link between a system and an owner
  * Optionally add a new system using the Systems model class
  *
  * @param array $options
  */
 public function sysaddAction($options)
 {
     // get system object
     $system = new \Videogames\Model\Systems();
     if (isset($_POST) && sizeof($_POST) > 0 && isset($_POST['own_id'])) {
         if (!isset($_POST['sys_id']) || $_POST['sys_id'] == '0') {
             if (!isset($_POST['sys_long']) || !isset($_POST['sys_short'])) {
                 $this->errorMsg['error_msg'] = "No system passed!";
                 $this->render($this->errorPage, $this->errorMsg, $this->stdHeader);
                 exit;
             }
             // Check if a system is known with given code
             $temp = $system->getSystemByCode($_POST['sys_short']);
             // No system exists, then add it
             if ($temp === false) {
                 $system->add($_POST);
                 $sys_id = \Videogames\Db::getInstance()->lastInsertId();
             } else {
                 // otherwise use this system (for now give an error)
                 // $sys_id = $temp['sys_id'];
                 $this->errorMsg['error_msg'] = "Abbreviation " . $_POST['sys_short'] . " already exsists!";
                 $this->render($this->errorPage, $this->errorMsg, $this->stdHeader);
                 exit;
             }
         } else {
             $sys_id = $_POST['sys_id'];
         }
         $own_id = $_POST['own_id'];
         if ($this->data->addSystem(['own_id' => $own_id, 'sys_id' => $sys_id])) {
             header("Location: /owner/syslist/" . $own_id);
             exit;
         } else {
             $this->errorMsg['error_msg'] = "Add failed.";
             $this->render($this->errorPage, $this->errorMsg, $this->stdHeader);
             exit;
         }
     }
     if (!isset($options['own_id']) || empty($options['own_id'])) {
         $this->errorMsg['error_msg'] = "No owner ID passed!";
         $this->render($this->errorPage, $this->errorMsg, $this->stdHeader);
         exit;
     }
     $owner = $this->data->getOwner($options['own_id']);
     if ($owner === false) {
         $this->errorMsg['error_msg'] = "Owner not found!";
         $this->render($this->errorPage, $this->errorMsg, $this->stdHeader);
         exit;
     }
     $systems = $system->getAllSystems();
     $sysown = $this->data->getSystems($options['own_id']);
     $this->render("owner/addsystem.phtml", ['owner' => $owner, 'systems' => $systems, 'sysown' => $sysown], $this->stdHeader);
 }
Esempio n. 2
0
 /**
  * Count number of games for a system
  *
  * @param int $sys_id
  *
  * @return int Number of game rows
  */
 public function countGames($sys_id)
 {
     $sql = "SELECT COUNT(*) FROM game\n                WHERE sys_id = :sys_id";
     $values = [':sys_id' => $sys_id];
     $query = \Videogames\Db::getInstance()->prepare($sql);
     $query->execute($values);
     return $query->fetchColumn();
 }
Esempio n. 3
0
File: Owners.php Progetto: pko22/vgs
 /**
  * Delete a sys_own row to unlink a system from an owner
  *
  * @param int $sysown_id
  *
  * @return bool
  */
 public function deleteSystem($sysown_id)
 {
     $sql = "DELETE FROM sys_own WHERE sysown_id = :sysown_id";
     $values = [':sysown_id' => $sysown_id];
     $query = \Videogames\Db::getInstance()->prepare($sql);
     return $query->execute($values);
 }
Esempio n. 4
0
File: Games.php Progetto: pko22/vgs
 /**
  * Fetch all game rows from 1 system
  *
  * @param int $sys_id
  *            System id
  *
  * @return mixed Array with rows or false
  */
 public function getSystemGames($sys_id)
 {
     $sql = "SELECT * FROM game ga\n                WHERE ga.sys_id = :sys_id\n                ORDER BY ga.sort_title";
     $values = [':sys_id' => $sys_id];
     $query = \Videogames\Db::getInstance()->prepare($sql);
     $query->execute($values);
     return $query->fetchAll();
 }