| 1 | <?php
|
|---|
| 2 | /* -----------------------------------------------------------------------------------------
|
|---|
| 3 | $Id: xtc_get_vpe_name.inc.php
|
|---|
| 4 |
|
|---|
| 5 | XT-Commerce - community made shopping
|
|---|
| 6 | http://www.xt-commerce.com
|
|---|
| 7 |
|
|---|
| 8 | Copyright (c) 2003 XT-Commerce
|
|---|
| 9 | Released under the GNU General Public License
|
|---|
| 10 | ---------------------------------------------------------------------------------------*/
|
|---|
| 11 |
|
|---|
| 12 |
|
|---|
| 13 | function xtc_get_vpe_name($products_vpe_id, $languages_id = '') {
|
|---|
| 14 | static $vpe_name_array;
|
|---|
| 15 |
|
|---|
| 16 | if (!is_array($vpe_name_array)) {
|
|---|
| 17 | $vpe_name_array = array();
|
|---|
| 18 | }
|
|---|
| 19 |
|
|---|
| 20 | if ($languages_id == '') {
|
|---|
| 21 | $languages_id = (int)$_SESSION['languages_id'];
|
|---|
| 22 | }
|
|---|
| 23 |
|
|---|
| 24 | if (!isset($vpe_name_array[$languages_id][$products_vpe_id])) {
|
|---|
| 25 | $vpe_name_array[$languages_id][$products_vpe_id] = '';
|
|---|
| 26 |
|
|---|
| 27 | $vpe_name_query = xtDBquery("SELECT products_vpe_name
|
|---|
| 28 | FROM " . TABLE_PRODUCTS_VPE . "
|
|---|
| 29 | WHERE language_id = '".(int)$languages_id."'
|
|---|
| 30 | AND products_vpe_id = '".(int)$products_vpe_id."'");
|
|---|
| 31 | if (xtc_db_num_rows($vpe_name_query, true)) {
|
|---|
| 32 | $vpe_name = xtc_db_fetch_array($vpe_name_query, true);
|
|---|
| 33 | $vpe_name_array[$languages_id][$products_vpe_id] = $vpe_name['products_vpe_name'];
|
|---|
| 34 | }
|
|---|
| 35 | }
|
|---|
| 36 |
|
|---|
| 37 | return $vpe_name_array[$languages_id][$products_vpe_id];
|
|---|
| 38 | }
|
|---|
