/**
*
*/
public function editsafinstancesAction()
{
$r = $this->getRequest();
$safinstance = false;
if (isset($r->id) && preg_match('/^[0-9]{1,50}$/', $r->id)) {
$sDB = new Safinstances();
$s = $sDB->find($r->id);
if (count($s) == 1) {
$safinstance = $s[0];
}
}
$this->view->safinstanceid = $safinstance->id;
$this->setSubtitle2('Webinstances : Edit');
// Main safinstance info form
$form = new SafinstancesFormOp();
$safform = $form->getMainform();
if ($r->isPost()) {
$p = $r->getPost();
if ($safform->isValid($p)) {
foreach ($p as $k => $v) {
if (isset($safinstance->{$k}) && $k != 'id') {
$safinstance->{$k} = $v;
}
}
$safinstance->save();
}
} else {
if ($safinstance) {
$safform->populate($safinstance->toArray());
}
}
$this->view->safinstancesForm = $safform;
}
public function init()
{
$options = new Safinstances();
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
if (isset($v['mlabel'])) {
$this->addMultiOption($k, $v['mlabel']);
}
}
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('safactivitylog');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$timestamp = new Zend_Form_Element_Text('timestamp');
$timestamp->setLabel('timestamp');
$priorityName = new Zend_Form_Element_Text('priorityName');
$priorityName->setLabel('priorityName');
$priority = new Zend_Form_Element_Text('priority');
$priority->setLabel('priority');
$className = new Zend_Form_Element_Text('className');
$className->setLabel('className');
$message = new Zend_Form_Element_Textarea('message');
$message->setLabel('message');
$usersId = new Zend_Form_Element_Select('users_id');
$options = new Users();
$usersId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$usersId->addMultiOption($k, $v['mlabel']);
}
$usersId->setLabel('users_id');
$login = new Zend_Form_Element_Text('login');
$login->setLabel('login');
$fname = new Zend_Form_Element_Text('fname');
$fname->setLabel('fname');
$lname = new Zend_Form_Element_Text('lname');
$lname->setLabel('lname');
$module = new Zend_Form_Element_Text('module');
$module->setLabel('module');
$action = new Zend_Form_Element_Text('action');
$action->setLabel('action');
$moduleTable = new Zend_Form_Element_Textarea('module_table');
$moduleTable->setLabel('module_table');
$moduleIds = new Zend_Form_Element_Textarea('module_ids');
$moduleIds->setLabel('module_ids');
$parentId = new Zend_Form_Element_Select('parent_id');
$options = new Safactivitylog();
$parentId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$parentId->addMultiOption($k, $v['mlabel']);
}
$parentId->setLabel('parent_id');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$this->addElements(array($id, $hash, $timestamp, $priorityName, $priority, $className, $message, $usersId, $login, $fname, $lname, $module, $action, $moduleTable, $moduleIds, $parentId, $safinstancesId));
$this->addElements(array($submit));
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('filfolders');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$label = new Zend_Form_Element_Text('label');
$label->setLabel('label');
$desc = new Zend_Form_Element_Textarea('desc');
$desc->setLabel('desc');
$parentId = new Zend_Form_Element_Select('parent_id');
$options = new Filfolders();
$parentId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$parentId->addMultiOption($k, $v['mlabel']);
}
$parentId->setLabel('parent_id');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$isNode = new Zend_Form_Element_Text('isnode');
$isNode->setLabel('isnode');
$isParam = new Zend_Form_Element_Text('isparam');
$isParam->setLabel('isparam');
$relevance = new Zend_Form_Element_Text('relevance');
$relevance->setLabel('relevance');
$pagOrder = new Zend_Form_Element_Text('pagorder');
$pagOrder->setLabel('pagorder');
$linkedTo = new Zend_Form_Element_Textarea('linkedto');
$linkedTo->setLabel('linkedto');
$isSystemFolder = new Zend_Form_Element_Text('isSystemFolder');
$isSystemFolder->setLabel('isSystemFolder');
$fileFoldersFileFiles = new FilfileslistForm('FilfoldersFilfiles');
$fileFoldersFileFiles->setLabel('FilfoldersFilfiles');
$fileFoldersUsers = new UserslistForm('FilfoldersUsers');
$fileFoldersUsers->setLabel('FilfoldersUsers');
$this->addElements(array($id, $hash, $label, $desc, $parentId, $safinstancesId, $isNode, $isParam, $relevance, $pagOrder, $linkedTo, $isSystemFolder, $fileFoldersFileFiles, $fileFoldersUsers));
$this->addElements(array($submit));
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('users');
$id = new Zend_Form_Element_Hidden('id');
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$safinstancesId = new Zend_Form_Element_Select('saf_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('Main website');
$safinstancesId->setRequired(true);
$safinstancesUsers = new SafinstanceslistForm('SafinstancesUsers');
$safinstancesUsers->setLabel('Additional website(s)');
$this->addElements(array($id, $safinstancesId, $safinstancesUsers, $submit));
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('filmetadata');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$label = new Zend_Form_Element_Textarea('label');
$label->setLabel('label');
$desc = new Zend_Form_Element_Textarea('desc');
$desc->setLabel('desc');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$parentId = new Zend_Form_Element_Select('parent_id');
$options = new Filmetadata();
$parentId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$parentId->addMultiOption($k, $v['mlabel']);
}
$parentId->setLabel('parent_id');
$isNode = new Zend_Form_Element_Text('isnode');
$isNode->setLabel('isnode');
$editable = new Zend_Form_Element_Text('editable');
$editable->setLabel('editable');
$fileFilesFileMetaData = new FilfileslistForm('FilfilesFilmetadata');
$fileFilesFileMetaData->setLabel('FilfilesFilmetadata');
$fileMetaDataFileType = new FiltypelistForm('FilmetadataFiltype');
$fileMetaDataFileType->setLabel('FilmetadataFiltype');
$this->addElements(array($id, $hash, $label, $desc, $safinstancesId, $parentId, $isNode, $editable, $fileFilesFileMetaData, $fileMetaDataFileType));
$this->addElements(array($submit));
}
/**
* Check the access rights agains the DB if we are in the publicms module
*
* @param $role
* @return void
*/
private function checkRightsPublicms($role)
{
// check if instance is offline
$safinstanceDB = new Safinstances();
$safinstances = $safinstanceDB->find($this->safinstancesId);
if (count($safinstances) != 1) {
print "FATAL ERROR 452 in Sydney_Controller_Plugin_Auth::checkRightsPublicms(" . $this->safinstancesId . ")";
header('Location: ' . Sydney_Tools_Paths::getRootUrlCdn() . '/install/instance/index.php/referrer/PluginAuth/checkRightsPublicms/noinstancefound');
exit;
} elseif ($safinstances[0]->active == 0) {
print $safinstances[0]->offlinemessage;
if (empty($safinstances[0]->offlinemessage)) {
print "This site is offline.";
header('Location: ' . Sydney_Tools_Paths::getRootUrlCdn() . '/install/instance/index.php/referrer/PluginAuth/checkRightsPublicms');
}
exit;
}
// get page data
$d = $this->request->getParams();
if ($d['module'] == 'publicms' && $d['controller'] == 'index' && $d['action'] == 'view') {
$nodes = new Pagstructure();
if (!isset($d['page']) || !preg_match("/^[0-9]{1,100}\$/", $d['page'])) {
$nodeId = $nodes->getHomeId($this->safinstancesId);
} else {
$nodeId = $d['page'];
}
$node = $nodes->fetchAll(" id = '" . $nodeId . "' AND safinstances_id = '" . $this->safinstancesId . "' ");
if (count($node) == 1) {
$authorizedGroupId = $node[0]->usersgroups_id;
if (!self::isContentAccessible($authorizedGroupId, $this->userNamespace->user['member_of_groups'])) {
$this->redirecting('default', 'login', 'index', 'code04');
}
} else {
print "Node {$nodeId} not found! (FATAL ERROR 542 in Sydney_Controller_Plugin_Auth::checkRightsPublicms)";
header('Location: ' . Sydney_Tools_Paths::getRootUrlCdn() . '/install/instance/index.php/referrer/PluginAuth/checkRightsPublicms/nodenotfound');
exit;
}
}
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('users');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$login = new Zend_Form_Element_Text('login');
$login->setLabel('login');
$password = new Zend_Form_Element_Password('password');
$password->setLabel('password');
$usersGroupsId = new Zend_Form_Element_Select('usersgroups_id');
$options = new Usersgroups();
$usersGroupsId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$usersGroupsId->addMultiOption($k, $v['mlabel']);
}
$usersGroupsId->setLabel('usersgroups_id');
$valid = new Zend_Form_Element_Checkbox('valid');
$valid->setLabel('valid');
$fileName = new Zend_Form_Element_Text('fname');
$fileName->setLabel('fname');
$mdName = new Zend_Form_Element_Text('mdname');
$mdName->setLabel('mdname');
$lastName = new Zend_Form_Element_Text('lname');
$lastName->setLabel('lname');
$phone = new Zend_Form_Element_Text('phone');
$phone->setLabel('phone');
$cell = new Zend_Form_Element_Text('cell');
$cell->setLabel('cell');
$email = new Zend_Form_Element_Text('email');
$email->setLabel('email');
$active = new Zend_Form_Element_Checkbox('active');
$active->setLabel('active');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$subscribeDate = new Zend_Form_Element_Text('subscribedate');
$subscribeDate->setLabel('subscribedate');
$unsubscribeDate = new Zend_Form_Element_Text('unsubscribedate');
$unsubscribeDate->setLabel('unsubscribedate');
$modifiedDate = new Zend_Form_Element_Text('modifieddate');
$modifiedDate->setLabel('modifieddate');
$ip = new Zend_Form_Element_Text('ip');
$ip->setLabel('ip');
$creatorIdentity = new Zend_Form_Element_Text('creatoridentity');
$creatorIdentity->setLabel('creatoridentity');
$avatar = new Zend_Form_Element_Text('avatar');
$avatar->setLabel('avatar');
$pageOrder = new Zend_Form_Element_Text('pagorder');
$pageOrder->setLabel('pagorder');
$lastLoginDate = new Zend_Form_Element_Text('lastlogindate');
$lastLoginDate->setLabel('lastlogindate');
$lastStatusChange = new Zend_Form_Element_Text('laststatuschange');
$lastStatusChange->setLabel('laststatuschange');
$lastPwdChanges = new Zend_Form_Element_Text('lastpwdchanges');
$lastPwdChanges->setLabel('lastpwdchanges');
$timeValidityPassword = new Zend_Form_Element_Text('timeValidityPassword');
$timeValidityPassword->setLabel('timeValidityPassword');
$lastPwdHistory = new Zend_Form_Element_Text('lastpwdhistory');
$lastPwdHistory->setLabel('lastpwdhistory');
$filFoldersUsers = new FilfolderslistForm('FilfoldersUsers');
$filFoldersUsers->setLabel('FilfoldersUsers');
$safinstancesUsers = new SafinstanceslistForm('SafinstancesUsers');
$safinstancesUsers->setLabel('SafinstancesUsers');
$this->addElements(array($id, $hash, $login, $password, $usersGroupsId, $valid, $fileName, $mdName, $lastName, $phone, $cell, $email, $active, $safinstancesId, $subscribeDate, $unsubscribeDate, $modifiedDate, $ip, $creatorIdentity, $avatar, $pageOrder, $lastLoginDate, $lastStatusChange, $lastPwdChanges, $timeValidityPassword, $lastPwdHistory, $filFoldersUsers, $safinstancesUsers));
$this->addElements(array($submit));
}
/**
* Manage the content of the meta keyword and description
* for ALL the webinstances
*/
protected function _manageMetaTags()
{
$metadesc = '';
$metakeywords = '';
// metadesc
if (is_array($this->view->thisnode) && isset($this->view->thisnode['metadesc']) && $this->view->thisnode['metadesc'] != '') {
$metadesc = $this->view->thisnode['metadesc'];
}
// metakeywords
if (is_array($this->view->thisnode) && isset($this->view->thisnode['metakeywords']) && $this->view->thisnode['metakeywords'] != '') {
$metakeywords = $this->view->thisnode['metakeywords'];
}
if (empty($metakeywords) || empty($metadesc)) {
$saf = new Safinstances();
$row = $saf->find($this->safinstancesId)->current();
if (empty($metakeywords)) {
$metakeywords = $row->metakeywords;
}
if (empty($metadesc)) {
$metadesc = $row->description;
}
}
$this->view->headMeta()->appendName('keywords', $metakeywords);
$this->view->headMeta()->appendName('description', $metadesc);
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('filfiles');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$label = new Zend_Form_Element_Textarea('label');
$label->setLabel('label');
$desc = new Zend_Form_Element_Text('desc');
$desc->setLabel('desc');
$keywords = new Zend_Form_Element_Textarea('keywords');
$keywords->setLabel('keywords');
$fileName = new Zend_Form_Element_Textarea('filename');
$fileName->setLabel('filename');
$path = new Zend_Form_Element_Textarea('path');
$path->setLabel('path');
$type = new Zend_Form_Element_Text('type');
$type->setLabel('type');
$fileWeight = new Zend_Form_Element_Text('fweight');
$fileWeight->setLabel('fweight');
$imgWidth = new Zend_Form_Element_Text('imgwidth');
$imgWidth->setLabel('imgwidth');
$imgHeight = new Zend_Form_Element_Text('imgheight');
$imgHeight->setLabel('imgheight');
$techData = new Zend_Form_Element_Textarea('techdata');
$techData->setLabel('techdata');
$fileTypeId = new Zend_Form_Element_Select('filtype_id');
$options = new Filtype();
$fileTypeId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$fileTypeId->addMultiOption($k, $v['mlabel']);
}
$fileTypeId->setLabel('filtype_id');
$usersId = new Zend_Form_Element_Select('users_id');
$options = new Users();
$usersId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$usersId->addMultiOption($k, $v['mlabel']);
}
$usersId->setLabel('users_id');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$datecreated = new Zend_Form_Element_Text('datecreated');
$datecreated->setLabel('datecreated');
$datemodified = new Zend_Form_Element_Text('datemodified');
$datemodified->setLabel('datemodified');
$istagged = new Zend_Form_Element_Text('istagged');
$istagged->setLabel('istagged');
$idxcontent = new Zend_Form_Element_Text('idxcontent');
$idxcontent->setLabel('idxcontent');
$fileFilesFileMetaData = new FilmetadatalistForm('FilfilesFilmetadata');
$fileFilesFileMetaData->setLabel('FilfilesFilmetadata');
$fileFoldersFilefiles = new FilfolderslistForm('FilfoldersFilfiles');
$fileFoldersFilefiles->setLabel('FilfoldersFilfiles');
$this->addElements(array($id, $hash, $label, $desc, $keywords, $fileName, $path, $type, $fileWeight, $imgWidth, $imgHeight, $techData, $fileTypeId, $usersId, $safinstancesId, $datecreated, $datemodified, $istagged, $idxcontent, $fileFilesFileMetaData, $fileFoldersFilefiles));
$this->addElements(array($submit));
}
public function __construct($options = null)
{
parent::__construct($options);
$this->setAttrib('accept-charset', 'UTF-8');
$this->setName('pagstructure');
$id = new Zend_Form_Element_Hidden('id');
$hash = new Zend_Form_Element_Hash('no_csrf_foo', array('salt' => '4s564evzaSD64sf'));
$submit = new Zend_Form_Element_Submit('submit');
$submit->setAttrib('id', 'submitbutton');
$label = new Zend_Form_Element_Textarea('label');
$label->setLabel('label');
$htmlTitle = new Zend_Form_Element_Textarea('htmltitle');
$htmlTitle->setLabel('htmltitle');
$url = new Zend_Form_Element_Textarea('url');
$url->setLabel('url');
$metaDesc = new Zend_Form_Element_Textarea('metadesc');
$metaDesc->setLabel('metadesc');
$metaKeywords = new Zend_Form_Element_Textarea('metakeywords');
$metaKeywords->setLabel('metakeywords');
$parentId = new Zend_Form_Element_Select('parent_id');
$options = new Pagstructure();
$parentId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$parentId->addMultiOption($k, $v['mlabel']);
}
$parentId->setLabel('parent_id');
$safinstancesId = new Zend_Form_Element_Select('safinstances_id');
$options = new Safinstances();
$safinstancesId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$safinstancesId->addMultiOption($k, $v['mlabel']);
}
$safinstancesId->setLabel('safinstances_id');
$isHome = new Zend_Form_Element_Text('ishome');
$isHome->setLabel('ishome');
$status = new Zend_Form_Element_Text('status');
$status->setLabel('status');
$pagOrder = new Zend_Form_Element_Text('pagorder');
$pagOrder->setLabel('pagorder');
$dateCreated = new Zend_Form_Element_Text('datecreated');
$dateCreated->setLabel('datecreated');
$dateModified = new Zend_Form_Element_Text('datemodified');
$dateModified->setLabel('datemodified');
$dateLastUpdateContent = new Zend_Form_Element_Text('date_lastupdate_content');
$dateLastUpdateContent->setLabel('date_lastupdate_content');
$whoModified = new Zend_Form_Element_Text('who_modified');
$whoModified->setLabel('who_modified');
$whoLastUpdateContent = new Zend_Form_Element_Text('who_lastupdate_content');
$whoLastUpdateContent->setLabel('who_lastupdate_content');
$isCachable = new Zend_Form_Element_Text('iscachable');
$isCachable->setLabel('iscachable');
$cacheTime = new Zend_Form_Element_Text('cachetime');
$cacheTime->setLabel('cachetime');
$hits = new Zend_Form_Element_Text('hits');
$hits->setLabel('hits');
$redirectToId = new Zend_Form_Element_Text('redirecttoid');
$redirectToId->setLabel('redirecttoid');
$usersGroupsId = new Zend_Form_Element_Select('usersgroups_id');
$options = new Usersgroups();
$usersGroupsId->addMultiOption('', '----------');
foreach ($options->fetchAlltoFlatArray() as $k => $v) {
$usersGroupsId->addMultiOption($k, $v['mlabel']);
}
$usersGroupsId->setLabel('usersgroups_id');
$isDeleted = new Zend_Form_Element_Text('isDeleted');
$isDeleted->setLabel('isDeleted');
$shortDesc = new Zend_Form_Element_Textarea('shortdesc');
$shortDesc->setLabel('shortdesc');
$colorCode = new Zend_Form_Element_Text('colorcode');
$colorCode->setLabel('colorcode');
$layout = new Zend_Form_Element_Text('layout');
$layout->setLabel('layout');
$pagStructurePagDivs = new PagdivslistForm('PagstructurePagdivs');
$pagStructurePagDivs->setLabel('PagstructurePagdivs');
$pagStructurePagMenus = new PagmenuslistForm('PagstructurePagmenus');
$pagStructurePagMenus->setLabel('PagstructurePagmenus');
$this->addElements(array($id, $hash, $label, $htmlTitle, $url, $metaDesc, $metaKeywords, $parentId, $safinstancesId, $isHome, $status, $pagOrder, $dateCreated, $dateModified, $dateLastUpdateContent, $whoModified, $whoLastUpdateContent, $isCachable, $cacheTime, $hits, $redirectToId, $usersGroupsId, $isDeleted, $shortDesc, $colorCode, $layout, $pagStructurePagDivs, $pagStructurePagMenus));
$this->addElements(array($submit));
}
