PHP mysql_meta::group_count 예제들

예제 #1

파일: artica-meta.menus.php 프로젝트: brucewu16899/1.6.x

function menu_system()
{
    $page = CurrentPageName();
    $tpl = new templates();
    $artica_meta = new mysql_meta();
    $sock = new sockets();
    $ArticaMetaUseSendClient = intval($sock->GET_INFO("ArticaMetaUseSendClient"));
    $gpid = $_GET["gpid"];
    if ($gpid == 0) {
        $hostname = $artica_meta->uuid_to_host($_GET["uuid"]);
        $tag = $artica_meta->uuid_to_tag($_GET["uuid"]);
    } else {
        $hostname = $artica_meta->gpid_to_name($_GET["gpid"]);
        $tag = $artica_meta->group_count($_GET["gpid"]) . " " . $tpl->javascript_parse_text("{computers}");
    }
    if ($ArticaMetaUseSendClient == 1) {
        $tr[] = paragrapheFleche("{send_ping}", "Loadjs('{$page}?send-ping-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{change_hostname}", "Loadjs('{$page}?change-hostname-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{add_tag}", "Loadjs('{$page}?add-tag-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        if (intval($artica_meta->GET_CONFIG("EnableKerbAuth", $_GET["uuid"]))) {
            $tr[] = paragrapheFleche("{activedirectroy_reconnection}", "Loadjs('{$page}?activedirectory-reconnect-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
        }
    }
    if ($gpid > 0) {
        if ($artica_meta->group_is_ad_inside($gpid)) {
            $tr[] = paragrapheFleche("{activedirectroy_reconnection}", "Loadjs('{$page}?activedirectory-reconnect-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
        }
    }
    $tr[] = paragrapheFleche("{reboot}", "Loadjs('{$page}?reboot-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{root_password2}", "Loadjs('{$page}?root-password-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{global_admin_account}", "Loadjs('{$page}?manager-password-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{install_package}", "Loadjs('artica-meta.packages.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{update_artica}", "Loadjs('artica-meta.update.artica.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{directories_monitor}", "Loadjs('{$page}?philesight-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{create_a_snapshot}", "Loadjs('{$page}?snapshot-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{restore_a_snapshot}", "Loadjs('artica-meta.snapshots.browse.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{delete}", "Loadjs('{$page}?delete-js=yes&uuid=" . urlencode($_GET["uuid"]) . "')");
    }
    $html = "<div style='font-size:18px;margin-bottom:20px'>{$hostname} - {$tag} - {$_GET["uuid"]}</div>" . CompileTr3($tr);
    echo $tpl->_ENGINE_parse_body($html);
}

예제 #2

파일: artica-meta.groups.php 프로젝트: BillTheBest/1.6.x

function search()
{
    $MyPage = CurrentPageName();
    $page = CurrentPageName();
    $tpl = new templates();
    $sock = new sockets();
    $q = new mysql_meta();
    $table = "metagroups";
    if (!$q->TABLE_EXISTS($table)) {
        $sql = "CREATE TABLE IF NOT EXISTS `metagroups` (\n\t\t\t\t`ID` INT(10) NOT NULL AUTO_INCREMENT,\n\t\t\t\t`groupname` varchar(90) NOT NULL,\n\t\t\t\t`CountHosts` smallint(3) NOT NULL DEFAULT 0,\n\t\t\t\tPRIMARY KEY (`ID`),\n\t\t\t\tKEY `groupname` (`groupname`),\n\t\t\t\tKEY `CountHosts` (`CountHosts`)\n\t\t\t\t) ENGINE=MYISAM;";
        $q->QUERY_SQL($sql);
        if (!$q->ok) {
            echo json_error_show($q->mysql_error, 1);
        }
    }
    $searchstring = string_to_flexquery();
    $page = 1;
    if (isset($_POST["sortname"])) {
        if ($_POST["sortname"] != null) {
            $ORDER = "ORDER BY `{$_POST["sortname"]}` {$_POST["sortorder"]}";
        }
    }
    if (isset($_POST['page'])) {
        $page = $_POST['page'];
    }
    if ($searchstring != null) {
        $sql = "SELECT COUNT( * ) AS tcount FROM {$table} WHERE 1 {$searchstring}";
        $ligne = mysql_fetch_array($q->QUERY_SQL($sql));
        if (!$q->ok) {
            json_error_show("Mysql Error [" . __LINE__ . "]: <br>{$q->mysql_error}.<br>{$sql}", 1);
        }
        $total = $ligne["tcount"];
    } else {
        $total = $q->COUNT_ROWS($table);
    }
    if (isset($_POST['rp'])) {
        $rp = $_POST['rp'];
    }
    if (!is_numeric($rp)) {
        $rp = 50;
    }
    $pageStart = ($page - 1) * $rp;
    $limitSql = "LIMIT {$pageStart}, {$rp}";
    $sql = "SELECT * FROM {$table} WHERE 1 {$searchstring} {$ORDER} {$limitSql} ";
    $results = $q->QUERY_SQL($sql);
    if (!$q->ok) {
        if ($q->mysql_error != null) {
            json_error_show(date("H:i:s") . "<br>SORT:{$_POST["sortname"]}:<br>Mysql Error [L." . __LINE__ . "]: {$q->mysql_error}<br>{$sql}", 1);
        }
    }
    if (mysql_num_rows($results) == 0) {
        json_error_show("no data", 1);
    }
    $data = array();
    $data['page'] = $page;
    $data['total'] = $total;
    $data['rows'] = array();
    $fontsize = "22";
    $style = " style='font-size:{$fontsize}px'";
    $styleHref = " style='font-size:{$fontsize}px;text-decoration:underline'";
    $free_text = $tpl->javascript_parse_text("{free}");
    $computers = $tpl->javascript_parse_text("{computers}");
    $overloaded_text = $tpl->javascript_parse_text("{overloaded}");
    $orders_text = $tpl->javascript_parse_text("{orders}");
    $directories_monitor = $tpl->javascript_parse_text("{directories_monitor}");
    while ($ligne = mysql_fetch_assoc($results)) {
        $LOGSWHY = array();
        $overloaded = null;
        $loadcolor = "black";
        $StatHourColor = "black";
        $ColorTime = "black";
        $groupname = $ligne["groupname"];
        $icon_warning_32 = "warning32.png";
        $icon_red_32 = "32-red.png";
        $icon = "ok-32.png";
        $urijs = "Loadjs('{$MyPage}?group-js=yes&ID={$ligne["ID"]}')";
        $link = "<a href=\"javascript:blur();\" OnClick=\"javascript:{$urijs}\" {$styleHref}>";
        $orders = imgtootltip("48-settings.png", null, "Loadjs('artica-meta.menus.php?gpid={$ligne["ID"]}');");
        $transparent = imgtootltip("ok-pass-48.png", null, "Loadjs('artica-meta.squidtransparent-white.php?gpid={$ligne["ID"]}');");
        $delete = imgtootltip("delete-32.png", null, "Loadjs('{$MyPage}?delete-group-js={$ligne["ID"]}')");
        $count = $q->group_count($ligne["ID"]);
        $cell = array();
        $cell[] = "<center><img src=\"img/{$icon}\"></center>";
        $cell[] = "<span {$style}>{$link}{$groupname}</a></span>";
        $cell[] = "<center {$style}>{$link}{$count}</a></center>";
        $cell[] = "<center {$style}>{$orders}</a></center>";
        $cell[] = "<center {$style}>{$transparent}</a></center>";
        $cell[] = "<center {$style}>{$delete}</a></center>";
        $data['rows'][] = array('id' => $ligne['uuid'], 'cell' => $cell);
    }
    echo json_encode($data);
}

예제 #3

파일: artica-meta.menus.php 프로젝트: BillTheBest/1.6.x

function menu_system()
{
    $page = CurrentPageName();
    $tpl = new templates();
    $artica_meta = new mysql_meta();
    $sock = new sockets();
    $ArticaMetaUseSendClient = intval($sock->GET_INFO("ArticaMetaUseSendClient"));
    $gpid = $_GET["gpid"];
    $LicenseText = null;
    if ($gpid == 0) {
        $hostname = $artica_meta->uuid_to_host($_GET["uuid"]);
        $ArticaVersion = $artica_meta->ArticaVersion($_GET["uuid"]);
        $tag = $artica_meta->uuid_to_tag($_GET["uuid"]);
        $LicenseInfos = $artica_meta->LicenseInfos($_GET["uuid"]);
        $LicenseJs = "OnClick=\"javascript:Loadjs('artica-meta.host.license.php?uuid={$_GET["uuid"]}')\"";
        $LICT = " Community Edition";
        if ($LicenseInfos["CORP_LICENSE"]) {
            $LICT = " Entreprise Edition";
        }
        if ($LicenseInfos["ExpiresSoon"] > 0) {
            if ($LicenseInfos["ExpiresSoon"] < 31) {
                $LICT = "<span style='color:red'>{trial_mode}</span>";
            }
        }
        $LicenseText = "<div style='text-align:right;margin-top:-30px;margin-bottom:30px'><i><a href=\"javascript:blur();\" {$LicenseJs} style='font-size:14px;text-decoration:underline'>v{$ArticaVersion} - {$LICT} - {company}:{$LicenseInfos["COMPANY"]}</a></i></div>";
    } else {
        $hostname = $artica_meta->gpid_to_name($_GET["gpid"]);
        $tag = $artica_meta->group_count($_GET["gpid"]) . " " . $tpl->javascript_parse_text("{computers}");
    }
    if ($ArticaMetaUseSendClient == 1) {
        $tr[] = paragrapheFleche("{send_ping}", "Loadjs('{$page}?send-ping-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{change_hostname}", "Loadjs('{$page}?change-hostname-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{add_tag}", "Loadjs('{$page}?add-tag-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    }
    if ($gpid == 0) {
        if (intval($artica_meta->IsAD($_GET["uuid"]))) {
            $tr[] = paragrapheFleche("{activedirectroy_reconnection}", "Loadjs('{$page}?activedirectory-reconnect-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
            $tr[] = paragrapheFleche("{enable_emergency_mode} (Active directory)", "Loadjs('{$page}?activedirectory-emergency-enable-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
            $tr[] = paragrapheFleche("{disable_emergency_mode} (Active directory)", "Loadjs('{$page}?activedirectory-emergency-disable-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
        }
    }
    if ($gpid > 0) {
        if ($artica_meta->group_is_ad_inside($gpid)) {
            $tr[] = paragrapheFleche("{activedirectroy_reconnection}", "Loadjs('{$page}?activedirectory-reconnect-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
            $tr[] = paragrapheFleche("{enable_emergency_mode} (Active directory)", "Loadjs('{$page}?activedirectory-emergency-enable-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
            $tr[] = paragrapheFleche("{disable_emergency_mode} (Active directory)", "Loadjs('{$page}?activedirectory-emergency-disable-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
        } else {
            if ($GLOBALS["VERBOSE"]) {
                echo "<H1>AD = FALSE</H1>";
            }
        }
    }
    $tr[] = paragrapheFleche("{reboot}", "Loadjs('{$page}?reboot-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{root_password2}", "Loadjs('{$page}?root-password-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{global_admin_account}", "Loadjs('{$page}?manager-password-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{install_package}", "Loadjs('artica-meta.packages.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{update_artica}", "Loadjs('artica-meta.update.artica.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{directories_monitor}", "Loadjs('{$page}?philesight-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{create_a_snapshot}", "Loadjs('{$page}?snapshot-js=yes&uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    $tr[] = paragrapheFleche("{restore_a_snapshot}", "Loadjs('artica-meta.snapshots.browse.php?uuid=" . urlencode($_GET["uuid"]) . "&gpid={$_GET["gpid"]}')");
    if ($gpid == 0) {
        $tr[] = paragrapheFleche("{delete}", "Loadjs('{$page}?delete-js=yes&uuid=" . urlencode($_GET["uuid"]) . "')");
    }
    $html = "<div style='font-size:26px;margin-bottom:20px'>{$hostname} - {$tag} - {$_GET["uuid"]}</div>{$LicenseText}" . CompileTr3($tr);
    echo $tpl->_ENGINE_parse_body($html);
}