Need 3 changes in a MySql Script
$8-15 USD / hour
Need 3 changes in a SQL Script
Users will add the IP address to a database using this link
The database is a *.db file
http://<ipaddr>/autoadd?username=username>&password=password
1. After the IP is written in the database at the same time the IP is written into the /etc/iptables/[login to view URL]' file
The current problem is, you can add the same IP multiple times into the database and the same IP is written multiple times in the /etc/iptables/[login to view URL]' file
We need to solve:
- Check if the IP already exists in the database,
if the IP addres is the same "do nothing"
- If there is a new IP:
delete the old IP from the database and add the new IP into the database
- as well we need to delete the old IP in the /etc/iptables/[login to view URL] and add the new IP into /etc/iptables/[login to view URL]
2. If the account from an user is expired in the database we need to delete his IP from the database and delete it from the file and from /etc/iptables/[login to view URL]
I prefer a freelancers from Ukraine and Russia
Thanks
Project ID: #31525322
About the project
25 freelancers are bidding on average $12/hour for this job
Hi, I read the details about your project "Need 3 changes in a MySql Script -".I can Design and Develop your Mobile & Web app within the given time and develop it using the Technologies Mentioned. I have 10 years of More
I have a few questions regarding the specs that you have provided. Could we please have a chat? My Skills: PHP, MySQL, SQL and Database Administration
********************************************** Hello edomm, I’m a Professional and Expert website Developer. I am interested in doing this job for you. I do have necessary skill set & resources to complete this proje More
Hey. I am an experienced Web Developer and have worked with wide variety of skills like PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS and more for many years. Can start right now.
hello i will solve you issues with your address with your PHP. I will provide you this function then you will be overright your ip with your database. please come on chat for start it Quick. thanks.
Hello, Hope you are fine. Before anything else, Can I ask one question? What script language did you use currently? I am MySQL expert and will provide you 100% quality work according to the requirements. Let's disc More
Hello, I am a Professional MySql developer, I am ready to do changes in ur script, have checked details please send me message for Quick discussion! Thank you
Hi there, i have read your job description and it is really easy task for mysql expert. You required 2 problem fixed, First one should be easy and Second one should take some more time than first one. But totally it i More
Hello. I have read your description carefully, and I think it suits me very well. I have a lot of experience with MySQL and have been developing using it for more than 5 years . Furthermore, I will be sure to finish yo More
Hello Dear! I have read your project description and I can Assist you with your projects. Please initiate a chat to discuss further. I guarantee you 100% satisfaction and support. I am available and ready to start imme More
Hi, I'm a senior in Website and App Development. I read the job details extremely carefully. I think I can help you to complete your project with my rich knowledge and experience. I'm ready to do it now. Should you req More