function printRecord($l)
{
global $propCount, $propTotal;
$tpl = Template::getInstance();
$totalTicks = $tpl->masterHandler->{$propCount};
$totalTime = $tpl->masterHandler->{$propTotal};
$total = (int) $l->{$propTotal};
$count = (int) $l->{$propCount};
if ($count === 0) {
return;
}
$avg = round($total / $count / 1000000, 4);
$tickAvg = round($avg * ($count / $totalTicks), 4);
$totalPct = round($total / $totalTime * 100, 2);
if ($l->id->name === "Full Server Tick") {
// always 100%
$totalPct = pctView($totalPct, 200, 200, 200, 200);
$pctOfTick = pctView($tickAvg / 50 * 100, 90, 80, 75, 70);
} else {
$totalPct = pctViewMod($totalPct, $totalPct / ($tickAvg / 50 * 100), 50, 30, 20, 10);
$pctOfTick = pctView($tickAvg / 50 * 100, 50, 30, 20, 10);
}
$avgCountTick = number_format($count / $totalTicks, 2);
$tickAvg = pctView($tickAvg);
$avg = pctView($avg);
$name = cleanName($l->id);
$total = round($total / 1000000000, 3);
echo "\n<div class='row-wrap'>\n\t<div class='name' style>{$name}</div>\n\n\t<div class='row-info'>\n\n\t\t<div class='row-info-total'>count(<span class='count'>{$count}</span>)\n\t\ttotal(<span class='totalPct'>{$totalPct}%</span> <span class='totalTime'>{$total}s</span>, <span class='pctOfTick'>{$pctOfTick}% of tick</span>)\n\t\t</div>\n\n\t\t<div class='row-info-avg'>\n\t\tavg(<span class='avgMs'>{$avg}ms</span> per - <span class='tickAvgMs'>{$tickAvg}ms/{$avgCountTick} per tick</span>)\n\t\t</div>\n\n\t</div>\n</div>\n\t\t\n";
}
function printRecord($l, $depth = 0)
{
static $i;
$tpl = Template::getInstance();
$lagTicks = $tpl->masterHandler->lagCount;
$ticks = $tpl->masterHandler->count;
$totalTime = $tpl->masterHandler->total;
$lagTotalTime = $tpl->masterHandler->lagTotal;
$id = $l->id->id . "_" . $i++;
$total = LAG_ONLY ? $l->lagTotal : $l->total;
$count = LAG_ONLY ? $l->lagCount : $l->count;
$avg = round($total / $count / 1000000, 4);
$tickAvg = round($avg * ($count / (LAG_ONLY ? $lagTicks : $ticks)), 4);
$tickAvg = lagView($tickAvg);
$totalPct = round($total / (LAG_ONLY ? $lagTotalTime : $totalTime) * 100, 2);
if ($l->id->name == "Full Server Tick") {
// always 100%
$totalPct = lagView($totalPct, 200, 200, 200, 200);
} else {
$totalPct = lagView($totalPct, 25, 15, 7, 3);
}
$avg = lagView($avg);
$name = cleanName($l->id);
$total = round($total / 1000000000, 3);
$indents = "";
for ($j = 1; $j <= $depth; $j++) {
$num = $j % 5;
$indents .= "<div class='indent depth{$num} full-depth{$j}'></div>";
}
echo "<div class='full-timing-row'>{$indents}<div id='{$id}' class='timing-row'>\n\t\t<a href='#{$id}'>#</a><span class='name'>{$name}</span> - count(<span class='count'>{$count}</span>) -\n\t\ttotal(<span class='totalPct'>{$totalPct}%</span> <span class='totalTime'>{$total}s</span>) -\n\t\tavg(<span class='avgMs'>{$avg}ms</span> - <span class='tickAvgMs'>{$tickAvg}ms</span>)\n\t\t</div></div>\n";
}
function getEnumClass($enumDefinition, $columnName)
{
$eClass = "class db_enum_" . $columnName . " { function __construct() {}";
$enumVals = explode(",", str_ireplace("'", "", str_ireplace(")", "", str_ireplace("(", "", str_ireplace("enum", "", $enumDefinition)))));
foreach ($enumVals as &$value) {
$eClass .= " const c_" . cleanName($value) . "='" . $value . "';";
}
$eClass .= " }";
return $eClass;
}
if ($image->getAttribute('data-extension') == "mov") {
$fxlt_image->assign('IMAGE_THUMB_SRC', $mov_thumb);
$fxlt_image->assign('IMAGE_REL', 'video');
} else {
$fxlt_image->assign('IMAGE_THUMB_SRC', resize($image_src, $resize_settings));
$fxlt_image->assign('IMAGE_REL', 'lightbox');
}
}
// Append image to page
$fxlt->assign('image', $fxlt_image);
// Clear the buffer
$fxlt_image->clear();
}
}
/* General template settings
---------------------------------------------------*/
// Set current URL params for filter links
$fxlt->assign('THIS_ALBUM_ID', $alb);
$fxlt->assign('THIS_CATEGORY_ID', $cat);
// Assign the currently-viewed album a title
$fxlt->assign('THIS_PAGE_TITLE', cleanName($protos->getAlbumName()) . " - " . cleanName($protos->getCategoryName()));
$fxlt->assign('THIS_ALBUM_NAME', $protos->getAlbumName());
$fxlt->assign('THIS_ALBUM_TITLE', cleanName($protos->getAlbumName()));
$fxlt->assign('THIS_CATEGORY_NAME', $protos->getCategoryName());
$fxlt->assign('THIS_CATEGORY_TITLE', cleanName($protos->getCategoryName()));
$fxlt->assign('THIS_SET_NAME', $protos->getSetName());
$fxlt->assign('THIS_SET_DESCRIPTION', $protos->getSetDescription());
/* Display template
---------------------------------------------------*/
// Write to page
$fxlt->display();
function getvnum($wk, $vendor, $cost)
{
global $lkp;
$vnum = 0;
$cv = cleanName($vendor);
if ($wk == 1) {
if ($cost > 0) {
if (in_array($cv, $lkp["1," . $wk . ",3"]) || in_array($cv, $lkp["1," . $wk . ",4"]) || in_array($cv, $lkp["1," . $wk . ",5"]) || in_array($cv, $lkp["1," . $wk . ",6"])) {
$vnum = 1;
} else {
if (in_array($cv, $lkp["2," . $wk . ",3"]) || in_array($cv, $lkp["2," . $wk . ",4"]) || in_array($cv, $lkp["2," . $wk . ",5"]) || in_array($cv, $lkp["2," . $wk . ",6"])) {
$vnum = 2;
} else {
if (in_array($cv, $lkp["3," . $wk . ",3"]) || in_array($cv, $lkp["3," . $wk . ",4"]) || in_array($cv, $lkp["3," . $wk . ",5"]) || in_array($cv, $lkp["3," . $wk . ",6"])) {
$vnum = 3;
} else {
if (in_array($cv, $lkp["4," . $wk . ",3"]) || in_array($cv, $lkp["4," . $wk . ",4"]) || in_array($cv, $lkp["4," . $wk . ",5"]) || in_array($cv, $lkp["4," . $wk . ",6"])) {
$vnum = 4;
}
}
}
}
}
} else {
if ($wk == 2) {
if ($cost > 0) {
if (in_array($cv, $lkp["1," . $wk . ",3"]) || in_array($cv, $lkp["1," . $wk . ",4"]) || in_array($cv, $lkp["1," . $wk . ",5"]) || in_array($cv, $lkp["1," . $wk . ",6"])) {
$vnum = 1;
} else {
if (in_array($cv, $lkp["2," . $wk . ",3"]) || in_array($cv, $lkp["2," . $wk . ",4"]) || in_array($cv, $lkp["2," . $wk . ",5"]) || in_array($cv, $lkp["2," . $wk . ",6"])) {
$vnum = 2;
} else {
if (in_array($cv, $lkp["3," . $wk . ",3"]) || in_array($cv, $lkp["3," . $wk . ",4"]) || in_array($cv, $lkp["3," . $wk . ",5"]) || in_array($cv, $lkp["3," . $wk . ",6"])) {
$vnum = 3;
} else {
if (in_array($cv, $lkp["4," . $wk . ",3"]) || in_array($cv, $lkp["4," . $wk . ",4"]) || in_array($cv, $lkp["4," . $wk . ",5"]) || in_array($cv, $lkp["4," . $wk . ",6"])) {
$vnum = 4;
}
}
}
}
}
} else {
if ($wk == 3) {
if ($cv != "") {
if (in_array($cv, $lkp["1," . $wk . ",3"]) || in_array($cv, $lkp["1," . $wk . ",4"]) || in_array($cv, $lkp["1," . $wk . ",5"]) || in_array($cv, $lkp["1," . $wk . ",6"])) {
$vnum = 1;
} else {
if (in_array($cv, $lkp["2," . $wk . ",3"]) || in_array($cv, $lkp["2," . $wk . ",4"]) || in_array($cv, $lkp["2," . $wk . ",5"]) || in_array($cv, $lkp["2," . $wk . ",6"])) {
$vnum = 2;
} else {
if (in_array($cv, $lkp["3," . $wk . ",3"]) || in_array($cv, $lkp["3," . $wk . ",4"]) || in_array($cv, $lkp["3," . $wk . ",5"]) || in_array($cv, $lkp["3," . $wk . ",6"])) {
$vnum = 3;
} else {
if (in_array($cv, $lkp["4," . $wk . ",3"]) || in_array($cv, $lkp["4," . $wk . ",4"]) || in_array($cv, $lkp["4," . $wk . ",5"]) || in_array($cv, $lkp["4," . $wk . ",6"])) {
$vnum = 4;
}
}
}
}
}
}
}
}
// echo '<br>'.$cv.' - '.$vnum.' = '.$cost;
return $vnum;
}
$app->notFound();
}
})->name('source');
// show html
$app->get('/:name/html/:id', function ($name, $id) use($app, $mailbox) {
$email = $mailbox->getMail($id);
if (!is_null($email)) {
$html_safe = preg_replace("/https?:\\/\\//i", URI_REDIRECT_PREFIX . '\\0', $email->textHtml);
print $html_safe;
} else {
$app->notFound();
}
})->name('html');
// read emails
$app->get('/:name/', function ($name) use($app, $mailbox) {
$name = cleanName($name);
$mailsIds = findMails($name, $mailbox);
$emails = array();
foreach ($mailsIds as $id) {
$emails[] = $mailbox->getMail($id);
}
$address = $name . '@' . DOMAIN;
if ($emails === NULL || count($emails) == 0) {
$app->render('waiting.html', array('name' => $name, 'address' => $address));
} else {
$app->render('list.html', array('name' => $name, 'address' => $address, 'emails' => $emails));
}
})->name('read');
$app->run();
function cleanName($name)
{
<?php
include 'util.php';
$string = file_get_contents("../conf/conf.json");
$json_a = json_decode($string, true);
$host = $json_a['datasource']['host'];
$user = $json_a['datasource']['username'];
$pass = $json_a['datasource']['password'];
$db = $json_a['datasource']['database'];
$con = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}") or die("Could not connect to server\n");
$table = $_GET['table'];
$query = "SELECT * FROM " . $table;
$rs = pg_query($con, $query) or die("Cannot execute query: {$query}\n");
$players = array();
//key: player, value: array -> key: award, value: count
while ($row = pg_fetch_assoc($rs)) {
$p = null;
$player1Name = $row['player1'];
//clean
$player1Name = cleanName($player1Name);
if (!array_key_exists($player1Name, $players)) {
$players[$player1Name] = array();
}
$players[$player1Name][cleanName($row['player2'])] = array("kills" => $row['kills'], "deaths" => $row['deaths']);
}
pg_close($con);
echo json_encode($players);
<?php
/**
* Script generating all possible emails for a said person
* Doesn't include reverted emails (last.first @ example.com)
**/
$options = getopt("f:l:d:");
$first = strtolower(trim($options["f"]));
$last = strtolower(trim($options["l"]));
$domain = strtolower(trim($options["d"]));
$emails = [];
$allFirsts = cleanName($first);
$allLasts = cleanName($last);
//Full name
foreach ($allFirsts as $fname) {
foreach ($allLasts as $lname) {
$emails[] = $fname . "." . $lname . "@" . $domain;
$emails[] = $fname . "_" . $lname . "@" . $domain;
$emails[] = $fname . "-" . $lname . "@" . $domain;
$emails[] = $fname . $lname . "@" . $domain;
}
}
//First name
foreach ($allFirsts as $fname) {
$emails[] = $fname . "@" . $domain;
}
//Last name
foreach ($allLasts as $fname) {
$emails[] = $lname . "@" . $domain;
}
$aFindex = count($allFirsts) - 1;
$qtable = "";
?>
<div class="properties <?php
if ($this->hidedescription) {
echo 'hideProperties';
}
?>
">
<?php
if ($this->properties) {
foreach ($this->properties as $r) {
?>
<div class="searchresult panel">
<div class="itemhead">
<a href="a/data-qualities/<?php
echo cleanName($r->{'quality'});
?>
" class="iconpurple">
<i class="fa fa-fw fa-bar-chart"></i> <?php
echo $r->{'quality'};
?>
</a>
</div>
<div class="dataproperty"><?php
if (is_numeric($r->{'value'})) {
echo round($r->{'value'}, 2);
} elseif ($r->{'value'} == 'true') {
echo "<i class='fa fa-check fa-lg'></i>";
} elseif ($r->{'value'} == 'false') {
echo "<i class='fa fa-times fa-lg'></i>";
} else {
foreach ($this->flow['parameters'] as $r) {
echo "<tr><td>" . $r['name'] . "</td><td>" . $r['description'] . "</td><td>" . (strlen($r['default_value']) > 0 ? "default: " . $r['default_value'] : "") . (strlen($r['recommended_range']) > 0 ? "<br><div class='tip recommendedrange' data-toggle='tooltip' data-placement='left' title='Recommended range'><i class='fa fa-thumbs-o-up'></i> " . $r['recommended_range'] . "</div>" : "") . "</td></tr>";
}
}
?>
</table>
</div>
</div> <!-- end col-md-6 -->
<div class="qualities col-xs-12">
<?php
$qtable = "";
if (sizeof($this->flow['qualities']) > 0) {
echo '<h3>' . sizeof($this->flow['qualities']) . ' properties</h3>';
foreach ($this->flow['qualities'] as $k => $v) {
$qtable .= "<tr><td><a href='a/flow-qualities/" . cleanName($k) . "'>" . $k . "</a></td><td>";
if (is_numeric($v)) {
$qtable .= round($v, 2);
} else {
$qtable .= $v;
}
$qtable .= "</td></tr>";
}
}
?>
</div><div class="col-xs-12">
<?php
if (strlen($qtable) > 1) {
echo "<a data-toggle='collapse' href='#algoquals'><i class='fa fa-caret-right'></i> Show more</a><div id='algoquals' class='collapse'><div class='table-responsive'><table class='table table-striped'>" . $qtable . "</table></div></div>";
}
?>
function compareTwoContacts($c1, $c2)
{
global $thresholdUsernameSimilarity, $thresholdNameSimilarity;
logMsg('DEBUG', "Comparing " . $c1['email'] . " with " . $c2['email']);
// merge primary name with secondary names
$c1Names = $c1['secondaryNames'];
$c2Names = $c2['secondaryNames'];
if ($c1['name']) {
$c1Names[] = $c1['name'];
}
if ($c2['name']) {
$c2Names[] = $c2['name'];
}
// if we have names
if (count($c1Names) && count($c2Names)) {
// clean names
array_walk($c1Names, 'cleanName');
array_walk($c2Names, 'cleanName');
// check for exact items
$commonNames = array_intersect($c1Names, $c2Names);
}
$c1Username = $c1['usernames'][0];
cleanName($c1Username);
$c2Username = $c2['usernames'][0];
cleanName($c2Username);
// check similarity
if (!empty($commonNames)) {
// full names match
return 1;
} elseif ($c1Username && $c2Username && ($usernameSimilarity = compareComplex($c1Username, $c2Username)) && $usernameSimilarity > $thresholdUsernameSimilarity) {
// very high username similarity
logMsg('DEBUG', "Username similarity between " . $c1Username . " and " . $c2Username . " is {$usernameSimilarity}");
return 1;
} elseif (count($c1Names) && count($c2Names)) {
// check names similarity
$nameSimilarity = 0;
foreach ($c1Names as $c1Name) {
if (!$c1Name) {
continue;
}
$c1NamesSplit = explode(' ', $c1Name);
$nameSimilarity = 0;
foreach ($c2Names as $c2Name) {
if (!$c2Name) {
continue;
}
$c2NamesSplit = explode(' ', $c2Name);
$similarity = compareComplexMulti($c1NamesSplit, $c2NamesSplit);
if ($similarity > $nameSimilarity) {
logMsg('DEBUG', "Name similarity between " . $c1Name . " and " . $c2Name . " is {$similarity}");
$nameSimilarity = $similarity;
}
}
}
unset($c1Names);
unset($c2Names);
unset($c1NamesSplit);
unset($c2NamesSplit);
return $nameSimilarity > $thresholdUsernameSimilarity ? 1 : 0;
} else {
unset($c1Names);
unset($c2Names);
return 0;
}
}
require_once "constants.php";
$cache = "<?php";
//special handling for stores table (creating stores cache)
$selectStores = new MySqlSelect();
$selectStores->COLUMNS("*");
$selectStores->FROM("stores");
$selectStores->ADD_SORT("store_name", "desc");
$storesResult = db::MySqlSubmitQuery($selectStores->toString());
if ($storesResult) {
$cache .= $newLine . "class db_cache_store{";
while ($storesResultRow = mysql_fetch_array($storesResult, MYSQL_ASSOC)) {
$cache .= $newLine . " public static \$" . "_" . cleanName($storesResultRow["store_name"]) . " = array(id => " . $storesResultRow["id"] . " , name => '" . $storesResultRow["store_name"] . "', default_tag_id => '" . $storesResultRow["default_tag_id"] . "');";
}
$cache .= $newLine . "}";
}
//special handling for tags table (creating stores cache)
$selectTags = new MySqlSelect();
$selectTags->COLUMNS("*");
$selectTags->FROM("tags");
$selectTags->ADD_SORT("tag_name", "desc");
$tagsResult = db::MySqlSubmitQuery($selectTags->toString());
if ($tagsResult) {
$cache .= $newLine . "class db_cache_tag{";
while ($tagsResultRow = mysql_fetch_array($tagsResult, MYSQL_ASSOC)) {
$cache .= $newLine . " public static \$" . "_" . cleanName($tagsResultRow["tag_name"]) . " = array(id => " . $tagsResultRow["id"] . " , name => '" . $tagsResultRow["tag_name"] . "');";
}
$cache .= $newLine . "}";
}
$cache .= $newLine . "?>";
file_put_contents("cache.php", $cache);
echo 'complete.';
<?php
include 'util.php';
$string = file_get_contents("../conf/conf.json");
$json_a = json_decode($string, true);
$host = $json_a['datasource']['host'];
$user = $json_a['datasource']['username'];
$pass = $json_a['datasource']['password'];
$db = $json_a['datasource']['database'];
$con = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}") or die("Could not connect to server\n");
$table = $_GET['table'];
$query = "SELECT * FROM " . $table;
$rs = pg_query($con, $query) or die("Cannot execute query: {$query}\n");
$players = array();
//key: player, value: array -> key: award, value: count
while ($row = pg_fetch_assoc($rs)) {
$p = null;
$playerName = cleanName($row['player']);
if (!array_key_exists($playerName, $players)) {
$players[$playerName] = array();
}
$players[$playerName][$row['award']] = $row['count'];
}
pg_close($con);
echo json_encode($players);
<?php
include 'util.php';
$string = file_get_contents("../conf/conf.json");
$json_a = json_decode($string, true);
$host = $json_a['datasource']['host'];
$user = $json_a['datasource']['username'];
$pass = $json_a['datasource']['password'];
$db = $json_a['datasource']['database'];
$con = pg_connect("host={$host} dbname={$db} user={$user} password={$pass}") or die("Could not connect to server\n");
$table = $_GET['table'];
$query = "SELECT * FROM " . $table;
$rs = pg_query($con, $query) or die("Cannot execute query: {$query}\n");
$players = array();
//key: player, value: array -> key: award, value: count
while ($row = pg_fetch_row($rs)) {
$p = null;
$playerName = cleanName($row[0]);
$value = $row[1];
$players[$playerName] = $value;
}
pg_close($con);
echo json_encode($players);
<ul>
<li><a href="index.php">Home</a></li>
<li><a href="ChoosePublicationToView.php">View Publications</a></li>
<li><a href="importFile.php">Import Publication</a></li>
<li><a href="search.php">New Search</a></li>
<li>About</li>
<li><a href="SearchResultsViewAll.php"> View All </a></li>
<li><i>Viewer courtesy of BookBlock</i></li>
</ul>
<!--Banner and navigation bar !-->
</div>
<?php
if (!isset($_SESSION['SearchResults'])) {
//sanitize form data and find personId number
$cleanLastName = cleanName($_POST['lname']);
$cleanFirstName = cleanName($_POST['fname']);
$_SESSION['personId'] = findName($cleanLastName, $cleanFirstName, $pdo);
if ($_POST['PubName'] == 'All') {
$sql = $pdo->prepare("SELECT Page_PageId FROM PageInfo WHERE Person_PersonId=?");
$sql->execute(array($_SESSION['personId']));
$resultPageIds = $sql->fetchAll(PDO::FETCH_ASSOC);
$_SESSION['row_count'] = $sql->rowCount();
} else {
//find publication id
$sql = $pdo->prepare("SELECT PublicationId FROM Publication WHERE Name=?");
$sql->execute(array($_POST['PubName']));
$_SESSION['publicationId'] = $sql->fetchColumn();
$sql = $pdo->prepare("SELECT Page_PageId FROM PageInfo WHERE Person_PersonId=? && Publication_PublicationId=?");
$sql->execute(array($_SESSION['personId'], $_SESSION['publicationId']));
$resultPageIds = $sql->fetchAll(PDO::FETCH_ASSOC);
$_SESSION['row_count'] = $sql->rowCount();
<?php
$uNameErr = "";
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$newUname = $_POST["new_u_name"];
if (empty($_POST["new_u_name"])) {
$uNameErr = "Please enter a user name";
} else {
if (!preg_match("/^[a-zA-Z0-9]*\$/", $newUname)) {
$uNameErr = "Only letters and numbers allowed.";
} else {
if (nameExists($newUname)) {
$uNameErr = "That username is taken, please choose another.";
} else {
$newUname = cleanName($_POST["new_u_name"]);
insertHash($newUname);
}
}
}
}
/** checks to see if this new username is already in the database */
function nameExists($newUname)
{
global $servername, $username, $dbname, $password, $preid;
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} else {
$sql = "SELECT * FROM users WHERE u_username = \"" . $newUname . "\";";
