function perform() { if ($_REQUEST['report_id'] == 1) { // make my report table header... echo '<table id= "questionTable"> <tr> <th>Hour Begin TO End</th> <th>Question Count</th> <th>Percentage</th> </tr>'; // get my report table data... $i = 0; $count = array(); $percentage = array(); echo '<tbody'; foreach ($reports as $report) { $nextHour = $report["hour_begin"] + 1; if ($nextHour == 13) { $nextHour = 1; } echo '<tr>' . '<td>' . $report["hour_begin"] . ' TO ' . $nextHour . '</td>' . '<td>' . ($report["question_count"] + 0) . '</td>' . '<td>' . round(($report["question_count"] + 0) / $numberReportQuestionCount * 100, 1) . '%' . '</td>' . '</tr>'; $i++; $arrayCount = $i; $count[$arrayCount] = $report["question_count"]; $percentage[$arrayCount] = round(($report["question_count"] + 0) / $numberReportQuestionCount * 100, 1); } echo '</tbody>'; // total report summary $questionSum = array_sum($count); $questionPercentage = array_sum($percentage); echo '<tr>' . '<td><strong>Totals</strong>' . '<td><strong>' . $questionSum . '</strong></td>' . '<td><strong>' . $questionPercentage . '%' . '</strong></td>' . '</tr></table></div></div>'; } return perform(); }
/** * @Given /^I scroll to the top$/ */ public function iScrollToTheTop() { $driver = $this->getSession()->getDriver(); // Wait two seconds for admin menu if using js. if ($driver instanceof Selenium2Driver) { $element = $driver . findElement(By . id("header")); $actions = new Actions($driver); $actions . moveToElement($element); // actions.click(); $actions . perform(); } }
function startServer($data) { // if the content-type is json, start loading if ($_SERVER['CONTENT_TYPE'] == "application/json" || $_SERVER['CONTENT_TYPE'] == "application/json; charset=UTF-8") { // open connection to database $con = establishConnection(); $jsonObject = json_decode($data); // create JSON-String and return it to the client echo json_encode(perform($jsonObject)); // close connection to database closeConnection($con); // else send a warning } else { $error = new Statusmessage(); $error->addFailure("Wrong content-type. Content-Type: application/json expected!"); echo json_encode($error); } }
function execute() { if ($GLOBALS["VERBOSE"]) { echo "Loading...\n"; } $unix = new unix(); if ($GLOBALS["VERBOSE"]) { "echo Loading done...\n"; } $pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid"; $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time"; $pid = @file_get_contents($pidfile); if (!$GLOBALS["FORCE"]) { if ($pid < 100) { $pid = null; } $unix = new unix(); if ($unix->process_exists($pid, basename(__FILE__))) { if ($GLOBALS["VERBOSE"]) { echo "Already executed pid {$pid}\n"; } return; } $timeexec = $unix->file_time_min($timefile); if ($timeexec < 1440) { if ($GLOBALS["VERBOSE"]) { echo "{$timeexec} <>1440...\n"; } return; } $mypid = getmypid(); @file_put_contents($pidfile, $mypid); } @file_put_contents($timefile, time()); $q = new mysql_squid_builder(); $sql = "SELECT DATE_FORMAT(zDate,'%Y%m%d') AS `suffix`, DATE_FORMAT(zDate,'%Y-%m-%d') AS `zDay`,`tablename`\n\t\tFROM tables_day WHERE zDate<DATE_SUB(NOW(),INTERVAL 2 DAY)\n\t\tORDER BY zDate DESC"; $q = new mysql_squid_builder(); if (!CheckTable()) { if ($GLOBALS['VERBOSE']) { echo "Fatal generic_categories, no such table\n"; } @unlink($timefile); ufdbguard_admin_events("Fatal generic_categories, no such table", __FUNCTION__, __FILE__, __LINE__, "stats"); return; } if ($GLOBALS["VERBOSE"]) { echo "{$sql}\n"; } $results = $q->QUERY_SQL($sql); if (!$q->ok) { @unlink($timefile); ufdbguard_admin_events("Fatal {$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__, "stats"); die; } if (mysql_num_rows($results) == 0) { @unlink($timefile); return; } $q->QUERY_SQL("TRUNCATE TABLE `generic_categories`"); while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $table_source = "{$ligne["suffix"]}_hour"; if (!$q->TABLE_EXISTS($table_source)) { if ($GLOBALS['VERBOSE']) { echo "{$table_source}, no such table\n"; } continue; } perform($table_source, $ligne["zDay"]); } }
<?php include_once('ressources/class.templates.inc'); include_once('ressources/class.ldap.inc'); include_once('ressources/class.users.menus.inc'); include_once("ressources/class.os.system.inc"); include_once("ressources/class.lvm.org.inc"); $user=new usersMenus(); if(!$user->AsSystemAdministrator){echo "alert('no privileges');";die();} if(isset($_GET["popup"])){popup();exit;} if(isset($_POST["dev"])){perform();exit;} if(isset($_GET["GetLogs"])){GetLogs();exit;} js(); function js(){ $page=CurrentPageName(); header("content-type: application/x-javascript"); $dev=$_GET["dev"]; $devenc=urlencode($dev); echo "YahooWinBrowse('700','$page?popup=yes&dev=$devenc','$dev',true)"; } function popup(){ $page=CurrentPageName(); $tpl=new templates(); $sock=new sockets(); $fsarray=unserialize(base64_decode($sock->getFrameWork("system.php?fsarray=yes"))); $macro_build_bigpart_warning=$tpl->javascript_parse_text('{macro_build_bigpart_warning}'); $devenc=urlencode($_GET["dev"]);
exit; } if (isset($_GET["restart-js"])) { reboot_js(); exit; } if (isset($_GET["defrag-js"])) { defrag_js(); exit; } if (isset($_GET["menus"])) { echo menus(); exit; } if (isset($_GET["perform"])) { perform(); exit; } function defrag() { include_once dirname(__FILE__) . "/class.sockets.inc"; include_once 'ressources/class.templates.inc'; $user = new usersMenus(); if (!$user->AsSystemAdministrator) { die; } $sock = new sockets(); $DisableRebootOrShutDown = $sock->GET_INFO('DisableRebootOrShutDown'); if ($DisableRebootOrShutDown == 1) { return; }
function start($xtime = 0) { $unix = new unix(); if ($GLOBALS["VERBOSE"]) { "echo Loading done...\n"; } $pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid"; $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time"; if ($GLOBALS["VERBOSE"]) { echo "Timefile = {$timefile}\n"; } $pid = @file_get_contents($pidfile); if (!$GLOBALS["FORCE"]) { if ($pid < 100) { $pid = null; } $unix = new unix(); if ($unix->process_exists($pid, basename(__FILE__))) { if ($GLOBALS["VERBOSE"]) { echo "Already executed pid {$pid}\n"; } return; } $timeexec = $unix->file_time_min($timefile); if (!$GLOBALS["SCHEDULED"]) { if ($timeexec < 2880) { return; } } $mypid = getmypid(); @file_put_contents($pidfile, $mypid); } @unlink($timefile); @file_put_contents($timefile, time()); build_progress("Starting refreshing...", 10); $sql = "SELECT tablename, familyday,DATE_FORMAT(zDate,'%Y%m%d') AS `suffix` FROM tables_day \n\t\t\tWHERE familyday=0 AND DAY(zDate)<DAY(NOW()) AND YEAR(zDate) = YEAR(NOW()) AND MONTH(zDate) = MONTH(NOW())"; $q = new mysql_squid_builder(); $q->CheckTables(); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; return; } if ($GLOBALS["VERBOSE"]) { echo mysql_num_rows($results) . " rows\n"; } $c = 0; $Max = mysql_num_rows($results); while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $worktable = "{$ligne["suffix"]}_visited"; $SourceTable = "{$ligne["suffix"]}_hour"; $desttable = "{$ligne["suffix"]}_family"; $c++; $prc = $c / $Max * 100; $prc = round($prc); if ($prc > 80) { $prc = 80; } build_progress("Checking ...{$worktable} {$desttable}", $prc); if (!$q->TABLE_EXISTS($worktable)) { if (!$q->TABLE_EXISTS($SourceTable)) { $q->QUERY_SQL("UPDATE tables_day SET familyday=1 WHERE tablename='{$ligne["tablename"]}'"); continue; } if (!repair_visited_from_sources_table($SourceTable, $worktable)) { continue; } } if (!perform($worktable, $desttable)) { continue; } $q->QUERY_SQL("UPDATE tables_day SET familyday=1 WHERE tablename='{$ligne["tablename"]}'"); } build_progress("Calculating master table", 80); CONDENSED(); build_progress("Done", 100); }
break; case 2: for ($y = 0, $n = 0; $y < $h; $y++) { for ($x = 0; $x < $w; $x += $bp, $n++) { @($c = ord($d[$n])); if ($r) { $c = ($c & 0xf) << 4 | $c >> 4 & 0xf; } for ($m = 0; $m < $bp; $m++) { //imagesetpixel($i, $x + ($m & ~1) + !($m % 2), $y, $c & $mask); imagesetpixel($i, $x + $m, $y, $c & $mask); $c >>= $bpp; } } } break; default: $error = true; fprintf(STDERR, "\nERROR: MODO {$image_mode} no soportado "); break; } if (isset($p['transparent'])) { imagecolortransparent($i, $p['transparent']); } imagepng($i, $image_out, 9); //if (!file_exists($image_out2)) copy($image_out, $image_out2); echo $error ? "Error\n" : "Ok\n"; return !$error; } perform('do_extract');
$q = new mysql_squid_builder(); $q->CheckTables(); $results = $q->QUERY_SQL($sql); if (!$q->ok) { ufdbguard_admin_events("Fatal {$q->mysql_error}", __FUNCTION__, __FILE__, __LINE__, "stats"); die; } $COUNT = mysql_num_rows($results); events("checking {$COUNT} items"); $c = 0; while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $c++; $table_source = "{$ligne["suffix"]}_hour"; $prc = round($c / $COUNT * 100, 2); events("{$table_source} {$ligne["zDay"]} {$prc}%"); if (perform($table_source, $ligne["zDay"])) { $q->QUERY_SQL("UPDATE tables_day SET wwwvisited=1 WHERE `tablename`='{$ligne["tablename"]}'"); continue; } } familysites(); function events($text) { $common = "/var/log/artica-squid-statistics.log"; $size = @filesize($common); if ($size > 100000) { @unlink($common); } $pid = getmypid(); $date = date("Y-m-d H:i:s"); $h = @fopen($common, 'a');
if ($perm->have_perm("user_pending")) { $be->box_full($t->translate("Error"), $t->translate("Access denied")); $auth->logout(); } else { if (isset($id)) { // Look if contact is already in table $columns = "*"; $tables = "contact"; $where = "conid='{$id}'"; if (!$db->query("SELECT {$columns} FROM {$tables} WHERE {$where}")) { mysql_die($db); } else { // If contact in table ask for person if ($db->next_record()) { if ($db->f("user") == $auth->auth["uname"] || $perm->have_perm("admin")) { perform($db); } else { $be->box_full($t->translate("Error"), $t->translate("Access denied")); } // If contact is not in table } else { $be->box_full($t->translate("Error"), $t->translate("Contact") . " (ID: {$id}) " . $t->translate("does not exist") . "."); } } } else { $be->box_full($t->translate("Error"), $t->translate("No Contact ID specified")); } } ?> <!-- end content -->
function tables_year() { $unix = new unix(); $pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid"; $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time"; if ($GLOBALS["VERBOSE"]) { echo "timefile={$timefile}\n"; } $pid = @file_get_contents($pidfile); if (!$GLOBALS["FORCE"]) { if ($pid < 100) { $pid = null; } $unix = new unix(); if ($unix->process_exists($pid, basename(__FILE__))) { if ($GLOBALS["VERBOSE"]) { echo "Already executed pid {$pid}\n"; } return; } $timeexec = $unix->file_time_min($timefile); if ($timeexec < 2880) { if ($GLOBALS["VERBOSE"]) { echo "Only each 2880mn - current {$timeexec}mn, use --force to bypass\n"; } return; } $mypid = getmypid(); @file_put_contents($pidfile, $mypid); } @unlink($timefile); if ($GLOBALS["VERBOSE"]) { echo "Time File: {$timefile}\n"; } @file_put_contents($timefile, time()); $sql = "SELECT tablename,DATE_FORMAT(zDate,'%Y%m') AS `suffix`,\n\t\t\tDATE_FORMAT(zDate,'%Y') AS `prefix`,\n\t\t\tMONTH(`zDate`) as MONTH FROM tables_day\n\t\t\tWHERE yeardone=0 AND `zDate`< DATE_SUB(NOW(),INTERVAL 1 MONTH) ORDER BY zDate"; $results = $GLOBALS["Q"]->QUERY_SQL($sql); if (mysql_num_rows($results) == 0) { if ($GLOBALS["VERBOSE"]) { echo "Return no row...\n"; } return; } while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $tablename = $ligne["tablename"]; $suffix = $ligne["suffix"]; $prefix = $ligne["prefix"]; $MONTH = $ligne["MONTH"]; $tablesource = "{$suffix}_month"; $nexttable = "{$prefix}_year"; $array[$tablesource]["NEXT"] = $nexttable; $array[$tablesource]["SUFFIX"] = $suffix; $array[$tablesource]["MONTH"] = $MONTH; } while (list($tablesource, $ligne) = each($array)) { $nexttable = $ligne["NEXT"]; $suffix = $ligne["SUFFIX"]; $MONTH = $ligne["MONTH"]; if ($GLOBALS["VERBOSE"]) { echo "{$MONTH} {$tablesource} -> {$nexttable}\n"; } if (!perform($tablesource, $nexttable, $MONTH)) { continue; } $GLOBALS["Q"]->QUERY_SQL("UPDATE tables_day SET yeardone=1 WHERE DATE_FORMAT(zDate,'%Y%m') ='{$suffix}'"); if (system_is_overloaded()) { if ($GLOBALS["VERBOSE"]) { echo "Overloaded\n"; } @unlink($timefile); $php = $unix->LOCATE_PHP5_BIN(); $unix->THREAD_COMMAND_SET($php . " " . __FILE__); die; } } }
function table_year() { $q = new mysql_squid_builder(); if (!$q->FIELD_EXISTS("tables_day", "year2")) { $q->QUERY_SQL("ALTER TABLE `tables_day` ADD `year2` TINYINT( 1 ) NOT NULL DEFAULT '0', ADD INDEX ( `year1` )"); } $sql = "CREATE TABLE IF NOT EXISTS `alluid` (\n\t`zmd5` VARCHAR(90) NOT NULL,\n\t`zDate` DATE NOT NULL,\n\t`size` BIGINT UNSIGNED NOT NULL,\n\t`websites` BIGINT UNSIGNED NOT NULL,\n\t`uid` VARCHAR(250) NOT NULL,\n\tPRIMARY KEY (`zmd5`),\n\tKEY `zDate` (`zDate`),\n\tKEY `size` (`size`),\n\tKEY `uid` (`uid`)\n\t\n\t) ENGINE = MYISAM;"; $q->QUERY_SQL($sql); if (!$q->ok) { return; } $sql = "SELECT tablename,DATE_FORMAT(zDate,'%Y-%m-%d') AS `zDate`,DATE_FORMAT(zDate,'%Y%m%d') \n\t\t\tAS `prefix` FROM tables_day WHERE year2=0 AND `zDate`< DATE_SUB(NOW(),INTERVAL 2 DAY) ORDER BY zDate"; $results = $GLOBALS["Q"]->QUERY_SQL($sql); if (mysql_num_rows($results) == 0) { if ($GLOBALS["VERBOSE"]) { echo "Return no row...\n"; } return; } while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $tableKEY = $ligne["tablename"]; $zDate = $ligne["zDate"]; $prefix = $ligne["prefix"]; $tablesource = "quotaday_{$prefix}"; if ($GLOBALS["VERBOSE"]) { echo "{$tablesource}\n"; } if (!perform($tablesource, $zDate)) { continue; } $q->QUERY_SQL("UPDATE tables_day set year2=1 WHERE tablename='{$tableKEY}'"); if (system_is_overloaded(__FILE__)) { return; } } }
function tables_months() { $unix = new unix(); $pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid"; $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time"; if ($GLOBALS["VERBOSE"]) { echo "timefile={$timefile}\n"; } $pid = @file_get_contents($pidfile); if (!$GLOBALS["FORCE"]) { if ($pid < 100) { $pid = null; } $unix = new unix(); if ($unix->process_exists($pid, basename(__FILE__))) { if ($GLOBALS["VERBOSE"]) { echo "Already executed pid {$pid}\n"; } return; } $timeexec = $unix->file_time_min($timefile); if ($timeexec < 2880) { if ($GLOBALS["VERBOSE"]) { echo "Only each 2880mn - current {$timeexec}mn, use --force to bypass\n"; } return; } $mypid = getmypid(); @file_put_contents($pidfile, $mypid); } if ($GLOBALS["VERBOSE"]) { echo "Time File: {$timefile}\n"; } @file_put_contents($timefile, time()); if ($GLOBALS["VERBOSE"]) { echo "index_tables_day()\n"; } index_tables_day(); if (!$GLOBALS["Q"]->ifStatisticsMustBeExecuted()) { if ($GLOBALS["VERBOSE"]) { echo "This is not intended to build statistics - ifStatisticsMustBeExecuted -\n"; } return; } $sql = "SELECT tablename,DATE_FORMAT(zDate,'%Y%m%d') AS `suffix`,DATE_FORMAT(zDate,'%Y%m') AS `prefix`,\n\t\t\tMONTH(`zDate`) as MONTH, DAY(`zDate`) AS DAY, YEAR(`zDate`) AS YEAR FROM tables_day\n\t\t\tWHERE monthdone=0 AND `zDate`< DATE_SUB(NOW(),INTERVAL 3 DAY) ORDER BY zDate"; if ($GLOBALS["VERBOSE"]) { echo $sql . "\n"; } $results = $GLOBALS["Q"]->QUERY_SQL($sql); if (mysql_num_rows($results) == 0) { if ($GLOBALS["VERBOSE"]) { echo "Return no row...\n"; } table_year(); return; } if ($GLOBALS["VERBOSE"]) { echo mysql_num_rows($result) . " items -> start loop\n"; } while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $tableKEY = $ligne["tablename"]; $suffix = $ligne["suffix"]; $prefix = $ligne["prefix"]; $tablesource = "{$suffix}_hour"; $nexttable = "{$prefix}_month"; $dayNum = $ligne["DAY"]; if ($GLOBALS["VERBOSE"]) { echo "{$dayNum} {$tablesource} -> Next table: {$nexttable}\n"; } if (!perform($tablesource, $nexttable, $dayNum)) { continue; } $GLOBALS["Q"]->QUERY_SQL("UPDATE tables_day SET monthdone=1 WHERE `tablename`='{$tableKEY}'"); } table_year(); }
function start($xtime = 0) { build_progress("Loading...", 10); $unix = new unix(); if ($GLOBALS["VERBOSE"]) { "echo Loading done...\n"; } $pidfile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".pid"; $timefile = "/etc/artica-postfix/pids/" . basename(__FILE__) . "." . __FUNCTION__ . ".time"; if ($GLOBALS["VERBOSE"]) { echo "Timefile = {$timefile}\n"; } $pid = @file_get_contents($pidfile); if (!$GLOBALS["FORCE"]) { if ($pid < 100) { $pid = null; } $unix = new unix(); if ($unix->process_exists($pid, basename(__FILE__))) { if ($GLOBALS["VERBOSE"]) { echo "Already executed pid {$pid}\n"; } return; } $timeexec = $unix->file_time_min($timefile); if (!$GLOBALS["SCHEDULED"]) { if ($timeexec < 2880) { return; } } $mypid = getmypid(); @file_put_contents($pidfile, $mypid); } if ($GLOBALS["RESTART"]) { REBUILD_FULL_MEMBERS(); exit; } @unlink($timefile); @file_put_contents($timefile, time()); $php = $unix->LOCATE_PHP5_BIN(); if (!$GLOBALS["VERBOSE"]) { build_progress("Execute exec.squid.stats.members.hours.php {please_wait}", 20); $repaircmd = "{$php} /usr/share/artica-postfix/exec.squid.stats.members.hours.php --repair --verbose --force 2>&1"; system($repaircmd); } $q = new mysql_squid_builder(); if (!$q->FIELD_EXISTS("tables_day", "usersday")) { $q->QUERY_SQL("ALTER TABLE `tables_day` ADD `usersday` TINYINT( 1 ) NOT NULL DEFAULT '0', ADD INDEX ( `usersday` )"); } $sql = "SELECT tablename, usersday,DATE_FORMAT(zDate,'%Y%m%d') AS `suffix` FROM tables_day \n\t\t\tWHERE usersday=0 AND DAY(zDate)<DAY(NOW()) AND YEAR(zDate) = YEAR(NOW()) AND MONTH(zDate) = MONTH(NOW())"; $q->CheckTables(); $results = $q->QUERY_SQL($sql); if (!$q->ok) { echo $q->mysql_error; build_progress("MySQL error", 110); return; } build_progress("tables_day = " . mysql_num_rows($results) . " rows {please_wait}", 30); if ($GLOBALS["VERBOSE"]) { echo mysql_num_rows($results) . " rows\n"; } while ($ligne = @mysql_fetch_array($results, MYSQL_ASSOC)) { $worktable = "{$ligne["suffix"]}_members"; $SourceTable = "{$ligne["suffix"]}_hour"; if (!$q->TABLE_EXISTS($worktable)) { continue; } $desttable = "{$ligne["suffix"]}_users"; build_progress("{$desttable} {please_wait}", 30); if (!perform($worktable, $desttable)) { continue; } $q->QUERY_SQL("UPDATE tables_day SET usersday=1 WHERE tablename='{$ligne["tablename"]}'"); } $currentdestable = date("Ymd") . "_users"; if (!$q->CreateUsersTempTable()) { build_progress("CreateUsersTempTable failed", 110); return false; } if (!$q->CreateUsersFullTable()) { build_progress("CreateUsersFullTable failed", 110); return false; } build_progress("Empty working tables", 40); $q->QUERY_SQL("TRUNCATE TABLE UsersTMP"); $q->QUERY_SQL("TRUNCATE TABLE UsersToTal"); $LIST_TABLES_MEMBERS = $q->LIST_TABLES_MEMBERS(); while (list($tablename, $ligne) = each($LIST_TABLES_MEMBERS)) { $xtime = $q->TIME_FROM_DAY_TABLE($tablename); $desttable = date("Ymd", $xtime) . "_users"; build_progress("Scanning {$tablename} -> {$desttable}", 50); if ($desttable == $currentdestable) { continue; } if (!$q->TABLE_EXISTS($desttable)) { if (!perform($tablename, $desttable)) { continue; } } MONTH_TABLE_FROM_MEMBER_DAY($tablename); CONDENSED_perform($desttable); } CONDENSED(); build_progress("Empty table UsersTMP", 90); $q->QUERY_SQL("TRUNCATE TABLE UsersTMP"); build_progress("{done}", 100); }