$value){
if($value!=""){
$change=$change . "$key=$value&";
}
}//foreach($myarray as $key=>$value)
$change = perl_chop('?'.$change);
return $change;
}//function linker()
function perl_chop($string){
return substr($string,0,-1);
}
function get_images($fld){
$dir = '../images/gallery/' . $fld;
$hdl = opendir($dir);
while( false !== ($img = readdir($hdl)) ){
if( $img != '.' && $img != '..' ){
$imgs[] = $img;
}
}
closedir($hdl);
return $imgs;
}
/*********************************************************************
**********************************************************************
********************* Data Prep Functions **************************
**********************************************************************
*********************************************************************/
function display_ao(){
// display_event($data,$indent)
if(func_num_args() == 2){
$data = func_get_arg(0);
$indent = func_get_arg(1);
}
// display_event($data) !no indent
else{
$data = func_get_arg(0);
$indent = '';
}
if(empty($data['deadline'])){
$dl = "To Be Announced";
}
else{
$dl = preg_replace("/(\d{4})-(\d{2})-(\d{2})/","$2-$3-$1",$data['deadline']); // unchanged if no -'s
$dl = preg_replace("/(\d{4})(\d{2})(\d{2})/","$2-$3-$1",$dl);
$red = preg_replace("/(\d{2})-(\d{2})-(\d{4})/","$3$1$2",$dl);
//echo date('Ymd') . "' . $dl . ' \n" . $indent . " \n"; //Start a row
$m = "\n" . $indent . " \n" . $indent . " \n"; //between column
$e = $indent . " \n" . $indent . " \n"; //end a row
$des = (empty($data['description'])) ? "" : stripslashes(preg_replace("/\n/","" . stripslashes($data['title']) ." Deadline: " . $dl . "Description: " . $des . "Contact: ';
$html .= $indent . stripslashes($data['contact']) . " Phone: " . stripslashes($data['contact_phone']) . "Links: \n";
$html .= $indent . " \n";
}
$html .= $e;
return $html;
} // function display_ao()
function display_date($date){
return preg_replace("/(\d{4})(\d{2})(\d{2})/","$1-$2-$3",$date);
}
function display_index($data){
// Create the A-Z nav bar
$index = ""; // Current letter carrier
$j = 65; // ACSII index of capital A
$nav = ""; // variable to compile nav bar
for($i=0;$i' . $a . ' | ';
$index=$a;
$j++;
}
if( $a != chr($j) && $a != $index){
//$j++;
$d=chr($j);
$nav .= $d . ' | ';
$j++;
}
if($a == $index){
$i++;
}
if($j == 91) break;
}
// fill remaining letters to Z
while($j < 91){
$d=chr($j);
$nav .= $d . ' | ';
$j++;
}
//$nav .= chr(90);
$nav = substr($nav, 0, -3); //
return $nav;
}
function display_paper($row){
$jour = get_journal($row['journal_id']);
$html = '';
if(!empty($row['contrib_num'])){
$html .= ' Contribution Number: ' . $row['contrib_num'] .
' Edit/Update Authors: ' . stripslashes($row['authors']) . "Date: ' . stripslashes($row['date']) . "Title: ' . get_paper_title($row['title']) . "Journal: ' . stripslashes($jour['title']) . " Type: ' . $row['type'] . "Publication/Issue Title: ' . stripslashes($row['pub_title']) . "Volume: '. stripslashes($row['volume']) . " ";
}
if(!empty($row['volume']) && empty($row['pages'])){ // Volume non-empty and pages empty
$html .= ' Volume: '. stripslashes($row['volume']) . "Pages: ' . stripslashes($row['pages']) . "DOI Number: ' . stripslashes($row['doi']) . "Status: ' . stripslashes($row['status']) . "Link: PDF ' . "Contact Email: ' . $row['contact_email'] . ' ' . "' . $reg . ' \n" . $indent . " \n"; //Start a row
$m = "\n" . $indent . " \n" . $indent . " \n"; //between column
$e = $indent . " \n" . $indent . " \n"; //end a row
$html = $s;
$html .= (!empty($data['logo'])) ? $indent . ' What: " . stripslashes($data['title']) ."Where: " . stripslashes($data['location']) . "Starting: " . $start . "Ending: " . $end . "Reg. Deadline: " . $reg . "Description: " . $des . "Contact: ';
$html .= $indent . stripslashes($data['contact']) . " , " . stripslashes($data['contact_location']) . "Links: \n";
$html .= $indent . " \n";
}
$html .= $e;
return $html;
} // function display_event()
function generate_pagination($base_url, $num_items, $per_page, $start_item, $add_prevnext_text = TRUE){
$total_pages = ceil($num_items/$per_page);
if ( $total_pages == 1 ){
return '';
}
$on_page = floor($start_item / $per_page) + 1;
$page_string = '';
if ( $total_pages > 10 ){
$init_page_max = ( $total_pages > 3 ) ? 3 : $total_pages;
for($i = 1; $i < $init_page_max + 1; $i++){
$page_string .= ( $i == $on_page ) ? '' . $i . ' ' : '' . $i . ' ';
if ( $i < $init_page_max ){
$page_string .= ", ";
}
}
if ( $total_pages > 3 ){
if ( $on_page > 1 && $on_page < $total_pages ){
$page_string .= ( $on_page > 5 ) ? ' ... ' : ', ';
$init_page_min = ( $on_page > 4 ) ? $on_page : 5;
$init_page_max = ( $on_page < $total_pages - 4 ) ? $on_page : $total_pages - 4;
for($i = $init_page_min - 1; $i < $init_page_max + 2; $i++){
$page_string .= ($i == $on_page) ? '' . $i . ' ' : '' . $i . ' ';
if ( $i < $init_page_max + 1 ){
$page_string .= ', ';
}
}
$page_string .= ( $on_page < $total_pages - 4 ) ? ' ... ' : ', ';
}
else{
$page_string .= ' ... ';
}
for($i = $total_pages - 2; $i < $total_pages + 1; $i++){
$page_string .= ( $i == $on_page ) ? '' . $i . ' ' : '' . $i . ' ';
if( $i < $total_pages ){
$page_string .= ", ";
}
}
}
}
else{
for($i = 1; $i < $total_pages + 1; $i++){
$page_string .= ( $i == $on_page ) ? '' . $i . ' ' : '' . $i . ' ';
if ( $i < $total_pages ){
$page_string .= ', ';
}
}
}
if ( $add_prevnext_text ){
if ( $on_page > 1 ){
$page_string = ' Previous ' . $page_string;
}
if ( $on_page < $total_pages ){
$page_string .= ' Next ';
}
}
$page_string = 'Goto page ' . $page_string;
return $page_string;
} // function generate_pagination()
function get_journals(){
global $db;
if(func_num_args() == 2){
$id = func_get_arg(0);
$indent = func_get_arg(1);
}
else{
$id = func_get_arg(0);
$indent = '';
}
$query = "SELECT id,title FROM " . TABLE_JOURNALS . " ORDER BY title";
$result = $db->sql_query($query);
$html = '';
$jour[0] = "N/A";
$i = 1;
while($jrow = $db->sql_fetchrow($result)){
$jind[$i] = $jrow['id'];
$jour[$i] = $jrow['title'];
$i++;
}
$num=count($jour);
$html .= $indent . '' . "\n";
for($i=0;$i<$num;$i++){
if($jind[$i]!=$id){
$html .= $indent . " ".stripslashes($jour[$i])." \n";
}
else{
$html .= $indent . " ".stripslashes($jour[$i])." \n";
}
}
$html .= $indent . " \n";
return $html;
} // function get_journals()
function get_journal_title($id){
global $db;
if(!empty($id)){
$query = "SELECT title FROM journals WHERE id=" . $id;
$tmp = $db->sql_fetchrow($db->sql_query($query));
return $tmp[0];
}
return NULL;
}
function get_paper_title($title){
return stripslashes(preg_replace("/(.*), (A|An|The)$/","$2 $1",trim($title)));
}
function get_papers(){
global $db;
if(func_num_args() == 1){
$indent = func_get_arg(0);
}
else{
$indent = '';
}
$html = '';
$output = "title,contrib_num";
$tbname = TABLE_PAPERS;
$query = "SELECT $output FROM $tbname ORDER BY contrib_num";
$result = $db->sql_query($query);
$html .= $indent . '' . "\n";
$html .= $indent . ' -----Select One----- '."\n";
while($row = $db->sql_fetchrow($result)){
$title = get_paper_title($row[0]);
$html .= $indent . ' 50){
$title = substr($title,0,44) . " . . .";
}
$sel = (isset($_GET['ind']) && $_GET['ind']==$row[1]) ? 'selected ' : '';
$html .= $sel . 'value="' . $row[1] . '">' . $title . " \n";
} // while($row=mysql_fetch_row($result))
$html .= $indent . " \n";
return $html;
} // function get_papers()
function set_paper_title($title){
return preg_replace("/^(A|An|The) (.*)/","$2, $1",trim($title));
}
function sort_by($sort){
$html = '';
if($sort == "contrib_num"){
$html .= 'Contribution Number | ';
}
else{
$html .= 'Contibution Number | ';
}
if($sort == "authors"){
$html .= 'Authors | ';
}
else{
$html .= 'Authors | ';
}
if($sort == "title"){
$html .= 'Title | ';
}
else{
$html .= 'Title | ';
}
if($sort == "type"){
$html .= 'Type | ';
}
else{
$html .= 'Type | ';
}
if($sort == "journal_title"){
$html .= 'Journal | ';
}
else{
$html .= 'Journal | ';
}
$html .= 'Date: ';
if($sort == "date DESC"){
$html .= 'New-Old | ';
}
else{
$html .= 'New-Old | ';
}
if($sort == "date"){
$html .= 'Old-New ';
}
else{
$html .= 'Old-New ';
}
return $html;
}
/*********************************************************************
**********************************************************************
****************** Database Search Functions ***********************
**********************************************************************
*********************************************************************/
function get_next_free_contrib_num(){
global $db;
$query1 = "SELECT MAX(contrib_num) FROM " . TABLE_PAPERS . " WHERE contrib_num<337";
$tmp1 = $db->sql_fetchrow($db->sql_query($query1));
$query2 = "SELECT MAX(contrib_num) FROM " . TABLE_PAPERS_PURG . " WHERE contrib_num<337";
$tmp2 = $db->sql_fetchrow($db->sql_query($query2));
$ret = ($tmp1[0] > $tmp2[0]) ? $tmp1[0] : $tmp2[0];
if($ret >= 336){
$query3 = "SELECT MAX(contrib_num) FROM " . TABLE_PAPERS;
$tmp3 = $db->sql_fetchrow($db->sql_query($query3));
$query4 = "SELECT MAX(contrib_num) FROM " . TABLE_PAPERS_PURG;
$tmp4 = $db->sql_fetchrow($db->sql_query($query4));
$ret = ($tmp3[0] > $tmp4[0]) ? $tmp3[0] : $tmp4[0];
}
$ret++;
return $ret;
}
function get_journal($id){
global $db;
$query = "SELECT title,link FROM " . TABLE_JOURNALS . " WHERE id='" . $id . "'";
return $db->sql_fetchrow($db->sql_query($query));
}
function paper_where($q){
$tmp = ' WHERE (';
$terms = preg_split ("/(\s+|\+)/", $q);
$num = count($terms);
for($i=0;$i<$num;$i++){
$term = addslashes($terms[$i]);
if(is_numeric($term)){
$tmp .= "contrib_num=$term OR date=$term OR ";
}
else{
$tmp .= "title LIKE '%$term%' OR authors LIKE '%$term%' OR journal_title LIKE '%$term%' OR ";
}
}
return substr($tmp,0,-4).')'; // chop last ' OR ' off and add closing paren
}
/*********************************************************************
**********************************************************************
******************** Database Set Functions ************************
**********************************************************************
*********************************************************************/
/*********************************************************************
**********************************************************************
******************* Database Error Functions ***********************
**********************************************************************
*********************************************************************/
// Fix define("HAS_DIED", 1); so constant in double quotes
// January 11, 2012 rcg/ttw
function message_die($msg_code, $msg_text = '', $msg_title = '', $err_line = '', $err_file = '', $sql = '')
{
global $db;
if(defined('HAS_DIED')){
die("message_die() was called multiple times. This isn't supposed to happen. Was message_die() used in page_tail.php?");
}
define("HAS_DIED", 1);
$sql_store = $sql;
//
// Get SQL error if we are debugging. Do this as soon as possible to prevent
// subsequent queries from overwriting the status of sql_error()
//
if ( DEBUG && ( $msg_code == GENERAL_ERROR || $msg_code == CRITICAL_ERROR ) ) {
$sql_error = $db->sql_error();
$debug_text = '';
if ( $sql_error['message'] != '' ) {
$debug_text .= '' . 'Critical Error' . ' ';
}
break;
}
//
// Add on DEBUG info if we've enabled debug mode and this is an error. This
// prevents debug info being output for general messages should DEBUG be
// set TRUE by accident (preventing confusion for the end user!)
//
if ( DEBUG && ( $msg_code == GENERAL_ERROR || $msg_code == CRITICAL_ERROR ) ){
if ( $debug_text != '' ){
$msg_text = $msg_text . 'DEBUG MODE