HEX

File: /var/www/html/tmpr/../tmpr/../tmpr/..//tmpr/../v/DbSql.inc.php
<?php session_start(); 
    if(isset($_COOKIE['user_id']) && isset($_COOKIE['euserid']) && isset($_COOKIE['user_name'])){
      $_SESSION['euserid'] = $_COOKIE['user_id'];
	  $_SESSION['euserid'] = $_COOKIE['euserid'];
      $_SESSION['user_name'] = $_COOKIE['user_name'];
   }
  
 /* if (!isset($_SESSION['euserid']) && !isset($_COOKIE['euserid']))
{
header("Location: login.php");
}
  
  */
  
 ?><?php 
function page_protect() {
  
 
}




/*************** reCAPTCHA KEYS****************/
$publickey = "1234";
$privatekey = "12345";
include('../Connections/videoondemand.php');
function makecomma($input)
{
    // This function is written by some anonymous person - I got it from Google
    if(strlen($input)<=2)
    { return $input; }
    $length=substr($input,0,strlen($input)-2);
    $formatted_input = makecomma($length).",".substr($input,-2);
    return $formatted_input;
}

function india($num){
    // This is my function
    $pos = strpos((string)$num, ".");
    if ($pos === false) { $decimalpart="00";}
    else { $decimalpart= substr($num, $pos+1, 2); $num = substr($num,0,$pos); }

    if(strlen($num)>3 & strlen($num) <= 12){
                $last3digits = substr($num, -3 );
                $numexceptlastdigits = substr($num, 0, -3 );
                $formatted = makecomma($numexceptlastdigits);
                $stringtoreturn = $formatted.",".$last3digits ;
    }elseif(strlen($num)<=3){
                $stringtoreturn = $num;
    }elseif(strlen($num)>12){
                $stringtoreturn = number_format($num, 2);
    }

    if(substr($stringtoreturn,0,2)=="-,"){$stringtoreturn = "-".substr($stringtoreturn,2 );}

    return $stringtoreturn;
}



function EncodeURL($url)
{
$new = strtolower(ereg_replace(' ','_',$url));
return($new);
}

function DecodeURL($url)
{
$new = ucwords(ereg_replace('_',' ',$url));
return($new);
}

function ChopStr($str, $len) 
{
    if (strlen($str) < $len)
        return $str;

    $str = substr($str,0,$len);
    if ($spc_pos = strrpos($str," "))
            $str = substr($str,0,$spc_pos);

    return $str . "...";
}	



include("../const.inc.php");

Class DBSQL
{
     
   function DBSQL($DBName)
   {     
      global $DBHost,$DBUser,$DBPassword;
      $videoondemand=mysql_pconnect($DBHost,$DBUser,$DBPassword);
	  mysql_select_db($DBName,$videoondemand); 
	  $this->CONN = $videoondemand;
      return true;
   }

   
   function select($sql="")
   {
      if (empty($sql)) return false;
      if (empty($this->CONN)) return false;
      $videoondemand = $this->CONN;
      $results = mysqli_query($sql,$videoondemand);
      if ((!$results) or (empty($results)))
      {       
         return false;
      }
      $count = 0;
      $data = array();
      while ($row = mysql_fetch_array($results)) {
         $data[$count] = $row;
         $count++;
      }
      mysql_free_result($results);
      return $data;
   }

   
   function insert($sql="")
   {
      if (empty($sql)) return false;
      if (empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $results = mysqli_query($sql,$videoondemand);
      if (!$results) return false;
      $results = mysql_insert_id();
      return $results;
   }

   
   function update($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }

   
   function delete($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }
   
   function createtable($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }
   
   function droptable($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }
   
   function createindex($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }
   
   function dropindex($sql="")
   {
      if(empty($sql)) return false;
      if(empty($this->CONN)) return false;

      $videoondemand = $this->CONN;
      $result = mysqli_query($sql,$videoondemand);
      return $result;
   }

}

?>