Click monitoring script unsure how to make it.

[KainRacure]

I am trying to make a script that will monitor and log into an SQL database when someone clicks a certain area or link or image.

 

I would like it to first off check their IP, check to see if it is in the database, if not it would add it to the database with its own row. if it is there it would wipe out the clicks column (this happens only once when the page loads). Each area/link/image clicked would add to a column with a count for each link clicked.

 

Then when the count hits a certain number it would pop up a box for them to enter a name n stuff in to receive a reward.

 

This is for a game I am making on my website.

 

I can make it check the IP, I can make it pop up the reward box but I am 100% unsure how to go about making it check for a click on each area/link/image.

 

Any help is appreciated.

 

 

[jelly]

<?php

mysql_connect('host','user','pass');
mysql_select_db('database');

// Database: LOGS -> log_id | IP | url | hits

$ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']);
$url = mysql_real_escape_string($_SERVER['PHP_SELF']);

	$sql = "SELECT * FROM `LOGS` WHERE IP = '$ip' AND url = '$url'";
	$sql_query = mysql_query($sql) OR die(mysql_error());
	$count = mysql_num_rows($sql_query);

		if ($count == 0)
		{
			$insert = "INSERT INTO `LOGS` (`IP`, `url`, `hits`) VALUES ('$ip','$url','1')";
			mysql_query($insert) OR die(mysql_error());
		}
		else
		{
			$update = "UPDATE `LOGS` SET (hits = hits + 1) WHERE IP = '$ip' AND url = '$url'";
			mysql_query($update) OR die(mysql_error());
		}
?>

Does that help you?

--

jelly

[xtopolis]

Perhaps he meant retrieving the X/Y coords of the image when clicked:

 

Set the image as part of a form.

 

<form action='' method=post>
  <input type="image" src="image.jpg" name="myImage" />
</form>

 

On submit, your values you look for are:

<?php
  $x = $_POST['myImage_x'];
  $y = $_POST['myImage_y'];
?>

 

With that data, you could check the appropriate mysql column(s).  Hope that helps.

[KainRacure]

I think that xtopolis has exactly what i wanted.

 

and thank you both for your helpful replys