Menu

#5536 SQL plugin

Parent Category:
DPCalendar
Category:
Calendar plugins
Last Updated:
Allon Moritz, Tuesday, 23 November 2021 10:02
Created:
Thursday, 01 May 2014 17:36
Hits:
2764

Introduction

The SQL plugins allows to integrate events from another database table into DPCalendar. It comes with tons of calendar options to use any kind of table setup. The table can even be on a remote host. Then make sure that the Joomla web server is able to connect to the database server by opening the needed port and url on the firewall.

Joins

It is possible to add unlimited joins to a SQL calendar. Define the type, table and condition for the join. In the columns options you can then select the columns from the joins. It is recommended to work here with alias to make the columns easy readable.

SQL join configuration

Debug

If you have troubles with the query, then enable the Joomla debug modus in the global configuration. The SQL query is then available on the bottom of the page in the "Joomla! Debug Console" in the "Database Queries" tab. If there is an error, then the error message with the query is printed in the Joomla error panel.

DPCalendar Options

These settings are the same for every calendar configured in the plugin.

Driver Type [Type: Databaseconnection] [Default: mysqli]
The database driver type.
Host Name [Type: Text]
The host name of the database.
User Name [Type: Text]
The user name for the database authentication.
Password [Type: Password]
The password for the database authentication.
Database Name [Type: Text]
The name of the database.
Timezone [Type: Timezone]
The timezone of the event data.
The following options are available:
  1. JLIB_FORM_VALUE_TIMEZONE_UTC
Table Name [Type: Text]
The table name to import the data from.
Where Condition [Type: Textarea]
An additional where expression. Will be pasted raw into an AND expression.
Order [Type: Text]
The order of the query, eg. 'e.start_date asc'.
Group [Type: Text]
The 'group by' clause.
Limit [Type: Text]
The result limit.
Joins [Type: Subform]
The table joins.
ID Column [Type: Text] [Default: id]
The column for the ID.
Title Column [Type: Text] [Default: title]
The column for the title.
Start Date Column [Type: Text] [Default: start_date]
The column for the start date.
End Date Column [Type: Text] [Default: end_date]
The column for the end date.
All Day Column [Type: Text]
The column for the all day.
Description Column [Type: Text]
The column for the description.
RRule Column [Type: Text]
The column for the recurrence rule.
Location Column [Type: Text]
The column for the location.
Url Column [Type: Text]
The column for the url.
Alias Column [Type: Text]
The column for the alias.
Colour Column [Type: Text]
The column for the colour.
Image Column [Type: Text]
The column for the image.

Plugin Options

Caching [Type: List] [Default: Joomla]
Select whether to cache the calendar data.
The following options are available:
  1. Joomla
  2. Database
  3. Never
Cache Time [Type: Text] [Default: 900]
The time for the cache in sec.
Sync Start [Type: Text] [Default: -3 year]
The relative start date to sync from.
Sync End [Type: Text] [Default: +3 year]
The relative end date to sync from.
Sync Steps [Type: Text] [Default: 1 year]
The sync steps.

Comments (0)

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.