PHP mysql_meta::create_table_meta_admin_mysql 예제들

예제 #1

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

function metaevents_client_scan($uuid)
{
    $unix = new unix();
    $sock = new sockets();
    $q = new mysql();
    if (!$q->test_mysql_connection()) {
        return;
    }
    $ArticaMetaStorage = $sock->GET_INFO("ArticaMetaStorage");
    if ($ArticaMetaStorage == null) {
        $ArticaMetaStorage = "/home/artica-meta";
    }
    $destdir = "{$ArticaMetaStorage}/{$uuid}/META_EVENTS";
    $files = $unix->DirFiles($destdir);
    if (!$q->FIELD_EXISTS("meta_admin_mysql", "zmd5", "artica_events")) {
        meta_events("Patching meta_admin_mysql");
        $meta = new mysql_meta();
        $q->QUERY_SQL("DROP TABLE `meta_admin_mysql`", "artica_events");
        $meta->create_table_meta_admin_mysql();
    }
    while (list($filename, $ARRAY) = each($files)) {
        $sourcefile = "{$destdir}/{$filename}";
        $destfile = "{$destdir}/{$filename}.sql";
        meta_events("{$uuid}: Uncompress {$sourcefile}...");
        $unix->uncompress($sourcefile, $destfile);
        if (!is_file($destfile)) {
            continue;
        }
        $q->QUERY_SQL(@file_get_contents($destfile), "artica_events");
        if (!$q->ok) {
            meta_events("{$uuid}:{$q->mysql_error}");
            @unlink($destfile);
            continue;
        }
        @unlink($sourcefile);
        @unlink($destfile);
    }
}