Repository navigation
Expand file tree
/
Copy pathserver.js
More file actions
232 lines (204 loc) · 7.63 KB
/
Copy pathserver.js
File metadata and controls
232 lines (204 loc) · 7.63 KB
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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
require('dotenv').config();
const express = require('express');
const path = require('path');
const session = require('express-session');
const cookieParser = require('cookie-parser');
const passport = require('passport');
// Initialise la BDD et applique le schéma + migrations au démarrage
const db = require('./db/database');
const BetterSQLiteStore = require('./db/session-store');
const { generateToken } = require('./middleware/csrf');
const { i18next, middleware: i18nMiddleware } = require('./lib/i18n');
const { applyLang } = require('./middleware/lang');
const { captureReferer } = require('./middleware/referer');
const siteConfig = require('./lib/config');
const authRoutes = require('./routes/auth');
const interestsRoutes = require('./routes/interests');
const settingsRoutes = require('./routes/settings');
const stumbleRoutes = require('./routes/stumble');
const voteRoutes = require('./routes/votes');
const favoritesRoutes = require('./routes/favorites');
const submitRoutes = require('./routes/submit');
const adminRoutes = require('./routes/admin');
const reportRoutes = require('./routes/report');
const tastesRoutes = require('./routes/tastes');
const legalRoutes = require('./routes/legal');
const accountRoutes = require('./routes/account');
const searchRoutes = require('./routes/search');
const curateRoutes = require('./routes/curate');
const seoRoutes = require('./routes/seo');
const profileRoutes = require('./routes/profile');
const { router: collectionsRoutes } = require('./routes/collections');
const followsRoutes = require('./routes/follows');
const notificationsRoutes = require('./routes/notifications');
const fs = require('fs');
const { version: APP_VERSION } = require('./package.json');
const app = express();
const PORT = process.env.PORT || 3000;
// Version du CSS basée sur sa date de modification (cache-busting automatique)
const CSS_VERSION = (() => {
try {
return fs.statSync(path.join(__dirname, 'public/style.css')).mtimeMs.toString(36);
} catch { return '1'; }
})();
// Caddy termine TLS et proxifie en HTTP → Express doit faire confiance au proxy
app.set('trust proxy', 1);
// Moteur de templates EJS
app.set('view engine', 'ejs');
app.set('views', path.join(__dirname, 'views'));
// Fichiers statiques (CSS, JS, images)
app.use(express.static(path.join(__dirname, 'public')));
// Cookies (nécessaire pour la détection de langue)
app.use(cookieParser());
// Sessions persistantes dans SQLite
app.use(session({
store: new BetterSQLiteStore(),
secret: process.env.SESSION_SECRET,
resave: false,
saveUninitialized: false,
cookie: {
httpOnly: true,
secure: process.env.NODE_ENV === 'production',
sameSite: 'lax',
maxAge: 30 * 24 * 60 * 60 * 1000,
},
}));
// Parsing des formulaires
app.use(express.urlencoded({ extended: false }));
app.use(express.json());
app.use(passport.initialize());
// i18n — doit être après cookieParser et session
app.use(i18nMiddleware.handle(i18next));
app.use(applyLang);
// Rend l'utilisateur, le token CSRF et l'URL de base disponibles dans tous les templates
app.use((req, res, next) => {
res.locals.user = req.session.userId
? { id: req.session.userId, username: req.session.username, isAdmin: req.session.isAdmin, isCurator: req.session.isCurator }
: null;
res.locals.baseUrl = process.env.BASE_URL || 'https://stumbupon.com';
res.locals.cssVersion = CSS_VERSION;
res.locals.appVersion = APP_VERSION;
res.locals.siteConfig = siteConfig.getAll();
res.locals.unreadNotifications = 0;
// Empêche tout cache (navigateur + CDN) pour les pages personnalisées
if (req.session.userId) {
res.set('Cache-Control', 'private, no-store');
}
next();
});
const stmtUnreadNotif = db.prepare(
'SELECT COUNT(*) AS n FROM notifications WHERE user_id=? AND read_at IS NULL'
);
app.use((req, res, next) => {
if (req.session.userId) {
res.locals.unreadNotifications = stmtUnreadNotif.get(req.session.userId).n;
}
next();
});
app.use(generateToken);
// Flash succès — lit et vide la session à chaque rendu
app.use((req, res, next) => {
res.locals.achievementFlash = req.session._achievements_flash || [];
delete req.session._achievements_flash;
next();
});
// URL canonique automatique pour toutes les pages
app.use((req, res, next) => {
res.locals.canonicalUrl = res.locals.baseUrl + req.path;
next();
});
// noindex sur les pages privées / sans valeur SEO
const _NOINDEX_EXACT = new Set([
'/stumble', '/stumble/join', '/stumble/join/skip',
'/login', '/signup', '/forgot-password',
'/settings', '/favorites', '/interests', '/tastes', '/curate', '/offline',
'/collections', '/following', '/notifications',
]);
const _NOINDEX_PREFIX = ['/admin', '/account/', '/reset-password/', '/verify-email/'];
app.use((req, res, next) => {
res.locals.noindex = _NOINDEX_EXACT.has(req.path)
|| _NOINDEX_PREFIX.some(p => req.path.startsWith(p));
next();
});
// Capture des Referers entrants (avant les routes)
app.use(captureReferer);
// Routes
app.use(authRoutes);
app.use(interestsRoutes);
app.use(settingsRoutes);
app.use(stumbleRoutes);
app.use(voteRoutes);
app.use(favoritesRoutes);
app.use(submitRoutes);
app.use(adminRoutes);
app.use(reportRoutes);
app.use(tastesRoutes);
app.use(legalRoutes);
app.use(accountRoutes);
app.use(searchRoutes);
app.use(curateRoutes);
app.use(seoRoutes);
app.use(profileRoutes);
app.use(collectionsRoutes);
app.use(followsRoutes);
app.use(notificationsRoutes);
const stmtRecentSites = db.prepare(`
SELECT s.id, s.url, s.title, s.description, s.language
FROM sites s
WHERE s.status = 'approved'
ORDER BY s.approved_at DESC
LIMIT 6
`);
const stmtSiteCategories = db.prepare(`
SELECT sc.site_id, c.emoji,
COALESCE(ct.name, c.name) AS localName
FROM site_categories sc
JOIN categories c ON c.id = sc.category_id
LEFT JOIN category_translations ct ON ct.category_id = c.id AND ct.language = ?
WHERE sc.site_id IN (SELECT value FROM json_each(?))
ORDER BY localName
`);
const stmtStats = db.prepare(`
SELECT
(SELECT COUNT(*) FROM sites WHERE status = 'approved') AS site_count,
(SELECT COUNT(*) FROM users) AS user_count
`);
const stmtUserStats = db.prepare(`
SELECT
(SELECT COUNT(*) FROM votes WHERE user_id = ? AND direction = 1) AS favorites,
(SELECT COUNT(*) FROM views WHERE user_id = ?) AS discovered
`);
const HOME_JSON_LD = {
'@context': 'https://schema.org',
'@type': 'WebSite',
name: 'StumbUpon.com',
url: 'https://stumbupon.com',
potentialAction: {
'@type': 'SearchAction',
target: { '@type': 'EntryPoint', urlTemplate: 'https://stumbupon.com/search?q={search_term_string}' },
'query-input': 'required name=search_term_string',
},
};
app.get('/', (req, res) => {
const stats = stmtStats.get();
const userId = req.session?.userId;
if (userId) {
const userStats = stmtUserStats.get(userId, userId);
return res.render('home', { title: 'StumbUpon.com', stats, userStats, recentSites: null, jsonLd: null });
}
const lang = res.locals.currentLang || 'fr';
const recent = stmtRecentSites.all();
const ids = JSON.stringify(recent.map(s => s.id));
const cats = stmtSiteCategories.all(lang, ids);
const catsBySite = {};
for (const c of cats) {
if (!catsBySite[c.site_id]) catsBySite[c.site_id] = [];
catsBySite[c.site_id].push(c);
}
const recentSites = recent.map(s => ({ ...s, categories: catsBySite[s.id] || [] }));
res.render('home', { title: 'StumbUpon.com', stats, userStats: null, recentSites, jsonLd: HOME_JSON_LD });
});
app.get('/offline', (req, res) => res.render('offline'));
app.listen(PORT, () => {
console.log(`StumbUpon.com lancé sur http://localhost:${PORT}`);
});