XoopsModules25x / xhelp

    $sql = sprintf('SELECT u.uid, u.uname, u.name, (s.responseTime / s.ticketsResponded) as AvgResponseTime FROM %s u INNER JOIN %s s ON u.uid = s.uid WHERE ticketsResponded > 0 ORDER BY AvgResponseTime', $xoopsDB->prefix('users'), $xoopsDB->prefix('xhelp_staff'));

    $ret = $xoopsDB->query($sql, MAX_STAFF_RESPONSETIME);

    $i = 0;

    while (list($uid, $uname, $name, $avgResponseTime) = $xoopsDB->fetchRow($ret)) {

        $class = $table_class[$i % 2];

        echo "<tr class='$class'><td>". xhelpGetDisplayName($displayName, $name,$uname) ."</td><td align='right'>". xhelpFormatTime($avgResponseTime) ."</td></tr>";

        $i++;

    }

    echo "</table></div><br />"; // End inner top-left cell

    echo "</td></tr><tr><td valign='top'>"; // End first, start second cell

            echo "<table border='0' width='100%' cellspacing='1' class='outer'>

                  <tr><th colspan='2'>". _AM_XHELP_TEXT_RESPONSE_TIME_SLOW ."</th></tr>";

            $i = 0;

            while (list($uid, $uname, $name, $avgResponseTime) = $xoopsDB->fetchRow($ret)) {

                $class = $table_class[$i % 2];

                echo "<tr class='$class'><td>". xhelpGetDisplayName($displayName, $name,$uname) ."</td><td align='right'>". xhelpFormatTime($avgResponseTime) ."</td></tr>";

                $i++;

            }

            echo "</table></div>";  // End first cell, second row of inner table

        }

    }