suppress some scraping errors when confronted with hybrid/strange

[friendica.git] / update.php

diff --git a/update.php b/update.php
index 5807f1a34e2985d5b18d7f8d4e4ed350bb840cbf..f7bf9da1eda951242963212b824fa9a4ceeab81a 100644 (file)
--- a/update.php
+++ b/update.php
@@ -270,3 +270,61 @@ function update_1027() {
        ) ENGINE = MYISAM DEFAULT CHARSET=utf8 ");
 }
 
+function update_1028() {
+       q("ALTER TABLE `user` ADD `openidserver` text NOT NULL AFTER `deny_gid` ");
+}
+
+function update_1029() {
+       q("ALTER TABLE `contact` ADD `info` MEDIUMTEXT NOT NULL AFTER `reason` ");
+}
+
+function update_1030() {
+       q("ALTER TABLE `contact` ADD `bdyear` CHAR( 4 ) NOT NULL COMMENT 'birthday notify flag' AFTER `profile-id` ");
+
+       q("CREATE TABLE IF NOT EXISTS `event` (
+       `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+       `uid` INT NOT NULL ,
+       `cid` INT NOT NULL ,
+       `created` DATETIME NOT NULL ,
+       `edited` DATETIME NOT NULL ,
+       `start` DATETIME NOT NULL ,
+       `finish` DATETIME NOT NULL ,
+       `desc` TEXT NOT NULL ,
+       `location` TEXT NOT NULL ,
+       `type` CHAR( 255 ) NOT NULL ,
+       `adjust` TINYINT( 1 ) NOT NULL DEFAULT '1',
+       `allow_cid` MEDIUMTEXT NOT NULL ,
+       `allow_gid` MEDIUMTEXT NOT NULL ,
+       `deny_cid` MEDIUMTEXT NOT NULL ,
+       `deny_gid` MEDIUMTEXT NOT NULL
+       ) ENGINE = MYISAM DEFAULT CHARSET=utf8 ");
+
+
+}
+
+function update_1031() {
+       // Repair any bad links that slipped into the item table
+       $r = q("SELECT `id`, `object` FROM `item` WHERE `object` != '' ");
+       if($r && count($r)) {
+               foreach($r as $rr) {
+                       if(strstr($rr['object'],'type="http')) {
+                               q("UPDATE `item` SET `object` = '%s' WHERE `id` = %d LIMIT 1",
+                                       dbesc(str_replace('type="http','href="http',$rr['object'])),
+                                       intval($rr['id'])
+                               );
+                       }
+               }
+       }
+}
+       
+function update_1032() {
+       q("ALTER TABLE `profile` ADD `pdesc` CHAR( 255 ) NOT NULL AFTER `name` ");
+}
+
+function update_1033() {
+       q("CREATE TABLE IF NOT EXISTS `cache` (
+               `k` CHAR( 255 ) NOT NULL PRIMARY KEY ,
+               `v` TEXT NOT NULL,
+               `updated` DATETIME NOT NULL
+               ) ENGINE = MYISAM DEFAULT CHARSET=utf8;");
+}