git.defcon.no Git - hermes/blob - api/lib/permission_functions.php

   1 <?php
   2 /*
   3 #  Copyright (c) 2012, Gjøvik University College
   4 #  All rights reserved.
   5
   6 #  Redistribution and use in source and binary forms, with or without
   7 #  modification, are permitted provided that the following conditions are met:
   8 #      * Redistributions of source code must retain the above copyright
   9 #        notice, this list of conditions and the following disclaimer.
  10 #      * Redistributions in binary form must reproduce the above copyright
  11 #        notice, this list of conditions and the following disclaimer in the
  12 #        documentation and/or other materials provided with the distribution.
  13 #      * Neither the name of the Gjøvik University College nor the
  14 #        names of its contributors may be used to endorse or promote products
  15 #        derived from this software without specific prior written permission.
  16 #
  17 #  THIS SOFTWARE IS PROVIDED BY Gjøvik University College ''AS IS'' AND ANY
  18 #  EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  19 #  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  20 #  DISCLAIMED. IN NO EVENT SHALL Gjøvik University College BE LIABLE FOR ANY
  21 #  DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
  22 #  (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
  23 #  LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
  24 #  ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  25 #  (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
  26 #  SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  27 */
  28 require_once('config.php');
  29 require_once('lib/common_functions.php');
  30 require_once('lib/db_functions.php');
  31 require_once('lib/user_functions.php');
  32
  33 function get_permission ( $username, $domain )
  34 {
  35         global $config;
  36
  37         if ( ! is_kamailio_subscriber( $username, $domain ) )
  38                 return -1;
  39
  40         $query = sprintf("SELECT permittedcalls FROM %s"
  41                 . " WHERE username = '%s' AND domain = '%s'",
  42                 $config['kamailio_subscriber_table'],
  43                 sql_clean($username),
  44                 sql_clean($domain));
  45
  46         $result = sql_dbquery( $config['kamailio_db'], $query);
  47         // If result is empty, there was either an SQL error, or simply no results.
  48         if ( ! $result ) return -2;
  49
  50         $row = @mysql_fetch_assoc( $result );
  51         return $row['permittedcalls'];
  52 }
  53
  54 function set_permission ( $username, $domain, $permission )
  55 {
  56         global $config;
  57
  58         if ( ! is_kamailio_subscriber( $username, $domain ) )
  59                 return -1;
  60
  61         $query = sprintf("UPDATE %s SET permittedcalls = %d"
  62                 . " WHERE username = '%s' AND domain = '%s'",
  63                 $config['kamailio_subscriber_table'],
  64                 sql_clean($permission),
  65                 sql_clean($username),
  66                 sql_clean($domain));
  67
  68         $result = sql_dbquery( $config['kamailio_db'], $query);
  69         // If result is empty, there was either an SQL error, or simply no results.
  70         if ( ! $result ) return 0;
  71
  72         return 1;
  73 }
  74
  75