1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
<?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
*/
namespace Bitweaver\Wiki;
use Bitweaver\BitBase;
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, [ $pPageId ] );
$cant = $this->mDb->getOne($query_cant, [ $pPageId ] );
$ret = [];
while ($res = $result->fetchRow()) {
$ret[] = $res;
}
$retval = [];
$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, [ $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, [ $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,[ $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,[ $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,[ (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,[ (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,[ (int)$id ] );
return true;
}
}
global $copyrightslib;
$copyrightslib = new CopyrightsLib();
|
