/**
* Runs this cron task.
*
* @return null
*/
public function run()
{
$sql = 'UPDATE ' . RATING_TABLE . ' SET
`top_hits_before` = `top_hits`,
`top_hosts_before` = `top_hosts`,
`top_in_before` = `top_in`,
`top_out_before` = `top_out`,
`top_hits` = 0,
`top_hosts` = 0,
`top_in` = 0,
`top_out` = 0
WHERE `top_id` BETWEEN 1 AND 100000
AND top_hosts > 1';
$this->db->sql_query($sql);
$this->db->sql_query('TRUNCATE TABLE ' . RATING_CLICK_TABLE);
$this->db->sql_query('TRUNCATE TABLE ' . RATING_HITS_TABLE);
$this->db->sql_query('TRUNCATE TABLE ' . RATING_ONLINE_TABLE);
$this->db->sql_query('OPTIMIZE TABLE ' . RATING_TABLE);
$this->db->sql_query('OPTIMIZE TABLE ' . RATING_CLICK_TABLE);
$this->db->sql_query('OPTIMIZE TABLE ' . RATING_HITS_TABLE);
$this->db->sql_query('OPTIMIZE TABLE ' . RATING_ONLINE_TABLE);
//$this->config->set('rating_platforms_active', 0);
$timestamp = time();
$timezone = new \DateTimeZone($this->config['board_timezone']);
$time = $this->user->get_timestamp_from_format('Y-m-d H:i:s', date('Y', $timestamp) . '-' . date('m', $timestamp) . '-' . date('d', $timestamp) . ' 00:00:00', $timezone);
$this->config->set('top_rating_last_gc', $time);
}
/**
* Deletes the users from the list, whose visit is to old.
*/
public function prune()
{
$timestamp = time();
if ($this->config['wwh_version']) {
/* OLD function
self::$prune_timestamp = gmmktime(0, 0, 0, gmdate('m', $timestamp), gmdate('d', $timestamp), gmdate('Y', $timestamp));
self::$prune_timestamp -= ($this->config['board_timezone'] * 3600);
self::$prune_timestamp -= ($this->config['board_dst'] * 3600);*/
// Correct Time Zone. https://www.phpbb.com/community/viewtopic.php?f=456&t=2297986&start=30#p14022491
$timezone = new \DateTimeZone($this->config['board_timezone']);
self::$prune_timestamp = $this->user->get_timestamp_from_format('Y-m-d H:i:s', date('Y', $timestamp) . '-' . date('m', $timestamp) . '-' . date('d', $timestamp) . ' 00:00:00', $timezone);
self::$prune_timestamp = self::$prune_timestamp < $timestamp - 86400 ? self::$prune_timestamp + 86400 : (self::$prune_timestamp > $timestamp ? self::$prune_timestamp - 86400 : self::$prune_timestamp);
} else {
self::$prune_timestamp = $timestamp - (3600 * $this->config['wwh_del_time_h'] + 60 * $this->config['wwh_del_time_m'] + $this->config['wwh_del_time_s']);
}
if (!isset($this->config['wwh_last_clean']) || $this->config['wwh_last_clean'] != self::$prune_timestamp || !$this->config['wwh_version']) {
$this->db->sql_return_on_error(true);
$sql = 'DELETE FROM ' . WWH_TABLE . '
WHERE wwh_lastpage <= ' . self::$prune_timestamp;
$result = $this->db->sql_query($sql);
$this->db->sql_return_on_error(false);
if ((bool) $result === false) {
// database does not exist yet...
return false;
}
if ($this->config['wwh_version']) {
$this->config->set('wwh_last_clean', self::$prune_timestamp);
}
}
// Purging was not needed or done succesfully...
return true;
}
/**
* Process adding dates
* @param \phpbb\event\data $event
* @param bool $is_member_or_owner
*/
protected function process_add_date($event, $is_member_or_owner)
{
$add_dates = $this->request->variable('add_date', '', true);
if (empty($add_dates)) {
return array();
}
if (!$is_member_or_owner) {
return array($this->user->lang('NOT_AUTH_HOOKUP'));
}
$hookup_errors = array();
$add_dates = array_map("trim", explode("\n", $add_dates));
//replace german date formats
$add_dates = preg_replace('#(\\d{1,2})\\. ?(\\d{1,2})\\. ?(\\d{2})[,:]?[,: ]#', '20$3-$2-$1 ', $add_dates);
$add_dates = preg_replace('#(\\d{1,2})\\. ?(\\d{1,2})\\. ?(\\d{4})[,:]?[,: ]#', '$3-$2-$1 ', $add_dates);
$date_added = false;
foreach ($add_dates as $date) {
$text_match = preg_match('#\\#(.*)#', $date, $text);
//strtotime uses the local (server) timezone, so parse manually and use gmmktime to ignore any timezone
if (!preg_match('#(\\d{4})-(\\d{1,2})-(\\d{1,2}) (\\d{1,2}):(\\d{2})#', $date) && !$text_match) {
$hookup_errors[] = "{$date}: {$this->user->lang['INVALID_DATE']}";
} else {
$hookup_continue = true;
if ($text_match) {
$text = trim($text[1]);
$date_time = '0';
} else {
$text = null;
$date_time = $this->user->get_timestamp_from_format('Y-m-d H:i', $date);
if ($date_time < time()) {
$hookup_continue = false;
$hookup_errors[] = "{$date}: {$this->user->lang['CANNOT_ADD_PAST']}";
}
}
if ($hookup_continue) {
//check for duplicate
if (!$this->hookup->add_date($date_time, $text)) {
$hookup_errors[] = sprintf($this->user->lang['DATE_ALREADY_ADDED'], $this->user->format_date($date_time, $text));
} else {
$date_added = true;
}
}
}
}
if ($date_added) {
// Notification
$notify_data = array('user_id' => $this->user->data['user_id'], 'topic_title' => $event['topic_data']['topic_title'], 'topic_id' => $event['topic_id'], 'forum_id' => $event['forum_id']);
$this->notification_manager->update_notifications('gn36.hookup.notification.type.date_added', $notify_data);
}
return $hookup_errors;
}
/**
* Process config change of survey
*
* @return array errors
*/
protected function process_config_change()
{
if (!check_form_key($this->form_key_name)) {
return array($this->user->lang('FORM_INVALID'));
}
$new_settings = array('caption' => '', 'show_order' => 0, 'reverse_order' => 0, 'allow_change_answer' => 0, 'allow_multiple_answer' => 0, 'visibility' => 0, 'stop_time' => '', 'default_hide' => 0);
if ($this->survey->is_moderator()) {
$new_settings['topic_poster_right'] = 0;
}
foreach ($new_settings as $setting => $default) {
$new_settings[$setting] = $this->request->variable('survey_setting_' . $setting, $default, true);
}
if ($new_settings['caption'] == '') {
return array($this->user->lang('SURVEY_INVALID_CAPTION'));
}
if (!in_array($new_settings['show_order'], survey::$SHOW_ORDER_TYPES)) {
return array($this->user->lang('SURVEY_INVALID_SHOW_ORDER_TYPE'));
}
$new_settings['reverse_order'] = $new_settings['reverse_order'] ? 1 : 0;
$new_settings['allow_change_answer'] = $new_settings['allow_change_answer'] ? 1 : 0;
$new_settings['allow_multiple_answer'] = $new_settings['allow_multiple_answer'] ? 1 : 0;
$new_settings['default_hide'] = $new_settings['default_hide'] ? 1 : 0;
if (!in_array($new_settings['visibility'], survey::$VISIBILITY_TYPES)) {
return array($this->user->lang('SURVEY_INVALID_VISIBILITY_TYPE'));
}
if ($new_settings['stop_time'] != '') {
$orig_input = $new_settings['stop_time'];
$new_settings['stop_time'] = $this->user->get_timestamp_from_format('Y-m-d H:i', $new_settings['stop_time']);
if ($new_settings['stop_time'] === false || $new_settings['stop_time'] + 60 < $this->survey->fixed_time() && $new_settings['stop_time'] != $this->survey->settings['stop_time']) {
return array($this->user->lang('SURVEY_INVALID_STOPDATE', $orig_input));
}
} else {
$new_settings['stop_time'] = null;
}
if ($this->survey->is_moderator()) {
if (!in_array($new_settings['topic_poster_right'], survey::$TOPIC_POSTER_RIGHT_TYPES)) {
return array($this->user->lang('SURVEY_INVALID_TOPIC_POSTER_RIGHT_TYPE'));
}
}
$this->survey->change_config($new_settings);
return array();
}
/**
* Process adding dates
* @param \phpbb\event\data $event
* @param bool $is_member_or_owner
*/
protected function process_add_date($event, $is_member_or_owner)
{
$add_dates = $this->request->variable('add_date', '', true);
if (empty($add_dates)) {
return array();
}
if (!$is_member_or_owner) {
return array($this->user->lang('NOT_AUTH_HOOKUP'));
}
$hookup_errors = array();
$add_dates = array_map("trim", explode("\n", $add_dates));
//replace german date formats
$add_dates = preg_replace('#(\\d{1,2})\\. ?(\\d{1,2})\\. ?(\\d{2})[,:]?[,: ]#', '20$3-$2-$1 ', $add_dates);
$add_dates = preg_replace('#(\\d{1,2})\\. ?(\\d{1,2})\\. ?(\\d{4})[,:]?[,: ]#', '$3-$2-$1 ', $add_dates);
$date_added = false;
foreach ($add_dates as $date) {
//strtotime uses the local (server) timezone, so parse manually and use gmmktime to ignore any timezone
if (!preg_match('#(\\d{4})-(\\d{1,2})-(\\d{1,2}) (\\d{1,2}):(\\d{2})#', $date, $m)) {
$hookup_errors[] = "{$date}: {$this->user->lang['INVALID_DATE']}";
} else {
$date_time = $this->user->get_timestamp_from_format('Y-m-d H:i', $date);
if ($date_time < time()) {
$hookup_errors[] = "{$date}: {$this->user->lang['CANNOT_ADD_PAST']}";
} else {
//check for duplicate
if (!$this->hookup->add_date($date_time)) {
$hookup_errors[] = sprintf($this->user->lang['DATE_ALREADY_ADDED'], $this->user->format_date($date_time));
} else {
$date_added = true;
}
}
}
}
if ($date_added) {
//notify members about new dates
if ($this->messenger == null) {
include_once $this->phpbb_root_path . 'includes/functions_messenger.' . $this->phpEx;
$this->messenger = new \messenger();
}
$messenger = $this->messenger;
$notify_users = array();
$notified_userids = array();
// Fetch users to be notified:
foreach ($this->hookup->hookup_users as $user_id => $user) {
if ($user['notify_status'] == 0) {
$notify_users[$user_id] = $user;
}
}
if (!empty($notify_users)) {
$sql = 'SELECT u.user_id, u.username, u.user_lang, u.user_email, u.user_jabber, u.user_notify_type
FROM ' . USERS_TABLE . ' u
WHERE ' . $this->db->sql_in_set('u.user_id', array_keys($notify_users));
$result = $this->db->sql_query($sql);
while ($row = $this->db->sql_fetchrow($result)) {
// TODO: Messenger ersetzen durch notification?
// https://www.phpbb.com/community/viewtopic.php?f=461&t=2259916#p13718356
$messenger->template('@gn36_hookup/hookup_dates_added', $row['user_lang']);
$messenger->to($row['user_email'], $row['username']);
$messenger->im($row['user_jabber'], $row['username']);
$messenger->assign_vars(array('USERNAME' => $row['username'], 'TOPIC_TITLE' => $event['topic_data']['topic_title'], 'U_TOPIC' => generate_board_url() . "/viewtopic.{$this->phpEx}?f={$event['forum_id']}&t={$event['topic_id']}"));
$messenger->send($row['user_notify_type']);
$notified_userids[] = $row['user_id'];
}
$this->db->sql_freeresult($result);
$messenger->save_queue();
//set notify status
foreach ($notified_userids as $user_id) {
$this->hookup->hookup_users[$user_id]['notify_status'] = 1;
}
}
}
return $hookup_errors;
}
