Changeset 361 for trunk/admin/aggiornadb.php

Timestamp:

Mar 17, 2022, 4:12:48 PM (3 years ago)

Author:

roby

Message:

Terzo aggiornamento con modifiche per la gestione delle funzioni per cellulare oltre modifiche alla funzione di autorizzazione.

File:

• trunk/admin/aggiornadb.php (modified) (2 diffs)

trunk/admin/aggiornadb.php

@@ -98 +98 @@
 {
         $sql="alter table `".$prefix."_config` change column `Versione` `versione` int(3)";
+        $ret=aggiorna($sql,$dbi,'',$num);
+}       
+
+if(!controllo($prefix.'__ele_voti_parziale','data',++$num))
+{
+        $sql="ALTER TABLE `".$prefix."_ele_voti_parziale` CHANGE `data` `data` DATE NOT NULL DEFAULT '1900-01-01'";
+        $ret=aggiorna($sql,$dbi,'',$num);
+}       
+
+if(!controllo($prefix.'__ele_rilaff','data',++$num))
+{
+        $sql="ALTER TABLE `".$prefix."_ele_rilaff` CHANGE `data` `data` DATE NOT NULL DEFAULT '1900-01-01'";
         $ret=aggiorna($sql,$dbi,'',$num);
 }       
@@ -361 +373 @@
 $ret=aggiorna_index($tab,$ind,$dbi,$sql2,++$num);
 
-
+echo "<br>Modifica Charset del database<br>";
+#$sql="ALTER DATABASE $dbname CHARACTER SET 'utf8' COLLATE 'utf8_general_ci'";
+#$res = $dbi->prepare("$sql");
+#$res->execute();
+# alter table $table DEFAULT CHARSET=utf8 COLLATE utf8_general_ci
+$sql="SELECT table_name,column_name,column_default,column_type,is_nullable FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$dbname' and (character_set_name='latin1' or collation_name like 'latin%')";
+$res = $dbi->prepare("$sql");
+$res->execute();
+$tab='';
+while(list($nometab,$campo,$def,$tipo,$nul)=$res->fetch(PDO::FETCH_NUM)) {
+        if($tab!=$nometab){
+                $sql="alter table $nometab DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
+                try{
+                        $res2 = $dbi->prepare("$sql");
+                        $res2->execute();
+        }
+                catch(PDOException $e)
+                {
+                        die( $sql . "<br>" . $e->getMessage());
+                } 
+                $tab=$nometab; echo "Tabella: $nometab<br>";
+        }
+        if($def!='') $default="DEFAULT '$def'"; else $default='';
+        if($nul=='NO') $nullable='NOT NULL'; else $nullable='NULL';
+        $sql="ALTER TABLE $nometab CHANGE $campo $campo $tipo CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' $nullable $default;";      
+        echo "-- $campo<br>";
+        try{
+                        $res2 = $dbi->prepare("$sql");
+                        $res2->execute();
+        }
+                catch(PDOException $e)
+                {
+                        $default="DEFAULT $def";
+                        $sql="ALTER TABLE $nometab CHANGE $campo $campo $tipo CHARACTER SET 'utf8' COLLATE 'utf8_general_ci' $nullable $default;";      
+                        try{
+                                        $res2 = $dbi->prepare("$sql");
+                                        $res2->execute();
+                                }
+                                catch(PDOException $e)
+                                {
+                                        die( $sql . "<br>" . $e->getMessage());
+                                } 
+                }
+}
+ $sql="SELECT table_name FROM INFORMATION_SCHEMA.tables WHERE TABLE_SCHEMA = '$dbname' and table_collation like 'latin%'";
+ $res = $dbi->prepare("$sql");
+ $res->execute();
+$tab='';
+while(list($nometab)=$res->fetch(PDO::FETCH_NUM)) {
+                $sql="alter table $nometab DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
+                try{
+        echo "Tabella: $nometab <br>";
+                        $res2 = $dbi->prepare("$sql");
+                        $res2->execute();
+        }
+                catch(PDOException $e)
+                {
+                        die( $sql . "<br>" . $e->getMessage());
+                } 
+}
+echo "<br><br>";
 ?>