5 * Data migration for the doc_manager - between pre6 and pre7
7 * Copyright 2002 (c) GFORGE LLC
12 require ('squal_pre.php');
14 // drop and recreate page cache
16 //SELECT * FROM doc_data WHERE filename is null;
19 $res=db_query("SELECT * FROM doc_data WHERE filename IS NULL");
25 $rows=db_numrows($res);
27 for ($i=0; $i<$rows; $i++) {
29 $res2=db_query("UPDATE doc_data
31 data='". base64_encode( util_unconvert_htmlspecialchars( db_result($res,$i,'data') )) ."',
32 filename='file".db_result($res,$i,'docid').".html',
34 WHERE docid='".db_result($res,$i,'docid')."'");
35 if (!$res2 || db_affected_rows($res2) < 1) {
36 echo 'DB ERROR'.db_error();