1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97
| $sql = "select a.id_marque,b.marque_long,a.modele,a.profile from logoson_phone a,logoson_phone_marque b,";
$sql.= "logoson_phone_format c,logoson_format d";
$sql.= ($type=="RINGTONE")? ",logoson_phone_format e,logoson_format f":"";
$sql.= " where a.id_marque=b.id_marque and a.id_phone=c.id_phone";
$sql.= " and c.id_format=d.id_format and c.mode='SMS' ";
$sql.= " and d.type='".$type."'";
$sql.= ($type=="RINGTONE")? " and a.id_phone=e.id_phone and e.id_format=f.id_format and e.mode='SMS' and f.type='IMAGE'":"";
$sql.= ($type=="RINGTONE")? " and (d.format='ott' or (d.format='imy' and f.format='EMS'))":"";
$sql.= ($type=="IMAGE")? " and d.format in ('otb','EMS')":"";
$sql.= " group by marque_long,modele,profile order by marque_long, modele,profile";
$res=mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
if (mysql_num_rows($res) == 0)
{
?>
<span id="grosse_surbrillance"><?=L_LS_NO_LOGOSON?></span></p>
<p>
<div id=stats>
$modele = "";
$liste = "";
$fin = FALSE;
?>
<span id="grosse_surbrillance"><?=L_LS_NO_LOGOSON?></span></p></div>
<p>
<?php
}
else
{
?>
<div id=stats>
<?php
$menu_nav="";
$menu_nav=menu_page($sql,$resultat,$_GET['page'],20);
if ($menu_nav!="")
{
?>
<table width='85%' border='0' align="center" cellpadding='0' cellspacing='0'>
<tr><td align="center"><? echo $menu_nav; ?></td></tr>
</table>
</p>
<?php
}
?>
<p>
<table>
<thead>
<tr>
<td><?=L_SRV_LB_MARQ?></td>
<td width="16px"> </td>
<?=($id_profil==PROFIL_ADMIN)? "<td>".L_SRV_LB_MODE."</td>":""?>
<td><?=L_SRV_LB_PRO?></td>
<td width="16"> </td>
<td width="16"> </td>
</tr>
</thead>
<?php
while($data=mysql_fetch_array($resultat))
{
$marque_long=($data['marque_long']==NULL)? 0:$data['marque_long'];
$profile=($data['profile']!=$data['profile'])? TRUE:FALSE;
?>
<tr valign="top">
<td><div id="grosse_surbrillance"><?=strtoupper($data['marque_long'])?></div></td>
<?php
$color="green";
if ($color=="green")
{
$texte_statut=L_LS_TEXT_STATUS_OK;
}
?>
<td><img src="<?=$path_images?>icone_<?=$color?>.png" width="16" height="16" border="0" title="<?=$texte_statut?>" alt="<?=$color?>" ></td>
<?=($id_profil==PROFIL_ADMIN)? "<td>".$data['modele']."</td>":"" ?>
<td><?=$data['profile']?></td>
<td><a href="modification2.php?id_marque=<?=$data['id_marque']?>&marque_long=<?=$data['marque_long']?>&modele=<?=$data['modele']?>" title="<?=sprintf(L_LS_UPDATE_LOGOSON,strtoupper($data['marque_long']))?>"><img src="<?=$path_images?>icone_editer.png" width="16" height="16" border="0" alt="<?=L_UPDATE?>" ></a></td>
<?php
if ($marque_long==0)
{
?>
<td><a class="secure_action" href="compatibilite.php?id_marque=<?=$data['id_marque']?>&marque_long=<?=$data['marque_long']?>&modele=<?=$data['modele']?>&action=supprimer" title="<?=sprintf(L_LS_DELETE_LOGOSON,strtoupper($data['marque_long']))?>"><img src="<?=$path_images?>icone_supprimer.png" width="16" height="16" border="0" alt="<?=L_DELETE?>" ></a></td>
<?php
}
else
{
?>
<td><a class="secure_action" href="compatibilite.php?id_marque=<?=$data['id_marque']?>&marque_long=<?=$data['marque_long']?>&modele=<?=$data['modele']?>&action=archiver" title="<?=sprintf(L_LS_ARCHIVE_LOGOSON,strtoupper($data['marque_long']))?>"><img src="<?=$path_images?>icone_archiver.png" width="16" height="16" border="0" alt="<?=L_ARCHIVE?>" ></a></td>
<?php |
Partager