Changeset 1099127

Timestamp:

02/25/2015 10:59:13 AM (11 years ago)

Author:

kushsharma

Message:

Option to update database table charset utf8

Location:

kush-micro-news/trunk

Files:

• includes/admin.php (modified) (3 diffs)
• index.php (modified) (1 diff)
• readme.txt (modified) (2 diffs)

kush-micro-news/trunk/includes/admin.php

@@ -24 +24 @@
 $what='';
 //$_POST = array_map('stripslashes_deep', $_POST['myRename']);
+
 if(isset($_POST['valSub']))
 {
@@ -238 +239 @@
         <br><hr>
         Download Backup of your Micro News data : <a href="?backup=true" target="_blank" class="button-primary">Download</a>
+
+
+        <br><hr>
+        Update table storage(to support utf-8 charset): <a href="?updatedb=true" target="_blank" class="button-primary">Update</a>
+        <h5 style="display:inline-block;margin:0;">Create a backup first.</h5>
     </form> 
     <br><br>
@@ -255 +261 @@
 </script>
 <?php
+}
+
+if(isset($_GET['updatedb']) && $_GET['updatedb']=='true')
+    update_table();
+function update_table(){
+    global $wpdb;
+    $table_name = $wpdb->prefix . "kushmicronews";
+            
+    $rows_affected = $wpdb->query("ALTER TABLE `$table_name` CONVERT TO CHARACTER SET utf8");
+    if($rows_affected == 1)
+        echo 'Updated Successfully!';
+                
 }
 

kush-micro-news/trunk/index.php

@@ -3 +3 @@
 Plugin Name: Kush Micro News
 Description: Spread the news in shortest possible way. Use links to refer data and title to concise it.
-Version: 1.5.2
+Version: 1.5.3
 Author: Kush Sharma
 Author Email: thekushsharma@gmail.com 
 Author URI: http://softnuke.com/
 Plugin URI: https://github.com/kushsharma/micro-news
-Last Officially Updated: 08 Feb 2015
+Last Officially Updated: 25 Feb 2015
 */
 

kush-micro-news/trunk/readme.txt

@@ -4 +4 @@
 Tags: post,news,micro,short,share,link,kush,refer,concise,fast
 Requires at least: 3.0.1
-Tested up to: 4.1
-Stable tag: 1.5.2
+Tested up to: 4.2
+Stable tag: 1.5.3
 License: GPLv2 or later
 License URI: http://www.gnu.org/licenses/gpl-2.0.html
@@ -83 +83 @@
 
 == Changelog ==
+
+= 1.5.3 =
+* Added option: Update database table to charset UTF8.
 
 = 1.5.2 =