[Sommaire] [Imprimer]

   1  <?php
   2  //

   3  // +----------------------------------------------------------------------+

   4  // |zen-cart Open Source E-commerce                                       |

   5  // +----------------------------------------------------------------------+

   6  // | Copyright (c) 2003 The zen-cart developers                           |

   7  // |                                                                      |

   8  // | http://www.zen-cart.com/index.php                                    |

   9  // |                                                                      |

  10  // | Portions Copyright (c) 2003 osCommerce                               |

  11  // +----------------------------------------------------------------------+

  12  // | This source file is subject to version 2.0 of the GPL license,       |

  13  // | that is bundled with this package in the file LICENSE, and is        |

  14  // | available through the world-wide-web at the following url:           |

  15  // | http://www.zen-cart.com/license/2_0.txt.                             |

  16  // | If you did not receive a copy of the zen-cart license and are unable |

  17  // | to obtain it through the world-wide-web, please send a note to       |

  18  // | license@zen-cart.com so we can mail you a copy immediately.          |

  19  // +----------------------------------------------------------------------+

  20  //  $Id: product_music_functions.php 1105 2005-04-04 22:05:35Z birdbrain $

  21  //

  22   
  23  ////

  24  // Return the artists URL in the needed language

  25    function zen_get_artists_url($artists_id, $language_id) {
  26      global $db;
  27      $artist = $db->Execute("select artists_url
  28                                    from " . TABLE_RECORD_ARTISTS_INFO . "
  29                                    where artists_id = '" . (int)$artists_id . "'
  30                                    and languages_id = '" . (int)$language_id . "'");
  31  
  32      return $artist->fields['artists_url'];
  33    }
  34  ////

  35  // Return the Record Company URL in the needed language

  36    function zen_get_record_company_url($record_company_id, $language_id) {
  37      global $db;
  38      $record_company = $db->Execute("select record_company_url
  39                                    from " . TABLE_RECORD_COMPANY_INFO . "
  40                                    where record_company_id = '" . (int)$record_company_id . "'
  41                                    and languages_id = '" . (int)$language_id . "'");
  42  
  43      return $record_company->fields['record_company_url'];
  44    }
  45  
  46  ////

  47  // Return the Music Genre URL in the needed language

  48    function zen_get_music_genre_url($music_genre_id, $language_id) {
  49      global $db;
  50      $music_genre = $db->Execute("select music_genre_url
  51                                    from " . TABLE_RECORD_COMPANY_INFO . "
  52                                    where music_genre_id = '" . (int)$music_genre_id . "'
  53                                    and languages_id = '" . (int)$language_id . "'");
  54  
  55      return $music_genre->fields['music_genre_url'];
  56    }
  57  ?>