* @license GNU General Public License, see http://www.gnu.org/licenses/gpl.html * @version $Revision$ * @link http://www.mediboard.org */ CCanDo::checkAdmin(); $dsn = CValue::get("dsn"); $table = CValue::get("table"); $tooltip = CValue::get("tooltip"); $start = (int) CValue::get("start"); $count = (int) CValue::getOrSession("count", 50); $order_column = CValue::getOrSession("order_column"); $order_way = CValue::getOrSession("order_way", "ASC"); $where_column = CValue::get("where_column"); $where_value = CValue::get("where_value"); $ds = CSQLDataSource::get($dsn); $columns = CImportTools::getColumnsInfo($ds, $table); $orderby = ""; if ($order_column) { $order_column = preg_replace('/[^-_\\w]/', "", $order_column); if (in_array($order_column, array_keys($columns))) { if (!in_array($order_way, array("ASC", "DESC"))) { $order_way = "ASC"; } $orderby = "{$order_column} {$order_way}"; } } $request = new CRequest(); $request->addTable($table); $request->addSelect("*"); $request->setLimit("{$start},{$count}"); if ($orderby) {