Ip Logging system needed

[harryb12]

Hello everyone


I am a reseller host and i am currently looking for a secure MY SQL way of logging visitors ip address because of the amount of times my pages get damaged or deleted through hacking and i would like to find a secure way to log their ips can any one point me in a general direction without saying search google because i have and not many secure ones


Thanks

Best Regards

Harryb12

[Forbzey]

You can use a JavaScript command to find a users IP Address and use AJAX to put it into an SQL! I can't remember how it is done exactly plus it's not reliable as one of your hackers can get around it by simply Disabling JavaScript on their browser

If you still want the JavaScript command let me know and I'll look for it for you!!

[Forbzey]

EDIT: There is a way through PHP as well!
It can be done this way:

<?php
$ip=$_SERVER['REMOTE_ADDR']; // REMOTE_ADDR = visitors IP Address!
mysql_connect(server,username,password);
mysql_select_db(database);

$sql="INSERT $ip INTO table_name";
mysql_query($sql);
?>

Hope that helps!

[hiteckart]

Why not just use the Cpanel's Weblizer for the ip's and pages in question?

[harryb12]

You can use a JavaScript command to find a users IP Address and use AJAX to put it into an SQL! I can't remember how it is done exactly plus it's not reliable as one of your hackers can get around it by simply Disabling JavaScript on their browser

If you still want the JavaScript command let me know and I'll look for it for you!!

can you have a look for me please dude

[harryb12]

Why not just use the Cpanel's Weblizer for the ip's and pages in question?

Hey dude my web host is not hosted by free space and my host doesnt have a webalizer

[Forbzey]

can you have a look for me please dude

I have tried searching everywhere and I cannot find the JS version!! The PHP one that I listed above is more reliable (as I don't believe there is a "Disable PHP" button on Web Browsers!)

Also just FYI: I did not put in the whole of the SQL Query (or write it properly for that matter) - I was rushing when I wrote it (sorry)
Anyway the SQL Query should look like this:

$sql="INSERT INTO table_name (The SQL IP Address Column) VALUES ($ip)";

[hiteckart]

Why not just use the Cpanel's Weblizer for the ip's and pages in question?

Seems like you are re inventing the wheel.