ulrisa
Posts: 8
|
| Posted: 08/06/2008, 3:40 PM |
|
HI can i do this change the open () function in vcalendar to show only the events added by the logged in user.
i need to add something like this ""WHERE events.user_id = $_SESSION['UserID']""
here
is this possible to do here??
function Open()
{
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeBuildSelect", $this->Parent);
$this->SQL = "SELECT category_image, event_id, event_title, event_date, event_time, event_time_end \n\n" .
"FROM events LEFT JOIN categories ON\n\n" .
"events.category_id = categories.category_id {SQL_Where} {SQL_OrderBy}";
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "BeforeExecuteSelect", $this->Parent);
$this->query(CCBuildSQL($this->SQL, $this->Where, $this->Order));
$this->CCSEventResult = CCGetEvent($this->CCSEvents, "AfterExecuteSelect", $this->Parent);
$this->MoveToPage($this->AbsolutePage);
}
|
 |
|
|
|
