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); }