Problems with an Visitor Exchange Script
Posted: Thu Sep 26, 2002 9:18 am
I own a Visitor Exchange Script, but it always shows only the same page.
Code: Select all
function viewpage()
{
global $userid, $showup_frequency, $points_hit, $points_view, $showup_time, $url_default, $points_referer_view, $points_referer_jackpot_views, $points_referer_jackpot_points;
if($userid)
{
$query="SELECT recently, refererid, views FROM accounts WHERE id='$userid';";
$result=mysql_query($query);
if($result)
{
$result = @mysql_fetch_array($result);
$recently=split(' ', $resultїrecently]);
$refererid=$resultїrefererid];
$views=$resultїviews];
if($points_referer_jackpot_views && $points_referer_jackpot_points && $views+1==$points_referer_jackpot_views){
$query="UPDATE accounts SET points=points+$points_referer_jackpot_points WHERE id='$refererid';";
mysql_query($query);
}
}
}
$query = "SELECT id, url FROM accounts WHERE showup='1' AND id!='$userid' AND points>=$points_hit AND savepoints='0'";
for($i=0; $i<count($recently) && $i<$showup_frequency; $i++)
{
$query .= " AND id!='$recentlyї$i]'";
$recentliesї]=$recentlyї$i];
}
$query .= ' ORDER BY points DESC';
$result=mysql_query($query);
$result=@mysql_fetch_array($result);
if($resultїid] && $resultїurl])
{
$query="UPDATE accounts SET hits=hits+1, points=points-$points_hit WHERE id='".$resultїid]."';";
mysql_query($query);
$recently=implode(" ", $recentlies);
$recently=$resultїid]." ".$recently;
$query="UPDATE accounts SET views=views+1, points=points+$points_view, recently='$recently', lastview='".time()."' WHERE id='$userid' AND lastview<='".time().-$showup_time."';";
mysql_query($query);
if($refererid)
{
$query="UPDATE accounts SET points=points+".$points_view*$points_referer_view." WHERE id='$refererid';";
mysql_query($query);
}
}else{
$resultїurl]=$url_default;
$query="UPDATE accounts SET views=views+1, points=points+1, lastview='".time()."' WHERE id='$userid' AND lastview<='".time().-$showup_time."';";
mysql_query($query);
if($refererid)
{
$query="UPDATE accounts SET points=points+".(1)*$points_referer_view." WHERE id='$refererid';";
mysql_query($query);
}
}
return array(
url=>$resultїurl],
id=>$resultїid]
);
}