<?php 

    function Get_available_knowledges()

    {

    

        // On va chercher les savoirs disponibles.

        // Les savoirs disponibles répondent a toutes les conditions de liaison et de descendance des autres savoirs

        // Il faut d'abord récupérer tous les savoirs détenus par un country

        

        $this->db->where('id_country', $this->session->userdata('current_view_fief'));

        $owned_knowledges = $this->db->get('utg_country_knowledge');

        

        // Nous avons un objet $query qui contient tous les id de knowledges connus.

        

        // On va chercher tous les knowledges qui dépendent des knowledges possédés

        // Pour l'instant, les knowledges ne peuvent être débloqués que par d'autres knowledges et rien d'autre type_parent = 1.

        $count = 0; // On met le compteur a 1 pour préparer le array.

        $available;

        foreach($owned_knowledges->result() as $row)

        { 

            $count ++;

            $this->db->where('id_knowledge_parent', $row->id_knowledge);

            $this->db->where('type_parent', 1);

            $this->db->select('id_knowledge_child');

            $result = $this->db->get('utg_knowledge_links');

            $potential_knowledges[$count] = $result->row();        

            $potential_knowledges[0] = $count;

            

        }

        

        // On a récupéré le tableau $potential_knowledges qui contient des objets id_knowledge_child

        // On va créer un tableau avec tous les knowledges child et le comparer au tableau des knowledges possédés.

        $count = 0; // On réinitialise le compteur

        

        while($count < $potential_knowledges[0])

        {

            $count++;

            $this->db->where('id_knowledge_child', $potential_knowledges[$count]->id_knowledge_child);

            $this->db->where('type_parent', 1);

            $this->db->select('id_knowledge_parent');

            $child_knowledges = $this->db->get('utg_knowledge_links');

            

            

            $available_knowledge[$count] = 0;

            foreach($child_knowledges->result() as $row)

            {

                //$available_knowledge[$count] = 1;

                if(in_array($row->id_knowledge_parent, $owned_knowledges->row_array()) != FALSE && $available_knowledge[$count] < 2 )

                {

                    $available_knowledge[$count] = 1;

                }

                else

                {

                    $available_knowledge[$count] = 2;

                }

            }

            

            $available_knowledge[0] = $count;

            

        }

        

        // On a tous les id de knowledges pouvant être recherchés

        // Il faut a présent les récupérer en détail et classés par famille

        

        $count = 1;

        if(isset($available_knowledge) && $available_knowledge[0] !=0)

        {

            while($count < $available_knowledge[0])

            {

                if($available_knowledge[$count] = 1)

                {

                    $this->db->where('id', $available_knowledge[$count]);

                }

            }            

            $this->db->where('active',1);

            $this->db->order_by('family');

            $final_result = $this->db->get('utg_knowledge');

            return $final_result;

        }

        return FALSE;

        

    } 

<?php 

        $available_knowledges = $this->db->query("

            SELECT     knowledge.id, knowledge.name, knowledge.family, knowledge.description, knowledge.img_url,

                    knowledge.time_to_discover, knowledge.price

            FROM     utg_knowledge knowledge

            WHERE     knowledge.id 

            NOT IN     (

                SELECT     id_knowledge_parent 

                FROM     utg_knowledge_links

                WHERE     utg_knowledge_links.id_knowledge_child 

                NOT IN     (

                    SELECT     id_knowledge

                    FROM     utg_country_knowledge 

                    WHERE     id_country = $fief

                        )

                    )

                AND knowledge.active = 1

            "); 

<?php 

class Knowledges_model extends Model 

{

    function Knowledges_model()

    {

        parent::Model();

    }

    

    function Get_knowledges()

    {

        $fief = $this->session->userdata('current_view_fief');

        $knowledges = $this->db->query(" 

            SELECT     utg_knowledge.id AS id_knowledge, utg_knowledge.name AS name_knowledge, utg_knowledge.description AS description_knowledge,

                    utg_knowledge.price AS price_knowledge

            FROM    utg_knowledge INNER JOIN utg_country_knowledge ON utg_knowledge.id = utg_country_knowledge.id_knowledge    

            WHERE    utg_country_knowledge.id_country = $fief

            AND        utg_country_knowledge.knowledge_status = 2

        

        ");

        return $knowledges;

    

    }

        

    function Get_started_knowledges()

    {

        $fief = $this->session->userdata('current_view_fief');

        

        $started_knowledges = $this->db->query(" 

            SELECT     utg_knowledge.id AS id, utg_knowledge.time_to_discover AS research_time, utg_country_knowledge.knowledge_acquired AS start_date,

                    utg_knowledge.name AS name, utg_knowledge.description AS description, utg_knowledge.family AS family

            FROM    utg_knowledge INNER JOIN utg_country_knowledge ON utg_knowledge.id = utg_country_knowledge.id_knowledge    

            WHERE    utg_country_knowledge.id_country = $fief

            AND        utg_country_knowledge.knowledge_status = 1

            ORDER BY    family ASC

        

        ");

        return $started_knowledges;

    }

    

    function Get_available_knowledges()

    {

    

        // On va chercher les savoirs disponibles.

        // Les savoirs disponibles répondent a toutes les conditions de liaison et de descendance des autres savoirs

        // Il faut d'abord récupérer tous les savoirs détenus par un country

        $fief = $this->session->userdata('current_view_fief');

        

        $available_knowledges = $this->db->query("

            SELECT      knowledge.id, knowledge.name, knowledge.family, knowledge.description, knowledge.img_url,

                        knowledge.time_to_discover, knowledge.price

            FROM         utg_knowledge knowledge

            WHERE         knowledge.active = 1 AND knowledge.id 

            NOT IN     (

                SELECT         utg_knowledge_links.id_knowledge_parent 

                FROM         utg_knowledge_links

                WHERE         utg_knowledge_links.id_knowledge_child 

                NOT IN     (

                    SELECT         utg_country_knowledge.id_knowledge

                    FROM         utg_country_knowledge 

                    WHERE         utg_country_knowledge.id_country = $fief

                        )

                    ) 

            "); 



        return $available_knowledges;

    }

} 

<?php 

    function knowledges()

    {

        $data = $this->Retrieve_informations();    

        $data['to_be_researched_knowledge'] = $this->Get_available_knowledges();

        $data['knowned_knowledge'] = $this->Get_knowledges();    

        $data['started_knowledges'] = $this->Get_started_knowledges();    

        

        foreach($data['started_knowledges']->result() as $row)

        {

            $data['time_left'][$row->id] = $this->TimeToJourJ($row->start_date, $row->research_time);

        }

        $data["main_content"] = "game/knowledges.php";

        

        $this->load->view("game/includes/template", $data);

    }



    function Get_available_knowledges()

    {

        $this->load->model('knowledges_model');

        $available_knowledges = $this->knowledges_model->Get_available_knowledges();

        return $available_knowledges;

    }

    

    function Get_knowledges()

    {

        $this->load->model('knowledges_model');

        $knowledges = $this->knowledges_model->Get_knowledges();

        return $knowledges;

    }

    

    function Get_started_knowledges()

    {

        $this->load->model('knowledges_model');

        $started_knowledges = $this->knowledges_model->Get_started_knowledges();

        return $started_knowledges;

    }