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>