include_once('../migration.conf.php');
include_once('../db_link.dbi.php');
include_once('../update_functions.php');
// time management for this script
$time_start = getmicrotime();
// add column "has_html" to table "files"
echo ('CommSy database, table files: insert file size.'."\n");
$success = true;
$count = array_shift(mysql_fetch_row(select('SELECT COUNT(files_id) FROM files WHERE size="0"')));
if ($count < 1) {
echo "<br/>nothing to do.";
} else {
init_progress_bar($count);
$query = "SELECT * FROM files WHERE size='0'";
$success = select($query);
$query = 'SELECT files_id, files.context_id, filename, room.context_id AS portal_id FROM files INNER JOIN room ON files.context_id=room.item_id WHERE size="0"';
$result = select($query);
$row = mysql_fetch_row($result);
$item_id = $row[0];
$context_id = $row[1];
$filename = $row[2];
$portal_id = $row[3];
while ($item_id) {
$filename_on_disc = '../../var/'.$portal_id.'/'.$context_id.'/cid'.$context_id.'_'.$item_id.'_'.$filename;
if (file_exists($filename_on_disc)) {
$size = filesize($filename_on_disc);
include_once('../migration.conf.php');
include_once('../db_link.dbi.php');
include_once('../update_functions.php');
// time management for this script
$time_start = getmicrotime();
// move configuration of ads from cs_config to database
echo ('This script cleans up the ontology in the <HOMECONF>'."\n");
$success = true;
$count_project = array_shift(mysql_fetch_row(select("SELECT COUNT(room.item_id) FROM room WHERE extras LIKE '%ontology_%';")));
if ($count_project < 1) {
echo "<br/>nothing to do.";
} else {
init_progress_bar($count_project);
// project projects
$query = "SELECT room.item_id,extras FROM room WHERE extras LIKE '%ontology_%' ORDER BY room.item_id;";
$result = select($query);
$row = mysql_fetch_row($result);
$project_id = $row[0];
$extra = $row[1];
while ($project_id) {
$treffer = array();
$treffer2 = array();
$home_conf_exist = preg_match('~(<HOMECONF>(.+)</HOMECONF>)~u', $extra, $treffer);
if ($home_conf_exist == true) {
if (mb_strpos($extra,'ontology_')!=false){
$home_conf_string = str_replace(',ontology_short','',$treffer[2]);
$home_conf_string = str_replace(',ontology_tiny','',$home_conf_string);
if ($do_it) {
$result = mysql_query($query);
if ($error = mysql_error() ) {
echo $error.". QUERY: ".$query;
$success = false;
}
} else {
echo ('<br /><br />QUERY: '.$query);
}
// first get all rooms not deleted
$count_rooms = array_shift(mysql_fetch_row(mysql_query("SELECT COUNT(room.item_id) FROM room WHERE room.deletion_date IS NULL;")));
if ($count_rooms < 1) {
echo "<br />nothing to do.";
} else {
init_progress_bar($count_rooms);
$query = "SELECT room.item_id FROM room WHERE room.deletion_date IS NULL ORDER BY room.item_id;";
$result = mysql_query($query);
if ( $error = mysql_error() ) {
echo ('<hr>'.$error.". QUERY: ".$query.'<hr>');
}
$row = mysql_fetch_row($result);
$room_id = $row[0];
while ($room_id) {
// get group all for room
$query = "SELECT labels.item_id FROM labels WHERE labels.context_id='".$room_id."' AND labels.name='ALL';";
$result2 = mysql_query($query);
if ( $error = mysql_error() ) {
echo ('<hr>'.$error.". QUERY: ".$query.'<hr>');
}
$row2 = mysql_fetch_row($result2);
if ( !isset($translator) ) {
$translator = $environment->getTranslationObject();
}
$text_converter = $environment->getTextConverter();
echo($text_converter->encode(AS_HTML_SHORT,$translator->getMessage('FILE_ZIP_UPLOAD_PROCESS_TITLE',$file->getDisplayName())).BRLF);
flush();
#######################################
# process-bar 1
#######################################
$namearray = listfilenames($pfad,2,$file,$environment,$namearray);
#######################################
# process-bar 2
#######################################
init_progress_bar(count_for_process($namearray),$translator->getMessage('FILE_ZIP_UPLOAD_PROCESS_DESC'));
#######################################
# process-bar 2
#######################################
replace_files($pfad,2,$file,$environment,$namearray);
#######################################
# process-bar 3
#######################################
echo('</div>'.LF);
echo('<style type="text/css">'.LF.'div.process { display: none; }'.LF.'</style>'.LF);
flush();
#######################################
# process-bar 3
#######################################
global $c_pmwiki_absolute_path_file;
$str = "<?php include('".$c_pmwiki_absolute_path_file."/pmwiki.php');?>";
file_put_contents($directory.'/'.$entry,$str);
update_progress_bar($count);
}
}
}
include_once('../migration.conf.php');
include_once('../db_link.dbi.php');
include_once('../update_functions.php');
// time management for this script
$time_start = getmicrotime();
// add column "has_html" to table "files"
echo ('wiki: change path in index.php'."\n");
$success = true;
@include_once('../../etc/commsy/pmwiki.php');
if ( !empty($c_pmwiki_absolute_path_file) ) {
if ( is_dir($c_pmwiki_absolute_path_file) ) {
$num = countWikis($c_pmwiki_absolute_path_file.'/wikis');
init_progress_bar($num);
changeWikis($c_pmwiki_absolute_path_file.'/wikis',$num);
}
}
// end of execution time
echo(getProcessedTimeInHTML($time_start));
?>
$sql_array = array();
foreach ( $must_sort_father_array as $father_id ) {
$sql = 'SELECT * FROM tag WHERE item_id IN ('.implode(',',$children_array[$father_id]).') ORDER BY title';
$result = select($sql);
$new_place_array = array();
$place = 0;
while ( $row = mysql_fetch_assoc($result) ) {
$place++;
$new_place_array[$row['item_id']] = $place;
}
foreach ($children_array[$father_id] as $child_id) {
if ( !empty($new_place_array[$child_id]) ) {
$sql = 'UPDATE tag2tag SET sorting_place='.$new_place_array[$child_id].' WHERE from_item_id='.$father_id.' AND to_item_id='.$child_id.';';
$sql_array[] = $sql;
}
}
}
init_progress_bar(count(array_unique($sql_array)));
foreach ( array_unique($sql_array) as $sql ) {
$result = select($sql);
update_progress_bar(count(array_unique($sql_array)));
}
} else {
echo('<br/>nothing to do'."\n");
}
// end of execution time
$time_end = getmicrotime();
$time = round($time_end - $time_start,3);
echo "<br/>Execution time: ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60))."\n";
?>
echo(LINEBREAK);
$sql = 'SHOW TABLES;';
$result = select($sql,false,'utf8');
unset($sql);
$utf8_table_array = array();
while ($row = mysql_fetch_assoc($result) ) {
if ( stristr($row['Tables_in_'.$DB_Name],'utf8_') ) {
$utf8_table_array[] = $row['Tables_in_'.$DB_Name];
}
}
mysql_free_result($result);
unset($result);
unset($row);
init_progress_bar(count($utf8_table_array));
foreach ( $utf8_table_array as $table ) {
$sql = 'SHOW FULL COLUMNS FROM '.$table.';';
$result = select($sql,false,'utf8');
unset($sql);
$column_array = array();
while ($row = mysql_fetch_assoc($result) ) {
$column_array[] = $row;
}
mysql_free_result($result);
unset($result);
unset($row);
$sql = 'DROP TABLE IF EXISTS '.str_replace('utf8_','',$table).';';
$success_array[] = select($sql,false,'utf8');
unset($sql);
chdir('..');
include_once('../update_functions.php');
chdir('../..');
include_once('etc/cs_config.php');
echo('this script checks the php syntax<hr/>');
flush();
echo('count files: ');
flush();
$count_files = countFilesInDir('.');
echo($count_files);
echo('<br/>');
flush();
init_progress_bar($count_files);
$result_array = runFilesInDir('.');
if ( empty($result_array) ) {
echo('<br/>'.'keinen Fehler gefunden');
} else {
echo('<br/>'.'Fehler gefunden:');
foreach ($result_array as $error) {
echo('<br/>'.$error);
}
}
?>
