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; }
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; }
function sql_gettable($myc, $tblname, $condition) { return sql_readtable($myc, $tblname, $condition); }
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; } }
function load_channelgroups($myc) { $chg = sql_readtable($myc, 'channelgroups', ""); return $chg; }
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; }