Reply to thread

Message

<blockquote data-quote="The_Stig" data-source="post: 1139529" data-attributes="member: 12276">Currently I think its not a DB-Problem, but an API-Problem. Even when I use only the snipplet to activate / deactivate the cam, it doesn't work. This is my current full php where activating/deactivating is not working:[CODE]&lt;?php$httpformat=&quot;http&quot;; //hier angeben ob http oder https$port=&quot;5000&quot;; //port$loginname=&quot;administrator&quot;; //Loginname an der Surveillance Station$passwd=&quot;Password&quot;; //passwort an der Surveillance Station$ip=&quot;192.168.178.99&quot;; //ip adresse der Surveillance station im LAN$cam_id=&quot;2&quot;; // Kamera ID mit script &quot;hole Kamera ID&quot; abfragen, später automatisieren// db$db_name = &quot;root&quot;;$db_pw = &quot;Password&quot;;$db_database = &quot;Surveillance&quot;;$db_table = &quot;user&quot;;$db_ip = &quot;127.0.0.1&quot;;// activate Surveillance$surveillance = true;// connect to db$connection = mysql_connect($db_ip, $db_name,$db_pw) or die (&quot;No connection. User or password is wrong&quot;);// select tablemysql_select_db($db_database) or die (&quot;The Database &quot;. $db_database .&quot; doesn't exist&quot;);// update table$query = &quot;UPDATE &quot;.$db_table.&quot; Set available = &quot;.mysql_real_escape_string($_GET['available']).&quot;, time = NOW() WHERE id = &quot;.mysql_real_escape_string($_GET['id']).&quot; AND password='&quot;.mysql_real_escape_string($_GET['pw']).&quot;'&quot;;$update = mysql_query($query);if (!$update) {&nbsp; &nbsp; die('Error: ' . mysql_error());}// select info$query = &quot;SELECT available FROM &quot;.$db_table;$result = mysql_query($query);while($row = mysql_fetch_object($result)) {&nbsp;&nbsp; if ($row-&gt;available == true)&nbsp; &nbsp; $surveillance = false;}//Login an der Surveillance Station:$json = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/auth.cgi?api=SYNO.API.Auth&amp;method=Login&amp;version=3&amp; account=&quot;.$loginname.&quot;&amp;passwd=&quot;.$passwd.&quot;&amp;session= SurveillanceStation&amp;format=sid'&quot;);$obj = json_decode($json, true);$sid = $obj[&quot;data&quot;][&quot;sid&quot;];if ($surveillance) {//Kamera aktivieren:$json = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/_______________________________________________________entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=&quot;.$cam_id.&quot;&amp;_sid=&quot;.$sid);}else {//Kamera deaktivieren:}//Logout Surveillance Station:$out = file_get_contents($httpformat.&quot;://&quot;.$ip.&quot;:&quot;.$port.&quot;/webapi/auth.cgi?api=SYNO.API.Auth&amp;version=3&amp;method=Logout &amp;session=SurveillanceStation&quot;);?&gt;[/CODE]And this is a script, where activating/deactivating is working:[CODE]&lt;?php//Authentication$json = file_get_contents('http://192.168.178.99:5000/webapi/auth.cgi?api=SYNO.API.Auth&amp;method=Login&amp;version=3&amp;account=administrator&amp;passwd=Password&amp;session=SurveillanceStation&amp;format=sid');$obj = json_decode($json, true);$sid = $obj[&quot;data&quot;][&quot;sid&quot;];//GetList$json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=List&amp;version=3&amp;_sid='.$sid);$obj = json_decode($json, true);$cam_activated = $obj[&quot;data&quot;][&quot;cameras&quot;][0][&quot;enabled&quot;];if($cam_activated == false){&nbsp; &nbsp; //Activate cam&nbsp; &nbsp; $json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=2&amp;_sid='.$sid);&nbsp; &nbsp; echo &quot;&lt;div class=\&quot;centered\&quot;&gt;&lt;img src=\&quot;http://192.168.178.99:5000/on_icon.png\&quot; style=\&quot;width:auto;height:auto;\&quot; /&gt;&lt;/div&gt;&quot;;} else{&nbsp; &nbsp; //Activate cam&nbsp; &nbsp; $json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&amp;method=Enable&amp;version=3&amp;cameraIds=2&amp;_sid='.$sid);&nbsp; &nbsp; echo &quot;&lt;div class=\&quot;centered\&quot;&gt;&lt;img src=\&quot;http://192.168.178.99:5000/off_icon.png\&quot; /&gt;&lt;/div&gt;&quot;;}?&gt;[/CODE]Don't know how to do this. Do you see a possibility to combine the first db-script with the second working activating script?</blockquote>

[QUOTE="The_Stig, post: 1139529, member: 12276"] Currently I think its not a DB-Problem, but an API-Problem. Even when I use only the snipplet to activate / deactivate the cam, it doesn't work. This is my current full php where activating/deactivating is not working: [CODE] <?php $httpformat="http"; //hier angeben ob http oder https $port="5000"; //port $loginname="administrator"; //Loginname an der Surveillance Station $passwd="Password"; //passwort an der Surveillance Station $ip="192.168.178.99"; //ip adresse der Surveillance station im LAN $cam_id="2"; // Kamera ID mit script "hole Kamera ID" abfragen, später automatisieren // db $db_name = "root"; $db_pw = "Password"; $db_database = "Surveillance"; $db_table = "user"; $db_ip = "127.0.0.1"; // activate Surveillance $surveillance = true; // connect to db $connection = mysql_connect($db_ip, $db_name,$db_pw) or die ("No connection. User or password is wrong"); // select table mysql_select_db($db_database) or die ("The Database ". $db_database ." doesn't exist"); // update table $query = "UPDATE ".$db_table." Set available = ".mysql_real_escape_string($_GET['available']).", time = NOW() WHERE id = ".mysql_real_escape_string($_GET['id'])." AND password='".mysql_real_escape_string($_GET['pw'])."'"; $update = mysql_query($query); if (!$update) { die('Error: ' . mysql_error()); } // select info $query = "SELECT available FROM ".$db_table; $result = mysql_query($query); while($row = mysql_fetch_object($result)) { if ($row->available == true) $surveillance = false; } //Login an der Surveillance Station: $json = file_get_contents($httpformat."://".$ip.":".$port."/webapi/auth.cgi?api=SYNO.API.Auth&method=Login&version=3& account=".$loginname."&passwd=".$passwd."&session= SurveillanceStation&format=sid'"); $obj = json_decode($json, true); $sid = $obj["data"]["sid"]; if ($surveillance) { //Kamera aktivieren: $json = file_get_contents($httpformat."://".$ip.":".$port."/webapi/_______________________________________________________entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=".$cam_id."&_sid=".$sid); }else { //Kamera deaktivieren: } //Logout Surveillance Station: $out = file_get_contents($httpformat."://".$ip.":".$port."/webapi/auth.cgi?api=SYNO.API.Auth&version=3&method=Logout &session=SurveillanceStation"); ?>[/CODE] And this is a script, where activating/deactivating is working: [CODE] <?php //Authentication $json = file_get_contents('http://192.168.178.99:5000/webapi/auth.cgi?api=SYNO.API.Auth&method=Login&version=3&account=administrator&passwd=Password&session=SurveillanceStation&format=sid'); $obj = json_decode($json, true); $sid = $obj["data"]["sid"]; //GetList $json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=List&version=3&_sid='.$sid); $obj = json_decode($json, true); $cam_activated = $obj["data"]["cameras"][0]["enabled"]; if($cam_activated == false){ //Activate cam $json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=2&_sid='.$sid); echo "<div class=\"centered\"><img src=\"http://192.168.178.99:5000/on_icon.png\" style=\"width:auto;height:auto;\" /></div>"; } else { //Activate cam $json = file_get_contents('http://192.168.178.99:5000/webapi/entry.cgi?api=SYNO.SurveillanceStation.Camera&method=Enable&version=3&cameraIds=2&_sid='.$sid); echo "<div class=\"centered\"><img src=\"http://192.168.178.99:5000/off_icon.png\" /></div>"; } ?> [/CODE] Don't know how to do this. Do you see a possibility to combine the first db-script with the second working activating script? [/QUOTE]

Verification