PHP File Manager

Editing File: Leagues.php

<?php

class Leagues extends CI_Model
{

function get($league_id = null)
    {
        $sql = "SELECT le.* "
                . "FROM league AS le "
                . "WHERE le.deleted IS NULL ";
        if ($league_id)
        {
            $sql .= sprintf('AND league_id = %d ', $this->db->escape($league_id));
        }
        $query  = $this->db->query($sql);
        $result = $query->result();
        if ($league_id && $result)
        {
            return reset($result);
        }
        return $result;
    }

function save($data)
    {
        foreach ($data['loc'] as $league_id => $league)
        {
            $save_data = array(
                'name'    => $league['name'],
                'deleted' => (isset($league['deleted']) && $league['deleted'] ? date('Y-m-d H:i:s') : null),
            );
            $this->db->query($this->db->update_string('league', $save_data, "league_id = {$this->db->escape($league_id)}"));
        }
        if ($new_name = trim($data['new']['name']))
        {
            $save_data = array('name' => $new_name);
            $this->db->query($this->db->insert_string('league', $save_data));
        }
    }

function getDropdownData(array $leagues)
    {
        $ret = array();
        foreach ($leagues as $league)
        {
            $ret[$league->league_id] = $league->name;
        }
        return $ret;
    }

}

Cancel