artifact-convert-files.php

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· PHP 代码 · 共 30 行

#!/usr/local/bin/php
<?php

require ('squal_pre.php');

db_begin();

$rel = db_query("SELECT id,bin_data FROM artifact_file ORDER BY id ASC;");
echo db_error();

$rows=db_numrows($rel);

for ($i=0; $i<$rows; $i++) {

	$res=db_query("UPDATE artifact_file 
		SET bin_data='". base64_encode( util_unconvert_htmlspecialchars( db_result($rel,$i,'bin_data') ) ) ."' 
		WHERE id='". db_result($rel,$i,'id') ."'");

	echo db_error();
	echo "<br />Num: $i | id: ".db_result($rel,$i,'id');

}

db_commit();
echo "Done: ".db_error();

db_query("vacuum analyze;");

?>