-- One‑time purchases (Pay‑Per‑View) CREATE TABLE purchases ( id BIGSERIAL PRIMARY KEY, user_id BIGINT REFERENCES users(id) ON DELETE CASCADE, model_id BIGINT REFERENCES users(id), stream_id BIGINT NOT NULL, -- reference to a live/recorded stream stripe_charge_id VARCHAR(255) UNIQUE, amount_cents INTEGER NOT NULL, purchased_at TIMESTAMP DEFAULT NOW() );
router.post('/webhooks/stripe', express.raw(type: 'application/json'), async (req, res) => const sig = req.headers['stripe-signature']; let event; camwhores.v
try event = stripe.webhooks.constructEvent(req.body, sig, process.env.STRIPE_WEBHOOK_SECRET); catch (err) console.error('⚠️ Webhook signature verification failed.', err); return res.sendStatus(400); model_id BIGINT REFERENCES users(id)
if (event.type === 'checkout.session.completed') const session = event.data.object; const userId, streamId = session.metadata; stream_id BIGINT NOT NULL
load(); , [id]);
// Render the video player (e.g., HLS.js, Vimeo, or your streaming CDN) return ( <div> <h2>stream.title</h2> <video controls src=stream.video_url style= width: '100%', maxWidth: '800px' /> </div> );