Đã Đóng

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

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

Kĩ năng: MySQL, PHP, Quản trị cơ sở dữ liệu, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 7 nhận xét ) Bang Saray, Germany

ID dự án: #31525322

28 freelancer chào giá trung bình $12/giờ cho công việc này

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 Thêm

$15 USD / giờ
(91 Nhận xét)
7.1
(119 Nhận xét)
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 Thêm

$12 USD / giờ
(49 Nhận xét)
7.1
(36 Nhận xét)
6.2
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 / giờ
(73 Nhận xét)
6.2
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 Thêm

$15 USD / giờ
(17 Nhận xét)
5.7
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 / giờ
(108 Nhận xét)
5.8
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 / giờ
(34 Nhận xét)
5.2
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 Thêm

$15 USD / giờ
(15 Nhận xét)
5.1
RanaNadeemTahir

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 / giờ
(29 Nhận xét)
4.6
rhlmeena35

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 / giờ
(46 Nhận xét)
4.7
mandavcon

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 Thêm

$15 USD / giờ
(7 Nhận xét)
4.6
AslamShariff

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 Thêm

$12 USD / giờ
(2 Nhận xét)
4.1
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 / giờ
(29 Nhận xét)
4.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 Thêm

$15 USD / giờ
(1 Nhận xét)
3.2
sweb1433

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. Thêm

$12 USD / giờ
(3 Nhận xét)
3.9
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 Thêm

$12 USD / giờ
(1 Nhận xét)
2.6
Websilicom

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 Thêm

$10 USD / giờ
(3 Nhận xét)
2.5
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 Thêm

$12 USD / giờ
(2 Nhận xét)
2.2
olenavyhivska

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 Thêm

$12 USD / giờ
(2 Nhận xét)
1.4