golden hour

/home/phakp/public_html/wp-content/plugins/books-papers/classes

File/Folder	Size	Actions
.gitkeep	0 B
article.php	1.49 KB
author.php	928 B
book.php	1.41 KB
bridge.php	91.72 KB
conference.php	1.4 KB
functions	-
item.php	311 B

Edit: bridge.php

<?php
class BNPP_Bridge //bridge class that contains dedicated functions
{
	var $dbAuthors;
	var $dbArticles;
	var $dbConferences;
	var $dbBooks;
	var $dbArticleAuthor;
	var $dbConferenceAuthor;
	var $dbBookAuthor;
	var $dbBookEditor;
	var $dbJournals;
	var $dbTags;
	var $dbArticleTag;
	var $dbConferenceTag;
	var $dbBookTag;

var $listDivision;

function __construct($dbAuthors, $dbArticles, $dbConferences, $dbBooks, $dbArticleAuthor, $dbConferenceAuthor, $dbBookAuthor, $dbBookEditor, $dbJournals, $dbTags, $dbArticleTag, $dbConferenceTag, $dbBookTag)
	{
		$this->dbAuthors = $dbAuthors;
		$this->dbArticles = $dbArticles;
		$this->dbConferences = $dbConferences;
		$this->dbBooks = $dbBooks;
		$this->dbArticleAuthor = $dbArticleAuthor;
		$this->dbConferenceAuthor = $dbConferenceAuthor;
		$this->dbBookAuthor = $dbBookAuthor;
		$this->dbBookEditor = $dbBookEditor;
		$this->dbJournals = $dbJournals;
		$this->dbTags = $dbTags;
		$this->dbArticleTag = $dbArticleTag;
		$this->dbConferenceTag = $dbConferenceTag;
		$this->dbBookTag = $dbBookTag;
	}

function alterTableCharSet() //changes tables charset
	{
		global $wpdb;
		$sql = "ALTER TABLE " . $this->dbAuthors . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbAuthors . " MODIFY last_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbAuthors . " MODIFY first_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbArticles . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbArticles . " MODIFY title TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbConferences . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbConferences . " MODIFY title TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbConferences . " MODIFY book_title TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBooks . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBooks . " MODIFY title TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBooks . " MODIFY publisher TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbArticleAuthor . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbArticleAuthor . " MODIFY author_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbConferenceAuthor . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbConferenceAuthor . " MODIFY author_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBookAuthor . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBookAuthor . " MODIFY author_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBookEditor . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbBookEditor . " MODIFY editor_name TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbJournals . " CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
		$sql = "ALTER TABLE " . $this->dbJournals . " MODIFY journal TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";
		$wpdb->query($sql);
	}

function createAdditionalTables() //calls private functions to create additional tables
	{
		$this->CreateTableAA();
		$this->CreateTableCA();
		$this->CreateTableBA();
		$this->CreateTableBE();
		$this->CreateTableJournal();
		$this->CreateTableTags();
		$this->CreateTableTA();
		$this->CreateTableTC();
		$this->CreateTableTB();
	}

private function CreateTableAA() //creates article-author relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbArticleAuthor'") != $this->dbArticleAuthor) 
		{
			$sql = "CREATE TABLE $this->dbArticleAuthor (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			author_id MEDIUMINT,
			author_name TINYTEXT,
			article_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}

private function CreateTableCA() //creates conference-author relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbConferenceAuthor'") != $this->dbConferenceAuthor) 
		{
			$sql = "CREATE TABLE $this->dbConferenceAuthor (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			author_id MEDIUMINT,
			author_name TINYTEXT,
			conference_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}

private function CreateTableBA() //creates book-author relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbBookAuthor'") != $this->dbBookAuthor) 
		{
			$sql = "CREATE TABLE $this->dbBookAuthor (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			author_id MEDIUMINT,
			author_name TINYTEXT,
			book_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}

private function CreateTableBE() //creates book-editor relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbBookEditor'") != $this->dbBookEditor) 
		{
			$sql = "CREATE TABLE $this->dbBookEditor (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			editor_id MEDIUMINT,
			editor_name TINYTEXT,
			book_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}

private function CreateTableJournal() //creates journal table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbJournals'") != $this->dbJournals) 
		{
			$sql = "CREATE TABLE $this->dbJournals (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			journal TINYTEXT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}
	
	private function CreateTableTags() //creates tags table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbTags'") != $this->dbTags) 
		{
			$sql = "CREATE TABLE $this->dbTags (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			tag TINYTEXT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}
	
	private function CreateTableTA() //creates tag-article relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbArticleTag'") != $this->dbArticleTag) 
		{
			$sql = "CREATE TABLE $this->dbArticleTag (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			article_id MEDIUMINT NOT NULL,
			tag_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}
	
	private function CreateTableTC() //creates tag-conference relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbConferenceTag'") != $this->dbConferenceTag) 
		{
			$sql = "CREATE TABLE $this->dbConferenceTag (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			conference_id MEDIUMINT NOT NULL,
			tag_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}
	
	private function CreateTableTB() //creates tag-book relation table
	{
		global $wpdb;
		if($wpdb->get_var("show tables like '$this->dbBookTag'") != $this->dbBookTag) 
		{
			$sql = "CREATE TABLE $this->dbBookTag (
			id MEDIUMINT NOT NULL AUTO_INCREMENT,
			book_id MEDIUMINT NOT NULL,
			tag_id MEDIUMINT NOT NULL,
			PRIMARY KEY (id)
			);";
			$wpdb->query($sql);
		}
	}

function addConference($title, $year, $pages, $doi, $url, $issn, $supp, $file, $date, $public, $arxiv, $bookTitle, $confPages, $char1, $char2, $char3) //adds conference data to table
	{
		$article = new BNPP_Conference($this->dbConferences);
		$article->title = $title;
		$article->year = $year;
		$article->pages = $pages;
		$article->doi = $doi;
		$article->url = $url;
		$article->issn = $issn;
		$article->supplementary = $supp;
		$article->fileLink = $file;
		$article->date = $date;
		$article->isPublic = $public;
		$article->arxiv = $arxiv;
		$article->bookTitle = $bookTitle;
		$article->confPages = $confPages;
		$article->char1 = $char1;
		$article->char2 = $char2;
		$article->char3 = $char3;
		$article->InsertConferenceInfo();
	}

function addBook($title, $year, $pages, $doi, $url, $issn, $supp, $file, $date, $public, $arxiv, $publisher, $chapter, $isbn, $char1, $char2, $char3) //adds book data to table
	{
		$article = new BNPP_Book($this->dbBooks);
		$article->title = $title;
		$article->year = $year;
		$article->pages = $pages;
		$article->doi = $doi;
		$article->url = $url;
		$article->issn = $issn;
		$article->supplementary = $supp;
		$article->fileLink = $file;
		$article->date = $date;
		$article->isPublic = $public;
		$article->arxiv = $arxiv;
		$article->publisher = $publisher;
		$article->chapter = $chapter;
		$article->isbn = $isbn;
		$article->char1 = $char1;
		$article->char2 = $char2;
		$article->char3 = $char3;
		$article->InsertBookInfo();
	}

private function fillArticleElement($ar) //creates one article cell for a list
	{
		global $wpdb;//$a_elem = str_replace('\&quot;',"",str_replace('"',"&quot;",$a_elem));
		$a_elem = "<span style='";
		if(get_option("bnpp_lstyle_value") != "") { $a_elem .= get_option("bnpp_lstyle_value"); }
		if(get_option("bnpp_custom_char1_name") != "" && !is_null($ar->char1)) { $a_elem .= get_option("bnpp_custom_char1_value"); }
		if(get_option("bnpp_custom_char2_name") != "" && !is_null($ar->char2)) { $a_elem .= get_option("bnpp_custom_char2_value"); }
		if(get_option("bnpp_custom_char3_name") != "" && !is_null($ar->char3)) { $a_elem .= get_option("bnpp_custom_char3_value"); }
		$a_elem .= "'>" . get_option('bnpp_article_list') . "</span><br>";
		while(preg_match('/{{(.*?)}}/',$a_elem,$matches))
		{
			$a_elem = str_replace($matches[0],$this->replaceOptionalContent($matches[1],$ar),$a_elem);
		}
		$a_elem = preg_replace('/\[title\]/',$ar->title,$a_elem);
		$a_elem = preg_replace('/\[year\]/',$ar->year,$a_elem);
		$a_elem = preg_replace('/\[pages\]/',$ar->pages,$a_elem);
		$a_elem = preg_replace('/\[doi\]/',$ar->doi,$a_elem);
		$a_elem = preg_replace('/\[url\]/',$ar->url,$a_elem);
		$a_elem = preg_replace('/\[issn\]/',$ar->issn,$a_elem);
		$a_elem = preg_replace('/\[supplementary\]/',$ar->supplementary,$a_elem);
		$a_elem = preg_replace('/\[filelink\]/',$ar->file_link,$a_elem);
		$a_elem = preg_replace('/\[date\]/',$ar->date,$a_elem);
		if($ar->volume != 0)
			$a_elem = preg_replace('/\[volume\]/',$ar->volume,$a_elem);
		else
			$a_elem = preg_replace('/\[volume\]/','',$a_elem);
		if($ar->issue != 0)
			$a_elem = preg_replace('/\[issue\]/',$ar->issue,$a_elem);
		else
			$a_elem = preg_replace('/\[issue\]/','',$a_elem);
		$a_elem = preg_replace('/\[arxiv\]/',$ar->arxiv,$a_elem);
		$a_elem_authors = "";
		try {
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbArticleAuthor . " WHERE article_id=%d", $ar->id)) as $a)
			{
				if(!is_null($a->author_id))
				{
					foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbAuthors . " WHERE id=%d", $a->author_id)) as $au)
					{
						$a_elem_authors .= "$au->first_name  $au->last_name, ";
					}
				} else {
					$a_elem_authors .= "$a->author_name, ";
				}
			}
			$a_elem_authors = substr($a_elem_authors, 0, -2);
			$a_elem = preg_replace('/\[authors\]/',$a_elem_authors,$a_elem);
			$a_elem_tags = "";
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbArticleTag . " WHERE article_id=%d", $ar->id)) as $a)
			{
				foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbTags . " WHERE id=%d", $a->tag_id)) as $au)
				{
					$a_elem_tags .= "$au->tag; ";
				}
			}
			$a_elem_tags = substr($a_elem_tags, 0, -2);
			$a_elem = preg_replace('/\[tags\]/',$a_elem_tags,$a_elem);
			$a_elem_journal = "";
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbJournals . " WHERE id=%d", $ar->journal)) as $j)
			{
				$a_elem_journal .= $j->journal;
			}
		} catch (Exception $e) {}
		$a_elem = preg_replace('/\[journal\]/',$a_elem_journal,$a_elem);
		$a_elem = str_replace('&quot;','',$a_elem);
		//$a_elem = str_replace('\&quot;',"",str_replace('"',"&quot;",$a_elem));
		if(get_option('bnpp_ordered_list')=='checked')
		{
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $ar->year)
					{
						$this->listDivision = $ar->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$ar->year</h3><li>" . $a_elem . "</li>";
					} else {
						return "<li>" . $a_elem . "</li>";
					}
				case "title":
					if($this->listDivision != $ar->title)
					{
						$this->listDivision = $ar->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$ar->title</h3><li>" . $a_elem . "</li>";
					} else {
						return "<li>" . $a_elem . "</li>";
					}
				case "journal":
					if($this->listDivision != $ar->journal)
					{
						$this->listDivision = $ar->journal;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$a_elem_journal</h3><li>" . $a_elem . "</li>";
					}
				default:
					return "<li>" . $a_elem . "</li>";
					break;
			}
		} else {
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $ar->year)
					{
						$this->listDivision = $ar->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$ar->year</h3>" . $a_elem;
					} else {
						return $a_elem;
					}
				case "title":
					if($this->listDivision != $ar->title)
					{
						$this->listDivision = $ar->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$ar->title</h3>" . $a_elem;
					} else {
						return $a_elem;
					}
				case "journal":
					if($this->listDivision != $ar->journal)
					{
						$this->listDivision = $ar->journal;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$a_elem_journal</h3>" . $a_elem;
					}
				default:
					return $a_elem;
					break;
			}
		}
	}

private function fillConferenceElement($co) //creates one conference cell for a list
	{
		global $wpdb;
		$c_elem = "<span style='";
		if(get_option("bnpp_lstyle_value") != "") { $c_elem .= get_option("bnpp_lstyle_value"); }
		if(get_option("bnpp_custom_char1_name") != "" && !is_null($co->char1)) { $c_elem .= get_option("bnpp_custom_char1_value"); }
		if(get_option("bnpp_custom_char2_name") != "" && !is_null($co->char2)) { $c_elem .= get_option("bnpp_custom_char2_value"); }
		if(get_option("bnpp_custom_char3_name") != "" && !is_null($co->char3)) { $c_elem .= get_option("bnpp_custom_char3_value"); }
		$c_elem .= "'>" . get_option('bnpp_conference_list') . "</span><br>";
		while(preg_match('/{{(.*?)}}/',$c_elem,$matches))
		{
			$c_elem = str_replace($matches[0],$this->replaceOptionalContent($matches[1],$co),$c_elem);
		}
		$c_elem = preg_replace('/\[title\]/',$co->title,$c_elem);
		$c_elem = preg_replace('/\[year\]/',$co->year,$c_elem);
		$c_elem = preg_replace('/\[pages\]/',$co->pages,$c_elem);
		$c_elem = preg_replace('/\[doi\]/',$co->doi,$c_elem);
		$c_elem = preg_replace('/\[url\]/',$co->url,$c_elem);
		$c_elem = preg_replace('/\[issn\]/',$co->issn,$c_elem);
		$c_elem = preg_replace('/\[supplementary\]/',$co->supplementary,$c_elem);
		$c_elem = preg_replace('/\[filelink\]/',$co->file_link,$c_elem);
		$c_elem = preg_replace('/\[date\]/',$co->date,$c_elem);
		$c_elem = preg_replace('/\[booktitle\]/',$co->book_title,$c_elem);
		$c_elem = preg_replace('/\[confpages\]/',$co->conf_page,$c_elem);
		$c_elem = preg_replace('/\[arxiv\]/',$co->arxiv,$c_elem);
		$c_elem_authors = "";
		try {
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbConferenceAuthor . " WHERE conference_id=%d", $co->id)) as $c)
			{
				if(!is_null($c->author_id))
				{
					foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbAuthors . " WHERE id=%d", $c->author_id)) as $au)
					{
						$c_elem_authors .= "$au->first_name  $au->last_name, ";
					}
				} else {
					$c_elem_authors .= "$c->author_name, ";
				}
			}
			$c_elem_authors = substr($c_elem_authors, 0, -2);
			$c_elem_tags = "";
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbConferenceTag . " WHERE conference_id=%d", $co->id)) as $c)
			{
				foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbTags . " WHERE id=%d", $c->tag_id)) as $au)
				{
					$c_elem_tags .= "$au->tag; ";
				}
			}
			$c_elem_tags = substr($c_elem_tags, 0, -2);
			$c_elem = preg_replace('/\[tags\]/',$c_elem_tags,$c_elem);
		} catch (Exception $e) {}
		$c_elem = preg_replace('/\[authors\]/',$c_elem_authors,$c_elem);
		$c_elem = str_replace('&quot;','',$c_elem);
		//$c_elem = str_replace('\&quot;',"",str_replace('"',"&quot;",$c_elem));
		if(get_option('bnpp_ordered_list')=='checked')
		{
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $co->year)
					{
						$this->listDivision = $co->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->year</h3><li>" . $c_elem . "</li>";
					} else {
						return "<li>" . $c_elem . "</li>";
					}
				case "title":
					if($this->listDivision != $co->title)
					{
						$this->listDivision = $co->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->title</h3><li>" . $c_elem . "</li>";
					} else {
						return "<li>" . $c_elem . "</li>";
					}
				case "book_title":
					if($this->listDivision != $co->book_title)
					{
						$this->listDivision = $co->book_title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->book_title</h3><li>" . $c_elem . "</li>";
					}
				default:
					return "<li>" . $c_elem . "</li>";
					break;
			}
		} else {
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $co->year)
					{
						$this->listDivision = $co->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->year</h3>" . $c_elem;
					} else {
						return $c_elem;
					}
				case "title":
					if($this->listDivision != $co->title)
					{
						$this->listDivision = $co->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->title</h3>" . $c_elem;
					} else {
						return $c_elem;
					}
				case "book_title":
					if($this->listDivision != $co->book_title)
					{
						$this->listDivision = $co->book_title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$co->book_title</h3>" . $c_elem;
					}
				default:
					return $c_elem;
					break;
			}
		}
	}

private function fillBookElement($bo) //creates one book cell for a list
	{
		global $wpdb;
		$b_elem = "<span style='";
		if(get_option("bnpp_lstyle_value") != "") { $b_elem .= get_option("bnpp_lstyle_value"); }
		if(get_option("bnpp_custom_char1_name") != "" && !is_null($bo->char1)) { $b_elem .= get_option("bnpp_custom_char1_value"); }
		if(get_option("bnpp_custom_char2_name") != "" && !is_null($bo->char2)) { $b_elem .= get_option("bnpp_custom_char2_value"); }
		if(get_option("bnpp_custom_char3_name") != "" && !is_null($bo->char3)) { $b_elem .= get_option("bnpp_custom_char3_value"); }
		$b_elem .= "'>" . get_option('bnpp_book_list') . "</span><br>";
		while(preg_match('/{{(.*?)}}/',$b_elem,$matches))
		{
			$b_elem = str_replace($matches[0],$this->replaceOptionalContent($matches[1],$bo),$b_elem);
		}
		$b_elem = preg_replace('/\[title\]/',$bo->title,$b_elem);
		$b_elem = preg_replace('/\[year\]/',$bo->year,$b_elem);
		$b_elem = preg_replace('/\[pages\]/',$bo->pages,$b_elem);
		$b_elem = preg_replace('/\[doi\]/',$bo->doi,$b_elem);
		$b_elem = preg_replace('/\[url\]/',$bo->url,$b_elem);
		$b_elem = preg_replace('/\[issn\]/',$bo->issn,$b_elem);
		$b_elem = preg_replace('/\[supplementary\]/',$bo->supplementary,$b_elem);
		$b_elem = preg_replace('/\[filelink\]/',$bo->file_link,$b_elem);
		$b_elem = preg_replace('/\[date\]/',$bo->date,$b_elem);
		$b_elem = preg_replace('/\[publisher\]/',$bo->publisher,$b_elem);
		$b_elem = preg_replace('/\[chapter\]/',$bo->chapter,$b_elem);
		$b_elem = preg_replace('/\[isbn\]/',$bo->isbn,$b_elem);
		$b_elem = preg_replace('/\[arxiv\]/',$bo->arxiv,$b_elem);
		$b_elem_authors = "";
		try{
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbBookAuthor . " WHERE book_id=%d", $bo->id)) as $a)
			{
				if(!is_null($a->author_id))
				{
					foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbAuthors . " WHERE id=%d", $a->author_id)) as $au)
					{
						$b_elem_authors .= "$au->first_name  $au->last_name, ";
					}
				} else {
					$b_elem_authors .= "$a->author_name, ";
				}
			}
			$b_elem_authors = substr($b_elem_authors, 0, -2);
			$b_elem = preg_replace('/\[authors\]/',$b_elem_authors,$b_elem);
			$b_elem_editors = "";
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbBookEditor . " WHERE book_id=%d", $bo->id)) as $a)
			{
				if(!is_null($a->editor_id))
				{
					foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbAuthors . " WHERE id=%d", $a->editor_id)) as $au)
					{
						$b_elem_editors .= "$au->first_name $au->last_name, ";
					}
				} else {
					$b_elem_editors .= "$a->editor_name, ";
				}
			}
			$b_elem_editors = substr($b_elem_editors, 0, -2);
			$b_elem_tags = "";
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbBookTag . " WHERE book_id=%d", $bo->id)) as $a)
			{
				foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbTags . " WHERE id=%d", $a->tag_id)) as $au)
				{
					$b_elem_tags .= "$au->tag; ";
				}
			}
			$b_elem_tags = substr($b_elem_tags, 0, -2);
			$b_elem = preg_replace('/\[tags\]/',$b_elem_tags,$b_elem);
		} catch (Exception $e) {}
		$b_elem = preg_replace('/\[editors\]/',$b_elem_editors,$b_elem);
		$b_elem = str_replace('&quot;','',$b_elem);
		//$b_elem = str_replace('\&quot;',"",str_replace('"',"&quot;",$b_elem));
		if(get_option('bnpp_ordered_list')=='checked')
		{
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $bo->year)
					{
						$this->listDivision = $bo->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->year</h3><li>" . $b_elem . "</li>";
					} else {
						return "<li>" . $b_elem . "</li>";
					}
				case "title":
					if($this->listDivision != $bo->title)
					{
						$this->listDivision = $bo->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->title</h3><li>" . $b_elem . "</li>";
					} else {
						return "<li>" . $b_elem . "</li>";
					}
				case "publisher":
					if($this->listDivision != $bo->publisher)
					{
						$this->listDivision = $bo->publisher;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->publisher</h3><li>" . $b_elem . "</li>";
					}
				default:
					return "<li>" . $b_elem . "</li>";
					break;
			}
		} else {
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $bo->year)
					{
						$this->listDivision = $bo->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->year</h3>" . $b_elem;
					} else {
						return $b_elem;
					}
				case "title":
					if($this->listDivision != $bo->title)
					{
						$this->listDivision = $bo->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->title</h3>" . $b_elem;
					} else {
						return $b_elem;
					}
				case "publisher":
					if($this->listDivision != $bo->publisher)
					{
						$this->listDivision = $bo->publisher;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$bo->publisher</h3>" . $b_elem;
					}
				default:
					return $b_elem;
					break;
			}
		}
	}
	
	private function fillMixedElement($pub) //creates one article cell for a list
	{
		global $wpdb;
		$p_elem = "<span style='";
		if(get_option("bnpp_lstyle_value") != "") { $p_elem .= get_option("bnpp_lstyle_value"); }
		if(get_option("bnpp_custom_char1_name") != "" && !is_null($pub->char1)) { $p_elem .= get_option("bnpp_custom_char1_value"); }
		if(get_option("bnpp_custom_char2_name") != "" && !is_null($pub->char2)) { $p_elem .= get_option("bnpp_custom_char2_value"); }
		if(get_option("bnpp_custom_char3_name") != "" && !is_null($pub->char3)) { $p_elem .= get_option("bnpp_custom_char3_value"); }
		$p_elem .= "'>" . get_option('bnpp_article_list') . "</span><br>";
		while(preg_match('/{{(.*?)}}/',$p_elem,$matches))
		{
			$p_elem = str_replace($matches[0],$this->replaceOptionalContent($matches[1],$pub),$p_elem);
		}
		$p_elem = preg_replace('/\[title\]/',$pub->title,$p_elem);
		$p_elem = preg_replace('/\[year\]/',$pub->year,$p_elem);
		$p_elem = preg_replace('/\[pages\]/',$pub->pages,$p_elem);
		$p_elem = preg_replace('/\[doi\]/',$pub->doi,$p_elem);
		$p_elem = preg_replace('/\[url\]/',$pub->url,$p_elem);
		$p_elem = preg_replace('/\[issn\]/',$pub->issn,$p_elem);
		$p_elem = preg_replace('/\[supplementary\]/',$pub->supplementary,$p_elem);
		$p_elem = preg_replace('/\[filelink\]/',$pub->file_link,$p_elem);
		$p_elem = preg_replace('/\[date\]/',$pub->date,$p_elem);
		$p_elem = preg_replace('/\[arxiv\]/',$pub->arxiv,$p_elem);
		$p_elem_authors = "";
		$p_elem_tags = "";
		try {
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . ($pub->type == "ar" ? $this->dbArticleAuthor : ($pub->type == "co" ? $this->dbConferenceAuthor : $this->dbBookAuthor)) . " WHERE article_id=%d", $pub->id)) as $a)
			{
				if(!is_null($a->author_id))
				{
					foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbAuthors . " WHERE id=%d", $a->author_id)) as $au)
					{
						$p_elem_authors .= "$au->first_name  $au->last_name, ";
					}
				} else {
					$p_elem_authors .= "$a->author_name, ";
				}
			}
			$p_elem_authors = substr($p_elem_authors, 0, -2);
			$p_elem = preg_replace('/\[authors\]/',$p_elem_authors,$p_elem);
			foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . ($pub->type == "ar" ? $this->dbArticleTag : ($pub->type == "co" ? $this->dbConferenceTag : $this->dbBookTag)) . " WHERE article_id=%d", $pub->id)) as $a)
			{
				foreach($wpdb->get_results($wpdb->prepare("SELECT * FROM " . $this->dbTags . " WHERE id=%d", $a->tag_id)) as $au)
				{
					$p_elem_tags .= "$au->tag; ";
				}
			}
			$p_elem_tags = substr($p_elem_tags, 0, -2);
			$p_elem = preg_replace('/\[tags\]/',$p_elem_tags,$p_elem);
		} catch (Exception $e) {}
		$p_elem = str_replace('&quot;','',$p_elem);
		if(get_option('bnpp_ordered_list')=='checked')
		{
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $pub->year)
					{
						$this->listDivision = $pub->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$pub->year</h3><li>" . $p_elem . "</li>";
					} else {
						return "<li>" . $p_elem . "</li>";
					}
				case "title":
					if($this->listDivision != $pub->title)
					{
						$this->listDivision = $pub->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$pub->title</h3><li>" . $p_elem . "</li>";
					} else {
						return "<li>" . $p_elem . "</li>";
					}
				default:
					return "<li>" . $p_elem . "</li>";
					break;
			}
		} else {
			switch(get_option('bnpp_list_division'))
			{
				case "year":
					if($this->listDivision != $pub->year)
					{
						$this->listDivision = $pub->year;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$pub->year</h3>" . $p_elem;
					} else {
						return $p_elem;
					}
				case "title":
					if($this->listDivision != $pub->title)
					{
						$this->listDivision = $pub->title;
						return "<h3 style='".get_option('bnpp_list_division_style')."'>$pub->title</h3>" . $p_elem;
					} else {
						return $p_elem;
					}
				default:
					return $p_elem;
					break;
			}
		}
	}

function replaceAuthorName($content) //replaces author name by criteria
	{
		global $wpdb;
		//compatibility options
		if (get_option('bnpp_comp_auth')) {
		if(!get_option('bnpp_drop_db_tables'))
		{
			$p_url = get_page_link();
			$author = "";
			$criteria = "";
			try{
				foreach($wpdb->get_results("SELECT * FROM " . $this->dbAuthors) as $au)
				{
					if($au->personal_url != "" && ($au->personal_url . "/" != $p_url) && ($au->personal_url != $p_url))
					{
						$author = '<a href="' . $au->personal_url . '">' . $au->first_name . ' ' . $au->last_name . '</a>';
					} else 
					{
						$author = $au->first_name . ' ' . $au->last_name;
					}

$criteria = "$au->first_name $au->last_name"; // Name Surname
					$content = str_replace($criteria, $author, $content);

$criteria = "$au->first_name  $au->last_name"; // Name  Surname
					$content = str_replace($criteria, $author, $content);

/*$criteria = substr($au->first_name, 0, 1) . ". $au->last_name"; // N. Surname
				$content = str_replace($criteria, $author, $content);*/

$criteria = "$au->last_name, $au->first_name"; // Surname, Name
					$content = str_replace($criteria, $author, $content);

/*$criteria = "$au->last_name, " . substr($au->first_name, 0, 1) . "."; // Surname, N.
				$content = str_replace($criteria, $author, $content);*/
				}
			}catch (Exception $e) {}
		}
		}
		return $content;
	}