{"id":43,"date":"2013-09-29T15:33:02","date_gmt":"2013-09-29T14:33:02","guid":{"rendered":"http:\/\/www.cvsjq.ch\/?page_id=43"},"modified":"2013-09-29T15:33:02","modified_gmt":"2013-09-29T14:33:02","slug":"resultats","status":"publish","type":"page","link":"https:\/\/www.cvsjq.ch\/index.php\/resultats\/","title":{"rendered":"R\u00e9sultats"},"content":{"rendered":"<style type='text\/css'> \n.entry-content th, .comment-content th {\nfont-size: 10px;\ncolor: white;\nbackground-color: #640100;\n}\n.entry-content table, .comment-content table {\nfont-size: 10px;\ncolor: black;\nwidth: 100%;\n}<\/p>\n<\/style>\n<p><?php\n\nfunction querymanager($server, $user, $password, $database, $sql, $headers=1) \n{\n\tglobal $plugin_cf, $plugin_tx;\n\n\tif (!$link = mysql_connect($server, $user, $password)) {\n    echo 'Connexion impossible \u00e0 mysql';\n    exit;\n\t}\n\n\tif (!mysql_select_db($database, $link)) {\n    echo 'S\u00e9lection de base de donn\u00e9es impossible';\n    exit;\n\t}\n\nmysql_query(\"SET NAMES UTF8\", $link);\n\t$result = mysql_query($sql, $link);\n\n\tif (!$result) {\n    echo \"Erreur DB, impossible d'effectuer une requ\u00eaten\";\n    echo 'Erreur MySQL : ' . mysql_error();\n    exit;\n\t}\n\n\tif (($result)||(mysql_errno == 0)) \n\t{ \n\t  echo \"\n\n<table class='RESTABLE' width='100%' cellspacing=0 cellpadding=5>\u00ab\u00a0; <\/p>\n<p>\t\tif (mysql_num_rows($result)>0)<br \/>\n\t  {<br \/>\n\t  \tif ($headers == 1)<br \/>\n\t  \t{<br \/>\n\t\t  \techo \u00ab\u00a0<\/p>\n<tr>\u00ab\u00a0;<br \/>\n\t\t  \t\/\/loop thru the field names to print the correct headers<br \/>\n\t\t    $i = 0;<br \/>\n\t\t    while ($i < mysql_num_fields($result)) \n\t\t    { \n\t\t       echo \"\n\n<th align=left>\u00ab\u00a0. mysql_field_name($result, $i) . \u00ab\u00a0<\/th>\n<p>\u00ab\u00a0;<br \/>\n\t\t       $i++;<br \/>\n\t\t    }<br \/>\n\t\t    echo \u00ab\u00a0<\/tr>\n<p>\u00ab\u00a0;<br \/>\n\t\t  }<\/p>\n<p>\t    \/\/display the data<br \/>\n\t    while ($rows = mysql_fetch_array($result,MYSQL_ASSOC))<br \/>\n\t    {<br \/>\n\t      echo \u00ab\u00a0<\/p>\n<tr>\u00ab\u00a0;<br \/>\n\t      foreach ($rows as $data)<br \/>\n\t      {<br \/>\n\t        echo \u00ab\u00a0<\/p>\n<td align='left'>\u00ab\u00a0. $data . \u00ab\u00a0<\/td>\n<p>\u00ab\u00a0;<br \/>\n\t      }<br \/>\n\t    }<br \/>\n\t  }else{<br \/>\n\t    echo \u00ab\u00a0<\/p>\n<tr width=\\\"100%\\\">\n<td colspan='\" . ($i+1) . \"'>&#8211;<\/td>\n<\/tr>\n<p>\u00ab\u00a0;<br \/>\n\t  }<br \/>\n\t  echo \u00ab\u00a0<\/table>\n<p>\u00ab\u00a0;<br \/>\n\t}else{<br \/>\n\t  echo \u00ab\u00a0Error in running query :\u00a0\u00bb. mysql_error();<br \/>\n\t} <\/p>\n<p>\tmysql_free_result($result);<br \/>\n\t\/\/return $output;<br \/>\n\t\/\/return $qm_out;<br \/>\n}<\/p>\n<p>$server   = &lsquo;localhost&rsquo;;<br \/>\n$database = &lsquo;cvsjq_2010&rsquo;;<br \/>\n$user     = &lsquo;cvsjq2010&rsquo;;<br \/>\n$password = &lsquo;c2v0s1j0q&rsquo;;<br \/>\n$max=2018;<br \/>\n\tif (!isset($_GET[&lsquo;annee&rsquo;]))<br \/>\n\t\t$_GET[&lsquo;annee&rsquo;] = $max;<\/p>\n<p>\tif (!isset($_GET[&lsquo;print&rsquo;]))<br \/>\n\t{<br \/>\n\t\techo \u00ab\u00a0<\/p>\n<hr>\n<p><center>\u00ab\u00a0;<br \/>\n\t\tfor ($i=$max;$i>1994;$i&#8211;)<br \/>\n\t\t{<br \/>\n\t\t\tif ($i == $_GET[&lsquo;annee&rsquo;])<br \/>\n\t\t\t  echo \u00ab\u00a0<a href=?page_id=43&#038;annee=\".$i.\"><b><font size=2>\u00ab\u00a0.$i.\u00a0\u00bb<\/font><\/b><\/a>\u00ab\u00a0;<br \/>\n\t\t\telse<br \/>\n\t\t\t\techo \u00ab\u00a0<a href=?page_id=43&#038;annee=\".$i.\">\u00ab\u00a0.$i.\u00a0\u00bb<\/a>\u00ab\u00a0;<br \/>\n\t\t\tif ($i > 1995)<br \/>\n\t\t\t\techo \u00a0\u00bb &#8211; \u00ab\u00a0;<br \/>\n\t\t}<br \/>\n\t\techo \u00ab\u00a0<\/center>\u00ab\u00a0;<br \/>\n\t\techo \u00ab\u00a0<\/p>\n<hr>\n<p>\u00ab\u00a0;<br \/>\n\t}<\/p>\n<p>\techo \u00ab\u00a0<br \/>\u00ab\u00a0;<\/p>\n<p>echo \u00ab\u00a0<font size=2><b>Finale Junior \u00ab\u00a0.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\necho querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, DATE_FORMAT(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, Cat\u00e9gorie.typeinstrument as Instrument, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldSuperFinale.nbrepoint as Points from OldSuperFinale inner join (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) on (OldSuperFinale.anneeconcours = OldConcurrent.anneeconcours) and (OldSuperFinale.oldnointerne = OldConcurrent.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) order by OldConcurrent.anneeconcours desc , OldSuperFinale.nbrepoint desc, 4&Prime;);<\/p>\n<p>echo \u00ab\u00a0<\/p>\n<hr>\n<p><font size=2><b>R\u00e9sultats Quatuors \u00ab\u00a0.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<\/p>\n<p>\/\/ CATEGORIE SUP<br \/>\n\t\techo \u00ab\u00a0<br \/>Cat\u00e9gorie sup\u00e9rieure\u00a0\u00bb;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select nom as Nom,NbrePoint as Points from OldQuatuor<br \/>\ninner join OldConcoursQuatuor on (OldQuatuor.oldnointerne = OldConcoursQuatuor.oldnointerne)<br \/>\nwhere OldQuatuor.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb and OldConcoursQuatuor.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<br \/>\nand OldQuatuor.oldnocategorie=1<br \/>\norder by nbrepoint desc\u00a0\u00bb);<\/p>\n<p>echo \u00ab\u00a0<br \/>Cat\u00e9gorie moyenne\u00a0\u00bb;<br \/>\necho querymanager($server, $user, $password, $database, \u00ab\u00a0select nom as Nom,NbrePoint as Points from OldQuatuor<br \/>\ninner join OldConcoursQuatuor on (OldQuatuor.oldnointerne = OldConcoursQuatuor.oldnointerne)<br \/>\nwhere OldQuatuor.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb and OldConcoursQuatuor.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<br \/>\nand OldQuatuor.oldnocategorie=2<br \/>\norder by nbrepoint desc\u00a0\u00bb);<\/p>\n<p>echo \u00ab\u00a0<\/p>\n<hr>\n<p><font size=2><b>R\u00e9sultats Championnat Junior \u00ab\u00a0.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<\/p>\n<p>$instr = \u00ab\u00a0Alto\u00a0\u00bb;<br \/>\n\t\techo \u00ab\u00a0<br \/><font size=1><b>\u00ab\u00a0.$instr.\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, date_format(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldFinale.nbrepoint as Points from (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) inner join OldFinale on (OldConcurrent.anneeconcours = OldFinale.anneeconcours) and (OldConcurrent.oldnointerne = OldFinale.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) and Cat\u00e9gorie.TypeInstrument='\u00a0\u00bb.$instr.\u00a0\u00bb&lsquo; order by OldConcurrent.anneeconcours desc , Cat\u00e9gorie.typeinstrument desc , OldFinale.nbrepoint desc , concat(nom,&rsquo; &lsquo;, pr\u00e9nom);\u00a0\u00bb);<\/p>\n<p>\t\t$instr = \u00ab\u00a0Basse\u00a0\u00bb;<br \/>\n\t\techo \u00ab\u00a0<br \/><font size=1><b>\u00ab\u00a0.$instr.\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, date_format(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldFinale.nbrepoint as Points from (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) inner join OldFinale on (OldConcurrent.anneeconcours = OldFinale.anneeconcours) and (OldConcurrent.oldnointerne = OldFinale.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) and Cat\u00e9gorie.TypeInstrument='\u00a0\u00bb.$instr.\u00a0\u00bb&lsquo; order by OldConcurrent.anneeconcours desc , Cat\u00e9gorie.typeinstrument desc , OldFinale.nbrepoint desc , concat(nom,&rsquo; &lsquo;, pr\u00e9nom);\u00a0\u00bb);<br \/>\n\t\t$instr = \u00ab\u00a0Cornet\u00a0\u00bb;<br \/>\n\t\techo \u00ab\u00a0<br \/><font size=1><b>\u00ab\u00a0.$instr.\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, date_format(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldFinale.nbrepoint as Points from (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) inner join OldFinale on (OldConcurrent.anneeconcours = OldFinale.anneeconcours) and (OldConcurrent.oldnointerne = OldFinale.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) and Cat\u00e9gorie.TypeInstrument='\u00a0\u00bb.$instr.\u00a0\u00bb&lsquo; order by OldConcurrent.anneeconcours desc , Cat\u00e9gorie.typeinstrument desc , OldFinale.nbrepoint desc , concat(nom,&rsquo; &lsquo;, pr\u00e9nom);\u00a0\u00bb);<br \/>\n \t\t$instr = \u00ab\u00a0Euphonium\u00a0\u00bb;<br \/>\n\t\techo \u00ab\u00a0<br \/><font size=1><b>\u00ab\u00a0.$instr.\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, date_format(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldFinale.nbrepoint as Points from (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) inner join OldFinale on (OldConcurrent.anneeconcours = OldFinale.anneeconcours) and (OldConcurrent.oldnointerne = OldFinale.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) and Cat\u00e9gorie.TypeInstrument='\u00a0\u00bb.$instr.\u00a0\u00bb&lsquo; order by OldConcurrent.anneeconcours desc , Cat\u00e9gorie.typeinstrument desc , OldFinale.nbrepoint desc , concat(nom,&rsquo; &lsquo;, pr\u00e9nom);\u00a0\u00bb);<br \/>\n \t\t$instr = \u00ab\u00a0Trombone\u00a0\u00bb;<br \/>\n\t\techo \u00ab\u00a0<br \/><font size=1><b>\u00ab\u00a0.$instr.\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0select concat(nom,&rsquo; &lsquo;, pr\u00e9nom) as Nom, date_format(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.titremorceau as Pi\u00e8ce, OldConcurrent.nomcompositeur as Compositeur, OldConcurrent.soci\u00e9t\u00e9 as Soci\u00e9t\u00e9, OldFinale.nbrepoint as Points from (OldConcurrent inner join Cat\u00e9gorie on OldConcurrent.instrument = Cat\u00e9gorie.instrument) inner join OldFinale on (OldConcurrent.anneeconcours = OldFinale.anneeconcours) and (OldConcurrent.oldnointerne = OldFinale.oldnointerne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb) and Cat\u00e9gorie.TypeInstrument='\u00a0\u00bb.$instr.\u00a0\u00bb&lsquo; order by OldConcurrent.anneeconcours desc , Cat\u00e9gorie.typeinstrument desc , OldFinale.nbrepoint desc , concat(nom,&rsquo; &lsquo;, pr\u00e9nom);\u00a0\u00bb);<br \/>\n\t\techo \u00ab\u00a0<\/p>\n<hr>\n<p><font size=2><b>R\u00e9sultats Championnat Minimes \u00ab\u00a0.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb<\/b><\/font>\u00ab\u00a0;<br \/>\n\t\techo querymanager($server, $user, $password, $database, \u00ab\u00a0SELECT concat(Nom,&rsquo; &lsquo;,Pr\u00e9nom) AS Nom, DATE_FORMAT(OldConcurrent.datenaissance, &lsquo;%d.%m.%y&rsquo;) as Naissance, OldConcurrent.TitreMorceau AS Pi\u00e8ce, OldConcurrent.NomCompositeur AS Compositeur, OldConcurrent.Soci\u00e9t\u00e9, OldConcurrent.Instrument,OldFinaleMinime.NbrePoint AS Points<br \/>\nFROM (OldConcurrent INNER JOIN Cat\u00e9gorie ON OldConcurrent.Instrument = Cat\u00e9gorie.Instrument) INNER JOIN OldFinaleMinime ON (OldConcurrent.AnneeConcours = OldFinaleMinime.AnneeConcours) AND (OldConcurrent.OldNoInterne = OldFinaleMinime.OldNoInterne) and (OldConcurrent.anneeconcours=\u00a0\u00bb.$_GET[&lsquo;annee&rsquo;].\u00a0\u00bb)<br \/>\nORDER BY OldFinaleMinime.AnneeConcours DESC , OldFinaleMinime.NbrePoint DESC , Concat(Nom,&rsquo; &lsquo;,Pr\u00e9nom);\u00a0\u00bb);<\/p>\n<p>?><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-templates\/full-width.php","meta":{"footnotes":""},"class_list":["post-43","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/pages\/43","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/comments?post=43"}],"version-history":[{"count":0,"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/pages\/43\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.cvsjq.ch\/index.php\/wp-json\/wp\/v2\/media?parent=43"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}