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