1: <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
 2: class Model_link extends CI_Model{
 3:     function article_links($id){
 4:         $links = $this->db->select('link_status,xenon_data_links.status,xenon_link.link_id,xenon_data.data_title')->from('xenon_link')->join('xenon_data_links','xenon_link.link_id = xenon_data_links.link_id')->join('xenon_data','xenon_data.data_id = xenon_link.data_id')->where('xenon_data_links.data_id',$id)->where('xenon_link.link_type','a')->get();
 5:         if($links->num_rows() > 0){
 6:             return $links->result();
 7:         }else{
 8:             return false;
 9:         }
10:     }
11:     
12:     function article_references($id){
13:         $references = $this->db->select('link_status,xenon_data_links.status,xenon_link.link_id,xenon_reference.refe_title')->from('xenon_link')->join('xenon_data_links','xenon_link.link_id = xenon_data_links.link_id')->join('xenon_reference','xenon_reference.refe_id = xenon_link.data_id')->where('xenon_data_links.data_id',$id)->where('xenon_link.link_type','r')->get();
14:         if($references->num_rows() > 0){
15:             return $references->result();
16:         }else{
17:             return false;
18:         }
19:     }
20:     
21:     function disable_data_link($data,$link){
22:         if($this->input->get('confirm') != 'true'){
23:             $dataz['status'] = 'n';
24:             $this->db->where('link_id',base64_decode(urldecode($link)))->where('data_id',base64_decode(urldecode($data)));
25:             $this->db->update('xenon_data_links',$dataz);
26:         }else{
27:             $this->db->delete('xenon_data_links',array('link_id'=>base64_decode(urldecode($link)),'data_id'=>base64_decode(urldecode($data))));     
28:         }
29:     }
30:     
31:     function enable_data_link($data,$link){
32:         $dataz['status'] = 'y';
33:         $this->db->where('link_id',base64_decode(urldecode($link)))->where('data_id',base64_decode(urldecode($data)));
34:         $this->db->update('xenon_data_links',$dataz);
35:     }
36: 
37: }
38: ?>