class TaskItem { private $Id; public $Login; public $Year; public $Month; public $Day; public $Text; public $Expire; function __construct($Login, $Id = null) { global $Language; global $DatabaseConnection; $this->Exists = FALSE; $this->Author = $Login; $Optional = null; if(!$IgnoreActive) { $Optional = " AND active='1'"; } if(!empty($Id) && $Query = Database::GetItems('tasks', 0, 1, null, FALSE, " AND id='".$Id."' AND login='".$Login."'".$Optional)) { $this->Id = $Id; $this->Login = $Login; $this->Year = $Query[0]['year']; $this->Month = $Query[0]['month']; $this->Day = $Query[0]['day']; $this->Text = $Query[0]['text']; } } function Exists() { return $this->Exists; } function Save() { global $Language; global $DatabaseConnection; $Year = (int) $Year; $Month = (int) $Month; $Day = (int) $Day; $QueryText = "INSERT INTO tasks(id,login,year,month,day,text) VALUES(NULL, '".sqlite_escape_string($this->Login)."', '".$Year."', '".$Month."', '".$Day."', '".sqlite_escape_string($this->Text)."')"; if($this->Exists) { $QueryText = "UPDATE tasks SET year='".$Year."', month='".$Month."', day='".$Day."', text='".sqlite_escape_string($this->Text)."' WHERE id=".$this->Id." AND login='".$this->Login."'"; } $DatabaseConnection->Query($QueryText); } } /*--------------------------------------------------------------------------*/ class TaskGroup extends ItemGroup { public $Items = array(); private $Start; private $Limit; private $Login; private $List; private $Year; private $Month; private $Day; function __construct($Login, $Start = 0, $Limit = 15, $Search) { $this->Start = $Start; $this->Limit = $Limit; $this->Login = $Login; if($Query = Database::GetItems('tasks', $Start, $Limit, null, FALSE, " WHERE login='".$Login."'")) { $this->Items = $Query; } } function Display() { global $Page; global $Language; global $DatabaseConnection; echo "