prepare("SELECT id FROM emote_sets WHERE id = ? AND owner_id = ?"); $stmt->execute([$emote_set_id, $_SESSION['user_id']]); if ($stmt->rowCount() == 0) { generate_alert("/emotes", "Emoteset not found", 404); exit; } $emote_set = $stmt->fetch(PDO::FETCH_ASSOC); // get user by username $user_name = $_POST['username']; $stmt = $db->prepare("SELECT id FROM users WHERE username = ?"); $stmt->execute([$user_name]); if ($stmt->rowCount() == 0) { generate_alert("/404.php", "Username $user_name does not exist", 403); exit; } $user_id = $stmt->fetch(PDO::FETCH_ASSOC)['id']; // checking if user has already acquired emote set $stmt = $db->prepare("SELECT id FROM acquired_emote_sets WHERE user_id = ? AND emote_set_id = ?"); $stmt->execute([$user_id, $emote_set_id]); if ($stmt->rowCount() > 0) { generate_alert("/404.php", "User $user_name has acquired this emoteset.", 409); exit; } $db->prepare('INSERT INTO acquired_emote_sets(user_id, emote_set_id) VALUES (?, ?)') ->execute([$user_id, $emote_set_id]); generate_alert("/emotesets/?id=$emote_set_id", "This emoteset has been acquired by $user_name.", 200);