<?PHP

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/news/news.php
Version=120
Updated=2007-mar-01
Type=Plugin
Author=Neocrome
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=mcalendar
Part=index
File=mcalendar.index
Hooks=header.tags
Tags=header.tpl:{INDEX_MCALENDAR}
Minlevel=0
Order=10
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

require("plugins/mcalendar/lang/mcalendar.".$usr['lang'].".lang.php");

$cfg['weekstartsunday'] = FALSE;

$y = sed_import('year','G','INT');
$m = sed_import('month','G','INT');

if ($y=='') { $y = date('Y', $sys['now'] + $usr['timezone'] * 3600); }
if ($m=='') { $m = date('n', $sys['now'] + $usr['timezone'] * 3600); }

$m_next = $m+1;
$m_prev = $m-1;
$y_next = $y;
$y_prev = $y;

if ($m_prev<1)
{
$m_prev = 12;
$y_prev--;
}

if ($m_next>12)
{
$m_next = 1;
$y_next++;
}

$col = 0;
$row = 0;

$firstday=date('w', mktime(0, 0, 0, $m, 1, $y));

if (!$cfg['weekstartsunday'])
{
if ($firstday==0) { $firstday = 7; }
}
else
{ $firstday++; }

$today_d = date('j', $sys['now'] + $usr['timezone'] * 3600);
$today_m = date('n', $sys['now'] + $usr['timezone'] * 3600);
$today_y = date('Y', $sys['now'] + $usr['timezone'] * 3600);
$m_c = date('F', mktime(0,0,0,$m,1,$y));
$m_c_m = ereg_replace($m_c,$L_month[$m_c],$m_c);
$m_c_y = date('Y', mktime(0,0,0,$m,1,$y));
$m_p = date('F', mktime(0,0,0,$m-1,1,$y));
$m_p = ereg_replace($m_p,$L_month[$m_p],$m_p);
$m_p .= date('Y', mktime(0,0,0,$m-1,1,$y));
$m_n = date('F', mktime(0,0,0,$m+1,1,$y));
$m_n = ereg_replace($m_n,$L_month[$m_n],$m_n);
$m_n .= date('Y', mktime(0, 0, 0, $m+1, 1, $y));
$l1 = sed_mktime(0, 0, 0, $m, 1, $y);
$l2 = sed_mktime(0, 0, 0, $m+1, 1, $y);


/* ================== NEWS ================== */
if ($cfg['plugin']['mcalendar']['mc_page_news'] == 'yes')
{
$catsub = str_replace(",", "' OR page_cat = '", $cfg['plugin']['mcalendar']['mc_news_cats']);
$kaan = sed_sql_query("
SELECT p.page_date, u.user_id FROM $db_pages AS p
LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid
WHERE page_date>'$l1' AND page_date<'$l2'
AND page_date<'".$sys['now_offset']."'
AND page_state=0
AND (page_cat = '".$catsub."')
AND page_cat NOT LIKE 'system'
ORDER BY page_date
LIMIT 100");
while ($row = sed_sql_fetcharray($sql)) {
$curr_date = date('j', $row['page_date'] + $usr['timezone'] * 3600);
$days_page_news[$curr_date]++;
}
}

/* ================== PAGES ================== */
if ($cfg['plugin']['mcalendar']['mc_page_page'] == 'yes')
{
$catsub = str_replace(",", "' AND page_cat NOT LIKE '", $cfg['plugin']['mcalendar']['mc_news_cats']);
$kaan = sed_sql_query("
SELECT p.page_date, u.user_id FROM $db_pages AS p
LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid
WHERE page_date>'$l1' AND page_date<'$l2'
AND page_date<'".$sys['now_offset']."'
AND page_state=0
AND page_cat NOT LIKE '".$catsub."'
AND page_cat NOT LIKE 'system'
ORDER BY page_date
LIMIT 100");
while ($row = sed_sql_fetcharray($sql))
{
$curr_date = date('j', $row['page_date'] + $usr['timezone'] * 3600);
$days_page_page[$curr_date]++;
}
}

/* ================== USERS: New registration ================== */
if ($cfg['plugin']['mcalendar']['mc_user_regs'] == 'yes')
{
$kaan = sed_sql_query("
SELECT user_regdate FROM $db_users
WHERE user_regdate>'$l1' AND user_regdate<'$l2'
ORDER BY user_regdate ASC
LIMIT 100");
while ($row = sed_sql_fetcharray($sql))
{
$curr_date = date('j', $row['user_regdate'] + $usr['timezone'] * 3600);
$days_user_regs[$curr_date]++;
}
}

/* ================== USERS: Birthday ================== */
if ($cfg['plugin']['mcalendar']['mc_user_birt'] == 'yes')
{
/* ========== part 1 ========== */
$ll = date("m", $l1);
$kaan = sed_sql_query("
SELECT user_birthdate FROM $db_users
WHERE user_birthdate > 0
AND DATE_FORMAT(FROM_UNIXTIME(user_birthdate), '%m')='$ll'
ORDER BY user_birthdate ASC
LIMIT 100");
while ($row = sed_sql_fetcharray($sql))
{
$curr_date = date('j', $row['user_birthdate'] + $usr['timezone'] * 3600);
$days_user_birt[$curr_date]++;
}

/* ========== part 2 ========== */
// Â ñâÿçè ñ òåì, ÷òî â âåğñèÿõ MySQL 4 è âûøå ñóùåñòâóåò îøèáêà
// http://bugs.mysql.com/bug.php?id=7515 íå ïîçâîëÿşùàÿ êîğğåêòíî îáğàáàòûâàòü
// Unix timestamp äàòû (äàòû ïîçäíåå 1970 ãîäà), êîòîğûå èñïîëüçóåò Seditio,
// ïğèõîäèòñÿ èçâğàùàòñÿ äîïîëíèòåëüíûì êîäîì, ÷òîáû ïëàãèí ó÷èòûâàë äíè ğîæäåíèÿ
// ïîëüçîâàòåëåé êîòîğûå ğîäèëèñü äî 1970ã.
// Â MySQL 3 âñå ğàáîòàåò è áåç ıòîãî íî äëÿ ñîâìåñòèìîñòè îñòàâëÿş ıòîò êîä.

$kaan = sed_sql_query("
SELECT user_birthdate FROM $db_users
WHERE user_birthdate < 0
ORDER BY user_birthdate ASC
LIMIT 100");
while ($row = sed_sql_fetcharray($sql))
{
if (date('m', $row['user_birthdate']) == $ll)
{
$curr_date = date('j', $row['user_birthdate'] + $usr['timezone'] * 3600);
$days_user_birt[$curr_date]++;
}
}
}

/* ================== FORUMS: New topic ================== */
if ($cfg['plugin']['mcalendar']['mc_forums_nt'] == 'yes')
{
$kaan = sed_sql_query("
SELECT ft_creationdate FROM $db_forum_topics
WHERE ft_creationdate>'$l1' AND ft_creationdate<'$l2'
ORDER by ft_creationdate
LIMIT 100");
while ($row = sed_sql_fetcharray($sql))
{
$curr_date = date('j', $row['ft_creationdate'] + $usr['timezone'] * 3600);
$days_forums_nt[$curr_date]++;
}
}

/* ================== DAYS title BEGIN ================== */

for ($i = 1; $i < 32; $i++)
{
if (!empty($days_page_news[$i])) { $days[$i] = $L['mc_news'].": ".$days_page_news[$i]; }
if (!empty($days_page_page[$i]))
{
$days[$i] .= (empty($days[$i])) ? '' : '; ';
$days[$i] .= $L['mc_pages'].": ".$days_page_page[$i];
}
if (!empty($days_user_regs[$i]))
{
$days[$i] .= (empty($days[$i])) ? '' : '; ';
$days[$i] .= $L['mc_users_reg'].": ".$days_user_regs[$i];
}
if (!empty($days_user_birt[$i]))
{
$days[$i] .= (empty($days[$i])) ? '' : '; ';
$days[$i] .= $L['mc_users_bir'].": ".$days_user_birt[$i];
}
if (!empty($days_forums_nt[$i]))
{
$days[$i] .= (empty($days[$i])) ? '' : '; ';
$days[$i] .= $L['mc_forums'].": ".$days_forums_nt[$i];
}
}

/* ================== DAYS title END ==================== */

$shortday = "<tr><td class=\"week\">".$L['mc_d_mo']."</td><td class=\"week\">".$L['mc_d_tu']."</td><td class=\"week\">".$L['mc_d_we']."</td><td class=\"week\">".$L['mc_d_th']."</td><td class=\"week\">".$L['mc_d_fr']."</td><td class=\"week\">".$L['mc_d_sa']."</td><td class=\"week\">".$L['mc_d_su']."</td></tr>";

$plugin_body= "
<!-- Êàëåíäàğü -->
<table class=\"mcalendar\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td class=\"navigation\"><a href=\"index.php?month=$m_prev&amp;year=$y_prev\" title=\"".$L['mc_prevm']."\">$sed_img_left</a></td>
<td class=\"month\" colspan=\"5\">$m_c_m</td>
<td class=\"navigation\"><a href=\"index.php?month=$m_next&amp;year=$y_next\" title=\"".$L['mc_nextm']."\">$sed_img_right</a></td>
</tr>".$shortday."<tr>";

for ($col = 1; $col < $firstday; $col++)
{ $plugin_body .= "<td class=\"field\">&nbsp;</td>"; }

for ($i = 1; $i < 32; $i++)
{
if (checkdate($m,$i,$y))
{
if ($today_d==$i && $today_m==$m && $today_y==$y)
{
$mcss = "today";
}
elseif (sed_mktime(0, 0, 0, $m, $i, $y) > $sys['now'] + $usr['timezone'] * 3600)
{
$mcss = "future";
}
    else
{
$mcss = "field";
}
if (!empty($days[$i]))
{
$ma .= "<a href=\"plug.php?e=mcalendar&amp;day=$i&amp;month=$m&amp;year=$y\" title=\"".$days[$i]."\" target=\"_blank\">";
$sl = $sl."</a>";
}
$plugin_body .= "<td class=\"".$mcss."\">".$ma.$i.$sl."</td>";
unset($mcss, $ma, $sl);

$col++;

if ($col>7)
{
$col=1;
$plugin_body .= "</tr><tr>";
}
}
}
while ($col <> 8 && $col <> 1)
{ $plugin_body .= "<td class=\"field\">&nbsp;</td>"; $col++; }

$plugin_body .= "</tr>".$shortday."<tr>
<td class=\"navigation\"><a href=\"index.php?month=$m&amp;year=".($y-1)."\" title=\"".$L['mc_prevy']."\">$sed_img_left</a></td>
<td class=\"year\" colspan=\"5\">$m_c_y</td>
<td class=\"navigation\"><a href=\"index.php?month=$m&amp;year=".($y+1)."\" title=\"".$L['mc_nexty']."\">$sed_img_right</a></td>
</tr></table>
<!-- Êîíåö: Êàëåíäàğü -->
";
$t-> assign(array("INDEX_MCALENDAR" => $plugin_body));
?>

/* This style only for MCALENDAR plugin BEGIN */
table.mcalendar { border-collapse:collapse; }
.mcalendar table { background-color:#FFFFFF; font-size: 100%; font-family: tahoma; border-collapse:collapse; }
.mcalendar td { background-color: #D4D1E9; border:1px solid #FFFFFF; vertical-align:middle; text-align:center; }
.mcalendar td.field { width: 20px; height:20px; }
.mcalendar td.future { color: #B0B0B0; width: 20px; height:20px; }
.mcalendar td.today { font-weight:bold; color:green; width: 20px; height:20px; }
.mcalendar td.week { color:#5D7BA7; width: 20px; height:15px; }
.mcalendar td.navigation { background-color:#D4E1E9; }
.mcalendar td.month { background-color:#D4E1E9; }
.mcalendar td.year { background-color:#D4E1E9; }
.mcalendar a { color: #0000FF; text-decoration: underline; font-weight:normal; }
.mcalendar a:hover { color: #0000FF; text-decoration: none; font-weight:bolder; }
/* This style only for MCALENDAR plugin END */