X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;f=cron%2Fswish_generator.php;h=d28f2666dd91508e04b6e2c9688f24871ca7da87;hb=f657368b72f62699e51cb6b7efeb9e0b30f02f67;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');