<?php
/*
= LuxCal get Event Subategories =

© Copyright 2009-2018 LuxSoft - www.LuxSoft.eu

*/
chdir('..'); //change to calendar root
//load config data
require './lcconfig.php';

//get input params
$catID = $_POST['catID'];

//sanity check
if (empty($lcV) or !preg_match('%^\d{1,8}$%', $catID)) { echo "0"; exit(); } //abort

//start session
session_name('PHPSESSID');
session_start();

//get calendar ID
if (empty($_SESSION['cal']) or empty($_SESSION['uid'])) { echo "0"; exit(); } //abort
$calID = $_SESSION['cal'];

//get db toolbox
require './common/toolboxd.php'; //database tools + LCV

//connect to db
$dbH = dbConnect($calID);

//get user name
$stH = stPrep("SELECT `subName1`,`subColor1`,`subBgrnd1`,`subName2`,`subColor2`,`subBgrnd2`,`subName3`,`subColor3`,`subBgrnd3`,`subName4`,`subColor4`,`subBgrnd4` FROM `categories` WHERE `ID` = ?");
stExec($stH,array($catID));
$row = $stH->fetch(PDO::FETCH_ASSOC);
$subCats = array();
if ($row['subName1']) { $subCats[] = array($row['subName1'],$row['subColor1'],$row['subBgrnd1']); }
if ($row['subName2']) { $subCats[] = array($row['subName2'],$row['subColor2'],$row['subBgrnd2']); }
if ($row['subName3']) { $subCats[] = array($row['subName3'],$row['subColor3'],$row['subBgrnd3']); }
if ($row['subName4']) { $subCats[] = array($row['subName4'],$row['subColor4'],$row['subBgrnd4']); }
//send subcategories
echo $subCats ? json_encode($subCats) : '0';
?>