/**
* Actually perform the changes to the files
*
* @param string $root_node Asset ID of the root node to search for Files from
* @param int $setting The unrestricted setting to change assets to
* (0 = restricted, 1 = unrestricted)
* @param array $file_assretids assetid of all the file type assets found under the root node
*
* @return void
*/
function do_set_unrestricted($root_node, $setting, $file_assetids)
{
$GLOBALS['SQ_SYSTEM']->changeDatabaseConnection('db2');
$GLOBALS['SQ_SYSTEM']->doTransaction('BEGIN');
$return = array('changed' => 0, 'failed' => 0);
$root_asset = $GLOBALS['SQ_SYSTEM']->am->getAsset($root_node);
$child_query = $GLOBALS['SQ_SYSTEM']->am->generateGetChildrenQuery($root_asset, 'file', FALSE);
// Children query normally selects asset ID and type code. We don't want type code.
$child_query['sql_array']['select'] = str_replace(', a.type_code', '', $child_query['sql_array']['select']);
$child_query['sql_array']['union_select'] = str_replace(', null AS type_code', '', $child_query['sql_array']['union_select']);
$sql = 'SELECT assetid FROM sq_ast_attr_val';
$where = ' WHERE assetid IN (' . implode(' ', $child_query['sql_array']) . ')
AND attrid IN (SELECT attrid FROM sq_ast_attr
WHERE type_code IN (SELECT type_code FROM sq_ast_typ_inhd
WHERE inhd_type_code = :inhd_type_code)
AND name = :attr_name)
AND custom_val <> :setting';
$bind_vars = array('inhd_type_code' => 'file', 'attr_name' => 'allow_unrestricted', 'setting' => (int) $setting);
// Get the assets (so we can update their lookups later)\
try {
status_message_start('Finding files to change...');
$bind_vars = array_merge($bind_vars, $child_query['bind_vars']);
$query = MatrixDAL::preparePdoQuery($sql . $where);
foreach ($bind_vars as $bind_var => $bind_value) {
MatrixDAL::bindValueToPdo($query, $bind_var, $bind_value);
}
$result = array_keys(MatrixDAL::executePdoGroupedAssoc($query));
} catch (Exception $e) {
status_message_result('DB ERROR');
throw new Exception('Database error: ' . $e->getMessage());
}
// bug fix #4649 set_files_unrestricted.php doesn't change any assets
// since we have all the file type asset's assetid we will check and
// see if any of them has the attributes not set
$sql_query = 'SELECT assetid FROM sq_ast_attr_val l WHERE l.assetid IN (\'' . implode('\', \'', array_keys($file_assetids)) . '\') AND l.attrid IN (SELECT attrid FROM sq_ast_attr WHERE type_code IN (SELECT type_code FROM sq_ast_typ_inhd WHERE inhd_type_code = \'file\') AND name = \'allow_unrestricted\')';
$good_assets = MatrixDAL::executeSqlAssoc($sql_query);
$additional_assets = array_keys($file_assetids);
foreach ($good_assets as $good_asset) {
foreach ($additional_assets as $index => $additional_asset) {
if ($additional_assets[$index] == $good_asset['assetid']) {
unset($additional_assets[$index]);
}
}
}
status_message_result(count($result) + count($additional_assets) . ' assets to update');
// If there were any assets, update them in one hit, and then update
// the lookups
if (count($result) + count($additional_assets) > 0) {
status_message_start('Updating attributes...');
// update
try {
$update_sql = 'UPDATE sq_ast_attr_val SET custom_val = :new_setting';
$bind_vars['new_setting'] = (int) $setting;
$query = MatrixDAL::preparePdoQuery($update_sql . $where);
foreach ($bind_vars as $bind_var => $bind_value) {
MatrixDAL::bindValueToPdo($query, $bind_var, $bind_value);
}
MatrixDAL::execPdoQuery($query);
status_message_result('OK');
} catch (Exception $e) {
status_message_result('DB ERROR');
throw new Exception('Database error: ' . $e->getMessage());
}
// insert
foreach ($additional_assets as $additional_asset) {
$asset = $GLOBALS['SQ_SYSTEM']->am->getAsset($additional_asset);
$GLOBALS['SQ_SYSTEM']->setRunLevel(SQ_RUN_LEVEL_FORCED);
$asset->setAttrValue('allow_unrestricted', (int) $setting);
$asset->saveAttributes(TRUE);
$GLOBALS['SQ_SYSTEM']->restoreRunLevel();
}
$assetids_to_update = array_merge($result, $additional_assets);
$deja_vu = $GLOBALS['SQ_SYSTEM']->getDejaVu();
if ($deja_vu->enabled()) {
foreach ($assetids_to_update as $assetid) {
$deja_vu->forget('asset', $assetid);
}
//end foreach
}
//end if
// Now update lookups
status_message_start('Updating lookups...');
$hh = $GLOBALS['SQ_SYSTEM']->getHipoHerder();
$vars = array('assetids' => $assetids_to_update);
$errors = $hh->freestyleHipo('hipo_job_update_lookups', $vars);
if (empty($errors)) {
status_message_result('OK');
} else {
status_message_result('ERRORS');
pre_echo($errors);
}
}
$GLOBALS['SQ_SYSTEM']->doTransaction('COMMIT');
$GLOBALS['SQ_SYSTEM']->restoreDatabaseConnection();
}