Exemplo n.º 1
0
 protected function beforeCreate()
 {
     $this->setSid($_SESSION['admin_sid']);
     $this->setTs(NOW);
     $this->setIpLong(IP_LONG);
     $this->setAgent(USER_AGENT);
     $this->setRequestUri(SELF);
     $this->setReferer(REF);
     $this->setReferer(REF);
     $this->setUserId(USER_ID);
     $this->setP(P);
     $this->setDo(P_DO);
     $this->setPost($_POST ? sql_prepare(serialize($_POST)) : '');
 }
Exemplo n.º 2
0
 public function get_user_options($user_id)
 {
     if (!$user_id) {
         throw new UnexpectedValueException();
     }
     $out = array();
     $res = sql_query("SELECT option_id id, option_value value FROM user_options_values WHERE user_id={$user_id}");
     while ($r = sql_fetch_array($res)) {
         $out[$r['id']] = $r['value'];
     }
     //autovivify absent options
     sql_begin();
     $ins = sql_prepare("INSERT INTO user_options_values VALUES(?, ?, ?)");
     foreach ($this->options as $opt) {
         if (!in_array($opt->id, array_keys($out))) {
             $out[$opt->id] = $opt->default_value;
             sql_execute($ins, array($user_id, $opt->id, $opt->default_value));
         }
     }
     sql_commit();
     return $out;
 }
Exemplo n.º 3
0
function get_ambiguity_stats_for_chart()
{
    $chart = array();
    $t = array();
    $tchart = array();
    $time = time();
    $param_set = array(5, 35, 36, 37, 41, 45, 62, 64);
    $res = sql_prepare("SELECT timestamp, param_value FROM stats_values WHERE timestamp > ? AND param_id = ? ORDER BY timestamp");
    foreach ($param_set as $param_id) {
        sql_execute($res, array($time - 90 * SEC_PER_DAY, $param_id));
        while ($r = sql_fetch_array($res)) {
            $day = intval($r['timestamp'] / SEC_PER_DAY);
            $t[$day][$param_id] = $r['param_value'];
        }
    }
    ksort($t);
    foreach ($t as $day => $ar) {
        $tchart['disamb_sentences'][] = '[' . $day * MSEC_PER_DAY . ',' . $ar[41] . ']';
        $tchart['disamb_sentences_strict'][] = '[' . $day * MSEC_PER_DAY . ',' . $ar[62] . ']';
        if ($ar[45]) {
            $tchart['disamb_sent_length'][] = '[' . $day * MSEC_PER_DAY . ',' . sprintf("%.3f", $ar[45] / $ar[41]) . ']';
        }
        if ($ar[64]) {
            $tchart['disamb_sent_strict_length'][] = '[' . $day * MSEC_PER_DAY . ',' . sprintf("%.3f", $ar[64] / $ar[62]) . ']';
        }
        if ($ar[35] == 0) {
            continue;
        }
        $tchart['avg_parses'][] = '[' . $day * MSEC_PER_DAY . ',' . sprintf("%.3f", $ar[35] / $ar[5]) . ']';
        $tchart['non_ambig'][] = '[' . $day * MSEC_PER_DAY . ',' . sprintf("%.3f", $ar[37] / $ar[5] * 100) . ']';
        $tchart['unknown'][] = '[' . $day * MSEC_PER_DAY . ',' . sprintf("%.3f", $ar[36] / $ar[5] * 100) . ']';
        $tchart['total_words'][] = '[' . $day * MSEC_PER_DAY . ',' . $ar[5] . ']';
    }
    foreach ($tchart as $name => $ar) {
        $chart[$name] = join(',', $ar);
    }
    return $chart;
}
Exemplo n.º 4
0
function get_context_for_word($tf_id, $delta, $dir = 0, $include_self = 1)
{
    // dir stands for direction (-1 => left, 1 => right, 0 => both)
    // delta <= 0 stands for infinity
    $t = array();
    $tw = 0;
    $left_c = -1;
    //if there is left context to be added
    $right_c = 0;
    //same for right context
    $mw_pos = 0;
    static $query1 = NULL;
    // prepare the 1st query
    if ($query1 == NULL) {
        $query1 = sql_prepare("\n            SELECT MAX(tokens.pos) AS maxpos, MIN(tokens.pos) AS minpos, sent_id, source, book_id\n            FROM tokens\n                JOIN sentences USING (sent_id)\n                JOIN paragraphs USING (par_id)\n            WHERE sent_id = (\n                SELECT sent_id\n                FROM tokens\n                WHERE tf_id=? LIMIT 1\n            )\n        ");
    }
    sql_execute($query1, array($tf_id));
    $res = sql_fetchall($query1);
    $r = $res[0];
    $sent_id = $r['sent_id'];
    $sentence_text = $r['source'];
    $book_id = $r['book_id'];
    $maxpos = $r['maxpos'];
    $minpos = $r['minpos'];
    // prepare the 2nd query
    // this is really bad unreadable code, sorry
    static $query2 = NULL;
    if ($query2 == NULL) {
        $q = "SELECT tf_id, tf_text, pos FROM tokens WHERE sent_id = ?";
        if ($dir != 0 || $delta > 0) {
            $q_left = $dir <= 0 ? $delta > 0 ? "(SELECT IF(pos > {$delta}, pos - {$delta}, 0) FROM tokens WHERE tf_id=? LIMIT 1)" : "0" : "(SELECT pos FROM tokens WHERE tf_id=? LIMIT 1)";
            $q_right = $dir >= 0 ? $delta > 0 ? "(SELECT pos+{$delta} FROM tokens WHERE tf_id=? LIMIT 1)" : "1000" : "(SELECT pos FROM tokens WHERE tf_id=? LIMIT 1)";
            $q .= " AND pos BETWEEN {$q_left} AND {$q_right}";
        }
        $q .= " ORDER BY pos";
        $query2 = sql_prepare($q);
    }
    // how many values should we provide?
    $bound = array($tf_id, $tf_id);
    if ($delta <= 0) {
        if ($dir == 0) {
            $bound = array();
        } else {
            $bound = array($tf_id);
        }
    }
    sql_execute($query2, array_merge(array($sent_id), $bound));
    foreach (sql_fetchall($query2) as $r) {
        if ($delta > 0) {
            if ($left_c == -1) {
                $left_c = $r['pos'] == $minpos ? 0 : $r['tf_id'];
            }
            if ($mw_pos) {
                if ($r['pos'] > $mw_pos) {
                    $right_c = $r['tf_id'];
                }
                if ($right_c && $r['pos'] == $maxpos) {
                    $right_c = 0;
                }
            }
        }
        if ($include_self || $r['tf_id'] != $tf_id) {
            $t[$r['tf_id']] = $r['tf_text'];
        }
        if ($include_self && $r['tf_id'] == $tf_id) {
            $mw_pos = $r['pos'];
        }
    }
    return array('context' => $t, 'mainword' => $tf_id, 'has_left_context' => $left_c, 'has_right_context' => $right_c, 'sentence_id' => $sent_id, 'sentence_text' => $sentence_text, 'book_id' => $book_id);
}
Exemplo n.º 5
0
function get_unknowns()
{
    $res = sql_query("\n        SELECT tf_id, tf_text, sent_id, ut.dict_revision\n        FROM tokens t\n        LEFT JOIN form2lemma f\n            ON (t.tf_text = f.form_text)\n        LEFT JOIN tf_revisions\n            USING (tf_id)\n        LEFT JOIN updated_tokens ut\n            ON (t.tf_id = ut.token_id)\n        WHERE is_last = 1\n        AND rev_text LIKE '%UNKN%'\n        AND f.lemma_id IS NOT NULL\n        GROUP BY tf_id\n        ORDER BY tf_id\n    ");
    $res1 = sql_prepare("\n        SELECT text, user_shown_name\n        FROM morph_annot_comments\n        LEFT JOIN morph_annot_samples\n            USING (sample_id)\n        LEFT JOIN users\n            USING (user_id)\n        WHERE tf_id = ?\n    ");
    $out = array();
    while ($r = sql_fetch_array($res)) {
        sql_execute($res1, array($r['tf_id']));
        $comments = array();
        while ($r1 = sql_fetch_array($res1)) {
            $comments[] = array('text' => $r1['text'], 'author' => $r1['user_shown_name']);
        }
        $out[] = array('sent_id' => $r['sent_id'], 'text' => $r['tf_text'], 'is_pending' => (bool) $r['dict_revision'], 'comments' => $comments);
    }
    return $out;
}
Exemplo n.º 6
0
<?php

use TMCms\DB\SQL;
use TMCms\Log\Errors;
if (!defined('INC')) {
    define('INC', true);
}
if (!defined('MODE')) {
    define('MODE', 'site');
}
if (stripos(USER_AGENT, 'bot') !== false) {
    return;
}
$msg = isset($_GET['msg']) ? $_GET['msg'] : '';
$stack = isset($_GET['stack']) ? $_GET['stack'] : '';
$url = isset($_GET['url']) ? $_GET['url'] : '';
$line = isset($_GET['line']) ? $_GET['line'] : '';
Errors::notify_devs(CFG_DOMAIN . ' JavaScript error', 'Message: ' . $msg . "\nClicks Stack: " . $stack . "\nURL: " . $url . "\nLine: " . $line);
// Write log if DB available
if (!SQL::getInstance()->getConnectionHandler()) {
    return;
}
q('INSERT INTO `cms_error_log` (
    `ts`, `ip_long`, `agent`,
    `type`, `msg`, `file`,
    `line`, `vars`
) VALUES (
    "' . NOW . '", "' . ip2long(IP) . '", "' . USER_AGENT . '",
    "JS", "' . sql_prepare($msg) . '", "' . sql_prepare($url) . '",
    "' . sql_prepare($line) . '", "' . sql_prepare($stack) . '"
)');
Exemplo n.º 7
0
<?php

/**
 * Load CSV data (defined in datapackage.jsob) to the SQL database.
 * php src/php/prepare.php
 */
include 'packLoad.php';
// must be CONFIGURED for your database
// // // // // // // // // //
// CONFIGS: (complement to omLib)
$basePath = realpath(__DIR__ . '/../..');
$reini = true;
// re-init all SQL structures of the project (drop and refresh schema)
$sqlMode = '1';
// // // // //
// SQL PREPARE
$sqlIni = ["::src/sql_mode{$sqlMode}/step1_libDefs.sql", "::src/sql_mode{$sqlMode}/step2_struct.sql", "::src/sql_mode{$sqlMode}/step3_lib.sql", "SELECT tStore.ns_upsert('test','pt','Test. Portuguese.')", "SELECT tStore.ns_upsert('wayta-pt','pt','Wayta SciELO reference-dataset, Portuguese.',true, '{\"group_unique\":false}'::jsonb)", "SELECT tStore.ns_upsert('wayta-code','  ','Wayta SciELO reference-dataset, no-lang')", "SELECT tStore.ns_upsert('wayta-en','en','Wayta SciELO reference-dataset, English.')", "SELECT tStore.ns_upsert('wayta-es','es','Wayta SciELO reference-dataset, Spanish.')", "UPDATE tStore.ns SET fk_partOf=tlib.nsget_nsid('wayta-pt') WHERE label!='wayta-pt' AND left(label,5)='wayta'", "SELECT tStore.ns_upsert('country-code', '  ', 'Country names reference-dataset, no-lang.', true, '{\"group_unique\":false}'::jsonb)", "SELECT tStore.ns_upsert('country-pt','pt','Country names reference-dataset, Portuguese.')", "SELECT tStore.ns_upsert('country-fr','fr','Country names reference-dataset, French.')", "SELECT tStore.ns_upsert('country-es','es','Country names reference-dataset, Spanish.')", "SELECT tStore.ns_upsert('country-en','en','Country names reference-dataset, English.')", "SELECT tStore.ns_upsert('country-de','de','Country names reference-dataset, Deutsch.')", "SELECT tStore.ns_upsert('country-it','it','Country names reference-dataset, Italian.')", "SELECT tStore.ns_upsert('country-nl','nl','Country names reference-dataset, Dutch.')", "UPDATE tStore.ns SET fk_partOf=tlib.nsget_nsid('country-code') WHERE label!='country-code' AND left(label,7)='country'", "INSERT INTO tstore.source (name,jinfo) VALUES\n\t\t('normalized_aff',      tstore.source_add1('Scielo','Wayta institution','https://github.com/scieloorg/wayta/blob/master/processing/normalized_aff.csv') )\n\t\t,('normalized_country', tstore.source_add1('Scielo','Wayta country','https://github.com/scieloorg/wayta/blob/master/processing/normalized_country.csv') )\n\t\t,('country-names-multilang', tstore.source_add1('Unicode','UNICODE CLDR, core, territory','http://www.unicode.org/Public/cldr') )\n\t\t,('country-codes',      tstore.source_add1('OKFN','Data Packaged Core Datasets, ISO and other Country Codes','https://raw.github.com/datasets/country-codes/master/data/country-codes.csv') )\n\t\t,('iso3166-1-alpha-2',      tstore.source_add1('ISO','ISO-3166-1, Country Codes, Alpha-2','') )\n\t\t,('iso3166-1-alpha-3',      tstore.source_add1('ISO','ISO-3166-1, Country Codes, Alpha-3','') )\n\t"];
// // // // //
// MAKING DATA:
sql_prepare($sqlIni, "SQL SCHEMAS with MODE{$sqlMode}", $basePath, $reini);
if (!$reini) {
    sql_prepare("DELETE FROM tstore.term; DELETE FROM tstore.ns;", "DELETING MAIN TABLES");
}
resourceLoad_run($basePath, ['test' => [['prepare_auto', "tlib.tmp_test"]], 'normalized_aff' => [['prepare_jsonb', "tlib.tmp_waytaff"]], 'normalized_country' => [['prepare_jsonb', "tlib.tmp_waytacountry"]], 'country-codes' => [['prepare_jsonb', "tlib.tmp_codes"]], 'country-names-multilang' => [['prepare_jsonb', "tlib.tmp_codes2"]]], "(MODE{$sqlMode})");
sql_prepare(["SELECT tStore.upsert(term, tlib.nsget_nsid('test')) FROM tlib.tmp_test;", "DROP TABLE tlib.tmp_test;", "::src/sql_mode{$sqlMode}/nsCountry_build.sql", "DROP TABLE tlib.tmp_waytacountry; DROP TABLE tlib.tmp_codes; DROP TABLE tlib.tmp_codes2;", "::src/sql_mode{$sqlMode}/nsWayta_build.sql", "DROP TABLE tlib.tmp_waytaff;", "::assert_bysql:data/assert1_mode{$sqlMode}.tsv"], "SQL FINALIZATION", $basePath);
Exemplo n.º 8
0
                die;
            }
            $save_ext = $params;
            break;
        case 'watermark':
            if (!$params) {
                break;
            }
            $check_size_allowed($params);
            if (!preg_match('/^[0-9]+$/', $params)) {
                if (!Settings::isProductionState()) {
                    exit('Error processing params for action "watermark". Example: 1 or main');
                }
                die;
            }
            $data = q_assoc_row('SELECT `image`, `image_pos` FROM `cms_img_proc_perms` WHERE `rule` = "&watermark=' . sql_prepare($params) . '" LIMIT 1');
            if (!$data || !$data['image'] || !$data['image_pos']) {
                if (!Settings::isProductionState()) {
                    exit('Error. Incorrect parameters for action "watermark"');
                }
                die;
            }
            $image->watermark($data['image'], $data['image_pos']);
            break;
    }
}
FileSystem::mkdir(DIR_CACHE . 'images/' . $path);
if (!$image->save(DIR_CACHE . 'images/' . QUERY, $ext, 90) && !Settings::isProductionState()) {
    dump('Not enough memory to resize and sharpen image "' . $path . $file . '".');
}
unset($image);
Exemplo n.º 9
0
 /**
  * Set migration .sql file as already finished
  * @param string $filename
  * @return $this
  */
 private function setMigrationFileAsCompleted($filename)
 {
     $migration = new MigrationEntity();
     $migration->setFilename(sql_prepare($filename));
     @$migration->save();
     return $this;
 }
Exemplo n.º 10
0
function find_ne_entity($annot_id, $e_id, $e_start_token, $e_length)
{
    static $res = NULL;
    if ($res == NULL) {
        $res = sql_prepare("\n            SELECT entity_id\n            FROM ne_entities\n            WHERE annot_id = ?\n            AND start_token = ?\n            AND length = ?\n        ");
    }
    sql_execute($res, array($annot_id, $e_start_token, $e_length));
    $rows = sql_fetchall($res);
    if (sizeof($rows) == 0) {
        return false;
    }
    // check tags
    $found_id = $rows[0]['entity_id'];
    $tags1 = get_ne_entity_tags($e_id, true);
    $tags2 = get_ne_entity_tags($found_id, true);
    if ($tags1 == $tags2) {
        return $found_id;
    }
    return false;
}
Exemplo n.º 11
0
function enqueue_updated_forms($forms, $revision_id)
{
    $ins = sql_prepare("INSERT INTO `updated_forms` VALUES (?, ?)");
    foreach (array_unique($forms) as $upd_form) {
        sql_execute($ins, array($upd_form, $revision_id));
    }
}
Exemplo n.º 12
0
function addtext_add($text, $sentences, $book_id, $par_num)
{
    check_permission(PERM_ADDER);
    if (!$text || !$book_id || !$par_num) {
        throw new UnexpectedValueException();
    }
    if (sizeof(sql_pe("SELECT book_id FROM books WHERE parent_id=?", array($book_id))) > 0) {
        throw new UnexpectedValueException("Can't add paragraphs to a text having subtexts");
    }
    sql_begin();
    $revset_id = create_revset();
    $sent_count = 0;
    $pars = split2paragraphs($text);
    // move the following paragraphs
    sql_query("UPDATE paragraphs SET pos=pos+" . sizeof($pars) . " WHERE book_id = {$book_id} AND pos >= {$par_num}");
    $par_ins = sql_prepare("INSERT INTO `paragraphs` VALUES(NULL, ?, ?)");
    $sent_ins = sql_prepare("INSERT INTO `sentences` VALUES(NULL, ?, ?, ?, 0)");
    $token_ins = sql_prepare("INSERT INTO `tokens` VALUES(NULL, ?, ?, ?)");
    foreach ($pars as $par) {
        //adding a paragraph
        sql_execute($par_ins, array($book_id, $par_num++));
        $par_id = sql_insert_id();
        $sent_num = 1;
        $sents = split2sentences($par);
        foreach ($sents as $sent) {
            if (!preg_match('/\\S/', $sent)) {
                continue;
            }
            //adding a sentence
            sql_execute($sent_ins, array($par_id, $sent_num++, trim($sent)));
            $sent_id = sql_insert_id();
            sql_query("INSERT INTO sentence_authors VALUES({$sent_id}, " . $_SESSION['user_id'] . ", " . time() . ")");
            $token_num = 1;
            $tokens = explode('^^', $sentences[$sent_count++]);
            foreach ($tokens as $token) {
                if (trim($token) === '') {
                    continue;
                }
                //adding a textform
                sql_execute($token_ins, array($sent_id, $token_num++, trim($token)));
                $tf_id = sql_insert_id();
                //adding a revision
                $parse = new MorphParseSet(false, trim($token));
                create_tf_revision($revset_id, $tf_id, $parse->to_xml());
            }
        }
    }
    sql_commit();
}
Exemplo n.º 13
0
 /**
  * @return string
  */
 public function execute()
 {
     $results = [];
     preg_match_all('/\\%(' . implode('|', self::$replacements) . ')/', $this->sql, $results);
     $results = $results[1];
     foreach ($this->params as $k => &$v) {
         if (!isset($results[$k])) {
             trigger_error('Incorrect parameter count');
         }
         switch ($results[$k]) {
             case 's':
             case 'string':
                 $v = '"' . sql_prepare($v) . '"';
                 break;
             case 'i':
             case 'int':
                 $v = (int) $v;
                 break;
             case 'ui':
             case 'uint':
                 $v = abs((int) $v);
                 break;
             case 'f':
             case 'float':
                 $v = (double) $v;
                 break;
             case 'l':
             case 'like':
                 $v = '"' . sql_prepare($v) . '"';
                 break;
             case 'ai':
             case 'arrayint':
                 foreach ($v as &$unit) {
                     $unit = (int) $unit;
                 }
                 $v = implode(',', $v);
                 unset($unit);
                 break;
             case 'aui':
             case 'arrayuint':
                 dump($v);
                 if (!is_array($v)) {
                     trigger_error('Parameter "' . ($k + 1) . '" must be an array becouse query contains "%' . $results[$k] . '".');
                 }
                 foreach ($v as &$unit) {
                     $unit = abs((int) $unit);
                 }
                 $v = implode(',', $v);
                 unset($unit);
                 break;
             case 'as':
             case 'arraystring':
                 if (!is_array($v)) {
                     trigger_error('Parameter "' . ($k + 1) . '" must be an array becouse query contains "%' . $results[$k] . '".');
                 }
                 foreach ($v as &$unit) {
                     $unit = '"' . sql_prepare($unit) . '"';
                 }
                 $v = implode(',', $v);
                 unset($unit);
                 break;
             case 'af':
             case 'arrayfloat':
                 if (!is_array($v)) {
                     trigger_error('Parameter "' . ($k + 1) . '" must be an array becouse query contains "%' . $results[$k] . '".');
                 }
                 foreach ($v as &$unit) {
                     $unit = (double) $unit;
                 }
                 $v = implode(',', $v);
                 unset($unit);
                 break;
             case 'auf':
             case 'arrayufloat':
                 if (!is_array($v)) {
                     trigger_error('Parameter "' . ($k + 1) . '" must be an array becouse query contains "%' . $results[$k] . '".');
                 }
                 foreach ($v as &$unit) {
                     $unit = abs((double) $unit);
                 }
                 $v = implode(',', $v);
                 unset($unit);
                 break;
             default:
                 trigger_error('Unknown Parameter');
         }
     }
     unset($v);
     $tmp = [];
     foreach (self::$replacements as $v) {
         $tmp[] = '%' . $v;
     }
     return vsprintf(str_replace($tmp, '%s', $this->sql), $this->params);
 }
Exemplo n.º 14
0
<?php

use TMCms\Templates\VisualEdit;
VisualEdit::getInstance()->init();
if (!VisualEdit::getInstance()->isEnabled()) {
    return;
}
if (!isset($_POST['content'], $_POST['component'], $_POST['page_id'])) {
    return;
}
q('UPDATE `cms_pages_components`
SET `data` = "' . sql_prepare($_POST['content']) . '"
WHERE `page_id` = "' . (int) $_POST['page_id'] . '"
AND `component` = "' . sql_prepare($_POST['component']) . '"
');
echo json_encode(['status' => true]);
Exemplo n.º 15
0
/**
 * Basic webservice  interface.
 */
include 'packLoad.php';
// must be CONFIGURED for your database
//$db = new pdo($dsn,$PG_USER,$PG_PW);
$basePath = '/var/www/xconv.local/xconv3/_relats';
//realpath(__DIR__ .'/../..');
$reini = true;
// re-init all SQL structures of the project (drop and refresh schema)
$sqlMode = '1';
$packs = ['packs' => ['aff2' => ['file' => "{$basePath}/data/aff2-2016-01-21.csv", 'sep' => ',']]];
$sqlIni = ["::assert_bysql:data/assert1_mode{$sqlMode}.tsv"];
sql_prepare($sqlIni, "teste de ASSERT", "/home/peter/gits/sql-term");
die("\nOK3232\n");
sql_prepare("\n    CREATE TABLE IF NOT EXISTS tmp_aff2 (\n    lang text,\n    artigo_id int,\n    p_aff xml\n  );\n  ");
resourceLoad_run($basePath, ['aff2' => [['prepared_copy', "tmp_aff2"]]], "AFF2 test kit", $packs);
// carregar asserts automaticamente, incluir "SELEC onde nao começar por SELECT ou WITH "
# see table tstore.assert
/*

CREATE FUNCTION array_last(
	--
	-- Returns the element of array_upper()
	--
	anyarray,
	int DEFAULT 0
) RETURNS anyelement AS $f$
	SELECT $1[array_upper($1,1)-$2];
$f$ LANGUAGE SQL IMMUTABLE;
Exemplo n.º 16
0
 /**
  * Filter collection by value exclusive
  * @param $field
  * @param string $like_value
  * @param bool $left_any
  * @param bool $right_any
  * @param string $table
  * @return $this
  */
 public function addWhereFieldIsNotLike($field, $like_value, $left_any = true, $right_any = true, $table = '')
 {
     if (!$table) {
         $table = $this->getDbTableName();
     }
     $this->addWhereFieldAsString('`' . $table . '`.`' . $field . '` NOT LIKE "' . ($left_any ? '%' : '') . sql_prepare($like_value, true) . ($right_any ? '%' : '') . '"');
     return $this;
 }
Exemplo n.º 17
0
function merge_sentences($id1, $id2)
{
    check_permission(PERM_ADDER);
    if ($id1 < 1 || $id2 < 1) {
        throw new UnexpectedValueException();
    }
    // check same paragraph and adjacency
    $res = sql_pe("SELECT pos, par_id FROM sentences WHERE sent_id IN (?, ?) ORDER BY pos LIMIT 2", array($id1, $id2));
    $r1 = $res[0];
    $r2 = $res[1];
    $res = sql_query("SELECT pos FROM sentences WHERE par_id = " . $r1['par_id'] . " AND pos > " . $r1['pos'] . " AND pos < " . $r2['pos'] . " LIMIT 1");
    if ($r1['par_id'] != $r2['par_id'] || sql_num_rows($res) > 0) {
        throw new Exception();
    }
    //moving tokens
    sql_begin();
    $res = sql_pe("SELECT MAX(pos) AS maxpos FROM tokens WHERE sent_id=?", array($id1));
    sql_pe("UPDATE tokens SET sent_id=?, pos=pos+? WHERE sent_id=?", array($id1, $res[0]['maxpos'], $id2));
    //merging source text
    $res_src = sql_prepare("SELECT `source` FROM sentences WHERE sent_id=? LIMIT 1");
    sql_execute($res_src, array($id1));
    $r1 = sql_fetchall($res_src);
    sql_execute($res_src, array($id2));
    $r2 = sql_fetchall($res_src);
    sql_pe("UPDATE sentences SET source=? WHERE sent_id=? LIMIT 1", array($r1[0]['source'] . ' ' . $r2[0]['source'], $id1));
    //dropping status, moving comments
    sql_pe("UPDATE sentences SET check_status=0 WHERE sent_id=? LIMIT 1", array($id1));
    sql_pe("UPDATE sentence_comments SET sent_id=? WHERE sent_id=?", array($id1, $id2));
    sql_pe("DELETE FROM sentence_check WHERE sent_id=? OR sent_id=?", array($id1, $id2));
    // change syntax markup accordingly
    sql_pe("UPDATE syntax_parses SET sent_id = ? WHERE sent_id = ?", array($id1, $id2));
    //deleting sentence
    sql_pe("DELETE FROM sentence_authors WHERE sent_id=? LIMIT 1", array($id2));
    sql_pe("DELETE FROM sentences WHERE sent_id=? LIMIT 1", array($id2));
    sql_commit();
}
Exemplo n.º 18
0
function sql_pe($query, $params)
{
    // prepares and executes query, closes cursor
    // returns all the rows
    $res = sql_prepare($query);
    sql_execute($res, $params);
    try {
        return sql_fetchall($res);
    } catch (PDOException $e) {
        return array();
    }
}
Exemplo n.º 19
0
function update_annot_instance($id, $answer, $user_id = 0)
{
    if (!$user_id) {
        $user_id = $_SESSION['user_id'];
    }
    if (!$id || !$answer || !$user_id) {
        throw new UnexpectedValueException();
    }
    global $config;
    static $res = NULL;
    if ($res == NULL) {
        $res = sql_prepare("\n            SELECT pool_id, p.status, i.user_id, answer\n            FROM morph_annot_instances i\n            LEFT JOIN morph_annot_samples\n                USING (sample_id)\n            LEFT JOIN morph_annot_pools p\n                USING (pool_id)\n            WHERE instance_id = ?\n            LIMIT 1\n        ");
    }
    sql_execute($res, array($id));
    $inst = sql_fetchall($res);
    if (!sizeof($inst)) {
        throw new Exception("Instance not found");
    }
    $r = $inst[0];
    // the pool should be editable
    if ($r['status'] != MA_POOLS_STATUS_IN_PROGRESS) {
        throw new Exception("Пул недоступен для разметки");
    }
    $pool_id = $r['pool_id'];
    sql_begin();
    static $res_rejected = NULL;
    // does the instance really belong to this user?
    $previous_answer = $r['answer'] > 0;
    if ($r['user_id'] != $user_id) {
        // if another user has taken it, no chance
        if ($r['user_id'] > 0) {
            throw new Exception();
        }
        // or, perhaps, this user has rejected it before but has changed his mind
        if ($res_rejected == NULL) {
            $res_rejected = sql_prepare("SELECT sample_id FROM morph_annot_rejected_samples WHERE user_id=? AND sample_id = (SELECT sample_id FROM morph_annot_instances WHERE instance_id=? LIMIT 1) LIMIT 1");
        }
        sql_execute($res_rejected, array($user_id, $id));
        if (sql_num_rows($res_rejected) > 0) {
            $r = sql_fetch_array($res_rejected);
            sql_pe("DELETE FROM morph_annot_rejected_samples WHERE user_id=? AND sample_id=? LIMIT 1", array($user_id, $r['sample_id']));
            sql_pe("UPDATE morph_annot_instances SET user_id=?, ts_finish=? WHERE instance_id=? LIMIT 1", array($user_id, time() + $config['misc']['morph_annot_timeout'], $id));
        }
    }
    // a valid answer
    static $update = NULL;
    if ($update == NULL) {
        $update = sql_prepare("UPDATE morph_annot_instances SET user_id=?, answer=? WHERE instance_id=? LIMIT 1");
    }
    if ($answer > 0) {
        sql_execute($update, array($user_id, $answer, $id));
    } elseif ($answer == -1) {
        reject_annot_instance($id, $user_id);
    }
    sql_commit();
}
Exemplo n.º 20
0
 function find_all_words($name = NULL, $lang = NULL, $spart = NULL)
 {
     global $sql_stmts;
     $stmt = [];
     $params = [""];
     if ($name !== NULL) {
         $stmt[] = "word_name";
         $params[0] .= "s";
         $params[] = $name;
     }
     if ($lang !== NULL) {
         $stmt[] = "word_lang";
         $params[0] .= "s";
         $params[] = $lang;
     }
     if ($spart !== NULL) {
         $stmt[] = "word_spart";
         $params[0] .= "s";
         $params[] = $spart;
     }
     if (!count($stmt)) {
         _die("bad arguments: need one non-NULL");
     }
     $stmt = $sql_stmts["word_id<-" . implode(",", $stmt)];
     $res = NULL;
     sql_getmany(sql_prepare($stmt), $res, $params);
     foreach ($res as &$r) {
         $r = WORD($this, $r);
     }
     return $res;
 }
Exemplo n.º 21
0
function save_user_options($post)
{
    if (!isset($post['options'])) {
        throw new UnexpectedValueException();
    }
    check_logged();
    sql_begin();
    $upd = sql_prepare("UPDATE user_options_values SET option_value=? WHERE option_id=? AND user_id=? LIMIT 1");
    foreach ($post['options'] as $id => $value) {
        if ($_SESSION['options'][$id]['value'] != $value) {
            sql_execute($upd, array($value, $id, $_SESSION['user_id']));
            $_SESSION['options'][$id] = $value;
        }
    }
    sql_commit();
}
Exemplo n.º 22
0
function revert_changeset($set_id, $comment)
{
    if (!$set_id) {
        throw new UnexpectedValueException();
    }
    check_permission(PERM_DICT);
    sql_begin();
    $new_set_id = create_revset($comment);
    $dict_flag = 0;
    $res = sql_pe("SELECT tf_id FROM tf_revisions WHERE set_id=?", array($set_id));
    $res_revtext = sql_prepare("SELECT rev_text FROM tf_revisions WHERE tf_id=? AND set_id<? ORDER BY rev_id DESC LIMIT 1");
    foreach ($res as $r) {
        sql_execute($res_revtext, array($r[0], $set_id));
        $arr = sql_fetch_array($res_revtext);
        create_tf_revision($new_set_id, $r[0], $arr[0]);
    }
    $res_revtext->closeCursor();
    $res = sql_pe("SELECT lemma_id FROM dict_revisions WHERE set_id=?", array($set_id));
    $res_revtext = sql_prepare("SELECT rev_text FROM dict_revisions WHERE lemma_id=? AND set_id<? ORDER BY rev_id DESC LIMIT 1");
    foreach ($res as $r) {
        sql_execute($res_revtext, array($r[0], $set_id));
        $arr = sql_fetch_array($res_revtext);
        new_dict_rev($r[0], $arr[0], $new_set_id);
        $dict_flag = 1;
    }
    $res_revtext->closeCursor();
    sql_commit();
    if ($dict_flag) {
        return 'dict_history.php';
    }
    return 'history.php';
}
Exemplo n.º 23
0
function sql_stmt($name)
{
    global $sql_stmts;
    if (is_string($sql_stmts[$name])) {
        $sql_stmts[$name] = sql_prepare($sql_stmts[$name]);
    }
    return $sql_stmts[$name];
}
Exemplo n.º 24
0
function set_ne_tags($entity_id, $tags, $annot_id = 0)
{
    // overwrites old set of tags
    // TODO check that tags and annotation belong to the same tagset
    if (!$annot_id) {
        $res = sql_pe("SELECT annot_id FROM ne_entities WHERE entity_id = ?", array($entity_id));
        $annot_id = $res[0]['annot_id'];
    }
    if (!check_ne_paragraph_status($annot_id, $_SESSION['user_id'])) {
        throw new Exception();
    }
    sql_begin();
    sql_pe("DELETE FROM ne_entity_tags WHERE entity_id = ?", array($entity_id));
    $res = sql_prepare("INSERT INTO ne_entity_tags VALUES(?, ?)");
    foreach ($tags as $tag) {
        sql_execute($res, array($entity_id, $tag));
    }
    sql_commit();
}