// $password="******";
// //$database="system";
?>
<head>
<title>Inform Communications Intranet</title>
<style media="all" type="text/css">
body { font-size: normal }
h1 { font-size: 140% }
h2 { font-size: 120% }
li h2 { margin: 0px; margin-top: 6px }
</style>
</head>
<body>
<?php
if (agent_ingroup("L")) {
echo '<TD VALIGN=TOP BGCOLOR=#906060>';
mysql_connect("192.168.1.209", $username, $password);
@mysql_select_db("loader07") or die("Unable to select database");
$query = "SELECT service, servsub, servicename, servicestart, serviceend, oldconvert FROM services WHERE serviceend>date_sub(now(), interval 14 day) ORDER BY servicename";
$result = mysql_query($query);
mysql_close();
$num = mysql_numrows($result);
$lastservice = '';
$i = 0;
while ($i < $num) {
//servicestart,
$servicename = mysql_result($result, $i, 'servicename');
$service = mysql_result($result, $i, 'service');
$servsub = mysql_result($result, $i, 'servsub');
$oldconvert = mysql_result($result, $i, 'oldconvert');
require_once '../../../includes/password_gen/password_gen.php';
include '../includes/connect_idb.php';
include '../includes/header.php';
require_once "./techshare.php";
//require_once "../includes/agent_info.php";
//require_once "../includes/agent_banner.php";
$agentdet = agent_info();
$agentinit = $agentdet['agentinit'];
$agentlogin = $agentdet['agentlogin'];
$agentalias = $agentdet['loginalias'];
//mysql_connect(localhost,$username,$password);
//@mysql_select_db('system') or die( "Unable to select database");
//$db_con
#!/usr/bin/php
//echo "HI<br>\n";
$limitclause = agent_ingroup('S') ? '' : " AND agentinit='{$agentinit}'";
$query = "SELECT * FROM agent WHERE (LENGTH(agentlogin)>5 OR LENGTH(loginalias)>5) AND NOW() BETWEEN agentfrom AND agentto {$limitclause} ORDER BY agentname";
//echo $query;
$result = mysqli_query($db_con, $query);
$num = mysqli_num_rows($result);
$lastservice = $lasttitle = '';
echo "<table><tr><th>Name</th><th>Login</th><th>Password</th><th>2014 Password</th></tr>";
for ($i = 0; $i < $num; ++$i) {
$row = mysqli_fetch_array($result);
if (strlen($passname = $row['agentlogin']) < 6) {
$passname = $row['loginalias'];
}
/* if ($lastservice!=$service) {
$lastservice=$service;
//echo '<span class="newshead">'.str_replace("_", " ", date('l, j_F_Y', strtotime($newsdate))).'</span>';
echo "<p><p>{$service}</p></p>";
<ul>
<li><a href="http://192.168.1.209/intranet/techservices/techservices_itr_new.php">New ITR Request</a></li>
</ul>
<p class="bold">Server Uptime</p>
<ul>
<li><a href="http://192.168.9.80/uptime.php">Emperor</a></li>
<li><a href="http://192.168.1.209/uptime.php">Adelie</a></li>
</ul>
<?php
}
?>
</TD>
<?php
if (agent_ingroup("A")) {
?>
<TD VALIGN=TOP BGCOLOR=#906060>
<?php
mysql_connect('192.168.1.209', $username, $password);
@mysql_select_db("system") or die("Unable to select database");
showmessages();
mysql_connect('192.168.1.106', 'liveaccess', 'GreyFlatBox');
@mysql_select_db("system") or die("Unable to select database");
showmessages();
mysql_close();
?>
</TD>
$colourhead = '#AAAAFF';
$colourbody = '#EEEEFF';
break;
case 'C':
$colourhead = '#DDAADD';
$colourbody = '#FFEEFF';
break;
default:
$colourhead = '#AAFFAA';
$colourbody = '#EEFFEE';
break;
}
}
echo "<tr bgcolor={$colourhead}>";
echo "<td>" . mysql_result($result, $i, 'serviceid') . '/' . mysql_result($result, $i, 'servicesub') . '/' . mysql_result($result, $i, 'exportset') . "<br>{$recorduri}</td><td>Call:" . mysql_result($result, $i, 'calltime') . " Load:" . mysql_result($result, $i, 'loadtime') . " Export:" . mysql_result($result, $i, 'exporttime') . " Sent:" . mysql_result($result, $i, 'senttime') . " DDI:" . mysql_result($result, $i, 'callddi') . " CLI:" . mysql_result($result, $i, 'callcli') . " Agent:" . mysql_result($result, $i, 'loadagent') . " Order:" . mysql_result($result, $i, 'ordercode') . "<br>\n" . mysql_result($result, $i, 'ns_primary') . ' ' . mysql_result($result, $i, 'nf_primary') . ' ' . mysql_result($result, $i, 'nn_primary') . ' ' . mysql_result($result, $i, 'ar_primary') . ' ' . mysql_result($result, $i, 'as_primary') . ' ' . mysql_result($result, $i, 'al_primary') . ' ' . mysql_result($result, $i, 'at_primary') . ' ' . mysql_result($result, $i, 'ac_primary') . ' ' . mysql_result($result, $i, 'ap_primary') . ' ' . mysql_result($result, $i, 'pp_primary') . ' ' . mysql_result($result, $i, 'pe_primary') . (mysql_result($result, $i, 'loadpartial') == '1' ? " (PARTIAL)" : '') . "</td>\n";
if (agent_ingroup('A') and mysql_result($result, $i, 'loadinto') > '') {
echo "<td><a href=?recall={$recorduri}>Recall</a></td>\n";
}
echo "</tr>";
}
$addfield = mysql_result($result, $i, 'addfield');
$addvalue = mysql_result($result, $i, 'addvalue');
echo "<tr bgcolor={$colourbody}>";
echo "<td>{$addfield}</td><td>{$addvalue}</td>\n";
echo "</tr>";
$i++;
}
//TOO MUCH WORK TO DO!!!!!
echo "</table>\n";
mysql_close();
include '../includes/footer.php';
