plugins/monthly/bulletin.php 1 location
|
@@ 58-81 (lines=24) @@
|
| 55 |
|
. $db->prefix('bulletin_stories') |
| 56 |
|
. " WHERE ($whr_topic) AND published < UNIX_TIMESTAMP() AND published >= $range_start_s AND published < $range_end_s AND (expired = 0 OR expired > '$now')"); |
| 57 |
|
|
| 58 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 59 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 60 |
|
if (date('n', $user_time) != $this->month) { |
| 61 |
|
continue; |
| 62 |
|
} |
| 63 |
|
$target_date = date('j', $user_time); |
| 64 |
|
$tmp_array = array( |
| 65 |
|
'dotgif' => $plugin['dotgif'], |
| 66 |
|
'dirname' => $plugin['dirname'], |
| 67 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/article.php?storyid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 68 |
|
'id' => $id, |
| 69 |
|
'server_time' => $server_time, |
| 70 |
|
'user_time' => $user_time, |
| 71 |
|
'name' => 'storyid', |
| 72 |
|
'title' => $myts->htmlSpecialChars($title) |
| 73 |
|
); |
| 74 |
|
if ($just1gif) { |
| 75 |
|
// just 1 gif per a plugin & per a day |
| 76 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 77 |
|
} else { |
| 78 |
|
// multiple gifs allowed per a plugin & per a day |
| 79 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 80 |
|
} |
| 81 |
|
} |
| 82 |
|
|
plugins/monthly/eguide.php 1 location
|
@@ 45-68 (lines=24) @@
|
| 42 |
|
// query |
| 43 |
|
$result = $db->query('SELECT title,eid,edate FROM ' . $db->prefix('eguide') . " WHERE edate >= $range_start_s AND edate < $range_end_s AND expire > '$now'"); |
| 44 |
|
|
| 45 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 46 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 47 |
|
if (date('n', $user_time) != $this->month) { |
| 48 |
|
continue; |
| 49 |
|
} |
| 50 |
|
$target_date = date('j', $user_time); |
| 51 |
|
$tmp_array = array( |
| 52 |
|
'dotgif' => $plugin['dotgif'], |
| 53 |
|
'dirname' => $plugin['dirname'], |
| 54 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/event.php?eid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 55 |
|
'id' => $id, |
| 56 |
|
'server_time' => $server_time, |
| 57 |
|
'user_time' => $user_time, |
| 58 |
|
'name' => 'eid', |
| 59 |
|
'title' => $myts->htmlSpecialChars($title) |
| 60 |
|
); |
| 61 |
|
if ($just1gif) { |
| 62 |
|
// just 1 gif per a plugin & per a day |
| 63 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 64 |
|
} else { |
| 65 |
|
// multiple gifs allowed per a plugin & per a day |
| 66 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 67 |
|
} |
| 68 |
|
} |
| 69 |
|
|
plugins/monthly/myalbum-p-photos.php 1 location
|
@@ 62-85 (lines=24) @@
|
| 59 |
|
// query (added 86400 second margin "begin" & "end") |
| 60 |
|
$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"); |
| 61 |
|
|
| 62 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 63 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 64 |
|
if (date('n', $user_time) != $this->month) { |
| 65 |
|
continue; |
| 66 |
|
} |
| 67 |
|
$target_date = date('j', $user_time); |
| 68 |
|
$tmp_array = array( |
| 69 |
|
'dotgif' => $plugin['dotgif'], |
| 70 |
|
'dirname' => $plugin['dirname'], |
| 71 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/photo.php?lid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 72 |
|
'id' => $id, |
| 73 |
|
'server_time' => $server_time, |
| 74 |
|
'user_time' => $user_time, |
| 75 |
|
'name' => 'lid', |
| 76 |
|
'title' => $myts->htmlSpecialChars($title) |
| 77 |
|
); |
| 78 |
|
if ($just1gif) { |
| 79 |
|
// just 1 gif per a plugin & per a day |
| 80 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 81 |
|
} else { |
| 82 |
|
// multiple gifs allowed per a plugin & per a day |
| 83 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 84 |
|
} |
| 85 |
|
} |
| 86 |
|
|
plugins/monthly/mydownloads.php 1 location
|
@@ 47-70 (lines=24) @@
|
| 44 |
|
// query (added 86400 second margin "begin" & "end") |
| 45 |
|
$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"); |
| 46 |
|
|
| 47 |
|
while (list($title, $id, $server_time, $cid) = $db->fetchRow($result)) { |
| 48 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 49 |
|
if (date('n', $user_time) != $this->month) { |
| 50 |
|
continue; |
| 51 |
|
} |
| 52 |
|
$target_date = date('j', $user_time); |
| 53 |
|
$tmp_array = array( |
| 54 |
|
'dotgif' => $plugin['dotgif'], |
| 55 |
|
'dirname' => $plugin['dirname'], |
| 56 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/singlefile.php?lid=$id&cid=$cid&caldate={$this->year}-{$this->month}-$target_date", |
| 57 |
|
'id' => $id, |
| 58 |
|
'server_time' => $server_time, |
| 59 |
|
'user_time' => $user_time, |
| 60 |
|
'name' => 'lid', |
| 61 |
|
'title' => $myts->htmlSpecialChars($title) |
| 62 |
|
); |
| 63 |
|
if ($just1gif) { |
| 64 |
|
// just 1 gif per a plugin & per a day |
| 65 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 66 |
|
} else { |
| 67 |
|
// multiple gifs allowed per a plugin & per a day |
| 68 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 69 |
|
} |
| 70 |
|
} |
| 71 |
|
|
plugins/monthly/mylinks.php 1 location
|
@@ 47-70 (lines=24) @@
|
| 44 |
|
// query (added 86400 second margin "begin" & "end") |
| 45 |
|
$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"); |
| 46 |
|
|
| 47 |
|
while (list($title, $id, $server_time, $cid) = $db->fetchRow($result)) { |
| 48 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 49 |
|
if (date('n', $user_time) != $this->month) { |
| 50 |
|
continue; |
| 51 |
|
} |
| 52 |
|
$target_date = date('j', $user_time); |
| 53 |
|
$tmp_array = array( |
| 54 |
|
'dotgif' => $plugin['dotgif'], |
| 55 |
|
'dirname' => $plugin['dirname'], |
| 56 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/singlelink.php?lid=$id&cid=$cid&caldate={$this->year}-{$this->month}-$target_date", |
| 57 |
|
'id' => $id, |
| 58 |
|
'server_time' => $server_time, |
| 59 |
|
'user_time' => $user_time, |
| 60 |
|
'name' => 'lid', |
| 61 |
|
'title' => $myts->htmlSpecialChars($title) |
| 62 |
|
); |
| 63 |
|
if ($just1gif) { |
| 64 |
|
// just 1 gif per a plugin & per a day |
| 65 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 66 |
|
} else { |
| 67 |
|
// multiple gifs allowed per a plugin & per a day |
| 68 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 69 |
|
} |
| 70 |
|
} |
| 71 |
|
|
plugins/monthly/news.php 1 location
|
@@ 58-81 (lines=24) @@
|
| 55 |
|
. $db->prefix('stories') |
| 56 |
|
. " WHERE ($whr_topic) AND published < UNIX_TIMESTAMP() AND published >= $range_start_s AND published < $range_end_s AND (expired = 0 OR expired > '$now')"); |
| 57 |
|
|
| 58 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 59 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 60 |
|
if (date('n', $user_time) != $this->month) { |
| 61 |
|
continue; |
| 62 |
|
} |
| 63 |
|
$target_date = date('j', $user_time); |
| 64 |
|
$tmp_array = array( |
| 65 |
|
'dotgif' => $plugin['dotgif'], |
| 66 |
|
'dirname' => $plugin['dirname'], |
| 67 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/article.php?storyid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 68 |
|
'id' => $id, |
| 69 |
|
'server_time' => $server_time, |
| 70 |
|
'user_time' => $user_time, |
| 71 |
|
'name' => 'storyid', |
| 72 |
|
'title' => $myts->htmlSpecialChars($title) |
| 73 |
|
); |
| 74 |
|
if ($just1gif) { |
| 75 |
|
// just 1 gif per a plugin & per a day |
| 76 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 77 |
|
} else { |
| 78 |
|
// multiple gifs allowed per a plugin & per a day |
| 79 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 80 |
|
} |
| 81 |
|
} |
| 82 |
|
|
plugins/monthly/plzXoo-answer.php 1 location
|
@@ 49-72 (lines=24) @@
|
| 46 |
|
. $db->prefix('plzxoo_question') |
| 47 |
|
. " q ON a.qid=q.qid WHERE a.input_date >= $range_start_s AND a.input_date < $range_end_s"); |
| 48 |
|
|
| 49 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 50 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 51 |
|
if (date('n', $user_time) != $this->month) { |
| 52 |
|
continue; |
| 53 |
|
} |
| 54 |
|
$target_date = date('j', $user_time); |
| 55 |
|
$tmp_array = array( |
| 56 |
|
'dotgif' => $plugin['dotgif'], |
| 57 |
|
'dirname' => $plugin['dirname'], |
| 58 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/index.php?action=detail&qid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 59 |
|
'id' => $id, |
| 60 |
|
'server_time' => $server_time, |
| 61 |
|
'user_time' => $user_time, |
| 62 |
|
'name' => 'qid', |
| 63 |
|
'title' => $myts->htmlSpecialChars($title) |
| 64 |
|
); |
| 65 |
|
if ($just1gif) { |
| 66 |
|
// just 1 gif per a plugin & per a day |
| 67 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 68 |
|
} else { |
| 69 |
|
// multiple gifs allowed per a plugin & per a day |
| 70 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 71 |
|
} |
| 72 |
|
} |
| 73 |
|
|
plugins/monthly/plzXoo-question.php 1 location
|
@@ 45-68 (lines=24) @@
|
| 42 |
|
// query |
| 43 |
|
$result = $db->query('SELECT subject,qid,input_date FROM ' . $db->prefix('plzxoo_question') . " WHERE input_date >= $range_start_s AND input_date < $range_end_s"); |
| 44 |
|
|
| 45 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 46 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 47 |
|
if (date('n', $user_time) != $this->month) { |
| 48 |
|
continue; |
| 49 |
|
} |
| 50 |
|
$target_date = date('j', $user_time); |
| 51 |
|
$tmp_array = array( |
| 52 |
|
'dotgif' => $plugin['dotgif'], |
| 53 |
|
'dirname' => $plugin['dirname'], |
| 54 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/index.php?action=detail&qid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 55 |
|
'id' => $id, |
| 56 |
|
'server_time' => $server_time, |
| 57 |
|
'user_time' => $user_time, |
| 58 |
|
'name' => 'qid', |
| 59 |
|
'title' => $myts->htmlSpecialChars($title) |
| 60 |
|
); |
| 61 |
|
if ($just1gif) { |
| 62 |
|
// just 1 gif per a plugin & per a day |
| 63 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 64 |
|
} else { |
| 65 |
|
// multiple gifs allowed per a plugin & per a day |
| 66 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 67 |
|
} |
| 68 |
|
} |
| 69 |
|
|
plugins/monthly/weblinks.php 1 location
|
@@ 47-70 (lines=24) @@
|
| 44 |
|
// query (added 86400 second margin "begin" & "end") |
| 45 |
|
$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"); |
| 46 |
|
|
| 47 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 48 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 49 |
|
if (date('n', $user_time) != $this->month) { |
| 50 |
|
continue; |
| 51 |
|
} |
| 52 |
|
$target_date = date('j', $user_time); |
| 53 |
|
$tmp_array = array( |
| 54 |
|
'dotgif' => $plugin['dotgif'], |
| 55 |
|
'dirname' => $plugin['dirname'], |
| 56 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/singlelink.php?lid=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 57 |
|
'id' => $id, |
| 58 |
|
'server_time' => $server_time, |
| 59 |
|
'user_time' => $user_time, |
| 60 |
|
'name' => 'lid', |
| 61 |
|
'title' => $myts->htmlSpecialChars($title) |
| 62 |
|
); |
| 63 |
|
if ($just1gif) { |
| 64 |
|
// just 1 gif per a plugin & per a day |
| 65 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 66 |
|
} else { |
| 67 |
|
// multiple gifs allowed per a plugin & per a day |
| 68 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 69 |
|
} |
| 70 |
|
} |
| 71 |
|
|
plugins/monthly/wordpress-item.php 1 location
|
@@ 53-76 (lines=24) @@
|
| 50 |
|
. $db->prefix("wp{$mydirnumber}_posts") |
| 51 |
|
. " WHERE UNIX_TIMESTAMP(post_date) >= $range_start_s AND UNIX_TIMESTAMP(post_date) < $range_end_s AND post_status='publish'"); |
| 52 |
|
|
| 53 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 54 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 55 |
|
if (date('n', $user_time) != $this->month) { |
| 56 |
|
continue; |
| 57 |
|
} |
| 58 |
|
$target_date = date('j', $user_time); |
| 59 |
|
$tmp_array = array( |
| 60 |
|
'dotgif' => $plugin['dotgif'], |
| 61 |
|
'dirname' => $plugin['dirname'], |
| 62 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/index.php?p=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 63 |
|
'id' => $id, |
| 64 |
|
'server_time' => $server_time, |
| 65 |
|
'user_time' => $user_time, |
| 66 |
|
'name' => 'p', |
| 67 |
|
'title' => $myts->htmlSpecialChars($title) |
| 68 |
|
); |
| 69 |
|
if ($just1gif) { |
| 70 |
|
// just 1 gif per a plugin & per a day |
| 71 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 72 |
|
} else { |
| 73 |
|
// multiple gifs allowed per a plugin & per a day |
| 74 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 75 |
|
} |
| 76 |
|
} |
| 77 |
|
|
plugins/monthly/yomi.php 1 location
|
@@ 45-68 (lines=24) @@
|
| 42 |
|
// query (added 86400 second margin "begin" & "end") |
| 43 |
|
$result = $db->query('SELECT title,id,`stamp` FROM ' . $db->prefix('yomi_log') . " WHERE `stamp` >= $range_start_s AND `stamp` < $range_end_s"); |
| 44 |
|
|
| 45 |
|
while (list($title, $id, $server_time) = $db->fetchRow($result)) { |
| 46 |
|
$user_time = $server_time + $tzoffset_s2u; |
| 47 |
|
if (date('n', $user_time) != $this->month) { |
| 48 |
|
continue; |
| 49 |
|
} |
| 50 |
|
$target_date = date('j', $user_time); |
| 51 |
|
$tmp_array = array( |
| 52 |
|
'dotgif' => $plugin['dotgif'], |
| 53 |
|
'dirname' => $plugin['dirname'], |
| 54 |
|
'link' => XOOPS_URL . "/modules/{$plugin['dirname']}/single_link.php?item_id=$id&caldate={$this->year}-{$this->month}-$target_date", |
| 55 |
|
'id' => $id, |
| 56 |
|
'server_time' => $server_time, |
| 57 |
|
'user_time' => $user_time, |
| 58 |
|
'name' => 'item_id', |
| 59 |
|
'title' => $myts->htmlSpecialChars($title) |
| 60 |
|
); |
| 61 |
|
if ($just1gif) { |
| 62 |
|
// just 1 gif per a plugin & per a day |
| 63 |
|
$plugin_returns[$target_date][$plugin['dirname']] = $tmp_array; |
| 64 |
|
} else { |
| 65 |
|
// multiple gifs allowed per a plugin & per a day |
| 66 |
|
$plugin_returns[$target_date][] = $tmp_array; |
| 67 |
|
} |
| 68 |
|
} |
| 69 |
|
|