157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
|
{
$db = DB::getInstance();
if ($db->simpleQuerySingle('SELECT COUNT(*) FROM wiki_pages WHERE parent = ?;', false, (int)$id))
{
return false;
}
$db->simpleExec('DELETE FROM wiki_revisions WHERE id_page = ?;', (int)$id);
//$db->simpleExec('DELETE FROM wiki_suivi WHERE id_page = ?;', (int)$id); FIXME
$db->simpleExec('DELETE FROM wiki_recherche WHERE id = ?;', (int)$id);
$db->simpleExec('DELETE FROM wiki_pages WHERE id = ?;', (int)$id);
return true;
}
public function get($id)
{
$db = DB::getInstance();
return $db->simpleQuerySingle('SELECT *,
|
>
>
>
>
>
>
>
>
>
>
|
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
|
{
$db = DB::getInstance();
if ($db->simpleQuerySingle('SELECT COUNT(*) FROM wiki_pages WHERE parent = ?;', false, (int)$id))
{
return false;
}
// Suppression des fichiers liés
$files = Fichiers::listLinkedFiles(Fichiers::LIEN_WIKI, $id, null);
foreach ($files as $file)
{
$file = new Fichiers($file['id'], $file);
$file->remove();
}
$db->simpleExec('DELETE FROM wiki_revisions WHERE id_page = ?;', (int)$id);
//$db->simpleExec('DELETE FROM wiki_suivi WHERE id_page = ?;', (int)$id); FIXME
$db->simpleExec('DELETE FROM wiki_recherche WHERE id = ?;', (int)$id);
$db->simpleExec('DELETE FROM wiki_pages WHERE id = ?;', (int)$id);
return true;
}
public function get($id)
{
$db = DB::getInstance();
return $db->simpleQuerySingle('SELECT *,
|