View Single Post
  #2  
Old 28th November 2011, 16:33
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,769
Thanks: 840
Thanked 5,609 Times in 4,420 Posts
Default

Each list object in ISPConfig is based on the class listform_actions. The listform actions can be found in interface/lib/classes/listform_actions.inc.php file. This class contains a function named getQueryString() which returns the sql string that is used to display the list. To show lists with a more complex sql syntax, you can override the function getQueryString() in your custom list file.

Example:

Code:
$app->load('listform_actions');

class list_action extends listform_actions {
	
	function getQueryString(){
                $my_sql_query = "SELECT * FROM a,b WHERE ......";
                return $my_sql_query;

	}
	
}

$list = new list_action;
$list->onLoad();
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote