[mirrors/Kyberia-bloodline.git] / cron / delete_rss.php

#!/usr/local/bin/php
<?php
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();

$set=$db->query("select node_id from nodes where node_type='13'");

while ($set->next()) {
	$id=$set->getString('node_id');
	if (is_numeric($id)) {
		$q="delete from node_content where node_id='$id'";
		$db->query($q);
		$q="delete from nodes where node_id='$id'";
		$db->query($q);
	}
}


?>
Commit	Line	Data
b42b2bf9 H	1	#!/usr/local/bin/php
	2	<?php
	3	require('../config/config.inc');
	4	//connecting to database and creating universal $db object
	5	require(SYSTEM_ROOT.'/inc/log.inc');
	6	require(SYSTEM_ROOT.'/inc/database.inc');
	7	require(SYSTEM_ROOT.'/inc/nodes.inc');
	8	$db=new CLASS_DATABASE();
	9
	10	$set=$db->query("select node_id from nodes where node_type='13'");
	11
	12	while ($set->next()) {
	13	$id=$set->getString('node_id');
	14	if (is_numeric($id)) {
	15	$q="delete from node_content where node_id='$id'";
	16	$db->query($q);
	17	$q="delete from nodes where node_id='$id'";
	18	$db->query($q);
	19	}
	20	}
	21
	22
	23
	24
	25
	26	?>