// Force the database to UTF-8 because we'll convert to it

   upgrade_database();

      $result = dbquery("RENAME TABLE  ".$db_prefix."shoutbox  TO ".$db_prefix."shoutbox_old ");

      

      $result_test = dbquery("SELECT * FROM ".$db_prefix."shoutbox_old ");

      $i = 1;

      while ($data_test = dbarray($result_test)) {

         $result1_test = dbquery("SELECT * FROM ".$db_prefix."shoutbox ORDER BY shout_id DESC LIMIT 1");

         if (dbrows($result1_test) != 0) { $data1_test = dbarray($result1_test); $neworder = $data1_test['shout_id'] + 1; } else { $neworder = 1; }

         $r8up_000 = $data_test['shout_id'];

         $r8up_001 = $data_test['shout_name'];

         $r8up_002 = $data_test['shout_message'];

         $r8up_003 = $data_test['shout_datestamp'];

         $r8up_004 = $data_test['shout_ip'];

         $r8up_005 = $data_test['shout_ip_type'];

         $r8up_006 = $data_test['shout_hidden'];

         

         $result2 = dbquery("INSERT INTO ".$db_prefix."shoutbox SET

               shout_id = '".$$r8up_000."',

               shout_name = '".$r8up_001."',

               shout_message = '".$r8up_002."',

               shout_datestamp = '".$r8up_003."',

               shout_ip = '".$r8up_004."',

               shout_ip_type = '".$r8up_005."',

               shout_hidden = '".$r8up_006."'

               ");

         $i++;

      }

         $result3 = dbquery("DROP TABLE ".$db_prefix."shoutbox_old ");

      

      $result0 = dbquery("ALTER TABLE ".$db_prefix."shoutbox CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");



      $result1 = dbquery("ALTER TABLE ".$db_prefix."shoutbox ADD shout_language VARCHAR(50) NOT NULL DEFAULT '' ");

      

      $result2 = dbquery("RENAME TABLE  ".$db_prefix."shoutbox  LIKE ".$db_prefix."shoutbox_old ");



      $result3 = dbquery("INSERT INTO ".$db_prefix."shoutbox SELECT * FROM ".$db_prefix."shoutbox_old");

      

      $result4 = dbquery("DROP TABLE ".$db_prefix."shoutbox_old ");

      $result_test = dbquery("SELECT * FROM ".$db_prefix."shoutbox ");

      $i = 1;

      while ($data_test = dbarray($result_test)) {

         $result1_test = dbquery("UPDATE ".$db_prefix."shoutbox  SET shout_language='".$settings['locale']."'");

         $i++;

      }

$db_connect = @mysql_connect($db_host, $db_user, $db_pass);