if (isset($_REQUEST['mockfbmltext'])) {
echo $_REQUEST['mockfbmltext'];
exit;
}
require_once 'dbappinclude.php';
//--------------------------------------------
// get data
//--------------------------------------------
$rs = query("select distinct task from times where user = $user order by task");
$tasks = array();
$sums = array();
$log = array();
$x = 0;
while ($row = mysql_fetch_assoc($rs)) {
$tasks[$x] = $row["task"];
$rsSum = query("select SUM(seconds) as \"sum\" from times where user = $user and task =\"$tasks[$x]\"");
if ($rowSum = mysql_fetch_assoc($rsSum)) {
$sums[$x] = $rowSum["sum"];
} else {
$sums[$x] = -1;
}
$rsRun = query("select UNIX_TIMESTAMP(logdate) as log from times where user = $user and code = 1 and task=\"$tasks[$x]\"");
if ($rowRun = mysql_fetch_assoc($rsRun)) {
$log[$x] = $rowRun["log"];
} else {
$log[$x] = -1;
}
$x++;
}
//--------------------------------------------
// create the Javascript to update runing times
//--------------------------------------------
echo "\n";
// echo "\n";
if ($clockflag = 0)
echo "\n";
else
echo "\n";
//--------------------------------------------
// greet
//--------------------------------------------
echo "hello $user (hmmm a name would be nice...)";
//--------------------------------------------
// make table
//--------------------------------------------
echo "
| task | time | adjust |
\n";
$i=0;
while($i <$x){
echo ' | \n";
if ($log[$i] > 0)
echo "";
else
echo " | ";
echo "";
echo " | \n";
echo " | \n";
echo "\n";
$i++;
}
echo "
\n";
//--------------------------------------------
// delete and add tasks
//--------------------------------------------
echo "\n";
echo '| new task |
\n";
echo "| ";
echo " |