Need 3 changes in a MySql Script

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


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


Habilidades: MySQL, PHP, Administração de Bancos de Dados, SQL

Veja mais: csv mysql script, mssql script mysql script, mysql modify sql dump file, mysql importing sql gzip file, mssql mysql script, flash cms mysql script, hotel web application php mysql script, simple php mysql script users, create script allows users forward address lotus notes, script profile sql users, mysql import sql script, convert mysql script sql script using vbnet, php mysql run script sql, convert sql script mysql script, php mysql script changes, i have an existing php/mysql script that i need customized with additional functions, need a quick mysql script, convert mysql script to sql server, sql server migration assistant v5.3 for mysql

Acerca do Empregador:
( 7 comentários ) Bang Saray, Germany

ID do Projeto: #31525322

28 freelancers estão ofertando em média $12/hora nesse trabalho


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 Mais

$15 USD / hora
(91 Comentários)
(119 Comentários)

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 Mais

$12 USD / hora
(49 Comentários)
(36 Comentários)

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 / hora
(73 Comentários)

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

$15 USD / hora
(17 Comentários)

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 / hora
(108 Comentários)

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 / hora
(34 Comentários)

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 Mais

$15 USD / hora
(15 Comentários)

hi i am expert in php queries and ready to manage the requests dependet of IP addresses . contact back so i can start it now.i can deliver this [login to view URL]

$8 USD / hora
(29 Comentários)

Hi, i understood your project details very well and i can finish the same in your timeline. come over chat to further discuss

$12 USD / hora
(46 Comentários)

Hi, Greetings for the Day! I am glad to offer you my services as a Sr. Software Developer. I am working in the Software Industry for last 9 years. Worked for more than 4000 Hours as freelancer. I have worked on SAML b Mais

$15 USD / hora
(7 Comentários)

Hello there, I’ve read the job description about changes in MySql and believe that I can help you with it. I have good hands in Ionic, Angular, html5/css3, JavaScript, jQuery, Ajax... I have Skills in PHP, MySQL, Magen Mais

$12 USD / hora
(2 Comentários)

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 / hora
(29 Comentários)

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 Mais

$15 USD / hora
(1 Comentário)

Hello there, I am website developer. I went through your requirements and would like to be a part of it and help you acheiving it. I strictly follow the software development standard and and my work is client centric. Mais

$12 USD / hora
(3 Comentários)

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 Mais

$12 USD / hora
(1 Comentário)

Hi there, I have read your requirement and you want a to add IP address in DB and file. If IP is already exist in DB then proceed and do nothing. If not present then add in DB as well in file. If account of user expir Mais

$10 USD / hora
(3 Comentários)

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 Mais

$12 USD / hora
(2 Comentários)

Hi, there I hope everything goes well with you. I just read your job description and very intesting on your project. I am professional MySQL developer. I have rich experience with Javascript, MySQL, HTML5, Node.js, Rea Mais

$12 USD / hora
(2 Comentários)