Changeset 378 for trunk/admin/admin.php

Timestamp:

Oct 3, 2022, 5:35:26 PM (2 years ago)

Author:

roby

Message:

ADMIN

• aggiunta funzione sperimentale e parziale per l'aggiornamento automatico all'ultima rev

File:

• trunk/admin/admin.php (modified) (1 diff)

trunk/admin/admin.php

@@ -206 +206 @@
         $_SESSION['ed_user']=$row['ed_user'];
         $multicomune=$row['multicomune'];
-} 
+}
+if(!isset($_SESSION['aggiornamento']) and isset($_SESSION['aid']) and ChiSei(0)==256)
+{
+        $sql="SELECT COLUMN_NAME
+        FROM INFORMATION_SCHEMA.COLUMNS
+        WHERE TABLE_SCHEMA = '$dbname'
+        AND TABLE_NAME = '".$prefix."_config'
+        AND COLUMN_NAME = 'aggiornamento'";
+        $sth = $dbi->prepare($sql);
+        $sth->execute();
+        if($sth->rowCount()) 
+        {
+                $sth = $dbi->prepare("select aggiornamento from ".$prefix."_config");
+                $sth->execute();
+                list($agg)=$sth->fetch(PDO::FETCH_NUM);
+                $_SESSION['aggiornamento']=$agg;
+                if($agg) include('aggiornamento.php');
+        }else{
+                $sql="ALTER TABLE `soraldo_config` ADD `aggiornamento` ENUM('0','1','2') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '2' AFTER `ed_user`;";
+                $sth = $dbi->prepare($sql);
+                $sth->execute();
+        }
+}
 //fine
         if (isset($param['tema'])) $_SESSION['tema']=$param['tema'];