Par Matthieu, Fondateur.

Cette page est conservé pour historique, la dernière version incluant Prestashop 1.4 & 1.5 est accessible ici.

[php]
$ap=trim(‘\’ ‘);
$MysqlDB=’delgrang202’;
$MysqlQuery = ‘SELECT PS_VERSION, COUNT(ID) AS NB_MOD ‘;
$MysqlQuery .= ‘FROM ‘.$MysqlDB.’.TOOLS_PSMODULES ‘;
$MysqlQuery .= ‘WHERE PUBLISH = \’0\’ ‘;
$MysqlQuery .= ‘GROUP BY PS_VERSION ‘;
$MysqlQuery .= ‘ORDER BY INET_ATON(SUBSTRING_INDEX(CONCAT(PS_VERSION,\’.0.0.0\’),\’.\’,4)) ‘;
$MysqlRes = mysql_query($MysqlQuery);
echo ‘[tr][td][/td]’;
while($row = mysql_fetch_assoc($MysqlRes))
{
$Versions\[\]=$row\[‘PS_VERSION’\];
echo ‘[td align=center][strong]’.$row\[‘PS_VERSION’\].'[/strong] (‘.$row\[‘NB_MOD’\].’)[/td]’;
}
echo ‘[/tr]’;
$MysqlQuery = ‘SELECT DISTINCT PHYSICAL_NAME ‘;
$MysqlQuery .= ‘FROM ‘.$MysqlDB.’.TOOLS_PSMODULES ‘;
$MysqlQuery .= ‘ORDER BY PHYSICAL_NAME ASC ‘;
$MysqlRes = mysql_query($MysqlQuery);
while($row = mysql_fetch_assoc($MysqlRes))
{
echo ‘[tr]’;
echo ‘[td align=left]’.$row\[‘PHYSICAL_NAME’\].'[/td]’;
$PreviousModVersion=$mynul;
foreach($Versions as $V)
{
$MysqlQuery = ‘SELECT VERSION, AUTHOR, COMMENT ‘;
$MysqlQuery .= ‘FROM ‘.$MysqlDB.’.TOOLS_PSMODULES ‘;
$MysqlQuery .= ‘WHERE PS_VERSION=’.$ap.$V.$ap.’ AND ‘;
$MysqlQuery .= ‘PHYSICAL_NAME=’.$ap.$row\[‘PHYSICAL_NAME’\].$ap.’ ‘;
//echo $MysqlQuery;
$MysqlRes2 = mysql_query($MysqlQuery);
$row2 = mysql_fetch_assoc($MysqlRes2);
if( mysql_affected_rows() < 1)
echo ‘[td bgcolor=#CCCCCC][/td]’;
elseif($row2\[‘VERSION’\]==$mynul)
{ echo ‘[td]??[/td]’; }
else
{
echo ‘[td][span title=\ ».$row2\[‘AUTHOR’\].’\’]’;
if($PreviousModVersion == $row2\[‘VERSION’\]) echo ‘[font color=\’#AAAAAA\’]’;
echo $row2\[‘VERSION’\];
if($PreviousModVersion == $row2\[‘VERSION’\]) echo ‘[/font]’;
if($row2\[‘COMMENT’\]!=$mynul) echo ‘ [span title=\ ».$row2\[‘COMMENT’\].’\’][font color=red]*[/font][/span]’;
echo ‘[/span][/td]’;
}

$PreviousModVersion = $row2\[‘VERSION’\];
}
echo ‘[/tr]’;
}
[/php]

Laissez un commentaire