[Tikiwiki-cvs] tiki/lib/trackers trackerlib.php, 1.231.2.36, 1.231.2.37

[<ny...@us...>]

Update of /cvsroot/tikiwiki/tiki/lib/trackers
In directory sc8-pr-cvs10.sourceforge.net:/tmp/cvs-serv2072/lib/trackers

Modified Files:
      Tag: BRANCH-1-10
	trackerlib.php 
Log Message:
[NEW][ENH] Complete revamping of file galleries

Most important IHM modifications are:

	* New gallery explorer (like windows one),

	* New subgal path (like breadcrumbs / directory path),

	* New wrench icon + contextual menu for actions on files and subgals to replace the old 'Actions' column (it can be disabled in admin > look & feel > other options > Use context menus for actions ),

	* New 'Other Sort' icon and column on the right (only if some fields are configured to be displayed in popup) to allow the user to sort on popup fields too (the 'Other Sort' icon will display the list of available fields with links to sort on them. It will dynamically replace the empty 'Other Sort' column by the selected one),

	* Merge files and subgals tables (like most common filemanagers),

	* Galleries now have only one feature-full display configuration (used for both files and subgals), were you can choose, for each field, between :
		- hide field,
		- show field as a column,
		- show field in the "informations" tooltip/popup,
		- show in both areas,
		(for "locked by" field, there is also a show as an 'icon' option),
		
	* Use new AJAX-enabled pagination, sort and other links,

	* Now handle subgals size (and sort on subgal size),

	* Add an option to limit the number of displayed rows,

	* Some tikineat theme improvements on filegals and icons hover for IE


Most important Code modifications are:

	* Rewrite of get_files() function to handle subgals too (and more options),

	* Modify some db field names to make it easier to handle files and subgals the same way (e.g. all 'downloads' fields are now named 'hits' fields),

	* many factorization and code cleaning,

	* now check permissions when retrieving files and subgals list from DB with new perms functions (this simplifies perms check and fix total number of items to count only items visible to user),

	* New smarty tree function to make tiki trees using phplayers and tiki famfamfam icons,

	* smarty block self_link : new param '_script' to specify another script than the current one (this disable AJAX for this link when the current script is different),

	* smarty query function now handles 'form_input' as '_type' param to return hidden fields needed for forms to keep current URL args,

	* smarty iconify modifier now benefits from icon function and accepts a second param to put an alt/title text for the icon




Index: trackerlib.php
===================================================================
RCS file: /cvsroot/tikiwiki/tiki/lib/trackers/trackerlib.php,v
retrieving revision 1.231.2.36
retrieving revision 1.231.2.37
diff -u -d -r1.231.2.36 -r1.231.2.37
--- trackerlib.php	26 Feb 2008 17:02:51 -0000	1.231.2.36
+++ trackerlib.php	27 Feb 2008 15:18:48 -0000	1.231.2.37
@@ -45,7 +45,7 @@
 	function add_item_attachment_hit($id) {
 		global $prefs, $user;
 		if ($user != 'admin' || $prefs['count_admin_pvs'] == 'y' ) {
-			$query = "update `tiki_tracker_item_attachments` set `downloads`=`downloads`+1 where `attId`=?";
+			$query = "update `tiki_tracker_item_attachments` set `hits`=`hits`+1 where `attId`=?";
 			$result = $this->query($query,array((int) $id));
 		}
 		return true;
@@ -64,7 +64,7 @@
 			$mid = " where `itemId`=? ";
 			$bindvars=array((int) $itemId);
 		}
-		$query = "select `user`,`attId`,`itemId`,`filename`,`filesize`,`filetype`,`downloads`,`created`,`comment`,`longdesc`,`version` ";
+		$query = "select `user`,`attId`,`itemId`,`filename`,`filesize`,`filetype`,`hits`,`created`,`comment`,`longdesc`,`version` ";
 		$query.= " from `tiki_tracker_item_attachments` $mid order by ".$this->convert_sortmode($sort_mode);
 		$query_cant = "select count(*) from `tiki_tracker_item_attachments` $mid";
 		$result = $this->query($query,$bindvars,$maxRecords,$offset);
@@ -82,7 +82,7 @@
 	}
 
 	function get_item_nb_attachments($itemId) {
-		$query = "select sum(downloads) as downloads, count(*) as attachments from `tiki_tracker_item_attachments` where `itemId`=?";
+		$query = "select sum(hits) as hits, count(*) as attachments from `tiki_tracker_item_attachments` where `itemId`=?";
 		$result = $this->query($query, array($itemId));
 		if ($res = $result->fetchRow())
 			return $res;
@@ -102,7 +102,7 @@
 			$mid = "";
 			$bindvars=array();
 		}
-		$query = "select `user`,`attId`,`itemId`,`filename`,`filesize`,`filetype`,`downloads`,`created`,`comment`,`path` ";
+		$query = "select `user`,`attId`,`itemId`,`filename`,`filesize`,`filetype`,`hits`,`created`,`comment`,`path` ";
 		$query.= " from `tiki_tracker_item_attachments` $mid order by ".$this->convert_sortmode($sort_mode);
 		$query_cant = "select count(*) from `tiki_tracker_item_attachments` $mid";
 		$result = $this->query($query,$bindvars,$maxRecords,$offset);
@@ -147,7 +147,7 @@
 
 	function item_attach_file($itemId, $name, $type, $size, $data, $comment, $user, $fhash, $version, $longdesc) {
 		$comment = strip_tags($comment);
-		$query = "insert into `tiki_tracker_item_attachments`(`itemId`,`filename`,`filesize`,`filetype`,`data`,`created`,`downloads`,`user`,";
+		$query = "insert into `tiki_tracker_item_attachments`(`itemId`,`filename`,`filesize`,`filetype`,`data`,`created`,`hits`,`user`,";
 		$query.= "`comment`,`path`,`version`,`longdesc`) values(?,?,?,?,?,?,?,?,?,?,?,?)";
 		$result = $this->query($query,array((int) $itemId,$name,$size,$type,$data,(int) $this->now,0,$user,$comment,$fhash,$version,$longdesc));
 	}