Card-Sleeves/game_update.php at master · thedeviousdev/Card-Sleeves · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
<?php
// include_once("login_session.php");
include_once('directory.php');
include_once('game_update_base.php');
// Update a card's details or add a new card

if(session_status() != PHP_SESSION_NONE && $_SESSION["loggedIn"] && isset($_POST['game_id'])) {

  $game_ID = $_POST['game_id'];

  $sleeve = $_POST['sleeve'];
  $quantity = $_POST['quantity'];
  $card_nb = $_POST['nb'];

  $card_array = count($quantity);

  for($i=0; $i<$card_array; $i++) {
    if($quantity[$i] != '0')
      card_update($game_ID, $quantity[$i], $card_nb[$i], $sleeve[$i]);
  }

  if(isset($_POST['base_id'])) {
    $base_ID = $_POST['base_id'];

    update_base($game_ID, $base_ID);
  }

  if(isset($_POST['image']) && $_POST['image'] !== NULL && $_POST['image'] !== "") {
    $image = $_POST['image'];

    update_image($game_ID, $image);
  }

  if(isset($_POST['edition'])) {
    $edition = $_POST['edition'];

    update_edition($game_ID, $edition);
  }

  if(isset($_POST['year'])) {
    $year = $_POST['year'];

    update_year($game_ID, $year);
  }

}

function update_image($g, $image){
  echo 'update_image';
  try {
    $db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');

    $check = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
    if ($check->fetchColumn() > 0) {

      $result = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
      foreach($result as $row) {
        $old_image = $row['Image'];

        if($old_image != $image)
          $db->exec("UPDATE Game SET Image = '" . $image  . "' WHERE Id = '" . $g . "';");
      }
    }
    return game_detail(new_game_object($g));
  }
  catch(PDOException $e)  {
    print 'Exception : '. $e->getMessage();
  }
}


function update_edition($g, $edition){
  echo 'update_edition';
  try {
    $db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');

    $check = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
    if ($check->fetchColumn() > 0) {

      $result = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
      foreach($result as $row) {
        $old_edition = $row['Edition'];

        if($old_edition != $edition)
          $db->exec("UPDATE Game SET Edition = '" . $edition  . "' WHERE Id = '" . $g . "';");
      }
    }
    return game_detail(new_game_object($g));
  }
  catch(PDOException $e)  {
    print 'Exception : '. $e->getMessage();
  }
}

function update_year($g, $year){
  echo 'update_year';
  try {
    $db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');

    $check = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
    if ($check->fetchColumn() > 0) {

      $result = $db->query("SELECT * FROM Game WHERE Id ='" . $g ."';");
      foreach($result as $row) {
        $old_year = $row['Year'];

        if($old_year != $year)
          $db->exec("UPDATE Game SET Year = '" . $year  . "' WHERE Id = '" . $g . "';");
      }
    }
    return game_detail(new_game_object($g));
  }
  catch(PDOException $e)  {
    print 'Exception : '. $e->getMessage();
  }
}

function card_update($g, $quantity, $card_nb, $sleeve_id, $base_id = NULL){

  try {
    $db = new PDO('sqlite:' . dir_path() . '/data/games_db.sqlite');
    // Check for results first
    $check = $db->query("SELECT * FROM Cards WHERE GameID ='" . $g ."' AND SleeveId ='" . $sleeve_id . "' AND CardNb ='" . $card_nb . "';");

    // If there already exists a card, update its quantity
    if ($check->fetchColumn() > 0) {
      $result = $db->query("SELECT * FROM Cards WHERE GameID ='" . $g ."' AND SleeveId ='" . $sleeve_id . "' AND CardNb ='" . $card_nb . "';");

      foreach($result as $row) {
        $id = $row['Id'];
        $old_qty = $row['Quantity'];
        $old_card_nb = $row['CardNb'];
        $old_sleeve_id = $row['SleeveId'];

        // echo "UPDATE Cards SET Quantity = '" . $quantity . "' WHERE GameId = '" . $g . "' AND CardNb = '" . $card_nb  . "';";

        if($old_qty != $quantity || $old_card_nb != $card_nb || $old_sleeve_id != $sleeve_id ) {

          $db->exec("UPDATE Cards SET Quantity = '" . $quantity . "' WHERE GameId = '" . $g . "' AND CardNb = '" . $card_nb  . "';");
        }
      }
    }
    // Otherwise, add a new card size & quantity
    else {
      $db->exec("INSERT INTO Cards (GameId, SleeveId, CardNb, Quantity) VALUES ('" . $g . "', '" . $sleeve_id . "', '" . $card_nb . "', '" . $quantity . "');");
    }
  }
  catch(PDOException $e)  {
    print 'Exception : '. $e->getMessage();
  }
}
?>