{include file="header.html"}
<!--// $Id: sql.html,v 1.8 2005/03/16 13:15:57 alec Exp $ //-->
{literal}
<SCRIPT language=JavaScript>
	<!--
	function page_change(page)
	{
		document.sql.action="?m=sql&page="+page;
		document.sql.target="";
		document.sql.submit();
	}
	function printResult()
	{
		document.sql.action="?m=sql&print=1";
		document.sql.target="_blank";
		document.sql.submit();
	}
	//-->
</SCRIPT>
{/literal}
<H1>{$layout.pagetitle}</H1>
<FORM NAME="sql" method="post" action="?m=sql">
{if $page}
	{if $executetime}
	<P><TABLE width="100%" cellpadding="3">
		<TR class="dark">
			<TD width="1%" class="fleftu"><IMG src="img/producer.gif" ALT="" align="absmiddle"></TD>
			<TD width="1%" class="fbt"><B>{t}Query:{/t}</B></TD>
			<TD width="98%" class="frightu">{$query}</TD>
		</TR>
		<TR class="light">
			<TD width="1%" class="fleft"><IMG src="img/time.gif" ALT="" align="absmiddle"></TD>
			<TD width="1%" NOWRAP><B>{t}Execution time:{/t}</B></TD>
			<TD width="98%" class="fright">{$executetime|string_format:"%0.3f"} s</TD>
		</TR>
		<TR class="light">
			<TD width="1%" class="fleft"><IMG src="img/id.gif" ALT="" align="absmiddle"></TD>
			<TD width="1%"><B>{t}Rows count:{/t}</B></TD>
			<TD width="98%" class="fright">{$nrows}</TD>
		</TR>
		<TR class="light">
			<TD width="100%" colspan="3" class="fbottomu" align="right" nowrap>
				<INPUT type="hidden" name="query" value="{$query}"></INPUT>
				<A href="javascript: document.sql.submit();">{t}Execute again{/t} <IMG src="img/save.gif" border="0" align="absmiddle" alt=""></A>&nbsp;
				<A href="javascript: printResult();">{t}Print{/t} <IMG src="img/print.gif" border="0" align="absmiddle" alt=""></A>&nbsp;
				<A href="?m=sql">{t}Cancel{/t} <IMG src="img/cancel.gif" border="0" align="absmiddle" alt=""></A>
			</TD>
		</TR>
	</TABLE></P>
	{/if}
	{if $result}
	<TABLE width="100%" cellpadding="0" border="1">
	<TR><TD>
		<TABLE width="100%" cellpadding="3">
			<TR class="dark">
				<TD class="blend"><B>{t}No.{/t}</B></TD>
				{foreach from=$colnames item=col}
				<TD><B>{$col}</B></TD>
				{/foreach}
			</TR>
				{$result}
			{if $nrows > $pagelimit}
			<TR class="dark">
				<TD width="100%" colspan="{math equation="x+1" x=$ncols}">
					<B>{t}Page:{/t} 
					{if $page > 1} 
						<A HREF="javascript:page_change({math equation="x - 1" x=$page});">&laquo;&laquo;&laquo;</A>{else}&laquo;&laquo;&laquo;
					{/if} 
					{section name=pcnt loop=$nrows  step=$pagelimit}
						{if $page eq $smarty.section.pcnt.rownum}[{else} <A HREF="javascript:page_change({$smarty.section.pcnt.rownum});">{/if}
						{$smarty.section.pcnt.rownum}
						{if $page eq $smarty.section.pcnt.rownum}]{else}</A>{/if}
					{/section} 
					{if $page < $smarty.section.pcnt.rownum}
						<A HREF="javascript:page_change({math equation="x + 1" x=$page});">&raquo;&raquo;&raquo;</A>{else}&raquo;&raquo;&raquo;
					{/if}
					</B> (rekordy {math equation="x + 1" x=$start} - {if $start + $pagelimit > $nrows}{$nrows}{else}{math equation="x + y" x=$start y=$pagelimit}{/if} z {$nrows})
				</TD>
			</TR>
			{/if}
		</TABLE>
	</TD></TR>
	</TABLE>
	{/if}
{else}
<TABLE WIDTH="100%" CELLPADDING="3">
	<TR CLASS="DARK">
		<TD CLASS="FLEFTU" WIDTH="1%">
			<IMG SRC="img/producer.gif" ALT="" BORDER="0" ALIGN="ABSMIDDLE"> 
		</TD>
		<TD CLASS="FRIGHTU" WIDTH="99%" COLSPAN="2"NOWRAP>
			<B>{t}SQL query{/t}</B>
		</TD>
	</TR>
	<TR CLASS="LIGHT">
		<TD CLASS="FLEFT" WIDTH="1%">
			<IMG SRC="img/edit.gif" ALT="" BORDER="0" ALIGN="ABSMIDDLE"> 
		</TD>
		<TD WIDTH="1%" NOWRAP>
			<B>{t}Query contents:{/t}</B>
		</TD>
		<TD CLASS="FRIGHT" WIDTH="98%">
			<TEXTAREA NAME="query" COLS="80" ROWS="10" {tip text="Enter contents of SQL query" trigger="query"}>{$query}</TEXTAREA><BR>
		</TD>
	</TR>
	<TR CLASS="LIGHT">
		<TD CLASS="FBOTTOMU" COLSPAN="3" ALIGN="RIGHT">
			 <A HREF="javascript:document.sql.submit();" accesskey="s">{t}Execute{/t} <IMG SRC="img/save.gif" ALT="" BORDER="0" ALIGN="ABSMIDDLE"></A>
		</TD>
	</TR>
</TABLE>
{/if}
</FORM>
{include file="footer.html"}