Revize 96b3e7ed

Re #7580 arabic průběžné úpravy

old/html/multidic/classes/db.php

@@ -12 +12 @@
   var $Host     = "Filek.cz";
   var $Database = "aswi-dictionary";
   var $User     = "dbowner";
-  var $Password = "db486ex12";
+  var $Password = "";
 
   /** @var mysqli_result  */
   var $result = null;
@@ -53 +53 @@
 
     $this->result = $this->connection->query($Query_String);
 
-    if ($this->result) {
-      $this->halt("Invalid SQL: ".$Query_String);
-    }
+//    if ($this->result) {
+//      $this->halt("Invalid SQL: ".$Query_String);
+//    }
 
     return $this->result;
   }

old/html/multidic/examination/article.php

@@ -129 +129 @@
 }
 
 function build_query_article($language, $contrains_source, $contrains_lection,$order, $od, $limit) {
-	  $dotaz = "SELECT DISTINCT ON (ar.\"IDarticle\")
-                         ar.\"IDarticle\"  as \"IDarticle\",
+	  $dotaz = "SELECT DISTINCT 
+                         ar.IDarticle  as IDarticle,
                          ar.title          as title,
                          lan.language      as language,
                          so.title          as source,
@@ -149 +149 @@
   if ($contrains_lection != "all")
     $dotaz .= "AND ar.lection = $contrains_lection";
 
-  $dotaz .= " AND ar.language = lan.\"IDlanguage\"
-              AND ar.source   = so.\"IDsource\" ";
+  $dotaz .= " AND ar.language = lan.IDlanguage
+              AND ar.source   = so.IDsource ";
   if (!empty($order)) {
-  	$orderClause = "ar.\"IDarticle\", \"$order\"";
+  	$orderClause = "ar.IDarticle, $order";
   }
   else {
-    $orderClause = "\"IDarticle\"";
+    $orderClause = "IDarticle";
   }
 
-  $dotaz .= " ORDER BY $orderClause OFFSET $od LIMIT $limit";
+  $dotaz .= " ORDER BY $orderClause LIMIT $limit OFFSET $od";
 
   return $dotaz;
 } // END function build_query_article
@@ -170 +170 @@
   $spojeni = new DB_Sql();
 	$dotaz = build_query_article($language, $contrains_source, $contrains_lection,$order, $od, $limit);
   $radky = $spojeni->query($dotaz);
-  while ($spojeni->next_record()) {
-    //print_r($spojeni->Record);
-    if (!empty($spojeni->Record['title'])) {
-	    $navrat .= "<a href=\"?language=".$_REQUEST['language']."&amp;view_article=".$spojeni->Record['IDarticle']."\">".$spojeni->Record['title']."</a><br />";
+  foreach ($radky as $radka){
+    if (!empty($radka['title'])) {
+	    $navrat .= "<a href=\"?language=".$_REQUEST['language']."&amp;view_article=".$radka['IDarticle']."\">".$radka['title']."</a><br />";
 	}
   }
 	return $navrat;

old/html/multidic/functions/dictionary.php

@@ -183 +183 @@
 function translation_chooser() {
   require_once("./classes/db.php");
   $spojeni = new DB_Sql();
-  $dotaz = "SELECT code FROM translation_lang WHERE NOT visible = 0;";
+  $dotaz = "SELECT code FROM translation_lang WHERE visible <> 0";
   $radky = $spojeni->query($dotaz);
-  while ($spojeni->next_record()) {
-    echo '<a href="?set_lang='.$spojeni->Record["code"].'">'.$spojeni->Record["code"].'</a>&nbsp;';
+  foreach ($radky as $radka) {
+      echo '<a href="?set_lang=' . $radka['code'] . '">' . $radka['code'] . '</a>&nbsp;';
 	}
 }
 
@@ -199 +199 @@
 function insert_picture( $class = "obrazek" ) {
   require_once("./classes/db.php");
   $spojeni = new DB_Sql();
-  $dotaz = "SELECT * FROM pictures ORDER BY Random() LIMIT 1";
+  $dotaz = "SELECT * FROM pictures ORDER BY RAND() LIMIT 1";
   $radky = $spojeni->query($dotaz);
-  if ($spojeni->num_rows() == 0) {
+
+  if(!$radky){
+      echo "Chyba pri vyberu obrazku...";
+      return false;
+  }
+
+  $obrazek = mysqli_fetch_assoc($radky);
+  if (empty($obrazek)) {
     echo "Chyba pri vyberu obrazku...";
     return false;
   }
   else {
-    $spojeni->next_record();
-    $nazev_souboru = $spojeni->Record["name_of_picture"];
-    $cesky = $spojeni->Record["czech"];
-    $anglicky = $spojeni->Record["english"];
-    $arabsky = $spojeni->Record["orig"];
+    $nazev_souboru = $obrazek["name_of_picture"];
+    $cesky = $obrazek["czech"];
+    $anglicky = $obrazek["english"];
+    $arabsky = $obrazek["orig"];
 
   $navrat .= "
 <div id=\"$class\">

old/html/multidic/index-arabic.php

@@ -1 +1 @@
 <?php
 require_once("./functions/dictionary.php");
+require_once("postgresql2mysql.php");
+
 if (!Empty($_GET['akce']) && $_GET['akce'] == "odhlasit") {
   odhlasit();
   $hlaska = lang("Byl jste odhlasen!!!");

old/html/multidic/postgresql2mysql.php

@@ +1 @@
+<?php
+
+/**
+ * Práce se session_register, která v PHP 7.0 není
+ */
+if (!function_exists('session_register'))
+{
+    function session_register($name)
+    {
+        return;
+    }
+}