* Copyright (c) 2002-2006 Platon Group, http://platon.sk/ * All rights reserved. * * See README file for more information about this software. * See COPYING file for license information. * * Download the latest version from * http://platon.sk/projects/phpMyEdit/ */ /* $Platon: phpMyEdit/extensions/phpMyEdit-messages.class.php,v 1.20 2017/06/09 15:02:37 igor Exp $ */ /* This extension is part of phpMyEzin: Content Management System project, where it handles discussion messages for particular articles. It depends on some phpMyEzin characteristics, thus extension should not and cannot be used outside this project. However there are planned some improvements for future to make this extension handle any kind of tree-structured data. */ require_once dirname(__FILE__).'/../phpMyEdit.class.php'; class phpMyEdit_messages extends phpMyEdit { // Record manipulation var $ezin_admin_article; // Operation var $deleteallinvalid; // Internal cache var $_cache_get_absolut_message_parent; function __construct($opts) /* {{{ */ { $execute = 1; isset($opts['execute']) && $execute = $opts['execute']; $opts['execute'] = 0; parent::__construct($opts); $this->tb2 = $opts['tb2']; $this->format_date = $opts['format_date']; $this->deleteallinvalid = $this->get_sys_cgi_var('operation'); $this->labels['Delete All'] = 'Delete All'; /* Preserved article ID in CGI environment. */ $this->ezin_admin_article = $this->get_data_cgi_var('article_id'); if ($this->ezin_admin_article <= 0) { $this->ezin_admin_article = $this->get_sys_cgi_var('ezin_admin_article_up'); } if ($this->ezin_admin_article <= 0) { $this->ezin_admin_article = $this->get_sys_cgi_var('ezin_admin_article_down'); } $this->ezin_admin_article = intval($this->ezin_admin_article); $execute && $this->execute(); } /* }}} */ function list_table() /* {{{ */ { $query = sprintf('SELECT article_id, count(id) AS messages FROM %s' .' GROUP BY article_id HAVING article_id = %d', $this->tb, intval($this->ezin_admin_article)); if (($result = $this->myquery($query)) == false) { return false; } $row = $this->sql_fetch($result, FETCH_ASSOC); //$ezin_admin_article = intval($row['article_id']); $ezin_admin_msgcount = intval($row['messages']); $this->sql_free_result($result); echo '

',"\n"; if ($this->nav_up() || $this->ezin_admin_article <= 0) { $this->message_nav_buttons($this->ezin_admin_article, $ezin_admin_msgcount, 'up'); echo '

',"\n"; } if ($this->ezin_admin_article> 0) { echo '',"\n"; echo '',"\n"; foreach (array('ID', 'Subject', ' ', 'Author', 'Date & Time', 'IP addresses') as $str) { echo '',"\n"; } echo '',"\n"; echo '',"\n"; echo '',"\n"; $message_ids = $this->message_process($this->ezin_admin_article, 0, 0); $count_message_ids = count($message_ids); if ($count_message_ids == 0) { echo '',"\n"; echo '',"\n"; } $query = sprintf('SELECT id, parent, article_id, author,' .' email, homepage, subject, datetime, ip' .' FROM %s WHERE article_id = %d ORDER BY datetime ASC', $this->tb, intval($this->ezin_admin_article)); if (($result = $this->myquery($query)) == false) { return false; } $all_ids = array(); $parents = array(); for ($i = 0; ($row = $this->sql_fetch($result, FETCH_ASSOC)); $i++) { $all_ids[] = $row['id']; $parents[$row['id']] = $row['parent']; } $this->sql_free_result($result); $all_ids = array_diff($all_ids, $message_ids); echo '',"\n"; echo '',"\n"; if (count($all_ids) > 0) { /* To force buttons */ $count_message_ids = -1; while (count($all_ids) > 0) { //echo "

all_ids: "; var_dump($all_ids);echo '
'; $sub_ids = $this->message_process($this->ezin_admin_article, $parents[array_shift($all_ids)], 0, true); $all_ids = array_diff($all_ids, $sub_ids); } } else { echo '

',"\n"; echo '',"\n"; } echo '

'; echo Platon::htmlspecialchars2($str),'
'; echo 'Valid messages
',"\n"; echo 'There are no valid messages for this article.'; echo '
'; echo 'Invalid messages'; if ($this->delete_enabled()) { echo ' '; echo $this->htmlSubmit('operation', $this->labels['Delete All'], $this->getCSSclass('delete'), false, false, 'onclick="return confirm(\'Realy delete ?\');"'); } echo '
',"\n"; echo 'There are no invalid messages for this article.'; echo '

'; } if ($this->nav_down() && $this->ezin_admin_article > 0) { echo '

',"\n"; $this->message_nav_buttons($this->ezin_admin_article, $ezin_admin_msgcount, 'down'); } // 2013-10-09 11:51 Igor //echo $this->htmlHiddenData('article_id', $ezin_admin_article); echo '

',"\n"; } /* }}} */ function message_process($article_id, $id, $level = 0, $parent = true) /* {{{ */ { $id = intval($id); $level = intval($level); $query = sprintf('SELECT id, parent, article_id, author,' .' email, homepage, subject, datetime, ip' .' FROM %s WHERE %s = %d AND article_id = %d' .' ORDER BY datetime ASC', $this->tb, $parent == true ? 'parent' : 'id', intval($id), intval($article_id)); if (($result = $this->myquery($query)) == false) { return false; } $ar = array(); $ar_out = array(); for ($i = 0; ($row = $this->sql_fetch($result, FETCH_ASSOC)); $i++) { $ar[$i] = $row; $ar_out[] = $row['id']; } $checked = ! $level && $parent ? ' checked' : ''; for ($i = 0; $i < count($ar); $i++) { echo '',"\n"; $css_class_name = $this->getCSSclass('cell', null, true); $css_class_name2 = $this->getCSSclass('navigation', null, true); echo '',$ar[$i]['id'],'',"\n"; echo ''; for ($j = 0; $j < $level; $j++) { echo ' '; } echo htmlspecialchars($ar[$i]['subject']); echo '',"\n"; echo ''; echo '',"\n"; echo '',htmlspecialchars($ar[$i]['author']), ''; echo '',htmlspecialchars($ar[$i]['datetime']),''; // TODO: do resolving echo ''; // this shoud be global IP-adress-deliminator $output = false; $ar_ip = preg_split('|([ ]*[ \\/,;]+[ ]*)|', $ar[$i]['ip'], -1, PREG_SPLIT_DELIM_CAPTURE); foreach ($ar_ip as $ip) { if (strlen($output) > 0) { $output = true; } $ip = htmlspecialchars($ip); if (preg_match('/^(\d{1,3}\.){3}\d{1,3}$/', $ip)) { echo ''; echo '',$ip,''; } else { echo $ip; } } if (! $output) { echo ' '; } echo '',"\n"; echo '',"\n"; if ($parent) { $ar_out = array_merge($ar_out, $this->message_process( $article_id, $ar[$i]['id'], $level + 1)); } strlen($checked) && $checked = ''; } return $ar_out; } /* }}} */ function message_nav_buttons($article_id, $messages_count, $position) /* {{{ */ { echo '',"\n"; echo '',"\n"; echo '',"\n"; echo '

',"\n"; $this->print_article_select($article_id, 0, $position); echo '

',"\n"; if ($article_id > 0) { if ($this->add_enabled()) { echo $this->htmlSubmit('operation', 'Add', $this->getCSSclass('add', $position), false, false); } if ($this->view_enabled()) { echo ' '; echo $this->htmlSubmit('operation', 'View', $this->getCSSclass('view', $position), false, $messages_count <= 0); } if ($this->change_enabled()) { echo ' '; echo $this->htmlSubmit('operation', 'Change', $this->getCSSclass('change', $position), false, $messages_count <= 0); } if ($this->delete_enabled()) { echo ' '; echo $this->htmlSubmit('operation', 'Delete', $this->getCSSclass('delete', $position), false, $messages_count <= 0); } } echo '

',"\n"; } /* }}} */ function display_record_buttons($position) /* {{{ */ { echo '',"\n"; echo '',"\n"; echo '',"\n"; if (strlen(@$this->message) > 0) { echo '',"\n"; } echo '',"\n"; echo '

',"\n"; $this->print_article_select($this->ezin_admin_article, 1, $position); echo '

',$this->message,'

',"\n"; if ($this->change_operation()) { echo $this->htmlSubmit('savechange', 'Save', $this->getCSSclass('save', $position), true), ' '; echo $this->htmlSubmit('morechange', 'Apply', $this->getCSSclass('more', $position), true), ' '; echo $this->htmlSubmit('cancelchange', 'Cancel', $this->getCSSclass('cancel', $position), false); } elseif ($this->add_operation()) { echo $this->htmlSubmit('saveadd', 'Save', $this->getCSSclass('save', $position), true), ' '; echo $this->htmlSubmit('moreadd', 'More', $this->getCSSclass('more', $position), true), ' '; echo $this->htmlSubmit('canceladd', 'Cancel', $this->getCSSclass('cancel', $position), false); } elseif ($this->delete_operation()) { echo $this->htmlSubmit('savedelete', 'Delete', $this->getCSSclass('save', $position), false), ' '; echo $this->htmlSubmit('canceldelete', 'Cancel', $this->getCSSclass('cancel', $position), false); } elseif ($this->view_operation()) { if ($this->change_enabled()) { echo $this->htmlSubmit('operation', 'Change', $this->getCSSclass('save', $position), false), ' '; } echo $this->htmlSubmit('cancelview', 'Cancel', $this->getCSSclass('cancel', $position), false); } // Message is now written here echo '

',"\n"; } /* }}} */ function print_article_select($selected_id, $disabled, $position) /* {{{ */ { if ($selected_id <= 0) { $rec = intval($this->get_sys_cgi_var('rec')); if ($rec > 0) { $query = sprintf('SELECT article_id FROM %s WHERE id = %d', $this->tb, $rec); $result = $this->myquery($query); if ($result != false) { $row = $this->sql_fetch($result, FETCH_NUM); $selected_id = $row[0]; } $this->sql_free_result($result); } } static $articles = null; if ($articles == null) { $articles = array(); $query = 'SELECT id, title, atitle, UNIX_TIMESTAMP(datetime) AS date' .' FROM '.$this->tb2 .' ORDER BY date DESC'; if (($result = $this->myquery($query)) == false) { return false; } for ($k = 0; ($row = $this->sql_fetch($result, FETCH_ASSOC)); $k++) { $articles[] = $row; } $this->sql_free_result($result); } echo '',"\n"; echo '',"\n"; foreach ($articles as $row) { $row['title'] = empty($row['title']) ? $row['atitle'] : $row['title']; $row['title'] = Platon::pretty_substr(strip_tags($row['title']), 40); echo '',$row['title']; if ($row['date'] > 0) { printf(' [%d] (%s)', $row['id'], date($this->format_date, $row['date'])); } echo '',"\n"; } echo '',"\n"; if ($disabled) { echo $this->htmlHiddenSys('ezin_admin_article_'.$position, $selected_id); } else { echo $this->htmlSubmit('ezin_admin_article_change_'.$position, ' > ', $this->get_sys_cgi_var('change', $position)), ' ', "\n"; } return true; } /* }}} */ function execute() { if ($this->deleteallinvalid == $this->labels['Delete All']) { $this->delete_enabled() && $this->do_delete_all_invalid_records(); $this->deleteallinvalid = null; } parent::execute(); } function get_absolut_message_parent($id) { $id = intval($id); if (isset($this->_cache_get_absolut_message_parent[$id])) { return $this->_cache_get_absolut_message_parent[$id]; } $query = sprintf('SELECT id, parent' .' FROM %s' .' WHERE id = %d', $this->tb, intval($id)); if (($result = $this->myquery($query)) == false) { return false; } $message = $this->sql_fetch($result, FETCH_ASSOC); if ($message == false) { $this->_cache_get_absolut_message_parent[$id] = false; return false; } $this->_cache_get_absolut_message_parent[$id] = ($message['parent'] == '0') ? $message['id'] : $this->get_absolut_message_parent($message['parent']); return $this->_cache_get_absolut_message_parent[$id]; } function get_invalid_messages($article_id) /* {{{ */ { $query = sprintf('SELECT *' .' FROM %s' .' WHERE article_id = %d' .' AND parent != 0', $this->tb, intval($article_id)); if (($result = $this->myquery($query)) == false) { return false; } $ar = array(); while ($row = $this->sql_fetch($result, FETCH_ASSOC)) { if ($this->get_absolut_message_parent($row['parent']) == false) { $ar[] = $row; } } return $ar; } function do_delete_all_invalid_records() { $invalids = $this->get_invalid_messages($this->ezin_admin_article); foreach ($invalids as $invalid) { $oldvals = $invalid; // Creating array of changed keys ($changed) $changed = is_array($oldvals) ? array_keys($oldvals) : array(); $newvals = array(); // Before trigger if ($this->exec_triggers('delete', 'before', $oldvals, $changed, $newvals) == false) { return false; } // Real query $query = 'DELETE FROM '.$this->tb.' WHERE ('.$this->key.' = ' .$this->key_delim.$invalid[$this->key].$this->key_delim.')'; // ) $res = $this->myquery($query, __LINE__); $this->message = $this->sql_affected_rows($this->dbh).' '.$this->labels['record deleted']; if (! $res) { return false; } // Notify list if (@$this->notify['delete'] || @$this->notify['all']) { $this->email_notify($oldvals, false); } // Note change in log table if ($this->logtable) { $query = sprintf('INSERT INTO %s' .' (updated, user, host, operation, tab, rowkey, col, oldval, newval)' .' VALUES (NOW(), "%s", "%s", "delete", "%s", "%s", "%s", "%s", "")', $this->logtable, addslashes($this->get_server_var('REMOTE_USER')), addslashes($this->get_server_var('REMOTE_ADDR')), addslashes($this->tb), addslashes($this->rec), addslashes($key), addslashes(serialize($oldvals))); $this->myquery($query, __LINE__); } // After trigger if ($this->exec_triggers('delete', 'after', $oldvals, $changed, $newvals) == false) { return false; } } return true; } } /* Modeline for ViM {{{ * vim:set ts=4: * vim600:fdm=marker fdl=0 fdc=0: * }}} */ ?>