Overclock

asdasdasdasd aasd

teste aaaa aaa

teste

teste

asd

testantõ😇

<? include 'tema/topo.php'; ?>

        <?

$acao = antiSQL($_GET['acao']);		
$idblog = antiSQL($_GET['id_blog']);
$id_usuario = $_SESSION[id];		
		
$Inserir = antiSQL($_POST['Inserir']);
$Alterar = antiSQL($_POST['Alterar']);
$Excluir = antiSQL($_GET['Excluir']);
			

$noticia = mysqli_real_escape_string($conn, $_POST['noticia']);



$titulo = antiSQL($_POST['titulo']);

$data = antiSQL(date("d/m/Y"));		

include 'blog_anexos.php';	
		
if ($Inserir == "ok") {
mysqli_query($conn,"INSERT INTO blog (id_usuario,titulo,noticia,imagem,imagem2,imagem3,data) VALUES ('$id_usuario','$titulo','$noticia','$imagemb','$imagem2b','$imagem3b','$data')");
header('Location: blog.php?cadastrado_sucesso=sim');
}
		
if (!empty($imagemb)) {
$excluiarq_antigo = mysqli_query($conn,"SELECT imagem FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo['imagem']);
unlink('../'.$excluiarq_antigo['imagem']);		
mysqli_query($conn,"UPDATE blog SET imagem='$imagemb' WHERE id=$idblog");
}	
if (!empty($imagem2b)) {
$excluiarq_antigo2 = mysqli_query($conn,"SELECT imagem2 FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo2['imagem2']);
unlink('../'.$excluiarq_antigo2['imagem2']);		
mysqli_query($conn,"UPDATE blog SET imagem2='$imagem2b' WHERE id=$idblog");
}	
if (!empty($imagem3b)) {
$excluiarq_antigo3 = mysqli_query($conn,"SELECT imagem3 FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo3['imagem3']);
unlink('../'.$excluiarq_antigo3['imagem3']);		
mysqli_query($conn,"UPDATE blog SET imagem3='$imagem3b' WHERE id=$idblog");
}			
	

if ($Alterar == "ok"){
mysqli_query($conn,"UPDATE blog SET id_usuario='$id_usuario',titulo='$titulo',noticia='$noticia' WHERE id=$idblog");
	
header('Location: blog.php?alterado_sucesso=sim');
}else{
	echo 'Erro para Atualizar Usuário';
}

if ($Excluir == "ok") {
$excluiarq_antigo = mysqli_query($conn,"SELECT imagem FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo['imagem']);
unlink('../'.$excluiarq_antigo['imagem']);
$excluiarq_antigo2 = mysqli_query($conn,"SELECT imagem2 FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo2['imagem2']);
unlink('../'.$excluiarq_antigo2['imagem2']);	
$excluiarq_antigo3 = mysqli_query($conn,"SELECT imagem3 FROM blog WHERE id=$idblog")->fetch_assoc();
unlink($excluiarq_antigo3['imagem3']);
unlink('../'.$excluiarq_antigo3['imagem3']);	
mysqli_query($conn,"DELETE FROM blog WHERE id=$idblog");
header('Location: blog.php?deletado_sucesso=sim');
}

        ?>


        <!-- ============================================================== -->
        <!-- Page wrapper  -->
        <!-- ============================================================== -->
        <div class="page-wrapper">
            <!-- ============================================================== -->
            <!-- Container fluid  -->
            <!-- ============================================================== -->
            <div class="container-fluid">
                <!-- ============================================================== -->
                <!-- Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <div class="row page-titles">
                    <div class="col-md-5 align-self-center">
                        <h4 class="text-themecolor"><? $pagina = basename($_SERVER['PHP_SELF'],'.php');  echo ucfirst(strtolower($pagina)); ?></h4>
                    </div>
                    <div class="col-md-7 align-self-center text-end">
                        <div class="d-flex justify-content-end align-items-center">
                            <ol class="breadcrumb justify-content-end">
                                <li class="breadcrumb-item"><a href="index.php">Início</a></li>
                                <li class="breadcrumb-item active"><? $pagina = basename($_SERVER['PHP_SELF'],'.php');  echo ucfirst(strtolower($pagina)); ?></li>
                            </ol>
                         <button type="button" class="btn btn-info d-lg-block m-l-15" onclick="location.href='?acao=Inserir';"><i class="fa fa-plus-circle"></i> Adicionar
                         <? $pagina = basename($_SERVER['PHP_SELF'],'.php');  echo ucfirst(strtolower($pagina)); ?></button>
                        </div>
                    </div>
                </div>
                <!-- ============================================================== -->
                <!-- End Bread crumb and right sidebar toggle -->
                <!-- ============================================================== -->
                <!-- ============================================================== -->
                <!-- Info box -->
                <!-- ============================================================== -->
                <div class="row g-0">

                    <? if ($acao == "Alterar") {
                        $sql = mysqli_query($conn, "SELECT * FROM blog WHERE id=$idblog")->fetch_array();
                    } ?>


                    <? if ($acao != "") { ?>
                        <div class="smart-wrap">
                            <div class="smart-forms smart-container wrap-0">
                                <div class="form-header header-blue ">
                                    <h4><i class="fa fa-calendar-o"></i>Missão </h4>
                                </div><!-- end .form-header section -->



        <form name="usuarios" id="usuarios" method="post" action="<?php echo $PHP_SELF?>"
                        enctype="multipart/form-data">


                        <div class="form-body">



                            <div class="spacer-b30">
                                <div class="tagline"><span style="color: black"> Imagens</span></div><!-- .tagline -->
                            </div>

                            <div class="frm-row">
                                <div class="section colm colm3">
                                    <div align="center">
                                        <a href="<? echo BaseFoto().$sql['imagem']; ?>" target="_blank"><img
                                                src="<? echo BaseFoto().$sql['imagem']; ?>"
                                                class="rounded img-responsive" alt="" width="40" height="40"></a>
                                    </div>
                                </div>
                                <div class="section colm colm6">
                                    <label for="file1" class="field prepend-icon file">
                                        <span class="button btn-primary"> Anexar </span>
                                        <input type="file" class="gui-file" name="imagem" id="imagem"
                                            onChange="document.getElementById('imagemup').value = this.value;">
                                        <input type="text" class="gui-input" id="imagemup"
                                            placeholder="Adicionar Imagem" readonly>
                                        <span class="field-icon"><i class="fa fa-upload"></i></span>
                                    </label>
                                </div><!-- end  section -->
                            </div><!-- end  section -->



                            <hr>
                            <div class="frm-row">
                                <div class="section colm colm3">
                                    <div align="center">
                                        <a href="<? echo BaseFoto().$sql['imagem2']; ?>" target="_blank"><img
                                                src="<? echo BaseFoto().$sql['imagem2']; ?>"
                                                class="rounded img-responsive" alt="" width="40" height="40"></a>
                                    </div>
                                </div>
                                <div class="section colm colm6">
                                    <label for="file1" class="field prepend-icon file">
                                        <span class="button btn-primary"> Anexar </span>
                                        <input type="file" class="gui-file" name="imagem2" id="imagem2"
                                            onChange="document.getElementById('imagem2up').value = this.value;">
                                        <input type="text" class="gui-input" id="imagem2up"
                                            placeholder="Adicionar Imagem 2" readonly>
                                        <span class="field-icon"><i class="fa fa-upload"></i></span>
                                    </label>
                                </div><!-- end  section -->
                            </div><!-- end  section -->



                            <hr>
                            <div class="frm-row">
                                <div class="section colm colm3">
                                    <div align="center">
                                        <a href="<? echo BaseFoto().$sql['imagem3']; ?>" target="_blank"><img
                                                src="<? echo BaseFoto().$sql['imagem3']; ?>"
                                                class="rounded img-responsive" alt="" width="40" height="40"></a>
                                    </div>
                                </div>
                                <div class="section colm colm6">
                                    <label for="file1" class="field prepend-icon file">
                                        <span class="button btn-primary"> Anexar </span>
                                        <input type="file" class="gui-file" name="imagem3" id="imagem3"
                                            onChange="document.getElementById('imagem3up').value = this.value;">
                                        <input type="text" class="gui-input" id="imagem3up"
                                            placeholder="Adicionar Imagem 3" readonly>
                                        <span class="field-icon"><i class="fa fa-upload"></i></span>
                                    </label>
                                </div><!-- end  section -->
                            </div><!-- end  section -->

                            <div class="spacer-b30">
                                <div class="tagline"><span style="color: black"> Informações Gerais </span></div>
                                <!-- .tagline -->
                            </div>
                            <div class="frm-row">
                                <div class="section colm colm3">

                                </div><!-- end section -->

                                <div class="section colm colm6">
                                    <label for="lastname" class="field prepend-icon">
                                        <input type="text" name="titulo" id="titulo" class="gui-input"
                                            placeholder="Titulo da Notícia" value="<? echo $sql['titulo']; ?>">
                                        <b class="tooltip tip-right-top"><b>Digite o <span style="color:#6CF;">Titulo da
                                                    Notícia</span> Exemplo: <span style="color:#6CF;"> Reportagem
                                                    Hoje</span></b></b>
                                        <span class="field-icon"><i class="fa fa-briefcase"></i></span>
                                    </label>
                                </div><!-- end section -->

                            </div><!-- end .frm-row section -->
                            <div class="frm-row">
                                <div class="section colm colm1"></div>
                                <div class="section colm colm10">

                                    <textarea class="summernote gui-textarea" id="noticia" name="noticia"
                                        placeholder="Escreva a Notícia" data-plugin-summernote
                                        data-plugin-options='{ "height": 180, "codemirror": { "theme": "ambiance" } }'><? echo $sql['noticia'];    ?></textarea>

                                </div>
                            </div>





                        </div>




                        <div class="form-footer" align="center">
                            <input type="hidden" name="id_blog" value="<? echo $idblog;?>">
                            <input type="hidden" name="<? echo $acao;?>" value="ok">
                            <input type="submit" class="button btn-blue" name="Submit" value="<? echo $acao;?>">

                        </div>

                    </form>
                            </div>
                        </div>


                        <div class="row page-titles">

                            <div class="col-md-7 align-self-center text-left">
                                <div class="d-flex justify-content align-items-center">

                                    <button type="button" class="btn btn-info d-lg-block m-l-15"
                                        onclick="location.href='blog.php';"><i class="fa fa-plus-circle"></i>
                                        Voltar</button>
                                </div>
                            </div>
                        </div>

                    <? } else { ?>


                        <div style="clear: both;"></div>


                        <div class="row">
                            <div class="col-sm-12">
                                <div class="card">

                                    <div class="card-block">

                                    <table id="advanced-table" class="table dt-responsive table-striped table-bordered nowrap"
                                width="100%">

                                <thead>

                                    <tr>
                                        <th style="width: 25px;">N° </th>
                                        <th>Dono</th>
                                        <th>Titulo</th>

                                        <th style="width: 45px;">Data</th>
                                        <th>Imagens</th>
                                        <th>Ações</th>
                                    </tr>

                                </thead>

                                <tfoot>

                                    <tr>
                                        <th style="width: 25px;">N° </th>
                                        <th>Dono</th>
                                        <th>Titulo</th>
                                        <th style="width: 45px;">Data</th>
                                        <th>Imagens</th>
                                        <th hidden=""> Ações</th>
                                    </tr>
                                </tfoot>

                                <tbody>
                                    <? $sqlblog = mysqli_query($conn,"SELECT * FROM blog order by id ASC");
while ($blog = mysqli_fetch_array($sqlblog)) { ?>

                                    <tr>
                                        <td style="width: 25px;">
                                            <? echo $blog[id]; ?>
                                        </td>
                                        <td>
                                            <? $usuario = mysqli_query($conn,"SELECT nome FROM usuarios WHERE id=$blog[id_usuario]")->fetch_assoc(); echo $usuario['nome'];  ?>
                                        </td>
                                        <td>
                                            <? echo $blog[titulo]; ?>
                                        </td>


                                        <td style="width: 45px;">
                                            <? echo $blog[data]; ?>
                                        </td>

                                        <td>

                                            <div class="lightbox mb-4"
                                                data-plugin-options="{'delegate': 'a', 'type': 'image', 'gallery': {'enabled': true}}">
                                                <? if(!empty($blog[imagem])){ ?>
                                                <a class="img-thumbnail img-thumbnail-no-borders d-inline-block mb-1 mr-1"
                                                    href="<?php $img = $blog[imagem]; echo basefoto().$img;?>">
                                                    <img class="img-fluid"
                                                        src="<?php $img = $blog[imagem]; echo basefoto().$img;?>"
                                                        width="60" height="60" alt="Img">
                                                </a>
                                                <? } ?>
                                                <? if(!empty($blog[imagem2])){ ?>
                                                <a class="img-thumbnail img-thumbnail-no-borders d-inline-block mb-1 mr-1"
                                                    href="<?php $img2 = $blog[imagem2]; echo basefoto().$img2;?>">
                                                    <img class="img-fluid"
                                                        src="<?php $img2 = $blog[imagem2]; echo basefoto().$img2;?>"
                                                        width="60" height="60" alt="Img2">
                                                </a>
                                                <? } ?>
                                                <? if(!empty($blog[imagem3])){ ?>
                                                <a class="img-thumbnail img-thumbnail-no-borders d-inline-block mb-1 mr-1"
                                                    href="<?php $img3 = $blog[imagem3]; echo basefoto().$img3;?>">
                                                    <img class="img-fluid"
                                                        src="<?php $img3 = $blog[imagem3]; echo basefoto().$img3;?>"
                                                        width="60" height="60" alt="Img3">
                                                </a>
                                                <? } ?>

                                            </div>

                                        <td style="width: 40px;"> <button type="button"
                                                class="btn waves-effect waves-light btn-outline-info"
                                                data-toggle="tooltip" data-placement="top" title=""
                                                data-original-title="Editar" aria-describedby="tooltip647345"><a
                                                    href="?acao=Alterar&id_blog=<?php echo $blog[id];?>"><i
                                                        class="fa fa-edit"
                                                        style="font-size:20px; color:#0A94E1"></i></a>
                                            </button>

                                            <button type="button"
                                                class="btn btn-inverse-danger waves-effect waves-light "
                                                data-toggle="tooltip" data-placement="top" title=""
                                                data-original-title="Excluir"><a
                                                    href="?Excluir=ok&id_blog=<? echo $blog[id]; ?>"
                                                    onClick="return pergunta();"><i class="fa fa-trash"
                                                        style="font-size:20px; color:#C80306"></i></a>
                                            </button>
                                        </td>

                                        </td>
                                    </tr>

                                    <? } ?>

                                </tbody>

                            </table>

                                    </div>

                                </div>
                            </div>
                        </div>
                        <div class="row page-titles">

                            <div class="col-md-7 align-self-center text-left">
                                <div class="d-flex justify-content align-items-center">

                                <button type="button" class="btn btn-info d-lg-block m-l-15" onclick="location.href='?acao=Inserir';"><i class="fa fa-plus-circle"></i> Adicionar
                         <? $pagina = basename($_SERVER['PHP_SELF'],'.php');  echo ucfirst(strtolower($pagina)); ?></button>
                                </div>
                            </div>
                        </div>

                        <? } ?>
            <!-- ============================================================== -->
            <!-- END row g-0 -->
            <!-- ============================================================== -->
        </div>

        <!-- ============================================================== -->
        <!-- END Container fluid  -->
        <!-- ============================================================== -->
    </div>
    <!-- ============================================================== -->
    <!-- END Page wrapper  -->
    <!-- ============================================================== -->
</div>


<?php include 'tema/base.php'; ?>


<script language="javascript" type="text/javascript" src="../vendor/tinymce/tinymce.min.js"></script>
<script language="javascript" type="text/javascript">

tinymce.init({
    selector: 'textarea#noticia',
    setup: function (editor) {
        editor.on('change', function (e) {
            editor.save();
        });
    },
    language: 'pt_BR',
    auto_focus: 'notes',
    browser_spellcheck: true,
    language_url : 'vendor/tinymce/langs/pt_BR.js',
    plugins: 'ai tinycomments mentions anchor autolink charmap codesample emoticons image link lists media searchreplace table visualblocks wordcount checklist mediaembed casechange export formatpainter pageembed permanentpen footnotes advtemplate advtable advcode editimage tableofcontents mergetags powerpaste tinymcespellchecker autocorrect a11ychecker typography inlinecss code',
    toolbar: 'undo redo | blocks fontfamily fontsize | bold italic underline strikethrough | link image media table mergetags | align lineheight | tinycomments | checklist numlist bullist indent outdent | charmap | removeformat',
    toolbar1: 'formatselect | bold italic strikethrough forecolor backcolor | link | alignleft aligncenter alignright alignjustify  | numlist bullist outdent indent  | removeformat | emoticons',
    toolbar2: 'codesample | code ',
    mobile: {
                theme: "mobile",
                plugins: [ 'autosave', 'lists', 'autolink', 'emoticons' ],
                toolbar: [ 'undo', 'bold', 'italic', 'styleselect' ]
            },
    tinycomments_mode: 'embedded',
    tinycomments_author: 'Author name',
    entity_encoding: "numeric",
    fullpage_default_doctype: "<!DOCTYPE html>",
    fullpage_hide_in_source_view: true,
    spellchecker_active: false,
    valid_children : "+body[style], header(),<style />, <style>",
    valid_elements : '*[*]',
    element_format : 'html,php,java',
    extended_valid_elements :  'input[placeholder|accept|alt|checked|disabled|maxlength|name|readonly|size|src|type|value|header]',
    mergetags_list: [
      { value: 'mensagem', title: 'mensagem' },
    ],

  });
</script>
<?php flush(); ?>

Ted

Teste

Agora vai