Besoin d'aide php

ok merci g regardé je trouve pas je met le code
si kelk1 pe maider merci d'avance

class Bannieres {

var $ban_id;
var $ban_id;
var $ban_source;
var $ban_url;
var $ban_weight;
var $ban_height;
var $ban_nb_vu;
var $ban_nb_click;
var $id_lien;
var $page_defaut;
var $BanMax;

function Bannieres($ban_value=array()) {
if(count($ban_value) > 0) {
if (array_key_exists('ban_id', $ban_value)) {
$this->ban_id = $ban_value['ban_id'];
}
if (array_key_exists('cam_id', $ban_value)) {
$this->cam_id = $ban_value['cam_id'];
}
if (array_key_exists('ban_source', $ban_value)) {
$this->ban_source = $ban_value['ban_source'];
}
if (array_key_exists('ban_url', $ban_value)) {
$this->ban_url = $ban_value['ban_url'];
}
if (array_key_exists('ban_weight', $ban_value)) {
$this->ban_weight = $ban_value['ban_weight'];
}
if (array_key_exists('ban_height', $ban_value)) {
$this->ban_height = $ban_value['ban_height'];
}
if (array_key_exists('ban_nb_vu', $ban_value)) {
$this->ban_nb_vu = $ban_value['ban_nb_vu'];
}
if (array_key_exists('ban_nb_click', $ban_value)) {
$this->ban_nb_click = $ban_value['ban_nb_click'];
}
}
else {
$this->ban_id = '';
$this->cam_id = '';
$this->ban_source = '';
$this->ban_url = '';
$this->ban_weight = '';
$this->ban_height = '';
$this->ban_nb_vu = '';
$this->ban_nb_click = '';
$this->page_defaut = './includes/index.html';
}
$this->BanMax = 5;
}

function GetBanInfo($ban_id) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$req = "SELECT * FROM bannieres WHERE ban_id='" . intval($ban_id) . "'";
$result = mysql_query($req);
if($donnees = mysql_fetch_array($result)) {
$tb[] = $donnees;
}
else {
$tb = array();
}
return $tb;
}

function GetBanId() {
return $this->ban_id;
}

function GetBanSource($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_source'];
}

function GetBanUrl($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_url'];
}

function GetBanWeight($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_weight'];
}

function GetBanHeight($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_height'];
}

function GetBanNbVu($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_nb_vu'];
}

function GetBanNbClick($ban_id) {
$tb = $this->GetBanInfo($ban_id);
return $tb[0]['ban_nb_click'];
}

function GetBanActive() {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$req = "SELECT *, cam_debut, cam_fin, cam_vu, cam_click FROM bannieres LEFT JOIN campagnes
ON campagnes.cam_id = bannieres.cam_id
WHERE (campagnes.cam_debut <= '" . date("Y-m-d H:i:s") . "' || campagnes.cam_debut = '0000-00-00 00:00:00')
AND (campagnes.cam_fin > '" . date("Y-m-d H:i:s") . "' || campagnes.cam_fin = '0000-00-00 00:00:00')
AND (campagnes.cam_vu >= bannieres.ban_nb_vu || campagnes.cam_vu = 0)
AND (campagnes.cam_click >= bannieres.ban_nb_click || campagnes.cam_click = 0)";
if($result = mysql_query($req)) {
$nb = mysql_num_rows($result);
$tb['nb'] = $nb;
if($nb > 0) {
while($donnees = mysql_fetch_array($result)) {
$tb['content'][] = array('ban_id'=>$donnees['ban_id'],
'cam_id'=>$donnees['cam_id'],
'ban_source'=>$donnees['ban_source'],
'ban_url'=>$donnees['ban_url'],
'ban_weight'=>$donnees['ban_weight'],
'ban_height'=>$donnees['ban_height'],
'ban_nb_vu'=>$donnees['ban_nb_vu'],
'ban_nb_click'=>$donnees['ban_nb_click']);
}
}
else {
$tb['nb'] = $nb;
}
}
else {
$tb = array();
}
return $tb;
}

function ProcessBanVu($id_ban) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$req = "UPDATE bannieres set ban_nb_vu = ban_nb_vu+1 WHERE ban_id=" . intval($id_ban);
if($result = mysql_query($req)) {
return TRUE;
}
else {
return FALSE;
}
}

function ProcessBanClick($id_ban) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$req = "UPDATE bannieres set ban_nb_click = ban_nb_click+1 WHERE ban_id=" . intval($id_ban);
$result = mysql_query($req);
$url = $this->GetBanUrl(intval($id_ban));
echo $url;
header("Location: " . $url);
if(!$result) {
echo 'Erreur';
exit;
}
}

function GetBanList($order, $sort, $index, $limit) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$req = "SELECT * FROM bannieres ORDER BY " . $order . " " . $sort . " LIMIT " . $index . ", " . $limit;
if($result = mysql_query($req)) {
$nb = mysql_num_rows($result);
if($nb > 0) {
while($donnees = mysql_fetch_array($result)) {
$bannieres['nb'] = $nb;
$bannieres['content'][] = array('ban_id'=>$donnees['ban_id'],
'cam_id'=>$donnees['cam_id'],
'ban_source'=>$donnees['ban_source'],
'ban_url'=>$donnees['ban_url'],
'ban_weight'=>$donnees['ban_weight'],
'ban_height'=>$donnees['ban_height'],
'nb_vu'=>$donnees['ban_nb_vu'],
'nb_click'=>$donnees['ban_nb_click']);
}
}
else {
$bannieres['nb'] = $nb;
}
}
else {
$bannieres = array();
}
return $bannieres;
}

function DisplayBan($page=NULL, $id_ban=NULL) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$txt = '';
if($id_ban === NULL) {
$tb = $this->GetBanActive();

if($tb['nb'] > 0) {
if($tb['nb'] < $this->BanMax) $this->BanMax = $tb['nb'];
$random = array_rand($tb['content'], $this->BanMax);
if(count($random) > 0) {
for($j=0;$j<count($random);$j++) {
$random_key = $random[$j];
$ban_img = '<img src="' . $tb['content'][$random_key]['ban_source'] . '"';
if(count($tb['content'][$random_key]['ban_weight']) > 0) {
$ban_img .= ' weight="' . $tb['content'][$random_key]['ban_weight'] . '"';
}
if(count($tb['content'][$random_key]['ban_height']) > 0) {
$ban_img .= ' height="' . $tb['content'][$random_key]['ban_height'] . '"';
}
$ban_img .= ' border="0">';
$tag = '<bann_' . ($j+1) . '>';
$ban_url = '<a href="' . $_SERVER['PHP_SELF'] . '?ban=' . $tb['content'][$random_key]['ban_id'] . '" target="blank">';
$random_tb[] = array(
'tag'=>$tag,
'ban'=>$ban_url . $ban_img . '</a>');
}
}
}
}
else {
$ban_id = intval($id_ban);
$ban_img = '<img src="' . $this->GetBanSource($ban_id) . '"';
if($this->GetBanWeight($ban_id) > 0) {
$ban_img .= ' weight="' . $this->GetBanWeight($ban_id) . '"';
}
if($this->GetBanHeight($ban_id) > 0) {
$ban_img .= ' height="' . $this->GetBanHeight($ban_id) . '"';
}
$ban_img .= ' border="0"></a>';
$tag = '<bann_' . $ban_id . '>';
$ban_url = '<a href="' . $_SERVER['PHP_SELF'] . '?ban=' . $ban_id . '" target="blank">';
$random_tb[] = array(
'tag'=>$tag,
'ban'=>$ban_url . $ban_img . '</a>');
}
if($page === NULL) {
$f = $this->page_defaut;
}
else {
$f = trim($page);
}
if (!file_exists($f)) {
$f2 = $f;
$f = $this->page_defaut;
echo "Maquette <b>$f2</b> inexistante<br>";
}
if (phpversion() < "4.3.0") $page_html = join("",file($f));
else $page_html = file_get_contents($f);
for($i=0;$i<count($random_tb);$i++) {
$page_html = str_replace($random_tb[$i]['tag'], $random_tb[$i]['ban'], $page_html);
}
return $page_html;
}

function AddBan($campagne, $source, $url, $weight, $height, $nb_vu=0, $nb_click=0) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$campagne = intval($campagne);
$source = trim($source);
$url = trim($url);
$weight= intval($weight);
$height = intval($height);
$nb_vu = intval($nb_vu);
$nb_click = intval($nb_click);
$req = "INSERT INTO bannieres (ban_id, cam_id, ban_source, ban_url, ban_weight,
ban_height, ban_nb_vu, ban_nb_click) VALUES ('','" . $campagne . "','" . $source . "','" . $url . "',
'" . $weight . "','" . $height . "','" . $nb_vu . "','" . $nb_click . "')";
if(mysql_query($req)) {
$id = mysql_insert_id();
}
else {
die("Impossible d&quote;ins&ecute;rer une nouvelle banni&ecute;re");
}
return $id;
}

function UpdateBan($ban_id, $campagne, $source, $url, $weight, $height) {
global $id_lien;
if(!isset($id_lien)) $id_lien = db_connect();
$id_ban = intval($ban_id);
$campagne = intval($campagne);
$source = trim($source);
$url = trim($url);
$weight = intval($weight);
$height = intval($height);
$req = "UPDATE bannieres SET cam_id='" . $campagne . "', ban_source='" . $source . "', ban_url='" . $url . "', ban_weight='" . $weight . "', ban_height='" . $height . "' WHERE ban_id='" . $id_ban . "'";
if(mysql_query($req)) {
return TRUE;
}
else {
return FALSE;
}
}

}
/* Fin de classe */
?>