<?php
$username="root";  
$password="vpsad24068";  
$hostname = "localhost";  
define( 'SHORTINIT', true );
require( './wp-load.php' );
// require( 'wp-includes/post.php' );
// require( 'wp-includes/post-template.php' );
// require( 'wp-includes/revision.php' );
// require( 'wp-includes/class-wp-post.php' );
// require( 'wp-includes/user.php' );
// require( 'wp-includes/taxonomy.php' );
//connection string with database  
$dbhandle = mysqli_connect($hostname, $username, $password);
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
inserisci_pubblicazioni();
//echo 'Hello ' . htmlspecialchars($_GET["email"]) . htmlspecialchars($_GET["doi"]) . '!';
$doi = htmlspecialchars($_GET["doi"]);
$email = htmlspecialchars($_GET["email"]);
$selected = mysqli_select_db($dbhandle, "wptest")  
or die("Could not select DB"); 
$query = "UPDATE wp_articoli SET appr = 1, wp_articoli.emailAppr = '$email'
            WHERE wp_articoli.doi = '$doi'";
echo $query;
$res3 = mysqli_query($dbhandle,$query);
$queryPost = "SELECT wp_articoli.authors,wp_articoli.published,wp_articoli.title,wp_articoli.ajournal,wp_articoli.doi,wp_articoli.summary FROM wp_articoli
                    WHERE wp_articoli.doi = '$doi'";
echo $queryPost;
$post2ins = mysqli_query($dbhandle,$queryPost);
$post2insarr = mysqli_fetch_array($post2ins);
//$content = $post2insarr[5];
//$title = $post2insarr[2];

$post = array(
    'post_author' => 1,
    'post_content' => $post2insarr[5],
    'post_title' => $post2insarr[2],
    'post_name' => 'my-page',
    'post_excerpt' => '',
    'post_status' => 'publish',
    'comment_status' => 'close',
    'ping_status' => 'open',
    'post_type' => 'page',
    'comment_count' => 0
);


// $year = strtok($post2insarr[1], '-');
// echo $year;
// $post2 = array(
//     'post_author' => 1,
//     'post_content' => $post2insarr[5],
//     'post_title' => $post2insarr[2],
//     'post_name' => 'my-page',
//     'post_category' => array($year),
//     'tags_input' => array($post2insarr[0]),
//     'meta_input' => array(
//         'ajournal' => $post2insarr[3],
//         'doi' => $post2insarr[4]
//     ),
//     'post_excerpt' => '',
//     'post_status' => 'publish',
//     'comment_status' => 'close',
//     'ping_status' => 'open',
//     'post_type' => 'page',
//     'comment_count' => 0
// );

//wp_insert_post($post2);

$wpdb->insert(
    'wp_posts', 
    $post,
    array( '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s' ));
$postID = $wpdb->insert_id;
echo $postID;

$year = strtok($post2insarr[1], '-');
echo $year;

$wpdb->update( 'wp_posts',
      array('comment_status'=> 'open',), // SET
      array('ID'=> $postID,)       // WHERE
   );
$wpdb->update( 'wp_postmeta',
    array( 
        'meta_value' => $post2insarr[3],  
        'meta_key' => 'ajournal'   
        ),  // SET
    array('ID'=> $postID,)       // WHERE
);
$wpdb->update( 'wp_postmeta',
    array( 
        'meta_value' => $post2insarr[4],  
        'meta_key' => 'arxivdoi'   
        ),  // SET
    array('ID'=> $postID,)       // WHERE
);

//$item->published = date("Y",strtotime($item->published));
//recupero l'anno di pubblicazione da inserire poi come categoria 
$year = strtok($post2insarr[1], '-');
echo $year;

// $current_post = $postID;
// if($current_post){
//     setup_postdata( $GLOBALS['post'] =& $post_object );
//     $post = $current_post;
//     update_post_meta( "$postID", "ajournal", "$post2insarr[3]" );
        
// } else {
//     echo "cippa !";
// }
//wp_set_post_tags( 50, array( 'awesome' ), true );
//update_post_meta( "$postID", "ajournal", "$post2insarr[3]" );

// update_post_meta( $postID, 'doi', $post2insarr[4] );

// wp_set_post_tags( $postID, $post2insarr[0] ) ;

// wp_set_post_categories( $postID, $year );

mysqli_close($dbhandle);

?>