public static function getGameCategoryItemWithLanguage()
{
$SQL = "SELECT categories.*,lang.language AS langCode,lang.text AS langText FROM " . TBL_GAME_ITEM_CATEGORY . " AS categories," . TBL_GAME_ITEM_CATEGORY_LANGUAGE . " AS lang WHERE categories.active=1 AND categories.categoryCode=lang.categoryCode ORDER BY id ASC";
$query = mysql_query($SQL, DBUtils::getManualConnection());
if (!empty($query)) {
$list = array();
$ids = array();
$i = 0;
while ($db_field = mysql_fetch_assoc($query)) {
$cat = GameItemCategory::createFromSQLWithLanguage($db_field);
if (!empty($cat)) {
$catId = $cat->getId();
if (!empty($catId)) {
if (isset($ids[$catId]) && isset($list[$ids[$catId]])) {
$oldItem = $list[$ids[$catId]];
$oldItem->languages = array_merge($oldItem->languages, $cat->languages);
} else {
array_push($list, $cat);
$ids[$catId] = $i;
$i++;
}
}
}
}
unset($ids);
return $list;
}
return array();
}
