X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;ds=sidebyside;f=cron%2Fswish_generator.php;h=d28f2666dd91508e04b6e2c9688f24871ca7da87;hb=202718bca35eeaf186bb5cfc412731b25aa04c8f;hp=ed6981224360bd66716aa97ec86ebb51a460cc0f;hpb=b42b2bf946332ad8544d53f610be9cb05e80bf56;p=mirrors%2FKyberia-bloodline.git diff --git a/cron/swish_generator.php b/cron/swish_generator.php index ed69812..d28f266 100755 --- a/cron/swish_generator.php +++ b/cron/swish_generator.php @@ -1,16 +1,28 @@ #!/usr/local/bin/php 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)"); +$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');