中國人民大吃大喝中國人民大吃大喝中國人民大吃大喝中國人民大吃大喝
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 25 -j DNAT --to-destination 192.168.1.104:25
#iptables -t nat -A POSTROUTING -s 192.168.0.0/255.255.0.0 -d 192.168.1.104 -p tcp -m tcp --dport 25 -j SNAT --to-source 192.168.1.101
#iptables -A INPUT -d 192.168.1.104 -p tcp -m tcp --dport 25 -i eth0 -j ACCEPT
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 110 -j DNAT --to-destination 192.168.1.104:110
#iptables -t nat -A POSTROUTING -s 192.168.0.0/255.255.0.0 -d 192.168.1.104 -p tcp -m tcp --dport 110 -j SNAT --to-source 192.168.1.101
#iptables -A INPUT -d 192.168.1.104 -p tcp -m tcp --dport 110 -i eth0 -j ACCEPT
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 803 -j DNAT --to-destination 110.75.125.15:22
#iptables -t nat -A POSTROUTING -d 110.75.125.15 -p tcp -m tcp --dport 22 -j SNAT --to-source 172.19.255.19
#iptables -A INPUT -d 110.75.125.15 -p tcp -m tcp --dport 803 -i eth1 -j ACCEPT
#從61.164.116.24的8002轉到219.90.127.198的8002
#iptables -t nat -A PREROUTING -d 61.164.116.24 -p tcp -m tcp --dport 8002 -j DNAT --to-destination 219.90.127.198:8002
#iptables -t nat -A POSTROUTING -d 219.90.127.198 -p tcp -m tcp --dport 8002 -j SNAT --to-source 61.164.116.24
#iptables -A INPUT -d 219.90.127.198 -p tcp -m tcp --dport 80 -i eth0 -j ACCEPT
#sysctl -w net.ipv4.ip_forward=1 >>/etc/sysctl.conf
#service iptables save
#select sort.* from(select tmp.*,(select count(*)+1 from Post where date(CreateTime) = date(tmp.CreateTime) and PostId < tmp.PostId) as tmp_order_id from Post tmp) sort where sort.tmp_order_id <= 20
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 25 -j DNAT --to-destination 192.168.1.104:25
#iptables -t nat -A POSTROUTING -s 192.168.0.0/255.255.0.0 -d 192.168.1.104 -p tcp -m tcp --dport 25 -j SNAT --to-source 192.168.1.101
#iptables -A INPUT -d 192.168.1.104 -p tcp -m tcp --dport 25 -i eth0 -j ACCEPT
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 110 -j DNAT --to-destination 192.168.1.104:110
#iptables -t nat -A POSTROUTING -s 192.168.0.0/255.255.0.0 -d 192.168.1.104 -p tcp -m tcp --dport 110 -j SNAT --to-source 192.168.1.101
#iptables -A INPUT -d 192.168.1.104 -p tcp -m tcp --dport 110 -i eth0 -j ACCEPT
#iptables -t nat -A PREROUTING -d 172.19.255.19 -p tcp -m tcp --dport 803 -j DNAT --to-destination 110.75.125.15:22
#iptables -t nat -A POSTROUTING -d 110.75.125.15 -p tcp -m tcp --dport 22 -j SNAT --to-source 172.19.255.19
#iptables -A INPUT -d 110.75.125.15 -p tcp -m tcp --dport 803 -i eth1 -j ACCEPT
#從61.164.116.24的8002轉到219.90.127.198的8002
#iptables -t nat -A PREROUTING -d 61.164.116.24 -p tcp -m tcp --dport 8002 -j DNAT --to-destination 219.90.127.198:8002
#iptables -t nat -A POSTROUTING -d 219.90.127.198 -p tcp -m tcp --dport 8002 -j SNAT --to-source 61.164.116.24
#iptables -A INPUT -d 219.90.127.198 -p tcp -m tcp --dport 80 -i eth0 -j ACCEPT
#sysctl -w net.ipv4.ip_forward=1 >>/etc/sysctl.conf
#service iptables save
#select sort.* from(select tmp.*,(select count(*)+1 from Post where date(CreateTime) = date(tmp.CreateTime) and PostId < tmp.PostId) as tmp_order_id from Post tmp) sort where sort.tmp_order_id <= 20