Reply to thread

Message

<blockquote data-quote="joz" data-source="post: 560681" data-attributes="member: 70244">Re: Server console (again <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink&nbsp; &nbsp; ;)" loading="lazy" data-shortname=";)" />)And there you have it!I figured out how to build up the proper array with PHP based upon a correctly formed MySQL nestedset result.here you have it (credit goes to emil, colleague);[php]&nbsp; &nbsp; &nbsp; &nbsp; $menu = $this-&gt;getSubTree(fetchAll($query));&nbsp; &nbsp; &nbsp; &nbsp; return $menu[0]['children'];&nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; private function getSubTree(&amp;$nodes, $prevNodeRgt = false){&nbsp; &nbsp; &nbsp; &nbsp; while($node = current($nodes)){ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if((!$prevNodeRgt ? $node['rgt'] : $prevNodeRgt) &lt; $node['rgt']) return $tree;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; next($nodes);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //Has children?&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($node['rgt'] - $node['lft'] &gt; 1) $node['children'] = $this-&gt;getSubTree($nodes, $node['rgt']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $tree[] = $node;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; return $tree; &nbsp; &nbsp; }[/php]Some more good news; Lord Alderaan (utorrent forum user) pointed me to one of his own projects that might help me tackle the login stuff faster. Have to wait for his project page being back online though <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /></blockquote>

[QUOTE="joz, post: 560681, member: 70244"] [b]Re: Server console (again ;))[/b] And there you have it! I figured out how to build up the proper array with PHP based upon a correctly formed MySQL nestedset result. here you have it (credit goes to emil, colleague); [php] $menu = $this->getSubTree(fetchAll($query)); return $menu[0]['children']; } private function getSubTree(&$nodes, $prevNodeRgt = false){ while($node = current($nodes)){ if((!$prevNodeRgt ? $node['rgt'] : $prevNodeRgt) < $node['rgt']) return $tree; next($nodes); //Has children? if($node['rgt'] - $node['lft'] > 1) $node['children'] = $this->getSubTree($nodes, $node['rgt']); $tree[] = $node; } return $tree; } [/php] Some more good news; Lord Alderaan (utorrent forum user) pointed me to one of his own projects that might help me tackle the login stuff faster. Have to wait for his project page being back online though :) [/QUOTE]

Verification