	ID	SectionID?_LANG_IN_SECTION:_LANG_IN_SITE)?>
$msg

	".$Array[0]."	SectionID."&SiteID=".$loc->SiteID."&SectionObjectID=".$Array[0]."\">".$Array[1]."	".$Array[2]."	".$Array[2]."	SectionID."&SiteID=".$loc->SiteID."&SectionObjectID=".$Array[0]."\">".($loc->SectionID?"SiteID."§ion=".$loc->SectionID."&object=".$Array[0].">":"")."

	ID

	".$Array[0]."	".(GetSectionObjectCount($Array[0])?"".$Array[1]."":"".$Array[1]."")." ".(!$Array[3]?"["._LANG_TURNOFF2."]":"")."	".(!ChildrenNumber ($Array[0])?_LANG_NO:_LANG_LIST." (".ChildrenNumber ($Array[0]).")")."	"._LANG_PROPERTIES." \| "._LANG_VIEW.""; print "

".$Array[0]."

".(GetSectionObjectCount($Array[0])?"".$Array[1]."":"".$Array[1]."")." ".(!$Array[3]?"["._LANG_TURNOFF2."]":"")."

".(!ChildrenNumber ($Array[0])?_LANG_NO:_LANG_LIST." (".ChildrenNumber ($Array[0]).")")."

"._LANG_PROPERTIES." | "._LANG_VIEW.""; print "

	ID
$msg

$msg

1){?>

".$templ['Description'].""; ?>

$v){ $out .= ""._LANG_INSERT_CODE.": ".$v['SON']."

"; } $out .= "[ X ]

"; echo $out; } else { // add obj? $out = ""._LANG_OBJ_ADD."

[ X ]

"; echo $out; } ?>

"._LANG_PROPERTIES." | "; echo ""._LANG_SUBSECTION_ADD.""; if (!ChildrenNumber($Array[0])) echo " | "._LANG_DELETE.""; ?> SiteID."\">"; $Hierarchy .= GetSiteNameByID ($loc->SiteID).""; if ($loc->SectionID) $SectionID = $loc->SectionID; else $SectionID = $loc->ParentSectionID; $LastSectionAsLink = 1; if ($SectionID) { $SectionArray[] = $SectionID; $CurrentSectionID = $SectionID; while ($CurrentSectionID) { $select = "SELECT `Parent_Section_ID` FROM `".(LOWER_CASE_TABLES ? "section" : "Section")."` WHERE `Section_ID`="; $select .= $CurrentSectionID; $Result = mysql_query ($select, $LinkID); if (!$Result) DebugBreak(); $Array = mysql_fetch_row ($Result); $CurrentSectionID = $Array[0]; if ($CurrentSectionID) $SectionArray[] = $Array[0]; } $this->Link = $this->NoLink = $Hierarchy; for ($i=sizeof($SectionArray)-1; $i>-1; $i--) { $this->Link .= $Delimeter; $this->NoLink .= $Delimeter; if ( $i || (!$i && $LastSectionAsLink) ) $this->Link .= ""; $Hierarchy = GetSectionNameByID($SectionArray[$i]); $this->Link .= $Hierarchy; $this->NoLink .= $Hierarchy; if ( $i || (!$i && $LastSectionAsLink) ) $this->Link .= ""; } } else { $this->Link = $this->NoLink = $Hierarchy; } } function printVars () { print "Link=".$this->Link."
\n"; print "NoLink=".$this->NoLink."
\n"; } } #конец класса ############################################################################### function ChangeSectionParentCompleted ($SectionID, $NewParentSectionID) { global $LinkID, $loc, $CMS_ADMIN_PATH; $ErrorString = ""; if ($NewParentSectionID==0) { System_UpdateParentSectionID ($SectionID, $NewParentSectionID); System_UpdateHiddenURL ("/",0,$loc->SiteID); } if ($SectionID == $NewParentSectionID) { $ErrorString = _LANG_MOVE_ERROR1; return $ErrorString; } if ( !IsSectionExist($NewParentSectionID) && $NewParentSectionID<>0) { $ErrorString = _LANG_MOVE_ERROR2_1.$NewParentSectionID._LANG_MOVE_ERROR2_2; return $ErrorString; } if (GetSiteBySection($SectionID) != GetSiteBySection($NewParentSectionID) && $NewParentSectionID<>0) { $ErrorString = _LANG_MOVE_ERROR3; return $ErrorString; } System_UpdateParentSectionID ($SectionID, $NewParentSectionID); System_UpdateHiddenURL ("/",0,$loc->SiteID); return $ErrorString; }; ############################################################################### // A.L. 10/12/2012 function CopySectionCompleted($SectionID, $CopyParentSectionID){ $section = SQLSelectOne("SELECT * FROM `".(LOWER_CASE_TABLES ? "" : "Section")."` WHERE `Section_ID`='$SectionID'"); if(empty($section)) return _LANG_COPY_ERROR .' (1)'; //Section unset($section['Section_ID']); if($CopyParentSectionID > 0){ $section['Parent_Section_ID'] = $CopyParentSectionID; $parent = SQLSelectOne("SELECT * FROM `Section` WHERE `Section_ID`='$CopyParentSectionID'"); $section['Site_ID'] = $parent['Site_ID']; $section['Hidden_URL'] = $parent['Hidden_URL'] . $section['LinkName'] .'/'; }else{ $section['Parent_Section_ID'] = 0; $section['Site_ID'] = -$CopyParentSectionID; $section['Hidden_URL'] = '/'. $section['LinkName'] .'/'; } $NewSectionID = SQLInsert('Section', $section); if(empty($SectionID)) return _LANG_COPY_ERROR .' (2)'; //Section_Object $SectionObjects = SQLSelect("SELECT * FROM `".(LOWER_CASE_TABLES ? "section_object" : "Section_Object")."` WHERE `Section_ID`='$SectionID'"); if(empty($SectionObjects)) return ''; foreach($SectionObjects as $SectionObject){ $SectionObjectID = $SectionObject['Section_Object_ID']; unset($SectionObject['Section_Object_ID']); $SectionObject['Section_ID'] = $NewSectionID; $SectionObject['Site_ID'] = $section['Site_ID']; if($SectionObject['DaysToHold'] == '') unset($SectionObject['DaysToHold']); if($SectionObject['RecordsPerPage'] == '') unset($SectionObject['RecordsPerPage']); $NewSectionObjectID = SQLInsert('Section_Object', $SectionObject); if(empty($NewSectionObjectID)) return _LANG_COPY_ERROR .' (3)'; //DataXXX $fields = getObjectStruct($SectionObject['Object_ID']); $datas = SQLSelect("SELECT * FROM `".(LOWER_CASE_TABLES ? "data" : "Data")."{$SectionObject['Object_ID']}` WHERE `Section_ID`='{$SectionID}' AND `Section_Object_ID`='{$SectionObjectID}'"); foreach($datas as $data){ unset($data['Data_ID']); $data['Section_ID'] = $NewSectionID; $data['Section_Object_ID'] = $NewSectionObjectID; if($data['TimeToDelete'] == '') unset($data['TimeToDelete']); if($data['TimeToUncheck'] == '') unset($data['TimeToUncheck']); foreach($fields as $field){ if($field['TypeOfData_ID'] == 6){ //File if(!empty($data[$field['Object_Field_Name']])){ list($srcFile) = explode(':', $data[$field['Object_Field_Name']]); if(!file_exists($GLOBALS['FILES_FOLDER'] . $srcFile)){ $data[$field['Object_Field_Name']] = ''; }else{ //Копируем основной файл if(preg_match('/^(.+)(\.[^.]*)$/i', $srcFile, $m)){ $basename = $m[1]; $ext = $m[2]; }else{ $basename = $srcFile; $ext = ''; } $dstFile = GenerateFilename($GLOBALS['FILES_FOLDER'], $basename, $ext); copy($GLOBALS['FILES_FOLDER'] . $srcFile, $GLOBALS['FILES_FOLDER'] . $dstFile); $data[$field['Object_Field_Name']] = $dstFile . substr($data[$field['Object_Field_Name']], strlen($srcFile)); //Копируем производные файлы if(preg_match_all("/postfix=([\_\-A-Za-z0-9]+)/i", $field['Format'], $mm)){ foreach($mm[1] as $postfix){ $src = InsertPostfix($GLOBALS['FILES_FOLDER'] . $srcFile, $postfix); $dst = InsertPostfix($GLOBALS['FILES_FOLDER'] . $dstFile, $postfix); if(file_exists($src)){ copy($src, $dst); } } }; }; }; } }; $DataID = SQLInsert("".(LOWER_CASE_TABLES ? "data" : "Data")."". $SectionObject['Object_ID'], $data); if(empty($DataID)) return _LANG_COPY_ERROR .' (4)'; }; } }; function GetSitesSectionsOptionList(){ $sites = SQLSelect("SELECT * FROM `".(LOWER_CASE_TABLES ? "site" : "Site")."` ORDER BY `Priority`"); $sections = SQLSelect("SELECT * FROM `".(LOWER_CASE_TABLES ? "section" : "Section")."` ORDER BY `Priority`"); $links = array(); $hSections = array(); foreach($sections as $item){ $hSections[$item['Section_ID']] = $item; $links[$item['Site_ID']][$item['Parent_Section_ID']][] = $item['Section_ID']; }; $groups = array(); foreach($sites as $site){ $group = array( 'title' => "{$site['Site_ID']} [{$site['Site_Lang']}] {$site['Site_Name']}", 'options' => array(array( 'value' => -$site['Site_ID'], 'caption'=>'/ - '. _LANG_COPY_ROOT_SECTION .' [0]', )), ); BildSectionOptionList(0, $group['options'], $links[$site['Site_ID']], $hSections); $groups[] = $group; }; return $groups; } function BildSectionOptionList($Parent_Section_ID, &$options, &$site_links, &$sections){ if(!empty($site_links[$Parent_Section_ID])){ foreach($site_links[$Parent_Section_ID] as $Section_ID){ $options[] = array( 'value' => $Section_ID, 'caption' => "{$sections[$Section_ID]['Hidden_URL']} - {$sections[$Section_ID]['Section_Name']} [$Section_ID]", ); BildSectionOptionList($Section_ID, $options, $site_links, $sections); } }; //return $sections; } ############################################################################### function System_UpdateSectionPriority () { global $LinkID; reset($_POST); while (list($key, $val) = each($_POST)) { if (substr($key,0,8)=="Priority") { $section_id = substr($key,8,strlen($key)-8)+0; $val += 0; $update = "UPDATE `".(LOWER_CASE_TABLES ? "section" : "Section")."` SET `Priority`=".$val.",`LastSystem_Updated`=LastSystem_Updated WHERE `Section_ID`=".$section_id; mysql_query($update,$LinkID); } } } ############################################################################### function InheritSectionEnv ($SectionID) { global $LinkID; $res = mysql_query("SELECT * FROM `".(LOWER_CASE_TABLES ? "section" : "Section")."` WHERE `Section_ID`=".$SectionID, $LinkID); $Array = mysql_fetch_assoc($res); $ParentArray["Site_ID"] = $Array["Site_ID"]; mysql_free_result($res); while ($Array["Parent_Section_ID"]) { $res = mysql_query("SELECT * FROM `".(LOWER_CASE_TABLES ? "section" : "Section")."` WHERE `Section_ID`=".$Array["Parent_Section_ID"], $LinkID); $ParentArray = mysql_fetch_assoc($res); mysql_free_result($res); if (!$Array["Template_ID"]) $Array["Template_ID"] = $ParentArray["Template_ID"]; if (!$Array["Read_Access_ID"]) $Array["Read_Access_ID"] = $ParentArray["Read_Access_ID"]; if (!$Array["Write_Access_ID"]) $Array["Write_Access_ID"] = $ParentArray["Write_Access_ID"]; if (!$Array["Edit_Access_ID"]) $Array["Edit_Access_ID"] = $ParentArray["Edit_Access_ID"]; if (!$Array["Subscribe_Access_ID"]) $Array["Subscribe_Access_ID"] = $ParentArray["Subscribe_Access_ID"]; if (!$Array["Moderation_ID"]) $Array["Moderation_ID"] = $ParentArray["Moderation_ID"]; $Array["Parent_Section_ID"] = $ParentArray["Parent_Section_ID"]; } $res = mysql_query("SELECT * FROM `".(LOWER_CASE_TABLES ? "site" : "Site")."` WHERE `Site_ID`=".$ParentArray["Site_ID"], $LinkID); $ParentArray = mysql_fetch_assoc($res); mysql_free_result($res); if (!$Array["Template_ID"]) $Array["Template_ID"] = $ParentArray["Template_ID"]; if (!$Array["Read_Access_ID"]) $Array["Read_Access_ID"] = $ParentArray["Read_Access_ID"]; if (!$Array["Write_Access_ID"]) $Array["Write_Access_ID"] = $ParentArray["Write_Access_ID"]; if (!$Array["Edit_Access_ID"]) $Array["Edit_Access_ID"] = $ParentArray["Edit_Access_ID"]; if (!$Array["Subscribe_Access_ID"]) $Array["Subscribe_Access_ID"] = $ParentArray["Subscribe_Access_ID"]; if (!$Array["Moderation_ID"]) $Array["Moderation_ID"] = $ParentArray["Moderation_ID"]; return $Array; } ############################################################################### function AskForSectionObjectAddition() { global $LinkID, $loc, $systemDataID; echo _LANG_SEC_ADD_SUCCESS."

"; echo ""._LANG_SEC_ADD_OBJ." | ParentSectionID?"ParentSectionID=".$loc->ParentSectionID:"SiteID=".$loc->SiteID).">"._LANG_BACK_SEC_LIST.""; } ?>index.php000066600000016630150472607030006402 0ustar00"._LANG_SITE.""; $Title2 = _LANG_SECTIONS; $Title3 = ""._LANG_SITES.""; $Title4 = _LANG_SECTION_ADD; $Title5 = GetSectionNameByID ($SectionID); $Title8 = _LANG_SECTION_PROPERTIES; $Title9 = _LANG_DELETE_CONFIRM; $Title10 = _LANG_OBJ_MOVE; $Title11 = _LANG_SECTIONS; $SiteURL = "http://".$ADMIN_DOMAIN."/site/?step=2&type=2&SiteID="; $SectionURL = "http://".$ADMIN_DOMAIN."/section/?step=5&SectionID="; if ($step==13) $ParentSectionID = $NewParentSectionID; $loc = new SectionLocation ($SiteID, $ParentSectionID, $SectionID); if (!isset($step)) $step=0; $sh = new SectionHierarchy ($Delimeter, $SiteURL, $SectionURL); switch ($step) { case 0: # покажем полный рубрикатор BeginHtml ($Title0, $Title0, 17); ShowFullSectionList (); break; case 1: # покажем список рубрик BeginHtml ($Title2, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title11, 17); ShowSectionList (); break; case 2: # покажем форму добавления рубрики BeginHtml ($Title4, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title4, 17); SectionForm (3, "./", 1); break; case 3: # собственно добавим рубрику BeginHtml ($Title2, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title11, 17); $perm->ExitIfGuest (); if ($SiteID) { $perm->ExitIfNotSupervisorManagerSiteAdmin ($SiteID); } else { $perm->ExitIfNotSupervisorManagerSiteSectionAdmin (GetSiteBySection($ParentSectionID), $ParentSectionID); } if ($submit == 1) { if (!$Section_Name) { // print _LANG_SECTION_ERROR1; SectionForm (3, "./", 1, _LANG_SECTION_ERROR1); break; } if ( !IsAllowedSectionLinkName ($LinkName, $loc->ParentSectionID, 0, $loc->SiteID) ) { // print _LANG_SECTION_ERROR2; SectionForm (3, "./", 1, _LANG_SECTION_ERROR2); break; } if ( strspn(strtolower($LinkName), "abcdefghijklmnopqrstuvwxyz0123456789_-") != strlen($LinkName) ) { // print _LANG_SECTION_ERROR3; SectionForm (3, "./", 1, _LANG_SECTION_ERROR3); break; } if (ActionSectionCompleted ($type)) { ShowFullSectionList(_LANG_SECTION_ADDED); }else{ ShowFullSectionList(_LANG_CMS_ERROR); } } break; case 4: # покажем меню операций для рубрики // *************** Deprecated ************** BeginHtml ($Title5, $Title1.$Delimeter.$sh->Link, 18); ShowSectionMenu ($SectionID, 9, "./", 5, "./", 12, "./"); break; case 5: # покажем форму для редактирования рубрики BeginHtml ($Title8, $Title1.$Delimeter.$sh->Link, 18); SectionForm (6, "./", 2); break; case 6: # собственно проапдейтим рубрику BeginHtml ($Title2, $Title1.$Delimeter.$sh->Link, 18); $perm->ExitIfGuest (); if ( !($perm->isSupervisor() || $perm->isManager() || $perm->isSiteAdmin ( GetSiteBySection($SectionID) ) || $perm->isSectionAdmin($SectionID) ) ) { NoRightsMessage(); EndHtml (); exit; } if ($submit == 1) { if (!$Section_Name) { // print _LANG_SECTION_ERROR1; SectionForm (6, "./", 2, _LANG_SECTION_ERROR1); break; } if ( !IsAllowedSectionLinkName ($LinkName, $loc->ParentSectionID, $loc->SectionID, $loc->SiteID) ) { // print _LANG_SECTION_ERROR2; SectionForm (6, "./", 2,_LANG_SECTION_ERROR2); break; } if ( strspn(strtolower($LinkName), "abcdefghijklmnopqrstuvwxyz0123456789_-") != strlen($LinkName) ) { // print _LANG_SECTION_ERROR3; SectionForm (6, "./", 2, _LANG_SECTION_ERROR3); break; } if (ActionSectionCompleted ($type)) { // ShowSectionMenu ($SectionID, 9, "./", 5, "./", 12, "./"); ShowFullSectionList(_LANG_SECTION_ADDED); } } else if ($submit == 2) { FileUpload (); ShowSectionMenu ($SectionID, 9, "./", 5, "./", 12, "./"); } break; case 7: # спросить, действительно ли надо удалить рубрику if (CheckIfDelete()) { BeginHtml ($Title9, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title9, 17); System_UpdateSectionPriority (); AscIfDeleteSection (11, "./"); } else { BeginHtml ($Title2, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title11, 17); $perm->ExitIfGuest (); $perm->ExitIfNotSupervisor (); System_UpdateSectionPriority (); ShowSectionList (); } break; case 11: # удалим несколько рубрик BeginHtml ($Title2, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title11, 17); $perm->ExitIfGuest (); $perm->ExitIfNotSupervisorManagerSiteAdmin ($SiteID); DeleteSection (); ShowFullSectionList (_LANG_SECTION_DELETED); break; # здесь не забудем, что номер 11 уже занят case 12: # покажем форму переноса рубрики в новую родительскую рубрику BeginHtml ($Title10, $Title1.$Delimeter.$sh->Link.$Delimeter.$Title10, 18); ChangeSectionParentForm (13, "./", $SectionID); break; case 13: # собственно перенесем рубрику в новую родительскую рубрику if ( $perm->isGuest () ) { BeginHtml ($Title2, $Title1.$Delimeter.$sh->NoLink, 18); NoRightsMessage(); EndHtml (); exit; } if ( !($perm->isSupervisor() || $perm->isManager() || $perm->isSiteAdmin ( GetSiteBySection($SectionID) ) ) ) { BeginHtml ($Title2, $Title1.$Delimeter.$sh->NoLink, 18); NoRightsMessage(); EndHtml (); exit; } $ErrorString = ChangeSectionParentCompleted ($SectionID, $NewParentSectionID); BeginHtml ($Title0, $Title1.$Delimeter.$sh->NoLink, 17); print $ErrorString; // ShowSectionMenu ($SectionID, 9, "./", 5, "./", 12, "./"); ShowFullSectionList(); break; case 15: # собственно скопируем рубрику (A.L. 10/12/12) if ( $perm->isGuest () || !($perm->isSupervisor() || $perm->isManager() || $perm->isSiteAdmin ( GetSiteBySection($SectionID) ) ) ) { BeginHtml ($Title2, $Title1.$Delimeter.$sh->NoLink, 18); NoRightsMessage(); EndHtml (); exit; } $CopyParentSectionID = $_REQUEST['CopyParentSectionID']; $ErrorString = CopySectionCompleted ($SectionID, $CopyParentSectionID); BeginHtml ($Title0, $Title1.$Delimeter.$sh->NoLink, 17); print $ErrorString; // ShowSectionMenu ($SectionID, 9, "./", 5, "./", 12, "./"); ShowFullSectionList(); break; } EndHtml (); ?>

	—			—
	—			—