source: trunk/install/db/84-database.php @ 5981

Revision 5981, 2.7 KB checked in by patdenice, 9 years ago (diff)

feature 1502: migrate other template than yoga.

Line 
1<?php
2// +-----------------------------------------------------------------------+
3// | Piwigo - a PHP based picture gallery                                  |
4// +-----------------------------------------------------------------------+
5// | Copyright(C) 2008-2010 Piwigo Team                  http://piwigo.org |
6// | Copyright(C) 2003-2008 PhpWebGallery Team    http://phpwebgallery.net |
7// | Copyright(C) 2002-2003 Pierrick LE GALL   http://le-gall.net/pierrick |
8// +-----------------------------------------------------------------------+
9// | This program is free software; you can redistribute it and/or modify  |
10// | it under the terms of the GNU General Public License as published by  |
11// | the Free Software Foundation                                          |
12// |                                                                       |
13// | This program is distributed in the hope that it will be useful, but   |
14// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
15// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
16// | General Public License for more details.                              |
17// |                                                                       |
18// | You should have received a copy of the GNU General Public License     |
19// | along with this program; if not, write to the Free Software           |
20// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
21// | USA.                                                                  |
22// +-----------------------------------------------------------------------+
23
24if (!defined('PHPWG_ROOT_PATH'))
25{
26  die('Hacking attempt!');
27}
28
29$upgrade_description = 'Update default template to default theme.';
30
31$query = '
32ALTER TABLE '.USER_INFOS_TABLE.'
33  CHANGE COLUMN template theme varchar(255) NOT NULL default \'Sylvia\'
34;';
35
36pwg_query($query);
37
38$query = '
39SELECT user_id, theme
40  FROM '.USER_INFOS_TABLE.'
41;';
42
43$result = pwg_query($query);
44
45$users = array();
46while ($row = pwg_db_fetch_assoc($result))
47{
48  list($user_template, $user_theme) = explode('/', $row['theme']);
49
50  switch ($user_template)
51  {
52    case 'yoga':
53      break;
54
55    case 'gally':
56      $user_theme = 'gally-'.$user_theme;
57      break;
58
59    case 'floPure':
60      $user_theme = 'Pure_'.$user_theme;
61      break;
62
63    case 'floOs':
64      $user_theme = 'OS_'.$user_theme;
65      break;
66
67    case 'simple':
68      $user_theme = 'simple-'.$user_theme;
69      break;
70
71    default:
72      $user_theme = 'Sylvia';
73  }
74
75  array_push($users, array(
76    'user_id' => $row['user_id'],
77    'theme' => $user_theme
78    )
79  );
80}
81
82mass_updates(
83  USER_INFOS_TABLE,
84  array(
85    'primary' => array('user_id'),
86    'update'  => array('theme')
87    ),
88  $users
89  );
90
91echo
92"\n"
93. $upgrade_description
94."\n"
95;
96?>
Note: See TracBrowser for help on using the repository browser.