From 09cc2a8a8cf2554a79b7282b6d76589305627172 2017-06-16 01:27:53 From: darkmorford Date: 2017-06-16 01:27:53 Subject: [PATCH] Merge pull request #4 from mt-site metabox Filesystem and database improvements --- diff --git a/frontend.inc.php b/frontend.inc.php index ff28144..bb7336d 100644 --- a/frontend.inc.php +++ b/frontend.inc.php @@ -288,6 +288,7 @@ function pagehead($caller, $title = 'relax, we understand j00', $style='') + diff --git a/mt-blk_bar-metabox.png b/mt-blk_bar-metabox.png deleted file mode 100644 index 4f3bafd37c224e2527bdd9ff2047c79486aa09fa..0000000000000000000000000000000000000000 GIT binary patch literal 0 Hc$@p5-&mKC79_1Z$!C!BM@02#yB)FU;<<~Q6}-jVle2u-;j-)jCEr}$~Lxk^sMV; zuOG(B#srt1>Sq1_k|#NRn?C1F&zGl9o^vVz5FjEVA|eV?x}n|x5fKp)(LX8d3f=^> z0=-Te>TL|#qjQq*_}rwS-Ubm75mDF*yMp(}x30&dbN)L8H)#@=sQkQi@3=9nmKDsMzp zjYHE3^*Ra5?jD2r(=9M6I<$6pQSwnEDt~Izls7#&67Md}z|_oG*xNj4c6b2*)ixIj zHyzWI8vqnpLiws3j2>YC0NCtqy!A;FzO2^veUz=pMuein=fAdNL0$q3iiBTk&tuK@ zdYo%&g$`r>S0?Wuwk#761y z+Rg@zyCxzcA_|=W9o})HBQSeP9A3OH6-GtE`oal#a()WNjx?gQI79OZ-&>Y})entF z-5EE&KjuV~QIC&T=i;us1WkEeZa=DRE_4flGi@FmJb6A4q2Tii{C3h6$e9>t!0r{< zh>6hNO}=IF2)zDC8vZ!vLA6cA9n&qSTz`$`+zV%o!k*Q+Feo~Ff6R$f&0Sdca2noz zTKjd>NfJtnGjQ`HGXUU@85XQBoB+N4zcW8gL_|dYAEIw$kBb&+g;f+4q=@S$#t5~- zDi+QfB^Ku=3bn#2A`Cil>1PHTqed8nT45EB%}old=_H7~>vF}HnQ=YOF*`l>PPuxDu5?Gs>X%cFMRor$%yr$e$CD(}$SLO(v zbaAbyAVsJZRx#47Xv%GnCGq)&YemzJ8Dicvi?El?6y>Y>pNqj@Fc=I5V>pD2%c!xr z0>|}sH_{R#002fs2e+sDav!^*c+?0T+pTNS`4&$qm z>#%!8HjXr?ShVq|=1~bEA|j$tyKKRGDYv($$Tce3?{nL{Bz?eIb)N!zxXBqGjqNX7 zjn95Khl9;MBN8bIMgTyhQTz8Hg8Th2on&jA|fIRr9l_GT_Nc3+U#yLwRE8{KM6+~)P5a7e~7xAhwEL) z%Q54?AqNbygm;QFP%C1ZWz1la6u)SU_b2LJ#R z6{KKsej=7^IgV|Wc652WvGRd&sJ6MVbN|`DPe4ROMD#BiQ1JG48J(&h?dLBXclzP% z>?uxzo!Xj$2Uiuh>MZ2cWo|!o+nN`vH3V`c5Pkn z7v4RI1hazDXD&XK;l$}qELdBkY1URJ0c#!_kIj1;v8~b$0C;0p1G2_OVfBOKS@04O z5z(+R;5ocN&wOfAOV@zoWQzf(TeUwM)*wsB8XMhjJmSP@H_mkge-l+-Mn#87Y0>EP zboaaYPOFJ2k%)_t;q?m~s&l~-tDx2Ch0h;+_1OC-8J(VPWQ~o2LDu2-rp~|*k5K5{ zx7*u|BMoXu#u*ah4Y0R)Ao`?|^%CMuN=Tj`OhiOP6e@pN@DdRb5fO!pu={IaA|fIp rqP|%05)ly*QCMTaOGHFOL}Beun!wN{6rc(600000NkvXXu0mjfTIMbS diff --git a/sql/001-convert-to-utf8.sql b/sql/001-convert-to-utf8.sql new file mode 100644 index 0000000..8a80e84 --- /dev/null +++ b/sql/001-convert-to-utf8.sql @@ -0,0 +1,43 @@ +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +ALTER TABLE `actor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `admin_log` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `admin_section` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `banner` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `contributor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `fredart` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `media_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `meta` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `meta_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rant` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rant_attachment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `rss_comment` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `scratchpad` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `sponsor` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `static_page` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `strip` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `strip_t` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `support` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `transcript` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `twitter_post` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `twitter_status` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; +ALTER TABLE `twitter_user` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; + +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;