<?php
// getlogs.php

    define('DB_HOST', 'localhost');
    define('DB_NAME', 'grgrgr');
    define('DB_USERNAME', 'rggrgr');
    define('DB_PASSWORD', 'grgrg');
    $odb = new PDO('mysql:host=' . DB_HOST . ';dbname=' . DB_NAME, DB_USERNAME, DB_PASSWORD);

    // build sql string
    $_GET['id'] = "1";


$selectSql = $odb->prepare('SELECT * FROM logs WHERE id = :ID AND active = 1 AND viewed = 1');
$selectSql->execute(array(':ID' => $_GET['id']));
$Logs = $selectSql->fetchAll();

$selectSql2 = $odb->prepare('SELECT * FROM logs WHERE id = :ID AND viewed = 0');
$selectSql2->execute(array(':ID' => $_GET['id']));
$Logs2 = $selectSql->fetchAll();

if(!empty($Logs2)){
     $updateSql = $odb->prepare('UPDATE mybb_auth SET viewed = 1 WHERE id = :ID');
     $updateSql->execute(array(':ID' => $_GET['id']));
     echo 'new';
}
?>