<?php 
class SMS{ 
    function get_active_api($utility_class,$db){ 
      $query = "SELECT * FROM `lms2_cnf_sms_api` WHERE `activated` = 1 AND `status` = 1";
      return $db->sql_query($query);
    }

    function api_list($utility_class,$db){ 
      $query = "SELECT * FROM `lms2_cnf_sms_api` WHERE `status` = 1";
      return $db->sql_query($query);
    }

    function activate_api($id,$db){
      $query="UPDATE `lms2_cnf_sms_api` SET `activated`= 1 WHERE `id` = $id";
      return $db->sql_query_affected_rows($query);
    }

    function deactivate_all_api($db){
       $query = "UPDATE `lms2_cnf_sms_api` SET `activated`= 0 WHERE 1";
      return $db->sql_query_affected_rows($query);
    }
}
?>