Changeset 2339
- Timestamp:
- May 15, 2008, 12:25:36 AM (16 years ago)
- Location:
- trunk
- Files:
-
- 15 edited
- 1 moved
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin.php
r2328 r2339 136 136 } 137 137 138 // Add the P hpWebGalleryOfficial menu138 // Add the Piwigo Official menu 139 139 $template->assign( 'pwgmenu', pwg_URL() ); 140 140 -
trunk/admin/cat_options.php
r2324 r2339 129 129 { 130 130 // theoretically, all categories in $_POST['cat_false'] contain at 131 // least one element, so P hpWebGallerycan find a representant.131 // least one element, so Piwigo can find a representant. 132 132 set_random_representant($_POST['cat_false']); 133 133 break; -
trunk/admin/include/functions.php
r2333 r2339 221 221 // destruction of the caddie associated with the user 222 222 CADDIE_TABLE, 223 // deletion of p hpwebgalleryspecific informations223 // deletion of piwigo specific informations 224 224 USER_INFOS_TABLE, 225 225 ); … … 1695 1695 1696 1696 /** 1697 * Create an XML file with P hpWebGalleryinformations about a list of1697 * Create an XML file with Piwigo informations about a list of 1698 1698 * pictures. 1699 1699 * 1700 1700 * The goal of the export feature is to make easier the reading of 1701 * informations related to pictures outside of P hpWebGallery.1701 * informations related to pictures outside of Piwigo. 1702 1702 * 1703 1703 * @param array image_ids … … 1786 1786 1787 1787 /** 1788 * Refer main P hpWebGalleryURLs (currently PHPWG_DOMAIN domain)1788 * Refer main Piwigo URLs (currently PHPWG_DOMAIN domain) 1789 1789 * 1790 1790 * @param void -
trunk/admin/include/functions_upgrade.php
r2299 r2339 24 24 function check_upgrade() 25 25 { 26 // Is P hpWebGalleryalready installed ?26 // Is Piwigo already installed ? 27 27 if (!defined('PHPWG_IN_UPGRADE') or !PHPWG_IN_UPGRADE) 28 28 { 29 $message = 'P hpWebGalleryis not in upgrade mode. In include/mysql.inc.php,29 $message = 'Piwigo is not in upgrade mode. In include/mysql.inc.php, 30 30 insert line 31 31 <pre style="background-color:lightgray"> -
trunk/admin/ws_checker.php
r2299 r2339 294 294 preg_match('/\d\d\d/', $response, $status_code); 295 295 switch( $status_code[0] ) { 296 296 case 200: 297 297 $ws_status = l10n('Web Services under control'); 298 299 300 $ws_status = 'PhpWebGalleryWeb Services failed and returned an '298 break; 299 case 503: 300 $ws_status = 'Piwigo Web Services failed and returned an ' 301 301 . 'HTTP status of 503. Service is unavailable. An internal ' 302 302 . 'problem prevented us from returning data to you.'; 303 304 305 $ws_status = 'PhpWebGalleryWeb Services failed and returned an '303 break; 304 case 403: 305 $ws_status = 'Piwigo Web Services failed and returned an ' 306 306 . 'HTTP status of 403. Access is forbidden. You do not have ' 307 307 . 'permission to access this resource, or are over ' 308 308 . 'your rate limit.'; 309 310 311 312 $ws_status = 'PhpWebGalleryWeb Services failed and returned an '309 break; 310 case 400: 311 // You may want to fall through here and read the specific XML error 312 $ws_status = 'Piwigo Web Services failed and returned an ' 313 313 . 'HTTP status of 400. Bad request. The parameters passed ' 314 314 . 'to the service did not match as expected. The exact ' 315 315 . 'error is returned in the XML response.'; 316 317 318 $ws_status = 'PhpWebGalleryWeb Services returned an unexpected HTTP '316 break; 317 default: 318 $ws_status = 'Piwigo Web Services returned an unexpected HTTP ' 319 319 . 'status of:' . $status_code[0]; 320 320 } -
trunk/feed.php
r2299 r2339 137 137 138 138 $item->date = mysqldt_to_ts($dbnow); 139 $item->author = 'P hpWebGallerynotifier';139 $item->author = 'Piwigo notifier'; 140 140 $item->guid= sprintf('%s', $dbnow);; 141 141 … … 189 189 190 190 $item->date = mysqldt_to_ts($date); 191 $item->author = 'P hpWebGallerynotifier';191 $item->author = 'Piwigo notifier'; 192 192 $item->guid= sprintf('%s', 'pics-'.$date);; 193 193 -
trunk/include/config_default.inc.php
r2334 r2339 141 141 $conf['tn_height'] = 128; 142 142 143 // show_version : shall the version of P hpWebGallerybe displayed at the143 // show_version : shall the version of Piwigo be displayed at the 144 144 // bottom of each page ? 145 145 $conf['show_version'] = true; … … 152 152 // for each link is associated a label 153 153 // $conf['links'] = array( 154 // 'http://p hpwebgallery.net' => 'PWG website',154 // 'http://piwigo.org' => 'PWG website', 155 155 // 'http://forum.phpwebgallery.net' => 'PWG forum', 156 156 // 'http://phpwebgallery.net/doc' => 'PWG wiki' … … 161 161 // you can pass a array with different optional parameter values 162 162 // $conf['links'] = array( 163 // 'http://p hpwebgallery.net' => array('label' => 'PWG website', 'new_window' => false, 'eval_visible' => 'return true;'),163 // 'http://piwigo.org' => array('label' => 'PWG website', 'new_window' => false, 'eval_visible' => 'return true;'), 164 164 // 'http://forum.phpwebgallery.net' => array('label' => 'For ADMIN', 'new_window' => true, 'eval_visible' => 'return is_admin();'), 165 165 // 'http://phpwebgallery.net/doc' => array('label' => 'For Guest', 'new_window' => true, 'eval_visible' => 'return is_a_guest();'), … … 186 186 // Equivalence: 187 187 // $conf['links'] = array( 188 // 'http://p hpwebgallery.net' => 'PWG website',188 // 'http://piwigo.org' => 'PWG website', 189 189 // ); 190 190 // $conf['links'] = array( 191 // 'http://p hpwebgallery.net' => array('label' => 'PWG website', 'new_window' => false, 'visible' => 'return true;'),191 // 'http://piwigo.org' => array('label' => 'PWG website', 'new_window' => false, 'visible' => 'return true;'), 192 192 // ); 193 193 // … … 224 224 $conf['display_fromto'] = false; 225 225 226 // allow_random_representative : do you wish P hpWebGalleryto search among226 // allow_random_representative : do you wish Piwigo to search among 227 227 // categories elements a new representative at each reload ? 228 228 // … … 322 322 $conf['use_iptc'] = false; 323 323 324 // use_iptc_mapping : in which IPTC fields will P hpWebGalleryfind image324 // use_iptc_mapping : in which IPTC fields will Piwigo find image 325 325 // information ? This setting is used during metadata synchronisation. It 326 // associates a p hpwebgallery_images column name to a IPTC key326 // associates a piwigo_images column name to a IPTC key 327 327 $conf['use_iptc_mapping'] = array( 328 328 'keywords' => '2#025', … … 430 430 431 431 // users_table: which table is the reference for users? Can be a different 432 // table than P hpWebGallerytable432 // table than Piwigo table 433 433 // 434 434 // If you decide to use another table than the default one, you need to 435 435 // prepare your database by deleting some datas : 436 436 // 437 // delete from p hpwebgallery_user_access;438 // delete from p hpwebgallery_user_cache;439 // delete from p hpwebgallery_user_feed;440 // delete from p hpwebgallery_user_group;441 // delete from p hpwebgallery_user_infos;442 // delete from p hpwebgallery_sessions;443 // delete from p hpwebgallery_rate;444 // update p hpwebgallery_images set average_rate = NULL;445 // delete from p hpwebgallery_caddie;446 // delete from p hpwebgallery_favorites;437 // delete from piwigo_user_access; 438 // delete from piwigo_user_cache; 439 // delete from piwigo_user_feed; 440 // delete from piwigo_user_group; 441 // delete from piwigo_user_infos; 442 // delete from piwigo_sessions; 443 // delete from piwigo_rate; 444 // update piwigo_images set average_rate = null; 445 // delete from piwigo_caddie; 446 // delete from piwigo_favorites; 447 447 // 448 448 // All informations contained in these tables and column are related to 449 // p hpwebgallery_users table.449 // piwigo_users table. 450 450 $conf['users_table'] = $prefixeTable.'users'; 451 451 -
trunk/include/functions.inc.php
r2333 r2339 467 467 } 468 468 469 //-------------------------------------------- P hpWebGalleryspecific functions469 //-------------------------------------------- Piwigo specific functions 470 470 471 471 /** … … 914 914 915 915 /* returns the relative path of the thumnail with regards to to the root 916 of p hpwebgallery(not the current page!).This function is not intended to be916 of piwigo (not the current page!).This function is not intended to be 917 917 called directly from code.*/ 918 918 function get_thumbnail_location($element_info) … … 1392 1392 * in descending order of preference: 1393 1393 * param language, user language, default language 1394 * P hpWebGallerydefault language.1394 * Piwigo default language. 1395 1395 * 1396 1396 * @param string filename -
trunk/include/functions_category.inc.php
r2325 r2339 189 189 // get_local_dir 190 190 // Example : "pets > rex > 1_year_old" is on the the same site as the 191 // P hpWebGalleryfiles and this category has 22 for identifier191 // Piwigo files and this category has 22 for identifier 192 192 // get_complete_dir(22) returns "./galleries/pets/rex/1_year_old/" 193 193 function get_complete_dir( $category_id ) … … 198 198 // get_local_dir returns an array with complete path without the site url 199 199 // Example : "pets > rex > 1_year_old" is on the the same site as the 200 // P hpWebGalleryfiles and this category has 22 for identifier200 // Piwigo files and this category has 22 for identifier 201 201 // get_local_dir(22) returns "pets/rex/1_year_old/" 202 202 function get_local_dir( $category_id ) -
trunk/include/functions_cookie.inc.php
r2299 r2339 22 22 // +-----------------------------------------------------------------------+ 23 23 24 // cookie_path returns the path to use for the P hpWebGallerycookie.25 // If P hpWebGalleryis installed on :24 // cookie_path returns the path to use for the Piwigo cookie. 25 // If Piwigo is installed on : 26 26 // http://domain.org/meeting/gallery/category.php 27 27 // cookie_path will return : "/meeting/gallery" -
trunk/include/functions_mail.inc.php
r2299 r2339 68 68 * - email_webmaster: mail corresponding to $conf['webmaster_id'] 69 69 * - formated_email_webmaster: the name of webmaster is $conf['gallery_title'] 70 * - text_footer: P hpWebGalleryand version70 * - text_footer: Piwigo and version 71 71 * 72 72 * @return array … … 523 523 524 524 /* 525 * sends an email, using P hpWebGalleryspecific informations525 * sends an email, using Piwigo specific informations 526 526 * 527 527 * @param: … … 531 531 * o Cc: array of carbon copy receivers of the mail. [default value empty] 532 532 * o Bcc: array of blind carbon copy receivers of the mail. [default value empty] 533 * o subject [default value 'P hpWebGallery']533 * o subject [default value 'Piwigo'] 534 534 * o content: content of mail [default value ''] 535 535 * o content_format: format of mail content [default value 'text/plain'] … … 576 576 if (empty($args['subject'])) 577 577 { 578 $args['subject'] = 'P hpWebGallery';578 $args['subject'] = 'Piwigo'; 579 579 } 580 580 // Spring cleaning … … 752 752 * - result of other sendmail 753 753 * - to: Receiver or receiver(s) of the mail. 754 * - subject [default value 'P hpWebGallery']754 * - subject [default value 'Piwigo'] 755 755 * - content: content of mail 756 756 * - headers: headers of mail -
trunk/include/functions_plugins.inc.php
r2299 r2339 23 23 24 24 /* 25 Events and event handlers are the core of P hpWebGalleryplugin management.25 Events and event handlers are the core of Piwigo plugin management. 26 26 Plugins are addons that are found in plugins subdirectory. If activated, PWG 27 27 will include the index.php of each plugin. -
trunk/install.php
r2299 r2339 143 143 //----------------------------------------------------- variable initialization 144 144 145 define('DEFAULT_PREFIX_TABLE', 'p hpwebgallery_');145 define('DEFAULT_PREFIX_TABLE', 'piwigo_'); 146 146 147 147 // Obtain various vars … … 173 173 { 174 174 include($config_file); 175 // Is P hpWebGalleryalready installed ?175 // Is Piwigo already installed ? 176 176 if (defined("PHPWG_INSTALLED")) 177 177 { 178 die('P hpWebGalleryis already installed');178 die('Piwigo is already installed'); 179 179 } 180 180 } … … 300 300 create_empty_local_files(); 301 301 302 // tables creation, based on p hpwebgallery_structure.sql302 // tables creation, based on piwigo_structure.sql 303 303 execute_sqlfile( 304 PHPWG_ROOT_PATH.'install/p hpwebgallery_structure.sql',304 PHPWG_ROOT_PATH.'install/piwigo_structure.sql', 305 305 DEFAULT_PREFIX_TABLE, 306 306 $table_prefix -
trunk/install/piwigo_structure.sql
r2336 r2339 6 6 7 7 -- 8 -- Table structure for table `p hpwebgallery_caddie`9 -- 10 11 DROP TABLE IF EXISTS `p hpwebgallery_caddie`;12 CREATE TABLE `p hpwebgallery_caddie` (8 -- Table structure for table `piwigo_caddie` 9 -- 10 11 DROP TABLE IF EXISTS `piwigo_caddie`; 12 CREATE TABLE `piwigo_caddie` ( 13 13 `user_id` smallint(5) NOT NULL default '0', 14 14 `element_id` mediumint(8) NOT NULL default '0', … … 17 17 18 18 -- 19 -- Table structure for table `p hpwebgallery_categories`20 -- 21 22 DROP TABLE IF EXISTS `p hpwebgallery_categories`;23 CREATE TABLE `p hpwebgallery_categories` (19 -- Table structure for table `piwigo_categories` 20 -- 21 22 DROP TABLE IF EXISTS `piwigo_categories`; 23 CREATE TABLE `piwigo_categories` ( 24 24 `id` smallint(5) unsigned NOT NULL auto_increment, 25 25 `name` varchar(255) NOT NULL default '', … … 44 44 45 45 -- 46 -- Table structure for table `p hpwebgallery_comments`47 -- 48 49 DROP TABLE IF EXISTS `p hpwebgallery_comments`;50 CREATE TABLE `p hpwebgallery_comments` (46 -- Table structure for table `piwigo_comments` 47 -- 48 49 DROP TABLE IF EXISTS `piwigo_comments`; 50 CREATE TABLE `piwigo_comments` ( 51 51 `id` int(11) unsigned NOT NULL auto_increment, 52 52 `image_id` mediumint(8) unsigned NOT NULL default '0', … … 62 62 63 63 -- 64 -- Table structure for table `p hpwebgallery_config`65 -- 66 67 DROP TABLE IF EXISTS `p hpwebgallery_config`;68 CREATE TABLE `p hpwebgallery_config` (64 -- Table structure for table `piwigo_config` 65 -- 66 67 DROP TABLE IF EXISTS `piwigo_config`; 68 CREATE TABLE `piwigo_config` ( 69 69 `param` varchar(40) NOT NULL default '', 70 70 `value` text, … … 74 74 75 75 -- 76 -- Table structure for table `p hpwebgallery_favorites`77 -- 78 79 DROP TABLE IF EXISTS `p hpwebgallery_favorites`;80 CREATE TABLE `p hpwebgallery_favorites` (76 -- Table structure for table `piwigo_favorites` 77 -- 78 79 DROP TABLE IF EXISTS `piwigo_favorites`; 80 CREATE TABLE `piwigo_favorites` ( 81 81 `user_id` smallint(5) NOT NULL default '0', 82 82 `image_id` mediumint(8) unsigned NOT NULL default '0', … … 85 85 86 86 -- 87 -- Table structure for table `p hpwebgallery_group_access`88 -- 89 90 DROP TABLE IF EXISTS `p hpwebgallery_group_access`;91 CREATE TABLE `p hpwebgallery_group_access` (87 -- Table structure for table `piwigo_group_access` 88 -- 89 90 DROP TABLE IF EXISTS `piwigo_group_access`; 91 CREATE TABLE `piwigo_group_access` ( 92 92 `group_id` smallint(5) unsigned NOT NULL default '0', 93 93 `cat_id` smallint(5) unsigned NOT NULL default '0', … … 96 96 97 97 -- 98 -- Table structure for table `p hpwebgallery_groups`99 -- 100 101 DROP TABLE IF EXISTS `p hpwebgallery_groups`;102 CREATE TABLE `p hpwebgallery_groups` (98 -- Table structure for table `piwigo_groups` 99 -- 100 101 DROP TABLE IF EXISTS `piwigo_groups`; 102 CREATE TABLE `piwigo_groups` ( 103 103 `id` smallint(5) unsigned NOT NULL auto_increment, 104 104 `name` varchar(255) NOT NULL default '', … … 109 109 110 110 -- 111 -- Table structure for table `p hpwebgallery_history`112 -- 113 114 DROP TABLE IF EXISTS `p hpwebgallery_history`;115 CREATE TABLE `p hpwebgallery_history` (111 -- Table structure for table `piwigo_history` 112 -- 113 114 DROP TABLE IF EXISTS `piwigo_history`; 115 CREATE TABLE `piwigo_history` ( 116 116 `id` int(10) unsigned NOT NULL auto_increment, 117 117 `date` date NOT NULL default '0000-00-00', … … 130 130 131 131 -- 132 -- Table structure for table `p hpwebgallery_history_summary`133 -- 134 135 DROP TABLE IF EXISTS `p hpwebgallery_history_summary`;136 CREATE TABLE `p hpwebgallery_history_summary` (132 -- Table structure for table `piwigo_history_summary` 133 -- 134 135 DROP TABLE IF EXISTS `piwigo_history_summary`; 136 CREATE TABLE `piwigo_history_summary` ( 137 137 `year` smallint(4) NOT NULL default '0', 138 138 `month` tinyint(2) default NULL, … … 144 144 145 145 -- 146 -- Table structure for table `p hpwebgallery_image_category`147 -- 148 149 DROP TABLE IF EXISTS `p hpwebgallery_image_category`;150 CREATE TABLE `p hpwebgallery_image_category` (146 -- Table structure for table `piwigo_image_category` 147 -- 148 149 DROP TABLE IF EXISTS `piwigo_image_category`; 150 CREATE TABLE `piwigo_image_category` ( 151 151 `image_id` mediumint(8) unsigned NOT NULL default '0', 152 152 `category_id` smallint(5) unsigned NOT NULL default '0', … … 156 156 157 157 -- 158 -- Table structure for table `p hpwebgallery_image_tag`159 -- 160 161 DROP TABLE IF EXISTS `p hpwebgallery_image_tag`;162 CREATE TABLE `p hpwebgallery_image_tag` (158 -- Table structure for table `piwigo_image_tag` 159 -- 160 161 DROP TABLE IF EXISTS `piwigo_image_tag`; 162 CREATE TABLE `piwigo_image_tag` ( 163 163 `image_id` mediumint(8) unsigned NOT NULL default '0', 164 164 `tag_id` smallint(5) unsigned NOT NULL default '0', … … 168 168 169 169 -- 170 -- Table structure for table `p hpwebgallery_images`171 -- 172 173 DROP TABLE IF EXISTS `p hpwebgallery_images`;174 CREATE TABLE `p hpwebgallery_images` (170 -- Table structure for table `piwigo_images` 171 -- 172 173 DROP TABLE IF EXISTS `piwigo_images`; 174 CREATE TABLE `piwigo_images` ( 175 175 `id` mediumint(8) unsigned NOT NULL auto_increment, 176 176 `file` varchar(255) NOT NULL default '', … … 202 202 203 203 -- 204 -- Table structure for table `p hpwebgallery_old_permalinks`205 -- 206 207 DROP TABLE IF EXISTS `p hpwebgallery_old_permalinks`;208 CREATE TABLE `p hpwebgallery_old_permalinks` (204 -- Table structure for table `piwigo_old_permalinks` 205 -- 206 207 DROP TABLE IF EXISTS `piwigo_old_permalinks`; 208 CREATE TABLE `piwigo_old_permalinks` ( 209 209 `cat_id` smallint(5) unsigned NOT NULL default '0', 210 210 `permalink` varchar(64) NOT NULL default '', … … 216 216 217 217 -- 218 -- Table structure for table `p hpwebgallery_plugins`219 -- 220 221 DROP TABLE IF EXISTS `p hpwebgallery_plugins`;222 CREATE TABLE `p hpwebgallery_plugins` (218 -- Table structure for table `piwigo_plugins` 219 -- 220 221 DROP TABLE IF EXISTS `piwigo_plugins`; 222 CREATE TABLE `piwigo_plugins` ( 223 223 `id` varchar(64) binary NOT NULL default '', 224 224 `state` enum('inactive','active') NOT NULL default 'inactive', … … 228 228 229 229 -- 230 -- Table structure for table `p hpwebgallery_rate`231 -- 232 233 DROP TABLE IF EXISTS `p hpwebgallery_rate`;234 CREATE TABLE `p hpwebgallery_rate` (230 -- Table structure for table `piwigo_rate` 231 -- 232 233 DROP TABLE IF EXISTS `piwigo_rate`; 234 CREATE TABLE `piwigo_rate` ( 235 235 `user_id` smallint(5) NOT NULL default '0', 236 236 `element_id` mediumint(8) unsigned NOT NULL default '0', … … 242 242 243 243 -- 244 -- Table structure for table `p hpwebgallery_search`245 -- 246 247 DROP TABLE IF EXISTS `p hpwebgallery_search`;248 CREATE TABLE `p hpwebgallery_search` (244 -- Table structure for table `piwigo_search` 245 -- 246 247 DROP TABLE IF EXISTS `piwigo_search`; 248 CREATE TABLE `piwigo_search` ( 249 249 `id` int(10) unsigned NOT NULL auto_increment, 250 250 `last_seen` date default NULL, … … 254 254 255 255 -- 256 -- Table structure for table `p hpwebgallery_sessions`257 -- 258 259 DROP TABLE IF EXISTS `p hpwebgallery_sessions`;260 CREATE TABLE `p hpwebgallery_sessions` (256 -- Table structure for table `piwigo_sessions` 257 -- 258 259 DROP TABLE IF EXISTS `piwigo_sessions`; 260 CREATE TABLE `piwigo_sessions` ( 261 261 `id` varchar(255) binary NOT NULL default '', 262 262 `data` mediumtext NOT NULL, … … 266 266 267 267 -- 268 -- Table structure for table `p hpwebgallery_sites`269 -- 270 271 DROP TABLE IF EXISTS `p hpwebgallery_sites`;272 CREATE TABLE `p hpwebgallery_sites` (268 -- Table structure for table `piwigo_sites` 269 -- 270 271 DROP TABLE IF EXISTS `piwigo_sites`; 272 CREATE TABLE `piwigo_sites` ( 273 273 `id` tinyint(4) NOT NULL auto_increment, 274 274 `galleries_url` varchar(255) NOT NULL default '', … … 278 278 279 279 -- 280 -- Table structure for table `p hpwebgallery_tags`281 -- 282 283 DROP TABLE IF EXISTS `p hpwebgallery_tags`;284 CREATE TABLE `p hpwebgallery_tags` (280 -- Table structure for table `piwigo_tags` 281 -- 282 283 DROP TABLE IF EXISTS `piwigo_tags`; 284 CREATE TABLE `piwigo_tags` ( 285 285 `id` smallint(5) unsigned NOT NULL auto_increment, 286 286 `name` varchar(255) binary NOT NULL default '', … … 291 291 292 292 -- 293 -- Table structure for table `p hpwebgallery_upgrade`294 -- 295 296 DROP TABLE IF EXISTS `p hpwebgallery_upgrade`;297 CREATE TABLE `p hpwebgallery_upgrade` (293 -- Table structure for table `piwigo_upgrade` 294 -- 295 296 DROP TABLE IF EXISTS `piwigo_upgrade`; 297 CREATE TABLE `piwigo_upgrade` ( 298 298 `id` varchar(20) NOT NULL default '', 299 299 `applied` datetime NOT NULL default '0000-00-00 00:00:00', … … 303 303 304 304 -- 305 -- Table structure for table `p hpwebgallery_user_access`306 -- 307 308 DROP TABLE IF EXISTS `p hpwebgallery_user_access`;309 CREATE TABLE `p hpwebgallery_user_access` (305 -- Table structure for table `piwigo_user_access` 306 -- 307 308 DROP TABLE IF EXISTS `piwigo_user_access`; 309 CREATE TABLE `piwigo_user_access` ( 310 310 `user_id` smallint(5) NOT NULL default '0', 311 311 `cat_id` smallint(5) unsigned NOT NULL default '0', … … 314 314 315 315 -- 316 -- Table structure for table `p hpwebgallery_user_cache`317 -- 318 319 DROP TABLE IF EXISTS `p hpwebgallery_user_cache`;320 CREATE TABLE `p hpwebgallery_user_cache` (316 -- Table structure for table `piwigo_user_cache` 317 -- 318 319 DROP TABLE IF EXISTS `piwigo_user_cache`; 320 CREATE TABLE `piwigo_user_cache` ( 321 321 `user_id` smallint(5) NOT NULL default '0', 322 322 `need_update` enum('true','false') NOT NULL default 'true', … … 329 329 330 330 -- 331 -- Table structure for table `p hpwebgallery_user_cache_categories`332 -- 333 334 DROP TABLE IF EXISTS `p hpwebgallery_user_cache_categories`;335 CREATE TABLE `p hpwebgallery_user_cache_categories` (331 -- Table structure for table `piwigo_user_cache_categories` 332 -- 333 334 DROP TABLE IF EXISTS `piwigo_user_cache_categories`; 335 CREATE TABLE `piwigo_user_cache_categories` ( 336 336 `user_id` smallint(5) NOT NULL default '0', 337 337 `cat_id` smallint(5) unsigned NOT NULL default '0', … … 345 345 346 346 -- 347 -- Table structure for table `p hpwebgallery_user_feed`348 -- 349 350 DROP TABLE IF EXISTS `p hpwebgallery_user_feed`;351 CREATE TABLE `p hpwebgallery_user_feed` (347 -- Table structure for table `piwigo_user_feed` 348 -- 349 350 DROP TABLE IF EXISTS `piwigo_user_feed`; 351 CREATE TABLE `piwigo_user_feed` ( 352 352 `id` varchar(50) binary NOT NULL default '', 353 353 `user_id` smallint(5) NOT NULL default '0', … … 357 357 358 358 -- 359 -- Table structure for table `p hpwebgallery_user_group`360 -- 361 362 DROP TABLE IF EXISTS `p hpwebgallery_user_group`;363 CREATE TABLE `p hpwebgallery_user_group` (359 -- Table structure for table `piwigo_user_group` 360 -- 361 362 DROP TABLE IF EXISTS `piwigo_user_group`; 363 CREATE TABLE `piwigo_user_group` ( 364 364 `user_id` smallint(5) NOT NULL default '0', 365 365 `group_id` smallint(5) unsigned NOT NULL default '0', … … 368 368 369 369 -- 370 -- Table structure for table `p hpwebgallery_user_infos`371 -- 372 373 DROP TABLE IF EXISTS `p hpwebgallery_user_infos`;374 CREATE TABLE `p hpwebgallery_user_infos` (370 -- Table structure for table `piwigo_user_infos` 371 -- 372 373 DROP TABLE IF EXISTS `piwigo_user_infos`; 374 CREATE TABLE `piwigo_user_infos` ( 375 375 `user_id` smallint(5) NOT NULL default '0', 376 376 `nb_image_line` tinyint(1) unsigned NOT NULL default '5', … … 393 393 394 394 -- 395 -- Table structure for table `p hpwebgallery_user_mail_notification`396 -- 397 398 DROP TABLE IF EXISTS `p hpwebgallery_user_mail_notification`;399 CREATE TABLE `p hpwebgallery_user_mail_notification` (395 -- Table structure for table `piwigo_user_mail_notification` 396 -- 397 398 DROP TABLE IF EXISTS `piwigo_user_mail_notification`; 399 CREATE TABLE `piwigo_user_mail_notification` ( 400 400 `user_id` smallint(5) NOT NULL default '0', 401 401 `check_key` varchar(16) binary NOT NULL default '', … … 407 407 408 408 -- 409 -- Table structure for table `p hpwebgallery_users`410 -- 411 412 DROP TABLE IF EXISTS `p hpwebgallery_users`;413 CREATE TABLE `p hpwebgallery_users` (409 -- Table structure for table `piwigo_users` 410 -- 411 412 DROP TABLE IF EXISTS `piwigo_users`; 413 CREATE TABLE `piwigo_users` ( 414 414 `id` smallint(5) NOT NULL auto_increment, 415 415 `username` varchar(100) binary NOT NULL default '', … … 421 421 422 422 -- 423 -- Table structure for table `p hpwebgallery_waiting`424 -- 425 426 DROP TABLE IF EXISTS `p hpwebgallery_waiting`;427 CREATE TABLE `p hpwebgallery_waiting` (423 -- Table structure for table `piwigo_waiting` 424 -- 425 426 DROP TABLE IF EXISTS `piwigo_waiting`; 427 CREATE TABLE `piwigo_waiting` ( 428 428 `id` int(10) unsigned NOT NULL auto_increment, 429 429 `storage_category_id` smallint(5) unsigned NOT NULL default '0', … … 439 439 440 440 -- 441 -- Table structure for table `p hpwebgallery_ws_access`442 -- 443 444 DROP TABLE IF EXISTS `p hpwebgallery_ws_access`;445 CREATE TABLE `p hpwebgallery_ws_access` (441 -- Table structure for table `piwigo_ws_access` 442 -- 443 444 DROP TABLE IF EXISTS `piwigo_ws_access`; 445 CREATE TABLE `piwigo_ws_access` ( 446 446 `id` smallint(5) unsigned NOT NULL auto_increment, 447 447 `name` varchar(32) NOT NULL default '', -
trunk/install/upgrade_1.4.0.php
r2299 r2339 70 70 71 71 " 72 ALTER TABLE p hpwebgallery_categories72 ALTER TABLE piwigo_categories 73 73 CHANGE COLUMN date_last date_last datetime default NULL 74 74 ;", 75 75 76 76 " 77 ALTER TABLE p hpwebgallery_comments77 ALTER TABLE piwigo_comments 78 78 ADD COLUMN validation_date datetime default NULL 79 79 ;", 80 80 81 81 " 82 UPDATE p hpwebgallery_comments82 UPDATE piwigo_comments 83 83 SET validation_date = date 84 84 ", 85 85 86 86 " 87 ALTER TABLE p hpwebgallery_comments87 ALTER TABLE piwigo_comments 88 88 ADD INDEX comments_i1 (image_id) 89 89 ;", 90 90 91 91 " 92 ALTER TABLE p hpwebgallery_comments92 ALTER TABLE piwigo_comments 93 93 ADD INDEX comments_i2 (validation_date) 94 94 ;", 95 95 96 96 " 97 ALTER TABLE p hpwebgallery_favorites98 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 99 ;", 100 101 " 102 ALTER TABLE p hpwebgallery_images97 ALTER TABLE piwigo_favorites 98 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 99 ;", 100 101 " 102 ALTER TABLE piwigo_images 103 103 CHANGE COLUMN date_available 104 104 date_available datetime NOT NULL default '0000-00-00 00:00:00' … … 106 106 107 107 " 108 ALTER TABLE p hpwebgallery_rate109 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 110 ;", 111 112 " 113 ALTER TABLE p hpwebgallery_sessions114 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 115 ;", 116 117 " 118 ALTER TABLE p hpwebgallery_user_access119 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 120 ;", 121 122 " 123 DROP TABLE p hpwebgallery_user_forbidden124 ;", 125 126 " 127 ALTER TABLE p hpwebgallery_user_group108 ALTER TABLE piwigo_rate 109 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 110 ;", 111 112 " 113 ALTER TABLE piwigo_sessions 114 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 115 ;", 116 117 " 118 ALTER TABLE piwigo_user_access 119 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 120 ;", 121 122 " 123 DROP TABLE piwigo_user_forbidden 124 ;", 125 126 " 127 ALTER TABLE piwigo_user_group 128 128 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0' 129 129 ;", 130 130 131 131 " 132 ALTER TABLE p hpwebgallery_users132 ALTER TABLE piwigo_users 133 133 CHANGE COLUMN id id smallint(5) NOT NULL auto_increment 134 134 ;", 135 135 136 136 " 137 CREATE TABLE p hpwebgallery_caddie (137 CREATE TABLE piwigo_caddie ( 138 138 user_id smallint(5) NOT NULL default '0', 139 139 element_id mediumint(8) NOT NULL default '0', … … 143 143 144 144 " 145 CREATE TABLE p hpwebgallery_user_cache (145 CREATE TABLE piwigo_user_cache ( 146 146 user_id smallint(5) NOT NULL default '0', 147 147 need_update enum('true','false') NOT NULL default 'true', … … 152 152 153 153 " 154 CREATE TABLE p hpwebgallery_user_feed (154 CREATE TABLE piwigo_user_feed ( 155 155 id varchar(50) binary NOT NULL default '', 156 156 user_id smallint(5) NOT NULL default '0', … … 161 161 162 162 " 163 CREATE TABLE p hpwebgallery_user_infos (163 CREATE TABLE piwigo_user_infos ( 164 164 user_id smallint(5) NOT NULL default '0', 165 165 nb_image_line tinyint(1) unsigned NOT NULL default '5', … … 181 181 foreach ($queries as $query) 182 182 { 183 $query = str_replace('p hpwebgallery_', PREFIX_TABLE, $query);183 $query = str_replace('piwigo_', PREFIX_TABLE, $query); 184 184 pwg_query($query); 185 185 } 186 186 187 // user datas migration from p hpwebgallery_users to phpwebgallery_user_infos187 // user datas migration from piwigo_users to piwigo_user_infos 188 188 $query = ' 189 189 SELECT * … … 254 254 ( 255 255 'gallery_title', 256 'P hpWebGallerydemonstration site',256 'Piwigo demonstration site', 257 257 'Title at top of each page and for RSS feed' 258 258 ) … … 274 274 foreach ($queries as $query) 275 275 { 276 $query = str_replace('p hpwebgallery_', PREFIX_TABLE, $query);276 $query = str_replace('piwigo_', PREFIX_TABLE, $query); 277 277 pwg_query($query); 278 278 } -
trunk/tools/create_listing_file.php
r2337 r2339 32 32 // URL of main gallery 33 33 // Example : http://www.my.domain/my/directory 34 $conf['gallery'] = 'http://demo.p hpwebgallery.net/';34 $conf['gallery'] = 'http://demo.piwigo.net/'; 35 35 36 36 // prefix for thumbnails in "thumbnail" sub directories … … 38 38 39 39 // $conf['file_ext'] lists all extensions (case insensitive) allowed 40 // for your P hpWebGalleryinstallation40 // for your Piwigo installation 41 41 $conf['file_ext'] = array('jpg','JPG','jpeg','JPEG', 42 42 'png','PNG','gif','GIF','mpg','zip', … … 75 75 $conf['use_iptc'] = false; 76 76 77 // use_iptc_mapping : in which IPTC fields will P hpWebGalleryfind image77 // use_iptc_mapping : in which IPTC fields will Piwigo find image 78 78 // information ? This setting is used during metadata synchronisation. It 79 // associates a p hpwebgallery_images column name to a IPTC key79 // associates a piwigo_images column name to a IPTC key 80 80 $conf['use_iptc_mapping'] = array( 81 81 'keywords' => '2#025', … … 1122 1122 else 1123 1123 { 1124 exit('<pre>PWG-ERROR-4: P hpWebGalleryversions differs</pre>');1124 exit('<pre>PWG-ERROR-4: Piwigo versions differs</pre>'); 1125 1125 } 1126 1126 } … … 1662 1662 code {font-weight: bold} 1663 1663 img {border-style: none; vertical-align: middle} 1664 ul {list-style-image: url(<?php echo $pwg_conf['icon_dir']; ?>add_tag.png)} 1664 ul {list-style-image: url(<?php echo $pwg_conf['icon_dir']; ?>add_tag.png)} 1665 1665 .success {color: green} 1666 1666 .warning {color: orange} … … 1678 1678 <div class="content"> 1679 1679 <fieldset class="header"> 1680 <span class="p">P hp</span>1681 <span class="w"> Web</span>1682 <span class="g"> Gallery</span>1680 <span class="p">Pi</span> 1681 <span class="w">wi</span> 1682 <span class="g">go</span> 1683 1683 remote site<? echo $g_header; ?> 1684 1684 </fieldset> … … 1688 1688 <fieldset class="footer"> 1689 1689 <div class="pwg_block"> 1690 Powered by <a href="http:// www.phpwebgallery.net" class="pwg"><span class="p">Php</span><span class="w">Web</span><span class="g">Gallery</span></a>1690 Powered by <a href="http://piwigo.org" class="pwg"><span class="p">Pi</span><span class="w">wi</span><span class="g">go</span></a> 1691 1691 </div> 1692 1692 <?php echo $g_footer; ?>
Note: See TracChangeset
for help on using the changeset viewer.