Convert jah_purity menu function help - Joomla! Forum - community, help and support

hey - how's things?

i'm looking jah_purity menu function joomla 2.5 , keep getting error. know template related site works if change this

code: select all

500 - jdatabasemysql::query: 1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near '' @ line 1 sql=select parent_id, menutype, ordering #_menu id = 132 limit 1

has done previously? have far

code: select all

function getcurrentmenuindex(){
      $itemid = jrequest::getint( 'itemid');
      $database      =& jfactory::getdbo();
      $id = $itemid;
      $menutype = 'mainmenu';
      $ordering = '0';
      while (1){
         $sql = "select parent_id, menutype, ordering #_menu id = $id limit 1";
         $database->setquery($sql);
         $row = null;
         $row = $database->loadobject();
         if ($row) {
            $menutype = $row->menutype;
            $ordering = $row->ordering;
            if ($row->parent_id > 0)
            {
               $id = $row->parent_id;
            }else break;
         }else break;
      }

      $user   =& jfactory::getuser();
      $sql = 'select count(*) #__menu m'
         . ' menutype=' . $database -> quote($menutype)
         . ' , published=1 , parent_id=0 , ordering < ' . $ordering
      ;
      if (isset($user)) {
         $aid = $user->get('aid', 0);
         $sql .= " , access <= '$aid'";
      }
      $database->setquery($sql);

      return $database->loadresult();
   }

any ideas?