public function edit() { if (getId() == '') { Router::redirect('/'); } if ($_POST) { if (!isset($_POST['back'])) { $id = isset($_POST['id']) ? (int) $_POST['id'] : null; $res_post = $_POST; $result = $this->model->save($res_post, $id); if ($result) { Session::setFlash(__('page_was_saved', 'Page was saved')); } else { Session::setFlash(__('page_was_not_saved', 'Page was not saved')); } } Router::redirect('/pages/profileview/' . getId()); } if (isset($this->params[0])) { $this->data['pages'] = $this->model->getById($this->params[0]); } else { Session::setFlash(__('Wrong_page_id', 'Wrong page id')); Router::redirect('/pages/'); } }
function delete() { $id = getId(); if ($_SERVER['REQUEST_METHOD'] == 'POST') { mysql_query("DELETE FROM list WHERE id='{$id}'") or mysql_error(); } }
public function convertStr($stringFrom) { if (preg_match("/[а-яА-Я]+/u", $stringFrom)) { $name = explode('.', $stringFrom); return getId() . '-' . time() . '.' . $name[1]; } return $stringFrom; }
public function funcTest() { function getId($self) { return $self->getPrivateId(); } return getId($this); }
function BxWallPage($sOwner, &$oWall) { $this->_sOwner = $sOwner; $this->_oWall =& $oWall; $this->oProfileGen = new BxBaseProfileGenerator(getId($sOwner, 0)); $this->aConfSite = $GLOBALS['site']; $this->aConfDir = $GLOBALS['dir']; parent::BxDolPageView('wall'); }
public function getIdByNameArr($_arrName) { $retArr = []; foreach ($_arrName as $item) { $id = getId($item); array_push($retArr, $id); } return $retArr; }
public function admin_back() { if (getId() == null) { Router::redirect('/'); } if ($_POST['back']) { Router::redirect('/admin/contacts/'); } }
function __construct($sOwner, &$oWall) { $this->_sOwner = $sOwner; $this->_oWall =& $oWall; $this->oProfileGen = new BxBaseProfileGenerator(getId($sOwner, 0)); $this->aConfSite = $GLOBALS['site']; $this->aConfDir = $GLOBALS['dir']; parent::__construct('wall'); }
public function getRecentProducts() { // call model to fetch data $arr_products = array(); $products = Mage::getModel("orderedproducts/orderedproducts")->getOrderedProducts(); foreach ($products as $product) { $arr_products[] = array('id' => $product - > getId(), 'name' => $product->getName(), 'url' => $product->getProductUrl()); } return $arr_products; }
function getRecord($id, $useUuid = false) { $therecord = parent::getRecord($id, $useUuid); /** * If type is credit, get the receipt id * else get the invoice id */ if ($therecord["type"] == "credit") { $therecord["editrelatedid"] = getId($this->db, "tbld:43678406-be25-909b-c715-7e2afc7db601", $therecord["relatedid"]); } else { $therecord["editrelatedid"] = getId($this->db, "tbld:62fe599d-c18f-3674-9e54-b62c2d6b1883", $therecord["relatedid"]); } return $therecord; }
public function __construct($rows, $cols = null, $opts = array()) { // Make sure rows are all arrays foreach ($rows as $k => $row) { if (!is_array($row)) { $rows[$k] = (array) $rows[$k]; } } if (!isset($cols)) { $cols = array(); if (count($rows) > 0) { $row = $rows[0]; foreach ($row as $k => $v) { if ($k === '__meta__') { continue; } $cols[] = array('label' => $k, 'name' => $k); } } } $flds = array('table', 'cssClass', 'canEdit', 'canAdd', 'canDelete', 'rowActions', 'newParams', 'params', 'addButtonLabel'); foreach ($flds as $fld) { if (isset($opts[$fld])) { $this->{$fld} = $opts[$fld]; } } $this->cssClass .= ' xf-portlet'; $decorateRow = null; if (isset($opts['decorateRow']) and is_callable($opts['decorateRow'])) { $decorateRow = $opts['decorateRow']; } foreach ($rows as $k => $row) { if (!isset($rows[$k]['__meta__'])) { $rows[$k]['__meta__'] = array(); } $dfRec = new \Dataface_Record($this->table, array()); if (!@$rows[$k]['__meta__']['recordId']) { $dfRec->setValues($row); $rows[$k]['__meta__']['recordId'] = $dfRec - getId(); } $rows[$k]['__meta__']['record'] = $dfRec; if (isset($decorateRow)) { $decorateRow($rows[$k]); } } $this->cols = $cols; $this->rows = $rows; $this->opts = $opts; }
function display_posts($name) { include 'html/showposts.php'; $conn = connect(); $id = getId($name); mysql_select_db("unihub", $conn); $query = "SELECT * FROM posts WHERE `id` = '{$id}'"; $result = mysql_query($query, $conn) or die(mysql_error()); if (mysql_num_rows($result) > 0) { // output data of each row while ($row = mysql_fetch_array($result)) { show_posts($row['title'], $row['thumb-desc'], $row['published'], $row['avatar'], $row['feature'], $row['main-desc'], $row['likes'], $row['comments']); } } }
function CreateOperator($_loginId, $_fullName, $_email, $_permissions, $_webspace, $_passwordMD5, $_administrator, $_groups, $_language) { $operator = new Operator(getId(USER_ID_LENGTH), $_loginId); $operator->Load(); $operator->Fullname = $_fullName; $operator->Email = $_email; $operator->PermissionSet = $_permissions; $operator->Webspace = $_webspace; $operator->Password = $_passwordMD5; $operator->Level = $_administrator ? 1 : 0; $operator->Groups = $_groups; $operator->Language = $_language; $operator->Save(true); return $operator; }
} if (!$sMessageBody) { $sErrorMessage = '_Mailbox description empty'; } if (!$vRecipientID) { $sErrorMessage = '_Mailbox recipient empty'; } $sOutputHtml = !$sErrorMessage ? $oMailBox->sendMessage($sMessageSubject, $sMessageBody, $vRecipientID, $aComposeSettings) : _t_err($sErrorMessage); break; case 'auto_complete': if ($sAutoCompleteQ) { $sOutputHtml = $oMailBox->getAutoCompleteList($sAutoCompleteQ); } break; case 'get_thumbnail': $iRecipientID = getId($vRecipientID); if ($iRecipientID) { $sOutputHtml = get_member_thumbnail($iRecipientID, 'none'); } break; } // try to define the callback function name ; if (isset($_GET['callback_function']) and in_array($_GET['callback_function'], $aCallbackFunctions)) { if (method_exists($oMailBox, $_GET['callback_function'])) { $sOutputHtml = $oMailBox->{$_GET['callback_function']}(); } } header('Content-Type: text/html; charset=utf-8'); echo $sOutputHtml; exit; }
function selectCommenti($scout_idscout) { $database = connect(); $res = $database->select("commenti", ['[>]utenti' => ['idutenti' => 'id']], ['commenti.id', 'commenti.idutenti', 'utenti.utente(username)', 'utenti.photo', 'commenti.data', 'commenti.titolo', 'commenti.testo'], ['commenti.scout_idscout[=]' => $scout_idscout]); $id = getId(); foreach ($res as &$r) { if ($r['idutenti'] == $id) { $r['owner'] = True; } else { $r['owner'] = False; } } return $res; }
function strip_dir($dir, $fn) { global $conf; return end(explode($dir . '/', $fn, 2)); } switch ($argv[1]) { case 'cleanID': echo cleanID($argv[2]); break; case 'wikiFN': if ($argc > 3 && $argv[3]) { echo strip_dir($conf['olddir'], wikiFN($argv[2], $argv[3])); } else { echo strip_dir($conf['datadir'], wikiFN($argv[2])); } break; case 'mediaFN': echo strip_dir($conf['mediadir'], mediaFN($argv[2])); break; case 'metaFN': echo strip_dir($conf['metadir'], metaFN($argv[2], $argv[3])); break; case 'getNS': echo getNS($argv[2]); break; case 'getId': echo getId(); break; default: die("Unknown knob: {$argv[1]}"); }
function getSessionId() { global $CONFIG; if (!isnull(getCookieValue("userid"))) { $session = getCookieValue("userid"); } else { setCookieValue("userid", $session = getId(USER_ID_LENGTH)); } return $session; }
function ProcessPosts() { global $USER; $pc = 0; if (!empty($USER->Browsers[0]->QueuedPosts)) { if (!$USER->Browsers[0]->Waiting) { while (!empty($_GET["mi" . $pc])) { $pc++; } foreach ($USER->Browsers[0]->QueuedPosts as $id => $postar) { $_GET["mp" . $pc] = $postar[0]; $_GET["mrid" . $pc] = $_GET["mi" . $pc] = Encoding::Base64UrlEncode($id); $_GET["mc" . $pc++] = Encoding::Base64UrlEncode($postar[1]); DBManager::Execute(true, "DELETE FROM `" . DB_PREFIX . DATABASE_POSTS . "` WHERE `id`='" . DBManager::RealEscape($id) . "' LIMIT 1;"); } $pc = 0; $USER->Browsers[0]->QueuedPosts = array(); } } $this->OverlayHTML = ""; if (!empty($_GET["mi" . $pc]) || $USER->Browsers[0]->Waiting || !empty($USER->Browsers[0]->InitChatWith) || !empty($USER->Browsers[0]->Forward) && !$USER->Browsers[0]->Forward->Received && $USER->Browsers[0]->Forward->Processed) { if ($USER->Browsers[0]->Waiting && $this->Botmode && !empty($USER->Browsers[0]->QueuedPosts)) { $USER->Browsers[0]->QueuedPosts = array(); } else { if (!Visitor::$OpenChatExternal) { $this->Init(); } } if (!empty($USER->Browsers[0]->Forward) && !$USER->Browsers[0]->Forward->Received && $USER->Browsers[0]->Forward->Processed) { $USER->Browsers[0]->Forward->Save(true, true); Visitor::$IsActiveOverlayChat = !$USER->Browsers[0]->Declined; } } if (!empty($USER->Browsers[0]->ChatId)) { $USER->AddFunctionCall("lz_chat_id='" . $USER->Browsers[0]->ChatId . "';", false); } $USER->Browsers[0]->VisitId = $USER->VisitId; while (!empty($_GET["mi" . $pc])) { $id = Communication::ReadParameter("mrid" . $pc, md5($USER->Browsers[0]->SystemId . $USER->Browsers[0]->ChatId . $_GET["mi" . $pc])); $senderName = !empty($USER->Browsers[0]->UserData->Fullname) ? $USER->Browsers[0]->UserData->Fullname : LocalizationManager::$TranslationStrings["client_guest"] . " " . Visitor::GetNoName($USER->UserId . Communication::GetIP()); $post = new Post($id, $USER->Browsers[0]->SystemId, "", Encoding::Base64UrlDecode($_GET["mp" . $pc]), Communication::ReadParameter("mc" . $pc, time()), $USER->Browsers[0]->ChatId, $senderName); $post->BrowserId = VisitorMonitoring::$Browser->BrowserId; if (!empty($_GET["mpti" . $pc])) { $post->Translation = Encoding::Base64UrlDecode($_GET["mpt" . $pc]); $post->TranslationISO = Encoding::Base64UrlDecode($_GET["mpti" . $pc]); } $saved = false; if (!$USER->Browsers[0]->Waiting) { foreach (Server::$Groups as $groupid => $group) { if ($group->IsDynamic && $USER->Browsers[0]->Status == CHAT_STATUS_ACTIVE && isset($group->Members[$USER->Browsers[0]->SystemId])) { foreach ($group->Members as $member => $persistent) { if ($member != $USER->Browsers[0]->SystemId) { if (!empty(Server::$Operators[$member])) { processPost($id, $post, $member, $pc, $groupid, $USER->Browsers[0]->ChatId); } else { processPost($id, $post, $member, $pc, $groupid, CacheManager::GetValueBySystemId($member, "chat_id", "")); } $saved = true; } } $pGroup = $group; } } foreach ($USER->Browsers[0]->Members as $systemid => $member) { if (!empty($member->Declined)) { continue; } if (!empty(Server::$Operators[$systemid]) && !empty($pGroup) && isset($pGroup->Members[$systemid])) { continue; } if (!(!empty($pGroup) && !empty(Server::$Operators[$systemid]))) { $saved = processPost($id, $post, $systemid, $pc, $USER->Browsers[0]->SystemId, $USER->Browsers[0]->ChatId, Server::$Operators[$systemid]->IsBot); } } if (!empty($USER->Browsers[0]->OperatorId) && (Server::$Operators[$USER->Browsers[0]->OperatorId]->IsBot || $USER->Browsers[0]->Status == CHAT_STATUS_ACTIVE)) { $rpost = new Post($id = getId(32), Server::$Operators[$USER->Browsers[0]->OperatorId]->SystemId, $USER->Browsers[0]->SystemId, $answer = Server::$Operators[$USER->Browsers[0]->OperatorId]->GetAutoReplies($post->Text . " " . $post->Translation, $USER->Browsers[0]), time(), $USER->Browsers[0]->ChatId, Server::$Operators[$USER->Browsers[0]->OperatorId]->Fullname); if (!empty($answer)) { if (Server::$Operators[$USER->Browsers[0]->OperatorId]->IsBot) { sleep(1); $USER->AddFunctionCall("lz_chat_input_bot_state(true,false);", false); } $rpost->ReceiverOriginal = $rpost->ReceiverGroup = $USER->Browsers[0]->SystemId; $rpost->Save(); $saved = true; foreach ($USER->Browsers[0]->Members as $opsysid => $member) { if ($opsysid != Server::$Operators[$USER->Browsers[0]->OperatorId]->SystemId || !Server::$Operators[$USER->Browsers[0]->OperatorId]->IsBot) { $rpost = new Post($id, Server::$Operators[$USER->Browsers[0]->OperatorId]->SystemId, $opsysid, $answer, time(), $USER->Browsers[0]->ChatId, Server::$Operators[$opsysid]->Fullname); $rpost->ReceiverOriginal = $rpost->ReceiverGroup = $USER->Browsers[0]->SystemId; $rpost->Save(); } } } } if ($saved) { $USER->AddFunctionCall("lz_chat_release_post('" . Encoding::Base64UrlDecode($_GET["mi" . $pc]) . "');", false); } } else { processPost($id, $post, "", $pc, $USER->Browsers[0]->SystemId, $USER->Browsers[0]->ChatId, false); $USER->Browsers[0]->QueuedPosts[$id] = array(0 => $_GET["mp" . $pc], 1 => time(), 2 => VisitorMonitoring::$Browser->BrowserId); $USER->AddFunctionCall("lz_chat_release_post('" . Encoding::Base64UrlDecode($_GET["mi" . $pc]) . "');", false); } $pc++; } if (!empty($USER->Browsers[0]->OperatorId) && empty($pc) && !Server::$Operators[$USER->Browsers[0]->OperatorId]->IsBot) { $autoReply = Server::$Operators[$USER->Browsers[0]->OperatorId]->GetAutoReplies("", $USER->Browsers[0]); if (!empty($autoReply)) { ChatAutoReply::SendAutoReply($autoReply, $USER, $USER->Browsers[0]->OperatorId); } } }
deleteId($id['id'], 'ccities', 'Id_Country', 'i'); deleteId($id['id'], 'countries', 'Id', 'i'); return $response->withJson(array('status' => 1, 'message' => "Country deleted sucsesfully")); } else { return $response->withJson(array('status' => 0, 'message' => "Country ID {$args['id']} does not exists")); } }); /* Delete city by Id */ $app->delete("/city/{id}/", function ($request, $response, $args) use($link) { $id = getId($args['id'], 'cities'); if ($id) { deleteId($id['id'], 'ccities', 'Id_City', 'i'); deleteId($id['id'], 'clanguages', 'Id_City', 'i'); deleteId($id['id'], 'cities', 'Id', 'i'); return $response->withJson(array('status' => 1, 'message' => "City deleted sucsesfully")); } else { return $response->withJson(array('status' => 0, 'message' => "City ID {$args['id']} does not exists")); } }); /* Delete language by Id */ $app->delete("/city/{idCity}/language/{id}/", function ($request, $response, $args) use($link) { $id = getId($args['id'], 'languages'); $idCity = getId($args['idCity'], 'cities'); if ($id && $idCity) { deleteId($id['id'], 'clanguages', 'Id_Language', 'ii', 'Id_City', $idCity['id']); return $response->withJson(array('status' => 1, 'message' => "Language deleted sucsesfully")); } else { return $response->withJson(array('status' => 0, 'message' => "Language ID {$args['id']} does not exists")); } }); $app->run();
if (empty($lang["btn_unsubscribe"])) { if (actionOK("subscribe")) { //check if action is disabled $_vector_tabs_right["ca-watch"]["href"] = wl(cleanID(getId()), array("do" => "subscribe"), false, "&"); $_vector_tabs_right["ca-watch"]["text"] = $lang["btn_subscribe"]; //language comes from DokuWiki core } //2009-12-25 "Lemming" and older ones. See the following for information: //<http://www.freelists.org/post/dokuwiki/Question-about-tpl-buttonsubscribe> } else { if (empty($INFO["subscribed"]) && actionOK("subscribe")) { //check if action is disabled $_vector_tabs_right["ca-watch"]["href"] = wl(cleanID(getId()), array("do" => "subscribe"), false, "&"); $_vector_tabs_right["ca-watch"]["text"] = $lang["btn_subscribe"]; //language comes from DokuWiki core } elseif (actionOK("unsubscribe")) { //check if action is disabled $_vector_tabs_right["ca-watch"]["href"] = wl(cleanID(getId()), array("do" => "unsubscribe"), false, "&"); $_vector_tabs_right["ca-watch"]["text"] = $lang["btn_unsubscribe"]; //language comes from DokuWiki core } } } } /****************************************************************************** ******************************** ATTENTION ********************************* DO NOT MODIFY THIS FILE, IT WILL NOT BE PRESERVED ON UPDATES! ****************************************************************************** If you want to add some own tabs, have a look at the README of this template and "/user/tabs.php". You have been warned! *****************************************************************************/
tpl_pagetitle(); ?> ]] ([[<?php echo hsc(getID() . "?rev=" . $rev); ?> |<?php echo hsc($lang["monobook_cite_thisversion"]); ?> ]])</dd> </dl> <dl> <dt><?php echo hsc($lang["monobook_cite_result"]); ?> </dt> <dd><a rel="nofollow" class="wikilink1" href="<?php echo hsc(wl(cleanID(getId()))); ?> "><?php tpl_pagetitle(); ?> </a> (<a rel="nofollow" class="wikilink1" href="<?php echo hsc($permurl); ?> "><?php echo hsc($lang["monobook_cite_thisversion"]); ?> </a>)</dd> </dl> </div>
function up_5402_6000($_prefix, $_link, $_engine) { $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "resources` ADD `languages` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',ADD `kb_public` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',ADD `kb_bot` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',ADD `kb_ft_search` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',ADD INDEX ( `languages` , `kb_public` ) "); $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "resources` ADD `shortcut_word` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';"); $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` ADD `data_id` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' AFTER `visit_id`;"); $commands[] = array(1054, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "data_updates` CHANGE `update_ratings` `update_feedbacks` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0';"); $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "administration_log` ADD `trace` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL AFTER `value`;"); $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "events` ADD `exclude_mobile` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';"); $commands[] = array(1060, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "events` ADD `exclude_countries` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';"); $commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "user_data` (`id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',`create` int(10) unsigned NOT NULL DEFAULT '0',`h_fullname` varchar(254) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',`h_email` varchar(254) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',`h_company` varchar(254) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',`h_phone` varchar(254) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',`h_customs` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,`h_text` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,PRIMARY KEY (`id`)) ENGINE=" . $_engine . " DEFAULT CHARSET=utf8 COLLATE=utf8_bin;"); $commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "feedbacks` (`id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`created` int(10) unsigned NOT NULL DEFAULT '0',`chat_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`ticket_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`resource_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`user_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`data_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`ip_hash` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',PRIMARY KEY (`id`)) ENGINE=" . $_engine . " DEFAULT CHARSET=utf8 COLLATE=utf8_bin;"); $commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "feedback_criteria` (`fid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`cid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`value` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',PRIMARY KEY (`fid`,`cid`)) ENGINE=" . $_engine . " DEFAULT CHARSET=utf8 COLLATE=utf8_bin;"); $commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "feedback_criteria_config` (`id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`type` tinyint(1) unsigned NOT NULL DEFAULT '0',`name` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`title` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',PRIMARY KEY (`id`)) ENGINE=" . $_engine . " DEFAULT CHARSET=utf8 COLLATE=utf8_bin;"); $commands[] = array(1050, "CREATE TABLE IF NOT EXISTS `" . DBManager::RealEscape($_prefix) . "stats_aggs_feedbacks` (`year` smallint(5) unsigned NOT NULL DEFAULT '0',`month` tinyint(3) unsigned NOT NULL DEFAULT '0',`day` tinyint(3) unsigned NOT NULL DEFAULT '0',`operator_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`group_id` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',`amount` int(10) unsigned NOT NULL DEFAULT '0',`ca` double unsigned NOT NULL DEFAULT '0',`cb` double unsigned NOT NULL DEFAULT '0',`cc` double unsigned NOT NULL DEFAULT '0',`cd` double unsigned NOT NULL DEFAULT '0',PRIMARY KEY (`year`,`month`,`day`,`operator_id`,`group_id`)) ENGINE=" . $_engine . " DEFAULT CHARSET=utf8 COLLATE=utf8_bin;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "resources` DROP `rank`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `fullname`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `email`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `company`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `phone`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `customs`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_chats` DROP `question`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` DROP `fullname`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` DROP `email`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` DROP `company`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` DROP `phone`;"); $commands[] = array(1091, "ALTER TABLE `" . DBManager::RealEscape($_prefix) . "visitor_browsers` DROP `customs`;"); $res = processCommandList($commands, $_link); // import ratings $_link->Query(true, "INSERT INTO `" . DBManager::RealEscape($_prefix) . "feedback_criteria_config` (`id`, `type`, `name`, `title`) VALUES ('d0', 0, 'Knowledge', '<!--lang_client_feedback_knowledge-->'),('d1', 0, 'Friendlyness', '<!--lang_client_feedback_friendliness-->'),('d2', 0, 'Responsivenness', '<!--lang_client_feedback_responsiveness-->'),('d3', 0, 'Overall', '<!--lang_client_feedback_overall-->'),('d4', 1, 'Comment', '<!--lang_client_feedback_comment-->');"); $sttime = time(); $max_fb_time = null; if ($result = $_link->Query(true, "SELECT * FROM `" . DB_PREFIX . "ratings` ORDER BY `time` DESC;")) { while ($sttime > time() - 15 && ($row = DBManager::FetchArray($result))) { $userData = new UserData($row["fullname"], $row["email"], $row["company"], ""); $hash = $userData->Hash(); $_link->Query(true, "INSERT IGNORE INTO `" . DBManager::RealEscape($_prefix) . "user_data` (`id`,`create`,`h_fullname`,`h_email`,`h_company`,`h_customs`) VALUES ('" . DBManager::RealEscape($hash) . "'," . intval(time()) . ",'" . DBManager::RealEscape($row["fullname"]) . "','" . DBManager::RealEscape($row["email"]) . "','" . DBManager::RealEscape($row["company"]) . "','');"); $_link->Query(true, "INSERT INTO `" . DBManager::RealEscape($_prefix) . "feedbacks` (`id`, `created`, `chat_id`, `user_id`, `operator_id`, `data_id`, `ip_hash`) VALUES ('" . DBManager::RealEscape($id = getId(32)) . "', " . intval($row["time"]) . ", '" . DBManager::RealEscape($row["chat_id"]) . "', '" . DBManager::RealEscape($row["user_id"]) . "', '" . DBManager::RealEscape($row["internal_id"]) . "','" . DBManager::RealEscape($hash) . "','" . DBManager::RealEscape(md5($row["ip"])) . "');"); $_link->Query(true, "INSERT INTO `" . DBManager::RealEscape($_prefix) . "feedback_criteria` (`fid`, `cid`, `value`) VALUES ('" . DBManager::RealEscape($id) . "', 'd0', '" . DBManager::RealEscape($row["qualification"]) . "');"); $_link->Query(true, "INSERT INTO `" . DBManager::RealEscape($_prefix) . "feedback_criteria` (`fid`, `cid`, `value`) VALUES ('" . DBManager::RealEscape($id) . "', 'd1', '" . DBManager::RealEscape($row["politeness"]) . "');"); if ($max_fb_time == null) { $max_fb_time = $row["time"]; } } } if ($max_fb_time == null) { $max_fb_time = time(); } CacheManager::WriteDataUpdateTime(DATA_UPDATE_KEY_FEEDBACKS, false, $_link, $_prefix, intval($max_fb_time) * 1000); CacheManager::WriteDataUpdateTime(DATA_UPDATE_KEY_FILTERS, false, $_link, $_prefix, intval(time()) * 1000); return $res; }
/** * Function will send the compose message ; * * @param : $sMessageSubject (string) - message's subject ; * @param : $sMessageBody (string) - message's body ; * @param : $vRecipientID (variant)- message's recipient ID or NickName; * @param : $aComposeSettings (array) - contain all needed settings for compose message ; * [ send_copy ] (bolean) - allow to send message to phisical recipient's email ; * [ notification ] (boolean) - allow to send notification to the recipient's email ; * [ send_copy_to_me ] (boolean) - allow to send message to phisical sender's email ; * @return : signaling information with Html ; */ function sendMessage($sMessageSubject, $sMessageBody, $vRecipientID, &$aComposeSettings, $isSimulateSending = false) { $sMessageSubject = process_db_input($sMessageSubject, BX_TAGS_STRIP); $sMessageSubjectCopy = $GLOBALS['MySQL']->unescape($sMessageSubject); $sMessageBody = process_db_input($sMessageBody, BX_TAGS_VALIDATE); $sCopyMessage = $GLOBALS['MySQL']->unescape($sMessageBody); if (!$isSimulateSending && (!$sMessageSubject || !$sMessageBody)) { $this->iSendMessageStatusCode = BX_MAILBOX_SEND_FAILED; return MsgBox(_t('_please_fill_next_fields_first')); } // init some needed variables ; $sReturnMessage = null; $sComposeUrl = BX_DOL_URL_ROOT . 'mail.php?mode=compose'; // try to define member's ID ; $iRecipientID = (int) getId($vRecipientID); if (!$iRecipientID) { $this->iSendMessageStatusCode = BX_MAILBOX_SEND_UNKNOWN_RECIPIENT; return MsgBox(_t('_Profile not found')); } $aRecipientInfo = getProfileInfo($iRecipientID); $oEmailTemplate = new BxDolEmailTemplates(); $bAllowToSend = true; $this->iSendMessageStatusCode = BX_MAILBOX_SEND_FAILED; // ** check permission for recipient member ; // Check if member is blocked ; $sQuery = "\n SELECT\n `ID`, `Profile`\n FROM\n `sys_block_list`\n WHERE\n `Profile` = {$this->aMailBoxSettings['member_id']}\n AND\n `ID` = '{$iRecipientID}'\n "; if (!isAdmin($this->aMailBoxSettings['member_id']) && db_arr($sQuery)) { $sReturnMessage = MsgBox(_t('_FAILED_TO_SEND_MESSAGE_BLOCK')); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_BLOCKED; $bAllowToSend = false; } // antispam check ; $sQuery = "\n SELECT\n `ID`\n FROM\n `sys_messages`\n WHERE\n `Sender` = {$this->aMailBoxSettings['member_id']}\n AND\n date_add(`Date`, INTERVAL {$this->iWaitMinutes} MINUTE) > Now()\n "; if (db_arr($sQuery)) { $sReturnMessage = MsgBox(_t('_You have to wait for PERIOD minutes before you can write another message!', $this->iWaitMinutes, $sComposeUrl)); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_WAIT; $bAllowToSend = false; } // additional antispam check ; if (bx_is_spam($sCopyMessage)) { $sReturnMessage = MsgBox(sprintf(_t("_sys_spam_detected"), BX_DOL_URL_ROOT . 'contact.php')); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_FAILED; $bAllowToSend = false; } // check if member not active ; if ($aRecipientInfo['Status'] != 'Active') { $sReturnMessage = MsgBox(_t('_FAILED_TO_SEND_MESSAGE_NOT_ACTIVE', $sComposeUrl)); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_RECIPIENT_NOT_ACTIVE; $bAllowToSend = false; } // chek membership level; if (!$this->isSendMessageAlowed($this->aMailBoxSettings['member_id'], $isSimulateSending ? false : true)) { $sReturnMessage = MsgBox(_t('_FAILED_TO_SEND_MESSAGE_MEMBERSHIP_DISALLOW')); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_FAILED_MEMBERSHIP_DISALLOW; $bAllowToSend = false; } // ** allow to send message ; if (!$isSimulateSending && $bAllowToSend) { $sQuery = "\n INSERT INTO\n `sys_messages`\n SET\n `Sender` = {$this->aMailBoxSettings['member_id']},\n `Recipient` = {$iRecipientID},\n `Subject` = '{$sMessageSubject}',\n `Text` = '{$sMessageBody}',\n `Date` = NOW(),\n `New` = '1',\n `Type` = 'letter'\n "; if (db_res($sQuery)) { $sReturnMessage = MsgBox(_t('_MESSAGE_SENT', $sComposeUrl, getProfileLink($iRecipientID), $aRecipientInfo['NickName'])); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_SUCCESS; //--- create system event bx_import('BxDolAlerts'); $aAlertData = array('msg_id' => db_last_id(), 'subject' => $sMessageSubjectCopy, 'body' => $sCopyMessage, 'send_copy' => $aComposeSettings['send_copy'], 'notification' => $aComposeSettings['notification'], 'send_copy_to_me' => $aComposeSettings['send_copy_to_me']); $oZ = new BxDolAlerts('profile', 'send_mail_internal', $this->aMailBoxSettings['member_id'], $iRecipientID, $aAlertData); $oZ->alert(); // ** check the additional parameters ; // send message to phisical recipient's email ; if ($aComposeSettings['send_copy']) { $aTemplate = $oEmailTemplate->getTemplate('t_Message', $iRecipientID); $aPlus = array(); $aPlus['MessageText'] = replace_full_uris($sCopyMessage); $aPlus['ProfileReference'] = getNickName($this->aMailBoxSettings['member_id']); $aPlus['ProfileUrl'] = getProfileLink($this->aMailBoxSettings['member_id']); sendMail($aRecipientInfo['Email'], $sMessageSubjectCopy, $aTemplate['Body'], $iRecipientID, $aPlus); } // send notification to the recipient's email ; if ($aComposeSettings['notification']) { $aTemplate = $oEmailTemplate->getTemplate('t_Compose', $iRecipientID); $aPlus['ProfileReference'] = getNickName($this->aMailBoxSettings['member_id']); $aPlus['ProfileUrl'] = getProfileLink($this->aMailBoxSettings['member_id']); sendMail($aRecipientInfo['Email'], $aTemplate['Subject'], $aTemplate['Body'], $iRecipientID, $aPlus); } // allow to send message to phisical sender's email; if ($aComposeSettings['send_copy_to_me']) { $aSenderInfo = getProfileInfo($this->aMailBoxSettings['member_id']); $aTemplate = $oEmailTemplate->getTemplate('t_MessageCopy', $this->aMailBoxSettings['member_id']); $aPlus['your subject here'] = $sMessageSubjectCopy; $aPlus['your message here'] = replace_full_uris($sCopyMessage); sendMail($aSenderInfo['Email'], $aTemplate['Subject'], $aTemplate['Body'], $this->aMailBoxSettings['member_id'], $aPlus); } } else { $sReturnMessage = MsgBox(_t('_FAILED_TO_SEND_MESSAGE')); $this->iSendMessageStatusCode = BX_MAILBOX_SEND_FAILED; } } return $sReturnMessage; }
$finance_head = $_POST['finance_head']; $phone_number = $_POST['phone_number']; $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $account_executive_id = " "; if ($user_type == 'Secretary' || $user_type == 'Finance_head') { $account_executive_id = $_POST['finance_head']; if ($user_type == 'Finance_head') { $user_type = 'account_executive'; } else { $select = "select department from master_address_file as a inner join master_department_file as k\n on a.department_id=k.department_id\n where account_id='" . $account_executive_id . "' and account_type='account_executive' limit 1"; $result = $conn->query($select); $row = $result->fetch_assoc(); $department = $row['department']; } $id = getId('master_address_file', 'account_id'); $add_array = array('account_type', "account_id", 'first_name', 'last_name', 'department_id', 'account_executive_id', 'phone_number', 'date_created'); $value_array = array($user_type, $id, $first_name, $last_name, $department, $account_executive_id, $phone_number, 'now()'); $result = insertMaker('master_address_file', $add_array, $value_array); //$result=insertMaker('master_address_file',array('secretary','secretary_id','account_executive_id'),array($name,$id,$account_executive_id)); } if ($department == 'Choose') { $department = ""; } $result = insertMaker('user_file', array('user_name', 'password', 'first_name', 'last_name', 'user_type', 'department', 'finance_head', 'phone_number'), array($username, 'password123', $first_name, $last_name, $user_type, $department, $finance_head, $phone_number)); echo "<script>alert('Successfully added New User')</script>"; } ?> <form name='form1' id='form1' method=post> <table style='width:300px' class='form_css'> <tr>
function SetDetails($_data, $_self) { global $CONFIG; $this->FirstCall = $_data["last_active"] < time() - (!empty($_data["js"]) ? $CONFIG["timeout_track"] : 7200) && !$this->ExtendSession; $this->VisitId = $_data["visit_id"]; if ($_self && $this->FirstCall) { $this->Visits = $_data["visits"] + 1; $this->VisitId = $_data["visit_id"] = getId(7); $this->VisitsDay = $_data["dcount"] + 1; } else { $this->Visits = $_data["visits"]; $this->VisitsDay = $_data["dcount"]; } $this->VisitLast = $_data["visit_last"]; $this->ExitTime = $_data["last_active"]; $this->IP = $_data["ip"]; $this->SystemInfo = $_data["system"]; $this->Language = $_data["language"]; $this->Resolution = $_data["resolution"]; $this->Host = $_data["host"]; $this->GeoTimezoneOffset = $_data["timezone"]; if (!empty($_data["longitude"])) { $this->GeoLongitude = $_data["longitude"]; $this->GeoLatitude = $_data["latitude"]; } $this->GeoCity = $_data["city"]; $this->GeoCountryISO2 = $_data["country"]; if (isset($_data["countryname"])) { $this->GeoCountryName = $_data["countryname"]; } $this->GeoRegion = $_data["region"]; $this->GeoResultId = $_data["geo_result"]; $this->GeoISP = $_data["isp"]; $this->FirstActive = $_data["entrance"]; $this->Browser = $_data["browser"]; $this->OperatingSystem = $_data["system"]; $this->Javascript = $_data["js"]; }
if (!defined("LIVEZILLA_PATH")) { define("LIVEZILLA_PATH", "./"); } @ini_set('session.use_cookies', '0'); @error_reporting(E_ALL); $html = ""; require LIVEZILLA_PATH . "_definitions/definitions.inc.php"; require LIVEZILLA_PATH . "_lib/functions.global.inc.php"; require LIVEZILLA_PATH . "_definitions/definitions.protocol.inc.php"; require LIVEZILLA_PATH . "_definitions/definitions.dynamic.inc.php"; require LIVEZILLA_PATH . "_lib/functions.external.inc.php"; require LIVEZILLA_PATH . "_lib/objects.external.inc.php"; Server::DefineURL(FILE_CHAT); Server::InitDataProvider(); LocalizationManager::AutoLoad(); $browserId = getId(USER_ID_LENGTH); if (!isset($_GET[GET_EXTERN_TEMPLATE])) { @set_time_limit(Server::$Configuration->File["timeout_chats"]); if (!isset($_GET["file"])) { @set_error_handler("handleError"); } define("SESSION", getSessionId()); if (empty(Server::$Configuration->File["gl_om_pop_up"]) && Server::$Configuration->File["gl_om_mode"] == 1) { Server::InitDataBlock(array("INTERNAL", "GROUPS", "FILTERS")); $groupbuilder = new GroupBuilder(); $groupbuilder->Generate(); if (!$groupbuilder->GroupAvailable) { exit("<html><script language=\"JavaScript\">if(typeof(window.opener != null) != 'undefined')window.opener.location = \"" . Server::$Configuration->File["gl_om_http"] . "\";window.close();</script></html>"); } } else { Server::InitDataBlock(array("FILTERS"));
break; case "FIRMWARE": $info = 2; $channel = 0; break; default: echo "Aufruf {$argv['0']} ADDRESS TEMPERATURE|HUMIDITY\n"; echo "Aufruf {$argv['0']} ADDRESS BOOT|CURRENT|ENERGY_COUNTER|FREQUENCY|POWER|VOLTAGE|RSSI|NAME\n"; exit; } include_once "/var/lib/homegear/scripts/Connect.php"; //$data = $Client->send("listDevices", array()); //print_r($data); $fields = array("FIRMWARE", "ID", "ADDRESS"); $data = $Client->send("listDevices", array(false, $fields)); $id = getId($data, $address); switch ($info) { case 2: foreach ($data as $i) { if ($i['ID'] === $id) { echo $i[$value] . "\n"; exit(0); } } echo "0\n"; exit(1); break; case 1: $deviceInfo = $Client->send("getDeviceInfo", array($id)); echo $deviceInfo[$value] . "\n"; break;
<!DOCTYPE html> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" type="text/css" href="./mystyle.css" /> <title> <?php echoString($lang, "title"); ?> </title> </head> <body> <?php $thesh = getThesh(); $pass = getPass(); $id = getId(); echo "<ul class=\"list_lang\" >"; echo "<li> <a href=\"music_vote.php?lang=GR&thesh={$thesh}&pass={$pass}\"> GR </a> </li>"; echo "<li> <a href=\"music_vote.php?lang=EN&thesh={$thesh}&pass={$pass}\"> EN </a> </li>"; echo "</ul>"; if ($thesh == -1 || $pass == -1 || correctPass($thesh, $pass) == 0) { echo "<ul class=\"list_main\" >"; echo "<li>"; echo getString($lang, "please_connect"); echo "</li>"; echo "</ul>"; echo "<a class=\"button\" href=\"index.php?lang={$lang}\"> " . getString($lang, "connect") . " </a>"; } else { echo "<ul class=\"list_main\" >"; echo "<li>"; $con = mysqli_connect("localhost", "root", getMysqlPass(), "multsyst");
function getSays($model_id = -1) { if ($model_id == -1) { $resultarray = getconf('crawler_contents', ' where history_id = ' . getId() . ' and rc_id = 3'); } else { $resultarray = getconf('crawler_contents', ' where history_id = ' . getId() . ' and rc_id = 3 and mc_id = ' . $model_id); } //$namearray=split(',',$resultarray[0][1]); //print_r($resultarray); return $resultarray; }
static function GetStatArray($_titles = false) { $a = array(); if (!empty(Server::$Configuration->Database["gl_fb"]) && is_array(Server::$Configuration->Database["gl_fb"])) { foreach (Server::$Configuration->Database["gl_fb"] as $id => $criteria) { if (count($a) < FeedbackCriteria::$MaxCriteriaReports && $criteria->Type == 0) { $a[$id] = $_titles ? str_replace("-->", "", str_replace("<!--lang_", "", $criteria->Title)) : 0; } } } if (!$_titles) { while (count($a) < FeedbackCriteria::$MaxCriteriaReports) { $a[getId(5)] = 0; } } return $a; }