Exemplo n.º 1
0
function sql_loadTransCats($myc, $uvjet)
{
    global $dconf, $debug;
    $chdb = sql_readtable($myc, 'trans_cat', $uvjet);
    if (!$chdb) {
        return false;
    }
    array_sort($chdb, "type");
    return $chdb;
}
Exemplo n.º 2
0
function loadlanguage($module)
{
    global $myc;
    global $dconf;
    $lang = $dconf['language'];
    $cond = "module='" . $module . "' AND language='" . $lang . "'";
    if ($module) {
        $langdb = sql_readtable($myc, "languagestrings", $cond);
    } else {
        $langdb = sql_readtable($myc, "lang_" . $lang, "");
    }
    if (!$langdb) {
        return false;
    }
    reset($langdb);
    while (list($lk, $lv) = each($langdb)) {
        $lngstr[$lv['strname']] = $lv['strvalue'];
    }
    return $lngstr;
}
Exemplo n.º 3
0
function sql_gettable($myc, $tblname, $condition)
{
    return sql_readtable($myc, $tblname, $condition);
}
Exemplo n.º 4
0
function sql_findService($myc, $kaj, $vrijednost)
{
    global $dconf, $debug;
    switch ($kaj) {
        case 'somefieldname':
            // walk through multiline text fields
            $cond = $kaj . " LIKE '%" . $vrijednost . "%'";
            return false;
            // ??????????
        // ??????????
        default:
            $cond = $kaj . "='" . $vrijednost . "'";
            break;
    }
    $sn = sql_readtable($myc, 'services', $cond);
    if ($debug) {
        dbg("sql_findService", $sn);
    }
    if (sizeof($sn) == 1) {
        // fix multiline text fields
        //$sn[0][somefieldname] = split ("\n", $sn[0][fwrules]);
        return $sn[0];
    } else {
        return false;
    }
}
Exemplo n.º 5
0
function load_channelgroups($myc)
{
    $chg = sql_readtable($myc, 'channelgroups', "");
    return $chg;
}
Exemplo n.º 6
0
function sql_findProgram($myc, $channel, $kaj, $vrijednost)
{
    global $dconf, $debug;
    $cond = "channel_id='" . $channel . "'";
    if (strlen(trim($kaj))) {
        switch ($kaj) {
            case 'fwrules':
                // walk through multiline text fields
            // walk through multiline text fields
            case 'ranges':
            case 'unranges':
            case 'routers':
            case 'staticroutes':
            case 'nameservers':
            case 'unnameservers':
            case 'winsservers':
            case 'unwinsservers':
                $cond .= " AND " . $kaj . " LIKE '%" . $vrijednost . "%'";
                return false;
                // ??????????
            // ??????????
            default:
                $cond .= " AND " . $kaj . "='" . $vrijednost . "'";
                break;
        }
    }
    $sn = sql_readtable($myc, 'programs', $cond);
    if ($debug) {
        dbg("sql_findProgram", $sn);
    }
    return $sn;
}