XoopsModules25x / apcal

// query (added 86400 second margin "begin" & "end")

$result = $db->query('SELECT title,lid,`date` FROM ' . $db->prefix("myalbum{$mydirnumber}_photos") . " WHERE ($whr_cid) AND `date` >= $range_start_s AND `date` < $range_end_s AND `status` > 0");

while (list($title, $id, $server_time) = $db->fetchRow($result)) {

    $user_time = $server_time + $tzoffset_s2u;

    if (date('j', $user_time) != $this->date) {

        continue;

    }

    $target_date = date('j', $user_time);

    $tmp_array   = array(

        'dotgif'      => $plugin['dotgif'],

        'dirname'     => $plugin['dirname'],

        'link'        => XOOPS_URL . "/modules/{$plugin['dirname']}/photo.php?lid=$id&caldate={$this->year}-{$this->month}-$target_date",

        'id'          => $id,

        'server_time' => $server_time,

        'user_time'   => $user_time,

        'name'        => 'lid',

        'title'       => $myts->htmlSpecialChars($title),

        'description' => ''

    );

    // multiple gifs allowed per a plugin & per a day

    $plugin_returns[$target_date][] = $tmp_array;

}

// query (added 86400 second margin "begin" & "end")

$result = $db->query('SELECT title,lid,`date`,cid FROM ' . $db->prefix('mydownloads_downloads') . " WHERE `date` >= $range_start_s AND `date` < $range_end_s AND `status` > 0");

while (list($title, $id, $server_time, $cid) = $db->fetchRow($result)) {

    $user_time = $server_time + $tzoffset_s2u;

    if (date('j', $user_time) != $this->date) {

        continue;

    }

    $target_date = date('j', $user_time);

    $tmp_array   = array(

        'dotgif'      => $plugin['dotgif'],

        'dirname'     => $plugin['dirname'],

        'link'        => XOOPS_URL . "/modules/{$plugin['dirname']}/singlefile.php?lid=$id&cid=$cid&caldate={$this->year}-{$this->month}-$target_date",

        'id'          => $id,

        'server_time' => $server_time,

        'user_time'   => $user_time,

        'name'        => 'lid',

        'title'       => $myts->htmlSpecialChars($title),

        'description' => ''

    );

    // multiple gifs allowed per a plugin & per a day

    $plugin_returns[$target_date][] = $tmp_array;

}

// query (added 86400 second margin "begin" & "end")

$result = $db->query('SELECT title,lid,`date`,cid FROM ' . $db->prefix('mylinks_links') . " WHERE `date` >= $range_start_s AND `date` < $range_end_s AND `status` > 0");

while (list($title, $id, $server_time, $cid) = $db->fetchRow($result)) {

    $user_time = $server_time + $tzoffset_s2u;

    if (date('j', $user_time) != $this->date) {

        continue;

    }

    $target_date = date('j', $user_time);

    $tmp_array   = array(

        'dotgif'      => $plugin['dotgif'],

        'dirname'     => $plugin['dirname'],

        'link'        => XOOPS_URL . "/modules/{$plugin['dirname']}/singlelink.php?lid=$id&cid=$cid&caldate={$this->year}-{$this->month}-$target_date",

        'id'          => $id,

        'server_time' => $server_time,

        'user_time'   => $user_time,

        'name'        => 'lid',

        'title'       => $myts->htmlSpecialChars($title),

        'description' => ''

    );

    // multiple gifs allowed per a plugin & per a day

    $plugin_returns[$target_date][] = $tmp_array;

}

// query (added 86400 second margin "begin" & "end")

$result = $db->query('SELECT title,lid,`time_update` FROM ' . $db->prefix('weblinks_link') . " WHERE `time_update` >= $range_start_s AND `time_update` < $range_end_s");

while (list($title, $id, $server_time) = $db->fetchRow($result)) {

    $user_time = $server_time + $tzoffset_s2u;

    if (date('j', $user_time) != $this->date) {

        continue;

    }

    $target_date = date('j', $user_time);

    $tmp_array   = array(

        'dotgif'      => $plugin['dotgif'],

        'dirname'     => $plugin['dirname'],

        'link'        => XOOPS_URL . "/modules/{$plugin['dirname']}/singlelink.php?lid=$id&caldate={$this->year}-{$this->month}-$target_date",

        'id'          => $id,

        'server_time' => $server_time,

        'user_time'   => $user_time,

        'name'        => 'lid',

        'title'       => $myts->htmlSpecialChars($title),

        'description' => ''

    );

    // multiple gifs allowed per a plugin & per a day

    $plugin_returns[$target_date][] = $tmp_array;

}

// query (added 86400 second margin "begin" & "end")

$result = $db->query('SELECT title,id,`stamp` FROM ' . $db->prefix('yomi_log') . " WHERE `stamp` >= $range_start_s AND `stamp` < $range_end_s");

while (list($title, $id, $server_time) = $db->fetchRow($result)) {

    $user_time = $server_time + $tzoffset_s2u;

    if (date('j', $user_time) != $this->date) {

        continue;

    }

    $target_date = date('j', $user_time);

    $tmp_array   = array(

        'dotgif'      => $plugin['dotgif'],

        'dirname'     => $plugin['dirname'],

        'link'        => XOOPS_URL . "/modules/{$plugin['dirname']}/single_link.php?item_id=$id&caldate={$this->year}-{$this->month}-$target_date",

        'id'          => $id,

        'server_time' => $server_time,

        'user_time'   => $user_time,

        'name'        => 'item_id',

        'title'       => $myts->htmlSpecialChars($title),

        'description' => ''

    );

    // multiple gifs allowed per a plugin & per a day

    $plugin_returns[$target_date][] = $tmp_array;

}