<?php


$shost = "localhost";
$suser = "site";
$spass = "4afFvRXVeq23PA4D";
$sdb = "site";

$sconnect = mysql_connect($shost,$suser,$spass) or die('Could not connect: ' . mysql_error());
mysql_select_db($sdb,$sconnect) or die('Could not select database');

$filename = $_GET['filename'];
$path = $_GET['path'];

$fpath = $path . $filename ;

// -------------------------------
// -------------------------------
// -------------------------------
// -------------------------------
// -------------------------------
// -------------------------------
// -------------------------------
// -------------------------------

function FirstClearJID ($xxjid,$xxtablename) {
// Once butun tablolardan silme islemi yapilir mukerrer kayit olmamasi icin
mysql_query("DELETE FROM " . $xxtablename . " WHERE JID = '$xxjid' ");
echo "<font color=\"green\"><b>" . $xxtablename . " Tablosundan " . mysql_affected_rows() . " Kayit Silindi</b></font><br>" ;
}

function r($text) {
// mysql insert edereken escape icin
return mysql_real_escape_string($text);
}


$contents = file_get_contents($fpath);
$xml = simplexml_load_string($contents); 
//print_r($xml);
//print_r($xml->front[0]);


$jid = $filename ;

FirstClearJID($jid,'journal_base');
FirstClearJID($jid,'journal_meta');
FirstClearJID($jid,'journal_history');
FirstClearJID($jid,'journal_permissions');
FirstClearJID($jid,'journal_keywords');
FirstClearJID($jid,'journal_counts');
FirstClearJID($jid,'journal_pub_date');
FirstClearJID($jid,'journal_title');
FirstClearJID($jid,'journal_affs');
FirstClearJID($jid,'journal_article');
FirstClearJID($jid,'journal_article_categories');
FirstClearJID($jid,'journal_author_notes');
FirstClearJID($jid,'journal_contrib');
FirstClearJID($jid,'journal_abstract');
FirstClearJID($jid,'journal_key_points');
FirstClearJID($jid,'journal_back_ack');
FirstClearJID($jid,'journal_back_refs');
FirstClearJID($jid,'journal_back_refs_journal');
FirstClearJID($jid,'journal_back_refs_web');
FirstClearJID($jid,'journal_back_refs_pg');
FirstClearJID($jid,'journal_back_refs_book');
FirstClearJID($jid,'journal_floats');
FirstClearJID($jid,'journal_float_fig');
FirstClearJID($jid,'journal_float_table');
FirstClearJID($jid,'journal_body');
FirstClearJID($jid,'jssmorgf');
FirstClearJID($jid,'journal_references');


mysql_close($sconnect);

?>