<?php

require('../lib/genopar.lib.php');
require('../lib/config.php');

// if(!doAuth(LVLADM)) {
// 	$genopar->fechaPagina(); exit;
// }

$genopar = new Genopar(__FILE__);
$genopar->abrePagina("Atualizar Lista de E.C. Numbers");

$localFile = getECtable($genopar);
$ECnumbers = parse($genopar,$localFile);
update($genopar, $ECnumbers);

$genopar->fechaPagina();

function getECtable($genopar){
	echo $genopar->dir_padrao;
	$server = "ftp.expasy.org";
	$serverFile = "databases/enzyme/enzyme.dat";
	$localFile = $genopar->dir_padrao."/tmp/ECtable";
	$USER = "anonymous";
	$PASS = "nada@lugar.algum";

	$con = ftp_connect($server) or $genopar->error("server indispon�vel.");
	ftp_login($con, $USER, $PASS);

	ftp_get($con, $localFile, $serverFile, FTP_BINARY) or $genopar->error("Impossible to download the file.");

	ftp_close($con);

	return $localFile;
}

function parse($genopar, $table){
	$ECnumbers = array();
	$lines = file($table);
	foreach ($lines as $line_num => $line) {
		if (preg_match("/^ID/", $line)){
    			preg_match("/^ID\s+(.*)/",$line,$EC);
    			$EC = $EC[1];
		}elseif(preg_match("/^DE/", $line)){
			preg_match("/^DE\s+(.*)$/",$line,$enz);
			$ECnumbers[$EC] = $enz[1];
		}
	}
	return $ECnumbers;
}

function update($genopar, $ECnumbers){
	$genopar->abreBanco();

	$q = "DROP TABLE ECnumbers";
	$genopar->queryBanco($q);

	$q = "	CREATE TABLE  `ECnumbers` (
		`numero` varchar(15) default NULL,
		`enzima` text
		) ENGINE=MyISAM DEFAULT CHARSET=latin1";
	$genopar->queryBanco($q);

	foreach ($ECnumbers as $EC => $enz){
		$Enz = addslashes($enz);
		$q = "INSERT into `ECnumbers` VALUES ('$EC', '$Enz')";
		$genopar->queryBanco($q);
	}

	$genopar->fechaBanco();

}