1
<?xml version="1.0" encoding="iso-8859-1"?>
2
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
3
<html xmlns="http://www.w3.org/1999/xhtml">
5
<!-- template designed by Marco Von Ballmoos -->
6
<title>Docs For Class NAVIGATION_extractMenuQuery</title>
7
<link rel="stylesheet" href="../../media/stylesheet.css" />
8
<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'/>
11
<div class="page-body">
12
<h2 class="class-name">Class NAVIGATION_extractMenuQuery</h2>
14
<a name="sec-description"></a>
15
<div class="info-box">
16
<div class="info-box-title">Description</div>
18
<span class="disabled">Description</span> |
19
<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
20
| <a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
23
<div class="info-box-body">
24
<!-- ========== Info from phpDoc block ========= -->
25
<p class="short-description">Navigation - Extract all available menus user belings too.</p>
27
<li><span class="field">author:</span> Jason Schoeman, Contact: titan [at] phpdevshell [dot] org.</li>
28
<li><span class="field">version:</span> 1.0.2 (greg)</li>
31
Located in <a class="field" href="_models---PHPDS_navigation.query.php.html">/models/PHPDS_navigation.query.php</a> (line <span class="field">63</span>)
35
<pre><a href="../../PHPDevShell/PHPDS_dependant.html">PHPDS_dependant</a>
37
--<a href="../../PHPDevShell/[DB-related]/PHPDS_query.html">PHPDS_query</a>
39
--NAVIGATION_extractMenuQuery</pre>
46
<a name="sec-var-summary"></a>
47
<div class="info-box">
48
<div class="info-box-title">Variable Summary</span></div>
50
<a href="#sec-description">Description</a> |
51
<span class="disabled">Vars</span> (<a href="#sec-vars">details</a>)
53
<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
56
<div class="info-box-body">
57
<div class="var-summary">
58
<div class="var-title">
59
<span class="var-type">mixed</span>
60
<a href="#$sql" title="details" class="var-name">$sql</a>
66
<a name="sec-method-summary"></a>
67
<div class="info-box">
68
<div class="info-box-title">Method Summary</span></div>
70
<a href="#sec-description">Description</a> |
71
<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
74
<span class="disabled">Methods</span> (<a href="#sec-methods">details</a>)
76
<div class="info-box-body">
77
<div class="method-summary">
79
<div class="method-definition">
80
<span class="method-result">array</span>
81
<a href="#invoke" title="details" class="method-name">invoke</a>
82
([<span class="var-type"></span> <span class="var-name">$parameters</span> = <span class="var-default">null</span>], <span class="var-type">int</span> <span class="var-name">$limit_favorite_db</span>)
88
<a name="sec-vars"></a>
89
<div class="info-box">
90
<div class="info-box-title">Variables</div>
92
<a href="#sec-description">Description</a> |
93
<a href="#sec-var-summary">Vars</a> (<span class="disabled">details</span>)
97
<a href="#sec-method-summary">Methods</a> (<a href="#sec-methods">details</a>)
100
<div class="info-box-body">
101
<a name="var$sql" id="$sql"><!-- --></A>
104
<div class="var-header">
105
<span class="var-title">
106
<span class="var-type">mixed</span>
107
<span class="var-name">$sql</span>
108
= <span class="var-default"> "<br /> SELECT SQL_CACHE<br /> t1.menu_id, t1.parent_menu_id, t1.menu_name, t1.menu_link, t1.plugin, t1.menu_type, t1.extend, t1.new_window, t1.rank, t1.hide, t1.template_id, t1.alias, t1.layout,<br /> t3.is_parent, t3.type,<br /> t6.template_folder<br /> FROM<br /> _db_core_menu_items t1<br /> LEFT JOIN<br /> _db_core_user_role_permissions t2<br /> ON<br /> t1.menu_id = t2.menu_id<br /> LEFT JOIN<br /> _db_core_menu_structure t3<br /> ON<br /> t1.menu_id = t3.menu_id<br /> LEFT JOIN<br /> _db_core_templates t6<br /> ON<br /> t1.template_id = t6.template_id<br /> WHERE<br /> (t2.user_role_id IN (%s))<br /> ORDER BY<br /> t3.id<br /> ASC<br /> "</span> (line <span class="line-number">65</span>)
112
<!-- ========== Info from phpDoc block ========= -->
114
<li><span class="field">access:</span> protected</li>
118
<hr class="separator" />
119
<div class="notes">Redefinition of:</div>
121
<dt><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$sql">PHPDS_query::$sql</a></dt>
122
<dd>The explicit SQL query</dd>
128
<h4>Inherited Variables</h4>
129
<A NAME='inherited_vars'><!-- --></A>
130
<p>Inherited from <span class="classname"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html">PHPDS_query</a></span></p>
132
<span class="var-title">
133
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$autoProtect">PHPDS_query::$autoProtect</a></span><br>
135
<span class="var-title">
136
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$auto_protect">PHPDS_query::$auto_protect</a></span><br>
138
<span class="var-title">
139
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$cachedResult">PHPDS_query::$cachedResult</a></span><br>
141
<span class="var-title">
142
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$fields">PHPDS_query::$fields</a></span><br>
144
<span class="var-title">
145
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$focus">PHPDS_query::$focus</a></span><br>
147
<span class="var-title">
148
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$groupby">PHPDS_query::$groupby</a></span><br>
150
<span class="var-title">
151
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$keyField">PHPDS_query::$keyField</a></span><br>
153
<span class="var-title">
154
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$limit">PHPDS_query::$limit</a></span><br>
156
<span class="var-title">
157
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$noEmptyRow">PHPDS_query::$noEmptyRow</a></span><br>
159
<span class="var-title">
160
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$no_empty_row">PHPDS_query::$no_empty_row</a></span><br>
162
<span class="var-title">
163
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$orderby">PHPDS_query::$orderby</a></span><br>
165
<span class="var-title">
166
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$returnId">PHPDS_query::$returnId</a></span><br>
168
<span class="var-title">
169
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$return_id">PHPDS_query::$return_id</a></span><br>
171
<span class="var-title">
172
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$singleRow">PHPDS_query::$singleRow</a></span><br>
174
<span class="var-title">
175
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$singleValue">PHPDS_query::$singleValue</a></span><br>
177
<span class="var-title">
178
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$single_row">PHPDS_query::$single_row</a></span><br>
180
<span class="var-title">
181
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$single_value">PHPDS_query::$single_value</a></span><br>
183
<span class="var-title">
184
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$typecast">PHPDS_query::$typecast</a></span><br>
186
<span class="var-title">
187
<span class="var-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#var$where">PHPDS_query::$where</a></span><br>
190
<p>Inherited from <span class="classname"><a href="../../PHPDevShell/PHPDS_dependant.html">PHPDS_dependant</a></span></p>
192
<span class="var-title">
193
<span class="var-name"><a href="../../PHPDevShell/PHPDS_dependant.html#var$dependance">PHPDS_dependant::$dependance</a></span><br>
195
<span class="var-title">
196
<span class="var-name"><a href="../../PHPDevShell/PHPDS_dependant.html#var$parent">PHPDS_dependant::$parent</a></span><br>
203
<a name="sec-methods"></a>
204
<div class="info-box">
205
<div class="info-box-title">Methods</div>
206
<div class="nav-bar">
207
<a href="#sec-description">Description</a> |
208
<a href="#sec-var-summary">Vars</a> (<a href="#sec-vars">details</a>)
209
<a href="#sec-method-summary">Methods</a> (<span class="disabled">details</span>)
212
<div class="info-box-body">
213
<A NAME='method_detail'></A>
215
<a name="methodinvoke" id="invoke"><!-- --></a>
216
<div class="evenrow">
218
<div class="method-header">
219
<span class="method-title">invoke</span> (line <span class="line-number">96</span>)
222
<!-- ========== Info from phpDoc block ========= -->
223
<p class="short-description">Loads favorite control panel menu items.</p>
225
<li><span class="field">access:</span> public</li>
228
<div class="method-signature">
229
<span class="method-result">array</span>
230
<span class="method-name">
233
([<span class="var-type"></span> <span class="var-name">$parameters</span> = <span class="var-default">null</span>], <span class="var-type">int</span> <span class="var-name">$limit_favorite_db</span>)
236
<ul class="parameters">
238
<span class="var-type">int</span>
239
<span class="var-name">$limit_favorite_db</span> </li>
241
<span class="var-type"></span>
242
<span class="var-name">$parameters</span> </li>
245
<hr class="separator" />
246
<div class="notes">Redefinition of:</div>
248
<dt><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodinvoke">PHPDS_query::invoke()</a></dt>
249
<dd>The usual process of a query: check the parameters, send the query to the server, check the results</dd>
253
<h4>Inherited Methods</h4>
254
<a name='inherited_methods'><!-- --></a>
255
<!-- =========== Summary =========== -->
256
<p>Inherited From <span class="classname"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html">PHPDS_query</a></span></p>
258
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#method__construct">PHPDS_query::__construct()</a></span><br>
259
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodaddWhere">PHPDS_query::addWhere()</a></span><br>
260
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodasArray">PHPDS_query::asArray()</a></span><br>
261
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodasLine">PHPDS_query::asLine()</a></span><br>
262
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodasOne">PHPDS_query::asOne()</a></span><br>
263
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodasWhole">PHPDS_query::asWhole()</a></span><br>
264
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodas_array">PHPDS_query::as_array()</a></span><br>
265
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodas_line">PHPDS_query::as_line()</a></span><br>
266
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodas_one">PHPDS_query::as_one()</a></span><br>
267
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodas_whole">PHPDS_query::as_whole()</a></span><br>
268
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodbuild">PHPDS_query::build()</a></span><br>
269
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodcheckParameters">PHPDS_query::checkParameters()</a></span><br>
270
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodcheckResults">PHPDS_query::checkResults()</a></span><br>
271
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodconnector">PHPDS_query::connector()</a></span><br>
272
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodcount">PHPDS_query::count()</a></span><br>
273
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methoddebugInstance">PHPDS_query::debugInstance()</a></span><br>
274
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodextraBuild">PHPDS_query::extraBuild()</a></span><br>
275
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodextra_build">PHPDS_query::extra_build()</a></span><br>
276
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodgetKey">PHPDS_query::getKey()</a></span><br>
277
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodgetResults">PHPDS_query::getResults()</a></span><br>
278
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodget_key">PHPDS_query::get_key()</a></span><br>
279
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodget_results">PHPDS_query::get_results()</a></span><br>
280
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodinvoke">PHPDS_query::invoke()</a></span><br>
281
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodlimit">PHPDS_query::limit()</a></span><br>
282
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodpreBuild">PHPDS_query::preBuild()</a></span><br>
283
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodprotectArray">PHPDS_query::protectArray()</a></span><br>
284
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodprotectString">PHPDS_query::protectString()</a></span><br>
285
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodprotect_array">PHPDS_query::protect_array()</a></span><br>
286
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodquery">PHPDS_query::query()</a></span><br>
287
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodqueryDebug">PHPDS_query::queryDebug()</a></span><br>
288
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodquerySQL">PHPDS_query::querySQL()</a></span><br>
289
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodrows">PHPDS_query::rows()</a></span><br>
290
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodsql">PHPDS_query::sql()</a></span><br>
291
<span class="method-name"><a href="../../PHPDevShell/[DB-related]/PHPDS_query.html#methodtypeCast">PHPDS_query::typeCast()</a></span><br>
293
<!-- =========== Summary =========== -->
294
<p>Inherited From <span class="classname"><a href="../../PHPDevShell/PHPDS_dependant.html">PHPDS_dependant</a></span></p>
296
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#method__construct">PHPDS_dependant::__construct()</a></span><br>
297
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodconstruct">PHPDS_dependant::construct()</a></span><br>
298
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methoddebugInstance">PHPDS_dependant::debugInstance()</a></span><br>
299
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodfactory">PHPDS_dependant::factory()</a></span><br>
300
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodfactoryWith">PHPDS_dependant::factoryWith()</a></span><br>
301
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodinfo">PHPDS_dependant::info()</a></span><br>
302
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodlog">PHPDS_dependant::log()</a></span><br>
303
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#methodPHPDS_dependance">PHPDS_dependant::PHPDS_dependance()</a></span><br>
304
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#method_log">PHPDS_dependant::_log()</a></span><br>
305
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#method__call">PHPDS_dependant::__call()</a></span><br>
306
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#method__get">PHPDS_dependant::__get()</a></span><br>
307
<span class="method-name"><a href="../../PHPDevShell/PHPDS_dependant.html#method__set">PHPDS_dependant::__set()</a></span><br>
314
<p class="notes" id="credit">
315
Documentation generated on Tue, 09 Aug 2011 09:05:15 +0200 by <a href="http://www.phpdoc.org" target="_blank">phpDocumentor 1.4.3</a>
b'\\ No newline at end of file'