juliushaertl / deck

	}

	public function assignLabel($card, $label) {

		$sql = 'INSERT INTO `*PREFIX*deck_assigned_labels` (`label_id`,`card_id`) VALUES (?,?)';

		$stmt = $this->db->prepare($sql);

		$stmt->bindParam(1, $label, \PDO::PARAM_INT);

		$stmt->bindParam(2, $card, \PDO::PARAM_INT);

		$stmt->execute();

	}

	public function removeLabel($card, $label) {

		$sql = 'DELETE FROM `*PREFIX*deck_assigned_labels` WHERE card_id = ? AND label_id = ?';

		$stmt->execute();

	}

	public function removeLabel($card, $label) {

		$sql = 'DELETE FROM `*PREFIX*deck_assigned_labels` WHERE card_id = ? AND label_id = ?';

		$stmt = $this->db->prepare($sql);

		$stmt->bindParam(1, $card, \PDO::PARAM_INT);

		$stmt->bindParam(2, $label, \PDO::PARAM_INT);

		$stmt->execute();

	}

	public function isOwner($userId, $cardId) {

		$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_stacks` WHERE id IN (SELECT stack_id FROM `*PREFIX*deck_cards` WHERE id = ?))';

		return $result;

	}

	public function deleteLabelAssignments($labelId) {

		$sql = 'DELETE FROM `*PREFIX*deck_assigned_labels` WHERE label_id = ?';

		$stmt = $this->db->prepare($sql);

		$stmt->bindParam(1, $labelId, \PDO::PARAM_INT);

		$stmt->execute();

	}

	public function deleteLabelAssignmentsForCard($cardId) {

		$sql = 'DELETE FROM `*PREFIX*deck_assigned_labels` WHERE card_id = ?';

		$stmt->execute();

	}

	public function deleteLabelAssignmentsForCard($cardId) {

		$sql = 'DELETE FROM `*PREFIX*deck_assigned_labels` WHERE card_id = ?';

		$stmt = $this->db->prepare($sql);

		$stmt->bindParam(1, $cardId, \PDO::PARAM_INT);

		$stmt->execute();

	}

	public function isOwner($userId, $labelId) {

		$sql = 'SELECT owner FROM `*PREFIX*deck_boards` WHERE `id` IN (SELECT board_id FROM `*PREFIX*deck_labels` WHERE id = ?)';