load("announcements");
checkadminpermissions("caneditann");
logadmin();
$fid = intval($mybb->input['fid']);
$aid = intval($mybb->input['aid']);
addacpnav($lang->nav_announcements);
switch($mybb->input['action'])
{
case "add":
addacpnav($lang->nav_add_announcement);
break;
case "delete":
addacpnav($lang->nav_delete_announcement);
break;
}
function getforums($pid="0")
{
global $db, $forumlist, $lang;
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."forums WHERE pid='$pid' ORDER BY disporder ASC");
while($forum = $db->fetch_array($query))
{
$forumlist .= "\n$forum[name]".makelinkcode($lang->add_announcement, "announcements.php?action=add&fid=$forum[fid]");
$annquery = $db->query("SELECT * FROM ".TABLE_PREFIX."announcements WHERE fid='$forum[fid]'");
$numannouncements = $db->num_rows($annquery);
if($numannouncements != "0")
{
$forumlist .= "";
while($announcement = $db->fetch_array($annquery))
{
$announcement['subject'] = stripslashes($announcement['subject']);
$forumlist .= "- $announcement[subject]".
makelinkcode($lang->edit_announcement, "announcements.php?action=edit&aid=$announcement[aid]").
makelinkcode($lang->delete_announcement, "announcements.php?action=delete&aid=$announcement[aid]")."
\n";
}
$forumlist .= "
\n";
}
$forumlist .= "\n";
getforums($forum['fid']);
$forumlist .= "
\n";
$forumlist .= "\n";
}
return $forumlist;
}
if($mybb->input['action'] == "do_add")
{
$message = addslashes($mybb->input['message']);
$subject = addslashes($mybb->input['subject']);
$startdateampm = $mybb->input['startdateampm'];
$startdatehour = intval($mybb->input['startdatehour']);
$enddateampm = $mybb->input['enddateampm'];
$enddatehour = intval($mybb->input['enddatehour']);
if($startdateampm == "pm")
{
$startdatehour = 12+$startdatehour;
if($startdatehour >= 24)
{
$startdatehour = "00";
}
}
if($enddateampm == "pm")
{
$enddatehour = 12+$enddatehour;
if($enddatehour >= 24)
{
$enddatehour = "00";
}
}
$startdate = gmmktime($startdatehour, intval($mybb->input['startdatemin']), 0, intval($mybb->input['startdatemonth']), intval($mybb->input['startdateday']), intval($mybb->input['startdateyear']));
$enddate = gmmktime($enddatehour, intval($mybb->input['enddatemin']), 0, intval($mybb->input['enddatemonth']), intval($mybb->input['enddateday']), intval($mybb->input['enddateyear']));
$sqlarray = array(
"fid" => $fid,
"uid" => $mybbadmin['uid'],
"subject" => $subject,
"message" => $message,
"startdate" => $startdate,
"enddate" => $enddate,
"allowhtml" => addslashes($mybb->input['allowhtml']),
"allowmycode" => addslashes($mybb->input['allowmycode']),
"allowsmilies" => addslashes($mybb->input['allowsmilies']),
);
$db->insert_query(TABLE_PREFIX."announcements", $sqlarray);
cpredirect("announcements.php", $lang->announcement_added);
}
if($mybb->input['action'] == "do_delete")
{
if($deletesubmit)
{
$db->query("DELETE FROM ".TABLE_PREFIX."announcements WHERE aid='$aid'");
cpredirect("announcements.php", $lang->announcement_deleted);
}
else
{
$mybb->input['action'] = "modify";
}
}
if($mybb->input['action'] == "do_edit")
{
$message = addslashes($mybb->input['message']);
$subject = addslashes($mybb->input['subject']);
$startdateampm = $mybb->input['startdateampm'];
$startdatehour = intval($mybb->input['startdatehour']);
$enddateampm = $mybb->input['enddateampm'];
$enddatehour = intval($mybb->input['enddatehour']);
if($startdateampm == "pm")
{
$startdatehour = 12+$startdatehour;
if($startdatehour >= 24)
{
$startdatehour = "00";
}
}
if($enddateampm == "pm")
{
$enddatehour = 12+$enddatehour;
if($enddatehour >= 24)
{
$enddatehour = "00";
}
}
$startdate = gmmktime($startdatehour, intval($mybb->input['startdatemin']), 0, intval($mybb->input['startdatemonth']), intval($mybb->input['startdateday']), intval($mybb->input['startdateyear']));
$enddate = gmmktime($enddatehour, intval($mybb->input['enddatemin']), 0, intval($mybb->input['enddatemonth']), intval($mybb->input['enddateday']), intval($mybb->input['enddateyear']));
$sqlarray = array(
"aid" => intval($mybb->input['aid']),
"fid" => $fid,
"uid" => $mybbadmin['uid'],
"subject" => $subject,
"message" => $message,
"startdate" => $startdate,
"enddate" => $enddate,
"allowhtml" => addslashes($mybb->input['allowhtml']),
"allowmycode" => addslashes($mybb->input['allowmycode']),
"allowsmilies" => addslashes($mybb->input['allowsmilies']),
);
$db->update_query(TABLE_PREFIX."announcements", $sqlarray, "aid='$aid'");
cpredirect("announcements.php", $lang->announcement_edited);
}
if($mybb->input['action'] == "add") {
cpheader();
startform("announcements.php", "" , "do_add");
starttable();
tableheader($lang->add_announcement2);
makeinputcode($lang->subject, "subject");
$hourmin = explode("-", gmdate("g-i-a", time()));
for($h=1;$h<=12;$h++)
{
if($hourmin[0] == $h)
{
$startdatehour .= "";
$enddatehour .= "";
}
else
{
$startdatehour .= "";
$enddatehour .= "";
}
}
if($hourmin[2] == "am")
{
$amsel = "selected";
}
else
{
$pmsel = "selected";
}
for($m=0;$m<=59;$m++)
{
if(!$m)
{ // 00
$m = "00";
}
if(strlen($m) == 1)
{
$m = "0".$m;
}
if($hourmin[1] == $m)
{
$startdatemin .= "";
$enddatemin .= "";
}
else
{
$startdatemin .= "";
$enddatemin .= "";
}
}
$day = gmdate("j", time());
for($i=1;$i<=31;$i++)
{
if($day == $i)
{
$startdateday .= "\n";
$enddateday .= "\n";
}
else
{
$startdateday .= "\n";
$enddateday .= "\n";
}
}
$month = gmdate("m", time());
$monthsel[$month] = "selected";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdateyear = gmdate("Y", time());
$enddateyear = gmdate("Y", time()) + 1;
makelabelcode($lang->start_date, "\n \n\n \n\n \n\n \n\n \n (GMT)\n");
makelabelcode($lang->end_date, "\n \n\n \n\n \n\n \n\n \n (GMT)\n");
maketextareacode($lang->announcement, "message", "", "10", "50");
makeyesnocode($lang->allow_html, "allowhtml", "yes");
makeyesnocode($lang->allow_mycode, "allowmycode", "yes");
makeyesnocode($lang->allow_smilies, "allowsmilies", "yes");
makelabelcode($lang->parent_forum, forumselect("fid", $fid, "", "", "0", $lang->global_to_all));
endtable();
endform($lang->add_announcement2, $lang->reset_button);
cpfooter();
}
if($mybb->input['action'] == "delete")
{
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."announcements WHERE aid='$aid'");
$announcement = $db->fetch_array($query);
$announcement['subject'] = stripslashes($announcement['subject']);
cpheader();
startform("announcements.php", "", "do_delete");
makehiddencode("aid", $aid);
starttable();
$lang->delete_announcement2 = sprintf($lang->delete_announcement2, $announcement['subject']);
$lang->delete_announcement_confirm = sprintf($lang->delete_announcement_confirm, $announcement['subject']);
tableheader($lang->delete_announcement2, "", 1);
$yes = makebuttoncode("deletesubmit", $lang->yes);
$no = makebuttoncode("no", $lang->no);
makelabelcode("$lang->delete_announcement_confirm
$yes$no", "");
endtable();
endform();
cpfooter();
}
if($mybb->input['action'] == "edit")
{
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."announcements WHERE aid='$aid'");
$announcement = $db->fetch_array($query);
$announcement['subject'] = stripslashes($announcement['subject']);
$announcement['message'] = stripslashes($announcement['message']);
$lang->nav_edit_announcement = sprintf($lang->nav_edit_announcement, $announcement['subject']);
addacpnav($lang->nav_edit_announcement);
if(!$noheader)
{
cpheader();
}
startform("announcements.php", "" , "do_edit");
makehiddencode("aid", "$aid");
starttable();
$lang->edit_announcement2 = sprintf($lang->edit_announcement2, $announcement['subject']);
tableheader($lang->edit_announcement2);
makeinputcode($lang->subject, "subject", "$announcement[subject]");
$startdate = explode("-", gmdate("j-m-Y-g-i-a", $announcement['startdate']));
$enddate = explode("-", gmdate("j-m-Y-g-i-a", $announcement['enddate']));
for($h=1;$h<=12;$h++)
{
if($startdate[3] == $h)
{
$startdatehour .= "";
}
else
{
$startdatehour .= "";
}
if($enddate[3] == $h)
{
$enddatehour .= "";
}
else
{
$enddatehour .= "";
}
}
if($startdate[5] == "am")
{
$samsel = "selected";
}
else
{
$spmsel = "selected";
}
if($enddate[5] == "am")
{
$eamsel = "selected";
}
else
{
$epmsel = "selected";
}
for($m=0;$m<=59;$m++)
{
if(!$m)
{ // 00
$m = "00";
}
if(strlen($m) == 1)
{
$m = "0".$m;
}
if($startdate[4] == $m)
{
$startdatemin .= "";
}
else
{
$startdatemin .= "";
}
if($enddate[4] == $m)
{
$enddatemin .= "";
}
else
{
$enddatemin .= "";
}
}
for($i=1;$i<=31;$i++)
{
if($startdate[0] == $i)
{
$startdateday .= "\n";
}
else
{
$startdateday .= "\n";
}
if($enddate[0] == $i)
{
$enddateday .= "\n";
}
else
{
$enddateday .= "\n";
}
}
$startmonthsel[$startdate[1]] = "selected";
$endmonthsel[$enddate[1]] = "selected";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
$startdatemonth .= "\n";
$enddatemonth .= "\n";
makelabelcode($lang->start_date, "\n \n\n \n\n \n\n \n\n \n (GMT)\n");
makelabelcode($lang->end_date, "\n \n\n \n\n \n\n \n\n \n (GMT)\n");
maketextareacode($lang->announcement, "message", "$announcement[message]", "10", "50");
makeyesnocode($lang->allow_html, "allowhtml", "$announcement[allowhtml]");
makeyesnocode($lang->allow_mycode, "allowmycode", "$announcement[allowmycode]");
makeyesnocode($lang->allow_smilies, "allowsmilies", "$announcement[allowsmilies]");
makelabelcode($lang->parent_forum, forumselect("fid", $announcement['fid'], "", "", "0", $lang->global_to_all));
endtable();
endform($lang->update_announcement, $lang->reset_button);
cpfooter();
}
if($mybb->input['action'] == "modify" || $mybb->input['action'] == "")
{
if(!$noheader)
{
cpheader();
}
starttable();
tableheader($lang->forum_announcements);
$forumlist = getforums();
$globallist = "\n$lang->global_announcements".makelinkcode($lang->add_announcement, "announcements.php?action=add&fid=-1")."\n";
$query = $db->query("SELECT * FROM ".TABLE_PREFIX."announcements WHERE fid='-1'");
while($globannouncement = $db->fetch_array($query))
{
$globallist .= "- $globannouncement[subject]".
makelinkcode($lang->edit_announcement, "announcements.php?action=edit&aid=$globannouncement[aid]").
makelinkcode($lang->delete_announcement, "announcements.php?action=delete&aid=$globannouncement[aid]")."
\n";
}
$globallist .= "
\n";
makelabelcode($lang->edit_delete_notice."
", "");
endtable();
cpfooter();
}
?>