function doSomething()
{
if (($object = getObject()) < 0) {
return $object;
}
return $object;
}
function getStreamByObject($object)
{
$query = "SELECT * FROM MSTREAMT WHERE oid={$object} ORDER BY(sid) DESC";
$result = mysql_query($query);
$ret = "<table class='table' style='width:300px;'>";
while ($row = mysql_fetch_array($result)) {
$o = getObject($row["oid"]);
$id = $row["oid"];
$im = getImgUri($o["oimgid"]);
$ret .= "<tr><td>" . $row["message"] . "</td><td>" . dateify($row["postedon"]) . "</td></tr>";
}
$ret .= "</table>";
return $ret;
}
public function listMessages()
{
$user = $this->registry > getObject('authenticate')->getUser()->getUserID();
$data = array();
$sql = "SELECT * FROM `messages` WHERE `sender`=" . $user . " OR `recipient`=" . $user;
$this->registry->getObject('db')->executeQuery($sql);
if ($this->registry->getObject('db')->numRows() > 0) {
$this->empty = false;
while ($fields = $this->registry->getObject('db')->getRows) {
$this->IDs = $fields['ID'];
$data[] = $fields;
}
$this->registry->getObject('template')->buildFromTemplate('header.php', 'messages_main.php', 'footer.php');
$cacheableIDs = array();
foreach ($this->IDs as $id) {
$i = array();
$i['message_id'] = $id;
$cacheableIDs[] = $i;
}
$cache = $this->registry->getObject('db')->cacheData($cacheableIDs);
$this->registry->getObject('template')->getPage()->addTag('message', array('DATA', $cache));
$daTags = array();
$type = $this->getType($d['type']);
foreach ($data as $d) {
foreach ($d as $f => $v) {
$daTags['message_' . $f] = $v;
}
if ($d['sender'] == $this->registry->getObject('authenticate')->getUser()->getUserID() && $d['read'] == 0 && $d['reply'] != 0) {
$this->listReply($d, 'messages/' . $type . '-replySelf-unread.php', $daTags);
} elseif ($d['sender'] == $this->registry->getObject('authenticate')->getUser()->getUserID() && $d['read'] == 1 && $d['reply'] != 0) {
$this->listReply($d, 'messages/' . $type . '-replySelf-read.php', $daTags);
} elseif ($d['read'] == 0 && $d['reply'] != 0) {
$this->listReply($d, 'messages/' . $type . '-reply-unread.php', $daTags);
} elseif ($d['read'] == 1 && $d['reply'] != 0) {
$this->listReply($d, 'messages/' . $type . '-reply-read.php', $daTags);
} elseif ($d['sender'] == $this->registry->getObject('authenticate')->getUser()->getUserID() && $d['read'] == 0) {
$this->registry->getObject('template')->addTemplateBit('message-' . $d['ID'], 'messages/' . $type . '-fromSelf-unread.php', $daTags);
} elseif ($d['sender'] == $this->registry->getObject('authenticate')->getUser()->getUserID() && $d['read'] == 1) {
$this->registry->getObject('template')->addTemplateBit('message-' . $d['ID'], 'messages/' . $type . '-fromSelf-read.php', $daTags);
} elseif ($d['read'] == 0) {
$this->registry->getObject('template')->addTemplateBit('message-' . $d['ID'], 'messages/' . $type . '-unread.php', $daTags);
} else {
$daTags['message_replyFrom'] = '';
$this->registry->getObject('template')->addTemplateBit('message-' . $d['ID'], 'messages/' . $type . '-read.php', $daTags);
}
}
}
}
define(ROOT, $_SERVER['DOCUMENT_ROOT']);
include_once ROOT . "/functions/database_management.php";
//TODO: Reemplazar por $_SESSION['username']
switch ($_POST["functionCalled"]) {
case "hasCompleted":
echo 'ret=' . var_export(hasCompleted($_POST["eventName"], $_POST["username"], $_POST["puzzle"]), true);
break;
case "complete":
echo complete($_POST["eventName"], $_POST["username"], $_POST["puzzle"]);
break;
case "isAvailable":
echo 'ret=' . var_export(isAvailable($_POST["eventName"], $_POST["username"], $_POST["object"]), true);
break;
case "hasObject":
echo 'ret=' . var_export(hasObject($_POST["eventName"], $_POST["username"], $_POST["object"]), true);
break;
case "usedObject":
echo 'ret=' . var_export(usedObject($_POST["eventName"], $_POST["username"], $_POST["object"]), true);
break;
case "releaseObject":
releaseObject($_POST["eventName"], $_POST["username"], $_POST["object"]);
break;
case "getObject":
getObject($_POST["eventName"], $_POST["username"], $_POST["object"]);
break;
case "useObject":
useObject($_POST["eventName"], $_POST["username"], $_POST["object"]);
break;
}
?>
/**
* Title
*
* Description
*
* @access public
*/
function callMethod($method_name, $params = 0)
{
$tmp = explode('.', $method_name);
if ($tmp[2]) {
$object_name = $tmp[0] . '.' . $tmp[1];
$varname = $tmp[2];
} elseif ($tmp[1]) {
$object_name = $tmp[0];
$method_name = $tmp[1];
} else {
$object_name = 'ThisComputer';
}
$obj = getObject($object_name);
if ($obj) {
return $obj->callMethod($method_name, $params);
} else {
return 0;
}
}
<?php
header('Content-Type: text/html; charset=utf-8');
include '../../includes/classes/core.php';
include '../../includes/classes/barcode/tfpdf.php';
include '../../includes/classes/logger.class.php';
$object_id = $_REQUEST['id'];
$status = $_REQUEST['status'];
$res = mysql_query("SELECT \t\tproduction.`name` AS `name`,\n\t\t\t\t\t\t\t\tCONCAT(sale_transaction_detail.product_quantity, ' ', production_unit.`name`) AS `quantity`\n\t\t\t\t\tFROM \t\tsale_transaction\n\t\t\t\t\tLEFT JOIN \tsale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\n\t\t\t\t\tRIGHT JOIN \tproduction ON production.id = sale_transaction_detail.production_id\n\t\t\t\t\tLEFT JOIN production_unit ON production.unit = production_unit.id\n\t\t\t\t\tWHERE \t\tsale_transaction.object_id = {$object_id} AND sale_transaction.`status` = {$status} AND sale_transaction_detail.production_id NOT IN (SELECT recipie.recipie_id FROM recipie)");
$res1 = mysql_query("SELECT \t\t\tsale_transaction_detail.id,\n\t\t\t\t\t\t\t\t\t\tpr1.`name` AS `name`,\n\t\t\t\t\t\t\t\t\t\tCONCAT(sale_transaction_detail.product_quantity, ' ', pu1.`name`) AS `quantity`,\n\t\t\t\t\t\t\t\t\t\tpr2.`name`AS `ingredient`,\n\t\t\t\t\t\t\t\t\t\trecipie_producing.quantity / recipie.quantity AS `ing_quantity`\n\t\t\t\t\t\tFROM \t\t\tsale_transaction\n\t\t\t\t\t\tLEFT JOIN \t\tsale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\n\t\t\t\t\t\tLEFT JOIN \trecipie_producing ON recipie_producing.recipie_id = sale_transaction_detail.production_id AND recipie_producing.transaction_detail_id = sale_transaction_detail.id\n\t\t\t\t\t\tLEFT JOIN \trecipie ON recipie_producing.recipie_id = recipie.recipie_id AND recipie_producing.production_id = recipie.ingredient_id\n\t\t\t\t\t\tLEFT JOIN\t\tproduction AS pr2 ON recipie_producing.production_id = pr2.id\n\t\t\t\t\t\tLEFT JOIN \t\tproduction AS pr1 ON pr1.id = sale_transaction_detail.production_id\n\t\t\t\t\t\tLEFT JOIN \tproduction_unit AS pu1 ON pr1.unit = pu1.id\n\t\t\t\t\t\tLEFT JOIN \tproduction_unit AS pu2 ON pr2.unit = pu2.id\n\t\t\t\t\t\tWHERE \t\t\tsale_transaction.object_id = {$object_id} AND sale_transaction.`status` = {$status} AND recipie_producing.quantity > 0 AND `recipie`.`visible` = 1 ");
$res3 = mysql_query("SELECT \t\tproduction.`name`,\n\t\t\t\t\t\t\t\t\tCONCAT(sale_transaction_detail.product_quantity, ' ', production_unit.`name`) AS `quantity` \n\t\t\t\t\tFROM \t\t\tsale_transaction\n\t\t\t\t\tLEFT JOIN\t \tsale_transaction_detail ON sale_transaction.id = sale_transaction_detail.transaction_id\n\t\t\t\t\tRIGHT JOIN\t \tproduction ON production.id = sale_transaction_detail.production_id\n\t\t\t\t\tLEFT JOIN \t\tproduction_unit ON production.unit = production_unit.id\n\t\t\t\t\tLEFT JOIN \trecipie ON recipie.recipie_id = production.id\n\t\t\t\t\tWHERE \t\t\tsale_transaction.object_id = 136 AND sale_transaction.`status` = 4 AND sale_transaction_detail.production_id \n\t\t\t\t\tGROUP BY recipie.recipie_id\n\t\t\t\t\tHAVING sum(recipie.visible)=0\n\t\t\t\t\t\t");
echo '<p align=center style=" font-size: 15px;"><u>' . date('Y-m-d H:i') . '</u></p>';
echo '<p align=center style=" font-size: 15px;">ობიექტი: <u>' . getObject($object_id) . '</u></p></br>';
echo '<table style="width: 100%; " cellspacing="0" cellpadding="6">';
while ($row = mysql_fetch_assoc($res)) {
echo '<tr>';
echo '<td style=" font-size: 14px; width: 35%; border-bottom:1px solid black;"><p>   ' . $row['name'] . '</p></td>';
echo '<td style=" font-size: 14px; width: 15%; border-bottom:1px solid black;"><p>' . $row['quantity'] . '</p></td>';
}
$array = array();
while ($row1 = mysql_fetch_assoc($res1)) {
echo '<tr>';
if (in_array($row1[id], $array)) {
echo '<td style=" font-size: 12px; width: 80%; border-bottom:1px solid black;"><p>      ' . $row1['ingredient'] . '</p></td>';
echo '<td style=" font-size: 12px; width: 15%; border-bottom:1px solid black;"><p>      ' . round($row1['ing_quantity'] / $row1['quantity'], 0) . '</p></td>';
} else {
echo '</tr>';
echo '<tr>';
echo '<td style=" font-size: 14px; width: 80%; border-bottom:1px solid black;"><b>   ' . $row1['name'] . '</b></td>';
echo '<td style=" font-size: 14px; width: 15%; border-bottom:1px solid black;"><p> ' . $row1['quantity'] . '</p></td>';
echo '</tr>';
$sortby = $sortby . " DESC";
}
}
$session->data['commands_sort'] = $sortby;
}
$sortby = "PRIORITY DESC, TITLE";
$out['SORTBY'] = $sortby;
// SEARCH RESULTS
$res = SQLSelect("SELECT * FROM commands WHERE {$qry} ORDER BY {$sortby}");
if ($res[0]['ID']) {
if ($this->action != 'admin') {
$dynamic_res = array();
$total = count($res);
for ($i = 0; $i < $total; $i++) {
if ($res[$i]['SMART_REPEAT'] && $res[$i]['LINKED_OBJECT']) {
$obj = getObject($res[$i]['LINKED_OBJECT']);
$objects = getObjectsByClass($obj->class_id);
$total_o = count($objects);
for ($io = 0; $io < $total_o; $io++) {
$rec = $res[$i];
$rec['ID'] = $res[$i]['ID'] . '_' . $objects[$io]['ID'];
$rec['LINKED_OBJECT'] = $objects[$io]['TITLE'];
$rec['DATA'] = str_replace('%' . $res[$i]['LINKED_OBJECT'] . '.', '%' . $rec['LINKED_OBJECT'] . '.', $rec['DATA']);
$rec['CUR_VALUE'] = getGlobal($rec['LINKED_OBJECT'] . '.' . $rec['LINKED_PROPERTY']);
$rec['TITLE'] = $objects[$io]['TITLE'];
$dynamic_res[] = $rec;
}
} else {
$dynamic_res[] = $res[$i];
}
}
}
}
foreach ($bt_devices as $k => $v) {
if ($v != $last_scan) {
//device removed
echo date('Y/m/d H:i:s') . " Device gone: {$k}\n";
$user = array();
$rec = SQLSelectOne("SELECT * FROM btdevices WHERE MAC LIKE '" . $k . "'");
if ($rec['ID']) {
$rec['LOG'] = 'Device lost ' . date('Y/m/d H:i:s') . "\n" . $rec['LOG'];
SQLUpdate('btdevices', $rec);
if ($rec['USER_ID']) {
$user = SQLSelectOne("SELECT * FROM users WHERE ID='" . $rec['USER_ID'] . "'");
}
}
getObject('BlueDev')->raiseEvent("Lost", array('mac' => $k, 'user' => $user['NAME']));
unset($bt_devices[$k]);
}
}
}
} else {
echo "Running Bluetooth monitor.";
}
$first_run = 0;
if (file_exists('./reboot') || $_GET['onetime']) {
$db->Disconnect();
exit;
}
sleep(1);
}
// closing database connection
function getRenditions($objectId, $options = array(OPT_RENDITION_FILTER => "*"))
{
return getObject($objectId, $options);
}
/**
* Title
*
* Description
*
* @access public
*/
function getDynamicElements($qry = '1')
{
$elements = SQLSelect("SELECT elements.* FROM elements, scenes WHERE elements.SCENE_ID=scenes.ID AND {$qry} ORDER BY PRIORITY DESC, TITLE");
$totale = count($elements);
$res2 = array();
for ($ie = 0; $ie < $totale; $ie++) {
$states = SQLSelect("SELECT elm_states.*,elements.TYPE FROM elm_states, elements WHERE elm_states.ELEMENT_ID=elements.ID AND ELEMENT_ID='" . $elements[$ie]['ID'] . "' ORDER BY elm_states.PRIORITY DESC, elm_states.TITLE");
if ($elements[$ie]['SMART_REPEAT'] && !$this->action == 'admin') {
$linked_object = '';
if ($states[0]['LINKED_OBJECT']) {
$linked_object = $states[0]['LINKED_OBJECT'];
} elseif ($states[0]['ACTION_OBJECT']) {
$linked_object = $states[0]['ACTION_OBJECT'];
}
if ($linked_object) {
$obj = getObject($linked_object);
$objects = getObjectsByClass($obj->class_id);
$total_o = count($objects);
for ($io = 0; $io < $total_o; $io++) {
$rec = $elements[$ie];
$rec['ID'] = $elements[$ie] . '_' . $objects[$io]['ID'];
$new_states = array();
$total_s = count($states);
for ($is = 0; $is < $total_s; $is++) {
$state_rec = $states[$is];
if ($state_rec['LINKED_OBJECT']) {
$state_rec['LINKED_OBJECT'] = $objects[$io]['TITLE'];
}
if ($state_rec['ACTION_OBJECT']) {
$state_rec['ACTION_OBJECT'] = $objects[$io]['TITLE'];
}
if ($state_rec['HTML']) {
$state_rec['HTML'] = str_replace('%' . $linked_object . '.', '%' . $objects[$io]['TITLE'] . '.', $state_rec['HTML']);
}
$state_rec['ID'] = $state_rec['ID'] . '_' . $objects[$io]['ID'];
$new_states[] = $state_rec;
}
$rec['STATES'] = $new_states;
$res2[] = $rec;
}
} else {
$elements[$ie]['STATES'] = $states;
$elements[$ie]['SMART_REPEAT'] = 0;
$res2[] = $elements[$ie];
}
} else {
$elements[$ie]['STATES'] = $states;
$res2[] = $elements[$ie];
}
}
return $res2;
}
include_once "./lib/loader.php";
include_once DIR_MODULES . "application.class.php";
$db = new mysql(DB_HOST, '', DB_USER, DB_PASSWORD, DB_NAME);
// connecting to database
include_once "./load_settings.php";
set_time_limit(30);
if (!$width) {
$w = 610;
} else {
$w = (int) $width;
}
// Dataset definition
//$DataSet = new pData;
if ($p != '') {
if (preg_match('/(.+)\\.(.+)/is', $p, $m)) {
$obj = getObject($m[1]);
$prop_id = $obj->getPropertyByName($m[2], $obj->class_id, $obj->id);
}
}
//$type='';
$pvalue = SQLSelectOne("SELECT * FROM pvalues WHERE PROPERTY_ID='" . $prop_id . "' AND OBJECT_ID='" . $obj->id . "'");
if (!$pvalue['ID']) {
echo "Incorrect property name";
exit;
}
if ($_GET['op'] == 'value') {
echo $pvalue['VALUE'];
exit;
}
$end_time = time();
if ($_GET['px']) {
/**
* Title
*
* Description
*
* @access public
*/
function processCommand($command) {
getObject("ThisComputer")->callMethod("commandReceived", array("command"=>$command));
}
foreach ($bt_devices as $k => $v) {
if ($v != $last_scan) {
//device removed
echo date('Y/m/d H:i:s') . ' Device gone: ' . $k . '\\n';
$user = array();
$sqlQuery = "SELECT * \n FROM btdevices \n WHERE MAC LIKE '" . $k . "'";
$rec = SQLSelectOne($sqlQuery);
if ($rec['ID']) {
$rec['LOG'] = 'Device lost ' . date('Y/m/d H:i:s') . '\\n' . $rec['LOG'];
SQLUpdate('btdevices', $rec);
if ($rec['USER_ID']) {
$sqlQuery = "SELECT * \n FROM users \n WHERE ID = '" . $rec['USER_ID'] . "'";
$user = SQLSelectOne($sqlQuery);
}
}
$objectArray = array('mac' => $k, 'user' => $user['NAME']);
getObject('BlueDev')->raiseEvent("Lost", $objectArray);
unset($bt_devices[$k]);
}
}
}
}
$first_run = 0;
if (file_exists('./reboot') || $_GET['onetime']) {
$db->Disconnect();
exit;
}
sleep(1);
}
// closing database connection
$db->Disconnect();
final function getEobject()
{
$class = "exx{$this->getClass()}";
return getObject($class);
}
/**
* Title
*
* Description
*
* @access public
*/
function checkAllVars($force=0) {
// ping hosts
if ($force) {
$pings=SQLSelect("SELECT * FROM webvars WHERE 1");
} else {
$pings=SQLSelect("SELECT * FROM webvars WHERE CHECK_NEXT<=NOW()");
}
$total=count($pings);
for($i=0;$i<$total;$i++) {
$host=$pings[$i];
if (!$force) {
echo "Checking webvar: ".$host['HOSTNAME']."\n";
}
$online_interval=$host['ONLINE_INTERVAL'];
if (!$online_interval) {
$online_interval=60;
}
$host['CHECK_NEXT']=date('Y-m-d H:i:s', time()+$online_interval);
SQLUpdate('webvars', $host);
// checking
//web host
$old_status=$host['LATEST_VALUE'];
if ($host['AUTH'] && $host['USERNAME']) {
$content=getURL($host['HOSTNAME'], $host['ONLINE_INTERVAL'], $host['USERNAME'], $host['PASSWORD']);
} else {
$content=getURL($host['HOSTNAME'], $host['ONLINE_INTERVAL']);
}
if ($host['ENCODING']!='') {
$content=iconv($host['ENCODING'], "UTF-8", $content);
}
$ok=1;
$new_status='';
if ($host['SEARCH_PATTERN']) {
if (preg_match('/'.$host['SEARCH_PATTERN'].'/is', $content, $m)) {
$new_status=$m[1];
} else {
$ok=0; // result did not matched
}
} else {
$new_status=$content;
}
if ($host['CHECK_PATTERN'] && !preg_match('/'.$host['CHECK_PATTERN'].'/is', $new_status)) {
$ok=0; // result did not pass the check
}
if (!$ok) {
$host['LOG']=date('Y-m-d H:i:s').' incorrect value:'.$new_status."\n".$host['LOG'];
SQLUpdate('webvars', $host);
continue;
}
$host['CHECK_LATEST']=date('Y-m-d H:i:s');
$host['CHECK_NEXT']=date('Y-m-d H:i:s', time()+$online_interval);
if ($old_status!=$new_status) {
$host['LOG']=date('Y-m-d H:i:s').' new value:'.$new_status."\n".$host['LOG'];
}
$host['LATEST_VALUE']=$new_status;
SQLUpdate('webvars', $host);
if ($host['LINKED_OBJECT']!='' && $host['LINKED_PROPERTY']!='') {
getObject($host['LINKED_OBJECT'])->setProperty($host['LINKED_PROPERTY'], $new_status);
}
if ($old_status!=$new_status && $old_status!='') {
// do some status change actions
$run_script_id=0;
$run_code='';
// got online
if ($host['SCRIPT_ID']) {
$run_script_id=$host['SCRIPT_ID'];
} elseif ($host['CODE']) {
$run_code=$host['CODE'];
}
if ($run_script_id) {
//run script
runScript($run_script_id);
} elseif ($run_code) {
//run code
eval($run_code);
}
}
}
}
$sqlQuery = "SELECT ID, TITLE\n FROM objects\n WHERE {$o_qry}";
$objects = SQLSelect($sqlQuery);
$total = count($objects);
for ($i = 0; $i < $total; $i++) {
echo $objects[$i]['TITLE'] . "->onNewMinute\n";
getObject($objects[$i]['TITLE'])->raiseEvent("onNewMinute");
getObject($objects[$i]['TITLE'])->setProperty("time", date('Y-m-d H:i:s'));
}
$old_minute = $m;
}
if ($h != $old_hour) {
$sqlQuery = "SELECT ID, TITLE\n FROM objects\n WHERE {$o_qry}";
echo "new hour\n";
$old_hour = $h;
$objects = SQLSelect($sqlQuery);
$total = count($objects);
for ($i = 0; $i < $total; $i++) {
getObject($objects[$i]['TITLE'])->raiseEvent("onNewHour");
}
}
if ($dt != $old_date) {
echo "new day\n";
$old_date = $dt;
}
if (file_exists('./reboot') || $_GET['onetime']) {
$db->Disconnect();
exit;
}
sleep(1);
}
DebMes("Unexpected close of cycle: " . basename(__FILE__));
$doesExist = $ossClient->doesObjectExist($bucket, "c.file.copy");
Common::println("file c.file.copy exist? " . ($doesExist ? "yes" : "no"));
// 批量删除object
$result = $ossClient->deleteObjects($bucket, array("b.file", "c.file"));
foreach ($result as $object) {
Common::println($object);
}
sleep(2);
unlink("c.file.localcopy");
//******************************* 完整用法参考下面函数 ****************************************************
listObjects($ossClient, $bucket);
listAllObjects($ossClient, $bucket);
createObjectDir($ossClient, $bucket);
putObject($ossClient, $bucket);
uploadFile($ossClient, $bucket);
getObject($ossClient, $bucket);
getObjectToLocalFile($ossClient, $bucket);
copyObject($ossClient, $bucket);
modifyMetaForObject($ossClient, $bucket);
getObjectMeta($ossClient, $bucket);
deleteObject($ossClient, $bucket);
deleteObjects($ossClient, $bucket);
doesObjectExist($ossClient, $bucket);
/**
* 创建虚拟目录
*
* @param OssClient $ossClient OssClient实例
* @param string $bucket 存储空间名称
* @return null
*/
function createObjectDir($ossClient, $bucket)
/**
* Title
*
* Description
*
* @access public
*/
function processCommand($command)
{
global $pattern_matched;
if (!$pattern_matched) {
getObject("ThisComputer")->callMethod("commandReceived", array("command" => $command));
}
}
function MessageStatus( &$pMessage, $Status ) {
global $skype, $CurrentUser, $archivechats;
global $pt;
$myhandle = $CurrentUser->Handle;
$cmeUnknown = -1;
$cmeCreatedChatWith = 0;
$cmeAddedMembers = 2;
$cmeSetTopic = 3;
$cmeSaid = 4;
$cmeLeft = 5;
if ($pMessage->Type == $cmeSetTopic) {
//skype_SetTopic($pMessage);
} else if ($pMessage->Type == $cmeAddedMembers) {
//skype_add_member($pMessage);
} else if ($pMessage->Type == $cmeSaid || $pMessage->Type == $cmeUnknown) {
if ($Status == 0 || $Status == 2) {
// print "\n$pMessage->body $Status $pMessage->type";
if ($pMessage->FromHandle <> $CurrentUser->Handle ) {
echo $pMessage->FromHandle.": ".convert_cyr_string($pMessage->Body, 'w', 'd')."\n";
if ( substr(strtolower($pMessage->Body),0,4) == 'ping' ) {
$skype->Chat($pMessage->ChatName)->SendMessage("pong");
}
$user=SQLSelectOne("SELECT ID FROM users WHERE SKYPE LIKE '".$pMessage->FromHandle."'");
if (!$user['ID']) {
$user=SQLSelectOne("SELECT ID FROM users ORDER BY ID");
}
$user_id=$user['ID'];
$qrys=explode(' '.DEVIDER.' ', iconv('WINDOWS-1251', 'UTF-8', $pMessage->Body));
$total=count($qrys);
for($i=0;$i<$total;$i++) {
$room_id=0;
$rec=array();
$rec['ROOM_ID']=(int)$room_id;
$rec['MEMBER_ID']=$user_id;
$rec['MESSAGE']=htmlspecialchars($qrys[$i]);
$rec['ADDED']=date('Y-m-d H:i:s');
SQLInsert('shouts', $rec);
$pt->checkAllPatterns();
getObject("ThisComputer")->raiseEvent("commandReceived", array("command"=>$qrys[$i]));
}
}
}
}
}
public static function get_details($message_id)
{
global $n;
global $pt;
//Получаем id чата, используется для ответа
$ch = $n->Invoke('GET CHATMESSAGE ' . $message_id . ' CHATNAME');
//Получаем текст сообщения
$mess = $n->Invoke('GET CHATMESSAGE ' . $message_id . ' BODY');
//Получаем автора сообщения
$aut = $n->Invoke('GET CHATMESSAGE ' . $message_id . ' FROM_DISPNAME');
/*
* Теперь мы получим из строк, которые мы только что получили, нужные нам данные.
* А именно: Автора сообщения, id чата и текст сообщения.
*/
$author = explode('FROM_DISPNAME ', $aut);
$chat = explode('CHATNAME ', $ch);
$message = explode('BODY ', $mess);
//Выводим в консоль автора и сообщение
#echo $author[1].': '.$message[1]."\n";
//на ping отвечаем pong - для тестирования приема сообщений скриптом. Если ответа нет - скорее всего скрипт остановлися.
if (substr(strtolower($message[1]), 0, 4) == 'ping') {
$n->Invoke('CHATMESSAGE ' . $chat[1] . ' pong');
return true;
}
//обработаем сообщения, начинающиеся с восклицательного знака !
//оставил возможность для примера - можно будет удалить
if ($message[1][0] == '!') {
self::reply($chat[1], $message[1], $message_id);
return true;
}
//на остальные сообщения - выполняем обычную обработку через модуль MajorDoMo
$user = SQLSelectOne("SELECT ID FROM users WHERE SKYPE LIKE '" . $author[1] . "'");
if (!$user['ID']) {
$user = SQLSelectOne("SELECT ID FROM users ORDER BY ID");
}
$user_id = $user['ID'];
$qrys = explode(' ' . DEVIDER . ' ', $message[1]);
$total = count($qrys);
for ($i = 0; $i < $total; $i++) {
$room_id = 0;
$rec = array();
$rec['ROOM_ID'] = (int) $room_id;
$rec['MEMBER_ID'] = $user_id;
$rec['MESSAGE'] = htmlspecialchars($qrys[$i]);
$rec['ADDED'] = date('Y-m-d H:i:s');
SQLInsert('shouts', $rec);
$pt->checkAllPatterns();
getObject("ThisComputer")->raiseEvent("commandReceived", array("command" => $qrys[$i]));
}
}
<?php
if (isset($_GET[msgid]) && !empty($_GET[msgid])) {
require_once "action/checkAamsLogin.php";
require_once "action/smarty_inc.php";
require_once "action/mysql.class.php";
$info = getObject("message where id='{$_GET['msgid']}'", $db);
$smarty->assign("info", $info);
$smarty->display("msginfo.html");
} else {
echo "<script>window.history.back();</script>";
exit;
}
$db = new mysql(DB_HOST, '', DB_USER, DB_PASSWORD, DB_NAME);
include_once "./load_settings.php";
$res = '';
$known_fields = array('tempOutside' => 2, 'relHumOutside' => 3, 'dewPoint' => 4, 'windLatest' => 6, 'windAverage' => 5, 'rainfallRate' => 8, 'rainfallHour' => 47, 'rainfall24' => 9, 'pressure' => 10, 'pressureRt' => -1, 'pressureTrend' => 18, 'windDirection' => 11, 'windDirectionAverage' => 51, 'tempInside' => 22, 'relHumInside' => 23, 'updatedTime' => 1, 'updatedDate' => 0);
$data = explode(' ', $_POST['data']);
$total = count($data);
for ($i = 0; $i < $total; $i++) {
$res .= 'data[' . $i . '] = ' . $data[$i] . "\n";
}
//DebMes('cumulus data: '.$res);
$obj = getObject('ws');
if (!$obj) {
$rec = array();
$rec['TITLE'] = 'ws';
$rec['ID'] = SQLInsert('objects', $rec);
$obj = getObject('ws');
}
$object_rec = SQLSelectOne("SELECT * FROM objects WHERE ID = '" . $obj->id . "'");
if (!$object_rec['CLASS_ID']) {
$class_rec = array();
$class_rec['TITLE'] = 'WeatherStations';
$class_rec['SUB_LIST'] = 0;
$class_rec['PARENT_LIST'] = 0;
$class_rec['ID'] = SQLInsert('classes', $class_rec);
$object_rec['CLASS_ID'] = $class_rec['ID'];
SQLUpdate('objects', $object_rec);
}
foreach ($known_fields as $k => $v) {
$prop_rec = SQLSelectOne("SELECT * FROM properties WHERE TITLE LIKE '" . DBSafe($k) . "' AND CLASS_ID = '" . $object_rec['CLASS_ID'] . "'");
if (!$prop_rec['ID']) {
$prop_rec['CLASS_ID'] = $object_rec['CLASS_ID'];
<?php
if (isset($_GET[task]) && "toUpdateCase" == $_GET[task] && isset($_GET[caseid]) && !empty($_GET[caseid])) {
require_once "action/checkAamsLogin.php";
require_once "action/smarty_inc.php";
require_once "action/mysql.class.php";
$info = getObject("`case` where id='{$_GET['caseid']}'", $db);
$smarty->assign("info", $info);
$smarty->display("editcase.html");
} else {
echo "<script>window.history.back();</script>";
exit;
}
foreach ($_GET as $k => $v) {
$request .= '&' . $k . '=' . $v;
}
if (!$request && $commandLine) {
$request = implode(' ', $argv);
}
//echo "object: $object op: $op m: $m status: $status ";exit;
if (!$commandLine) {
header('Content-Type: text/html; charset=utf-8');
}
//echo "\nRequest: ".$request;
//exit;
//DebMes("Request: ".$request);
if ($object != '') {
//DebMes("object: ".$object);
$obj = getObject($object);
if ($obj) {
//DebMes("object [".$object."] FOUND");
if ($op == 'get') {
$value = $obj->getProperty($p);
echo $value;
}
if ($op == 'set') {
$obj->setProperty($p, $v);
echo "OK";
}
if ($op == 'm') {
$params = array();
foreach ($_GET as $k => $v) {
$params[$k] = ${$k};
}
sleep(5);
}
if (file_exists('./reboot')) {
unlink('./reboot');
}
// connecting to database
$db = new mysql(DB_HOST, '', DB_USER, DB_PASSWORD, DB_NAME);
include_once "./load_settings.php";
echo "CONNECTED TO DB" . PHP_EOL;
include_once DIR_MODULES . "control_modules/control_modules.class.php";
$ctl = new control_modules();
echo "Running startup maintenance" . PHP_EOL;
$run_from_start = 1;
include "./scripts/startup_maintenance.php";
$run_from_start = 0;
getObject('ThisComputer')->raiseEvent("StartUp");
// 1 second sleep
sleep(1);
// getting list of /scripts/cycle_*.php files to run each in separate thread
$cycles = array();
if (is_dir("./scripts")) {
if ($lib_dir = opendir("./scripts")) {
while (($lib_file = readdir($lib_dir)) !== false) {
if (preg_match("/^cycle_.+?\\.php\$/", $lib_file)) {
$cycles[] = './scripts/' . $lib_file;
}
}
closedir($lib_dir);
}
}
$threads = new Threads();
<?php
require_once "action/checkAamsLogin.php";
require_once "action/smarty_inc.php";
require_once "action/mysql.class.php";
$info = getObject(" `comm_code` a,`comm_code` b where a.id=b.fkid and a.comm_code='Partner'", $db, "a.comm_value as info,b.comm_value as descinfo,b.comm_type,b.id");
$smarty->assign("info", $info);
$smarty->display("partner.html");
$session->data['commands_sort']=$sortby;
}
$sortby="PRIORITY DESC, TITLE";
$out['SORTBY']=$sortby;
// SEARCH RESULTS
$res=SQLSelect("SELECT * FROM commands WHERE $qry ORDER BY $sortby");
if ($res[0]['ID']) {
$total=count($res);
for($i=0;$i<$total;$i++) {
// some action for every record if required
$item=$res[$i];
if ($item['LINKED_PROPERTY']!='') {
$lprop=getObject($item['LINKED_OBJECT'])->getProperty($item['LINKED_PROPERTY']);
if ($item['TYPE']=='custom') {
$field='DATA';
} else {
$field='CUR_VALUE';
}
if ($lprop!=$item[$field]) {
$item[$field]=$lprop;
SQLUpdate('commands', $item);
$res[$i]=$item;
}
}
if ($item['TYPE']=='timebox') {
$tmp=explode(':', $item['CUR_VALUE']);
/**
* Title
*
* Description
*
* @access public
*/
function checkAllVars($force = 0)
{
// ping hosts
if ($force) {
$pings = SQLSelect("SELECT * FROM webvars WHERE 1");
} else {
$pings = SQLSelect("SELECT * FROM webvars WHERE CHECK_NEXT<=NOW()");
}
$total = count($pings);
for ($i = 0; $i < $total; $i++) {
$host = $pings[$i];
if (!$force) {
echo date('H:i:s') . " Checking webvar: " . processTitle($host['HOSTNAME']) . "\n";
}
if (!$host['HOSTNAME']) {
continue;
}
$online_interval = $host['ONLINE_INTERVAL'];
if (!$online_interval) {
$online_interval = 60;
}
$host['CHECK_NEXT'] = date('Y-m-d H:i:s', time() + $online_interval);
SQLUpdate('webvars', $host);
// checking
//web host
$old_status = $host['LATEST_VALUE'];
if ($host['AUTH'] && $host['USERNAME']) {
$content = getURL(processTitle($host['HOSTNAME']), $host['ONLINE_INTERVAL'], $host['USERNAME'], $host['PASSWORD']);
} else {
$content = getURL(processTitle($host['HOSTNAME']), $host['ONLINE_INTERVAL']);
}
if ($host['ENCODING'] != '') {
$content = iconv($host['ENCODING'], "UTF-8", $content);
}
$ok = 1;
$new_status = '';
if ($host['SEARCH_PATTERN']) {
if (preg_match('/' . $host['SEARCH_PATTERN'] . '/is', $content, $m)) {
//$new_status=$m[1];
$total1 = count($m);
for ($i1 = 1; $i1 < $total1; $i1++) {
$new_status .= $m[$i1];
}
} else {
$ok = 0;
// result did not matched
}
} else {
$new_status = $content;
}
if ($host['CHECK_PATTERN'] && !preg_match('/' . $host['CHECK_PATTERN'] . '/is', $new_status)) {
$ok = 0;
// result did not pass the check
}
if (strlen($new_status) > 50 * 1024) {
$new_status = substr($new_status, 0, 50 * 1024);
}
if (!$ok) {
$host['LOG'] = date('Y-m-d H:i:s') . ' incorrect value:' . $new_status . "\n" . $host['LOG'];
$tmp = explode("\n", $host['LOG']);
$total = count($tmp);
if ($total > 50) {
$tmp = array_slice($tmp, 0, 50);
$host['LOG'] = implode("\n", $tmp);
}
SQLUpdate('webvars', $host);
continue;
}
$host['CHECK_LATEST'] = date('Y-m-d H:i:s');
$host['CHECK_NEXT'] = date('Y-m-d H:i:s', time() + $online_interval);
if ($old_status != $new_status) {
$host['LOG'] = date('Y-m-d H:i:s') . ' new value:' . $new_status . "\n" . $host['LOG'];
$tmp = explode("\n", $host['LOG']);
$total = count($tmp);
if ($total > 50) {
$tmp = array_slice($tmp, 0, 50);
$host['LOG'] = implode("\n", $tmp);
}
}
$host['LATEST_VALUE'] = $new_status;
SQLUpdate('webvars', $host);
if ($host['LINKED_OBJECT'] != '' && $host['LINKED_PROPERTY'] != '') {
getObject($host['LINKED_OBJECT'])->setProperty($host['LINKED_PROPERTY'], $new_status);
}
if ($old_status != $new_status && $old_status != '') {
$params = array('VALUE' => $new_status);
// do some status change actions
$run_script_id = 0;
$run_code = '';
// got online
if ($host['SCRIPT_ID']) {
$run_script_id = $host['SCRIPT_ID'];
} elseif ($host['CODE']) {
$run_code = $host['CODE'];
}
if ($run_script_id) {
//run script
runScript($run_script_id, $params);
} elseif ($run_code) {
//run code
try {
$code = $run_code;
$success = eval($code);
if ($success === false) {
DebMes("Error in webvar code: " . $code);
registerError('webvars', "Error in webvar code: " . $code);
}
} catch (Exception $e) {
DebMes('Error: exception ' . get_class($e) . ', ' . $e->getMessage() . '.');
registerError('webvars', get_class($e) . ', ' . $e->getMessage());
}
}
}
}
}
/**
* BackEnd
*
* Module backend
*
* @access public
*/
function admin(&$out)
{
global $ajax;
if ($ajax) {
global $op;
global $item_id;
if ($op == 'get_details') {
startMeasure('getDetails');
global $labels;
global $values;
$res = array();
//echo "Debug labels: $labels \nValues: $values\n";
$res['LABELS'] = array();
$labels = explode(',', $labels);
$total = count($labels);
$seen = array();
for ($i = 0; $i < $total; $i++) {
$item_id = trim($labels[$i]);
if (!$item_id || $seen[$item_id]) {
continue;
}
$seen[$item_id] = 1;
$item = SQLSelectOne("SELECT * FROM commands WHERE ID='" . (int) $item_id . "'");
if ($item['ID']) {
if ($item['TYPE'] == 'custom') {
$item['DATA'] = processTitle($item['DATA'], $this);
$data = $item['DATA'];
} else {
$item['TITLE'] = processTitle($item['TITLE'], $this);
$data = $item['TITLE'];
}
if ($item['RENDER_DATA'] != $item['DATA'] || $item['RENDER_TITLE'] != $item['TITLE']) {
$tmp = SQLSelectOne("SELECT * FROM commands WHERE ID='" . $item['ID'] . "'");
$tmp['RENDER_TITLE'] = $item['TITLE'];
$tmp['RENDER_DATA'] = $item['DATA'];
$tmp['RENDER_UPDATED'] = date('Y-m-d H:i:s');
SQLUpdate('commands', $tmp);
}
if (preg_match('/#[\\w\\d]{6}/is', $data, $m)) {
$color = $m[0];
$data = trim(str_replace($m[0], '<style>#item' . $item['ID'] . ' .ui-btn-active {background-color:' . $color . ';border-color:' . $color . '}</style>', $data));
}
$res['LABELS'][] = array('ID' => $item['ID'], 'DATA' => $data);
}
}
$res['VALUES'] = array();
$values = explode(',', $values);
$total = count($values);
$seen = array();
for ($i = 0; $i < $total; $i++) {
$item_id = trim($values[$i]);
if (!$item_id || $seen[$item_id]) {
continue;
}
$seen[$item_id] = 1;
$item = SQLSelectOne("SELECT * FROM commands WHERE ID='" . (int) $item_id . "'");
if ($item['ID']) {
$data = $item['CUR_VALUE'];
$res['VALUES'][] = array('ID' => $item['ID'], 'DATA' => $data);
}
}
$res['LATEST_REQUEST'] = time();
echo json_encode($res);
endMeasure('getDetails');
exit;
}
if ($op == 'get_label') {
startMeasure('getLabel');
$item = SQLSelectOne("SELECT * FROM commands WHERE ID='" . (int) $item_id . "'");
startMeasure('getLabel ' . $item['TITLE'], 1);
if ($item['ID']) {
$res = array();
if ($item['TYPE'] == 'custom') {
$item['DATA'] = processTitle($item['DATA'], $this);
$res['DATA'] = $item['DATA'];
} else {
$item['TITLE'] = processTitle($item['TITLE'], $this);
$res['DATA'] = $item['TITLE'];
}
if ($item['RENDER_DATA'] != $item['DATA'] || $item['RENDER_TITLE'] != $item['TITLE']) {
$tmp = SQLSelectOne("SELECT * FROM commands WHERE ID='" . $item['ID'] . "'");
$tmp['RENDER_TITLE'] = $item['TITLE'];
$tmp['RENDER_DATA'] = $item['DATA'];
$tmp['RENDER_UPDATED'] = date('Y-m-d H:i:s');
SQLUpdate('commands', $tmp);
}
echo json_encode($res);
}
endMeasure('getLabel ' . $item['TITLE'], 1);
endMeasure('getLabel', 1);
exit;
}
if ($op == 'get_value') {
startMeasure('getValue');
$item = SQLSelectOne("SELECT * FROM commands WHERE ID='" . (int) $item_id . "'");
if ($item['ID']) {
$res = array();
$res['DATA'] = $item['CUR_VALUE'];
echo json_encode($res);
}
endMeasure('getValue', 1);
exit;
}
if ($op == 'value_changed') {
global $new_value;
$item = SQLSelectOne("SELECT * FROM commands WHERE ID='" . (int) $item_id . "'");
if ($item['ID']) {
$old_value = $item['CUR_VALUE'];
$item['CUR_VALUE'] = $new_value;
SQLUpdate('commands', $item);
if ($item['LINKED_PROPERTY'] != '') {
//$old_value=gg($item['LINKED_OBJECT'].'.'.$item['LINKED_PROPERTY']);
sg($item['LINKED_OBJECT'] . '.' . $item['LINKED_PROPERTY'], $item['CUR_VALUE'], array($this->name => 'ID!=' . $item['ID']));
}
$params = array('VALUE' => $item['CUR_VALUE'], 'OLD_VALUE' => $old_value);
if ($item['ONCHANGE_METHOD'] != '') {
if (!$item['LINKED_OBJECT']) {
$item['LINKED_OBJECT'] = $item['ONCHANGE_OBJECT'];
}
getObject($item['LINKED_OBJECT'])->callMethod($item['ONCHANGE_METHOD'], $params);
//ONCHANGE_OBJECT
//DebMes("calling method ".$item['ONCHANGE_OBJECT'].".".$item['ONCHANGE_METHOD']." with ".$item['CUR_VALUE']);
}
if ($item['SCRIPT_ID']) {
//DebMes('Running on_change script #'.$item['SCRIPT_ID']);
runScript($item['SCRIPT_ID'], $params);
}
if ($item['CODE']) {
//DebMes("Running on_change code");
try {
$code = $item['CODE'];
$success = eval($code);
if ($success === false) {
DebMes("Error menu item code: " . $code);
registerError('menu_item', "Error menu item code: " . $code);
}
} catch (Exception $e) {
DebMes('Error: exception ' . get_class($e) . ', ' . $e->getMessage() . '.');
registerError('menu_item', get_class($e) . ', ' . $e->getMessage());
}
}
}
echo "OK";
}
exit;
}
if (isset($this->data_source) && !$_GET['data_source'] && !$_POST['data_source']) {
$out['SET_DATASOURCE'] = 1;
}
if ($this->data_source == 'commands' || $this->data_source == '') {
if ($this->view_mode == '' || $this->view_mode == 'search_commands') {
startMeasure('searchCommands');
$this->search_commands($out);
endMeasure('searchCommands', 1);
}
if ($this->view_mode == 'moveup' && $this->id) {
$this->reorder_items($this->id, 'up');
$this->redirect("?");
}
if ($this->view_mode == 'movedown' && $this->id) {
$this->reorder_items($this->id, 'down');
$this->redirect("?");
}
if ($this->view_mode == 'edit_commands') {
$this->edit_commands($out, $this->id);
}
if ($this->view_mode == 'clone_commands') {
$rec = SQLSelectOne("SELECT * FROM commands WHERE ID='" . $this->id . "'");
unset($rec['ID']);
$rec['TITLE'] = $rec['TITLE'] . ' (copy)';
$rec['ID'] = SQLInsert('commands', $rec);
$this->redirect("?id=" . $rec['ID'] . "&view_mode=edit_commands");
}
if ($this->view_mode == 'delete_commands') {
$this->delete_commands($this->id);
$this->redirect("?");
}
}
}
</head>
<body>
<fieldset>
<legend>Student Report</legend>
<center>
<form action='#' method='post'>
From-Date: <input type='text' id='inputField1' name='datein' required=true/> 
To-Date: <input type='text' id='inputField2' name='dateout' required=true></input><br><br><input type='submit' name='phase1'>
</form>
<div id='phase1'>
<?php
if(isset($_POST['phase1']))
{
$arr = getObject($oid);
//print_r($arr);
$sidarr = getStudent($arr["obhandle"]);
$rno =$sidarr["srno"];
$datein = $_POST["datein"];
$dateout = $_POST['dateout'];
$Arr = queryMe("SELECT sid from MSTUDENTT where srno like '".strtoupper($rno)."'");
$sid = $Arr['sid'];
$brid = getBranchFromSrno($rno);
$obrid = getBranchFilter();
$result=mysql_query("select * from MSTUDENTT where srno='$rno'");
$rownum=mysql_num_rows($result);
if($rownum<=0)
{
