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 "
"; foreach($this->Items as $Item) { echo "\n\n\n"; } echo "
$Language[91] $Language[90] $Language[102]
"; echo $Item['day'].".".$Item['month'].".".$Item['year']; $Date = getdate(time()); echo " ".$Date['weekday']; if((int) $Date['mon'] == (int) $Item['month'] && (int) $Date['year'] == (int) $Item['year'] && (int) $Date['mday'] == (int) $Item['day']) { echo " ($Language[79])"; } echo "".$Item['text']."

"; $Optional = null; if(!empty($_GET['search'])) { $Optional .= "&search=".SecureQuery($_GET['search']); } PageNavigation(count(Database::GetItems('tasks', 0, FALSE, null, FALSE, " WHERE login='".$this->Login."' AND text LIKE '%".$Search."%'")), $Page, "?module=profiles§ion=calendar".$Optional, $this->Limit); } }