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
| $member = $_SESSION['member_id'];
$campaign = 1;
$sql = 'SELECT mission_id, mission_name, complete_normal, complete_hard
FROM missions INNER JOIN complete
ON (mission_campaign = complete_campaign)
AND (mission_id = complete_mission)
WHERE mission_campaign = :campaign
AND complete_member = :member
UNION
SELECT mission_id, mission_name, 0, 0
FROM missions
WHERE mission_campaign = :campaign
AND mission_id NOT IN
(SELECT mission_id
FROM missions INNER JOIN complete
ON (mission_campaign = complete_campaign)
AND (mission_id = complete_mission)
WHERE mission_campaign = :campaign
AND complete_member = :member)
';
$sth = $db->prepare($sql);
$sth->bindParam(':campaign', $campaign, PDO::PARAM_INT);
$sth->bindParam(':member', $member, PDO::PARAM_INT);
$sth->execute(); |