From 80e7b0d7d17b0e9581fa56be484b8772d82261de Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Wed, 18 Nov 2009 11:19:42 -0500
Subject: [PATCH] Added code to delete old remote sessions.

---
 interface/lib/classes/listform_actions.inc.php |  107 +++++++++++++++++++++++++++--------------------------
 1 files changed, 54 insertions(+), 53 deletions(-)

diff --git a/interface/lib/classes/listform_actions.inc.php b/interface/lib/classes/listform_actions.inc.php
index 804699b..70d6652 100644
--- a/interface/lib/classes/listform_actions.inc.php
+++ b/interface/lib/classes/listform_actions.inc.php
@@ -1,7 +1,7 @@
 <?php
 
 /*
-Copyright (c) 2005, Till Brehm, projektfarm Gmbh
+Copyright (c) 2007, Till Brehm, projektfarm Gmbh
 All rights reserved.
 
 Redistribution and use in source and binary forms, with or without modification,
@@ -28,30 +28,22 @@
 EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
 
-/**
-* Action framework for the listform library.
-*
-* @author Till Brehm <t.brehm@scrigo.org>
-* @copyright Copyright &copy; 2005, Till Brehm
-*/
-
 class listform_actions {
 	
-	var $id;
-	var $idx_key;
-	var $DataRowColor;
-	var $SQLExtWhere = '';
-	var $SQLOrderBy = '';
+	private $id;
+	public $idx_key;
+	public $DataRowColor;
+	public  $SQLExtWhere = '';
+	public  $SQLOrderBy = '';
 	
-	function onLoad() {
+	public function onLoad()
+    {
 		global $app, $conf, $list_def_file;
 		
-		if(!@is_object($app->tpl)) $app->uses('tpl');
-		if(!@is_object($app->listform)) $app->uses('listform');
-		if(!@is_object($app->tform)) $app->uses('tform');
+		$app->uses('tpl,listform,tform');
 		
-		// Clear session variable that is used when lists are embedded with the listview plugin
-		$_SESSION["s"]["form"]["return_to"] = '';
+		//* Clear session variable that is used when lists are embedded with the listview plugin
+		$_SESSION['s']['form']['return_to'] = '';
 		
 		// Load list definition
 		$app->listform->loadListDef($list_def_file);
@@ -66,7 +58,6 @@
 
 		// Getting Datasets from DB
 		$records = $app->db->queryAllRecords($this->getQueryString());
-
 
 		$this->DataRowColor = "#FFFFFF";
 		$records_new = '';
@@ -84,43 +75,48 @@
 		
 	}
 	
-	function prepareDataRow($rec) {
+	public function prepareDataRow($rec)
+    {
 		global $app;
 		
 		$rec = $app->listform->decode($rec);
 
-		// Alternating datarow colors
-		$this->DataRowColor = ($this->DataRowColor == "#FFFFFF")?"#EEEEEE":"#FFFFFF";
-		$rec["bgcolor"] = $this->DataRowColor;
+		//* Alternating datarow colors
+		$this->DataRowColor = ($this->DataRowColor == '#FFFFFF') ? '#EEEEEE' : '#FFFFFF';
+		$rec['bgcolor'] = $this->DataRowColor;
 		
-		// substitute value for select fields
-		foreach($app->listform->listDef["item"] as $field) {
-			$key = $field["field"];
-			if($field['formtype'] == "SELECT") {
-				$rec[$key] = $field['value'][$rec[$key]];
+		//* substitute value for select fields
+		foreach($app->listform->listDef['item'] as $field) {
+			$key = $field['field'];
+			if(isset($field['formtype']) && $field['formtype'] == 'SELECT') {
+				if(strtolower($rec[$key]) == 'y' or strtolower($rec[$key]) == 'n') {
+					// Set a additional image variable for bolean fields
+					$rec['_'.$key.'_'] = (strtolower($rec[$key]) == 'y')?'x16/tick_circle.png':'x16/cross_circle.png';
+				}
+				//* substitute value for select field
+				$rec[$key] = @$field['value'][$rec[$key]];
 			}
 		}
 		
-		// The variable "id" contains always the index variable
-		$rec["id"] = $rec[$this->idx_key];
-		
+		//* The variable "id" contains always the index variable
+		$rec['id'] = $rec[$this->idx_key];
 		return $rec;
 	}
 	
-	function getQueryString() {
+	private function getQueryString() {
 		global $app;
-		
-		// Generate the search sql
-		if($app->listform->listDef["auth"] != 'no') {
-			if($_SESSION["s"]["user"]["typ"] == "admin") {
-				$sql_where = "";
+		$sql_where = '';
+
+		//* Generate the search sql
+		if($app->listform->listDef['auth'] != 'no') {
+			if($_SESSION['s']['user']['typ'] == "admin") {
+				$sql_where = '';
 			} else {
-				$sql_where = $app->tform->getAuthSQL('r')." and";
+				$sql_where = $app->tform->getAuthSQL('r').' and';
 			}
-		}
-		
+		}		
 		if($this->SQLExtWhere != '') {
-			$sql_where .= " ".$this->SQLExtWhere." and";
+			$sql_where .= ' '.$this->SQLExtWhere.' and';
 		}
 
 		$sql_where = $app->listform->getSearchSQL($sql_where);
@@ -128,31 +124,36 @@
 		
 		$order_by_sql = $this->SQLOrderBy;
 
-		// Generate SQL for paging
+		//* Generate SQL for paging
 		$limit_sql = $app->listform->getPagingSQL($sql_where);
-		$app->tpl->setVar("paging",$app->listform->pagingHTML);
+		$app->tpl->setVar('paging',$app->listform->pagingHTML);
 
-		return "SELECT * FROM ".$app->listform->listDef["table"]." WHERE $sql_where $order_by_sql $limit_sql";
-		
+		return 'SELECT * FROM '.$app->listform->listDef['table']." WHERE $sql_where $order_by_sql $limit_sql";
 	}
 	
 	
-	function onShow() {
+	public function onShow()
+    {
 		global $app;
 		
-		// Language File setzen
-		$lng_file = "lib/lang/".$_SESSION["s"]["language"]."_".$app->listform->listDef['name']."_list.lng";
+		//* Set global Language File
+		$lng_file = ISPC_LIB_PATH.'/lang/'.$_SESSION['s']['language'].'.lng';
+		if(!file_exists($lng_file))
+		$lng_file = ISPC_LIB_PATH.'/lang/en.lng';
 		include($lng_file);
 		$app->tpl->setVar($wb);
-		$app->tpl->setVar("form_action",$app->listform->listDef["file"]);
 		
-		// Parse the templates and send output to the browser
+		$app->tpl->setVar('toolsarea_head_txt',$app->lng('toolsarea_head_txt'));
+		$app->tpl->setVar($app->listform->wordbook);
+		$app->tpl->setVar('form_action', $app->listform->listDef['file']);
+		
+		//* Parse the templates and send output to the browser
 		$this->onShowEnd();
 	}
 	
-	function onShowEnd() {
+	private function onShowEnd()
+    {
 		global $app;
-		
 		$app->tpl_defaults();
 		$app->tpl->pparse();
 	}

--
Gitblit v1.9.1