X-Git-Url: http://git.cyclocoop.org/?p=velocampus%2Fweb%2Fwww.git;a=blobdiff_plain;f=www%2Fecrire%2Fmaj%2Fvieille_base%2F1917%2Fcreate.php;fp=www%2Fecrire%2Fmaj%2Fvieille_base%2F1917%2Fcreate.php;h=e2263634e61cad6b2779e2da1657388ced17717e;hp=0000000000000000000000000000000000000000;hb=80b4d3e85f78d402ed2e73f8f5d1bf4c19962eed;hpb=aaf970bf4cdaf76689ecc10609048e18d073820c diff --git a/www/ecrire/maj/vieille_base/1917/create.php b/www/ecrire/maj/vieille_base/1917/create.php new file mode 100644 index 0000000..e226363 --- /dev/null +++ b/www/ecrire/maj/vieille_base/1917/create.php @@ -0,0 +1,61 @@ + $v) + spip_create_vieille_table($k, $v['field'], $v['key'], true); + + foreach($tables_auxiliaires as $k => $v) + spip_create_vieille_table($k, $v['field'], $v['key'], false); + + foreach($tables_images as $k => $v) + spip_query("INSERT IGNORE INTO spip_types_documents (extension, inclus, titre, id_type) VALUES ('$k', 'image', '" . + (is_numeric($v) ? + (strtoupper($k) . "', $v") : + "$v', 0") . + ")"); + + foreach($tables_sequences as $k => $v) + spip_query("INSERT IGNORE INTO spip_types_documents (extension, titre, inclus) VALUES ('$k', '$v', 'embed')"); + + foreach($tables_documents as $k => $v) + spip_query("INSERT IGNORE INTO spip_types_documents (extension, titre, inclus) VALUES ('$k', '$v', 'non')"); + + foreach ($tables_mime as $extension => $type_mime) + spip_query("UPDATE spip_types_documents + SET mime_type='$type_mime' WHERE extension='$extension'"); +} +/* +// http://doc.spip.org/@stripslashes_base +function stripslashes_base($table, $champs) { + $modifs = ''; + reset($champs); + while (list(, $champ) = each($champs)) { + $modifs[] = $champ . '=REPLACE(REPLACE(' .$champ. ',"\\\\\'", "\'"), \'\\\\"\', \'"\')'; + } + spip_query("UPDATE $table SET ".join(',', $modifs)); + +}*/ + +?>