Location: PHPKode > projects > Program E > docs/developer/__filesource/fsource_application__cmsincludedelete.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 delete.inc.php</title>
			<link rel="stylesheet" href="../media/stylesheet.css" />
											</head>
		<body>
						
<h1>Source for file delete.inc.php</h1>
<p>Documentation is available at <a href="../application/_cms_include_delete_inc_php.html">delete.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>&nbsp;</li>
<li><a name="a24"></a>&nbsp;</li>
<li><a name="a25"></a><span class="src-doc">/**</span></li>
<li><a name="a26"></a><span class="src-doc">* Delete a category using template ID</span></li>
<li><a name="a27"></a><span class="src-doc">*</span></li>
<li><a name="a28"></a><span class="src-doc">* This is the container function for a set of other functions for the</span></li>
<li><a name="a29"></a><span class="src-doc">* deletion of a category. It will travel the AIML tree backwards checking</span></li>
<li><a name="a30"></a><span class="src-doc">* if a word-node is used by other categories, if not then deletes it and</span></li>
<li><a name="a31"></a><span class="src-doc">* travels onward to the next word-node. If it it is used, then breaks of</span></li>
<li><a name="a32"></a><span class="src-doc">* the routine, it has then accomplised what it needed to do.</span></li>
<li><a name="a33"></a><span class="src-doc">*</span></li>
<li><a name="a34"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> findmainnode()</span></li>
<li><a name="a35"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> debugger()</span></li>
<li><a name="a36"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> templateCheck()</span></li>
<li><a name="a37"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> findprevioustemplate()</span></li>
<li><a name="a38"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> deleteTemplate()</span></li>
<li><a name="a39"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> updateGmcache()</span></li>
<li><a name="a40"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> deleteCheck()</span></li>
<li><a name="a41"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> findParent()</span></li>
<li><a name="a42"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> deletePatternElement()</span></li>
<li><a name="a43"></a><span class="src-doc">*</span></li>
<li><a name="a44"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$templateID </span><span class="src-doc">              The template's ID</span></li>
<li><a name="a45"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$botid </span><span class="src-doc">                   The bot's ID.</span></li>
<li><a name="a46"></a><span class="src-doc">*</span></li>
<li><a name="a47"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></li>
<li><a name="a48"></a><span class="src-doc">*/</span></li>
<li><a name="a49"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functiondelete_category">delete_category</a><span class="src-sym">(</span><span class="src-var">$templateID</span><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="a50"></a>    </li>
<li><a name="a51"></a>    <span class="src-comm">// retrieve the pattern ID of the main node</span></li>
<li><a name="a52"></a>    <span class="src-var">$mainNode</span>= <a href="../application/_cms_include_common_inc_php.html#functionfindmainnode">findmainnode</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="a53"></a>    <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-str">&quot;(delete_category) mainNode &quot;</span>.<span class="src-var">$mainNode</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="a54"></a>    </li>
<li><a name="a55"></a>    <span class="src-comm">// check if the template exists. If not, then no use continuing.</span></li>
<li><a name="a56"></a>    <span class="src-var">$temp_check </span>= <a href="../application/_cms_include_common_inc_php.html#functiontemplateCheck">templateCheck</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a57"></a>    <span class="src-key">if</span><span class="src-sym">(</span><span class="src-var">$temp_check</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a58"></a>&nbsp;</li>
<li><a name="a59"></a>        <span class="src-comm">/* </span></li>
<li><a name="a60"></a><span class="src-comm">          categories are put in the database in sequence with the last</span></li>
<li><a name="a61"></a><span class="src-comm">          record being the reference to the template table. Thus a </span></li>
<li><a name="a62"></a><span class="src-comm">          category (roughly) would exist from template reference to</span></li>
<li><a name="a63"></a><span class="src-comm">          template reference.</span></li>
<li><a name="a64"></a><span class="src-comm">        */</span></li>
<li><a name="a65"></a>        <span class="src-var">$previous_templateID </span>= <a href="../application/_cms_include_delete_inc_php.html#functionfindprevioustemplate">findprevioustemplate</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a66"></a>    <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></li>
<li><a name="a67"></a>        <span class="src-key">break</span><span class="src-sym">;</span></li>
<li><a name="a68"></a>    <span class="src-sym">}</span></li>
<li><a name="a69"></a>    </li>
<li><a name="a70"></a>    <span class="src-comm">// if there is no previous template, for example often CONNECT category</span></li>
<li><a name="a71"></a>    <span class="src-comm">// or many other top level categories, the main node will need to serve</span></li>
<li><a name="a72"></a>    <span class="src-comm">// this purpose.</span></li>
<li><a name="a73"></a>    <span class="src-key">if</span><span class="src-sym">(</span><span class="src-var">$previous_templateID </span>== <span class="src-str">''</span><span class="src-sym">) </span><span class="src-sym">{</span></li>
<li><a name="a74"></a>        <span class="src-var">$previous_templateID </span>= <span class="src-var">$mainNode</span><span class="src-sym">;</span></li>
<li><a name="a75"></a>    <span class="src-sym">}</span></li>
<li><a name="a76"></a>    </li>
<li><a name="a77"></a>    <span class="src-comm">// delete the template from the templates table</span></li>
<li><a name="a78"></a>    <a href="../application/_cms_include_delete_inc_php.html#functiondeleteTemplate">deleteTemplate</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a79"></a>    </li>
<li><a name="a80"></a>    <span class="src-comm">// edit (perhaps delete be better?) the GMcache to prevent cache responses </span></li>
<li><a name="a81"></a>    <span class="src-comm">// from bot using non-existent categories.</span></li>
<li><a name="a82"></a>    <a href="../application/_cms_include_delete_inc_php.html#functionupdateGmcache">updateGmcache</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a83"></a>    </li>
<li><a name="a84"></a>    <span class="src-comm">// Only if the node is not used by other categories and the template ID is </span></li>
<li><a name="a85"></a>    <span class="src-comm">// lower than that of the next template reference (or main node) are we allowed</span></li>
<li><a name="a86"></a>    <span class="src-comm">// to continue.</span></li>
<li><a name="a87"></a>    <span class="src-key">while</span><span class="src-sym">((</span><a href="../application/_cms_include_delete_inc_php.html#functiondeleteCheck">deleteCheck</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">) </span>== <span class="src-str">'TRUE'</span><span class="src-sym">)</span>&amp;&amp;<span class="src-sym">(</span><span class="src-var">$templateID</span>&gt;<span class="src-var">$previous_templateID</span><span class="src-sym">)) </span><span class="src-sym">{</span></li>
<li><a name="a88"></a>    </li>
<li><a name="a89"></a>             <span class="src-comm">// find the patternID of next word (i.e parentID of current word) </span></li>
<li><a name="a90"></a>             <span class="src-comm">// of the next word. </span></li>
<li><a name="a91"></a>             <span class="src-var">$parentID </span>= <a href="../application/_cms_include_common_inc_php.html#functionfindParent">findParent</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a92"></a>             <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-str">&quot;(delete_category) (while) parentID &quot;</span>.<span class="src-var">$parentID</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="a93"></a>&nbsp;</li>
<li><a name="a94"></a>             <span class="src-comm">// for the current word the patternID is the templateID</span></li>
<li><a name="a95"></a>             <span class="src-var">$patternID </span>= <span class="src-var">$templateID</span><span class="src-sym">;</span></li>
<li><a name="a96"></a>             <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-str">&quot;(delete_category) (while) patternID &quot;</span>.<span class="src-var">$patternID</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="a97"></a>             </li>
<li><a name="a98"></a>             <span class="src-comm">// delete the word (or _ or *)</span></li>
<li><a name="a99"></a>             <a href="../application/_cms_include_delete_inc_php.html#functiondeletePatternElement">deletePatternElement</a><span class="src-sym">(</span><span class="src-var">$patternID</span><span class="src-sym">)</span><span class="src-sym">;</span></li>
<li><a name="a100"></a>            </li>
<li><a name="a101"></a>             <span class="src-comm">// prepare for the next round, setting focus on the next word</span></li>
<li><a name="a102"></a>             <span class="src-var">$templateID </span>= <span class="src-var">$parentID</span><span class="src-sym">;</span></li>
<li><a name="a103"></a>             <a href="../application/_cms_include_common_inc_php.html#functiondebugger">debugger</a><span class="src-sym">(</span><span class="src-str">&quot;(delete_category) (while) templateID &quot;</span>.<span class="src-var">$templateID</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="a104"></a> </li>
<li><a name="a105"></a>    <span class="src-sym">}</span></li>
<li><a name="a106"></a>    </li>
<li><a name="a107"></a><span class="src-sym">}</span></li>
<li><a name="a108"></a>&nbsp;</li>
<li><a name="a109"></a>&nbsp;</li>
<li><a name="a110"></a><span class="src-doc">/**</span></li>
<li><a name="a111"></a><span class="src-doc">* Delete the word from the Pattern Table.</span></li>
<li><a name="a112"></a><span class="src-doc">*</span></li>
<li><a name="a113"></a><span class="src-doc">* Remove the record from the pattern table using it's unique ID.</span></li>
<li><a name="a114"></a><span class="src-doc">*</span></li>
<li><a name="a115"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> debugger()</span></li>
<li><a name="a116"></a><span class="src-doc">*</span></li>
<li><a name="a117"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$patternID </span><span class="src-doc">      The word's pattern ID</span></li>
<li><a name="a118"></a><span class="src-doc">* </span></li>
<li><a name="a119"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></li>
<li><a name="a120"></a><span class="src-doc">*</span></li>
<li><a name="a121"></a><span class="src-doc">*/</span></li>
<li><a name="a122"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functiondeletePatternElement">deletePatternElement</a><span class="src-sym">(</span><span class="src-var">$patternID</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a123"></a>&nbsp;</li>
<li><a name="a124"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;delete from patterns where id='&quot;</span>.<span class="src-var">$patternID</span>.<span class="src-str">&quot;'&quot;</span><span class="src-sym">;</span></li>
<li><a name="a125"></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="a126"></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="a127"></a><span class="src-sym">}</span></li>
<li><a name="a128"></a>&nbsp;</li>
<li><a name="a129"></a>&nbsp;</li>
<li><a name="a130"></a><span class="src-doc">/**</span></li>
<li><a name="a131"></a><span class="src-doc">* Delete the template from the Template Table.</span></li>
<li><a name="a132"></a><span class="src-doc">*</span></li>
<li><a name="a133"></a><span class="src-doc">* Delete the template record with a particular ID.</span></li>
<li><a name="a134"></a><span class="src-doc">*</span></li>
<li><a name="a135"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> debugger()</span></li>
<li><a name="a136"></a><span class="src-doc">*</span></li>
<li><a name="a137"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$templateID </span><span class="src-doc">       The category's ID</span></li>
<li><a name="a138"></a><span class="src-doc">* </span></li>
<li><a name="a139"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></li>
<li><a name="a140"></a><span class="src-doc">*</span></li>
<li><a name="a141"></a><span class="src-doc">*/</span></li>
<li><a name="a142"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functiondeleteTemplate">deleteTemplate</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a143"></a>&nbsp;</li>
<li><a name="a144"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;delete from templates where id='&quot;</span>.<span class="src-var">$templateID</span>.<span class="src-str">&quot;'&quot;</span><span class="src-sym">;</span></li>
<li><a name="a145"></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="a146"></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="a147"></a><span class="src-sym">}</span></li>
<li><a name="a148"></a>&nbsp;</li>
<li><a name="a149"></a>&nbsp;</li>
<li><a name="a150"></a><span class="src-doc">/**</span></li>
<li><a name="a151"></a><span class="src-doc">* Disable record in GMcache table.</span></li>
<li><a name="a152"></a><span class="src-doc">*</span></li>
<li><a name="a153"></a><span class="src-doc">* The GMcache is used to speed up the bot's response time, by checking the</span></li>
<li><a name="a154"></a><span class="src-doc">* cache first before waking the AIML tree. But also means that if a category</span></li>
<li><a name="a155"></a><span class="src-doc">* is deleted, all Cached references need to be deleted or edited too.</span></li>
<li><a name="a156"></a><span class="src-doc">* Currently the records are edited, the Combined contents is replaced by</span></li>
<li><a name="a157"></a><span class="src-doc">* REMOVED and the template ID is replaced by 0</span></li>
<li><a name="a158"></a><span class="src-doc">*</span></li>
<li><a name="a159"></a><span class="src-doc">* </span><span class="src-doc-coretag">@uses</span><span class="src-doc"> debugger()</span></li>
<li><a name="a160"></a><span class="src-doc">*</span></li>
<li><a name="a161"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$templateID </span><span class="src-doc">    The category's ID</span></li>
<li><a name="a162"></a><span class="src-doc">* </span></li>
<li><a name="a163"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></li>
<li><a name="a164"></a><span class="src-doc">*</span></li>
<li><a name="a165"></a><span class="src-doc">*/</span></li>
<li><a name="a166"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functionupdateGmcache">updateGmcache</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a167"></a>&nbsp;</li>
<li><a name="a168"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;UPDATE gmcache SET combined = 'REMOVED', template = '000000' WHERE template = '&quot;</span>.<span class="src-var">$templateID</span>.<span class="src-str">&quot;'&quot;</span><span class="src-sym">;</span></li>
<li><a name="a169"></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="a170"></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="a171"></a><span class="src-sym">}</span></li>
<li><a name="a172"></a>&nbsp;</li>
<li><a name="a173"></a>&nbsp;</li>
<li><a name="a174"></a><span class="src-doc">/**</span></li>
<li><a name="a175"></a><span class="src-doc">* Check if it is safe to delete node.</span></li>
<li><a name="a176"></a><span class="src-doc">*</span></li>
<li><a name="a177"></a><span class="src-doc">* In order to be able to delete a node from a tree, there shouldn't be any</span></li>
<li><a name="a178"></a><span class="src-doc">* other records referencing to it. This function checks this for this</span></li>
<li><a name="a179"></a><span class="src-doc">* these types of references. So it checks to see if it's safe to delete this</span></li>
<li><a name="a180"></a><span class="src-doc">* node. TRUE -&gt; safe, FALSE -&gt; not safe.</span></li>
<li><a name="a181"></a><span class="src-doc">*</span></li>
<li><a name="a182"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$patternID </span><span class="src-doc">     The word's pattern ID</span></li>
<li><a name="a183"></a><span class="src-doc">* </span></li>
<li><a name="a184"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">boolean </span><span class="src-doc">               TRUE/FALSE.</span></li>
<li><a name="a185"></a><span class="src-doc">*</span></li>
<li><a name="a186"></a><span class="src-doc">*/</span></li>
<li><a name="a187"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functiondeleteCheck">deleteCheck</a><span class="src-sym">(</span><span class="src-var">$parentID</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a188"></a>&nbsp;</li>
<li><a name="a189"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;select if(count(id) = 0, 'TRUE', 'FALSE') as delete_safe from patterns where parent = '&quot;</span>.<span class="src-var">$parentID</span>.<span class="src-str">&quot;'&quot;</span><span class="src-sym">;</span></li>
<li><a name="a190"></a>    <span class="src-comm">//debugger($query,2);</span></li>
<li><a name="a191"></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="a192"></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="a193"></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="a194"></a>            <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a195"></a>        <span class="src-sym">}</span></li>
<li><a name="a196"></a>        <span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a197"></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="a198"></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="a199"></a>            <span class="src-sym">}</span></li>
<li><a name="a200"></a>        <span class="src-sym">}</span></li>
<li><a name="a201"></a>    <span class="src-sym">}</span></li>
<li><a name="a202"></a>&nbsp;</li>
<li><a name="a203"></a>    <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a204"></a><span class="src-sym">}</span></li>
<li><a name="a205"></a>&nbsp;</li>
<li><a name="a206"></a>&nbsp;</li>
<li><a name="a207"></a><span class="src-doc">/**</span></li>
<li><a name="a208"></a><span class="src-doc">* Retrieve the previous category's reference to the template Table.</span></li>
<li><a name="a209"></a><span class="src-doc">*</span></li>
<li><a name="a210"></a><span class="src-doc">* Categories are put in the database in sequence with the last record being</span></li>
<li><a name="a211"></a><span class="src-doc">* the reference to the template table. Thus a category (roughly) would exist</span></li>
<li><a name="a212"></a><span class="src-doc">* from template reference to template reference.</span></li>
<li><a name="a213"></a><span class="src-doc">*</span></li>
<li><a name="a214"></a><span class="src-doc">* </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">integer </span><span class="src-doc-var">$templateID </span><span class="src-doc">        The category's ID</span></li>
<li><a name="a215"></a><span class="src-doc">* </span></li>
<li><a name="a216"></a><span class="src-doc">* </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">integer </span><span class="src-doc">                   pattern/template ID.</span></li>
<li><a name="a217"></a><span class="src-doc">*</span></li>
<li><a name="a218"></a><span class="src-doc">*/</span></li>
<li><a name="a219"></a><span class="src-key">function </span><a href="../application/_cms_include_delete_inc_php.html#functionfindprevioustemplate">findprevioustemplate</a><span class="src-sym">(</span><span class="src-var">$templateID</span><span class="src-sym">)</span><span class="src-sym">{</span></li>
<li><a name="a220"></a>&nbsp;</li>
<li><a name="a221"></a>    <span class="src-var">$query </span>= <span class="src-str">&quot;select p.id from patterns as p, templates as t where p.id = t.id and p.id&lt;=&quot;</span>.<span class="src-var">$templateID</span>.<span class="src-str">&quot; order by id desc limit 1,1&quot;</span><span class="src-sym">;</span></li>
<li><a name="a222"></a>    <span class="src-comm">//debugger($query,2);</span></li>
<li><a name="a223"></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="a224"></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="a225"></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="a226"></a>            <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a227"></a>        <span class="src-sym">}</span></li>
<li><a name="a228"></a>        <span class="src-key">else</span><span class="src-sym">{</span></li>
<li><a name="a229"></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="a230"></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="a231"></a>            <span class="src-sym">}</span></li>
<li><a name="a232"></a>        <span class="src-sym">}</span></li>
<li><a name="a233"></a>    <span class="src-sym">}</span></li>
<li><a name="a234"></a>&nbsp;</li>
<li><a name="a235"></a>    <span class="src-key">return </span><span class="src-str">&quot;&quot;</span><span class="src-sym">;</span></li>
<li><a name="a236"></a><span class="src-sym">}</span></li>
<li><a name="a237"></a>&nbsp;</li>
<li><a name="a238"></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:04 +0100 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.3.0RC3</a>
	</p>
	</body>
</html>
Return current item: Program E