I recently purchased the Calendar template so that i could provide users the ability to manage their OWN events calendar... however, i cant figure a way to do this... everything i've tried keeps showing ALL the calendar events. I sure could use some help...
Hi, to apply User can see and edit their own records only security method in the Calendar you need to edit SQL query in the Before display events for monthly and weekly views. Add where clause to all SQL queries.
Here is a sample:
$strSQL = "select DateField from calendar where Recurrence=0 and Year(DateField)=".$yr." and Month(DateField)=".$mon." group by DateField where `User id`='".$_SESSION["UserID"]."'";
Then open and modify SQL queries in the Before SQL query events for daily view.
To turn on User can see and edit their own records only security method procees to the Security tab and click on the Advanced... button.