public static function getCategoryGameItemWithLanguage($categoryCode) { $SQL = "SELECT items.*,lang.language AS langCode,lang.text AS langText FROM game_items AS items,game_item_language AS lang WHERE items.category='" . DBUtils::mysql_escape($categoryCode) . "' AND items.active=1 AND items.itemCode=lang.itemCode"; $query = mysql_query($SQL, DBUtils::getManualConnection()); if (!empty($query)) { $list = array(); $ids = array(); $i = 0; while ($db_field = mysql_fetch_assoc($query)) { $item = GameItems::createFromSQLWithLanguage($db_field); if (!empty($item)) { $itemId = $item->getId(); if (!empty($itemId)) { if (isset($ids[$itemId]) && isset($list[$ids[$itemId]])) { $oldItem = $list[$ids[$itemId]]; $oldItem->languages = array_merge($oldItem->languages, $item->languages); } else { array_push($list, $item); $ids[$itemId] = $i; $i++; } } } } unset($ids); return $list; } return array(); }