diff options
| author | redmatrix <git@macgirvin.com> | 2016-06-23 18:35:01 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-06-23 18:35:01 -0700 |
| commit | 51e2ef39c221a6f8cd89f8bb9e85a8f374f1fd6c (patch) | |
| tree | 65afb1f43e8611aa487b84a92377cd6985aa715f /install/update.php | |
| parent | b19bbf54736b83afaa26aa11ba95c7816c7f8599 (diff) | |
| download | volse-hubzilla-51e2ef39c221a6f8cd89f8bb9e85a8f374f1fd6c.tar.gz volse-hubzilla-51e2ef39c221a6f8cd89f8bb9e85a8f374f1fd6c.tar.bz2 volse-hubzilla-51e2ef39c221a6f8cd89f8bb9e85a8f374f1fd6c.zip | |
db update for abconfig transition
Diffstat (limited to 'install/update.php')
| -rw-r--r-- | install/update.php | 38 |
1 files changed, 37 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index 241de78e1..3cb5010eb 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1178 ); +define( 'UPDATE_VERSION' , 1179 ); /** * @@ -2325,3 +2325,39 @@ function update_r1177() { return UPDATE_SUCCESS; return UPDATE_FAILED; } + + +function update_r1178() { + + $c2 = null; + + $c1 = q("SELECT channel_id, channel_hash from channel where true"); + if($c1) { + $c2 = q("SELECT id, chan from abconfig where true"); + if($c2) { + for($x = 0; $x < count($c2); $x ++) { + foreach($c1 as $c) { + if($c['channel_hash'] == $c2[$x]['chan']) { + $c2[$x]['chan'] = $c['channel_id']; + break; + } + } + } + } + } + + $r1 = q("ALTER TABLE abconfig CHANGE chan chan int(10) unsigned NOT NULL DEFAULT '0' "); + + if($c2) { + foreach($c2 as $c) { + q("UPDATE abconfig SET chan = %d where id = %d", + intval($c['chan']), + intval($c['id']) + ); + } + } + + if($r1) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +}
\ No newline at end of file |