Loading...

Database

Windu CMS database is made up of a number of tables, which you can use with the database engine.

Downloading data

To download data you must first create an object for the specific table, then on the newly formed object call out one of the standard methods or other ones available for this table.

List of basic methods you can use
  • select($where = null, $order = null, $what = '*',$limit = null, $groupby = null, $bindValues = array() )
  • insert(array $data = array())
  • update($column, $value, $where, $bindValues = array() )
  • updateRow($data, $where, $bindValues = array() )
  • deleteRows($where, $bindValues = array() )
  • delete($id)
  • fetchRow($where = null, $order = null, $what = '*', $bindValues = array(), $fetchType = PDO::FETCH_OBJ)
  • fetchAll($where = null, $order = null, $what = '*', $limit = null, $groupby = null, $bindValues = array(),$fetchType = PDO::FETCH_OBJ)
  • fetchTextSearch($searchText,array $columns, $where = null, $order = null, $what = '*', $limit = null, $groupby = null, $bindValues = array() )
  • fetchCount($where = null, $bindValues = array() )
  • fetchCountGroup($groupBy,$where = null,$order = null,$what = '*', $limit = null, $bindValues = array() )
  • fetchSum($sumColumn,$where = null,$order = null,$what = '*', $limit = null, $bindValues = array() )
  • fetchGroup($groupBy, $where = null, $order = null, $what = '*', $limit = null, $bindValues = array())
  • set($id,$column,$value)
  • get($id,$column)
 
$pagesDB = new pagesDB();
$pages = $pagesDB->fetchAll("id>10");


Tables

Every table has it's own file with unique methods as well as regular methods that are available to any table using the database engine.

The list of tables contains the following:
  • banners
  • bannersareas
  • cache
  • calendar
  • calendarEvents
  • comments
  • config
  • contact
  • contactgroups
  • cronlog
  • firewall
  • files
  • forumGroups
  • forumPosts
  • forumTopics
  • forumReadedLog
  • forums
  • images
  • mailings
  • mailingtemplates
  • messages
  • notes
  • notify
  • pages
  • pagesbackups
  • pollanswers
  • pollAnswers
  • pollQuestions
  • polls
  • rates
  • redirect
  • session
  • systemStatus
  • themes
  • users
  • usertypes
  • widgets

To browse and edit tables, in the case of the SQLite database, we recommend the  FireFox extension https://addons.mozilla.org/pl/firefox/addon/sqlite-manager/.
 

We are continually working to improve Windu CMS!

By visitng the Windu website you will be kept up to date on new developments concerning the CMS.

2014-05-19 00:00:00 Battle Report

Since the release of Windu 3.0 we have we have done a lot of stuff to our CMS. The most important event in the near future will be the upgrade to version 3.1, which means a...

2014-03-25 00:00:00 Windu 3.0 - list of changes

After many months of challenges, new version of our CMS is finally out! We've decided to drop the idea Windu 2.4 and go for 3.0 straight away due to amount of changes...

2013-06-17 00:00:00 Update - Windu CMS rev 1432

New Windu CMS update is available for download at update server! Update includes several changes in our system: Pinning of tabs - allows fast navigation between open...

Buy a PRO license!

Activate loads of add-ons in your windu!

Buy a PRO license