Store No of Banner clicks for every User Topic is solved

[plwst]

hi i would like to store the amount of clicks on banners for every single user.
I wanna store info not in DB on Webserver but on my own PC
that is what i tried:
i tried to change clickbanner() in fronted component com_banner
But it doesnt work any ideas ?

Code: Select all

function clickbanner( $bid ) {
	global $database, $mainframe;

	require_once( $mainframe->getPath( 'class' ) );

	$row = new mosBanner($database);
	$row->load((int)$bid);
	$row->clicks();

	$pat = "http.*://";
	if (!eregi( $pat, $row->clickurl )) {
		$clickurl = "http://$row->clickurl";
	} else {
		$clickurl = $row->clickurl;
	}
echo $my_name = $my->username;

 if ($my->id == 0)
   {
      $my_name = "Besucher";
   } else {
      $my_name = $my->username;
   }

//establish connection to master db server
$link = mysql_connect ('My Server', 'root', 'My PW');
mysql_select_db ('vote');

	  		mysql_query("UPDATE vote SET name = name, nr = nr + 1, banner = banner WHERE name = '$my_name' AND banner = 'top200'", $link);
  			mysql_close($link);


	mosRedirect( $clickurl );
}

no idea anyone ? any solution would help data can could be stored in jos tables aswell