Need 3 changes in a MySql Script

Suljettu Julkaistu 2 vuotta sitten Maksettu toimituksen yhteydessä
Suljettu

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 Tietokannan hallinto SQL

Projektin tunnus: #31525322

Tietoa projektista

25 ehdotusta Etäprojekti Aktiivinen 2 vuotta sitten

25 freelanceria on tarjonnut keskimäärin $12/tunti tähän työhön

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 Lisää

$15 USD / tunti
(102 arvostelua)
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 Lisää

$12 USD / tunti
(69 arvostelua)
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 / tunti
(133 arvostelua)
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 Lisää

$15 USD / tunti
(35 arvostelua)
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 / tunti
(121 arvostelua)
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 / tunti
(80 arvostelua)
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 Lisää

$15 USD / tunti
(18 arvostelua)
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 Lisää

$10 USD / tunti
(15 arvostelua)
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 / tunti
(34 arvostelua)
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 Lisää

$15 USD / tunti
(3 arvostelua)
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 Lisää

$12 USD / tunti
(6 arvostelua)
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 Lisää

$12 USD / tunti
(3 arvostelua)
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 Lisää

$10 USD / tunti
(0 arvostelua)
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 Lisää

$12 USD / tunti
(0 arvostelua)
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 Lisää

$12 USD / tunti
(0 arvostelua)
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. Lisää

$12 USD / tunti
(0 arvostelua)
0.0