File: //home/awaldron/public_html/archive/fifthace/application/models/fifthace.php
<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class Fifthace extends CI_Model {
public function check_avail() {
return true;
}
public function num_events( $date ) {
$this->db->select('COUNT(A.et_id)');
$this->db->from('5a_event_times as A, 5a_events as B');
$this->db->where('A.et_start > '.strtotime($date));
$this->db->where('A.et_start < '.strtotime('+1 day',strtotime($date)));
$this->db->where('A.event_id=B.event_id');
$this->db->where('B.event_active','1');
$this->db->where('B.event_deleted','0');
return qsql($this->db->get());
}
function dbvar($key) {
$this->db->select('value');
$this->db->from('5a_sitevars');
$this->db->where('varname',$key);
return qsql($this->db->get());
}
}