auto-update - create 's' keys for all users that don't have 'em

1 files changed, 23 insertions, 1 deletions

diff --git a/update.php b/update.php
index 80ec50bd2..2ce83d5ce 100644
--- a/update.php
+++ b/update.php
@@ -40,4 +40,26 @@ function update_1005() {
 	q("ALTER TABLE `user` ADD `spubkey` TEXT NOT NULL AFTER `prvkey` ,
 		ADD `sprvkey` TEXT NOT NULL AFTER `spubkey`");
 
-}
\ No newline at end of file
+}
+
+function update_1006() {
+
+	// create 's' keys for everybody that does not have one
+
+	$r = q("SELECT * FROM `user` WHERE `spubkey` = '' ");
+	if(count($r)) {
+		foreach($r as $rr) {
+			$sres=openssl_pkey_new(array('encrypt_key' => false ));
+			$sprvkey = '';
+			openssl_pkey_export($sres, $sprvkey);
+			$spkey = openssl_pkey_get_details($sres);
+			$spubkey = $spkey["key"];
+			$r = q("UPDATE `user` SET `spubkey` = '%s', `sprvkey` = '%s'
+				WHERE `uid` = %d LIMIT 1",
+				dbesc($spubkey),
+				dbesc($sprvkey),
+				intval($rr['uid'])
+			);
+		}
+	}
+}