PHP GameItems::createFromSQLWithLanguage示例

 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();
 }