public static function getClanportals(Dolumar_Players_Clan $clan) { $db = Neuron_DB_Database::getInstance(); $villages = array(); foreach ($clan->getMembers() as $player) { foreach ($player->getVillages() as $v) { $villages[] = $v->getId(); } } $list = "(" . implode($villages, ",") . ")"; $data = $db->query("\n\t\t\tSELECT\n\t\t\t\t*\n\t\t\tFROM\n\t\t\t\tmap_portals\n\t\t\tWHERE\n\t\t\t\tp_caster_v_id IN {$list} OR\n\t\t\t\tp_target_b_id IN {$list}\n\t\t"); $out = array(); foreach ($chk as $v) { $in = new self($v['p_id']); $in->setData($v[0]); $out[] = $in; } return $out; }