function SQLreCreateTermIndex()
{
global $DBCFG;
$sqlTerminosValidos = SQLIdTerminosValidos();
$sqlTruncate = SQL("truncate", "{$DBCFG['DBprefix']}indice");
while ($array = mysqli_fetch_row($sqlTerminosValidos[datos])) {
$i = ++$i;
$este_tema_id = $array[0];
$tema_ids_inverso = generaIndices($array[0]);
$tema_ids_inverso = array_reverse(explode("|", $tema_ids_inverso));
foreach ($tema_ids_inverso as $tema_id) {
$indice[$este_tema_id] .= '|' . $tema_id;
}
$esteindice = substr($indice[$este_tema_id], 1);
$sql = SQL("insert", "into {$DBCFG['DBprefix']}indice values ('{$array['0']}','{$esteindice}')");
}
return array("cant_terms_index" => $i);
}
function doTotalTopicMap($tipoEnvio)
{
$time_start = time();
@set_time_limit(900);
switch ($tipoEnvio) {
case 'line':
$sql = SQLIdTerminosValidos();
header('content-type: text/xml');
outputCosas('<?xml version="1.0" encoding="ISO-8859-1"?>');
outputCosas(XTMheader);
outputCosas(doTerminosXTM());
outputCosas(doRelacionesXTM());
outputCosas('</topicMap>');
break;
#enviar como archivo
#enviar como archivo
case 'file':
header('content-type: text/xml');
$row .= '<?xml version="1.0" encoding="ISO-8859-1"?>';
$row .= XTMheader;
$rowTerminos = doTerminosXTM($tema_id);
$rowRelaciones = doRelacionesXTM($tema_id);
$rowFinal = '</topicMap>';
$rows = $row . $rowTerminos . $rowRelaciones . $rowFinal;
$filname = string2url($_SESSION[CFGTitulo]) . '.xtm';
sendFile("{$rows}", "{$filname}");
break;
}
}
function SQLreCreateTermIndex()
{
global $DBCFG;
$sqlTerminosValidos = SQLIdTerminosValidos();
$sqlTruncate = SQL("truncate", "{$DBCFG['DBprefix']}indice");
while ($array = $sqlTerminosValidos->FetchRow()) {
$i = ++$i;
$este_tema_id = $array[0];
$tema_ids_inverso = generaIndices($array[0]);
$tema_ids_inverso = array_reverse(explode("|", $tema_ids_inverso));
foreach ($tema_ids_inverso as $tema_id) {
$indice[$este_tema_id] .= '|' . $tema_id;
}
if ($DBCFG["debugMode"] == "1") {
echo $indice[$este_tema_id] . ': ' . $este_tema_id . '<br>';
}
$esteindice = substr($indice[$este_tema_id], 1);
$sql = SQL("insert", "into {$DBCFG['DBprefix']}indice values ('{$array['0']}','{$esteindice}')");
}
//Check some problems
//1) code null
$sql = SQL("update", " {$DBCFG['DBprefix']}tema set code=null where length(code)<1 ");
//2) change date 0000
$sql = SQL("update", " {$DBCFG['DBprefix']}tema set cuando_final=null where cuando_final='0000-00-00' ");
$sql = SQL("update", " {$DBCFG['DBprefix']}tema set cuando=now() where cuando='0000-00-00' ");
return array("cant_terms_index" => $i);
}
function doSparqlEndpoint()
{
global $DBCFG;
/* Include ARC2 classes. */
require_once T3_ABSPATH . 'common/arc2/ARC2.php';
/* ARC2 static class inclusion */
/* MySQL and endpoint configuration */
$config = array('db_host' => $DBCFG["Server"], 'db_name' => $DBCFG["DBName"], 'db_user' => $DBCFG["DBLogin"], 'db_pwd' => $DBCFG["DBPass"], 'store_name' => $DBCFG["DBprefix"], 'endpoint_features' => array('select', 'construct', 'ask', 'describe', 'load'), 'endpoint_timeout' => 60, 'endpoint_read_key' => '', 'endpoint_write_key' => '', 'endpoint_max_limit' => 250);
/* instantiation */
$ep = ARC2::getStoreEndpoint($config);
if (!$ep->isSetUp()) {
$ep->setUp();
/* create MySQL tables */
}
// reset the endpoint
$ep->reset();
// ask terms
$sql = SQLIdTerminosValidos();
//fetch main metadata
$sparql_command = 'LOAD <' . $_SESSION["CFGURL"] . 'xml.php?skosMeta=1> into <' . $_SESSION["CFGURL"] . '>';
$ep->query($sparql_command);
while ($array = $sql->FetchRow()) {
$i == ++$i;
#Mantener vivo el navegador
$time_now = time();
if ($time_start >= $time_now + 10) {
$time_start = $time_now;
header('X-pmaPing: Pong');
}
$sparql_command = 'LOAD <' . $_SESSION["CFGURL"] . 'xml.php?skosNode=' . $array[id] . '> into <' . $_SESSION["CFGURL"] . '>';
$ep->query($sparql_command);
}
//Update data about las endpoint
$ARRAYlastUpdateEndpoint = fetchlastUpdateEndpoint();
if ($ARRAYlastUpdateEndpoint["value"]) {
$sql = SQL("update", " {$DBCFG['DBprefix']}values set value=now() where value_type='DATESTAMP' and value_code='ENDPOINT_CHANGE'");
} else {
$sql = SQL("insert", "into {$DBCFG['DBprefix']}values (`value_type`, `value`, `value_order`, `value_code`) VALUES\r\n\t\t\t\t\t('DATESTAMP', now(), NULL, 'ENDPOINT_CHANGE')");
}
return array("count_nodes" => $i);
}
