<?php
/**
 *
 * @category        modules
 * @package         news
 * @author          WebsiteBaker Project
 * @copyright       WebsiteBaker Org. e.V.
 * @link            http://websitebaker.org/
 * @license         http://www.gnu.org/licenses/gpl.html
 * @platform        WebsiteBaker 2.8.3
 * @requirements    PHP 5.3.6 and higher
 * @version         $Id: modify_post.php 2 2017-07-02 15:14:29Z Manuela $
 * @filesource      $HeadURL: svn://isteam.dynxs.de/wb/2.10.x/trunk/modules/news/modify_post.php $
 * @lastmodified    $Date: 2017-07-02 17:14:29 +0200 (Sun, 02 Jul 2017) $
 *
 */

if ( !defined( 'WB_PATH' ) ){ require( dirname(dirname((__DIR__))).'/config.php' ); }

// $admin_header = true;
// Tells script to update when this page was last updated
$update_when_modified = false;
// show the info banner
$print_info_banner = true;
// Include WB admin wrapper script
require(WB_PATH.'/modules/admin.php');

$backlink = ADMIN_URL.'/pages/modify.php?page_id='.(int)$page_id;
$post_id = intval($admin->checkIDKEY('post_id', false, 'GET'));
if (!$post_id) {
   $admin->print_error($MESSAGE['GENERIC_SECURITY_ACCESS'], $backlink);
}

// Get header and footer
$sql  = 'SELECT * FROM `'.TABLE_PREFIX.'mod_news_posts` '
      . 'WHERE `post_id` = '.$post_id.' '
      . 'ORDER BY `position` ASC';
$query_content = $database->query($sql);
$fetch_content = $query_content->fetchRow(MYSQLI_ASSOC);

if (!defined('WYSIWYG_EDITOR') OR WYSIWYG_EDITOR=="none" OR !file_exists(WB_PATH.'/modules/'.WYSIWYG_EDITOR.'/include.php')) {
   function show_wysiwyg_editor($name,$id,$content,$width,$height) {
      echo '<textarea name="'.$name.'" id="'.$id.'" rows="10" cols="1" style="width: '.$width.'; height: '.$height.';">'.$content.'</textarea>';
   }
} else {
   $id_list=array("short","long");
   require(WB_PATH.'/modules/'.WYSIWYG_EDITOR.'/include.php');
}

// include jscalendar-setup
$jscal_use_time = true; // whether to use a clock, too
require_once(WB_PATH."/include/jscalendar/wb-setup.php");
?>
<h2><?php echo $TEXT['ADD'].'/'.$TEXT['MODIFY'].' '.$TEXT['POST']; ?></h2>
<div class="jsadmin jcalendar hide"></div>
<form name="modify" action="<?php echo WB_URL; ?>/modules/news/save_post.php" method="post" style="margin: 0;">
<?php echo $admin->getFTAN(); ?>
<input type="hidden" name="section_id" value="<?php echo $section_id; ?>" />
<input type="hidden" name="page_id" value="<?php echo $page_id; ?>" />
<input type="hidden" name="post_id" value="<?php echo $post_id; ?>" />

<table class="row_a news">
<tr>
   <td><?php echo $TEXT['TITLE']; ?>:</td>
   <td width="80%">
      <input type="text" name="title" value="<?php echo (htmlspecialchars($fetch_content['title'])); ?>" style="width: 98%;" maxlength="255" />
   </td>
</tr>
<tr>
   <td><?php echo $TEXT['GROUP']; ?>:</td>
   <td>
      <select name="group" style="width: 100%;">
         <option value="0"><?php echo $TEXT['NONE']; ?></option>
         <?php
         $sql = 'SELECT `group_id`, `title` FROM `'.TABLE_PREFIX.'mod_news_groups` '
         .'WHERE `section_id` = '.$section_id.' '
         .'ORDER BY `position` ASC';
         $query = $database->query($sql);
         if($query->numRows() > 0) {
            // Loop through groups
            while($group = $query->fetchRow(MYSQLI_ASSOC)) {
               ?>
               <option value="<?php echo $group['group_id']; ?>"<?php if($fetch_content['group_id'] == $group['group_id']) { echo ' selected="selected"'; } ?>><?php echo $group['title']; ?></option>
               <?php
            }
         }
         ?>
      </select>
   </td>
</tr>
<tr>
   <td><?php echo $TEXT['COMMENTING']; ?>:</td>
   <td>
      <select name="commenting" style="width: 100%;">
         <option value="none"><?php echo $TEXT['DISABLED']; ?></option>
         <option value="public" <?php if($fetch_content['commenting'] == 'public') { echo ' selected="selected"'; } ?>><?php echo $TEXT['PUBLIC']; ?></option>
         <option value="private" <?php if($fetch_content['commenting'] == 'private') { echo ' selected="selected"'; } ?>><?php echo $TEXT['PRIVATE']; ?></option>
      </select>
   </td>
</tr>
<tr>
   <td><?php echo $TEXT['ACTIVE']; ?>:</td>
   <td>
      <input type="radio" name="active" id="active_true" value="1" <?php if($fetch_content['active'] == 1) { echo ' checked="checked"'; } ?> />
      <a href="#" onclick="document.getElementById('active_true').checked = true;">
      <?php echo $TEXT['YES']; ?>
      </a>
      &nbsp;
      <input type="radio" name="active" id="active_false" value="0" <?php if($fetch_content['active'] == 0) { echo ' checked="checked"'; } ?> />
      <a href="#" onclick="document.getElementById('active_false').checked = true;">
      <?php echo $TEXT['NO']; ?>
      </a>
   </td>
</tr>
<tr>
   <td><?php echo $TEXT['PUBL_START_DATE']; ?>:</td>
   <td>
<?php
if ($fetch_content['published_when']==0) {
    $iPublishedWhen = date($jscal_format, strtotime((date('Y-m-d H:i')))+TIMEZONE);
} else {
    $iPublishedWhen = date($jscal_format, $fetch_content['published_when']+TIMEZONE);
}
?>
   <input type="text" id="publishdate" name="publishdate" value="<?php echo $iPublishedWhen;?>" style="width: 120px;" />
   <img src="<?php echo THEME_URL ?>/images/clock_16.png" id="publishdate_trigger" style="cursor: pointer;" title="<?php echo $TEXT['CALENDAR']; ?>" alt="<?php echo $TEXT['CALENDAR']; ?>" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" />
   <img src="<?php echo THEME_URL ?>/images/clock_del_16.png" style="cursor: pointer;" title="<?php echo $TEXT['DELETE_DATE']; ?>" alt="<?php echo $TEXT['DELETE_DATE']; ?>" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" onclick="document.modify.publishdate.value=''" />
   </td>
</tr>
<tr>
   <td><?php echo $TEXT['PUBL_END_DATE']; ?>:</td>
   <td>
<?php
if ($fetch_content['published_until']==0) {
    $iPublishedUntil = '';
} else {
    $iPublishedUntil = date($jscal_format, $fetch_content['published_until']+TIMEZONE);
}
?>
   <input type="text" id="enddate" name="enddate" value="<?php echo $iPublishedUntil;?>" style="width: 120px;" />
   <img src="<?php echo THEME_URL ?>/images/clock_16.png" id="enddate_trigger" style="cursor: pointer;" title="<?php echo $TEXT['CALENDAR']; ?>" alt="<?php echo $TEXT['CALENDAR']; ?>" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" />
   <img src="<?php echo THEME_URL ?>/images/clock_del_16.png" style="cursor: pointer;" title="<?php echo $TEXT['DELETE_DATE']; ?>" alt="<?php echo $TEXT['DELETE_DATE']; ?>" onmouseover="this.style.background='lightgrey';" onmouseout="this.style.background=''" onclick="document.modify.enddate.value=''" />
   </td>
</tr>
</table>

<table class="row_a news">
<tr>
   <td valign="top"><?php echo $TEXT['SHORT']; ?>:</td>
</tr>
<tr>
   <td>
<?php
      $contentShort = $fetch_content['content_short'];
      $contentLong = $fetch_content['content_long'];
      $sFilterApi = WB_PATH.'/modules/output_filter/OutputFilterApi.php';
      if (is_readable($sFilterApi)) {
          require_once($sFilterApi);
          $contentShort = OutputFilterApi('ReplaceSysvar', $contentShort);
          $contentLong  = OutputFilterApi('ReplaceSysvar', $contentLong);
      }
      show_wysiwyg_editor("short","short",htmlspecialchars($contentShort),"100%","200px");
   ?>
   </td>
</tr>
<tr>
   <td valign="top"><?php echo $TEXT['LONG']; ?>:</td>
</tr>
<tr>
   <td>
<?php
      show_wysiwyg_editor("long","long",htmlspecialchars($contentLong),"100%","650px");
?>
   </td>
</tr>
</table>

<table class="news">
<tr>
   <td align="left">
      <input name="save" type="submit" value="<?php echo $TEXT['SAVE']; ?>" style="width: 100px; margin-top: 5px;" />
   </td>
   <td align="right">
      <input type="button" value="<?php echo $TEXT['CANCEL']; ?>" onclick="javascript: window.location = '<?php echo ADMIN_URL; ?>/pages/modify.php?page_id=<?php echo $page_id; ?>';" style="width: 100px; margin-top: 5px;" />
   </td>
</tr>
</table>
</form>

<script type="text/javascript">
   Calendar.setup(
      {
         inputField  : "publishdate",
         ifFormat    : "<?php echo $jscal_ifformat ?>",
         button      : "publishdate_trigger",
         firstDay    : <?php echo $jscal_firstday ?>,
         <?php if(isset($jscal_use_time) && $jscal_use_time==TRUE)
            { ?>
            showsTime   : "true",
            timeFormat  : "24",
         <?php
            } ?>
         date        : "<?php echo $jscal_today ?>",
         range       : [1970, 2037],
         step        : 1
      }
   );
   Calendar.setup(
      {
         inputField  : "enddate",
         ifFormat    : "<?php echo $jscal_ifformat ?>",
         button      : "enddate_trigger",
         firstDay    : <?php echo $jscal_firstday ?>,
         <?php if(isset($jscal_use_time) && $jscal_use_time==TRUE)
            { ?>
            showsTime   : "true",
            timeFormat  : "24",
         <?php
            } ?>
         date        : "<?php echo $jscal_today ?>",
         range       : [1970, 2037],
         step        : 1
      }
   );
</script>

<br />

<h2><?php echo $TEXT['MODIFY'].'/'.$TEXT['DELETE'].' '.$TEXT['COMMENT']; ?></h2>

<?php

// Loop through existing posts
$query_comments = $database->query("SELECT * FROM `".TABLE_PREFIX."mod_news_comments` WHERE section_id = '$section_id' AND post_id = '$post_id' ORDER BY commented_when DESC");
if($query_comments->numRows() > 0) {
   $row = 'a';
   $pid = $admin->getIDKEY($post_id);
   ?>
   <table class="news">
<?php
   while($comment = $query_comments->fetchRow()) {
      $cid = $admin->getIDKEY($comment['comment_id']);
      ?>
      <tr class="row_<?php echo $row; ?>" >
         <td width="20" style="padding-left: 5px;">
            <a href="<?php echo WB_URL; ?>/modules/news/modify_comment.php?page_id=<?php echo $page_id; ?>&amp;section_id=<?php
               echo $section_id; ?>&amp;comment_id=<?php echo $cid; ?>" title="<?php echo $TEXT['MODIFY']; ?>">
               <img src="<?php echo THEME_URL; ?>/images/modify_16.png" border="0" alt="^" />
            </a>
         </td>
         <td>
            <a href="<?php echo WB_URL; ?>/modules/news/modify_comment.php?page_id=<?php echo $page_id; ?>&amp;section_id=<?php
               echo $section_id; ?>&amp;comment_id=<?php echo $cid; ?>">
               <?php echo $comment['title']; ?>
            </a>
         </td>
         <td width="20">
            <a href="javascript: confirm_link('<?php echo $TEXT['ARE_YOU_SURE']; ?>', '<?php
               echo WB_URL; ?>/modules/news/delete_comment.php?page_id=<?php echo $page_id; ?>&amp;section_id=<?php
               echo $section_id; ?>&amp;post_id=<?php echo $pid; ?>&amp;comment_id=<?php echo $cid; ?>');" title="<?php
               echo $TEXT['DELETE']; ?>">
               <img src="<?php echo THEME_URL; ?>/images/delete_16.png" border="0" alt="X" />
            </a>
         </td>
      </tr>
      <?php
      // Alternate row color
      if($row == 'a') {
         $row = 'b';
      } else {
         $row = 'a';
      }
   }
   ?>
   </table>
   <?php
} else {
   echo $TEXT['NONE_FOUND'];
}

// Print admin footer
$admin->print_footer();
