besoin d'un pro, car je crois avoir une ligne de code pas évidente à coder !!!
voici mon problème :
1) Si vous vous rendez sur cette page de mon site http://www.ln-c.com/player_list2.php, mettez les équipes en odre alphabétique et vous trouverez en première position un joueur avec l'inscription *** RFA ***, les 2 autres avec l'inscription *** UFA *** et pour les 107 autres il y a un nom d'équipe exemple Admirals, dans ma base de donnée les équipe son numéroté de 1 à 30
3) le texte *** RFA *** apparaît dans la colonne Équipe, quand le joueur appartient à une équipe, mais n'a pas de contrat.
4) dans la colonne Offre si le texte de la colonne Équipe est *** RFA *** le lien du texte "faire une offre" doit être ceci restricted_offer_sheet.php?player=<?php echo $row_GetSkaters['Number']; ?>&type=Player" fonctionne bien ! vous ne pouvez pas le voir car vous devez être membre
5) le texte *** UFA *** apparaît dans la colonne Équipe, quand le joueur n'appartient à personne et n'a pas de contrat. fonctionne bien aussi !
Besoin de code pour ce paramètre
6) dans la colonne Offre si le texte de la colonne Équipe est *** UFA *** le lien du texte "faire une offre" doit être ceci offer_sheet.php?player=<?php echo $row_GetSkaters['Number']; ?>&type=Player"
Besoin de code pour ce paramètre
7) et pour terminé j'aimerais que la case de la colonne "Offre" soit vide si il y a un nom d'équipe dans la colonne Équipe.
j'espère trouver réponse à mon problème !!!
merci de votre aide
8) voici le code de la page http://www.ln-c.com/player_list2.php j'ai mis en rouge l'endroit a coder (enfin je crois)
<?php include('Connections/settings.php'); ?>
<?php include("includes/sessionInfo.php") ?>
<?php include("includes/functions.php") ?>
<?php include("includes/langfile.php") ?>
<?php include("includes/langs.php") ?>
<?php
switch ($lang){
case 'en':
$l_DraftYear = "Draft Year";
$l_Rating = "Rating";
$l_Total = "Total";
$l_All = "All";
$l_C = "C";
$l_LW = "LW";
$l_RW = "RW";
$l_D = "D";
$l_G = "G";
break;
case 'fr':
$l_Send = "Faire une Offre";
$l_C = "C";
$l_LW = "AG";
$l_RW = "AD";
$l_D = "D";
$l_G = "G";
$l_DraftYear = "Année Repecher";
$l_Rating = "Cote";
$l_Total = "Total de";
$l_All = "Tous";
break;
}
$GET_GetLetter = "A";
if (isset($_GET['letter'])) {
$GET_GetLetter = (get_magic_quotes_gpc()) ? $_GET['letter'] : addslashes($_GET['letter']);
}
if ($GET_GetLetter == "All"){
$GET_GetLetter="";
}
$query_GetSalarys = "SELECT Number, Name, Overall, Team, Status0, AgeDate,Age, PosRW, PosLW, PosC, PosD, Country,Injury, Salary1, Contract FROM players WHERE Retired = 0 AND Name LIKE '".$GET_GetLetter."%' ORDER BY Name asc";
$GetSalarys = mysql_query($query_GetSalarys, $connection) or die(mysql_error());
$row_GetSalarys = mysql_fetch_assoc($GetSalarys);
$totalRows_GetSalarys = mysql_num_rows($GetSalarys);
$query_GetPlayerTotal = "SELECT COUNT(ID) as TotalRows FROM players WHERE Retired = 0";
$GetPlayerTotal = mysql_query($query_GetPlayerTotal, $connection) or die(mysql_error());
$row_GetPlayerTotal = mysql_fetch_assoc($GetPlayerTotal);
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title><?php echo $l_nav_player_lists;?> - <?php echo $_SESSION['SiteName'] ; ?></title>
<link rel="shortcut icon" type="image/png" href="<?php echo $_SESSION['DomainName']; ?>/image/<?php echo $_SESSION['FavIcon'];?>" />
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/reset.css">
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/html5.css">
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/menu.css">
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/jquery.accessible-news-slider.css" />
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/jquery-ui-1.8.custom.css" />
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/header.css" />
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/tipsy.css">
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/ui.tabs.css">
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery-1.5.1.min.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/formly.min.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery.accessible-news-slider.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery.pop.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery.tipsy.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery.tablesorter.min.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/ui.core.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/reflection.js"></script>
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/jquery-ui-1.8.custom.min.js"></script>
<?php if(isset($_SESSION['username'])){ ?>
<link rel="stylesheet" type="text/css" href="<?php echo $_SESSION['DomainName']; ?>/css/chat.css" />
<script type="text/javascript" src="<?php echo $_SESSION['DomainName']; ?>/js/chat.js"></script>
<?php } ?>
<!--[if lte IE 9]>
<script src="<?php echo $_SESSION['DomainName']; ?>/js/html5.js" type="text/javascript"></script>
<![endif]-->
<script type="text/javascript">
$(function(){
$("table").tablesorter();
$('#cssdropdown li.headlink').hover(
function() { $('ul', this).css('display', 'block'); },
function() { $('ul', this).css('display', 'none'); });
});;
</script>
<style media="all" type="text/css">
#container {background-image:url(<?php echo $_SESSION['DomainName']; ?>/image/headers/<?php echo $_SESSION['current_HeaderImage']; ?>); background-color:#<?php echo $_SESSION['current_PrimaryColor'];?>;}
a {color:#<?php echo $_SESSION['current_PrimaryColor']; ?>;}
table.tablesorter thead tr th { background-color: #<?php echo $_SESSION['current_SecondaryColor']; ?>; color:#<?php echo $_SESSION['current_TextColor']; ?>;}
table.tablesorterRates thead tr th { background-color: #<?php echo $_SESSION['current_SecondaryColor']; ?>; color:#<?php echo $_SESSION['current_TextColor']; ?>;}
table.tablesorter thead tr th a{ color:#<?php echo $_SESSION['current_TextColor']; ?>;}
table.tablesorterRates thead tr th a{ color:#<?php echo $_SESSION['current_TextColor']; ?>;}
footer { background-color:#<?php echo $_SESSION['current_PrimaryColor']; ?>;}
#FatFooter { background-color:#<?php echo $_SESSION['current_SecondaryColor']; ?>; color:#<?php echo $_SESSION['current_TextColor']; ?>;}
<?php if ($_SESSION['current_SecondaryColor'] == $_SESSION['current_PrimaryColor']){ echo "#FatFooter a { color:#".$_SESSION['current_TextColor']."; } "; } ?>
h3 {color:#<?php echo $_SESSION['current_PrimaryColor']; ?>;}
#cssdropdown, #cssdropdown ul {background-color:#<?php echo $_SESSION['current_PrimaryColor']; ?>;}
nav {background-color:#<?php echo $_SESSION['current_PrimaryColor']; ?>;}
</style>
</head>
<body>
<div align="center">
<div id="wrapper">
<?php include("includes/header.php"); ?>
<?php include("includes/nav.php"); ?>
<article>
<!-- RIGHT HAND SIDE BAR GOES HERE -->
<!--<aside></aside>-->
<!-- MAIN PAGE CONTENT GOES HERE -->
<section>
<h1><?php echo $l_nav_player_lists;?></h1>
<br />
<br />
<table cellpadding="3" cellspacing="0" border="0" width="100%">
<tr>
<td>
<a href="player_list.php?letter=All"><?php echo $l_All;?></a>
<a href="player_list.php?letter=A">A</a>
<a href="player_list.php?letter=B">B</a>
<a href="player_list.php?letter=C">C</a>
<a href="player_list.php?letter=D">D</a>
<a href="player_list.php?letter=E">E</a>
<a href="player_list.php?letter=F">F</a>
<a href="player_list.php?letter=G">G</a>
<a href="player_list.php?letter=H">H</a>
<a href="player_list.php?letter=I">I</a>
<a href="player_list.php?letter=J">J</a>
<a href="player_list.php?letter=K">K</a>
<a href="player_list.php?letter=L">L</a>
<a href="player_list.php?letter=M">M</a>
<a href="player_list.php?letter=N">N</a>
<a href="player_list.php?letter=O">O</a>
<a href="player_list.php?letter=P">P</a>
<a href="player_list.php?letter=Q">Q</a>
<a href="player_list.php?letter=R">R</a>
<a href="player_list.php?letter=S">S</a>
<a href="player_list.php?letter=T">T</a>
<a href="player_list.php?letter=U">U</a>
<a href="player_list.php?letter=V">V</a>
<a href="player_list.php?letter=W">W</a>
<a href="player_list.php?letter=X">X</a>
<a href="player_list.php?letter=Y">Y</a>
<a href="player_list.php?letter=Z">Z</a>
</td>
</tr>
</table>
<table cellspacing="0" border="0" width="100%" class="tablesorter" >
<thead>
<tr>
<th width="20"><?php echo No;?></th>
<th width="160"><?php echo $l_Name;?></th>
<th width="80"><?php echo $l_Position;?></th>
<th><?php echo Overall;?></th>
<th><?php echo $l_Country;?></th>
<th><?php echo $l_Age;?></th>
<th><?php echo $l_Salary;?></th>
<th><?php echo $l_Contract;?></th>
<th><?php echo $l_nav_team;?></th>
<th>Offre</th>
</tr>
</thead>
<tbody>
<?php $i=0; do { $i=$i+1;
if ($row_GetSalarys['PosG'] == "True" || $row_GetSalarys['PosG'] == "Vrai"){
$tmpTarget="goalie.php";
} else {
$tmpTarget="player.php";
}
?>
<tr>
<td align="center"><?php echo $i;?></td>
<td><a href="<?php echo $tmpTarget; ?>?player=<?php echo $row_GetSalarys['Number']; ?>"target="_blank"><?php echo $row_GetSalarys['Name']; ?></a></td>
<td align="center"><?php
echo '<div style="display:block; float:left; width:20px; text-align:center; vertical-align:middle">';
if ($row_GetSalarys['PosC'] == "True" || $row_GetSalarys['PosC'] == "Vrai"){
echo $l_C;
} else { echo " "; }
echo '</div>';
echo '<div style="display:block; float:left; width:20px; text-align:center; vertical-align:middle">';
if ($row_GetSalarys['PosLW'] == "True" || $row_GetSalarys['PosLW'] == "Vrai"){
echo $l_LW;
} else { echo " "; }
echo '</div>';
echo '<div style="display:block; float:left; width:20px; text-align:center; vertical-align:middle">';
if ($row_GetSalarys['PosRW'] == "True" || $row_GetSalarys['PosRW'] == "Vrai"){
echo $l_RW;
} else { echo " "; }
echo '</div>';
echo '<div style="display:block; float:left; width:20px; text-align:center; vertical-align:middle">';
if ($row_GetSalarys['PosD'] == "True" || $row_GetSalarys['PosD'] == "Vrai"){
echo $l_D;
} else { echo " "; }
echo '</div>';
?>
</td>
<td align="center"><?php echo $row_GetSalarys['Overall']; ?></td>
<td align="center"><?php echo $row_GetSalarys['Country']; ?> <img height="12" width="22" src="<?php echo $_SESSION['DomainName']; ?>/image/flags/<?php echo $row_GetSalarys['Country']; ?>.png" border="0"/></td>
<td align="center"><?php echo getAge($row_GetSalarys['AgeDate']); ?></td>
<td align="center"> $<?php echo number_format($row_GetSalarys['Salary1'],0); ?></td>
<td align="center"><?php echo $row_GetSalarys['Contract']; ?></td>
<td align="center"><?php
if ($row_GetSalarys['Contract'] > 0 ){
if ($row_GetSalarys['Status0'] <= 1){
$query_GetTeam = sprintf("SELECT Number, Name FROM farmteam WHERE Number=%s",$row_GetSalarys['Team']);
$GetTeam = mysql_query($query_GetTeam, $connection) or die(mysql_error());
$row_GetTeam = mysql_fetch_assoc($GetTeam);
echo "<a href='farm_roster.php?team=".$row_GetSalarys['Team']."'>".$row_GetTeam['City']." ".$row_GetTeam['Name']."</a>";
} else {
$query_GetTeam = sprintf("SELECT City, Number, Name FROM proteam WHERE Number=%s",$row_GetSalarys['Team']);
$GetTeam = mysql_query($query_GetTeam, $connection) or die(mysql_error());
$row_GetTeam = mysql_fetch_assoc($GetTeam);
echo "<a href='pro_roster.php?team=".$row_GetSalarys['Team']."'>".$row_GetTeam['City']." ".$row_GetTeam['Name']."</a>";
}
} else if ($row_GetSalarys['Team'] == 0 ) {
echo "*** UFA ***";
} else { echo "*** RFA ***"; }
?></td>
<td align="center" nowrap="nowrap">
<?php
if ($_SESSION['U_ID'] <> ""){
if ($row_GetSalarys['Team'] > 0 )?>
<a href="restricted_offer_sheet.php?player=<?php echo $row_GetSalarys['Number']; ?>&type=Player"><?php echo $l_Send;?></a>
<?php } ?>
</td>
</tr>
<?php } while ($row_GetSalarys = mysql_fetch_assoc($GetSalarys)); ?>
</tbody>
</table>
<br />
<div align="center"><?php echo $l_Total." ".$row_GetPlayerTotal['TotalRows']; ?></div>
<br /><br />
</section>
</article>
<?php include("includes/footer.php"); ?>
<?php include("includes/statusBar.php"); ?>
</div>
</div>
</body>
</html>
