// $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';