cron/swish_generator.php

   1 #!/usr/local/bin/php
   2 <?php
   3 /*
   4  * Script that XXX
   5  * Called XXX
   6  */
   7
   8 //error_reporting(0);
   9
  10 // Use relative address of config file
  11 // Change this, if you move you cron directory.
  12 $dir=substr(__FILE__, 0, strrpos(__FILE__, '/'));
  13 require($dir.'/../wwwroot/config/config.inc');
  14
  15 //connecting to database and creating universal $db object
  16 require(INCLUDE_DIR.'/log.inc');
  17 require(INCLUDE_DIR.'/database.inc');
  18 require(INCLUDE_DIR.'/nodes.inc');
  19 $db=new CLASS_DATABASE();
  20
  21 $set=$db->query("select nodes.*,node_content from nodes
  22                 left join node_content on node_content.node_id=nodes.node_id
  23                 where node_system_access='public' and
  24                 date(node_created)<=current_date()-interval 1 day and
  25                 (nodes.k>0 or nodes.node_views>0)");
  26 while ($set->next()) {
  27         $node_id=$set->getString('node_id');
  28         $node_content=$set->getString('node_content');
  29         $node_name=$set->getString('node_name');
  30         $node_views=$set->getString('node_views');
  31         $node_creator=$set->getString('node_creator');
  32         $template_id=$set->getString('template_id');
  33         $k=$set->getString('k');
  34         $string.="<node_views>$node_views</node_views>\n";
  35         $string.="<node_creator>$node_views</node_creator>\n";
  36         $string.="<k>$k</k>\n<template_id>$template_id</template_id>\n";
  37         $string.="<node_id>$node_id</node_id>\n<node_name>$node_name</node_name>\n";
  38         $string.="<node_content>$node_content</node_content>\n";
  39         $header="Path-Name: $node_id\n";
  40         $header.="Content-Length: ".strlen($string);
  41         echo $header."\n\n".$string;
  42 }
  43 echo EOF;
  44
  45 ?>
  46