function aup_moduddemailboxtime($uddtimezone = 0)
{
$uddmosConfig_offset = uddeIMgetOffset();
$uddrightnow = time() + ($uddmosConfig_offset + $uddtimezone) * 3600;
return $uddrightnow;
}
function uddeIMshowMCP($option, $task, $act, $config) {
$mosConfig_offset = uddeIMgetOffset();
$database = uddeIMgetDatabase();
$version = uddeIMgetVersion();
$emnid = intval( uddeIMmosGetParam( $_POST, 'id', '' ) );
uddeIMaddScript(uddeIMgetPath('live_site')."/components/com_uddeim/js/uddeimtools.js");
switch($act) {
case "delete": uddeIMdeleteOneMessage($option, $task, $act, $emnid, $config); break;
case "deliver": uddeIMdeleteOneMessage($option, $task, $act, $emnid, $config); break;
}
// get parameter from filter
$f_param = array();
$f_where = array();
$f_param[0] = uddeIMmosGetParam($_POST, 'f_username', '');
if($f_param[0]!="") $f_where[] = "ufrom.username LIKE '$f_param[0]%'";
$f_param[1] = uddeIMmosGetParam($_POST, 'f_name', '');
if($f_param[1]!="") $f_where[] = "ufrom.name LIKE '$f_param[1]%'";
$limit = intval( uddeIMmosGetParam( $_POST, 'limit', 10 ) );
$limitstart = intval( uddeIMmosGetParam( $_POST, 'limitstart', 0 ) );
$where = count($f_where) ? " WHERE `delayed`<>0 " . implode(' AND ', $f_where) : " WHERE `delayed`<>0";
$sql = "SELECT count(id) FROM #__uddeim".$where;
$database->setQuery($sql);
$total = (int)$database->loadResult();
if ($limit==0) {
$limit = $total;
$limitstart = 0;
}
if ($limitstart>=$total)
$limitstart = 0;
// echo($sql." ==> ".$total."<br />");
$sql = "SELECT a.totrash AS trashinbox, a.totrashoutbox AS trashoutbox, a.*, ufrom.name AS fromname,
uto.name AS toname,
ufrom.username AS fromusername,
uto.username AS tousername,
ufrom.id AS fromid,
uto.id AS toid
FROM ((#__uddeim AS a LEFT JOIN #__users AS ufrom ON a.fromid = ufrom.id)
LEFT JOIN #__users AS uto ON a.toid = uto.id)";
$sql .= $where;
$sql .= " ORDER BY a.id DESC LIMIT $limitstart,$limit";
$database->setQuery($sql);
$rows = $database->loadObjectList();
// echo($sql."<br />");
// include_once(uddeIMgetPath('absolute_path')."/administrator/includes/pageNavigation.php");
$pageNav = new uddeIMmosPageNav( $total, $limitstart, $limit );
$query="SELECT username,name FROM #__users WHERE block!='1' ORDER BY username";
$database->setQuery($query);
$results = $database->loadObjectList();
$results = array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z");
$the_username='******';
if ($f_param[0]=="") $the_username.=' selected';
$the_username.='>'._UDDEADM_USERSET_SELUSERNAME.'</option>';
foreach($results as $result) {
$the_username.='<option value="'.$result.'"';
if ($result==$f_param[0]) $the_username.=' selected';
$the_username.='>'.$result.'...</option>';
}
$the_username.="</select>";
$the_name='<select id="f_name" class="text" name="f_name" size="1"><option value=""';
if ($f_param[1]=="") $the_name.=' selected';
$the_name.='>'._UDDEADM_USERSET_SELNAME.'</option>';
foreach($results as $result) {
$the_name.='<option value="'.$result.'"';
if ($result==$f_param[1]) $the_name.=' selected';
$the_name.='>'.$result.'...</option>';
}
$the_name.="</select>";
// <h4><img align="middle" style="display: inline;" src="<?php echo uddeIMgetPath('live_site')."/administrator/images/inbox.png"; " /> <?php echo _UDDEADM_MCP_EDIT; </h4>
?>
<form action="<?php echo uddeIMredirectIndex(); ?>" method="post" name="adminForm" id='adminForm'>
<div align="center">
<table cellpadding="4" cellspacing="0" border="0" width="98%">
<tr>
<td class="sectionname" align="left">
<h4><?php echo _UDDEADM_MCP_EDIT; ?></h4>
</td>
<td class="sectionname" align="right">
<img align="middle" style="display: inline; border:1px solid lightgray;" src="<?php echo uddeIMgetPath('live_site')."/components/com_uddeim/templates/images/uddeim_logo.png"; ?>" />
</td>
</tr>
</table>
</div>
<table cellpadding="4" cellspacing="0" border="0" width="100%" class="adminlist">
<tr>
<td width="100%" align="left"><?php echo $pageNav->writeLimitBox('?option=$option&task=$task'); ?></td>
<td><?php echo $the_username; ?></td>
<td><?php echo $the_name; ?></td>
<td>
<input type="submit" value="<?php echo _UDDEADM_ADMIN_FILTER; ?>" />
</td>
</tr>
</table>
<br />
<table class="adminlist">
<tr>
<th class="title" width="4%"><input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count( $rows ); ?>);" /></th>
<th class="title" width="4%"><?php echo "ID"; ?></th>
<th class="title" width="4%"><?php echo _UDDEADM_MCP_TRASHED; ?></th>
<th class="title" nowrap="nowrap"><?php echo _UDDEADM_MCP_FROM; ?></th>
<th class="title" width="4%"><?php echo _UDDEADM_MCP_TRASHED; ?></th>
<th class="title" nowrap="nowrap"><?php echo _UDDEADM_MCP_TO; ?></th>
<th class="title"><?php echo _UDDEADM_MCP_DELIVER; ?></th>
<th class="title"><?php echo _UDDEADM_MCP_DELETE; ?></th>
<th class="title" nowrap="nowrap"><?php echo _UDDEADM_MCP_DATE; ?></th>
</tr>
<?php
$k = 0;
for($i=0, $n=count( $rows ); $i < $n; $i++)
{
$row = &$rows[$i];
echo "<tr class='row$k'>";
echo "<td width='5%'><input type='checkbox' id='cb$i' name='uddeid[]' value='$row->id' onclick='isChecked(this.checked);' /></td>";
echo "<td align='left'>$row->id</td>";
echo "<td align='left'>";
echo uddeIMshowValueNULL($row->trashoutbox);
echo "</td>";
echo "<td align='left'>";
if ($row->fromid)
echo "Public: $row->fromname ($row->fromusername)";
else
echo "$row->publicname ($row->publicemail)";
echo "</td>";
echo "<td align='left'>";
echo uddeIMshowValueNULL($row->trashinbox);
echo "</td>";
echo "<td align='left'>";
echo "$row->toname ($row->tousername)";
echo "</td>";
echo "<td align='left'>";
if ($row->delayed) {
echo "<a href='#' onclick='document.adminForm.act.value=\"deliver\"; document.adminForm.id.value=\"".$row->id."\"; if (confirm(\""._UDDEADM_MCP_NOTEDELIVER."\")) document.adminForm.submit(); return false;'>";
uddeIMshowTick(true,false); // show tick, opaque (false)
echo "</a>";
} else {
uddeIMshowTick(false,true); // show cross, opaque (false)
}
echo "</td>";
echo "<td align='left'>";
if (is_null($row->trashoutbox) && is_null($row->trashinbox)) {
// message already deleted
} else {
echo "<a href='#' onclick='document.adminForm.act.value=\"delete\"; document.adminForm.id.value=\"".$row->id."\"; if (confirm(\""._UDDEADM_MCP_NOTEDEL."\")) document.adminForm.submit(); return false;'>";
uddeIMshowTick(false,($row->trashoutbox && $row->trashinbox)); // show cross, not opaque (opaque, wenn beide true)
echo "</a>";
}
echo "</td>";
echo "<td align='left'>";
echo date("Y-m-d H:i:s", $row->datum + (3600*uddeIMgetUserTZ()));
echo "</td>";
echo "</tr>\n";
echo "<tr class='row$k'>";
echo "<td align='left'></td>";
echo "<td align='left'></td>";
echo "<td align='left' colspan='7'>";
echo "<div style='text-align:right;'><a href='javascript:uddeIMtoggleLayer(\"".$i."\");'>"._UDDEADM_MCP_SHOWHIDE."</a></div>";
echo "<div id='uddeimdivlayer_".$i."' style='display:none;'>";
// $dm = uddeIMdecrypt($row->message, "", $row->cryptmode);
$dm = uddeIMgetMessage($row->message, "", $row->cryptmode, $row->crypthash, $config->cryptkey);
echo $dm;
echo "</div>";
echo "</td>";
echo "</tr>\n";
$k = 1 - $k;
}
?>
<tr>
<th align="center" colspan="9"><?php echo $pageNav->writePagesLinks(); ?></th>
</tr>
<tr>
<td align="center" colspan="9"><?php echo $pageNav->writePagesCounter(); ?></td>
</tr>
</table>
<input type="hidden" name="option" value="<?php echo $option;?>" />
<input type="hidden" name="task" value="<?php echo $task;?>" />
<input type="hidden" name="act" value="" />
<input type="hidden" name="id" value="" />
<input type="hidden" name="boxchecked" value="0" />
<input type="hidden" name="hidemainmenu" value="0" />
<?php
if ($version->PRODUCT == "Joomla!" || $version->PRODUCT == "Accessible Joomla!")
if (strncasecmp($version->RELEASE, "1.0", 3)) {
echo "<input type=\"hidden\" name=\"limitstart\" value=\"".(int)$limitstart."\" />";
}
?>
</form>
<?php
}
