Kyberia v2.3 - 1st revision from SVN (Without patches of kyberia.sk team)

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

diff --git a/cron/swish_generator.php b/cron/swish_generator.php
new file mode 100755 (executable)
index 0000000..ed69812
--- /dev/null
+++ b/cron/swish_generator.php
@@ -0,0 +1,34 @@
+#!/usr/local/bin/php
+<?php
+error_reporting(0);
+//requiring main config file with path/database etc. constants
+require('/storage/system/www-docroot/kyberia.sk/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 nodes.*,node_content from nodes left join node_content on node_content.node_id=nodes.node_id where node_system_access='public' and date(node_created)<=current_date()-interval 1 day and (nodes.k>0 or nodes.node_views>0)");
+while ($set->next()) {
+       $node_id=$set->getString('node_id');
+       $node_content=$set->getString('node_content');
+       $node_name=$set->getString('node_name');
+       $node_views=$set->getString('node_views');
+       $node_creator=$set->getString('node_creator');
+       $template_id=$set->getString('template_id');
+       $k=$set->getString('k');
+       $string.="<node_views>$node_views</node_views>\n";
+       $string.="<node_creator>$node_views</node_creator>\n";
+       $string.="<k>$k</k>\n<template_id>$template_id</template_id>\n";
+       $string.="<node_id>$node_id</node_id>\n<node_name>$node_name</node_name>\n";
+       $string.="<node_content>$node_content</node_content>\n";
+       $header="Path-Name: $node_id\n";
+       $header.="Content-Length: ".strlen($string);
+       echo $header."\n\n".$string;
+}
+echo EOF;
+
+?>
+