private function _getProcessedTimeInHTML($time_start)
{
$time_end = $this->_getMicroTime();
$time = round($time_end - $time_start, 3);
$retour = BRLF . "Execution time: " . mb_sprintf("%02d:%02d:%02d", (int) ($time / 3600), (int) (fmod($time, 3600) / 60), (int) fmod(fmod($time, 3600), 60)) . BRLF . BRLF;
return $retour;
}
// add column "has_html" to table "files"
echo ('CommSy database, add table: log_error.'."\n");
$success = true;
$query = "CREATE TABLE `log_error` (
`id` int(11) NOT NULL auto_increment,
`datetime` datetime NOT NULL,
`number` int(11) NOT NULL,
`type` varchar(255) NOT NULL,
`message` text NOT NULL,
`file` varchar(255) NOT NULL,
`line` int(11) NOT NULL,
`context` int(11) NOT NULL,
`module` varchar(255) NOT NULL,
`function` varchar(255) NOT NULL,
`user` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM;";
$success = select($query);
if ($success) {
echo('[ <font color="#00ff00">done</font> ]<br/>'."\n");
} else {
echo('[ <font color="#ff0000">failed</font> ]<br/>'."\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";
?>
function getProcessedTimeInHTML ($time_start) {
$time_end = getmicrotime();
$time = round($time_end - $time_start,3);
$retour = LINEBREAK."Execution time: ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60)).LINEBREAK;
return $retour;
}
echo('</h3>'."\n");
echo '<script type="text/javascript">window.scrollTo(1,10000000);</script>'."\n";
flush();
include_once($script);
echo '<script type="text/javascript">window.scrollTo(1,10000000);</script>'."\n";
flush();
if ($success == FALSE) {
echo "<font color='#ff0000'><b> [failed]</b></font>"."\n";
break;
} else {
echo "<font color='#00ff00'><b> [done]</b></font>"."\n";
}
echo('<br>');
echo '<script type="text/javascript">window.scrollTo(1,10000000);</script>'."\n";
flush();
// um mysql eine verschnaufpause zwischen jedem script zu gönnen
sleep(5);
}
// end of execution time
$time_end = getmicrotime();
$time = round($time_end - $time_start_all,3);
echo "<br/><br/><b>".count($scripts)." scripts processed in ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60))." hours</b><br><br><br>\n";
echo '<script type="text/javascript">window.scrollTo(1,10000000);</script>';
echo('</body>'."\n");
echo('</html>'."\n");
flush();
?>
function _performQuery($mode = 'select')
{
if ($mode == 'count') {
$query = 'SELECT count(' . $this->addDatabasePrefix('dates') . '.item_id) AS count';
} elseif ($mode == 'id_array') {
$query = 'SELECT ' . $this->addDatabasePrefix('dates') . '.item_id';
} elseif ($mode == 'distinct') {
$query = 'SELECT DISTINCT ' . $this->addDatabasePrefix($this->_db_table) . '.*';
} else {
$query = 'SELECT ' . $this->addDatabasePrefix('dates') . '.*,
(
SELECT
COUNT(' . $this->addDatabasePrefix('annotations') . '.item_id)
FROM
' . $this->addDatabasePrefix('annotations') . '
WHERE
' . $this->addDatabasePrefix('annotations') . '.linked_item_id = ' . $this->addDatabasePrefix('dates') . '.item_id
) as count_annotations
';
}
$query .= ' FROM ' . $this->addDatabasePrefix('dates');
if (!empty($this->_search_array) || (isset($this->_sort_order) and $this->_sort_order == 'modificator' || $this->_sort_order == 'modificator_rev')) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('user') . ' AS people ON (people.item_id=' . $this->addDatabasePrefix('dates') . '.creator_id)';
// modificator_id (TBD)
//look in filenames of linked files for the search_limit
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('item_link_file') . ' ON ' . $this->addDatabasePrefix('dates') . '.item_id = ' . $this->addDatabasePrefix('item_link_file') . '.item_iid' . ' LEFT JOIN ' . $this->addDatabasePrefix('files') . ' ON ' . $this->addDatabasePrefix('item_link_file') . '.file_id = ' . $this->addDatabasePrefix('files') . '.files_id';
//look in filenames of linked files for the search_limit
}
// dates restricted by topics
if (isset($this->_topic_limit)) {
if ($this->_topic_limit == -1) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l21 ON';
$query .= ' l21.deletion_date IS NULL';
if (isset($this->_room_limit)) {
$query .= ' AND l21.context_id = "' . encode(AS_DB, $this->_room_limit) . '"';
}
$query .= ' AND (l21.first_item_type = "' . CS_TOPIC_TYPE . '" OR l21.second_item_TYPE = "' . CS_TOPIC_TYPE . '")';
$query .= ' AND (l21.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id OR l21.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id)';
// second part in where clause
} else {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l21 ON';
$query .= ' (l21.first_item_id = "' . encode(AS_DB, $this->_topic_limit) . '" OR l21.second_item_id = "' . encode(AS_DB, $this->_topic_limit) . '")';
$query .= ' AND l21.deletion_date IS NULL AND (l21.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id OR l21.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id)';
}
}
if (isset($this->_institution_limit)) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l121 ON ( l121.deletion_date IS NULL AND ((l121.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l121.second_item_type="' . CS_INSTITUTION_TYPE . '"))) ';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l122 ON ( l122.deletion_date IS NULL AND ((l122.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l122.first_item_type="' . CS_INSTITUTION_TYPE . '"))) ';
}
if (isset($this->_user_limit)) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS user_limit1 ON ( user_limit1.deletion_date IS NULL AND ((user_limit1.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND user_limit1.second_item_type="' . CS_USER_TYPE . '"))) ';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS user_limit2 ON ( user_limit2.deletion_date IS NULL AND ((user_limit2.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND user_limit2.first_item_type="' . CS_USER_TYPE . '"))) ';
}
if (isset($this->_assignment_limit) and isset($this->_related_user_limit)) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS related_user_limit1 ON ( related_user_limit1.deletion_date IS NULL AND ((related_user_limit1.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND related_user_limit1.second_item_type="' . CS_USER_TYPE . '"))) ';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS related_user_limit2 ON ( related_user_limit2.deletion_date IS NULL AND ((related_user_limit2.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND related_user_limit2.first_item_type="' . CS_USER_TYPE . '"))) ';
}
if (isset($this->_tag_limit)) {
$tag_id_array = $this->_getTagIDArrayByTagIDArray($this->_tag_limit);
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l41 ON ( l41.deletion_date IS NULL AND ((l41.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l41.second_item_type="' . CS_TAG_TYPE . '"))) ';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l42 ON ( l42.deletion_date IS NULL AND ((l42.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l42.first_item_type="' . CS_TAG_TYPE . '"))) ';
}
// restrict dates by buzzword (la4)
if (isset($this->_buzzword_limit)) {
if ($this->_buzzword_limit == -1) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('links') . ' AS l6 ON l6.from_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l6.link_type="buzzword_for"';
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('labels') . ' AS buzzwords ON l6.to_item_id=buzzwords.item_id AND buzzwords.type="buzzword"';
} else {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('links') . ' AS l6 ON l6.from_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l6.link_type="buzzword_for"';
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('labels') . ' AS buzzwords ON l6.to_item_id=buzzwords.item_id AND buzzwords.type="buzzword"';
}
}
// dates restricted by groups
if (isset($this->_group_limit)) {
if ($this->_group_limit == -1) {
$query .= ' LEFT JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l31 ON';
$query .= ' l31.deletion_date IS NULL';
if (isset($this->_room_limit)) {
$query .= ' AND l31.context_id = "' . encode(AS_DB, $this->_room_limit) . '"';
}
$query .= ' AND (l31.first_item_type = "' . CS_GROUP_TYPE . '" OR l31.second_item_TYPE = "' . CS_GROUP_TYPE . '")';
$query .= ' AND (l31.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id OR l31.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id)';
// second part in where clause
} else {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l31 ON';
$query .= ' (l31.first_item_id = "' . encode(AS_DB, $this->_group_limit) . '" OR l31.second_item_id = "' . encode(AS_DB, $this->_group_limit) . '")';
$query .= ' AND l31.deletion_date IS NULL AND (l31.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id OR l31.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id)';
}
}
if (isset($this->_ref_id_limit)) {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('link_items') . ' AS l5 ON ( (l5.first_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l5.second_item_id="' . encode(AS_DB, $this->_ref_id_limit) . '")
OR(l5.second_item_id=' . $this->addDatabasePrefix('dates') . '.item_id AND l5.first_item_id="' . encode(AS_DB, $this->_ref_id_limit) . '") AND l5.deleter_id IS NULL)';
}
// only files limit -> entries with files
if (isset($this->_only_files_limit) and $this->_only_files_limit) {
$query .= ' INNER JOIN ' . $this->addDatabasePrefix('item_link_file') . ' AS lf ON ' . $this->addDatabasePrefix($this->_db_table) . '.item_id = lf.item_iid';
}
$query .= ' WHERE 1';
if (!$this->_show_not_activated_entries_limit) {
$query .= ' AND (' . $this->addDatabasePrefix('dates') . '.modification_date IS NULL OR ' . $this->addDatabasePrefix('dates') . '.modification_date <= "' . getCurrentDateTimeInMySQL() . '")';
}
// fifth, insert limits into the select statement
if ($this->_future_limit) {
#$query .= ' AND (dates.datetime_end > NOW() OR dates.datetime_start > NOW())'; // this will not get all dates today
$date = date("Y-m-d") . ' 00:00:00';
$query .= ' AND (' . $this->addDatabasePrefix('dates') . '.datetime_end >= "' . encode(AS_DB, $date) . '" OR (' . $this->addDatabasePrefix('dates') . '.datetime_end="0000-00-00 00:00:00" AND ' . $this->addDatabasePrefix('dates') . '.datetime_start >= "' . encode(AS_DB, $date) . '") )';
}
if (isset($this->_room_array_limit) and !empty($this->_room_array_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.context_id IN (' . implode(", ", $this->_room_array_limit) . ')';
} elseif (isset($this->_room_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.context_id = "' . encode(AS_DB, $this->_room_limit) . '"';
}
if ($this->_delete_limit == true) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.deleter_id IS NULL';
}
if (isset($this->_ref_user_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.creator_id = "' . encode(AS_DB, $this->_ref_user_limit) . '"';
}
if (isset($this->_age_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.modification_date >= DATE_SUB(CURRENT_DATE,interval ' . encode(AS_DB, $this->_age_limit) . ' day)';
}
if (isset($this->_color_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.color = "' . encode(AS_DB, $this->_color_limit) . '"';
}
if (isset($this->_recurrence_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.recurrence_id = "' . encode(AS_DB, $this->_recurrence_limit) . '"';
}
if (isset($this->_existence_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.creation_date >= DATE_SUB(CURRENT_DATE,interval ' . encode(AS_DB, $this->_existence_limit) . ' day)';
}
// dates restricted by topics, second part
if (isset($this->_topic_limit) and $this->_topic_limit == -1) {
$query .= ' AND l21.first_item_id IS NULL AND l21.second_item_id IS NULL';
}
if (isset($this->_institution_limit)) {
if ($this->_institution_limit == -1) {
$query .= ' AND (l121.first_item_id IS NULL AND l121.second_item_id IS NULL)';
$query .= ' AND (l122.first_item_id IS NULL AND l122.second_item_id IS NULL)';
} else {
$query .= ' AND ((l121.first_item_id = "' . encode(AS_DB, $this->_institution_limit) . '" OR l121.second_item_id = "' . encode(AS_DB, $this->_institution_limit) . '")';
$query .= ' OR (l122.second_item_id = "' . encode(AS_DB, $this->_institution_limit) . '" OR l122.first_item_id = "' . encode(AS_DB, $this->_institution_limit) . '"))';
}
}
if (isset($this->_user_limit)) {
if ($this->_user_limit == -1) {
$query .= ' AND (user_limit1.first_item_id IS NULL AND user_limit1.second_item_id IS NULL)';
$query .= ' AND (user_limit2.first_item_id IS NULL AND user_limit2.second_item_id IS NULL)';
} else {
$query .= ' AND ((user_limit1.first_item_id = "' . encode(AS_DB, $this->_user_limit) . '" OR user_limit1.second_item_id = "' . encode(AS_DB, $this->_user_limit) . '")';
$query .= ' OR (user_limit2.first_item_id = "' . encode(AS_DB, $this->_user_limit) . '" OR user_limit2.second_item_id = "' . encode(AS_DB, $this->_user_limit) . '"))';
}
}
if (isset($this->_assignment_limit) and isset($this->_related_user_limit)) {
$query .= ' AND ( (related_user_limit1.first_item_id IN (' . implode(", ", $this->_related_user_limit) . ') OR related_user_limit1.second_item_id IN (' . implode(", ", $this->_related_user_limit) . ') )';
$query .= ' OR (related_user_limit2.first_item_id IN (' . implode(", ", $this->_related_user_limit) . ') OR related_user_limit2.second_item_id IN (' . implode(", ", $this->_related_user_limit) . ') ))';
}
// dates restricted by groups, second part
if (isset($this->_group_limit) and $this->_group_limit == -1) {
$query .= ' AND l31.first_item_id IS NULL AND l31.second_item_id IS NULL';
}
if (isset($this->_tag_limit)) {
$tag_id_array = $this->_getTagIDArrayByTagIDArray($this->_tag_limit);
$id_string = implode(', ', $tag_id_array);
if (isset($tag_id_array[0]) and $tag_id_array[0] == -1) {
$query .= ' AND (l41.first_item_id IS NULL AND l41.second_item_id IS NULL)';
$query .= ' AND (l42.first_item_id IS NULL AND l42.second_item_id IS NULL)';
} else {
$query .= ' AND ( (l41.first_item_id IN (' . encode(AS_DB, $id_string) . ') OR l41.second_item_id IN (' . encode(AS_DB, $id_string) . ') )';
$query .= ' OR (l42.first_item_id IN (' . encode(AS_DB, $id_string) . ') OR l42.second_item_id IN (' . encode(AS_DB, $id_string) . ') ))';
}
}
if (isset($this->_buzzword_limit)) {
if ($this->_buzzword_limit == -1) {
$query .= ' AND (l6.to_item_id IS NULL OR l6.deletion_date IS NOT NULL)';
} else {
$query .= ' AND buzzwords.item_id="' . encode(AS_DB, $this->_buzzword_limit) . '"';
}
}
if (isset($this->_day_limit)) {
$query .= ' AND DAYOFMONTH(' . $this->addDatabasePrefix('dates') . '.start_day) = "' . encode(AS_DB, $this->_day_limit) . '"';
}
if (isset($this->_month_limit) and isset($this->_year_limit)) {
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", $this->_month_limit) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", $this->_month_limit) . '-' . daysInMonth($this->_month_limit, $this->_year_limit);
$query .= ' AND ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
} elseif (isset($this->_month_limit2) and isset($this->_year_limit)) {
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", $this->_month_limit2) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", $this->_month_limit2) . '-' . daysInMonth($this->_month_limit2, $this->_year_limit);
$query .= ' AND ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . '';
if ($this->_month_limit2 == 1) {
$year = $this->_year_limit - 1;
$string_start_day = $year . '-' . mb_sprintf("%02d", 12) . '-' . '01';
$string_end_day = $year . '-' . mb_sprintf("%02d", 12) . '-' . daysInMonth(12, $year);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", 2) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", 2) . '-' . daysInMonth(2, $this->_year_limit);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
} elseif ($this->_month_limit2 == 12) {
$year = $this->_year_limit + 1;
$string_start_day = $year . '-' . mb_sprintf("%02d", 1) . '-' . '01';
$string_end_day = $year . '-' . mb_sprintf("%02d", 1) . '-' . daysInMonth(1, $year);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", 11) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", 11) . '-' . daysInMonth(11, $this->_year_limit);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
} else {
$month = $this->_month_limit2 - 1;
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", $month) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", $month) . '-' . daysInMonth($this->_month_limit2, $this->_year_limit);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
$month = $this->_month_limit2 + 1;
$string_start_day = $this->_year_limit . '-' . mb_sprintf("%02d", $month) . '-' . '01';
$string_end_day = $this->_year_limit . '-' . mb_sprintf("%02d", $month) . '-' . daysInMonth($month, $this->_year_limit);
$query .= ' OR ( ' . ' (' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_start_day) . '" AND "' . encode(AS_DB, $string_end_day) . '" <= ' . $this->addDatabasePrefix('dates') . '.end_day AND (' . $this->addDatabasePrefix('dates') . '.end_day IS NOT NULL OR ' . $this->addDatabasePrefix('dates') . '.end_day !=""))' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.start_day AND ' . $this->addDatabasePrefix('dates') . '.start_day <="' . encode(AS_DB, $string_end_day) . '")' . ' OR ("' . encode(AS_DB, $string_start_day) . '"<= ' . $this->addDatabasePrefix('dates') . '.end_day AND ' . $this->addDatabasePrefix('dates') . '.end_day <="' . encode(AS_DB, $string_end_day) . '")' . ')';
}
$query .= ' )';
}
if (isset($this->_date_mode_limit) and $this->_date_mode_limit != 2 and empty($this->_id_array_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix('dates') . '.date_mode="' . encode(AS_DB, $this->_date_mode_limit) . '"';
}
if (!empty($this->_id_array_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.item_id IN (' . implode(", ", encode(AS_DB, $this->_id_array_limit)) . ')';
}
// restrict sql-statement by search limit, create wheres
if (isset($this->_search_array) and !empty($this->_search_array)) {
$query .= ' AND (';
$field_array = array('TRIM(CONCAT(people.firstname," ",people.lastname))', $this->addDatabasePrefix('dates') . '.end_day', $this->addDatabasePrefix('dates') . '.start_day', $this->addDatabasePrefix('dates') . '.end_time', $this->addDatabasePrefix('dates') . '.start_time', $this->addDatabasePrefix('dates') . '.title', $this->addDatabasePrefix('dates') . '.description', $this->addDatabasePrefix('dates') . '.place', $this->addDatabasePrefix('files') . '.filename');
$search_limit_query_code = $this->_generateSearchLimitCode($field_array);
$query .= $search_limit_query_code;
$query .= ' )';
}
// init and perform ft search action
if (!empty($this->_search_array)) {
$query .= $this->initFTSearch();
}
// only files limit -> entries with files
if (isset($this->_only_files_limit) and $this->_only_files_limit) {
$query .= ' AND lf.deleter_id IS NULL AND lf.deletion_date IS NULL';
}
// $this->_not_older_than_limit
if (isset($this->_not_older_than_limit)) {
$query .= ' AND ' . $this->addDatabasePrefix($this->_db_table) . '.datetime_start > "' . $this->_not_older_than_limit . '"';
}
if (isset($this->_between_limit) && !empty($this->_between_limit)) {
$query .= "\n \t\t\tAND\n \t\t\t(\n \t\t\t\t(\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_start <= '" . $this->_between_limit["start"] . "' AND\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_end >= '" . $this->_between_limit["end"] . "'\n \t\t\t\t)\n \t\t\t\tOR\n \t\t\t\t(\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_start <= '" . $this->_between_limit["end"] . "' AND\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_end >= '" . $this->_between_limit["end"] . "'\n \t\t\t\t)\n \t\t\t\tOR\n \t\t\t\t(\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_start >= '" . $this->_between_limit["start"] . "' AND\n \t\t\t\t\t" . $this->addDatabasePrefix($this->_db_table) . ".datetime_end <= '" . $this->_between_limit["end"] . "'\n \t\t\t\t)\n \t\t\t)\n \t\t";
}
if (isset($this->_sort_order)) {
if ($this->_sort_order == 'place') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.place ASC';
} elseif ($this->_sort_order == 'place_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.place DESC';
} elseif ($this->_sort_order == 'time') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.datetime_start ASC';
} elseif ($this->_sort_order == 'time_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.datetime_start DESC';
} elseif ($this->_sort_order == 'title') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.title ASC';
} elseif ($this->_sort_order == 'title_rev') {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.title DESC';
}
} elseif ($this->_future_limit) {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.datetime_start ASC';
} else {
$query .= ' ORDER BY ' . $this->addDatabasePrefix('dates') . '.datetime_start DESC';
}
if ($mode == 'select') {
if (isset($this->_interval_limit) and isset($this->_from_limit)) {
$query .= ' LIMIT ' . encode(AS_DB, $this->_from_limit) . ', ' . encode(AS_DB, $this->_interval_limit);
}
}
// perform query
$result = $this->_db_connector->performQuery($query);
if (!isset($result)) {
include_once 'functions/error_functions.php';
trigger_error('Problems selecting dates.', E_USER_WARNING);
} else {
return $result;
}
}
// add column "has_html" to table "files"
echo ('links add x and y.'.LINEBREAK);
$success = true;
$query = "SHOW COLUMNS FROM links";
$result = select($query);
$column_array = array();
while ($row = mysql_fetch_assoc($result) ) {
$column_array[] = $row['Field'];
}
if ( in_array('x',$column_array) ) {
echo('nothing to do for x');
} else {
$query = "ALTER TABLE links ADD x INT NULL;";
$result = select($query);
echo('x done');
}
echo(LINEBREAK);
if ( in_array('y',$column_array) ) {
echo('nothing to do for y');
} else {
$query = "ALTER TABLE links ADD y INT NULL;";
$result = select($query);
echo('y done');
}
// end of execution time
$time_end = getmicrotime();
$time = round($time_end - $time_start,3);
echo LINEBREAK."Execution time: ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60)).LINEBREAK;
?>
$update_query = 'UPDATE server SET extras="'.addslashes(serialize($extras)).'" WHERE item_id=99;';
if ( !select($update_query) ) {
if ( empty($bash) or !$bash ) {
echo('<br/>Error while updating version number in server item.');
} else {
echo("\n".'Error while updating version number in server item.');
}
}
} else {
if ( empty($bash) or !$bash ) {
echo('<br/>Server Item not found.');
} else {
echo("\n".'Server Item not found.');
}
}
// end of execution time
$time_end = getmicrotime();
$time = round($time_end - $time_start_all,3);
if ( empty($bash) or !$bash ) {
echo "<br/><br/><b>".count($scripts)." scripts processed in ".sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60))." hours</b><br><br><br>\n";
echo '<script type="text/javascript">window.scrollTo(1,10000000);</script>';
echo('</body>'."\n");
echo('</html>'."\n");
} else {
echo(count($scripts)." scripts processed in ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60))." hours\n");
echo("\n");
}
flush();
?>
echo('Kein MessageTag passt zu den Einträgen der Whitelist.');
}
// show used
} elseif ($mode == 'show_used') {
showUsedTags();
// delete
} elseif ($mode == 'delete') {
if (isset($_POST['really_delete']) and $_POST['really_delete']) {
echo('</br>');
echo('Anzahl gelöschter MessageTags: '.count($_POST['orphans']).'</br>');
echo('Gelöschte MessageTags:</br>');
foreach ($_POST['orphans'] as $TagID) {
echo($TagID.'</br>');
}
} else {
echo('</br>');
echo('Keine Tags gelöscht, da die Sicherheitscheckbox nicht angeklickt wurde.');
}
}
echo('</form>');
$time_end = getmicrotime();
$time = round($time_end - $time_start,3);
echo('</br>');
echo("Execution time: ".mb_sprintf("%02d:%02d:%02d", (int)($time/3600), (int)(fmod($time,3600)/60), (int)fmod(fmod($time,3600), 60)));
?>
</body>
</html>
