14 protected $mysqlObject;
21 protected $maxLevelQuery;
23 public $maxLevel = array();
25 public function __construct($mysqlObject,$protocol,$page,$language,$perm)
27 $this->mysqlObject = $mysqlObject;
28 $this->protocol = $protocol;
30 $this->language = $language;
33 $this->maxLevelQuery = $this->mysqlObject->query(
"SELECT MAX(`level_id`) AS maxlevel FROM `categories` LIMIT 1");
35 while($data = mysql_fetch_assoc($this->maxLevelQuery)){
36 $this->maxLevel[] = $data;
53 public function addItemToMenu($cBase,$cSubBase,$priority,$perm,$lang,$cName,$cHref,$cTitle,$cImage,$cImageAlt)
56 $this->mysqlObject->dbCreateTable(array(
59 'category_id'=>$cBase,
60 'subcategory_id'=>$cSubBase,
64 'category_name'=>
"'$cName'",
65 'category_href'=>
"'$cHref'",
66 'category_title'=>
"'$cTitle'",
67 'category_img'=>
"'$cImage'",
68 'category_img_alt'=>
"'$cImageAlt'"
71 $this->mysqlObject->execute();
81 $this->mysqlObject->dbCreateTable(array(
83 'id'=>array(
'type'=>
'int',
'auto_increment'=>
true,
'primary_key'=>
true),
84 'category_id'=>array(
'type'=>
'int'),
85 'subcategory_id'=>array(
'type'=>
'int'),
86 'sort'=>array(
'type'=>
'int'),
87 'perm'=>array(
'type'=>
'int(4)'),
88 'lang'=>array(
'type'=>
'int(4)'),
89 'category_name'=>array(
'type'=>
'varchar(250)'),
90 'category_href'=>array(
'type'=>
'varchar(250)'),
91 'category_title'=>array(
'type'=>
'varchar(250)'),
92 'category_img'=>array(
'type'=>
'varchar(250)'),
93 'category_img_alt'=>array(
'type'=>
'varchar(250)')
96 $this->mysqlObject->execute();
117 public function generateMenu($subcategory, $level)
120 $query = $this->mysqlObject->query(
"SELECT menu.category_id, menu.category_name, menu.category_href, menu.sort, menu.lang, menu.perm, Deriv1.count FROM " .
"`" .$db.
"`" .
" menu LEFT OUTER JOIN (SELECT subcategory_id, COUNT(*) AS count FROM ".
"`" .$db.
"`".
" GROUP BY subcategory_id) Deriv1 ON menu.category_id = Deriv1.subcategory_id WHERE menu.subcategory_id=".$subcategory.
" AND menu.lang=".$this->language.
" AND menu.perm=".$this->perm.
" ORDER BY menu.sort ASC");
121 $arr[] =
"<ul class='menu-ul-level-".$level.
"'>";
122 while($data = mysql_fetch_assoc($query))
124 $this->href = $this->protocol.
'://'.$_SERVER[
'SERVER_NAME'].
"/".$data[
'category_href'];
126 if($data[
'count'] > 0)
128 $arr[] =
"<li class='menu-li-level-".$level.
"'><a class='menu-a-level-".$level.
"' href='".$this->href.
"'>".$data[
'category_name'].
"</a>";
129 $arr[] = $this->generateMenu($data[
'category_id'], $level + 1);
133 elseif($data[
'count'] == 0)
135 $arr[] =
"<li class='menu-li-level-".$level.
"'><a class='menu-a-level-".$level.
"' href='".$this->href.
"'>".$data[
'category_name'].
"</a></li>";
139 return implode(
"\n", $arr);
153 public function generateMenuLevel($level, $limit, $page){
156 $page = explode(
'/', $page);
160 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
163 while ($data = mysql_fetch_assoc($level_1_query)){
164 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$data[
'category_href'].
"/".$limit.
">".$data[
'category_name'].
"</a></li>";
168 return implode(
"\n", $arr);
173 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
176 while ($level_1 = mysql_fetch_assoc($level_1_query)){
177 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
180 if($level_1[
'category_href'] == $page[1]){
181 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
183 while ($level_2 = mysql_fetch_assoc($level_2_query)){
186 if($level_2[
'category_href'].substr($page[1])){
188 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
194 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
199 return implode(
"\n", $arr);
204 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
207 while ($level_1 = mysql_fetch_assoc($level_1_query)){
208 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
211 if($level_1[
'category_href'] == $page[1]){
212 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
214 while ($level_2 = mysql_fetch_assoc($level_2_query)){
217 if($level_2[
'category_href'].substr($page[1])){
218 $level_3_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_2[
'category_id'].
" ORDER BY sort");
221 if($level_2[
'category_href'] == $page[1].
"/".$page[2]){
222 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
"><b>".$level_2[
'category_name'].
"</b></a>";
224 while ($level_3 = mysql_fetch_assoc($level_3_query)){
228 if($level_3[
'category_href'].substr($page[1].
"/".$page[2])){
229 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
">".$level_3[
'category_name'].
"</a></li>";
235 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
242 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
247 return implode(
"\n", $arr);
252 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
255 while ($level_1 = mysql_fetch_assoc($level_1_query)){
256 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
259 if($level_1[
'category_href'] == $page[1]){
260 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
262 while ($level_2 = mysql_fetch_assoc($level_2_query)){
265 if($level_2[
'category_href'].substr($page[1])){
266 $level_3_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_2[
'category_id'].
" ORDER BY sort");
269 if($level_2[
'category_href'] == $page[1].
"/".$page[2]){
270 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
"><b>".$level_2[
'category_name'].
"</b></a>";
272 while ($level_3 = mysql_fetch_assoc($level_3_query)){
276 if($level_3[
'category_href'].substr($page[1].
"/".$page[2])){
277 $level_4_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_3[
'category_id'].
" ORDER BY sort");
280 if($level_3[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3]){
281 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
"><b>".$level_3[
'category_name'].
"</b></a>";
283 while ($level_4 = mysql_fetch_assoc($level_4_query)){
287 if($level_4[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3])){
288 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
">".$level_4[
'category_name'].
"</a></li>";
294 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
">".$level_3[
'category_name'].
"</a></li>";
301 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
308 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
313 return implode(
"\n", $arr);
318 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
321 while ($level_1 = mysql_fetch_assoc($level_1_query)){
322 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
325 if($level_1[
'category_href'] == $page[1]){
326 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
328 while ($level_2 = mysql_fetch_assoc($level_2_query)){
331 if($level_2[
'category_href'].substr($page[1])){
332 $level_3_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_2[
'category_id'].
" ORDER BY sort");
335 if($level_2[
'category_href'] == $page[1].
"/".$page[2]){
336 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
"><b>".$level_2[
'category_name'].
"</b></a>";
338 while ($level_3 = mysql_fetch_assoc($level_3_query)){
342 if($level_3[
'category_href'].substr($page[1].
"/".$page[2])){
343 $level_4_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_3[
'category_id'].
" ORDER BY sort");
346 if($level_3[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3]){
347 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
"><b>".$level_3[
'category_name'].
"</b></a>";
349 while ($level_4 = mysql_fetch_assoc($level_4_query)){
353 if($level_4[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3])){
354 $level_5_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_4[
'category_id'].
" ORDER BY sort");
357 if($level_4[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4]){
358 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
"><b>".$level_4[
'category_name'].
"</b></a>";
360 while ($level_5 = mysql_fetch_assoc($level_5_query)){
364 if($level_5[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4])){
365 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_5[
'category_href'].
"/".$limit.
">".$level_5[
'category_name'].
"</a></li>";
371 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
">".$level_4[
'category_name'].
"</a></li>";
378 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
">".$level_3[
'category_name'].
"</a></li>";
385 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
392 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
397 return implode(
"\n", $arr);
402 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
405 while ($level_1 = mysql_fetch_assoc($level_1_query)){
406 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
409 if($level_1[
'category_href'] == $page[1]){
410 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
412 while ($level_2 = mysql_fetch_assoc($level_2_query)){
415 if($level_2[
'category_href'].substr($page[1])){
416 $level_3_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_2[
'category_id'].
" ORDER BY sort");
419 if($level_2[
'category_href'] == $page[1].
"/".$page[2]){
420 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
"><b>".$level_2[
'category_name'].
"</b></a>";
422 while ($level_3 = mysql_fetch_assoc($level_3_query)){
426 if($level_3[
'category_href'].substr($page[1].
"/".$page[2])){
427 $level_4_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_3[
'category_id'].
" ORDER BY sort");
430 if($level_3[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3]){
431 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
"><b>".$level_3[
'category_name'].
"</b></a>";
433 while ($level_4 = mysql_fetch_assoc($level_4_query)){
437 if($level_4[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3])){
438 $level_5_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_4[
'category_id'].
" ORDER BY sort");
441 if($level_4[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4]){
442 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
"><b>".$level_4[
'category_name'].
"</b></a>";
444 while ($level_5 = mysql_fetch_assoc($level_5_query)){
448 if($level_5[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4])){
449 $level_6_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_5[
'category_id'].
" ORDER BY sort");
452 if($level_5[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5]){
453 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_5[
'category_href'].
"/".$limit.
"><b>".$level_5[
'category_name'].
"</b></a>";
455 while ($level_6 = mysql_fetch_assoc($level_6_query)){
459 if($level_6[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5])){
460 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_6[
'category_href'].
"/".$limit.
">".$level_6[
'category_name'].
"</a></li>";
466 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_5[
'category_href'].
"/".$limit.
">".$level_5[
'category_name'].
"</a></li>";
473 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
">".$level_4[
'category_name'].
"</a></li>";
480 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
">".$level_3[
'category_name'].
"</a></li>";
487 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
494 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
499 return implode(
"\n", $arr);
504 $level_1_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `level_id` = 1 ORDER BY sort");
507 while ($level_1 = mysql_fetch_assoc($level_1_query)){
508 $level_2_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_1[
'category_id'].
" ORDER BY sort");
511 if($level_1[
'category_href'] == $page[1]){
512 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
"><b>".$level_1[
'category_name'].
"</b></a>";
514 while ($level_2 = mysql_fetch_assoc($level_2_query)){
517 if($level_2[
'category_href'].substr($page[1])){
518 $level_3_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_2[
'category_id'].
" ORDER BY sort");
521 if($level_2[
'category_href'] == $page[1].
"/".$page[2]){
522 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
"><b>".$level_2[
'category_name'].
"</b></a>";
524 while ($level_3 = mysql_fetch_assoc($level_3_query)){
528 if($level_3[
'category_href'].substr($page[1].
"/".$page[2])){
529 $level_4_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_3[
'category_id'].
" ORDER BY sort");
532 if($level_3[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3]){
533 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
"><b>".$level_3[
'category_name'].
"</b></a>";
535 while ($level_4 = mysql_fetch_assoc($level_4_query)){
539 if($level_4[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3])){
540 $level_5_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_4[
'category_id'].
" ORDER BY sort");
543 if($level_4[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4]){
544 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
"><b>".$level_4[
'category_name'].
"</b></a>";
546 while ($level_5 = mysql_fetch_assoc($level_5_query)){
550 if($level_5[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4])){
551 $level_6_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_5[
'category_id'].
" ORDER BY sort");
554 if($level_5[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5]){
555 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_5[
'category_href'].
"/".$limit.
"><b>".$level_5[
'category_name'].
"</b></a>";
557 while ($level_6 = mysql_fetch_assoc($level_6_query)){
561 if($level_6[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5])){
562 $level_7_query = $this->mysqlObject->query(
"SELECT * FROM ".
"`".$db.
"`".
" WHERE `subcategory_id` = ".$level_6[
'category_id'].
" ORDER BY sort");
565 if($level_6[
'category_href'] == $page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5].
"/".$page[6]){
566 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_6[
'category_href'].
"/".$limit.
"><b>".$level_6[
'category_name'].
"</b></a>";
568 while ($level_7 = mysql_fetch_assoc($level_7_query)){
572 if($level_7[
'category_href'].substr($page[1].
"/".$page[2].
"/".$page[3].
"/".$page[4].
"/".$page[5].
"/".$page[6])){
573 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_7[
'category_href'].
"/".$limit.
">".$level_7[
'category_name'].
"</a></li>";
579 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_6[
'category_href'].
"/".$limit.
">".$level_6[
'category_name'].
"</a></li>";
586 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_5[
'category_href'].
"/".$limit.
">".$level_5[
'category_name'].
"</a></li>";
593 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_4[
'category_href'].
"/".$limit.
">".$level_4[
'category_name'].
"</a></li>";
600 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_3[
'category_href'].
"/".$limit.
">".$level_3[
'category_name'].
"</a></li>";
607 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_2[
'category_href'].
"/".$limit.
">".$level_2[
'category_name'].
"</a></li>";
614 $arr[] =
"<li><div class='fin-categories-img'></div><a class='fin-transition-2' href=".
'http://'.$_SERVER[
'SERVER_NAME'].
"/produkty/".$level_1[
'category_href'].
"/".$limit.
">".$level_1[
'category_name'].
"</a></li>";
619 return implode(
"\n", $arr);
633 $page = explode(
'/', PAGE);
637 case 'produkty/'.$page[1].
'/'.$page[2]:
638 echo $this->generateMenuLevel(
"categories", 2,
"0-10", PAGE);
642 case 'produkty/'.$page[1].
'/'.$page[2].
'/'.$page[3]:
643 echo $this->generateMenuLevel(
"categories", 3,
"0-10", PAGE);
647 case 'produkty/'.$page[1].
'/'.$page[2].
'/'.$page[3].
'/'.$page[4]:
648 echo $this->generateMenuLevel(
"categories", 4,
"0-10", PAGE);
652 case 'produkty/'.$page[1].
'/'.$page[2].
'/'.$page[3].
'/'.$page[4].
'/'.$page[5]:
653 echo $this->generateMenuLevel(
"categories", 5,
"0-10", PAGE);
657 case 'produkty/'.$page[1].
'/'.$page[2].
'/'.$page[3].
'/'.$page[4].
'/'.$page[5].
'/'.$page[6]:
658 echo $menuGen->generateMenuLevel(
"categories", 6,
"0-10", PAGE);
662 case 'produkty/'.$page[1].
'/'.$page[2].
'/'.$page[3].
'/'.$page[4].
'/'.$page[5].
'/'.$page[6].
'/'.$page[7]:
663 echo $menuGen->generateMenuLevel(
"categories", 7,
"0-10", PAGE);
667 default: echo $this->generateMenuLevel(
"categories", 1,
"0-10", PAGE);