apps/dvr_old/php/camera.php

Go to the documentation of this file.

<?php
    
#    header ('Content-type: text/plain');
    header ('Content-type: text/xml');

    include "tag.php";
    include "def.php";
    include "db.php";
    include "check.php";
    
    define ("DELETE",   1);    
    define ("UNDELETE", 0);
    

    function addCam ($mac, $id, $ip1, $ip2, $place)
    {
        $mac_orig = $mac;
        
        if ( (checkMac ($mac) == -1) || (! $mac))
        {
            return error ("Error: Wrong MAC='" . $mac . "' ", "cameras");
        }
        
        $mac = checkMac ($mac);
        
        $query = "SELECT * FROM cameras WHERE mac='" . $mac . "' " ;
        
        $query_resp     = @mysql_query ($query, $id);
        $num            = @mysql_numrows ($query_resp);

        if ($num > 0)
        {
            $err = '';
            if (mysql_result ($query_resp, $i, "del") == 1)  $err = ' and marked as deleted';
            return error ("Error: Camera with MAC='" . $mac_orig ."' already registered" . $err . "!", "cameras");
        }
        
        $query          = "INSERT INTO cameras VALUES ('" . $mac . "', '" . $ip1 . "', '" . $ip2 . "', '" . $place . "', '0')";
        $query_resp     = @mysql_query ($query, $id);
        
        $ret            = formClosedTag ("OK", "add", "") . "\n";
        $ret            = formClosedTag ($ret, "cameras", "\n") . "\n";
        
        return $ret;
    
    }

    function editCam ($mac, $id, $ip1, $ip2, $place)
    {
        $mac_orig = $mac;
        
        if ( (checkMac ($mac) == -1) || (! $mac))
        {
            return error ("Error: Wrong MAC='" . $mac . "' ", "cameras");
        }
        
        $mac = checkMac ($mac);
        
        $query = "SELECT * FROM cameras WHERE mac='" . $mac . "' AND del=0" ;
        
        $query_resp     = @mysql_query ($query, $id);
        $num            = @mysql_numrows ($query_resp);

        if ($num < 1)
        {
            return error ("Error: Camera with MAC='" . $mac_orig ."' is not found!", "cameras");
        }
        
        $flag           = 0;    
        $query          = "UPDATE cameras SET ";
        if ($ip1)
        {
            $flag        = 1;
            $query      .= "ip1='" . $ip1 . "' ";
        }
        if ($ip2)
        {
            if ($flag == 1) 
            {
                $query  .= ", ";
            }
            $flag        = 1;
            $query      .= "ip2='" . $ip2 . "' ";
        }
        if ($place)
        {
            if ($flag == 1) 
            {
                $query  .= ", ";
            }
            $flag        = 1;
            $query      .= "place='" . $place . "' ";
        }
        
        $query          .= "   WHERE mac='" . $mac . "' AND del=0";
        
        if ($flag == 1)
        {
            $query_resp         = @mysql_query ($query, $id);
        }
        
        $ret            = formClosedTag ("OK", "edit", "") . "\n";
        $ret            = formClosedTag ($ret, "cameras", "\n") . "\n";
        
        return $ret;
    }


    function delUndelCam ($mac, $id, $action)
    {
        $mac_orig = $mac;
        
        if (($mac = checkMac ($mac)) == -1)
        {
            return error ("Error: Wrong MAC=" . $mac, "cameras");
        }
        
        if (($action != DELETE) && ($action != UNDELETE))
        {
            return error ("Error: Wrong action=" . $action, "cameras");
        }
        
        $action_rev = $action == UNDELETE ? DELETE : UNDELETE;
        $query = "SELECT * FROM cameras WHERE mac='" . $mac . "' AND del=" . $action_rev;
        
        $query_resp     = @mysql_query ($query, $id);
        $num            = @mysql_numrows ($query_resp);

        if ($num < 1)
        {
            $err = 'C';
            if ($action == UNDELETE) $err = 'Deleted c';
            return error ("Error: " . $err . "amera with MAC='$mac_orig' is not found", "cameras");
        }
        
        $query = "UPDATE cameras SET del=" . $action . "  WHERE mac='" . $mac . "' AND del=" . $action_rev;     
        $query_resp     = @mysql_query ($query, $id);
        
        $ret = formClosedTag ("OK", "undel", "") . "\n";
        if ($action == DELETE)
        {
            $ret = formClosedTag ("OK", "del", "") . "\n";
        }
        
        $ret = formClosedTag ($ret, "cameras", "\n");
        
        return $ret;
    }


    
    function listCams ($mac, $id)
    {
        $mac_orig = $mac;
        
        if ($mac)
        {       
            if (($mac = checkMac ($mac)) == -1)
            {
                return error ("Error: Wrong MAC=" . $mac, "cameras");
            }
        }
        
        $mac_enabled = 0;
        if ($mac)
        {
            $query = "SELECT * FROM cameras WHERE mac='" . $mac . "' AND del=0";
            $mac_enabled = 1;
        }
        else
        {
            $query = "SELECT * FROM cameras WHERE del=0";
        }
        
        $query_resp     = mysql_query ($query, $id);
        $num            = mysql_numrows ($query_resp);
        
        if ($num < 1)
        {
            if ( $mac_enabled == 1)
            {
                return error ("Error: Camera with MAC='" . $mac_orig . "' is not found", "cameras");
            }
            return error ("Error: Database is empty.", "cameras");
        }
        
        $i   = 0;
        $ret = '';
        while ($i < $num)
        {
            $mac_ = getDottedMac (mysql_result ($query_resp, $i, "mac"));
            $ret_ = '';
            $ret_ = $ret_ . formClosedTag ($mac_,  "mac", "") . "\n";
            $ret_ = $ret_ . formClosedTag (mysql_result ($query_resp, $i, "ip1"),   "ip1", "") . "\n";
            $ret_ = $ret_ . formClosedTag (mysql_result ($query_resp, $i, "ip2"),   "ip2", "") . "\n";
            $ret_ = $ret_ . formClosedTag (mysql_result ($query_resp, $i, "place"), "place", "") . "\n";
            $ret_ = formClosedTag ($ret_, "camera", "\n") . "\n";
            $i++;
            $ret .= $ret_;
        }
        $ret = formClosedTag ($ret, "cameras", "\n");
        
        return $ret;
    }




// Entry point    

    switch ($_GET[cmd]) 
    {
        case "list":
        case "del":
        case "undel":
        case "add":
        case "edit":
            break;
        default :
            echo error ("Error: Unknown command '" . $_GET[cmd] . "' ", "cameras");
            return 0;
            break;
    }
    
    $id = connectToServer (server, user, password);
    if (!$id)
    {
        echo error ("Error: " . mysql_error(), "cameras");
        return 0;
    }
    
    if (!openDB (database, $id))
    {
        echo error ("Error: " . mysql_error($id), "cameras");
        closeDB ($id);
        return 0;
    }
    
    
    switch ($_GET[cmd]) 
    {
        case "list":
            $ret = listCams ($_GET[mac], $id);
            break;
        case "add":
            $ret = addCam ($_GET[mac], $id, $_GET[ip1], $_GET[ip2], $_GET[place]);
            break;
        case "edit":
            $ret = editCam ($_GET[mac], $id, $_GET[ip1], $_GET[ip2], $_GET[place]);
            break;
        case "del":
            $ret = delUndelCam ($_GET[mac], $id, DELETE);
            break;
        case "undel":
            $ret = delUndelCam ($_GET[mac], $id, UNDELETE);
            break;
        default :
            $ret = error ("Error: Unknown command \"$_GET[cmd]\"", "cameras");
            break;
    }
    
    closeDB ($id);
    
    echo $ret
?>

---