Need 3 changes in a MySql Script

Closed Posted 2 years ago Paid on delivery
Closed

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

MySQL PHP Database Administration SQL

Project ID: #31525322

About the project

25 proposals Remote project Active 2 years ago

25 freelancers are bidding on average $12/hour for this job

MaximSky

Hello, I can make this changes to your program. I'm PHP and MySQL expert with 8+ years of experience. You can check my reviews here: https://www.freelancer.com/u/MaximSky Let's discuss details in chat. Regards, M More

$15 USD / hour
(102 Reviews)
7.1
developer2581

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

$12 USD / hour
(69 Reviews)
7.3
ShrineWeb

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

$10 USD / hour
(133 Reviews)
6.8
saubhagyamweb

********************************************** 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

$15 USD / hour
(35 Reviews)
6.6
testotorko

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.

$10 USD / hour
(121 Reviews)
5.8
worldbestcon

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.

$10 USD / hour
(80 Reviews)
5.8
AlikAgaian

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

$15 USD / hour
(18 Reviews)
5.5
oleksdevr

Hi, welcome. I am Andrii From Ukraine I have carefully read the job description. MySQL is my outstanding professional skill. I am having more than 5 years' experience in this field. My propose is not to waste your ti More

$10 USD / hour
(15 Reviews)
5.6
webzonenetwork80

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

$10 USD / hour
(34 Reviews)
5.2
gurdishaleks

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

$15 USD / hour
(3 Reviews)
4.7
dubine

Hello. I am a fullstack developer with 5 years of experience in developing website. I am familiar with html, css, javascript, CodeIgniter, Laravel, Wordpress, MySQL and website design. I am interested in your job and More

$12 USD / hour
(6 Reviews)
4.2
vkavtiashvili

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

$12 USD / hour
(3 Reviews)
2.6
stromilovandrey

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

$10 USD / hour
(0 Reviews)
0.0
omer19

hello, I have seen that you need an experienced DBMS expert for 3 changes in a MySql Script. I am a professional DB expert with more than 10 years experience. I have carefully understood your project requirements a More

$12 USD / hour
(0 Reviews)
0.0
jorora8333

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

$12 USD / hour
(0 Reviews)
0.0
SvvssSoft

I Can Assist you with the entire software development life cycle. 1. Understand the requirements 2. Understand the Design.(Including Proper coding standards) 3. Implementing the design. 4. Unit Testing. 5. Deployment. More

$12 USD / hour
(0 Reviews)
0.0