Commit graph

320 commits

Author SHA1 Message Date
patdenice
7f8cbea1ec Move template class inclusion to common.inc.php.
Add forum link in upgrade page.
Install and upgrade try to configure PHP5.

git-svn-id: http://piwigo.org/svn/trunk@3203 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-03-16 16:57:10 +00:00
plegall
51fe601ee9 merge r3132 from branch 2.0 to trunk
modification: phpwebgallery.net moves to piwigo.org

modification: doc/README_*.txt much simpler with link to piwigo.org for
installation and upgrade guides.

modification: latest_version has changed its path on the website to download
directory.

deletion: doc/ChangeLog was useless and outdated.


git-svn-id: http://piwigo.org/svn/trunk@3133 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-02-12 23:20:40 +00:00
rub
5865b1e90b Try to change write permission before deletion on 80-database.php (delete old and unused files and directories)
git-svn-id: http://piwigo.org/svn/trunk@3107 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-21 21:42:00 +00:00
rub
5cab9dbf8f Add db file upgrade feed witch not update database.
80-database.php delete old and unused files and directories between phpwebgallery-1.0.0 and Piwigo-trunk-r3105

git-svn-id: http://piwigo.org/svn/trunk@3106 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-20 21:54:13 +00:00
plegall
be3c66f112 merge r3054 from branch 2.0 to trunk
Code administration: convert all text files to Unix file format (CR as eol
and not CRLF)


git-svn-id: http://piwigo.org/svn/trunk@3055 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-06 21:39:04 +00:00
plegall
1b711ad236 Administration: happy new year 2009, all PHP headers updated.
git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-04 23:28:36 +00:00
patdenice
509cfc5547 - Replace some mysql_query by pwg_query function.
- Add home button after upgrade.php.
- Add utf8 charset for access denied message.
- Replace some #content by .content in css files.
- Fix menubar blocks borders with IE.

git-svn-id: http://piwigo.org/svn/trunk@2884 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-19 15:44:04 +00:00
patdenice
cd9f45fd1d - Remove advises of file removal at the end of install/upgrade.
- Automatic change mysql.inc.php if file is writable, else purpose manual change to user.

git-svn-id: http://piwigo.org/svn/trunk@2863 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-12 12:40:20 +00:00
patdenice
04395a4c35 - improve 1.3.1 upgrade (automatic write in mysql.inc.php).
- translate 1.3.1 upgrade informations messages.
- security fix in upgrade login.

git-svn-id: http://piwigo.org/svn/trunk@2838 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-07 13:54:35 +00:00
patdenice
e91161f331 - Webmaster or administrator can login to run upgrade.
- Inserting upgrade line in mysql.inc.php still work.
- Convert espagnol upgrade file to utf8.
- Minor changes in upgrade processus.
- Remove all comments in pclzip.lib.php.

git-svn-id: http://piwigo.org/svn/trunk@2836 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-06 14:44:51 +00:00
patdenice
214164c9a1 - Add roma theme to upgrade page.
- Upgrade translation.

git-svn-id: http://piwigo.org/svn/trunk@2819 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-03 19:52:33 +00:00
patdenice
9a7de2b6b1 - bugs correction in upgrade_1.7.0.php.
- only non-standard plugins are deactivated during upgrade.

git-svn-id: http://piwigo.org/svn/trunk@2815 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-01 21:19:20 +00:00
plegall
faa543851b merge -c2754 from branch 2.0 to trunk
new: upgrade script from 1.7.0. Instead of previous upgrade scripts, I call
directly the "unit" upgrades from 61 to current. Previous upgrades not in
the database are inserted but not applied (and have an explicit description
saying so).


git-svn-id: http://piwigo.org/svn/trunk@2768 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-10-17 20:39:30 +00:00
plegall
68d06d6d49 new: set yoga/Sylvia as default theme.
git-svn-id: http://piwigo.org/svn/trunk@2615 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-27 21:04:06 +00:00
plegall
d04fd1d44e feature 868 added: pwg.images.add checks if the same file has not alread
been uploaded.


git-svn-id: http://piwigo.org/svn/trunk@2592 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-25 23:01:35 +00:00
rvelices
4d86bb2234 - images.file categories.permalink old_permalinks.permalink - become binary
- session security improvement: now the sessions are valid only for originating ip addr (with mask 255.255.0.0 to allow users behind load balancing proxies) -> stealing the session cookie is almost a non issue (with the exception of the 65536 machines in range)
- metadata sync from the sync button does not overwrite valid data with empty metadata
- other small fixes/enhancements:
 - added event get_category_image_orders
 - fix display issue with redirect.tpl (h1/h2 within h1)
 - fix known_script smarty function registration
 - query search form not submitted if q is empty
 - better admin css rules
 - some other minor changes (ws_core, rest_handler, functions_search...)

git-svn-id: http://piwigo.org/svn/trunk@2521 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-12 02:17:35 +00:00
plegall
bc290fd6b4 bug fixed: following r2516, remove ws_access table from database script
creation.


git-svn-id: http://piwigo.org/svn/trunk@2518 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-11 22:07:33 +00:00
plegall
d39db9aaaf feature 169 added: ability to manually sort images inside a category. A
dedicated screen let the administrator sort the images (pur HTML, no
JavaScript yet). The "rank" sort order is available only for a category
without flat mode. New database column image_category.rank.


git-svn-id: http://piwigo.org/svn/trunk@2517 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-11 21:40:00 +00:00
rvelices
fdffe42bdc remove ws access table/partners functionality
git-svn-id: http://piwigo.org/svn/trunk@2516 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-11 01:20:25 +00:00
rvelices
26474d349f - fix issue when picture_url_style = file (sql query like)
- sql call SET NAMES "xxx" (if required) in upgrade.php, upgrade_feed.php and after 65-database.php

git-svn-id: http://piwigo.org/svn/trunk@2512 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-09 01:16:32 +00:00
rvelices
abb2f22b2e - based on test_menu by grum (thanks to you) - integration of dynamic menu bar to pwg
- the menubar is composed now of dynamic blocks that can be ordered/hidden
- plugins can add their own blocks 


git-svn-id: http://piwigo.org/svn/trunk@2488 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-08-28 00:32:39 +00:00
rvelices
4322abb39f - add #user_cache.cache_update_time - useful for plugins or the filter when it is not possible/desirable to cache/calculate data specific to the user when pwg core does it; note that this opens the possibility to implement a data cache (file/shared mem/ etc...) for every user (for very large databases)
git-svn-id: http://piwigo.org/svn/trunk@2448 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-22 10:32:25 +00:00
rub
bf8ffbbdf9 Remove warning off extend_for_templates.php
Add new in config.sql

git-svn-id: http://piwigo.org/svn/trunk@2437 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-16 05:41:12 +00:00
vdigital
df29ffbde7 Feature template-extension based on 2006 chrisaga's idea.
chrisaga wrote: "If you want to make some template customization without building a brand new
template, you should use ..."

git-svn-id: http://piwigo.org/svn/trunk@2434 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-14 21:42:40 +00:00
rub
3cffa07182 Change some PhpWebGallery to Piwigo. (2/2)
All phpwebgallery.net are not changed!



git-svn-id: http://piwigo.org/svn/trunk@2342 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-15 18:43:33 +00:00
rub
51491ab08f Change some PhpWebGallery to Piwigo.
Not all PhpWebGallery has been translated!

git-svn-id: http://piwigo.org/svn/trunk@2339 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-14 22:25:36 +00:00
rvelices
5dbad41e2e - remove some unnecessary db columns (#history_summary.id, #history.year, month, day and hour)
git-svn-id: http://piwigo.org/svn/trunk@2333 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-06 01:04:58 +00:00
rub
5436a351ef Resolved issue 0000823: Enhance upload functionalities
First commit, others will be follow.
Not hesitate to change my translations.

Add upload configuration tabsheet (move and add configuration)
Change and add define for access level
Can show upload link every time
Can restrict access upload.class.php
Can choice category on upload page
Add upload class not use for the moment
Review quickly and temporary style of upload.tpl

git-svn-id: http://piwigo.org/svn/trunk@2325 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-02 21:56:21 +00:00
rvelices
7942dccf9b - move #categories.date_last and nb_images to #user_cache_categories
git-svn-id: http://piwigo.org/svn/trunk@2324 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-01 01:12:34 +00:00
rvelices
6c0a51806f - transform some db fields from text to mediumtext (for large dbs); - #sessions.data, #user_cache.forbidden_categories and #user_cache.image_access_list
git-svn-id: http://piwigo.org/svn/trunk@2323 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-30 01:03:14 +00:00
rvelices
23fcaf6b64 - merged function ordering() with update_global_rank() and also optimized the queries
git-svn-id: http://piwigo.org/svn/trunk@2306 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-20 22:20:20 +00:00
plegall
524011bfa6 Bug fixed: as rvelices notified me by email, my header replacement script was
bugged (r2297 was repeating new and old header).

By the way, I've also removed the replacement keywords. We were using them
because it was a common usage with CVS but it is advised not to use them with
Subversion. Personnaly, it is a problem when I search differences between 2
Piwigo installations outside Subversion.


git-svn-id: http://piwigo.org/svn/trunk@2299 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-05 14:14:07 +00:00
plegall
3f235497f3 Modification: new header on PHP files, PhpWebGallery renamed Piwigo.
git-svn-id: http://piwigo.org/svn/trunk@2297 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-04 22:57:23 +00:00
rub
bf4012291a Resolved issue 0000807: New slideshow features
git-svn-id: http://piwigo.org/svn/trunk@2218 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-02-27 20:25:18 +00:00
rub
ea960a5563 Resolved issue 0000792: Admin "intro" : Integrity control bypass
Some sentences must be re-write ;-)

git-svn-id: http://piwigo.org/svn/trunk@2208 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-02-13 20:13:12 +00:00
rvelices
e9becfa669 - PWG_CHARSET, DB_CHARSET and DB_COLLATE... utf-8 ready
git-svn-id: http://piwigo.org/svn/trunk@2127 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-10-09 01:43:29 +00:00
rub
e74e456749 Resolved 0000748: Name configuration of all the tables
Resolved 0000750: Check anomalies after upgrade (Feature proposition)


git-svn-id: http://piwigo.org/svn/trunk@2096 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-09-19 05:26:58 +00:00
rvelices
92f80e5d79 feature 731: permissions at image level
- this is the first version - I wait for feedback before changing help files

git-svn-id: http://piwigo.org/svn/trunk@2084 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-09-11 02:24:51 +00:00
rub
bbd2ddd142 Change headers with team email
git-svn-id: http://piwigo.org/svn/trunk@2059 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-07-10 05:30:01 +00:00
rub
e8c396c06b Resolved issue 0000489: Mail address obligatory
git-svn-id: http://piwigo.org/svn/trunk@2032 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-06-10 22:01:18 +00:00
rub
ea4f185d1f git-svn-id: http://piwigo.org/svn/trunk@1963 68402e56-0260-453c-a942-63ccdbb3a9ee 2007-04-19 20:40:38 +00:00
rub
7acc304f55 o add missing $lang
o use of l10n_dec
  o normalize file header


git-svn-id: http://piwigo.org/svn/trunk@1932 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-29 19:04:54 +00:00
rub
ac97e73565 Set correct svn properties
git-svn-id: http://piwigo.org/svn/trunk@1931 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-28 22:41:13 +00:00
plegall
0d5216267c New: release upgrade scripts from 1.3.0 come back from branch 1.6. Only
install/upgrade_1.6.2.php is really new, upgrade 60 was taken into
account. Detection of 1.6.0 or 1.6.2 data model in upgrade.php. Release
upgrade scripts added on trunk to be kept in a safer place.


git-svn-id: http://piwigo.org/svn/trunk@1927 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-28 22:06:13 +00:00
rub
7c43a3c62d Issue 578
User guest must be real user

Step 1: guest is a real user

On next commit, I finish installation and use of guest of user list and group

git-svn-id: http://piwigo.org/svn/trunk@1926 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-28 19:57:00 +00:00
plegall
b86d4ac0b8 Complement to trunk r1924: modification on index names reported in SQL
database structure installation file.

Modification: somes indexes were renamed to comply with PWG indexes naming
rules, ie <table_name>_[u for unique]i<index number in table>.


git-svn-id: http://piwigo.org/svn/trunk@1925 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-27 08:43:10 +00:00
plegall
04e58f3769 Modification: somes indexes were renamed to comply with PWG indexes naming
rules, ie <table_name>_[u for unique]i<index number in table>.


git-svn-id: http://piwigo.org/svn/trunk@1924 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-27 08:26:28 +00:00
rub
e78d0fde73 Update svn properties (svn:eol-style and svn:keywords)
git-svn-id: http://piwigo.org/svn/trunk@1912 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-16 06:30:07 +00:00
rub
cad4270a4d Update index.php header.
Don't use explicitly index.php on the recursive call.

Add missing index.php.

Chang tags.php svn properties.

git-svn-id: http://piwigo.org/svn/trunk@1909 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-16 06:15:27 +00:00
rub
c5da19e536 Fix bad default value for language on table user_info
Improve mail send (Undisclosed-recipients, switch language, ...)
Improve send an email to group members (Use Bcc, template, multi-language, ...) (But need more improvements)

git-svn-id: http://piwigo.org/svn/trunk@1904 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-13 23:01:16 +00:00
vdigital
6295173652 Updates:
- Copyrights 2003-2007
- help
- Some HTML comform requests

git-svn-id: http://piwigo.org/svn/trunk@1903 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-13 22:44:45 +00:00
rub
17246da089 Add notification when a picture is loaded.
Change little translations.
Improve mail sent.

git-svn-id: http://piwigo.org/svn/trunk@1901 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-12 23:10:35 +00:00
rub
4577278acc Apply property svn:eol-style Value: LF
git-svn-id: http://piwigo.org/svn/trunk@1900 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-12 22:33:53 +00:00
plegall
b0478ef330 New: #images.high_filesize was added so that we can sum the filesizes in the
filtered history. #images.high_filesize is filled during metadata
synchronization.

Bug fixed: in getAttribute XML function, when asking "filesize", it was
returning high_filesize. The regex was too simple.


git-svn-id: http://piwigo.org/svn/trunk@1883 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-03-09 16:28:49 +00:00
rvelices
ea56d7b2ac feature 657: permalinks for categories
git-svn-id: http://piwigo.org/svn/trunk@1866 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-28 03:07:12 +00:00
rvelices
cea58b64ee - user comments are not saved in the database with htmlspecialchars anymore
- web service: added the possibility to enter a user comment using the service...
- new comment functions from picture_comment.inc.php

git-svn-id: http://piwigo.org/svn/trunk@1849 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-22 01:12:32 +00:00
plegall
3b46143435 New: non picture files are now logged in history when downloaded. The
history filter was redesigned: #history.is_high replaced by
#history.image_type = high. The filter is simpler.


git-svn-id: http://piwigo.org/svn/trunk@1844 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-20 23:40:02 +00:00
plegall
aabdb3e929 New: history logs high quality access via action.php. A new column
#history.is_high was added. Filter was added on administration history
detail view.

Modification: function get_sql_condition_FandF was slightly refactored for
presentation improvement.


git-svn-id: http://piwigo.org/svn/trunk@1817 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-14 22:53:02 +00:00
vdigital
1f53608976 Web Service:
- Delete high and normal in #ws_access table
- start date is kept.

w0p0 template: Minor change


git-svn-id: http://piwigo.org/svn/trunk@1791 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-08 21:20:40 +00:00
rub
e517cfad64 Issue 0000598: NBM: Add new informations
Notification by mail:
Add new informations about last categories and last images like new feature of RSS notification.

2 parts:
  - Possibility to send HTML mail
  - Include last categories and last images on HTML format into notification mail


ccs & HTML experts! Please! Check, fix, improve and enhance HTML mail content!


git-svn-id: http://piwigo.org/svn/trunk@1784 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-02-06 22:55:12 +00:00
vdigital
70bffc591e Issue 0000614: Display hits under thumbnails like comments counter
- Update config.sql

git-svn-id: http://piwigo.org/svn/trunk@1770 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-30 19:54:08 +00:00
vdigital
3b11eb39cf Issue 0000614: Display hits under thumbnails like comments counter
Include Show_nb_hits in #config and remove from config_default.inc.php

git-svn-id: http://piwigo.org/svn/trunk@1767 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-29 20:19:48 +00:00
vdigital
7709c4189c Web Service: Remove ws_status from #config (remove missing in config.sql)
(Next steps:
- Restrict Method need to be more generic maybe
- Delete functions_webserv.inc.php 
- Activate $partner in ws.php
- Include checked access in tools
- ...)

Issue 0000614: 	Display hits under thumbnails like comments counter
- Add show_nb_hits to #user_infos (add in phpwebgallery_structure.sql)


git-svn-id: http://piwigo.org/svn/trunk@1762 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-28 19:00:09 +00:00
vdigital
b22da12d04 Web Service: Remove ws_status from #config
(Next steps:
- Restrict Method need to be more generic maybe
- Delete functions_webserv.inc.php 
- Activate $partner in ws.php
- Include checked access in tools
- ...)

Issue 0000614: 	Display hits under thumbnails like comments counter
- Add show_nb_hits to #user_infos


git-svn-id: http://piwigo.org/svn/trunk@1761 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-28 18:51:46 +00:00
rvelices
e90aaffbd5 - revert feature 564: log the login of each user; but add the possibility to be
done by a plugin
- create a "standard" way to define PHP functions that we use but might not be
available in the current php version
- when a comment is rejected (spam, anti-flood etc), put the content back to the
browser in case there is a real user behind it
- now a comment can be entered only if the page was retrieved between 2 seconds
ago and 1 hour ago

git-svn-id: http://piwigo.org/svn/trunk@1744 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-23 01:22:52 +00:00
vdigital
ee5dbaefbb More rename index
git-svn-id: http://piwigo.org/svn/trunk@1742 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-22 21:51:52 +00:00
vdigital
eab94717e1 Index rename
git-svn-id: http://piwigo.org/svn/trunk@1741 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-22 21:47:03 +00:00
rub
d0c7ff3b15 Bad quotes Fixed
git-svn-id: http://piwigo.org/svn/trunk@1740 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-21 23:05:37 +00:00
vdigital
eb0315c74d Inefficient and non required index is removed on #_image_category.
git-svn-id: http://piwigo.org/svn/trunk@1739 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-21 15:49:45 +00:00
rvelices
96a0c2b1d3 feature 625: comment anti-spam - protect against some of the spam robots
git-svn-id: http://piwigo.org/svn/trunk@1737 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-19 02:56:54 +00:00
plegall
5d9a865fe1 Modification: new data model for history, more compact, more efficient. A
summary table is used as cache for history stats display.

New: a Perl script fill_history.pl was added to simulate a high load on
history table (making the efficiency of the new data model obvious).

Modification: function prepend_append_array_items moved from
include/functions_search.inc.php to include/functions_search.inc.php since
this function is used in new file admin/history.php

Modification: admin/images/*_stats.img.php replaced by a simpler and more
generic admin/images/stats.img.php unique file.

New: a history detail search page was added. Currently, only start and end
dates can be modified, it's just a beginning.


git-svn-id: http://piwigo.org/svn/trunk@1727 68402e56-0260-453c-a942-63ccdbb3a9ee
2007-01-16 23:39:39 +00:00
vdigital
3d32716fc5 Upgrade feed correct I hope 8-)
git-svn-id: http://piwigo.org/svn/trunk@1669 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 11:42:41 +00:00
vdigital
e2fcbfeef8 Upgrade Feed corrected
git-svn-id: http://piwigo.org/svn/trunk@1668 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 11:33:52 +00:00
vdigital
5fe8be40c2 Updrade_feed corrected
git-svn-id: http://piwigo.org/svn/trunk@1667 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 11:31:04 +00:00
vdigital
b005e5a3c0 Parse error corrected
git-svn-id: http://piwigo.org/svn/trunk@1666 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 10:30:38 +00:00
vdigital
a4473e8201 Admin part in coding review status.
git-svn-id: http://piwigo.org/svn/trunk@1663 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 09:40:59 +00:00
vdigital
0bd0969499 Table structure for Web service
git-svn-id: http://piwigo.org/svn/trunk@1662 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-16 09:30:44 +00:00
rvelices
0ad7985abc forgot db #config upgrade
git-svn-id: http://piwigo.org/svn/trunk@1653 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-13 01:08:49 +00:00
rvelices
74e5d80e89 - feature 599: option to forbid user registration
- 1 language cleanup
- added page_forbidden function (sends 403)

git-svn-id: http://piwigo.org/svn/trunk@1652 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-13 01:05:38 +00:00
rvelices
961640b8d6 - remove #user_cache_categories.is_child_date_last
- optimize code in get_icon
- correct css font-wigth:italic to font-style:italic
- aditionnal check on $conf['authorize_remembering'] before allowing auto_login

git-svn-id: http://piwigo.org/svn/trunk@1641 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-07 23:21:54 +00:00
rub
7638575de3 Fixed: Use old $conf to insert in #_config
Only to help for next migration

See http://svn.gna.org/viewcvs/phpwebgallery?rev=1565&view=rev 

git-svn-id: http://piwigo.org/svn/trunk@1634 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-04 21:57:23 +00:00
rub
9ce5c07734 Improve database update of svn:1624
git-svn-id: http://piwigo.org/svn/trunk@1626 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-02 13:34:51 +00:00
rub
63638b9b6d Resolved Issue ID 0000299:
o Add (new) icon of parent category with children categories including new images
  o Improved display text for images count
  o Improved (a little) mass_* functions

More explications on the forum.
You must call directly upgrade_feep.php (http://127.0.0.1/BSF/upgrade_feed.php for example)

git-svn-id: http://piwigo.org/svn/trunk@1624 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01 23:31:19 +00:00
rvelices
7111d867b9 get rid of #users.auto_login_key
git-svn-id: http://piwigo.org/svn/trunk@1622 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-12-01 00:48:49 +00:00
rvelices
5de8aeafad feature 440: send mail to admin when comment is entered
git-svn-id: http://piwigo.org/svn/trunk@1617 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-11-22 04:41:25 +00:00
rvelices
a81bac0f15 plugins go now in the #plugins table
git-svn-id: http://piwigo.org/svn/trunk@1584 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-31 02:41:32 +00:00
rub
9c3e182268 Resolved Issue ID 0000526:
o Add default group to new user

Allow to have n default groups.
Property are save on table #_group and can be modified on administration group screen.


git-svn-id: http://piwigo.org/svn/trunk@1583 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-30 23:34:31 +00:00
rvelices
12182ddcfe plugins: first prototype version
git-svn-id: http://piwigo.org/svn/trunk@1578 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-26 03:35:20 +00:00
rvelices
9e770f68a3 fix a previous upgrade (username column was not binary)
git-svn-id: http://piwigo.org/svn/trunk@1575 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-24 00:38:20 +00:00
rvelices
af621d40d4 feature 564: logs in the history table each user login
feature 562: possibility to log page visits for any combination of 
administrators/users/guests

git-svn-id: http://piwigo.org/svn/trunk@1565 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-10-19 00:41:07 +00:00
rub
27aa4d6bfc Resolved Issue ID 0000474 (Step 3):
o Remove .htaccess files
  o Undo svn:1505 

http://svn.gna.org/viewcvs/phpwebgallery?rev=1505&view=rev


git-svn-id: http://piwigo.org/svn/trunk@1519 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-31 22:18:32 +00:00
rub
7ca31726ed Resolved Issue ID 0000474 (Step 2):
o Add .htaccess files

=>
  * admin
      - .htaccess = deny from all
  * doc
      - no .htaccess
  * galleries
      - .htaccess = Options -Indexes
  * include
      - .htaccess = deny from all
      => move 2 .js in template-common
  * install
      - .htaccess = deny from all
  * language
      - .htaccess = deny from all
  * template
      - .htaccess = Options -Indexes
  * template-common
      - .htaccess = Options -Indexes
  * template-extension
      - .htaccess = Options -Indexes
  * tools
      - no .htaccess


git-svn-id: http://piwigo.org/svn/trunk@1505 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-26 21:29:21 +00:00
rvelices
aca06a08aa feature 169: each category can have its own image order
git-svn-id: http://piwigo.org/svn/trunk@1500 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-26 00:51:08 +00:00
rub
7e79e15d18 Resolved Issue ID 0000474:
o Delete old files index.htm



git-svn-id: http://piwigo.org/svn/trunk@1497 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-25 21:37:10 +00:00
nikrou
1150fb7add fix bug 486: field username too small
git-svn-id: http://piwigo.org/svn/trunk@1495 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-25 07:40:02 +00:00
nikrou
5d06d43541 bug 451 fixed: problem with auto login
- add an auto_login_key in users_table
- $conf['session_length'] is no more useful 
    and sessions length will be 0 (until browser closed)
- add $conf['remember_me_name'] for cookie remember name


git-svn-id: http://piwigo.org/svn/trunk@1493 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-23 15:25:49 +00:00
rub
27aeab97e9 Resolved Issue ID 0000474 (Step 1):
o Rename index.htm into index.php
  o Add index.php on all sub-directories
  o Use an uniform source code of index.php (like /include/index.php)

(/index.php is of course not changed)




git-svn-id: http://piwigo.org/svn/trunk@1481 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-07-18 21:38:54 +00:00
rub
c932e8d5d4 Issue ID 0000445:
Issue ID 0000401: 
Finish manual merge to branch_1.6 to BSF/install/config.sql

git-svn-id: http://piwigo.org/svn/trunk@1417 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-06-29 21:41:27 +00:00
plegall
006118d03a manual merge -r1344:1345 from branch 1.6 to trunk (bug 401 fixed)
git-svn-id: http://piwigo.org/svn/trunk@1346 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-06-13 20:17:41 +00:00
plegall
a8e574e2b5 merge -r1310:1311 from branch 1.6 to trunk (bug 365 fixed)
git-svn-id: http://piwigo.org/svn/trunk@1312 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-05-15 21:47:28 +00:00
plegall
c64da384ea partial merge -r1173:1174 from branch-1_6 to trunk: new configuration
parameter die_on_sql_error (upgrade.php and install/upgrade_*.php not
concerned on BSF)

partial merge -r1208:1209 from branch-1_6 to trunk (only bug fix on
incorrect insertion of complex upgrade identifiers)

deletions: upgrade.php and all install/upgrade_*.php because these script
are never up to date on BSF. Anyway, they are only required on a stable
branch.


git-svn-id: http://piwigo.org/svn/trunk@1221 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-20 19:31:12 +00:00
plegall
d7393a5980 merge -r1157:1158 from branch-1_6 into trunk (images_i1 comes back)
git-svn-id: http://piwigo.org/svn/trunk@1159 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-13 20:42:37 +00:00
rvelices
d700a59172 improvement: urls for tags can contain now only the tag or the id and tag
improvement: urls for category can be now id and category names (instead
of only id)

improvement: added 2 indexes (#image_tag.tag_id and #tags.url_name)

improvement: identification, register, search pages automatically set focus
on first form input

improvement: focus, nofocus css class now valid for all forms

fix: category comment is tag stripped in category_subcats.inc.php
(otherwise issues with html/scripts inside category comment)

git-svn-id: http://piwigo.org/svn/trunk@1131 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-06 02:23:54 +00:00
rvelices
bdceff32bc image sort order for tags
very minor code and language simplifications and corrections

git-svn-id: http://piwigo.org/svn/trunk@1125 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-05 02:01:36 +00:00
plegall
d8c15ddf65 feature deleted: code for categories link was too complicated for such a
simple fature. Replaced by static association. Links are not persistent
anymore.

modification removed: #image_category.is_storage replaced by
#images.storage_category_id as in branche 1.5..


git-svn-id: http://piwigo.org/svn/trunk@1121 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-04 22:29:35 +00:00
plegall
42abf4c576 improvement: tags replace keywords. Better data model, less
limitations. Each image can be associated to as many tag as needed. Tags can
contain non ASCII characters. Oriented navigation with tags by association.


git-svn-id: http://piwigo.org/svn/trunk@1119 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-02 22:26:19 +00:00
rub
324f3c4279 [NBM] Step 7: Add functionalities subscribe/unsubscribe:
o reduce length of check_key
  o fix bugs
  o send mail on subscribe/unsubscribe
  o add and used $conf parameters
  o review keyword of languages
  o improve selection/check
  o can subscribe/unsubscribe with a link include on mail
  o fix bug mass_update collate




git-svn-id: http://piwigo.org/svn/trunk@1116 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-04-01 01:14:57 +00:00
rub
d63d25a61d [NBM] Step 4: Screen NBM is available
o Add news parameters
  o Add file functions_notification_by_mail.inc.php in order to use in future, these functions on php file of subscribe/unsubscribe
  o Write a little html help file

+ improve mass_update in order to used binary fields (used collate and SHOW COLUMNS FROM)
 


git-svn-id: http://piwigo.org/svn/trunk@1105 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-26 22:06:20 +00:00
rvelices
5c7d655005 URL rewrite: 3 options in the config file define behaviour (question mark
removal, file name for picture and .php extension removal)

fix: added unsigned for column in install sql - for the sake of uniformization

change: add_url_param is now add_url_params and takes an array as parameter 
instead of a string

git-svn-id: http://piwigo.org/svn/trunk@1094 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-23 01:49:04 +00:00
rub
9b521760af Step 7 improvement issue 0000301:
o can attribute status <= current user
  o define mode adviser 
    => buttons disabled (gray on IE, not on FF)
    => truncated actions
    => display info mode adviser

git-svn-id: http://piwigo.org/svn/trunk@1085 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-16 22:58:16 +00:00
rvelices
88e3b36e2f feature 262: new user cached information nb_total_pictures
git-svn-id: http://piwigo.org/svn/trunk@1081 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-15 02:26:25 +00:00
rub
7eb6e6ca1f Step 1 improvement issue 0000127:
o Add field enabled_high of table #_user_infos
  o Add $conf['newuser_default_enabled_high']
  o Used field on picture.php



git-svn-id: http://piwigo.org/svn/trunk@1078 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-13 23:27:34 +00:00
rvelices
316d89a90b bug 255: parameter values in #config limited to 255 chars (value becomes text)
feature 303: page banner moved from combination of gallery_title, 
gallery_description and template to database (simplifies user customization)


git-svn-id: http://piwigo.org/svn/trunk@1071 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-09 01:57:13 +00:00
rub
b263f0c996 Step 1 improvement issue 0000301:
o Change status of table #_user_infos
  o Don't send password to webmaster, guest, generic

Next Step:
  o Functions Check of status
  o Restricted Access for user generic

git-svn-id: http://piwigo.org/svn/trunk@1070 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-08 23:14:53 +00:00
plegall
8615119a80 bug fixed: table #categories_link was created with an hardcoded prefix
bug fixed: on source/destination links, if an image/category association is
added to a source, destinations must be filled. If an image/category
association is delete from a source, the same association must be deleted in
the destinations.


git-svn-id: http://piwigo.org/svn/trunk@1065 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-05 22:44:32 +00:00
plegall
c08fa6f67e new feature: source/destination links between categories. Will we keep this
feature? Code is complicated and very few people will understand how it
works...

modification: #images.storage_category_id replaced by
#image_category.is_storage

improvement: many code refactoring to improve readibility

improvement: virtual category creation code was moved to a dedicated
function in order to be called from admin/cat_list.php and
admin/cat_modify.php (create a new destination category)


git-svn-id: http://piwigo.org/svn/trunk@1064 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-03-04 23:31:46 +00:00
rvelices
d22a07cee3 feature 264: gallery_url, rate and rate_anonymous from config file to database
git-svn-id: http://piwigo.org/svn/trunk@1044 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-16 00:45:18 +00:00
rvelices
f328dd14bb feature 251: Rating For Anonymous users
fix: page['items'] for favorites category and remove old use of $has_next, 
$has_prev in picture.php (slideshow and favorites section)

optimization: one less sql query in picture.php when there are no comments

display of the refresh url in redirect.tpl (useful when debugging with 
browser meta redirects disabled)


git-svn-id: http://piwigo.org/svn/trunk@1041 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-14 01:14:31 +00:00
rub
687a7ca122 [NBM] Step 2: Add new table user_mail_notification (update, install, constants, delete user
+ Correction delete user (table user_feed missing, table sessions must be removed)

git-svn-id: http://piwigo.org/svn/trunk@1028 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-06 22:59:30 +00:00
rvelices
bb181b04cf feature 280: Allow visitors/users to choose image ordering inside a category
improvement 82: Viewing pictures from remote galleries does not check anymore 
for the high pictures (existence flag added to create_listing_file and db)

correction: link element in picture is in the head instead of body (w3c spec)

correction: in profile.php the current template was not selected by default

git-svn-id: http://piwigo.org/svn/trunk@1020 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-02-01 02:46:26 +00:00
plegall
7b2ff328cb Search engine redesign, first part :
- new table #search to store search rules associated to a search id.

- search rules are not passed through GET anymore, the search array build in
  search.php is serialized in #search table, so no need to rebuild it in
  function include/functions_category.inc.php::category_initialize

- search array build code is improved (efficiency and layout) in search.php

- SQL related to search is build in a dedicated function
  include/functions::get_sql_search_clause

- direct search author:<...>, date_avalaible:<...>, date_creation:<...>,
  keywords:<...> from picture.php are not available anymore. They will come
  back later, with improvement (new design). Same for date_*:<> in calendar
  calendar category.


git-svn-id: http://piwigo.org/svn/trunk@1008 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-20 14:34:37 +00:00
nikrou
9410522e9f bug fix 261: improve security of sessions (next to svn:1004):
- improve presentation code style
- add upgrade database file

git-svn-id: http://piwigo.org/svn/trunk@1007 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-18 15:16:30 +00:00
nikrou
c3397a2c73 Improve security of sessions:
- use only cookies to store session id on client side
- use default php session system with database handler to store sessions on server side

git-svn-id: http://piwigo.org/svn/trunk@1004 68402e56-0260-453c-a942-63ccdbb3a9ee
2006-01-15 13:45:42 +00:00
plegall
bb9e2c0e48 Database modification on users template preference with the new template
directory tree.


git-svn-id: http://piwigo.org/svn/trunk@965 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-12-03 20:42:03 +00:00
plegall
935b69d868 - new: system to notify and upgrade database among developers
git-svn-id: http://piwigo.org/svn/trunk@953 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-11-24 21:37:29 +00:00
plegall
aa27a6b598 - bug 181 fixed: "Parameters not created in phpwebgallery_config during
upgrade". gallery_title and gallery_description had not been added to
  config table. (use|show)_(exif|iptc) and authorize_remembering have also
  been removed...


git-svn-id: http://piwigo.org/svn/trunk@911 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-10-23 21:02:21 +00:00
plegall
1f594dc148 - modification: configuration parameters gallery_title and
gallery_description are GUI managed in
  Administration>Configuration>General

- bug fixed: configuration parameters (use|show)_(exif|iptc) and
  authorize_remembering should have been deleted from config table some time
  ago.


git-svn-id: http://piwigo.org/svn/trunk@882 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-10-07 23:25:42 +00:00
plegall
1673892026 - update: upgrade from 1.4.0 or 1.4.1. Upgrade from 1.3.x is not available
anymore.

- update: README files updated for very near branch 1.5 :-)

- new: file tools/config_local.inc.php as example for optional
  include/config_local.inc.php

- bug fixed: configuration parameter show_picture_name_on_title was useless


git-svn-id: http://piwigo.org/svn/trunk@870 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-20 22:04:57 +00:00
plegall
c614c0798e (not in ChangeLog)
- yoga template used for installation and by default in user_infos table

- adaptation of yoga template to itself (no use of icons from template
  default)


git-svn-id: http://piwigo.org/svn/trunk@860 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-03 20:56:35 +00:00
plegall
7eae759590 - modification : less configuration parameters in administration
screen. These parameters are move to include/config_default.inc.php.

- new : ability to add a single picture to caddie from picture.php

- new : contextual help, only a few pages are available.

- new : ability to delete users from admin/user_list

- modification : reorganization of configuration file

- new : configuration parameter use_exif_mapping

- improvement : MOD hidemail added to standard


git-svn-id: http://piwigo.org/svn/trunk@858 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-09-03 16:36:05 +00:00
plegall
429dd2ff62 - deletion : no mail notification anymore. Feature replaced by RSS feed
notification.

- improvement : on waiting pictures management. Ability to validate all or
  reject all in one clic.

- regrouped fields in admin/update


git-svn-id: http://piwigo.org/svn/trunk@849 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-08-24 22:22:29 +00:00
plegall
ede184cacc - modification : RSS feed work only with a given feed identifier. Thus we
can avoid fixed frequency notification to concentrate on variable
  frequency notification, which is much more interesting. To do this, feeds
  have moved to a dedicated table allowing each user (including guest user)
  to have more than on feed.


git-svn-id: http://piwigo.org/svn/trunk@833 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-08-19 13:54:40 +00:00
plegall
273884a652 - new : external authentication in another users table. Previous users table
is divided between users (common properties with any web application) and
  user_infos (phpwebgallery specific informations). External table and
  fields can be configured.

- modification : profile.php is not reachable through administration anymore
  (not useful).

- modification : in profile.php, current password is mandatory only if user
  tries to change his password. Username can't be changed.

- deletion : of obsolete functions get_user_restrictions,
  update_user_restrictions, get_user_all_restrictions, is_user_allowed,
  update_user

- modification : $user['forbidden_categories'] equals at least "-1" so that
  category_id NOT IN ($user['forbidden_categories']) can always be used.

- modification : user_forbidden table becomes user_cache so that not only
  restriction informations can be stored in this table.


git-svn-id: http://piwigo.org/svn/trunk@808 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-08-08 20:52:19 +00:00
plegall
9bafdff171 - new feature : RSS notification feed. Feed generator is an external tool
(FeedCreator class v1.7.2). New file feed.php

- new database field : comments.validation_date (datetime). This field is
  required for notification feed.

- new database field : users.feed_id (varchar(50)). users.feed_id is an
  alias of users.id but is much more complicated to find (50 characters,
  figures or letters, case sensitive) : the purpose is to keep it secret (as
  far as possible).

- new database field : users.last_feed_check (datetime)

- new database field : users.registration_date (datetime)

- bug fixed : no need to add the (unavailable) session id to install.php in
  the installation form.

- modified database field : images.date_available become more precise (date
  to datetime). This precision is needed for notification feed.

- new index : comments_i1 (validation_date). Might be useful for feed
  queries.

- new index : comments_i2 (image_id). Useful each time you want to have
  informations about an element and its associated comments.

- version 9.11 of mysqldump outputs database field names and table names
  with backquote "`" (didn't find how to take them off)


git-svn-id: http://piwigo.org/svn/trunk@801 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-07-16 14:29:35 +00:00
plegall
aed2bd916e - new feature : caddie (new table was forgotten in previous commit)
git-svn-id: http://piwigo.org/svn/trunk@757 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-03-25 22:26:35 +00:00
plegall
4d093b96c4 - by default use_iptc and use_exif are set to false
git-svn-id: http://piwigo.org/svn/trunk@701 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-17 19:09:48 +00:00
plegall
6244654872 all headers adapted to new year 2005, happy new year
git-svn-id: http://piwigo.org/svn/trunk@675 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-07 23:10:51 +00:00
plegall
79c440d8bb - upgrade scripts added for releases 1.3.x
- my_error function moved from admin/include/functions.php to
  include/functions.inc.php

- because MySQL temporary tables are not always authorized on creation, use
  a temporary table name (with the current microsecond) on a non temporary
  table (in mass_updates function)

- ability to retrieve distant full directories (usefull in upgrade scripts)

- global variables $count_queries and $queries_time moved into global array
  $page

- get_cat_display_name displays category names in correct order : the one
  given by uppercats

- function setup_style simplified

- default value for configuration parameter "show_nb_comments" set to false
  (less queries by default)


git-svn-id: http://piwigo.org/svn/trunk@672 68402e56-0260-453c-a942-63ccdbb3a9ee
2005-01-06 22:16:21 +00:00
plegall
6409647e1c - new feature : lock temporary your gallery for maintenance
- $user keys for guest user are initialized with default values of $conf


git-svn-id: http://piwigo.org/svn/trunk@653 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-20 23:54:59 +00:00
plegall
7543485ba8 - restricted access mode deleted : set all your categories as private
instead


git-svn-id: http://piwigo.org/svn/trunk@651 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-20 22:03:04 +00:00
gweltas
1d46ea86e9 - Minor update of language file
- Configuration / Default dispaly : maximum height & width


git-svn-id: http://piwigo.org/svn/trunk@649 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-20 14:52:30 +00:00
plegall
5a8ecfbfb1 - in picture.php, $user['maxwidth'] and $user['maxheight'] can be unset if
NULL in database

- new table user_forbidden {user_id,need_update,forbidden_categories} and
  deletion of field users.forbidden_categories

- new function calculate_permissions to update table user_forbidden when
  needed

- simplification of include/user.inc.php

- in footer of each page, use "-" instead of "::" to separate page
  information


git-svn-id: http://piwigo.org/svn/trunk@648 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-20 12:30:36 +00:00
plegall
f0e9cd804a - bug fixed : in admin/cat_list, next_rank cant' be calculted and query to
count sub-categories per sub-categories became false if no sub-categories

- virtual association come back in admin/infos_images (not only in
  admin/picture_modify)

- check_favorites function in admin section becomes check_user_favorites in
  public section : favorites are checked when user tries to display his
  favorites. Function was optimized.

- in function update_category, wrap of long queries due to many categories
  to update at the same time

- typo fixed in description of paginate_pages_around configuration parameter

- bug fixed in new navigation bar : no separation pipe was displayed between
  next and last when the page displayed was the last

- sessions.expiration changed of type from int to datetime (a lot easier to
  read)

- sessions.ip removed : IP address is no longer used to verify session

- $lang['cat_options'] was missing in en_UK.iso-8859-1

- typo fixed in language/en_UK.iso-8859-1/admin.lang.php on
  editcat_lock_info language item


git-svn-id: http://piwigo.org/svn/trunk@647 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-12-18 22:05:30 +00:00
plegall
c18457fa32 changing name of key from none to history_i1
git-svn-id: http://piwigo.org/svn/trunk@616 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-24 21:26:21 +00:00
gweltas
bd71857691 Drop of PRIMARY Key on history table.
git-svn-id: http://piwigo.org/svn/trunk@615 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-24 10:49:41 +00:00
plegall
f0fcd1eedc - global categories' options : instead of N horizontal tabs on a single
page, N options in the left menu (but the same backend)

- categories.global_rank : new calculated field. It gives a global rank of
  the category among all others (updated during ordering)

- category.php page : menu is generated faster thanks to
  categories.global_rank, recursivity becomes useless :-)

- new function to display select box with a set of categories :
  display_select_cat_wrapper

- cat_options : instead of using 1 multiselect for true/false items, using 1
  multiselect for true, and another one for false. The form provides buttons
  with arrows to switch categories from one multiselect to another

- deletion of obsolete function display_categories (working with the old
  template system)

- deletion of obsolete functions get_user_plain_structure,
  create_user_structure, get_user_subcat_ids, update_structure, count_images
  : useless thanks to global_rank


git-svn-id: http://piwigo.org/svn/trunk@614 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-23 22:31:24 +00:00
plegall
ec015abc78 optimization : instead of reading each $conf['calendar_datefield'] for
matching YEAR() and MONTH(), use of SQL statement BETWEEN ... AND ... on the
date field + new index image_i5 on date_creation (default date field for
calendar)


git-svn-id: http://piwigo.org/svn/trunk@612 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-21 11:13:48 +00:00
plegall
1bf3753f14 - images.path column added to reduce database access
- function mass_inserts moved from admin/remote_sites.php to
  admin/include/function.php

- function mass_inserts used in admin/update.php


git-svn-id: http://piwigo.org/svn/trunk@606 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-16 23:38:34 +00:00
plegall
88e4e1e60a - admin/cat_options page added : manage options for the whole categories
tree (uploadable, commentable). status and visible will be soon added

- admin.php : $conf_link var to avoid lines longer than 79 characters

- config.upload_available configuration parameter disappear : it's simpler
  to manage with cat_options

- config.show_comments idem : new column categories.commentable, each
  categories can be commentable or not

- categories.site_id becomes a nullable column : a virtual category does
  belong to no site

- function display_select_categories has a new argument : $CSS_classes array
  to optionnaly assign a CSS class to each category in the select field

- added informations in include/config.inc.php for setting default value of :

  - categories.visible
  - categories.status
  - categories.uploadable
  - categories.commentable

- 2 new indexes images_i3(average_rate) and images_i4(hit) : optimizes best
  rated and most visited categories


git-svn-id: http://piwigo.org/svn/trunk@602 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-11-13 13:43:53 +00:00
z0rglub
32f3056631 there was a bug in the mysql structure script generator : when a column was
nullable the script said the opposite


git-svn-id: http://piwigo.org/svn/trunk@573 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-10-23 09:02:11 +00:00
z0rglub
11699a5546 - checkbox for "remember me" are only shown if authorized
- simplification : each session is created with a cookie and if
  PhpWebGallery can't read the cookie, it uses the URI id and it will be
  used in the add_session_id function.

- configuration parameter "auth_method" disappeared (didn't lived much...)

- only one session id size possible. More comments for configuration in
  include/config.inc.php


git-svn-id: http://piwigo.org/svn/trunk@555 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-10-06 22:48:48 +00:00
z0rglub
3c8309a7e6 - deletion of session_time and session_id_size as config parameter
- new feature : "remember me" creates a long time cookie

- possibility to set the default authentication method to URI or cookie

- really technical parameters (session identifier size, session duration)
  are set in the config file and not in database + configuration.php


git-svn-id: http://piwigo.org/svn/trunk@541 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-10-02 23:12:50 +00:00
gweltas
1d4238055a -First draft of history display
git-svn-id: http://piwigo.org/svn/trunk@537 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-09-26 21:24:49 +00:00
z0rglub
1f71a31084 - in admin/configuration, add new step with "sections" (general, comments,
default, upload, metadata, sessions)

- admin/configuration.php and its template have been higly simplificated by
  making things more generic : for example, for each configuration
  parameter, its name must correspond to the name we find in the config
  table and belongs to a section, in the lang array we find :

  - $lang['conf_<section>_<param>']
  - $lang['conf_<section>_<param>_info']
  - $lang['conf_<section>_<param>_error'] optionnaly

- more described message when connection to database server is impossible

- redefinitions of get_languages and get_templates functions

- deletion of configuration parameters : webmaster, session_keyword

- rename of configuration parameters :

  - default_lang => default_language
  - default_style => default_template


git-svn-id: http://piwigo.org/svn/trunk@512 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-09-03 15:01:05 +00:00
z0rglub
0e2436f50a add rating feature
git-svn-id: http://piwigo.org/svn/trunk@507 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-30 22:00:46 +00:00
z0rglub
d8494248fc "show metadata" feature added : you can ask to show metadata (EXIF and IPTC)
on picture.php page. Metadata read functions were moved from
admin/include/functions_metadata.php to include/functions_metadata.inc.php


git-svn-id: http://piwigo.org/svn/trunk@493 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-25 21:09:09 +00:00
z0rglub
52a8435493 - add files metadata support : use info for database fields
- distinction between directories synchronization and metadata
  synchronization


git-svn-id: http://piwigo.org/svn/trunk@487 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-21 13:01:12 +00:00
z0rglub
d4519a348f - add files metadata support : use info for database fields
- distinction between directories synchronization and metadata synchronization


git-svn-id: http://piwigo.org/svn/trunk@486 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-21 12:52:43 +00:00
z0rglub
bf9fc4f33c - non picture files management (adds column images.representative_ext)
- short_period + long_period replaced by a single recent_period


git-svn-id: http://piwigo.org/svn/trunk@474 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-08-05 17:50:44 +00:00
gweltas
52a3531e7e Installation procedure update
git-svn-id: http://piwigo.org/svn/trunk@463 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-07-28 17:21:58 +00:00
z0rglub
f007a28bf6 replacement of short_period and long_period by recent_period
git-svn-id: http://piwigo.org/svn/trunk@452 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-07-09 21:00:00 +00:00
z0rglub
aa33a48943 - moved index images.storage_category_id to images_i1
- new index images_i2 on images.date_available


git-svn-id: http://piwigo.org/svn/trunk@444 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-06-25 20:38:06 +00:00
z0rglub
537af4c959 - moved index storage_category_id to images_i1
- new index images_i2 on images.date_available


git-svn-id: http://piwigo.org/svn/trunk@443 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-06-25 20:34:39 +00:00
z0rglub
5643049f23 table user_category dropped
git-svn-id: http://piwigo.org/svn/trunk@423 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-28 21:56:07 +00:00
z0rglub
8db124da81 field comments.date becomes a datetime MySQL field type (instead of int)
git-svn-id: http://piwigo.org/svn/trunk@420 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-05-20 21:22:44 +00:00
z0rglub
d74a116ded bug 15 : useless index in categories dropped
git-svn-id: http://piwigo.org/svn/trunk@407 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-31 21:14:51 +00:00
gweltas
6b1aee3dad Default configuration
git-svn-id: http://piwigo.org/svn/trunk@399 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-27 13:25:07 +00:00
z0rglub
0a6d420fd4 new version of config table
git-svn-id: http://piwigo.org/svn/trunk@385 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-04 23:57:39 +00:00
z0rglub
801e36f6d5 initial revision
git-svn-id: http://piwigo.org/svn/trunk@384 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-04 23:57:24 +00:00
z0rglub
72bc2296ca move admin/phpwebgallery_structure.sql to install/phpwebgallery_structure.sql
git-svn-id: http://piwigo.org/svn/trunk@381 68402e56-0260-453c-a942-63ccdbb3a9ee
2004-03-04 23:48:26 +00:00