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