'" .$_SERVER['REMOTE_ADDR'] . "', " . count($persons) . ")");
$ssid = mysql_insert_id();
}
$t = new Smarty();
$t->assign('query', $query);
$t->assign('ssid', $ssid);
$p = array();
for ($i = 0; $i < count($persons); $i++) {
$person = array(
'id' => $persons[$i]->id,
'tiny_img_url' => $persons[$i]->getTinyImgUrl(),
'display_name' => $persons[$i]->displayName,
'party_name' => getPartyNameForId($persons[$i]->getFact('party')),
'history_snippet' => $persons[$i]->getHistorySnippet()
);
$p[] = $person;
}
$t->assign('persons', $p);
if (trim($_GET['d']) == 'true') {
$declarations = searchDeclarations($query);
$t->assign('declarations', $declarations);
$t->assign('searched_declarations', true);
} else {
$t->assign('searched_declarations', false);
}
/**
* Tests whether there are values in the URL for the party percentage or
* votes. If that is true, it simulates the elections system and then
* it prints the people that would get elected.
* @return {boolean} True if an election was simulated, false otherwise.
* This will be used to decide whether we will still display all the
* candidates or just the elected ones.
*/
function maybeDisplaySimulationResults()
{
global $_GET;
global $VOT_PRESENCE;
$v = getSimulationSystemValuesFromGet();
if ($v != null) {
$seats = simulateDHondtSystem($v);
echo "Cu aceste procente și o prezență generală la vot " . "de {$VOT_PRESENCE}%, aceștia ar fi europarlamentarii:";
echo "<table cellspacing=5><tr bgcolor=\"#EEEEEE\"><td></td>" . "<td>Nume</td>";
echo "<td></td><td></td><td></td><td></td>" . "<td>Partid</td>";
$count = 1;
foreach ($seats as $p => $v) {
$idparty = substr($p, 1);
switch ($idparty) {
case "a":
$idparty = "10 AND e.idperson=3336 ";
break;
case "b":
$idparty = "10 AND e.idperson=3335 ";
break;
}
$s = mysql_query("SELECT e.name, e.idperson, e.occupation, e.birthday, " . "p.name as pname, h4.what as wh4, " . "h1.what as wh1, h2.what as wh2, h3.what as wh3 " . "FROM euro_2009_candidates AS e " . "LEFT JOIN parties AS p ON p.id = e.idparty " . "LEFT JOIN people_history AS h1 " . "ON e.idperson = h1.idperson AND h1.what='catavencu/2008' " . "LEFT JOIN people_history AS h2 " . "ON e.idperson = h2.idperson AND h2.what='results/2008' " . "LEFT JOIN people_history AS h3 " . "ON e.idperson = h3.idperson AND h3.what='euro_parliament/2007' " . "LEFT JOIN people_history AS h4 " . "ON e.idperson = h4.idperson AND h4.what='qvorum/2009' " . "WHERE idparty={$idparty} " . "ORDER BY position ASC " . "LIMIT 0, {$seats[$p]}");
if ($idparty != "10 AND e.idperson=3336 " && $idparty != "10 AND e.idperson=3335 ") {
echo "<tr bgcolor=#FAFAFA>";
echo "<td colspan=7 align=center>" . getPartyNameForId($idparty) . " - {$seats[$p]} locuri</td>";
}
while ($r = mysql_fetch_array($s)) {
echo "<tr>";
echo "<td align=right>" . $count++ . "</td>";
$name = moveFirstNameLast(ucwords(strtolower_ro($r['name'])));
echo "<td><a href=\"?name=" . urlencode($name) . "&cid=9&id={$r['idperson']}\">{$name}</a>";
$age = round((time() * 1000 - $r['birthday']) / (1000 * 60 * 60 * 24 * 365));
echo ", {$age} ani";
$idperson = $r['idperson'];
echo "</td>";
echo "<td align=right>" . getIconHtml($r['wh1'], $idperson) . "</td>";
echo "<td align=right>" . getIconHtml($r['wh2'], $idperson) . "</td>";
echo "<td align=right>" . getIconHtml($r['wh3'], $idperson) . "</td>";
echo "<td align=right>" . getIconHtml($r['wh4'], $idperson) . "</td>";
//echo "<td><span class=\"small gray\">{$r['occupation']}</span></td>";
echo "<td>{$r['pname']}</td>";
}
}
echo "</table>";
return true;
}
return false;
}
// And now here I should put some content, like something about the elections,
// some stats, some news, something like that.
if ($query && $restrict != "cs") {
$persons = search($query);
}
if ($query != "") {
// add it to the database
mysql_query("INSERT INTO log_searches(query, time, ip, num_results)\n VALUES('" . mysql_real_escape_string($query) . "', " . time() . ",\n '" . $_SERVER['REMOTE_ADDR'] . "', " . count($persons) . ")");
$ssid = mysql_insert_id();
}
$t = new Smarty();
$t->assign('query', $query);
$t->assign('ssid', $ssid);
$p = array();
for ($i = 0; $i < count($persons); $i++) {
$person = array('id' => $persons[$i]->id, 'tiny_img_url' => $persons[$i]->getTinyImgUrl(), 'display_name' => $persons[$i]->displayName, 'party_name' => getPartyNameForId($persons[$i]->getFact('party')), 'history_snippet' => $persons[$i]->getHistorySnippet());
$p[] = $person;
}
$show_people = count($p) > 0;
$t->assign('persons', $p);
if (trim($_GET['d']) == 'true') {
$declarations = searchDeclarations($query);
$t->assign('declarations', $declarations);
$t->assign('searched_declarations', true);
$show_people = $show_people || count($declarations) > 0;
} else {
$t->assign('searched_declarations', false);
}
$colleges = getCollegeSearch($query);
$t->assign('colleges', $colleges);
$show_people = $show_people || count($colleges) == 0;
