Overview
Comment: | identité, pas identifiant |
---|---|
Downloads: | Tarball | ZIP archive | SQL archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
346ce111feb3075b530e423c4d55d1ab |
User & Date: | bohwaz on 2014-04-18 04:08:51 |
Other Links: | manifest | tags |
Context
2014-04-18
| ||
04:17 | Rendu des diff du wiki check-in: 6a9c3ed756 user: bohwaz tags: trunk | |
04:08 | identité, pas identifiant check-in: 346ce111fe user: bohwaz tags: trunk | |
03:48 | Ne pas laisser la possibilité d'automatiser comme ça, c'est trop bancal check-in: 249da9228e user: bohwaz tags: trunk | |
Changes
Modified src/include/class.wiki.php from [80444f9637] to [1dd8836624].
︙ | ︙ | |||
191 192 193 194 195 196 197 | $db = DB::getInstance(); return $db->simpleQuerySingle('SELECT titre FROM wiki_pages WHERE id = ? LIMIT 1;', false, (int)$id); } public function getRevision($id, $rev) { $db = DB::getInstance(); | | | | 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 | $db = DB::getInstance(); return $db->simpleQuerySingle('SELECT titre FROM wiki_pages WHERE id = ? LIMIT 1;', false, (int)$id); } public function getRevision($id, $rev) { $db = DB::getInstance(); $champ_id = Config::getInstance()->get('champ_identite'); // FIXME pagination au lieu de bloquer à 1000 return $db->simpleQuerySingle('SELECT r.revision, r.modification, r.id_auteur, r.contenu, strftime(\'%s\', r.date) AS date, LENGTH(r.contenu) AS taille, m.'.$champ_id.' AS nom_auteur, r.chiffrement FROM wiki_revisions AS r LEFT JOIN membres AS m ON m.id = r.id_auteur WHERE r.id_page = ? AND revision = ? LIMIT 1;', true, (int) $id, (int) $rev); } public function listRevisions($id) { $db = DB::getInstance(); $champ_id = Config::getInstance()->get('champ_identite'); // FIXME pagination au lieu de bloquer à 1000 return $db->simpleStatementFetch('SELECT r.revision, r.modification, r.id_auteur, strftime(\'%s\', r.date) AS date, LENGTH(r.contenu) AS taille, m.'.$champ_id.' AS nom_auteur, LENGTH(r.contenu) - (SELECT LENGTH(contenu) FROM wiki_revisions WHERE id_page = r.id_page AND revision < r.revision ORDER BY revision DESC LIMIT 1) AS diff_taille, r.chiffrement FROM wiki_revisions AS r LEFT JOIN membres AS m ON m.id = r.id_auteur |
︙ | ︙ |