[mirrors/Kyberia-bloodline.git] / scripts / content_innodb.php

<?php
//requiring main config file with path/database etc. constants
require('../config/config.inc');

//connecting to database and creating universal $db object
require(SYSTEM_ROOT.'/inc/log.inc');
require(SYSTEM_ROOT.'/inc/database.inc');
require(SYSTEM_ROOT.'/inc/nodes.inc');
$db=new CLASS_DATABASE();

$qNCOld = "select * from node_content";
$i=0;
$set = $db->query($qNCOld);
while ($set->next()) {
  $i++;
  if ($i%100==0) echo "$i nodes loaded\n";
  $qNCNew = "update nodes set node_content='".addslashes($set->getString('node_content'))."' where node_id='".$set->getString('node_id')."'";
  $db->query($qNCNew);
}
?>
Commit	Line	Data
b42b2bf9 H	1	<?php
	2	//requiring main config file with path/database etc. constants
	3	require('../config/config.inc');
	4
	5	//connecting to database and creating universal $db object
	6	require(SYSTEM_ROOT.'/inc/log.inc');
	7	require(SYSTEM_ROOT.'/inc/database.inc');
	8	require(SYSTEM_ROOT.'/inc/nodes.inc');
	9	$db=new CLASS_DATABASE();
	10
	11	$qNCOld = "select * from node_content";
	12	$i=0;
	13	$set = $db->query($qNCOld);
	14	while ($set->next()) {
	15	$i++;
	16	if ($i%100==0) echo "$i nodes loaded\n";
	17	$qNCNew = "update nodes set node_content='".addslashes($set->getString('node_content'))."' where node_id='".$set->getString('node_id')."'";
	18	$db->query($qNCNew);
	19	}
	20	?>