Store No of Banner clicks for every User
Posted: Tue Mar 11, 2008 10:08 am
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 ?
no idea anyone ? any solution would help data can could be stored in jos tables aswell
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 );
}