From: <pk...@us...> - 2011-11-30 21:20:45
|
Revision: 39060 http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=39060&view=rev Author: pkdille Date: 2011-11-30 21:20:39 +0000 (Wed, 30 Nov 2011) Log Message: ----------- No changes - code styling only (seen on quality.tiki.org) Modified Paths: -------------- trunk/lib/commcenter/commlib.php Modified: trunk/lib/commcenter/commlib.php =================================================================== --- trunk/lib/commcenter/commlib.php 2011-11-30 21:00:33 UTC (rev 39059) +++ trunk/lib/commcenter/commlib.php 2011-11-30 21:20:39 UTC (rev 39060) @@ -6,7 +6,7 @@ // $Id$ //this script may only be included - so its better to die if called directly. -if (strpos($_SERVER["SCRIPT_NAME"],basename(__FILE__)) !== false) { +if (strpos($_SERVER["SCRIPT_NAME"], basename(__FILE__)) !== false) { header("location: index.php"); exit; } @@ -14,20 +14,27 @@ class CommLib extends TikiLib { - function accept_page($receivedPageId) { + function accept_page($receivedPageId) + { $info = $this->get_received_page($receivedPageId); + if ($info['structureName'] == $info['pageName']) { global $tikilib; global $structlib; include_once('lib/structures/structlib.php'); $pages = $tikilib->list_received_pages(0, -1, 'pageName_asc', '', 's', $info['structureName']); + foreach ($pages['data'] as $page) { $names[] = $page['pageName']; } + if (empty($names)) return true; - $query = "select count(*) from `tiki_pages` where `pageName` in (".implode(',',array_fill(0,count($names),'?')).")"; + + $query = "select count(*) from `tiki_pages` where `pageName` in (" . implode(',', array_fill(0, count($names), '?')) .")"; + if ($this->getOne($query, $names)) return false; + foreach ($pages['data'] as $key=>$page) { $parent_id = null; $after_ref_id = 0; @@ -44,38 +51,86 @@ } } } + if ($parent_id) - $this->create_page($page['pageName'], 0, $page['data'], $this->now, $page['comment'], $page['receivedFromUser'], $page['receivedFromSite'], $page['description']); + $this->create_page( + $page['pageName'], + 0, + $page['data'], + $this->now, + $page['comment'], + $page['receivedFromUser'], + $page['receivedFromSite'], + $page['description'] + ); + $pages['data'][$key]['page_ref_id'] = $structlib->s_create_page($parent_id, $after_ref_id, $page['pageName'], $page['page_alias']); + if (!$parent_id) - $this->update_page($page['pageName'], $page['data'], $page['comment'], $page['receivedFromUser'], $page['receivedFromSite'], $page['description'], true); + $this->update_page( + $page['pageName'], + $page['data'], + $page['comment'], + $page['receivedFromUser'], + $page['receivedFromSite'], + $page['description'], + true + ); } $query = "delete from `tiki_received_pages` where `structureName`=?"; $this->query($query, $info['structureName']); } elseif (empty($info['structureName'])) { if ($this->page_exists($info["pageName"])) return false; - $this->create_page($info["pageName"], 0, $info["data"], $this->now, $info["comment"], $info["receivedFromUser"], $info["receivedFromSite"], $info["description"]); + $this->create_page( + $info["pageName"], + 0, + $info["data"], + $this->now, + $info["comment"], + $info["receivedFromUser"], + $info["receivedFromSite"], + $info["description"] + ); $query = "delete from `tiki_received_pages` where `receivedPageId`=?"; - $this->query($query,array((int)$receivedPageId)); - } + $this->query($query, array((int)$receivedPageId)); + } + return true; } - function accept_article($receivedArticleId, $topic) { + function accept_article($receivedArticleId, $topic) + { global $artlib; require_once 'lib/articles/artlib.php'; $info = $this->get_received_article($receivedArticleId); - $artlib->replace_article($info["title"], $info["authorName"], - $topic, $info["useImage"], $info["image_name"], $info["image_size"], $info["image_type"], $info["image_data"], - $info["heading"], $info["body"], $info["publishDate"], $info["expireDate"], $info["author"], - 0, $info["image_x"], $info["image_y"], $info["type"], $info["rating"]); + $artlib->replace_article( + $info["title"], + $info["authorName"], + $topic, + $info["useImage"], + $info["image_name"], + $info["image_size"], + $info["image_type"], + $info["image_data"], + $info["heading"], + $info["body"], + $info["publishDate"], + $info["expireDate"], + $info["author"], + 0, + $info["image_x"], + $info["image_y"], + $info["type"], + $info["rating"] + ); $query = "delete from `tiki_received_articles` where `receivedArticleId`=?"; - $result = $this->query($query,array((int)$receivedArticleId)); + $result = $this->query($query, array((int)$receivedArticleId)); return true; } - function list_received_articles($offset, $maxRecords, $sort_mode = 'publishDate_desc', $find = '') { + function list_received_articles($offset, $maxRecords, $sort_mode = 'publishDate_desc', $find = '') + { $bindvars = array(); if ($find) { $findesc = '%' . $find . '%'; @@ -86,10 +141,10 @@ $mid = ""; } - $query = "select * from `tiki_received_articles` $mid order by ".$this->convertSortMode($sort_mode); + $query = "select * from `tiki_received_articles` $mid order by " . $this->convertSortMode($sort_mode); $query_cant = "select count(*) from `tiki_received_articles` $mid"; - $result = $this->query($query,$bindvars,$maxRecords,$offset); - $cant = $this->getOne($query_cant,$bindvars); + $result = $this->query($query, $bindvars, $maxRecords, $offset); + $cant = $this->getOne($query_cant, $bindvars); $ret = array(); while ($res = $result->fetchRow()) { @@ -102,48 +157,94 @@ return $retval; } - function remove_received_page($receivedPageId) { + function remove_received_page($receivedPageId) + { $info = $this->get_received_page($receivedPageId); + if ($info['structureName'] == $info['pageName']) { $query = "delete from `tiki_received_pages` where `structureName`=?"; - $this->query($query,array($info['structureName'])); + $this->query($query, array($info['structureName'])); } elseif (empty($info['structureName'])) { $query = "delete from `tiki_received_pages` where `receivedPageId`=?"; - $this->query($query,array((int)$receivedPageId)); + $this->query($query, array((int)$receivedPageId)); } } - function remove_received_article($receivedArticleId) { + function remove_received_article($receivedArticleId) + { $query = "delete from `tiki_received_articles` where `receivedArticleId`=?"; - $result = $this->query($query,array((int)$receivedArticleId)); + $result = $this->query($query, array((int)$receivedArticleId)); } - function get_received_page($receivedPageId) { + function get_received_page($receivedPageId) + { $query = "select * from `tiki_received_pages` where `receivedPageId`=?"; - $result = $this->query($query,array((int)$receivedPageId)); - if (!$result->numRows()) return false; + $result = $this->query($query, array((int)$receivedPageId)); + + if (!$result->numRows()) + return false; + $res = $result->fetchRow(); + return $res; } - function get_received_article($receivedArticleId) { + function get_received_article($receivedArticleId) + { $query = "select * from `tiki_received_articles` where `receivedArticleId`=?"; - $result = $this->query($query,array((int)$receivedArticleId)); - if (!$result->numRows()) return false; + $result = $this->query($query, array((int)$receivedArticleId)); + + if (!$result->numRows()) + return false; + $res = $result->fetchRow(); return $res; } - function update_received_article($receivedArticleId, $title, $authorName, $useImage, $image_x, $image_y, $publishDate, $expireDate, $heading, $body, $type, $rating) { + function update_received_article( + $receivedArticleId, + $title, + $authorName, + $useImage, + $image_x, + $image_y, + $publishDate, + $expireDate, + $heading, + $body, + $type, + $rating + ) + { $size = strlen($body); $hash = md5($title . $heading . $body); + $query = "update `tiki_received_articles` set `title`=?, `authorName`=?, `heading`=?, `body`=?, `size`=?, `hash`=?, `useImage`=?, `image_x`=?, "; $query.= " `image_y`=?, `publishDate`=?, `expireDate`=?, `type`=?, `rating`=? where `receivedArticleId`=?"; - $result = $this->query($query, - array($title,$authorName,$heading,$body,(int)$size,$hash,$useImage,(int)$image_x,(int)$image_y,(int)$publishDate,$expireDate,$type,(int)$rating,(int)$receivedArticleId)); + + $result = $this->query( + $query, + array( + $title, + $authorName, + $heading, + $body, + (int)$size, + $hash, + $useImage, + (int)$image_x, + (int)$image_y, + (int)$publishDate, + $expireDate, + $type, + (int)$rating, + (int)$receivedArticleId + ) + ); } - function update_received_page($receivedPageId, $pageName, $data, $comment) { + function update_received_page($receivedPageId, $pageName, $data, $comment) + { $info = $this->get_received_page($receivedPageId); if ($info['pageName'] != $pageName && !empty($info['structureName'])) { if ($info['pageName'] == $info['structureName']) { @@ -154,48 +255,131 @@ $this->query($query, array($pageName, $info['pageName'])); } $query = "update `tiki_received_pages` set `pageName`=?, `data`=?, `comment`=? where `receivedPageId`=?"; - $this->query($query,array($pageName,$data,$comment,(int)$receivedPageId)); + $this->query($query, array($pageName, $data, $comment, (int)$receivedPageId)); } - function receive_article($site, $user, $title, $authorName, $size, $use_image, $image_name, $image_type, $image_size, $image_x, - $image_y, $image_data, $publishDate, $expireDate, $created, $heading, $body, $hash, $author, $type, $rating) { + function receive_article( + $site, + $user, + $title, + $authorName, + $size, + $use_image, + $image_name, + $image_type, + $image_size, + $image_x, + $image_y, + $image_data, + $publishDate, + $expireDate, + $created, + $heading, + $body, + $hash, + $author, + $type, + $rating + ) + { $query = "delete from `tiki_received_articles` where `title`=? and `receivedFromsite`=? and `receivedFromUser`=?"; - $result = $this->query($query,array($title,$site,$user)); - $query = "insert into `tiki_received_articles`(`receivedDate`,`receivedFromSite`,`receivedFromUser`,`title`,`authorName`,`size`, "; - $query.= " `useImage`,`image_name`,`image_type`,`image_size`,`image_x`,`image_y`,`image_data`,`publishDate`,`expireDate`,`created`,`heading`,`body`,`hash`,`author`,`type`,`rating`) "; + $result = $this->query($query, array($title, $site, $user)); + + $query = "insert into `tiki_received_articles`(`receivedDate`,`receivedFromSite`," . + " `receivedFromUser`,`title`,`authorName`,`size`, `useImage`,`image_name`," . + " `image_type`,`image_size`,`image_x`,`image_y`,`image_data`,`publishDate`," . + " `expireDate`,`created`,`heading`,`body`,`hash`,`author`,`type`,`rating`) " + ; $query.= " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; - $result = $this->query($query,array((int)$this->now,$site,$user,$title,$authorName,(int)$size,$use_image,$image_name,$image_type,$image_size, - $image_x,$image_y,$image_data,(int)$publishDate,(int)$expireDate,(int)$created,$heading,$body,$hash,$author,$type,(int)$rating)); + + $result = $this->query( + $query, + array( + (int)$this->now, + $site, + $user, + $title, + $authorName, + (int)$size, + $use_image, + $image_name, + $image_type, + $image_size, + $image_x, + $image_y, + $image_data, + (int)$publishDate, + (int)$expireDate, + (int)$created, + $heading, + $body, + $hash, + $author, + $type, + (int)$rating + ) + ); } - function receive_page($pageName, $data, $comment, $site, $user, $description) { + function receive_page($pageName, $data, $comment, $site, $user, $description) + { // Remove previous page sent from the same site-user (an update) $query = "delete from `tiki_received_pages` where `pageName`=? and `receivedFromsite`=? and `receivedFromUser`=? and `structureName`=?"; - $result = $this->query($query,array($pageName,$site,$user,'')); + $result = $this->query($query, array($pageName, $site, $user, '')); + // Now insert the page - $query = "insert into `tiki_received_pages`(`pageName`,`data`,`comment`,`receivedFromSite`, `receivedFromUser`, `receivedDate`,`description`) values(?,?,?,?,?,?,?)"; - $result = $this->query($query,array($pageName,$data,$comment,$site,$user,(int)$this->now,$description)); + $query = "insert into `tiki_received_pages`(`pageName`,`data`,`comment`,`receivedFromSite`," . + " `receivedFromUser`, `receivedDate`,`description`) values(?,?,?,?,?,?,?)"; + + $result = $this->query($query, array($pageName, $data, $comment, $site, $user, (int)$this->now, $description)); } - function receive_structure_page($pageName, $data, $comment, $site, $user, $description, $structureName, $parentName, $pos, $alias) { + function receive_structure_page($pageName, $data, $comment, $site, $user, $description, $structureName, $parentName, $pos, $alias) + { global $tikilib; $query = "delete from `tiki_received_pages` where `pageName`=? and `receivedFromsite`=? and `receivedFromUser`=? and `structureName`=?"; - $this->query($query,array($pageName,$site,$user,$structureName)); - $query = "insert into `tiki_received_pages`(`pageName`,`data`,`comment`,`receivedFromSite`, `receivedFromUser`, `receivedDate`,`description`,`structureName`, `parentName`, `page_alias`, `pos`) values(?,?,?,?,?,?,?,?,?,?,?)"; - $this->query($query,array($pageName,$data,$comment,$site,$user,(int)$tikilib->now,$description,$structureName, $parentName,$alias,$pos)); + $this->query($query, array($pageName, $site, $user, $structureName)); + + $query = "insert into `tiki_received_pages` (`pageName`,`data`,`comment`,`receivedFromSite`," . + " `receivedFromUser`, `receivedDate`,`description`,`structureName`, `parentName`," . + " `page_alias`, `pos`) values(?,?,?,?,?,?,?,?,?,?,?)"; + $this->query( + $query, + array( + $pageName, + $data, + $comment, + $site, + $user, + (int)$tikilib->now, + $description, + $structureName, + $parentName, + $alias, + $pos + ) + ); } - function rename_structure_pages($pages, $prefix, $postfix) { + + function rename_structure_pages($pages, $prefix, $postfix) + { $bindvars[] = $prefix; $bindvars[] = $postfix; $bindvars = array_merge($bindvars, $pages); - $query = 'update `tiki_received_pages` set `pageName`= concat(?,`pageName`,?) where `pageName` in ('.implode(',',array_fill(0, count($pages),'?')).")"; + + $query = 'update `tiki_received_pages` set `pageName`= concat(?,`pageName`,?) where `pageName` in (' . + implode(',', array_fill(0, count($pages), '?')) . ")"; $this->query($query, $bindvars); - $query = 'update `tiki_received_pages` set `parentName`= concat(?,`parentName`,?) where `parentName` in ('.implode(',',array_fill(0, count($pages),'?')).")"; + + $query = 'update `tiki_received_pages` set `parentName`= concat(?,`parentName`,?) where `parentName` in (' . + implode(',', array_fill(0, count($pages), '?')) . ")"; $this->query($query, $bindvars); - $query = 'update `tiki_received_pages` set `structureName`= concat(?,`structureName`,?) where `structureName` in ('.implode(',',array_fill(0, count($pages),'?')).")"; + + $query = 'update `tiki_received_pages` set `structureName`= concat(?,`structureName`,?) where `structureName` in (' . + implode(',', array_fill(0, count($pages), '?')) . ")"; + $this->query($query, $bindvars); } -// Functions for the communication center end //// } $commlib = new CommLib; This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |