Mio Technology logo

Moov 200

  • '.$row['thema'].'

    '; echo '

    '.$row['content'].'

    '; echo '
  • '; ?> 'en','nl-be'=>'nl','fr-be'=>'fr','it-it'=>'it','es-es'=>'es','de-de'=>'de'); $lang = $languages['sv-se']; //$categories= array("Overview"=>"All Mio","168"=>"Mio 168","336"=>"Mio 336","A201"=>"Mio A201","8380"=>"Mio 8380","268+"=>"Mio 268+","8390"=>"Mio 8390","269+"=>"Mio 269+","A701"=>"Mio A701","C210"=>"Mio C210","C510"=>"Mio C510","C710"=>"Mio C710","P350"=>"Mio P350","P550"=>"Mio P550","H610"=>"Mio H610","268"=>"Mio 268","269"=>"Mio 269","339"=>"Mio 339","558"=>"Mio 558","C250"=>"Mio C250","C220"=>"Mio C220","C320(t)"=>"Mio C320(t)","C520(t)"=>"Mio C520(t)","A501"=>"Mio A501","C230"=>"Mio C230","C620"=>"Mio C620","A702"=>"Mio A702","C320b"=>"Mio C320b","P360"=>"Mio P360","P560"=>"Mio P560","Moov 200"=>"Moov 200","Moov 330"=>"Moov 330","Moov 370"=>"Moov 370","Moov 210"=>"Moov 210","Moov 310"=>"Moov 310"); $categories=array("Overview"=>"All Mio","168"=>"Mio 168","336"=>"Mio 336","A201"=>"Mio A201","8380"=>"Mio 8380","268+"=>"Mio 268+","8390"=>"Mio 8390","269+"=>"Mio 269+","A701"=>"Mio A701","C210"=>"Mio C210","C510"=>"Mio C510","C710"=>"Mio C710","P350"=>"Mio P350","P550"=>"Mio P550","P360"=>"Mio P360","P560"=>"Mio P560","H610"=>"Mio H610","268"=>"Mio 268","269"=>"Mio 269","339"=>"Mio 339","558"=>"Mio 558","C250"=>"Mio C250","C220"=>"Mio C220","C320(t)"=>"Mio C320(t)","C520(t)"=>"Mio C520(t)","C520"=>"Mio C520(t)","A501"=>"Mio A501","C230"=>"Mio C230","C620"=>"Mio C620","A702"=>"Mio A702","C320b"=>"Mio C320","P360"=>"Mio P360","P560"=>"Mio P560","Moov 200"=>"Moov 200","Moov 330"=>"Moov 330","Moov 370"=>"Moov 370","Moov 210"=>"Moov 210","Moov 310"=>"Moov 310","Moov 300"=>"Moov 300","Moov 580"=>"Moov 580","Moov 560"=>"Moov 560","Moov 510"=>"Moov 510","Moov 500"=>"Moov 500","Moov 150"=>"Moov 150","C728"=>"C728"); $cat=$categories['Moov 200']; /* OPEN AND READ COMMA SEPERATED FILE WITH TOP FAQ IDS IN */ $myFile = "d:\sites\mio-tech.be/upload/faqlist.txt"; $fh = fopen($myFile, 'r'); $faqIDs= fread($fh, filesize($myFile)); fclose($fh); /* END OPEN AND READ */ $conn = mysql_connect('10.15.2.1','connector','connector!1785*') or die ('Error connecting to mysql'); mysql_select_db('faq'); if( strstr($cat,"Moov") OR ($cat=="C728") ){ $sql="SELECT DISTINCT faqdata.id, faqdata.thema, device2article.deviceName, faqvisits.visits FROM faqdata right Join device2article ON faqdata.id = device2article.id left Join faqvisits ON faqvisits.id = faqdata.id WHERE faqdata.lang='".$lang."' AND (device2article.devicename like '%".$cat."%' or device2article.devicename like '%all%' ) AND faqdata.id NOT IN (SELECT faqId FROM approvalqueue WHERE lang='".$lang."' UNION SELECT faqId FROM faqtranslationqueue WHERE translationLang='".$lang."') GROUP BY faqdata.id ORDER BY faqvisits.visits DESC limit 0,15 "; } else{ $sql="SELECT DISTINCT faqdata.id, faqdata.thema FROM faqdata INNER JOIN faqcategoryrelations ON faqdata.id=faqcategoryrelations.record_id INNER JOIN faqcategories ON faqcategoryrelations.category_id=faqcategories.id WHERE faqdata.lang='".$lang."' AND faqdata.id IN(".$faqIDs.") AND faqcategories.name='".$cat."' AND faqdata.id NOT IN (SELECT faqId FROM approvalqueue WHERE lang='".$lang."' UNION SELECT faqId FROM faqtranslationqueue WHERE translationLang='".$lang."') LIMIT 0,15"; } $result = mysql_query($sql) or die(mysql_error()); echo '
    • Top FAQs

        '; while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo '
      • '.$row['thema'].'
      • '; } if(mysql_num_rows($result) < 15 ){ $sqlDelta = "SELECT DISTINCT faqdata.id, faqdata.thema FROM faqdata INNER JOIN faqcategoryrelations ON faqdata.id=faqcategoryrelations.record_id INNER JOIN faqcategories ON faqcategoryrelations.category_id=faqcategories.id Inner Join faqvisits ON faqdata.id = faqvisits.id WHERE faqdata.lang='".$lang."' AND faqdata.id NOT IN(".$faqIDs.") AND faqcategories.name like '%".$cat."%' AND faqdata.id NOT IN (SELECT faqId FROM approvalqueue WHERE lang='".$lang."' UNION SELECT faqId FROM faqtranslationqueue WHERE translationLang='".$lang."') ORDER BY faqvisits.visits DESC LIMIT 0," . (15 - mysql_num_rows($result)); $result = mysql_query($sqlDelta) or die(mysql_error()); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { echo '
      • '.$row['thema'].'
      • '; } } echo '
    '; } ?>