Re: 未来投稿日時の指定時　各ブロック表示について

334
335
336
337
338
339
340

    $sql = "SELECT d.uid, d.bid, d.cid, d.create_time, d.openarea,             c.cid, c.openarea AS openareacat             FROM ".$db->prefix($this->mydirname.'_diary')." d             LEFT JOIN ".$db->prefix($this->mydirname.'_category')." c ".$on_uid."             LEFT JOIN ".$db->prefix($this->mydirname.'_config')." cfg ON d.uid=cfg.uid             WHERE ".$whr_uid." AND ".$whr_openarea."             AND create_time>='".$start."' AND create_time<'".$end."'";

334
335
336
337
338
339
340
341
342
343
344
345

    $now = date("Y-m-d H:i:s");    if ($this->mPerm->isadmin!=true and $this->mPerm->isauthor!=true) {        $whr_nofuture = " AND d.create_time<'".$now."' ";    } else { $whr_nofuture = ""; }     $sql = "SELECT d.uid, d.bid, d.cid, d.create_time, d.openarea,             c.cid, c.openarea AS openareacat             FROM ".$db->prefix($this->mydirname.'_diary')." d             LEFT JOIN ".$db->prefix($this->mydirname.'_category')." c ".$on_uid."             LEFT JOIN ".$db->prefix($this->mydirname.'_config')." cfg ON d.uid=cfg.uid             WHERE ".$whr_uid." AND ".$whr_openarea.$whr_nofuture."             AND create_time>='".$start."' AND create_time<'".$end."'";