<?php require_once('../Connections/connBaseAntiga.php'); ?>

<?php

    session_start();

    require("sessao.php");

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

  if (PHP_VERSION < 6) {

    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  }

 

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

 

  switch ($theType) {

    case "text":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;    

    case "long":

    case "int":

      $theValue = ($theValue != "") ? intval($theValue) : "NULL";

      break;

    case "double":

      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

      break;

    case "date":

      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

      break;

    case "defined":

      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

      break;

  }

  return $theValue;

 

$logoutAction = $_SERVER['PHP_SELF']."?doLogout=true";

if ((isset($_SERVER['QUERY_STRING'])) && ($_SERVER['QUERY_STRING'] != "")){

  $logoutAction .="&". htmlentities($_SERVER['QUERY_STRING']);

 

if ((isset($_GET['doLogout'])) &&($_GET['doLogout']=="true")){

  //to fully log out a visitor we need to clear the session varialbles

  $_SESSION['MM_Username'] = NULL;

  $_SESSION['MM_UserGroup'] = NULL;

  $_SESSION['PrevUrl'] = NULL;

  unset($_SESSION['MM_Username']);

  unset($_SESSION['MM_UserGroup']);

  unset($_SESSION['PrevUrl']);

   

  $logoutGoTo = "index.php";

  if ($logoutGoTo) {

    header("Location: $logoutGoTo");

    exit;

  }

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "frm_not")) {

       

        if(is_uploaded_file($_FILES['not_imagem']['tmp_name'])){

        // variáveis criadas para o funcionamento do upload //

        $imagem_type = $_FILES['type'];

        $arquivo = $_FILES['not_imagem'];

        $vetFile = explode('.',$_FILES[$id_arquivo]['name']);

        $extensao = $vetFile[count($vetFile)-1];

        //gera nome da foto da noticia atraves do titulo da noticia

        $arquivo_nome = 'not'.'_'.date('d_m_Y').'_'.md5(rand(1,9182930495).date('ymdhsi')).$extensao;

       

        //$arquivo_nome = 'not'.'_'.date('d_m_Y').'_'.md5(rand(1,9182930495).date('ymdhsi'));

 

        //diretorio aonde salvara as imagens

        $caminho_imagem = "imgs_not/".$arquivo_nome;

 

         if( $imagem_type <> 'image/gif' AND

             $imagem_type <> 'image/pjpeg' AND

             $imagem_type <> 'image/jpeg' AND

             $imagem_type <> 'image/png') {

          /*verifica o tipo da imagem*/

          $erros=1;

          $Mensagem = "Tipo de arquivo inválido";

        }      

    }

   

    // variáveis upLoad //

    $insertSQL = sprintf("INSERT INTO tb_noticia (sinopse_noticia,

                       GetSQLValueString($_POST['not_sinopse'], "text"),

                       GetSQLValueString($_POST['not_titulo'], "text"),

                       GetSQLValueString($_POST['not_texto'], "text"),

                       GetSQLValueString($arquivo_nome, "text"),

                       GetSQLValueString($_POST['usuario'], "text"),

                       GetSQLValueString(date('Y-m-d'), "text"),

                       GetSQLValueString($_POST['not_destaque'], "text"),

                       GetSQLValueString($_POST['not_status'], "text"),

                       GetSQLValueString('1', "text"));

 

  //código Upload //  

  set_time_limit(0);

  $diretorio = "imgs_not";

  $id_arquivo = "not_imagem";

 // $nome_arquivo = $_FILES[$id_arquivo]['name'];

  $arquivo_temporario = $_FILES[$id_arquivo]["tmp_name"];

  move_uploaded_file($arquivo_temporario, "$diretorio/arquivo_nome");

  //fim código Upload //

   

    /*

 

  mysql_select_db($database_connBaseAntiga, $connBaseAntiga);

  $Result1 = mysql_query($insertSQL, $connBaseAntiga) or die(mysql_error());

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Projeto: Portal de Not&iacute;cias [ &Aacute;rea Administrativa ]</title>

<script type="text/javascript" src="../jscripts/tiny_mce/tiny_mce.js"></script>

<script type="text/javascript">

    tinyMCE.init({

        // General options

        mode : "textareas",

        theme : "advanced",

        plugins : "safari,pagebreak,style,layer,table,save,advhr,advimage,advlink,emotions,iespell,inlinepopups,insertdatetime,preview,media,searchreplace,print,contextmenu,paste,directionality,fullscreen,noneditable,visualchars,nonbreaking,xhtmlxtras,template",

 

        // Theme options

        theme_advanced_buttons1 : "save,newdocument,|,bold,italic,underline,strikethrough,|,justifyleft,justifycenter,justifyright,justifyfull,styleselect,formatselect,fontselect,fontsizeselect",

        theme_advanced_buttons2 : "cut,copy,paste,pastetext,pasteword,|,search,replace,|,bullist,numlist,|,outdent,indent,blockquote,|,undo,redo,|,link,unlink,anchor,image,cleanup,help,code,|,insertdate,inserttime,preview,|,forecolor,backcolor",

        theme_advanced_buttons3 : "tablecontrols,|,hr,removeformat,visualaid,|,sub,sup,|,charmap,emotions,iespell,media,advhr,|,print,|,ltr,rtl,|,fullscreen",

        theme_advanced_buttons4 : "insertlayer,moveforward,movebackward,absolute,|,styleprops,|,cite,abbr,acronym,del,ins,attribs,|,visualchars,nonbreaking,template,pagebreak",

        theme_advanced_toolbar_location : "top",

        theme_advanced_toolbar_align : "left",

        theme_advanced_statusbar_location : "bottom",

        theme_advanced_resizing : false,

 

        // Example content CSS (should be your site CSS)

        content_css : "css/content.css",

 

        // Drop lists for link/image/media/template dialogs

        template_external_list_url : "lists/template_list.js",

        external_link_list_url : "lists/link_list.js",

        external_image_list_url : "lists/image_list.js",

        media_external_list_url : "lists/media_list.js",

 

        // Replace values for the template plugin

        template_replace_values : {

            username : "Some User",

            staffid : "991234"

        }

    });

</script>

<link href="css/style_portal_admin.css" rel="stylesheet" type="text/css" />

</head>

<body>

<div id="global">

<div id="topo">

        <h1>G.NEWS</h1>

    </div>

    <!-- / Head -->

   

    <div id="menu">

        <ul>

    <li><a href="indexNews.php" class="bts_Menu_Horiz">Listar Not&iacute;cias</a></li>

    <li><a href="noticia_inserir.php" class="bts_Menu_Horiz">Cadastrar Notícia</a></li>

    <li><a href="indexClipping.php" class="bts_Menu_Horiz">Listar Clipping</a></li>

    <li><a href="clipping_inserir.php" class="bts_Menu_Horiz">Cadastrar Clipping</a></li>

    <li id="bemvindo">Bem vindo(a),<strong><?php echo $_SESSION['usuario']; ?></strong>.</li>

    <li><a href="<?php echo $logoutAction ?>" class="bts_Menu_Horiz">Sair</a></li>

      </ul>

  </div>

    <!-- / Menu -->

       

  <div id="conteudo_admin">

  <div id="box_Titulos2"> <h1>Cadastrar Notícia</h1></div>

  <div id="box_centraliza_forms">

   

          <form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="frm_not" id="frm_not"  onsubmit="return submitForm();">

<table align="center" width="695px">

                <tr valign="baseline">

                  <td colspan="2" nowrap><strong>Chape&uacute;:</strong></td>

        </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap><input name="not_sinopse" type="text" id="not_sinopse" value="" size="60%" /></td>

              </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap>&nbsp;</td>

          </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap><strong>T&iacute;tulo:</strong></td>

        </tr>

                <tr valign="baseline">

                    <td colspan="2" nowrap><input type="text" name="not_titulo" value="" size="60%"></td>

        </tr>

                <tr valign="baseline">

                  <td colspan="2" valign="top" nowrap>&nbsp;</td>

          </tr>

                <tr valign="baseline">

                  <td colspan="2" valign="top" nowrap><strong>Mat&eacute;ria:</strong></td>

        </tr>

                <tr valign="baseline">

                    <td colspan="2" valign="top" nowrap><textarea name="not_texto" rows="25" id="not_texto"></textarea></td>

                    </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap>&nbsp;</td>

        </tr>

                <tr valign="baseline">

                  <td width="63" nowrap><strong>Imagem:</strong></td>

                  <td width="556" nowrap><input type="file" name="not_imagem" id="not_imagem" /></td>

        </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap>&nbsp;</td>

        </tr>

                <tr valign="baseline">

                  <td nowrap><strong>Destaque:</strong></td>

                  <td nowrap><select name="not_destaque">

                    <option value="M">Ativo</option>

                    <option value="D" selected="selected">Inativo</option>

                  </select></td>

        </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap>&nbsp;</td>

        </tr>

                <tr valign="baseline">

                    <td nowrap><strong>Status:</strong></td>

                    <td nowrap><select name="not_status">

                      <option value="A">Ativo</option>

                      <option value="I" selected="selected">Inativo</option>

                    </select></td>

                    </tr>

                <tr valign="baseline">

                  <td colspan="2" nowrap>&nbsp;</td>

        </tr>

                <tr valign="baseline">

                    <td colspan="2" align="center" nowrap><div id="box"><input type="submit" class="bts" value="Cadastrar Notícia" /></div></td>

                  </tr>

                </table>

<input type="hidden" name="not_usuario_id" />

<input type="hidden" name="MM_insert" value="frm_not" />

      <input name="usuario" type="hidden" value="<?php echo $_SESSION['login']; ?>" />

      </form></div>

    </div>

    <!-- / Conteudo Admin -->

       

<div id="rodape">

        <h4>Rodapé</h4>

    </div>

    <!-- / Rodapé -->

   

</div>

<!-- / Global -->

 

 

</body>

</html>