| ' . $dateField . ' | ' . $titleField . '/' . $descriptionField . ' | ' . $duedateField . ' | ' . $statusField . ' | |
';
$id = '';
$result = select_query("tbltodolist","",array("status"=>array("sqltype"=>"NEQ","value"=>"Completed")),"duedate","ASC");
while ($data = mysql_fetch_array($result)) {
$id = $data["id"];
$date = $data["date"];
$title = $data["title"];
$description = $data["description"];
$admin = $data["admin"];
$status = $data["status"];
$duedate = $data["duedate"];
$date = fromMySQLDate($date);
$duedate = ($duedate == "0000-00-00") ? '-' : fromMySQLDate($duedate);
$bgcolor = ($admin == $vars['adminid']) ? "#f5f5d7" : "#ffffff";
$description = (strlen($description)>50) ? substr($description,0,50).'...' : $description;
$content .= '| '.$date.' | '.$title.' - '.$description.' | '.$duedate.' | '.$status.' |  |
';
}
if (!$id) $content .= '| ' . $noRecordsFoundGlobal . ' |
';
$content .= '
';
$title = $_ADMINLANG['todolist']['todolisttitle'];
return array('title'=>$title,'content'=>$content);
}
add_hook("AdminHomeWidgets",1,"widget_todo_list");