Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html lang="pt">
- <head>
- <?php
- // error_reporting(0); # remove syntax errors (VertrigoServ / XAMP and others)
- DEFINE( 'HOST', 'localhost' ); # Padrão
- DEFINE( 'USER', 'root' ); # Usuário do pma
- DEFINE( 'PASS', 'vertrigo' ); # Senha do pma
- DEFINE( 'DATABASE', 'board' ); # Nome da database do fórum
- DEFINE( 'BOARD', '/forum/' ); # link do seu fórum
- DEFINE( 'LIMIT', '5'); # Limite de Notícias que será exibida
- DEFINE( 'CATEGORY1', '2'); # ID da categoria dos Eventos (coluna forum_id = %)
- DEFINE( 'CATEGORY2', '4'); # ID da categoria das Changelogs da Staff (coluna forum_id = %)
- DEFINE( 'CATEGORY3', '6'); # ID da categoria de Noticías da Staff (coluna forum_id = %)
- try {
- $pdo = new PDO("mysql:dbname=".DATABASE.";host=".HOST, USER, PASS);
- $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- // $pdo->exec("SET NAMES utf8");
- } catch (PDOException $e) {
- echo "Sua conexão falhou: ".$e->getMessage();
- die();
- }
- ?>
- <meta charset="utf-8" />
- <title>Last News IP.Board by Envolvents</title>
- <meta name="viewport" content="initial-scale=1.0; maximum-scale=1.0; width=device-width;">
- <style type="text/css">
- /*
- * Last News IP.Board by Envolvents
- * v.1.0
- * 01/03/2017
- */
- @import url(http://fonts.googleapis.com/css?family=Roboto:400,500,700,300,100);
- body {
- background-color: #3e94ec;
- font-family: "Roboto", helvetica, arial, sans-serif;
- font-size: 16px;
- font-weight: 400;
- text-rendering: optimizeLegibility;
- }
- div.table-title {
- display: block;
- margin: auto;
- max-width: 600px;
- padding:5px;
- width: 100%;
- }
- .table-title h3 {
- color: #fafafa;
- font-size: 30px;
- font-weight: 400;
- font-style:normal;
- font-family: "Roboto", helvetica, arial, sans-serif;
- text-shadow: -1px -1px 1px rgba(0, 0, 0, 0.1);
- text-transform:uppercase;
- text-align: center;
- }
- /*** Table Styles **/
- .table-fill {
- background: white;
- border-radius:3px;
- border-collapse: collapse;
- height: 320px;
- margin: auto;
- max-width: 600px;
- padding:5px;
- width: 100%;
- box-shadow: 0 5px 10px rgba(0, 0, 0, 0.1);
- animation: float 5s infinite;
- }
- th {
- color:#D5DDE5;;
- background:#1b1e24;
- border-bottom:4px solid #9ea7af;
- border-right: 1px solid #343a45;
- font-size:23px;
- font-weight: 100;
- padding:24px;
- text-align:left;
- text-shadow: 0 1px 1px rgba(0, 0, 0, 0.1);
- vertical-align:middle;
- }
- th:first-child {
- border-top-left-radius:3px;
- }
- th:last-child {
- border-top-right-radius:3px;
- border-right:none;
- }
- tr {
- border-top: 1px solid #C1C3D1;
- border-bottom-: 1px solid #C1C3D1;
- color:#666B85;
- font-size:16px;
- font-weight:normal;
- text-shadow: 0 1px 1px rgba(256, 256, 256, 0.1);
- }
- tr:hover td {
- background:#4E5066;
- color:#FFFFFF;
- border-top: 1px solid #22262e;
- border-bottom: 1px solid #22262e;
- }
- tr:hover td a {
- color:#FFFFFF;
- }
- tr:first-child {
- border-top:none;
- }
- tr:last-child {
- border-bottom:none;
- }
- tr:nth-child(odd) td {
- background:#EBEBEB;
- }
- tr:nth-child(odd):hover td {
- background:#4E5066;
- }
- tr:last-child td:first-child {
- border-bottom-left-radius:3px;
- }
- tr:last-child td:last-child {
- border-bottom-right-radius:3px;
- }
- td {
- background:#FFFFFF;
- padding:20px;
- text-align:left;
- vertical-align:middle;
- font-weight:300;
- font-size:18px;
- text-shadow: -1px -1px 1px rgba(0, 0, 0, 0.1);
- border-right: 1px solid #C1C3D1;
- }
- td a {
- color: #666B85;
- text-decoration: underline;
- }
- td:last-child {
- border-right: 0px;
- }
- th.text-left {
- text-align: left;
- }
- th.text-center {
- text-align: center;
- }
- th.text-right {
- text-align: right;
- }
- td.text-left {
- text-align: left;
- }
- td.text-center {
- text-align: center;
- }
- td.text-right {
- text-align: right;
- }
- </style>
- </head>
- <body>
- <div class="table-title">
- <h3>Noticias IP.B 3.4.x by Ferraz</h3>
- </div>
- <table class="table-fill">
- <thead>
- <tr>
- <th class="text-left"> </th>
- <th class="text-left">Data</th>
- <th class="text-left">Título</th>
- <th class="text-left">Autor</th>
- <th class="text-left">Acesse</th>
- </tr>
- </thead>
- <tbody class="table-hover">
- <?php
- $sql = $pdo->prepare("
- SELECT *,
- CASE forum_id
- WHEN ".CATEGORY1." THEN 'News'
- WHEN ".CATEGORY2." THEN 'Changelogs'
- WHEN ".CATEGORY3." THEN 'Eventos'
- END as forum_id
- FROM topics
- WHERE forum_id IN ( '".CATEGORY1."', '".CATEGORY2."','".CATEGORY3."')
- ORDER BY `tid`
- DESC LIMIT 0, ".LIMIT." ");
- $sql->execute();
- if(count($sql) > 0) {
- foreach ($sql->fetchAll() as $app) {
- $date = date("d/m", $app['start_date']);
- echo( "<tr>");
- echo( "<td class=\"text-left\"><img src=\"{$app['forum_id']}.png\"></td>");
- echo( "<td class=\"text-left\">{$date}</td>");
- echo( "<td class=\"text-left\">{$app['title']}</td>");
- echo( "<td class=\"text-left\">{$app['starter_name']}</td>");
- echo( "<td class=\"text-left\"><a href=\"" . BOARD . "index.php?/topic/{$app['tid']}-{$app['title_seo']}\" class=\"tipsyTIP\" title=\"Clique para ver a notícia completa.\" target=\"_blank\">[mais ...]</a></td>");
- echo( "</tr>");
- }
- } else {
- echo("<tr>");
- echo("<td class=\"text-left\" colspan=\"5\" style=\"text-align:center;\">Não há notícias.</td>");
- echo("</tr>");
- }
- ?>
- </tbody>
- </table>
- </body>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement