function Save() { $ocs = new ocs(); $ocs->HARDWARE_ID = $_POST["HARDWARE_ID"]; $ocs->LoadParams(); $ocs->ComputerName = $_POST["computername"]; $ocs->ComputerIP = $_POST["ipaddr"]; $ocs->mac = $_POST["MAC"]; $ocs->UpdateDirect(); }
function softwares_search() { $page = CurrentPageName(); $tpl = new templates(); $cmp = new computers($_GET["uid"]); $ocs = new ocs($cmp->ComputerMacAddress); $ocs->LoadParams(); $q = new mysql(); $search = $_GET["search"]; $search = "*{$search}*"; $search = str_replace("**", "*", $search); $search = str_replace("**", "*", $search); $search = str_replace("*", "%", $search); $group_text = $tpl->_ENGINE_parse_body("{group}"); $sql = "SELECT * FROM softwares WHERE HARDWARE_ID={$ocs->HARDWARE_ID} AND ((PUBLISHER LIKE '{$search}') OR (NAME LIKE '{$search}') OR (COMMENTS LIKE '{$search}')) ORDER BY NAME LIMIT 0,50"; $results = $q->QUERY_SQL($sql, "ocsweb"); if (!$q->ok) { echo "<H2>{$q->mysql_error}</H2><code style='font-size:11px'>{$sql}</code>"; } $html = "<center>\n<table cellspacing='0' cellpadding='0' border='0' class='tableView' style='width:100%'>\n<thead class='thead'>\n\t<tr>\n\t\t<th width=1% nowrap colspan=2>{PUBLISHER}</th>\n\t\t<th width=99%>{software}</th>\n\t\t<th width=1% align='center'>{version}</th>\n\t</tr>\n</thead>\n<tbody class='tbody'>"; while ($ligne = mysql_fetch_array($results, MYSQL_ASSOC)) { if (trim($ligne["PUBLISHER"]) == null) { $ligne["PUBLISHER"] = " "; } if ($classtr == "oddRow") { $classtr = null; } else { $classtr = "oddRow"; } $color = "black"; $html = $html . "\n\t\t<tr class={$classtr}>\n\t\t\t<td width=1%><img src='img/software-task-32.png'></td>\n\t\t\t<td style='font-size:14px;font-weight:normal;color:{$color}' nowrap>{$ligne["PUBLISHER"]}</td>\n\t\t\t<td style='font-size:14px;font-weight:normal;color:{$color}'>{$ligne["NAME"]}<div style='font-size:10px'><i>{$ligne["COMMENTS"]}</i></td>\n\t\t\t<td style='font-size:14px;font-weight:normal;color:{$color}' align='center'>{$ligne["VERSION"]}</td>\n\t\t</tr>\n\t\t"; } $html = $html . "</table>\n\t</center>\n\t"; echo $tpl->_ENGINE_parse_body($html); }