click.php

来自「晕了」· PHP 代码 · 共 39 行

<?
//
require("functions.php");
if((!isset($from))||(!isset($to))){
        header("Location:".$GLOBALS["LINKS_URL"]);
        exit;
}

$conn=DBConnect();

$sql="delete from links_hits where TO_DAYS(NOW())-TO_DAYS(time)>=".$LINKS_HITS_HOLDAYS;
mysql_query($sql,$conn);

$sql="insert into links_hits(ip,fromid,toid,time) values('";
$sql=$sql.$REMOTE_ADDR;
$sql=$sql."',";
$sql=$sql.$from;
$sql=$sql.",";
$sql=$sql.$to;
$sql=$sql.",'";
$sql=$sql.date("Y-m-d H:i:s");
$sql=$sql."')";
mysql_query($sql,$conn);

$sql="select siteurl from links_users where id=$to";
$result=mysql_query($sql,$conn);
$toinfo=mysql_fetch_object($result);

$sql="update links_users set account=account+1,account_out=account_out+1 where id=".$from;
mysql_query($sql,$conn);

$sql="update links_users set account=account-1,account_in=account_in+1 where id=".$to;
mysql_query($sql,$conn);

DBClose($conn);

$url=$toinfo->siteurl;
header("Location:".$url);
?>