Location: PHPKode > projects > Program E > docs/developer/__filesource/fsource_application__cmsincludemenu.inc.php.html
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  <html xmlns="http://www.w3.org/1999/xhtml">
		<head>
			<!-- template designed by Marco Von Ballmoos  -->
			<title>File Source for menu.inc.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
											</head>
		<body>
						
<h1>Source for file menu.inc.php</h1>
<p>Documentation is available at <a href="../application/_cms_include_menu_inc_php.html">menu.inc.php</a></p>
<div class="src-code">
<pre><ol><li><a name="a1"></a><span class="src-php">&lt;?php</span></li>
<li><a name="a2"></a>&nbsp;</li>
<li><a name="a3"></a><span class="src-comm">/*</span></li>
<li><a name="a4"></a><span class="src-comm">    Program E related AIML knowledgebase tools</span></li>
<li><a name="a5"></a><span class="src-comm">    Copyright 2004, Anne Kootstra [hide@address.com]</span></li>
<li><a name="a6"></a><span class="src-comm">    http://www.AIML.info</span></li>
<li><a name="a7"></a>    </li>
<li><a name="a8"></a><span class="src-comm">    Program E is free software; you can redistribute it and/or modify</span></li>
<li><a name="a9"></a><span class="src-comm">    it under the terms of the GNU General Public License as published by</span></li>
<li><a name="a10"></a><span class="src-comm">    the Free Software Foundation; either version 2 of the License, or</span></li>
<li><a name="a11"></a><span class="src-comm">    (at your option) any later version.</span></li>
<li><a name="a12"></a>&nbsp;</li>
<li><a name="a13"></a><span class="src-comm">    Program E is distributed in the hope that it will be useful,</span></li>
<li><a name="a14"></a><span class="src-comm">    but WITHOUT ANY WARRANTY; without even the implied warranty of</span></li>
<li><a name="a15"></a><span class="src-comm">    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the</span></li>
<li><a name="a16"></a><span class="src-comm">    GNU General Public License for more details.</span></li>
<li><a name="a17"></a>&nbsp;</li>
<li><a name="a18"></a><span class="src-comm">    You should have received a copy of the GNU General Public License</span></li>
<li><a name="a19"></a><span class="src-comm">    along with Program E; if not, write to the Free Software</span></li>
<li><a name="a20"></a><span class="src-comm">    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA</span></li>
<li><a name="a21"></a><span class="src-comm">*/</span></li>
<li><a name="a22"></a>&nbsp;</li>
<li><a name="a23"></a><span class="src-var">$settings</span><span class="src-sym">[</span><span class="src-str">'menuItems'</span><span class="src-sym">] </span>= <span class="src-str">'5'</span><span class="src-sym">;</span></li>
<li><a name="a24"></a>&nbsp;</li>
<li><a name="a25"></a>&nbsp;</li>
<li><a name="a26"></a><span class="src-key">function </span><a href="../application/_cms_include_menu_inc_php.html#functiongetFirstWords">getFirstWords</a><span class="src-sym">(</span><span class="src-var">$strFirstChar</span><span class="src-sym">, </span><span class="src-var">$botid</span><span class="src-sym">, </span><span class="src-var">$pid</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a27"></a>&nbsp;</li>
<li><a name="a28"></a><span class="src-key">global </span><span class="src-var">$settings</span><span class="src-sym">;</span></li>
<li><a name="a29"></a>&nbsp;</li>
<li><a name="a30"></a><span class="src-var">$strSQLfirsWords </span>= <span class="src-str">&quot;</span></li>
<li><a name="a31"></a><span class="src-str">SELECT</span></li>
<li><a name="a32"></a><span class="src-str"> DISTINCT SUBSTRING_INDEX(pattern, ' ', 1) AS firstWords</span></li>
<li><a name="a33"></a><span class="src-str">FROM templates</span></li>
<li><a name="a34"></a><span class="src-str">WHERE</span></li>
<li><a name="a35"></a><span class="src-str"> bot = &quot;</span>.<span class="src-var">$botid</span>.<span class="src-str">&quot; AND</span></li>
<li><a name="a36"></a><span class="src-str"> pattern REGEXP '^&quot;</span>.<span class="src-var">$strFirstChar</span>.<span class="src-str">&quot;'</span></li>
<li><a name="a37"></a><span class="src-str">ORDER BY</span></li>
<li><a name="a38"></a><span class="src-str"> firstWords ASC</span></li>
<li><a name="a39"></a><span class="src-str">LIMIT &quot;</span>.<span class="src-var">$pid </span>* <span class="src-var">$settings</span><span class="src-sym">[</span><span class="src-str">'menuItems'</span><span class="src-sym">]</span>.<span class="src-str">&quot;,&quot;</span>.<span class="src-sym">((</span><span class="src-var">$pid </span>+ <span class="src-num">1</span><span class="src-sym">) </span>* <span class="src-var">$settings</span><span class="src-sym">[</span><span class="src-str">'menuItems'</span><span class="src-sym">]</span><span class="src-sym">)</span>.<span class="src-str">&quot;;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a40"></a>&nbsp;</li>
<li><a name="a41"></a>    <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-var">$strSQLfirsWords</span><span class="src-sym">,</span><span class="src-num">2</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a42"></a>    <span class="src-var">$selectcode </span>= <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$strSQLfirsWords</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a43"></a>    <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a44"></a>        <span class="src-key">if</span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mysql_numrows">mysql_numrows</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a45"></a>            <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a46"></a>        <span class="src-sym">}</span></li>
<li><a name="a47"></a>        <span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a48"></a>            <span class="src-key">while </span><span class="src-sym">(</span><span class="src-var">$q </span>= <a href="http://www.php.net/mysql_fetch_row">mysql_fetch_row</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a49"></a>                 <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a50"></a>            <span class="src-sym">}</span></li>
<li><a name="a51"></a>            </li>
<li><a name="a52"></a>            <span class="src-key">return </span><span class="src-var">$result</span><span class="src-sym">;</span></li>
<li><a name="a53"></a>        <span class="src-sym">}</span></li>
<li><a name="a54"></a>    <span class="src-sym">}</span></li>
<li><a name="a55"></a>&nbsp;</li>
<li><a name="a56"></a>    <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a57"></a><span class="src-sym">}</span></li>
<li><a name="a58"></a>&nbsp;</li>
<li><a name="a59"></a>&nbsp;</li>
<li><a name="a60"></a><span class="src-key">function </span><a href="../application/_cms_include_menu_inc_php.html#functiongetNode">getNode</a><span class="src-sym">(</span><span class="src-var">$strPattern</span><span class="src-sym">, </span><span class="src-var">$botid</span><span class="src-sym">, </span><span class="src-var">$pid</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a61"></a>&nbsp;</li>
<li><a name="a62"></a><span class="src-key">global </span><span class="src-var">$settings</span><span class="src-sym">;</span></li>
<li><a name="a63"></a>&nbsp;</li>
<li><a name="a64"></a><span class="src-var">$pid </span>= <span class="src-var">$pid </span>- <span class="src-num">1</span><span class="src-sym">;</span></li>
<li><a name="a65"></a>&nbsp;</li>
<li><a name="a66"></a><span class="src-var">$quer </span>= <span class="src-str">&quot;set @strPat = '1';&quot;</span><span class="src-sym">; </span></li>
<li><a name="a67"></a><span class="src-var">$que2 </span>= <span class="src-str">&quot;select botname from bots where id = @strPat;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>&nbsp;</li>
<li><a name="a69"></a><span class="src-var">$strSQLsetVar </span>= <span class="src-str">&quot;</span></li>
<li><a name="a70"></a><span class="src-str">SET</span></li>
<li><a name="a71"></a><span class="src-str"> @strPattern = TRIM(UCASE('&quot;</span>.<span class="src-var">$strPattern</span>.<span class="src-str">&quot;')),</span></li>
<li><a name="a72"></a>&nbsp;</li>
<li><a name="a73"></a><span class="src-str"> @intWords = LENGTH(@strPattern) - LENGTH(REPLACE(@strPattern, ' ', '')) + 1;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a74"></a>&nbsp;</li>
<li><a name="a75"></a><span class="src-var">$strSQLnodes </span>= <span class="src-str">&quot;</span></li>
<li><a name="a76"></a>&nbsp;</li>
<li><a name="a77"></a><span class="src-str">SELECT</span></li>
<li><a name="a78"></a><span class="src-str"> SUBSTRING_INDEX(</span></li>
<li><a name="a79"></a><span class="src-str">                SUBSTRING_INDEX(</span></li>
<li><a name="a80"></a><span class="src-str">                           pattern,</span></li>
<li><a name="a81"></a><span class="src-str">                           ' ',</span></li>
<li><a name="a82"></a><span class="src-str">                           @intWords +1</span></li>
<li><a name="a83"></a><span class="src-str">                           ),</span></li>
<li><a name="a84"></a><span class="src-str">                 ' ',</span></li>
<li><a name="a85"></a><span class="src-str">                 -1</span></li>
<li><a name="a86"></a><span class="src-str">                 ) AS word,</span></li>
<li><a name="a87"></a>&nbsp;</li>
<li><a name="a88"></a><span class="src-str"> IF(</span></li>
<li><a name="a89"></a><span class="src-str">    LENGTH(pattern) - LENGTH(REPLACE(pattern, ' ', '')) = @intWords,</span></li>
<li><a name="a90"></a><span class="src-str">    1,</span></li>
<li><a name="a91"></a><span class="src-str">    0</span></li>
<li><a name="a92"></a><span class="src-str">   ) AS isend,</span></li>
<li><a name="a93"></a>&nbsp;</li>
<li><a name="a94"></a><span class="src-str"> COUNT(pattern) AS no_nodes,</span></li>
<li><a name="a95"></a>&nbsp;</li>
<li><a name="a96"></a><span class="src-str"> IF(</span></li>
<li><a name="a97"></a><span class="src-str">    LENGTH(pattern) - LENGTH(REPLACE(pattern, ' ', '')) = @intWords || COUNT(pattern) = 1,</span></li>
<li><a name="a98"></a><span class="src-str">    id,</span></li>
<li><a name="a99"></a><span class="src-str">    null</span></li>
<li><a name="a100"></a><span class="src-str">    ) AS template_id,</span></li>
<li><a name="a101"></a>&nbsp;</li>
<li><a name="a102"></a><span class="src-str"> MAX(LENGTH(pattern) - LENGTH(REPLACE(pattern, ' ', ''))) + 1 AS max_words</span></li>
<li><a name="a103"></a><span class="src-str">FROM</span></li>
<li><a name="a104"></a><span class="src-str"> templates</span></li>
<li><a name="a105"></a><span class="src-str">WHERE</span></li>
<li><a name="a106"></a><span class="src-str">  SUBSTRING_INDEX(pattern, ' ', @intWords) like @strPattern AND</span></li>
<li><a name="a107"></a><span class="src-str">    pattern != @strPattern AND</span></li>
<li><a name="a108"></a><span class="src-str">  bot = &quot;</span>.<span class="src-var">$botid</span>.<span class="src-str">&quot;</span></li>
<li><a name="a109"></a><span class="src-str">GROUP BY</span></li>
<li><a name="a110"></a><span class="src-str">  word</span></li>
<li><a name="a111"></a><span class="src-str">ORDER BY</span></li>
<li><a name="a112"></a><span class="src-str">  word ASC</span></li>
<li><a name="a113"></a><span class="src-str">LIMIT &quot;</span>.<span class="src-var">$pid </span>* <span class="src-var">$settings</span><span class="src-sym">[</span><span class="src-str">'menuItems'</span><span class="src-sym">]</span>.<span class="src-str">&quot;,&quot;</span>.<span class="src-sym">((</span><span class="src-var">$pid </span>+ <span class="src-num">1</span><span class="src-sym">) </span>* <span class="src-var">$settings</span><span class="src-sym">[</span><span class="src-str">'menuItems'</span><span class="src-sym">]</span><span class="src-sym">)</span>.<span class="src-str">&quot;;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a114"></a> </li>
<li><a name="a115"></a><span class="src-comm">//echo &quot;$strSQLsetVar $strSQLnodes&quot;;</span></li>
<li><a name="a116"></a> </li>
<li><a name="a117"></a>    <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-var">$strSQLnodes</span><span class="src-sym">,</span><span class="src-num">2</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a118"></a>    <span class="src-var">$selectcode </span>= <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$strSQLsetVar</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a119"></a>    <span class="src-var">$selectcode </span>= <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$strSQLnodes</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a120"></a>    <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a121"></a>        <span class="src-key">if</span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mysql_numrows">mysql_numrows</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a122"></a>            <span class="src-comm">//die('&lt;br/&gt;&lt;br/&gt;&lt;br/&gt;Invalid query: ' . mysql_error());</span></li>
<li><a name="a123"></a>            <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a124"></a>        <span class="src-sym">}</span></li>
<li><a name="a125"></a>        <span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a126"></a>            <span class="src-var">$x </span>= <span class="src-num">0</span><span class="src-sym">;</span></li>
<li><a name="a127"></a>            <span class="src-key">while </span><span class="src-sym">(</span><span class="src-var">$q </span>= <a href="http://www.php.net/mysql_fetch_array">mysql_fetch_array</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a128"></a>                </li>
<li><a name="a129"></a>                <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$x</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'word'</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-str">'word'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a130"></a>                <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$x</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'isend'</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-str">'isend'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a131"></a>                <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$x</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'no_nodes'</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-str">'no_nodes'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a132"></a>                <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$x</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'template_id'</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-str">'template_id'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a133"></a>                <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$x</span><span class="src-sym">]</span><span class="src-sym">[</span><span class="src-str">'max_words'</span><span class="src-sym">] </span>= <span class="src-var">$q</span><span class="src-sym">[</span><span class="src-str">'max_words'</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a134"></a>                <span class="src-var">$x</span>++<span class="src-sym">;</span></li>
<li><a name="a135"></a>            <span class="src-sym">}</span></li>
<li><a name="a136"></a>            </li>
<li><a name="a137"></a>            <span class="src-key">return </span><span class="src-var">$result</span><span class="src-sym">;</span></li>
<li><a name="a138"></a>        <span class="src-sym">}</span></li>
<li><a name="a139"></a>    <span class="src-sym">}</span></li>
<li><a name="a140"></a>    </li>
<li><a name="a141"></a>    </li>
<li><a name="a142"></a>    <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a143"></a>&nbsp;</li>
<li><a name="a144"></a><span class="src-sym">}</span></li>
<li><a name="a145"></a>&nbsp;</li>
<li><a name="a146"></a>&nbsp;</li>
<li><a name="a147"></a>&nbsp;</li>
<li><a name="a148"></a><span class="src-key">function </span><a href="../application/_cms_include_menu_inc_php.html#functiongetBotName">getBotName</a><span class="src-sym">(</span><span class="src-var">$botid</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a149"></a>&nbsp;</li>
<li><a name="a150"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;select botname from bots where id=&quot;</span>.<span class="src-var">$botid</span>.<span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a151"></a>    <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">,</span><span class="src-num">2</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a152"></a>    <span class="src-var">$selectcode </span>= <a href="http://www.php.net/mysql_query">mysql_query</a><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a153"></a>    <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a154"></a>        <span class="src-key">if</span><span class="src-sym">(</span><span class="src-sym">!</span><a href="http://www.php.net/mysql_numrows">mysql_numrows</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a155"></a>            <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a156"></a>        <span class="src-sym">}</span></li>
<li><a name="a157"></a>        <span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a158"></a>            <span class="src-key">while </span><span class="src-sym">(</span><span class="src-var">$q </span>= <a href="http://www.php.net/mysql_fetch_array">mysql_fetch_array</a><span class="src-sym">(</span><span class="src-var">$selectcode</span><span class="src-sym">))</span><span class="src-sym">{</span></li>
<li><a name="a159"></a>                <span class="src-key">return </span><span class="src-var">$q</span><span class="src-sym">[</span><span class="src-num">0</span><span class="src-sym">]</span><span class="src-sym">;</span></li>
<li><a name="a160"></a>            <span class="src-sym">}</span></li>
<li><a name="a161"></a>        <span class="src-sym">}</span></li>
<li><a name="a162"></a>    <span class="src-sym">}</span></li>
<li><a name="a163"></a>&nbsp;</li>
<li><a name="a164"></a>    <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a165"></a><span class="src-sym">}</span></li>
<li><a name="a166"></a><span class="src-php">?&gt;</span></li>
</ol></pre>
</div>
	<p class="notes" id="credit">
		Documentation generated on Tue, 11 Jan 2005 18:41:07 +0100 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC3</a>
	</p>
	</body>
</html>
Return current item: Program E