/**
* Delete all objects from SubClass
*
* @param int SubClassID
*/
function SubClassClear($SubClassID)
{
global $nc_core, $db, $MODULE_FOLDER;
// full info about this subclass
$SubClassID = intval($SubClassID);
$res = $db->get_row("SELECT `Catalogue_ID`, `Subdivision_ID`, `Class_ID` FROM `Sub_Class` WHERE `Sub_Class_ID` = '" . $SubClassID . "'", ARRAY_A);
if (nc_module_check_by_keyword("comments")) {
include_once $MODULE_FOLDER . "comments/function.inc.php";
// delete comment rules
nc_comments::dropRuleSubClass($db, $SubClassID);
// delete comments
nc_comments::dropComments($db, $SubClassID, "Sub_Class");
}
DeleteSubClassFiles($SubClassID, $res['Class_ID']);
// delete from message
$messages_id = $db->get_col("SELECT `Message_ID` FROM `Message" . $res['Class_ID'] . "` WHERE `Subdivision_ID` = '" . $res['Subdivision_ID'] . "' AND `Sub_Class_ID` = '" . $SubClassID . "'");
if (!empty($messages_id)) {
if ($db->query("SELECT * FROM `Message" . $res['Class_ID'] . "` WHERE `Message_ID` IN (" . join(", ", $messages_id) . ")")) {
$messages_data = array_combine($db->get_col(NULL, 0), $db->get_results(NULL));
}
// execute core action
$nc_core->event->execute("dropMessagePrep", $res['Catalogue_ID'], $res['Subdivision_ID'], $SubClassID, $res['Class_ID'], $messages_id, $messages_data);
$db->query("DELETE FROM `Message" . $res['Class_ID'] . "` WHERE `Message_ID` IN (" . join(", ", $messages_id) . ")");
// execute core action
$nc_core->event->execute("dropMessage", $res['Catalogue_ID'], $res['Subdivision_ID'], $SubClassID, $res['Class_ID'], $messages_id, $messages_data);
}
return;
}
function ActionSubClassCompleted($type)
{
global $nc_core, $db, $ClassID;
global $loc, $ADMIN_FOLDER, $MODULE_FOLDER, $CustomSettings;
$params = array('Priority', 'Checked', 'SubClassName', 'EnglishName', 'Class_Template_ID', 'DefaultAction', 'isNakedCC', 'AllowTags', 'NL2BR', 'UseCaptcha', 'RecordsPerPage', 'SortBy', 'Read_Access_ID', 'Write_Access_ID', 'Cache_Lifetime', 'Edit_Access_ID', 'Checked_Access_ID', 'Delete_Access_ID', 'Moderation_ID', 'CacheAccessID', 'CacheLifetime', 'CacheForUser', 'CommentAccessID', 'Edit_Class_Template', 'CommentsEditRules', 'CommentsDeleteRules', 'SubClassID', 'SubdivisionID', 'CatalogueID', 'SrcMirror', 'Cache_Access_ID');
foreach ($params as $v) {
${$v} = $nc_core->input->fetch_get_post($v);
}
//транслитерация, если пустой EnglishName
if (empty($EnglishName)) {
$EnglishName = nc_transliterate($SubClassName, true);
}
// проверка на валидность
$EnglishName = nc_check_english_name((int) $SubClassID, $EnglishName, 2);
if (nc_module_check_by_keyword("comments")) {
include_once $MODULE_FOLDER . "comments/function.inc.php";
}
if (+$_POST['is_mirror']) {
$ClassID = $nc_core->sub_class->get_by_id(+$SrcMirror, 'Class_ID');
}
if ($Class_Template_ID == $ClassID) {
$Class_Template_ID = 0;
}
if ($Priority === '') {
$Priority = $db->get_var("SELECT (`Priority` + 1) FROM `Sub_Class` WHERE `Subdivision_ID` = '" . $loc->SubdivisionID . "' ORDER BY `Priority` DESC LIMIT 1");
}
if ($type == 1) {
if (nc_module_check_by_keyword("cache")) {
$cache_insert_fields = "`Cache_Access_ID`, `Cache_Lifetime`, `CacheForUser`,";
$cache_insert_values = "'" . $Cache_Access_ID . "', '" . $Cache_Lifetime . "', '" . $CacheForUser . "',";
} else {
$cache_insert_fields = "";
$cache_insert_values = "";
}
$insert = "INSERT INTO `Sub_Class` (" . $cache_insert_fields . "`Subdivision_ID`, `Catalogue_ID`, `Class_ID`, `Sub_Class_Name`, `Read_Access_ID`, `Write_Access_ID`, `Edit_Access_ID`, `Checked_Access_ID`, `Delete_Access_ID`, `Subscribe_Access_ID`, `Moderation_ID`, `Checked`, `Priority`, `EnglishName`, `DaysToHold`, `AllowTags`, `NL2BR`, `RecordsPerPage`, `SortBy`, `Created`, `DefaultAction`, `UseCaptcha`, `CustomSettings`, `Class_Template_ID`, `isNaked`, `SrcMirror`)";
$insert .= " VALUES (" . $cache_insert_values . "'" . $loc->SubdivisionID . "', '" . $loc->CatalogueID . "', '" . $ClassID . "', '" . $db->escape($SubClassName) . "', '" . $Read_Access_ID . "', '" . $Write_Access_ID . "', '" . $Edit_Access_ID . "', '" . $Checked_Access_ID . "','" . $Delete_Access_ID . "','" . $SubscribeAccessID . "', '" . $Moderation_ID . "', '" . $Checked . "', '" . $Priority . "', '" . $EnglishName . "', ";
$insert .= $DaysToHold == "" ? "NULL, " : "'" . $DaysToHold . "', ";
$insert .= "'" . $AllowTags . "', ";
$insert .= "'" . $NL2BR . "', ";
$insert .= $RecordsPerPage == "" ? "NULL" : "'" . $RecordsPerPage . "'";
$insert .= ",'{$SortBy}','" . date("Y-m-d H:i:s") . "','" . $DefaultAction . "', '" . $UseCaptcha . "', '" . addcslashes($CustomSettings, "'") . "', '" . $Class_Template_ID . "', '" . $isNakedCC . "', '" . $SrcMirror . "')";
// execute core action
$nc_core->event->execute("addSubClassPrep", $loc->CatalogueID, $loc->SubdivisionID, 0);
$db->query($insert);
// inserted ID
$insertedSubClassID = $db->insert_id;
// execute core action
$nc_core->event->execute("addSubClass", $loc->CatalogueID, $loc->SubdivisionID, $insertedSubClassID);
if (nc_module_check_by_keyword("comments")) {
if ($CommentAccessID > 0) {
// add comment relation
$CommentRelationID = nc_comments::addRule($db, array($loc->CatalogueID, $loc->SubdivisionID, $insertedSubClassID), $CommentAccessID, $CommentsEditRules, $CommentsDeleteRules);
// update inserted data
$db->query("UPDATE `Sub_Class` SET `Comment_Rule_ID` = '" . (int) $CommentRelationID . "' WHERE `Sub_Class_ID` = '" . (int) $insertedSubClassID . "'");
}
}
return $insertedSubClassID;
}
if ($type == 2) {
$cur_checked = $db->get_var("SELECT `Checked` FROM `Sub_Class` WHERE `Sub_Class_ID` = '" . $SubClassID . "'");
if (nc_module_check_by_keyword("comments")) {
$CommentData = nc_comments::getRuleData($db, array($loc->CatalogueID, $loc->SubdivisionID, $SubClassID));
$CommentRelationID = $CommentData['ID'];
switch (true) {
case $CommentAccessID > 0 && $CommentRelationID:
// update comment rules
nc_comments::updateRule($db, array($loc->CatalogueID, $loc->SubdivisionID, $SubClassID), $CommentAccessID, $CommentsEditRules, $CommentsDeleteRules);
break;
case $CommentAccessID > 0 && !$CommentRelationID:
// add comment relation
$CommentRelationID = nc_comments::addRule($db, array($loc->CatalogueID, $loc->SubdivisionID, $SubClassID), $CommentAccessID, $CommentsEditRules, $CommentsDeleteRules);
break;
case $CommentAccessID <= 0 && $CommentRelationID:
// delete comment rules
nc_comments::dropRuleSubClass($db, $SubClassID);
$CommentRelationID = 0;
break;
}
}
$update = "UPDATE `Sub_Class` SET ";
$update .= "`Sub_Class_Name` = '" . $db->escape($SubClassName) . "',";
$update .= "`Read_Access_ID` = '" . $Read_Access_ID . "',";
$update .= "`Write_Access_ID` = '" . $Write_Access_ID . "',";
$update .= "`Edit_Access_ID` = '" . $Edit_Access_ID . "',";
$update .= "`Checked_Access_ID` = '" . $Checked_Access_ID . "',";
$update .= "`Delete_Access_ID` = '" . $Delete_Access_ID . "',";
$update .= "`Subscribe_Access_ID` = '" . $SubscribeAccessID . "',";
if (nc_module_check_by_keyword("cache")) {
$update .= "`Cache_Access_ID` = '" . $Cache_Access_ID . "',";
$update .= "`Cache_Lifetime` = '" . $Cache_Lifetime . "',";
$update .= "`CacheForUser` = '" . $CacheForUser . "',";
}
if (nc_module_check_by_keyword("comments")) {
$update .= "`Comment_Rule_ID` = '" . $CommentRelationID . "',";
}
$update .= "`Moderation_ID` = '" . $Moderation_ID . "',";
$update .= "`Checked` = '" . $Checked . "',";
//$update.= "`Priority` = '" . $Priority . "',";
$update .= "`EnglishName` = '" . $EnglishName . "',";
$update .= "`DefaultAction` = '" . $DefaultAction . "',";
$update .= $DaysToHold == "" ? "`DaysToHold` = NULL," : "`DaysToHold` = '" . $DaysToHold . "',";
$update .= "`AllowTags` = '" . $AllowTags . "',";
$update .= "`NL2BR` = '" . $NL2BR . "',";
$update .= $RecordsPerPage == "" ? "`RecordsPerPage` = NULL," : "`RecordsPerPage` = '" . $RecordsPerPage . "',";
$update .= "`SortBy` = '" . $SortBy . "',";
$update .= "`UseCaptcha` = '" . $UseCaptcha . "', ";
$update .= "`CustomSettings` = '" . $db->escape(addcslashes($CustomSettings, "'")) . "', ";
$update .= "`Class_Template_ID` = '" . $Class_Template_ID . "', ";
$update .= "`Edit_Class_Template` = '" . $Edit_Class_Template . "', ";
$update .= "`isNaked` = '" . $isNakedCC . "', ";
$update .= "`SrcMirror` = '" . $SrcMirror . "', ";
$update .= "`AllowRSS` = '" . intval($nc_core->input->fetch_get_post('AllowRSS' . $SubClassID)) . "',";
$update .= "`AllowXML` = '" . intval($nc_core->input->fetch_get_post('AllowXML' . $SubClassID)) . "'";
$update .= " WHERE `Sub_Class_ID` = '" . $SubClassID . "'";
$subclass_data = $nc_core->sub_class->get_by_id($SubClassID);
$nc_core->event->execute("updateSubClassPrep", $subclass_data['Catalogue_ID'], $subclass_data['Subdivision_ID'], $SubClassID);
if ($cur_checked != $Checked) {
$nc_core->event->execute($Checked ? "checkSubClassPrep" : "uncheckSubClassPrep", $subclass_data['Catalogue_ID'], $subclass_data['Subdivision_ID'], $SubClassID);
}
$db->query($update);
if ($db->is_error) {
throw new nc_Exception_DB_Error($db->last_query, $db->last_error);
}
// execute core action
$nc_core->event->execute("updateSubClass", $subclass_data['Catalogue_ID'], $subclass_data['Subdivision_ID'], $SubClassID);
// произошло включение / выключение
if ($cur_checked != $Checked) {
$nc_core->event->execute($Checked ? "checkSubClass" : "uncheckSubClass", $subclass_data['Catalogue_ID'], $subclass_data['Subdivision_ID'], $SubClassID);
}
return $db->rows_affected;
}
}
function DeleteFromSubClass($subdivisionId)
{
global $nc_core, $db, $MODULE_FOLDER;
$res = $nc_core->sub_class->get_by_subdivision_id($subdivisionId);
$catalogueId = null;
$subClassToDelete = array();
$classIds = array();
foreach ((array) $res as $subClass) {
if (!$catalogueId) {
$catalogueId = $subClass['Catalogue_ID'];
}
$subClassToDelete[] = (int) $subClass['Sub_Class_ID'];
$classIds[$subClass['Sub_Class_ID']] = (int) $subClass['Class_ID'];
}
if (count($subClassToDelete) > 0) {
$nc_core->event->execute("dropSubClassPrep", $catalogueId, $subdivisionId, $subClassToDelete);
foreach ($subClassToDelete as $subClass) {
DeleteSubClassFiles($subClass, $classIds[$subClass]);
if (nc_module_check_by_keyword("comments")) {
include_once $MODULE_FOLDER . "comments/function.inc.php";
// delete comment rules
nc_comments::dropRuleSubClass($db, $subClass);
// delete comments
nc_comments::dropComments($db, $subClass, "Sub_Class");
}
$db->query("DELETE FROM `Sub_Class` WHERE `Sub_Class_ID` = {$subClass}");
}
$nc_core->event->execute("dropSubClass", $catalogueId, $subdivisionId, $subClassToDelete);
}
return;
}
