Example #1
0
/**
 * Parses csv file
 *
 * @param string $filename FIle name including path.
 * @return array
 */
function parseFile($filename)
{
    $result = [];
    $handle = @fopen($filename, "r");
    $fnames = false;
    if ($handle) {
        while (($row = fgetcsv($handle, 4096, ",")) !== false) {
            if (count($row) != 20) {
                continue;
            }
            if (!$fnames) {
                $fnames = $row;
                foreach ($fnames as $key => $value) {
                    $fnames[$key] = strtolower($value);
                }
            } else {
                $tmp = processRow($row, $fnames);
                if ($tmp['ipv4addr']) {
                    $result[$row[0]][$row[2]] = $tmp;
                }
            }
        }
        if (!feof($handle)) {
            echo "Error: unexpected fgets() exception\n";
            exit(1);
        }
        fclose($handle);
    } else {
        echo "Error: file '{$filename}' can not be opened.\n";
        exit(1);
    }
    return $result;
}
Example #2
0
/**
 * Parses csv file
 *
 * @param string $filename FIle name including path.
 * @return array
 */
function parseFile($filename)
{
    $fields = getFields();
    $field_names = array_keys($fields);
    $result = [];
    $handle = @fopen($filename, "r");
    if ($handle) {
        while (($row = fgetcsv($handle, 20000, ",")) !== false) {
            if (count($row) != 75) {
                continue;
            }
            $result[$row[59]] = processRow($row, $fields, $field_names);
        }
        if (!feof($handle)) {
            echo "Error: unexpected fgets() exception\n";
            exit(1);
        }
        fclose($handle);
    } else {
        echo "Error: file '{$filename}' can not be opened.\n";
        exit(1);
    }
    return $result;
}
Example #3
0
sleep(1);
echo ">>> 8 <<<\n";
sleep(1);
echo ">>> 7 <<<\n";
sleep(1);
echo ">>> 6 <<<\n";
sleep(1);
echo ">>> 5 <<<\n";
sleep(1);
echo ">>> 4 <<<\n";
sleep(1);
echo ">>> 3 <<<\n";
sleep(1);
echo ">>> 2 <<<\n";
sleep(1);
echo ">>> 1 <<<\n";
sleep(1);
echo ">>> 0 <<<\n";
sleep(2);
echo 'Please wait while the master database is refreshed.' . "\n";
$mysql = getMasterMySQL();
$total = mysql_fetch_assoc(mysql_query('SELECT COUNT(*) AS `count` FROM `editset`'));
$total = $total['count'];
$count = 0;
$results = mysql_query('SELECT `editid`, `isvandalism`, `isactive`, `reviewers`, `reviewers_agreeing`, `source` FROM `editset`');
while ($row = mysql_fetch_assoc($results)) {
    $count++;
    echo "" . round($count * 100 / $total) . "% (" . $count . "/" . $total . "): " . $row['editid'] . " ... ";
    processRow($row['editid'], $row['isvandalism'], $row['isactive'], $row['reviewers'], $row['reviewers_agreeing'], $row['source']);
    echo " Done!\n";
}
function processRow($menuitem, $indent)
{
    printRow($menuitem, $indent);
    if (count($menuitem["subitems"]) > 0) {
        foreach ($menuitem["subitems"] as $item) {
            processRow($item, $indent + 1);
        }
    }
}