XoopsModules25x / xfguestbook

 * @param $country_code

 * @param $country_name

 */

function countrySave($country_id, $country_code, $country_name)

{

    global $xoopsDB;

    $myts = MyTextSanitizer::getInstance();

    //$country_code=$myts->makeTboxData4Save::$country_code;

    //$country_name=$myts->makeTboxData4Save::$country_name;

    echo $country_code;

    if (!empty($country_id)) {

        $sql = 'UPDATE ' . $xoopsDB->prefix('xfguestbook_country') . " SET country_code='$country_code', country_name='$country_name'";

        $sql .= " WHERE country_id=$country_id";

        $xoopsDB->query($sql);

        $messagesent = _AM_XFGB_COUNTRY_UPDATED;

    } else {

        $sql = sprintf("SELECT COUNT(*) FROM  %s WHERE country_code = '%s'", $xoopsDB->prefix('xfguestbook_country'), $country_code);

        list($count) = $xoopsDB->fetchRow($xoopsDB->query($sql));

        if ($count > 0) {

            $messagesent = '<font color="#FF0000">' . _AM_XFGB_COUNTRY_EXIST . '</font>';

        } else {

            $country_id = $xoopsDB->genId('country_id_seq');

            $sql        =

                sprintf("INSERT INTO %s (country_id, country_code, country_name) VALUES (%s, '%s', '%s')", $xoopsDB->prefix('xfguestbook_country'), $country_id, $country_code, $country_name);

            $xoopsDB->query($sql);

            $messagesent = _AM_XFGB_COUNTRY_ADDED;

        }

    }

    redirect_header('country_manager.php', 2, $messagesent);

    exit();

}

function countryShow()

{

 * @param $ip_id

 * @param $ip_value

 */

function badIpSave($ip_id, $ip_value)

{

    global $xoopsDB;

    $myts = MyTextSanitizer::getInstance();

    //$ip_value=$myts->makeTboxData4Save($ip_value);

    if (!empty($ip_id)) {

        $sql = 'UPDATE ' . $xoopsDB->prefix('xfguestbook_badips') . " SET ip_id='$ip_id', ip_value='$ip_value'";

        $sql .= " WHERE ip_id = $ip_id";

        $xoopsDB->query($sql);

        $messagesent = _AM_XFGB_BADIP_UPDATED;

    } else {

        $sql = sprintf("SELECT COUNT(*) FROM  %s WHERE ip_value = '%s'", $xoopsDB->prefix('xfguestbook_badips'), $ip_value);

        list($count) = $xoopsDB->fetchRow($xoopsDB->query($sql));

        if ($count > 0) {

            $messagesent = '<font color="#FF0000">' . _AM_XFGB_BADIP_EXIST . '</font>';

        } else {

            $country_id = $xoopsDB->genId('ip_id_seq');

            $sql        = sprintf("INSERT INTO %s (ip_id, ip_value) VALUES (%s, '%s')", $xoopsDB->prefix('xfguestbook_badips'), $ip_id, $ip_value);

            $xoopsDB->query($sql);

            $messagesent = _AM_XFGB_BADIP_ADDED;

        }

    }

    redirect_header('ip_manager.php', 2, $messagesent);

    exit();

}

function badIpShow()

{