escape_string($_COOKIE['FW_SESSION']); // Find session cookie in database $res= $mysqli->query("select ". "webcam_session.username,fullname,email,perm,token ". "from webcam_session left join webcam_user ". "on webcam_session.username=webcam_user.username ". "where expires>now() and token='$token'"); if ($res && $res->num_rows>0) { $session= $res->fetch_assoc(); $ip= $mysqli->escape_string($_SERVER['REMOTE_ADDR']); // Update last access time stamp $mysqli->query("update webcam_session set last_act=now(),last_ip='$ip'". " where token='$token'"); $session['valid']= true; } } } // -------------------------------------------------------------------------- // Check if valid MySQL connection is configured and open it // -------------------------------------------------------------------------- function openMysql() { global $webcam; if (isset($webcam['mysqli'])) { return $webcam['mysqli']; } if (isset($webcam['mysqlLogin'])) { $mysqli= new mysqli($webcam['mysqlHost'], $webcam['mysqlLogin'], $webcam['mysqlPassword'], $webcam['mysqlDatabase']); if ($mysqli->connect_errno) { return null; } $webcam['mysqli']= $mysqli; return $mysqli; } return null; } function openMysqlWetter() { global $webcam; if (isset($webcam['mysqliWetter'])) { return $webcam['mysqliWetter']; } if (isset($webcam['mysqlLoginWetter'])) { $mysqli= new mysqli($webcam['mysqlHost'], $webcam['mysqlLoginWetter'], $webcam['mysqlPasswordWetter'], $webcam['mysqlDatabaseWetter']); if ($mysqli->connect_errno) { return null; } $webcam['mysqliWetter']= $mysqli; return $mysqli; } return null; } // -------------------------------------------------------------------------- // Generate a random password // -------------------------------------------------------------------------- function pwGenerate($length) { $res= ""; while (strlen($res)<$length) { $ch= chr(rand(ord('a'), ord('z'))); if (rand(1,5)==1) { $ch= chr(rand(ord('0'), ord('9'))); } if (rand(1,5)==1) { $ch= chr(rand(ord('A'), ord('Z'))); } $res.= $ch; } return $res; } ?> PNG  IHDR&]\ pHYs+IDATHMa߹ B+YLVGb,XNv6W6,FMɂX(i4^{5wtzysFf:")"zMhX&K̟+Hhr>W[  >%5mlLz`D4p j&vc?c_Z쌈~>ro &MU7ži ao 7ݬ[[EkۑjjFUm^ÝE†FU̼3sBQ#`D4K-oF|lD GFLc"@5mN:RN;{Σݺ8xYt̜^\³7Sb˵Ӹ?*I=__-ĺEX?>֕)IENDB`