$binData"; //exit; } function abstract_rank( $ranking ) { // $ranking = array( [abstract_id, ranker_id, ranking_ip, ranking_value] ) $db = db_connect(); $ranking = pg_convert($db, "rankings", $ranking); $abstract_id = $ranking["abstract_id"]; $ranking_ip = $ranking["ranking_ip"]; $ranker_id = $ranking["ranker_id"]; $ranking_value = $ranking["ranking_value"]; pg_query("begin") or db_die( "abstract_rank" ); $rv = pg_query( "update rankings set ranking_value = $ranking_value where abstract_id = $abstract_id and ranker_id = $ranker_id"); if ( ! pg_affected_rows($rv) ) { $rv = pg_query( "insert into rankings ( abstract_id, ranking_ip, ranker_id, ranking_value ) values ( $abstract_id, $ranking_ip, $ranker_id, $ranking_value )"); } pg_query("commit") or db_die( "abstract_rank" ); db_disconnect($db); return TRUE; } function last_changed_timestamp( $table ) { $db = db_connect(); $table = pg_escape_string( $table ); $sql = "select date_part('epoch',table_timestamp) as table_timestamp from last_changed where table_name = '$table'"; $result = pg_query($db, $sql) or db_die( "last_changed_timestamp" ); if (!$result) db_die("last_changed_timestamp"); $rv = pg_fetch_result($result, 0, 0); db_disconnect($db); return $rv; } function abstract_id_query($query) { $sql = "select abstract_id from abstracts where abstract_tsearch @@ to_tsquery('$query')"; $db = db_connect(); $result = pg_query($db, $sql) or db_die( "abstract_id_query" ); if (!$result) db_die("abstract_id_query_result"); $rv = array(); while ( $row = pg_fetch_assoc($result) ) { array_push($rv, $row["abstract_id"]); } db_disconnect($db); return $rv; } function print_abstract_ranks_full($result) { $i = 0; print "
| " . $i . " | "; print "ID:" . $r["abstract_id"] . " | "; print "" . $r["abstract_title"] . " | "; print "
|---|---|---|
| "; print $r["ranking"] . " / " . $r["interest"] . " / " . $r["interest_pct"] . " / " . $r["interest_high_pct"]; print " | "; print ""; print $r["presenter"] . ", " . $r["presenter_organization"]; print " | "; print "|
| "; print nl2br($r["abstract_description"]); print " | ||
| # | ID | R/I/% | Title | Presenter |
|---|---|---|---|---|
| $i | "; print "" . $r["abstract_id"] . " | "; print "" . $r["ranking"] . "/" . $r["interest"] . "/" . $r["interest_pct"] . "/" . $r["interest_high_pct"] . " | "; print "" . $r["abstract_title"] . " | "; print "" . $r["presenter"] . ", " . $r["presenter_organization"] . " | "; print "
Explanation of numbers: First number ('ranking') is sum(scores). Second number ('interest') is sum(scores>0?1:0). Third number ('interest percent') is # of non-zero votes for this abstract divided by total number of votes recorded for all abstracts. Fourth number ('high interest percent') is # of 2 votes for this abstract compared to the # of 1 votes for this abstract.
"; return TRUE; } function print_abstract_ranks_tsv($result) { print "rank\tabstract_id\tranking\tinterest\tinterest_pct\tinterest_high_pct\tabstract_title\tpresenter_name\tpresenter_organization\turl\n"; $i = 0; while ( $r = pg_fetch_assoc($result) ) { $i++; print $i . "\t"; print $r["abstract_id"] . "\t"; print $r["ranking"] . "\t"; print $r["interest"] . "\t"; print $r["interest_pct"] . "\t"; print $r["interest_high_pct"] . "\t"; print $r["abstract_title"] . "\t"; print $r["presenter"] . "\t"; print $r["presenter_organization"] . "\t"; print "http://www.foss4g2007.org/presentations/view.php?abstract_id=" . $r["abstract_id"] . "\n"; } return TRUE; } function abstract_list_session( $session ) { $db = db_connect(); $session = pg_escape_string( $session ); //$sql = "SELECT abstract_id, abstract_title, abstract_description, ranking_value FROM abstracts LEFT JOIN (SELECT ranking_value, abstract_id FROM rankings WHERE ranker_id = '$session') as rankings USING ( abstract_id ) WHERE abstract_status = 2 ORDER BY abstract_timestamp"; $sql = "SELECT distinct on (abstract_id) abstract_id, abstract_title, substr(abstract_description, 1, 512) || ' ...' as abstract_description, abstract_description as abstract_content, ranking_value, presenter_first_name, presenter_last_name, presenter_organization, presenter_department FROM abstracts LEFT JOIN (SELECT ranking_value, abstract_id FROM rankings WHERE ranker_id = '$session') as rankings USING ( abstract_id ) left join (SELECT * FROM presenters ORDER BY presenter_id) as presenters using (abstract_id) WHERE abstract_status = 1; "; $result = pg_query($db, $sql) or db_die( "abstract_array_query" ); if (!$result) db_die("abstract_array_result"); $rv = array(); while ( $row = pg_fetch_assoc($result) ) { array_push($rv, $row); } db_disconnect($db); return $rv; } function abstract_get( $abstract_id, $session ) { $db = db_connect(); $rv = array(); $abstract_id = pg_escape_string( $abstract_id ); $session = pg_escape_string($session); $sql = "SELECT * FROM abstracts where abstract_id = '$abstract_id'"; $result = pg_query($db, $sql) or db_die( "abstract_get_query" ); if ($result) $rv["abstract"] = pg_fetch_assoc($result, 0); else return FALSE; $sql = "SELECT * FROM presenters where abstract_id = '$abstract_id' order by presenter_id"; $result = pg_query($db, $sql) or db_die( "abstract_get_query" ); $presenters = array(); if ($result) { while ( $row = pg_fetch_assoc($result) ) { array_push($presenters, $row); } } $rv["presenters"] = $presenters; $sql = "SELECT * FROM rankings where abstract_id = '$abstract_id' and ranker_id = '$session'"; $result = pg_query($db, $sql) or db_die( "abstract_get_query_3" ); if ($result && pg_num_rows($result) > 0) $rv["ranking"] = pg_fetch_assoc($result, 0); else $rv["ranking"] = FALSE; db_disconnect($db); return $rv; } function session_sort( $a, $b ) { global $global_session; $a = md5($global_session + $a["abstract_id"]); $b = md5($global_session + $b["abstract_id"]); if( $a == $b ) { return 0; } return ($a < $b) ? -1 : 1; } function html_abstract_list( $session ) { global $global_session; $global_session = $session; $abstracts = abstract_list_session( $session ); usort($abstracts, "session_sort"); $count = 0; $rankcount = 0; $ids = array(); foreach ( $abstracts as $a ) { $count++; if ( $a["ranking_value"] > 0 ) { $rankcount++; } $alternate = $count % 2; $abstract_id = $a["abstract_id"]; array_push($ids, $abstract_id); print "\n"; print "" . $a["abstract_description"] . "
\n"; print "" . nl2br($a["abstract"]["abstract_description"]) . "
\n"; } function html_abstracts_accepted($where) { //$abstracts = abstract_list("WHERE abstract_status = 3 ORDER BY abstract_timestamp"); $abstracts = abstract_list("WHERE $where ORDER BY ranking DESC"); print "![](\"${i}_${j}.png\")
\n";
}
}
function session_get() {
if( isset( $_COOKIE["ranksession"] ) ) {
return $_COOKIE["ranksession"];
}
if( isset( $_GET["ranksession"] ) ) {
$session = $_GET["ranksession"];
setcookie( "ranksession", $session, time() + 365 * 24 * 60 * 60 );
return $session;
}
return FALSE;
}
?>