Changeset 31822

Timestamp:

May 19, 2017, 2:46:22 PM (7 years ago)

Author:

plg

Message:

compatibility MySQL 5.7, insert must not give empty id

File:

• extensions/AMenuManager/amm_root.class.inc.php (modified) (3 diffs)

extensions/AMenuManager/amm_root.class.inc.php

@@ -224 +224 @@
     if($id=='')
     {
-      $sql="INSERT INTO ".$this->tables['urls']." VALUES
-            ('',
+      $sql="INSERT INTO ".$this->tables['urls']." (label,url,mode,icon,position,visible,accessUsers,accessGroups) VALUES
+            (
              '".$label."',
              '".$url."',
@@ -430 +430 @@
     if($id=='')
     {
-      $sql="INSERT INTO ".$this->tables['personalised']." VALUES
-            ('',
+      $sql="INSERT INTO ".$this->tables['personalised']." (visible,nfo) VALUES
+            (
              '$visible',
              '".$nfo."'
@@ -462 +462 @@
       {
         $values[]="('$id',
-                    '".$lang['lang']."',
+                    '".substr($lang['lang'],0,5)."',
                     '".pwg_db_real_escape_string(stripslashes($lang['title']))."',
                     '".pwg_db_real_escape_string(stripslashes($lang['content']))."')";