public function stack_load_card($card_id)
{
$stmt = $this->file_db->prepare('SELECT card.bkgnd_id, bkgnd.bkgnd_name, bkgnd.cant_delete, bkgnd.dont_search, ' . 'bkgnd.bkgnd_data, card.card_data, card_name, card_seq, card.object_data, ' . 'bkgnd.object_data, card.cant_delete, card.dont_search, card.marked, card.card_art, bkgnd.bkgnd_art ' . 'FROM card JOIN bkgnd ON card.bkgnd_id=bkgnd.bkgnd_id WHERE card_id=?');
Stack::sl_ok($stmt, $this->file_db, 'Loading Card (1)');
Stack::sl_ok($stmt->execute(array(intval($card_id))), $this->file_db, 'Loading Card (2)');
$row = $stmt->fetch(PDO::FETCH_NUM);
if ($row === false) {
return null;
}
$card['card_id'] = intval($card_id);
$card['card_name'] = $row[6];
$card['card_seq'] = $row[7] / 10;
$card['card_cant_delete'] = Stack::decode_bool($row[10]);
$card['card_dont_search'] = Stack::decode_bool($row[11]);
$card['card_marked'] = Stack::decode_bool($row[12]);
$data = json_decode($row[5], true);
$card['card_script'] = Stack::nvl($data['card_script'], array('content' => '', 'selection' => 0));
$card['card_has_art'] = Stack::nvl($data['card_has_art'], false);
$card['data'] = '';
if (isset($data['data'])) {
$card['data'] = $data['data'];
}
$card['card_art'] = null;
if (isset($row[13]) && $row[13] !== '' && $row[13] !== null) {
$card['card_art'] = $row[13];
}
//if (isset($data['content']))
// $card['content'] = $data['content'];
$card['card_object_data'] = $row[8];
$card['bkgnd_id'] = $row[0];
$card['bkgnd_name'] = $row[1];
$card['bkgnd_cant_delete'] = Stack::decode_bool($row[2]);
$card['bkgnd_dont_search'] = Stack::decode_bool($row[3]);
$data = json_decode($row[4], true);
$card['bkgnd_script'] = Stack::nvl($data['bkgnd_script'], array('content' => '', 'selection' => 0));
$card['bkgnd_has_art'] = Stack::nvl($data['bkgnd_has_art'], false);
$card['bkgnd_art'] = null;
if (isset($row[14]) && $row[14] !== '' && $row[14] !== null) {
$card['bkgnd_art'] = $row[14];
}
$card['bkgnd_object_data'] = $row[9];
$card['stack_count'] = Stack::stack_get_count_cards(null);
$card['bkgnd_count'] = Stack::stack_get_count_cards($card['bkgnd_id']);
return $card;
}
