How to add automatic adding users in the telegram bot group without using any marketing software

how to add an automatic user in the telegram bot group with nodejs without using any software,
I tried to use my api but I did not find any solution to call the api in bot
Now I am so confused how to add without telegram marketing software

Adding subcategory to the package product on the product page (magento 2)

Is there any way to add subcategory in the product package in magneto 2

menu and submenu

linux – Firewall Blocks NAT traffic suddenly after adding a NIC

I have a server that used to have a NIC, but I added a second to provide a dedicated link to the TV tuner.

I went from having eth0 (the integrated NIC) to enp7s0 (the new NIC) and enp9s1 (the new name for the integrated NIC).

All services were updated to use the new interface names.

My iptables script was updated to use the new interface names in adapter-specific rules (everything uses enp9s1, except the DHCP server and a UDP port in enp7s0)

The configuration of my router did not change, and since the MAC address has not changed, it must still give the NIC the same IP address (and it does).

But, I'm baffled as to why everything works locally and suddenly nothing works on NAT. I can see that the router is forwarding packets, but the server still rejects them. Even after disabling the firewall completely temporarily, it still does not work. All I did was add a NIC.

So, how do I get the server to accept NATed packages again?

Attached is my firewall script:

#! / bin / bash

# ===========================================
# Command Aliases
# (to write faster)
# ===========================================
ip4 = & # 39; / sbin / iptables & # 39;
ip6 = & # 39; / sbin / ip6tables & # 39;

# logical interface names
nicmobo = & # 39; enp9s1 & # 39;
nicext1 = & # 39; enp7s0 & # 39;

# ===========================================
# Download rules, delete
# chains, zero counters
# ===========================================
$ ip4 -F; $ ip4 -X; $ ip4 -Z
$ ip6 -F; $ ip6 -X; $ ip6 -Z

# ===========================================
# Default rules
# ===========================================

# ----------------------
# IPv4
# ----------------------

# Delete all incoming connections by default
$ ip4 -P INPUT DROP
$ ip4 -P DROP FORWARD
$ ip4 -P OUTPUT I ACCEPT

# Allow all connections from the loopback interface
$ ip4 -A ENTRADA -i lo -j ACCEPT
# Allow all incoming connections related / established
$ ip4 -A ENTRY -m conntrack --ctstate ESTABLISHED, RELATED -j ACCEPT

# ----------------------
# IPv6
# ----------------------
# Delete all the incoming by default, restore the output
$ ip6 -P DROP ENTRY
$ ip6 -P DROP FORWARD
$ ip6 -P OUTPUT ACCEPT

# Allow loopback interface
$ ip6 -A ENTRADA -i lo -j ACCEPT

# Reject connection attempt not started from the host
# $ ip6 -A ENTRY -p tcp --syn -j GOTA

# Allow return connections initiated from the host
$ ip6 -A ENTRY -m conntrack --ctstate ESTABLISHED, RELATED -j ACCEPT

# Acceot ICMPv6 Packages
$ ip6 -A ENTRY -p ipv6-icmp -j ACCEPT


# ===========================================
# SSH connections in mobo
# ===========================================

# Allow incoming SSH connections on the ssh listening port (currently
# port 22 at the time of writing this)
$ ip4 -A ENTRY -p tcp -m tcp --dport 22 -j ACCEPT
$ ip6 -A ENTRY -p tcp -m tcp --dport 22 -j ACCEPT
# Also allows SSH in 2322 from the local LAN
$ ip4 -A ENTRY -s 172.26.62.0/23 -p tcp -m tcp -m status --state NEW --port 2322 -j ACCEPT


# ===========================================
# VPN Ports in Mobo
# ===========================================

# Allow L2TP / IPSEC UDP Ports 500, 4500
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW status -m udp -p udp --dport 500 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW status -m udp -p udp --dport 500 -j ACCEPT
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW status -m udp -p udp --dport 4500 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW status -m udp -p udp --dport 4500 -j ACCEPT
# Allow incoming TCP 992 for VPN connections
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 992 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 992 -j ACCEPT
# Allow incoming TCP 1194 for openVPN TCP connections
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 1194 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 1194 -j ACCEPT
# Allow incoming UDP 1194 for openVPN connections
$ ip4 -i $ nicmobo -A ENTRY -m status --state NEW -m udp -p udp --dport 1194 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW status -m udp -p udp --dport 1194 -j ACCEPT
# Allow incoming TCP 5555 for TCP VPN connections
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 5555 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 5555 -j ACCEPT


# ===========================================
# Emby HTTPS Non-standard port (8920) in mobo
# ===========================================
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 8920 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 8920 -j ACCEPT


# =================================================
# HDHomerun Discovery Ports Allow only from prvate lan (second NIC)
# =================================================
$ ip4 -i $ nicext1 -A ENTRY -s 172.27.0.0/28 -p udp -m status --state NEW -m udp --sport 65001 -j ACCEPT


# =================================================
# Puerto 80, 443 in Mobo
# =================================================
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 80 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 80 -j ACCEPT
$ ip4 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 443 -j ACCEPT
$ ip6 -i $ nicmobo -A ENTRY -m status - NEW state -m tcp -p tcp --dport 443 -j ACCEPT

# =================================================
# SAMBA on the local network in mobo
# =================================================
$ ip4 -i $ nicmobo -A ENTRY -s 172.26.62.0/23 -p tcp -m status --state NEW -m tcp --dport 139 -j ACCEPT
$ ip4 -i $ nicmobo -A ENTRY -s 172.26.62.0/23 -p tcp -m status --state NEW -m tcp --dport 445 -j ACCEPT
$ ip4 -i $ nicmobo -A ENTRY -s 172.26.62.0/23 -p udp -m status --state NEW -m udp --dport 137 -j ACCEPT
$ ip4 -i $ nicmobo -A ENTRY -s 172.26.62.0/23 -p udp -m status --state NEW -m udp --dport 138 -j ACCEPT

# =================================================
# Allow DHCP to private LAN (second NIC)
# =================================================
$ ip4 -i $ nicext1 -A ENTRY -s 172.27.0.0/28 -p udp -m status --state NEW -m udp --dport 67 --sport 68 -j ACCEPT


exit 0

I get some error messages in the field of adding & # 39; type_login & # 39; in the php script

I want to add a "type_login" field from which I get some error messages
PHP Script Missing the code please help me …

error ->

Warning: mysqli_stmt_bind_param (): the number of elements in the type definition string does not match the number of link variables in D: xammp htdocs raisebux admin member-register.php on line 85

line no. 85

mysqli_stmt_bind_param ($ stmt, "ss", $ param_username, $ param_password,
$ param_type);

start of table session

insert this type in a data table

user_id | username password | type_login
1 | abcd xxxxxxxx | one
2 | avcd | xxxxxxxx | two
3 | hbcd xxxxxxxx | 3

PHP insert script here …

yes ($ _ SERVER["REQUEST_METHOD"] == "POST") {

yes (empty (trim ($ _ POST)["username"]))) {
$ username_err = "Please enter a username.";
} else {
$ sql = "SELECT user_id FROM login WHERE username =?";

if ($ stmt = mysqli_prepare ($ conn, $ sql)) {
mysqli_stmt_bind_param ($ stmt, "s", $ param_username);

$ param_username = trim ($ _ POST["username"]);

if (mysqli_stmt_execute ($ stmt)) {
mysqli_stmt_store_result ($ stmt);

if (mysqli_stmt_num_rows ($ stmt) == 1) {
$ username_err = "This username is already in use.";
} else {
$ username = trim ($ _ POST["username"]);
}
} else {
echo "Wow, something went wrong, try again later.";
}
}

mysqli_stmt_close ($ stmt);
}
// ------------------------
yes (empty (trim ($ _ POST)["type_login"]))) {
$ type_login_err = "Select user type";
} else {
$ sql = "SELECT type_login FROM login WHERE type_login =?";

if ($ stmt = mysqli_prepare ($ conn, $ sql)) {
mysqli_stmt_bind_param ($ stmt, "s", $ param_type);

$ param_type = trim ($ _ POST["type_login"]);


}

mysqli_stmt_close ($ stmt);
}



// ------------------------
yes (empty (trim ($ _ POST)["password"]))) {
$ password_err = "Please enter a password.";
} elseif (strlen (trim ($ _ POST["password"])) < 6){
        $password_err = "Password must have atleast 6 characters.";
    } else{
        $password = trim($_POST["password"]);
    }

    if(empty(trim($_POST["confirm_password"]))){
        $confirm_password_err = "Please confirm password.";     
    } else{
        $confirm_password = trim($_POST["confirm_password"]);
        if(empty($password_err) && ($password != $confirm_password)){
            $confirm_password_err = "Password did not match.";
        }
    }



    if(empty($username_err) && empty($password_err) && empty($confirm_password_err) && empty($type_login_err)){

        $sql = "INSERT INTO login (username, password, type_login) VALUES (?, ?, ?)";

        if($stmt = mysqli_prepare($conn, $sql)){
            mysqli_stmt_bind_param($stmt, "ss", $param_username, $param_password, $param_type);

            $param_username = $username;
          $param_type = $type_login;
            $param_password = password_hash($password, PASSWORD_DEFAULT); 

            if(mysqli_stmt_execute($stmt)){
                header("location: sign-in.php");
            } else{
                echo "Something went wrong. Please try again later.";
            }
        }
        mysqli_stmt_close($stmt);
    }
    mysqli_close($conn);
}
?>

html form here

<form action = ""method =" post ">

<div class = "form-group ">

            

            <input type = "text" name = "username" class = "form-control" value = "">

            

        
<div class = "form-group "> <input type = "password" name = "password" class = "form-control" value = "">
<div class = "form-group "> <input type = "password" name = "confirm_password" class = "form-control" value = "">