Changeset 33083

Timestamp:

Feb 22, 2024, 5:40:07 PM (3 months ago)

Author:

ddtddt

Message:

[meta_og] size id

File:

• extensions/meta_og/maintain.class.php (modified) (3 diffs)

extensions/meta_og/maintain.class.php

@@ -3 +3 @@
 // | Meta Open Graph plugin for Piwigo by TEMMII                           |
 // +-----------------------------------------------------------------------+
-// | Copyright(C) 2020-2023 ddtddt               http://temmii.com/piwigo/ |
+// | Copyright(C) 2020-2024 ddtddt               http://temmii.com/piwigo/ |
 // +-----------------------------------------------------------------------+
 // | This program is free software; you can redistribute it and/or modify  |
@@ -28 +28 @@
  global $conf, $prefixeTable, $user;
     $q = 'CREATE TABLE ' . $prefixeTable . 'metaog(
-id SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT,
+id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
 type SMALLINT( 5 ) UNSIGNED NOT NULL,
-idobj SMALLINT( 5 ) UNSIGNED NOT NULL default "0",
+idobj MEDIUMINT(8) UNSIGNED NOT NULL default "0",
 page VARCHAR( 255 ) ,
 metaogtitle VARCHAR( 255 ) NOT NULL ,
@@ -58 +58 @@
   function update($old_version, $new_version, &$errors=array())
   {
-          global $conf;
+          global $conf, $prefixeTable;
+          
+if (!defined('METAOG_TABLE'))define('METAOG_TABLE', $prefixeTable . 'metaog');
+$row = pwg_db_fetch_assoc(pwg_query('SHOW COLUMNS FROM `'.METAOG_TABLE.'` LIKE "idobj";'));
+if (!preg_match('/^mediumint/i', $row['Type'])){
+  $q = 'ALTER TABLE ' . METAOG_TABLE . ' CHANGE `idobj` `idobj` MEDIUMINT(8) UNSIGNED NOT NULL ';
+  pwg_query($q);
+}
+$row = pwg_db_fetch_assoc(pwg_query('SHOW COLUMNS FROM `'.METAOG_TABLE.'` LIKE "id";'));
+if (!preg_match('/^mediumint/i', $row['Type'])){
+  $q = 'ALTER TABLE ' . METAOG_TABLE . ' CHANGE `id` `id` MEDIUMINT(8) UNSIGNED NOT NULL ';
+  pwg_query($q);
+}
           
 if(!isset($conf['mogshowpai'])){if($conf['mogshowpa']==2 | $conf['mogshowpa']==4){$conf['mogshowpai']=true;}else{$conf['mogshowpai']=false;}}