1 files changed, 77 insertions, 0 deletions
diff --git a/includes/copyrights_lib.php b/includes/copyrights_lib.php
new file mode 100644
index 0000000..ef8d1be
--- /dev/null
+++ b/includes/copyrights_lib.php
@@ -0,0 +1,77 @@
+<?php
+/**
+ * Copyright (c) 2004 bitweaver.org
+ * Copyright (c) 2003 tikwiki.org
+ * Copyright (c) 2002-2003, Luis Argerich, Garland Foster, Eduardo Polidor, et. al.
+ * All Rights Reserved. See below for details and a complete list of authors.
+ * Licensed under the GNU LESSER GENERAL PUBLIC LICENSE. See http://www.gnu.org/copyleft/lesser.html for details
+ *
+ * @package wiki
+ */
+
+/**
+ * @package wiki
+ * @subpackage CopyrightsLib
+ */
+class CopyrightsLib extends BitBase {
+	function list_copyrights( $pPageId ) {
+		$query = "select * from `".BIT_DB_PREFIX."liberty_copyrights` WHERE `page_id`=? order by ".$this->mDb->convertSortmode( "copyright_order_asc" );
+		$query_cant = "select count(*) from `".BIT_DB_PREFIX."liberty_copyrights` WHERE `page_id`=?";
+		$result = $this->mDb->query($query, array( $pPageId ));
+		$cant = $this->mDb->getOne($query_cant, array( $pPageId ));
+		$ret = array();
+		while ($res = $result->fetchRow()) {
+			$ret[] = $res;
+		}
+		$retval = array();
+		$retval["data"] = $ret;
+		$retval["cant"] = $cant;
+		return $retval;
+	}
+	function top_copyright_order( $pPageId ) {
+		$query = "select MAX(`copyright_order`) from `".BIT_DB_PREFIX."liberty_copyrights` where `page_id` = ?";
+		return $this->mDb->getOne($query, array( $pPageId ));
+	}
+	function unique_copyright( $pPageId , $title) {
+		$query = "select `copyrightID` from `".BIT_DB_PREFIX."liberty_copyrights` where `page_id`=? and `title`=?";
+		return $this->mDb->getOne($query, array( $pPageId ,$title));
+	}
+	function add_copyright( $pPageId , $title, $year, $authors, $pUserId) {
+		//$unique = $this->unique_copyright( $pPageId ,$title);
+		//if($unique != 0) {
+		// security here?
+		//$this->edit_copyright($unique,$title,$year,$authors,$pUserId);
+		//return;
+		//}
+		$top = $this->top_copyright_order( $pPageId );
+		$order = $top + 1;
+		$query = "insert into `".BIT_DB_PREFIX."liberty_copyrights` (`page_id`, `title`, `copyright_year`, `authors`, `copyright_order`, `user_id`) values (?,?,?,?,?,?)";
+		$this->mDb->query($query,array( $pPageId ,$title,$year,$authors,$order,$pUserId));
+		return true;
+	}
+	function edit_copyright($id, $title, $year, $authors, $pUserId) {
+		$query = "update `".BIT_DB_PREFIX."liberty_copyrights` SET `copyright_year`=?, `title`=?, `authors`=?, `user_id`=? where `copyright_id`=?";
+		$this->mDb->query($query,array($year,$title,$authors,$pUserId,(int)$id));
+		return true;
+	}
+	function remove_copyright($id) {
+		$query = "delete from `".BIT_DB_PREFIX."liberty_copyrights` where `copyright_id`=?";
+		$this->mDb->query($query,array((int)$id));
+		return true;
+	}
+	function up_copyright($id) {
+		$query = "update `".BIT_DB_PREFIX."liberty_copyrights` set `copyright_order`=`copyright_order`-1 where `copyright_id`=?";
+		$result = $this->mDb->query($query,array((int)$id));
+		return true;
+	}
+	function down_copyright($id) {
+		$query = "update `".BIT_DB_PREFIX."liberty_copyrights` set `copyright_order`=`copyright_order`+1 where `copyright_id`=?";
+		$result = $this->mDb->query($query,array((int)$id));
+		return true;
+	}
+}
+
+global $copyrightslib;
+$copyrightslib = new CopyrightsLib();
+
+?>