View Single Post
  #5  
Old 24-03-2004, 19:46
StoRm StoRm is offline
Membre
 
Join Date: 06-10-2003
Posts: 61
Re: prob de lien de ref - PHP

<?
if(!isset($ref)){
include("membres/fonctions.php");
$kil=rotateur();
$pg=$PHP_SELF;
$ki=$kil["pseudo"]; sti($kil["id"],$pg);
}
else{
include("membres/fonctions.php");
$kil=rot_perso($ref);
$pg=$PHP_SELF;
$ki=$kil["pseudo"]; sti($kil["id"],$pg);
}
echo $ki;
?>


site.domaine/xxx.php?parin=<? echo $kil['parain']; ?>&ref=<? echo $kil['code']; ?>


rotateur :




<?

function rotateur(){
include("db.php");
$con_rot=mysql_connect($host,$user,$pass);
$sql_der="select dernier from technique where id='1' ";
$res_der=@mysql_db_query($db,$sql_der,$con_rot);
list($dern)=@mysql_fetch_row($res_der);

$sql_rot="select id,parain,pseudo,mail,code from $tbl_membres where id>$dern order by id asc ";
$res_rot=mysql_db_query($db,$sql_rot,$con_rot);
$valides=@mysql_num_rows($res_rot);
if($valides==0){
$sql_rot="select id,parain,pseudo,mail,code from $tbl_membres where id<>'1' order by id asc ";
$res_rot=mysql_db_query($db,$sql_rot,$con_rot);
}
list($rot["id"],$rot["parain"],$rot["pseudo"],$rot["mail"],$rot["code"])=mysql_fetch_row($res_rot);

$sql_par="select code from $tbl_membres where id='".$rot["parain"]."' ";
$res_par=@mysql_db_query($db,$sql_par,$con_rot);
list($rot["parain"])=@mysql_fetch_row($res_par);

return $rot;
@mysql_close($con_rot);
}

function rot_perso($rep) {
include("db.php");
$con_rot=mysql_connect($host,$user,$pass);
$sql_rot="select id,parain,code,pseudo,mail from $tbl_membres where code='$rep' ";
$res_rot=mysql_db_query($db,$sql_rot,$con_rot);
list($rotperso["id"],$rotperso["parain"],$rotperso["code"],$rotperso["pseudo"],$rotperso["mail"])=mysql_fetch_row($res_rot);

$sql_par="select code from $tbl_membres where id='".$rot["parain"]."' ";
$res_par=@mysql_db_query($db,$sql_par,$con_rot);
list($rotperso["paran"])=@mysql_fetch_row($res_par);

$rot["parain"]=$rotperso["paran"];

return $rotperso;
@mysql_close($con_rot);
}

function sti($quel_id,$page){
if(isset($quel_id)){
$date_vue=date("Y-m-j");
$time_vue=date("H:i");
$ip=getenv("REMOTE_ADDR");

@include("db.php");
$con_par=mysql_connect($host,$user,$pass);
$sql_par="insert into $tbl_stats (quel_id,page,date_vue,time_vue,ip)
values ('$quel_id','$page','$date_vue','$time_vue','$ip') ";
$sql_par2="update $tbl_membres set pages_vues=pages_vues+1 where id='$quel_id' ";
$sql_par3=" update technique set dernier='$quel_id' where id='1' ";
mysql_db_query($db,$sql_par,$con_par);
mysql_db_query($db,$sql_par2,$con_par);
mysql_db_query($db,$sql_par3,$con_par);
@mysql_close($con_par);
}
}
?>
Reply With Quote