echo "<td>";
// Have a look if this user has skills with this software
$ssql = "SELECT softwareid FROM `{$dbUserSoftware}` ";
$ssql .= "WHERE userid='{$userrow['id']}' AND softwareid='{$software}' ";
$sresult = mysql_query($ssql);
if (mysql_num_rows($sresult) >= 1) {
echo "<strong>{$userrow['realname']}</strong>";
} else {
echo $userrow['realname'];
}
echo "</td>";
echo "<td>" . $userrow['phone'] . "</td>";
echo "<td>" . user_online_icon($userrow['id']) . " " . userstatus_name($userrow['status']) . "</td>";
echo "<td>" . $userrow['message'] . "</td>";
echo "<td align='center'>";
$incpriority = user_incidents($userrow['id']);
$countincidents = $incpriority['1'] + $incpriority['2'] + $incpriority['3'] + $incpriority['4'];
if ($countincidents >= 1) {
$countactive = user_activeincidents($userrow['id']);
} else {
$countactive = 0;
}
$countdiff = $countincidents - $countactive;
echo "{$countactive} / {$countdiff}</td>";
echo "<td align='center'>" . $incpriority['4'] . "</td>";
echo "<td align='center'>" . $incpriority['3'] . "</td>";
echo "<td align='center'>" . $incpriority['2'] . "</td>";
echo "<td align='center'>" . $incpriority['1'] . "</td>";
echo "<td align='center'>";
echo $userrow['accepting'] == 'Yes' ? $strYes : "<span class='error'>{$strNo}</span>";
echo "</td>";
echo "<tr class='{$shade}'>";
echo "<td><label><input type='radio' name='userid' value='{$users->id}' /> ";
// Have a look if this user has skills with this software
$ssql = "SELECT softwareid FROM `{$dbUserSoftware}` WHERE userid={$users->id} AND softwareid={$incident->softwareid} ";
$sresult = mysql_query($ssql);
if (mysql_error()) {
trigger_error("MySQL Query Error " . mysql_error(), E_USER_WARNING);
}
if (mysql_num_rows($sresult) >= 1) {
echo "<strong>{$users->realname}</strong>";
} else {
echo $users->realname;
}
echo "</label></td>";
echo "<td>" . user_online_icon($users->id) . userstatus_name($users->status) . "</td>";
$incpriority = user_incidents($users->id);
$countincidents = $incpriority['1'] + $incpriority['2'] + $incpriority['3'] + $incpriority['4'];
if ($countincidents >= 1) {
$countactive = user_activeincidents($users->id);
} else {
$countactive = 0;
}
$countdiff = $countincidents - $countactive;
echo "<td align='center'>{$countactive} / {$countdiff}</td>";
echo "<td align='center'>" . $incpriority['4'] . "</td>";
echo "<td align='center'>" . $incpriority['3'] . "</td>";
echo "<td align='center'>" . $incpriority['2'] . "</td>";
echo "<td align='center'>" . $incpriority['1'] . "</td>";
echo "<td align='center'>";
echo $users->accepting == 'Yes' ? $strYes : "<span class='error'>{$strNo}</span>";
echo "</td>";