popufare/server/ui/fleet-management/util.php

<?php

function getval($qry)
{
global $sql;
  $res=mysqli_query($sql, $qry);
  $row=mysqli_fetch_array($res,MYSQL_NUM);
  return $row[0];
}

function login($username, $password)
{
global $sql;
  $safeuser=mysqli_escape_string($sql, $username);
  $combo=mysqli_escape_string($sql, $username . $password);
  
  $qry="SELECT id FROM users WHERE uname='$safeuser' AND secret=SHA1('$combo')";
  
  $res=mysqli_query($sql, $qry);
  
  $row=mysqli_fetch_assoc($res);
  
  if(isset($row['id']))
  {
    $_SESSION['uid']=$row['id'];
    $_SESSION['uname']=$username;
    return true;
  }
  else
  {
    session_unset();
    return false;
  }

}


function logout()
{
  session_unset();
}

function redirect($extra)
{
  $host  = $_SERVER['HTTP_HOST'];
  $uri  = rtrim(dirname($_SERVER['PHP_SELF']), '/\\');

/* DEBUG */
  header("Location: http://$host$uri/$extra");

  //header("Location: https://$host$uri/$extra");
  exit;
}
                    

function generate_select_box($name,$current,$arr,$keyandval=true,$onchange="")
{
  if(strlen($onchange) > 0)
  {
    echo "<select name=\"$name\" onChange=\"$onchange\">\n";
  }
  else
  {
    echo "<select name=\"$name\">\n";
  }
  
  foreach($arr as $k => $v)
  {
    if($keyandval)
    {
      $disp="$k ($v)";
    }
    else
    {
      $disp=$v;
    }
        
    if( (($k == $current) && $keyandval) || (!$keyandval && ($v == $current)) )
    {
      echo "<option selected value=\"$k\">$disp</option>\n";  
    }
    else
    {
      echo "<option value=\"$k\">$disp</option>\n";  
    }
  }
  
  echo "</select>\n";
}

function escape_array($arr)
{
global $sql;
  $accum=array();
  
  foreach($arr as $k => $v)
  {
    $accum[$k]=mysqli_escape_string($sql, $v);
  }
  
  return $accum;
}

function dbgprint($v)
{
  echo "<pre>";
  print_r($v);
  echo "</pre>";
}

function get_userlist()
{
global $sql;
  $res=mysqli_query($sql, "SELECT id, uname FROM users");

  if(!$res)
    return array();
    
  $accum=array();
  
  while($row=mysqli_fetch_assoc($res))
  {
    $accum[]=$row;
  }
  
  return $accum;  
}

?>