[Tikiwiki-cvs/svn] SF.net SVN: tikiwiki:[14974] trunk

[<sy...@us...>]

Revision: 14974
          http://tikiwiki.svn.sourceforge.net/tikiwiki/?rev=14974&view=rev
Author:   sylvieg
Date:     2008-10-03 14:32:12 +0000 (Fri, 03 Oct 2008)

Log Message:
-----------
[MOD]log: a quick hack to see the adodb logs from tw - must be done for pdo

Added Paths:
-----------
    trunk/templates/tiki-sqllog.tpl
    trunk/tiki-sqllog.php

Added: trunk/templates/tiki-sqllog.tpl
===================================================================
--- trunk/templates/tiki-sqllog.tpl	                        (rev 0)
+++ trunk/templates/tiki-sqllog.tpl	2008-10-03 14:32:12 UTC (rev 14974)
@@ -0,0 +1,26 @@
+{* $Id: tiki-adminusers.tpl 14918 2008-09-30 15:28:29Z ricks99 $ *}
+{title admpage="general"}{tr}Log SQL{/tr}{/title}
+
+{if $prefs.log_sql ne 'y'}
+	{remarksbox type="warning" title="{tr}Notice{/tr}"}}{tr}This feature is disabled{/tr}<br />{tr}You will not see the latest queries.{/tr}{/remarksbox}
+{/if}
+
+{include file='find.tpl' find_show_num_rows='y'}
+
+<table class="normal">
+	<tr>
+		<th>{self_link _sort_arg='sort_mode' _sort_field='created'}{tr}Created{/tr}{/self_link}</th>
+		<th>{self_link _sort_arg='sort_mode' _sort_field='sql1'}{tr}Query{/tr}{/self_link}</th>
+		<th>{self_link _sort_arg='sort_mode' _sort_field='params'}{tr}Params{/tr}{/self_link}</th>
+		<th>{self_link _sort_arg='sort_mode' _sort_field='timer'}{tr}Time{/tr}{/self_link}</th>
+	<tr>
+	{foreach from=$logs item=log}
+		<tr>
+			<td>{$log.created|escape}</td>
+			<td>{$log.sql1|truncate:200|escape}</td>
+			<td>{$log.params|truncate:200|escape}</td>
+			<td>{$log.timer|escape}</td>
+		</tr>
+	{/foreach}
+</table>
+{pagination_links cant=$cant step=$numrows offset=$offset}{/pagination_links}

Added: trunk/tiki-sqllog.php
===================================================================
--- trunk/tiki-sqllog.php	                        (rev 0)
+++ trunk/tiki-sqllog.php	2008-10-03 14:32:12 UTC (rev 14974)
@@ -0,0 +1,35 @@
+<?php
+// $Id: /cvsroot/tikiwiki/tiki/lib/logs/logslib.php,v 1.54.2.5 2008-01-22 16:58:23 sylvieg Exp $
+
+include_once('tiki-setup.php');
+
+if ($tiki_p_admin != 'y') {
+	$smarty->assign('errortype', 401);
+	$smarty->assign('msg', tra("You do not have permission to use this feature"));
+	$smarty->display("error.tpl");
+	die;
+}
+// let look at the log even if not active for older logs
+//if ($prefs['log_sql'] != 'y') {
+//	$smarty->assign('msg', tra('This feature is disabled').': log_sql');
+//	$smarty->display('error.tpl');
+//	die;
+//}
+
+include_once('lib/logs/logslib.php');
+
+$auto_query_args = array('offset', 'numrows', 'find', 'sort_mode'); 
+$numrows = (isset($_REQUEST['numrows'])) ? $_REQUEST['numrows']: (isset($_REQUEST['maxRecords'])? $_REQUEST['maxRecords']: $prefs['maxRecords']);
+$smarty->assign_by_ref('numrows', $numrows);
+$smarty->assign_by_ref('maxRecords', $numrows);
+$offset = (isset($_REQUEST['offset'])) ? $_REQUEST['offset']: 0;
+$smarty->assign_by_ref('offset', $offset);
+$sort_mode = (isset($_REQUEST['sort_mode'])) ? $_REQUEST['sort_mode']: 'created_desc';
+$smarty->assign_by_ref('sort_mode', $sort_mode);
+$find = (isset($_REQUEST['find'])) ? $_REQUEST['find']: '';
+$smarty->assign_by_ref('find', $find);
+$logs = $logslib->list_logsql($sort_mode, $offset, $numrows, $find);
+$smarty->assign_by_ref('logs', $logs['data']);
+$smarty->assign_by_ref('cant', $logs['cant']);
+$smarty->assign('mid', 'tiki-sqllog.tpl');
+$smarty->display('tiki.tpl');


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.