XoopsModules25x / efqdirectory

 * @param $locdestid

 * @return int

 */

function GetLevelid($locdestid)

{

    global $xoopsDB;

    $block        = array();

    $myts         = MyTextSanitizer::getInstance();

    $result2      = $xoopsDB->query('SELECT locid, levelid FROM ' . $xoopsDB->prefix('dst_loc') . ' WHERE locid = ' . $locdestid . '');

    $num_results2 = $GLOBALS['xoopsDB']->getRowsNum($result2);

    if (!$result2) {

        return 0;

    }

    for ($i = 0; $i < $num_results2; ++$i) {

        $row2    = $GLOBALS['xoopsDB']->fetchBoth($result2);

        $levelid = $row2['levelid'];

    }

    return $levelid;

}

/**

 * @param $locdestid

 * @param $locdestid

 * @return int

 */

function GetLocName($locdestid)

{

    global $xoopsDB;

    $block       = array();

    $myts        = MyTextSanitizer::getInstance();

    $result      = $xoopsDB->query('SELECT locid, name FROM ' . $xoopsDB->prefix('dst_loc') . ' WHERE locid = ' . $locdestid . '');

    $num_results = $GLOBALS['xoopsDB']->getRowsNum($result);

    if (!$result) {

        return 0;

    }

    for ($i = 0; $i < $num_results; ++$i) {

        $row     = $GLOBALS['xoopsDB']->fetchBoth($result);

        $locname = $myts->htmlSpecialChars($row['name']);

    }

    return $locname;

}

include XOOPS_ROOT_PATH . '/footer.php';