aboutsummaryrefslogtreecommitdiffstats
path: root/include/functions_user.inc.php (unfollow)
Commit message (Collapse)AuthorFilesLines
2010-07-05Bug 1760 fixed : Avoid session fixationnikrou1-1/+1
After connection, session id is changed using session_regenerate_id but without removing old session. Passing param true makes the job Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6661 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-07-03Bug 1754 fixed : The keyword AS is mandatory for alias in PostgreSQL queriesnikrou1-2/+2
Merge from trunk git-svn-id: http://piwigo.org/svn/branches/2.1@6653 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-06-09Fix bug 1722 : PosgtreSQL wants all fields in select to be in Group by clausenikrou1-8/+22
or agregate function Fix issue for lambda function (incorrect number of params) merge from trunk. git-svn-id: http://piwigo.org/svn/branches/2.1@6511 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-24bug 1682: r6312 was producing a MySQL error (depending on the MySQL serverplegall1-1/+2
version) because a count() implies a group by. This code change was checked against MySQL 5.0.75, MySQL 5.0.51 (where the error occured) and SQLite 3.6.22. git-svn-id: http://piwigo.org/svn/branches/2.1@6321 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-23bug 1684 fixed: the test to check availability of the user_infos line wasplegall1-14/+18
wrong. I had changed the old db_num_rows > 0 because it was not working with SQLite. As suggested by nicolas, let's use a simpler trick "count(1)" in the query itself, this way it should work with any database engine. I've also removed the while (true) (ugly infinite loop, with a condition for exit) that was producing an infinite loop for Piwigo installations with 2.0 database model and 2.1 code (before launching upgrade.php) git-svn-id: http://piwigo.org/svn/branches/2.1@6312 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-23bug 1683 fixed: as soon as an admin modifies the admin>conf>options>guest ↵plegall1-0/+41
settings, registration is broken. This is because user_infos.theme/language are emptied (while they should not). I have also added an "automatic repair" piece of code in get_default_user_info function. This piece of code should be removed for 2.2 with the appropriate migration task. git-svn-id: http://piwigo.org/svn/branches/2.1@6311 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-05-07bug 1648 fixed: add the pwg_db_check_version functions for pdo-sqlite, sqliteplegall1-1/+1
and pgsql, also make the $pwg_db_link global in the install_db_connect function so that it can be used in SQLite functions. bug fixed: with pdo-sqlite, pwg_db_num_rows always returns 0, so when initializing user data, it tries to insert the same row twice. git-svn-id: http://piwigo.org/svn/trunk@6090 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-04-28feature 1630: upgrade to Piwigo 2.1 :-)plegall1-1/+15
bug 1604: only activate core themes not all themes. git-svn-id: http://piwigo.org/svn/trunk@5982 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-23Add function is_webmaster (like is_admin function)rub1-0/+9
Add on ignore list the directory local/personal git-svn-id: http://piwigo.org/svn/trunk@5272 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-22bug fixed: if the theme for guest is empty (I don't know how this could be,plegall1-1/+1
but it has been reported), the fallback on constant PHPWG_DEFAULT_TEMPLATE was not working. git-svn-id: http://piwigo.org/svn/trunk@5271 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-22feature 1514: improvement, if a user has a theme that is (maybe temporary)plegall1-5/+6
unactive, we fallback on default theme (the real default theme, the one set for default user) git-svn-id: http://piwigo.org/svn/trunk@5264 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-19increase copyright year to 2010plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@5196 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-19bug 1328: backport the pwg_token on trunkplegall1-7/+32
bug 1329: backport the check_input_parameter on trunk feature 1026: add pwg_token feature for edit/delete comment. Heavy refactoring on this feature to make the code simpler and easier to maintain (I hope). git-svn-id: http://piwigo.org/svn/trunk@5195 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-13feature 1502: based on Dotclear model, P@t has reorganized the way Piwigoplegall1-3/+7
manages template/theme in a simpler "theme only level" architecture. It supports multiple level inheritance. git-svn-id: http://piwigo.org/svn/trunk@5123 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-06Renaming $conf['no_case_sensitive_for_login'] to ↵Eric1-1/+1
$conf['insensitive_case_logon'] according with VDigital's proposal git-svn-id: http://piwigo.org/svn/trunk@5060 68402e56-0260-453c-a942-63ccdbb3a9ee
2010-03-02Feature 1451 : localization with gettextnikrou1-7/+7
Use php-gettext (developpement version rev43, because of php5.3) as fallback Use native language (english) instead of key for translation Keep directory en_UK for english customization Need some refactoring for plurals Todo : managing plugins in the same way git-svn-id: http://piwigo.org/svn/trunk@5021 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-12-05Feature 0000796 fixed : Strengthen login handlingEric1-0/+34
git-svn-id: http://piwigo.org/svn/trunk@4429 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-29Feature_1255 :nikrou1-1/+1
- single quotes in queries - start using $conf['dblayer'] git-svn-id: http://piwigo.org/svn/trunk@4385 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-25Feature 1255: modification in sql queriesnikrou1-4/+4
- manage random function - manage regex syntax - manage quote (single instead of double) - manage interval git-svn-id: http://piwigo.org/svn/trunk@4367 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-20Feature 1244 resolvednikrou1-22/+22
Replace all mysql functions in core code by ones independant of database engine Fix small php code synxtax : hash must be accessed with [ ] and not { }. git-svn-id: http://piwigo.org/svn/trunk@4325 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-18Escape all login and username characters in databaseEric1-8/+8
Display correctly usernames (I hope not to have made mistakes) git-svn-id: http://piwigo.org/svn/trunk@4304 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-11-15Feature 1241 resolved. replace mysql_fetch_array by mysql_fetch_assoc for ↵nikrou1-10/+10
small php code improvements git-svn-id: http://piwigo.org/svn/trunk@4265 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-08-17PHP 5.3 compatibility - Deprecated functions were replace as follows :Eric1-2/+2
ereg() -> preg_match() ereg_replace() -> preg_replace() eregi() -> preg_match() with the 'i' modifier eregi_replace() -> preg_replace() with the 'i' modifier set_magic_quotes_runtime() -> No more usefull. Fixed it by adding "@" prefix. git-svn-id: http://piwigo.org/svn/trunk@3747 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-07-20- bug fix (use uasort for computed categories instead of usort) - I think ↵rvelices1-1/+1
this is an old bug and somehow it worked before) git-svn-id: http://piwigo.org/svn/trunk@3642 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-07-20correct bug in commit r3622 ( feature 1053 )rvelices1-3/+3
git-svn-id: http://piwigo.org/svn/trunk@3640 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-07-18feature 1053: hide categories that contain no photo due to privacy levelrvelices1-44/+54
git-svn-id: http://piwigo.org/svn/trunk@3622 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-06-23Feature 1026 step 2 :nikrou1-2/+3
add author_id column so that guest cannot modify old users comments git-svn-id: http://piwigo.org/svn/trunk@3450 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-06-23Feature 1026 : Modify / delete comments for usersnikrou1-0/+15
+ update config table content + minor modification of Sylvia theme + need refactoring git-svn-id: http://piwigo.org/svn/trunk@3445 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-02-14Last (I hope) paranoic optims ...rvelices1-56/+0
- move get_uysername and get_groupname from public to admin/functions.inc.php - optim in index.php - tags.tpl does not need smarty modifier included - move func get_comment_post_key from functions_comment to functions (avoid extra inclusion every time on picture page) git-svn-id: http://piwigo.org/svn/trunk@3145 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-02-05- embellish_url compacts now ..rvelices1-12/+12
- some trigger improvements (render_category_description) - improved perf of duplicate_xxx_url ( rewrote func params_for_duplication and remove some vars from $page ) git-svn-id: http://piwigo.org/svn/trunk@3126 68402e56-0260-453c-a942-63ccdbb3a9ee
2009-01-04Administration: happy new year 2009, all PHP headers updated. plegall1-1/+1
git-svn-id: http://piwigo.org/svn/trunk@3049 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-11-04merge -c2823 from branch 2.0 to trunkrvelices1-14/+1
- removed some unused constants from constants.php - removed some unused css rules - removed unused code git-svn-id: http://piwigo.org/svn/trunk@2824 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-10-16merge 2755 and 2756 from branch 2.0 to trunkrvelices1-4/+30
- 2755 fix vulnerability http://www.milw0rm.com/exploits/6755 - 2756 security paranoia: protect session/remember me cookies from XSS attacks (works only if php>=5.2 and with IE/FF maybe others) git-svn-id: http://piwigo.org/svn/trunk@2757 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-10-15- change mysql_escape_string function (deprecated) by mysql_real_escape_string.patdenice1-2/+2
- Correction on install.tpl (link color). git-svn-id: http://piwigo.org/svn/trunk@2752 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-23- removed #debug css rule (why would we need that in default-layout?)rvelices1-9/+2
- order by rank is not available in calendar/chronology mode - small non-functional change in functions_search.inc.php (handy for plugin) - unused variables/smaller code/unused params in func call git-svn-id: http://piwigo.org/svn/trunk@2572 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-14$_SERVER["HTTP_ACCEPT_LANGUAGE"] could be empty so test it.nikrou1-1/+8
git-svn-id: http://piwigo.org/svn/trunk@2537 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-09-07fix too strict regex for emailnikrou1-1/+4
git-svn-id: http://piwigo.org/svn/trunk@2507 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-22- add #user_cache.cache_update_time - useful for plugins or the filter when ↵rvelices1-13/+8
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-05- fix some side effects with browser language (wrong display/user creation ↵rvelices1-15/+13
in admin and mails to admin in user browser language) git-svn-id: http://piwigo.org/svn/trunk@2425 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-01- put back browser language (deleted by error during my last commit - was ↵rvelices1-3/+29
working on an old version) git-svn-id: http://piwigo.org/svn/trunk@2411 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-07-01- remember me cookie security improvement (the time when the cookie was ↵rvelices1-37/+17
generated is saved and checked in range [now-remember_me_length; now] - tags improvements * pass to templates all fields in table #tags (handy for plugins such as type tags) * fix issue with tag letter when first letter is accentuated (utf-8) * tags are sorted on url_name instead of name (accentuated first letter chars are the same as without accent) * better use of columns in by letter display mode git-svn-id: http://piwigo.org/svn/trunk@2409 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-31Feature 0000080: Browser language detection (Use first active browser ↵vdigital1-1/+27
language as language for guest, generic members, registering process). If the language is not available PHPWG_DEFAULT_LANGUAGE is used as previously. git-svn-id: http://piwigo.org/svn/trunk@2371 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-05-02Resolved issue 0000823: Enhance upload functionalitiesrub1-3/+3
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-01- move #categories.date_last and nb_images to #user_cache_categoriesrvelices1-15/+7
git-svn-id: http://piwigo.org/svn/trunk@2324 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-26New: jQuery and Accordion Admin menusvdigital1-6/+1
git-svn-id: http://piwigo.org/svn/trunk@2313 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-04-05Bug fixed: as rvelices notified me by email, my header replacement script wasplegall1-24/+0
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-04Modification: new header on PHP files, PhpWebGallery renamed Piwigo.plegall1-0/+21
git-svn-id: http://piwigo.org/svn/trunk@2297 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-03-08- security fix (profile)rvelices1-5/+4
- les langues a la hache - fix some copy/paste errors git-svn-id: http://piwigo.org/svn/trunk@2268 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-03-01Merge from revision 2236.patdenice1-1/+10
801: add trigger in register_user function. 805: add 2 triggers in profile.php. 769: correct get_email_address_as_display_text function. git-svn-id: http://piwigo.org/svn/trunk@2237 68402e56-0260-453c-a942-63ccdbb3a9ee
2008-02-29Merge from revision 2228.patdenice1-2/+2
Resolved bugs: 741 and 793: Added user does not appear in listing. 769: show email address in adviser mode when editing user profil. 800: get_absolute_root_url does not work with https protocol. git-svn-id: http://piwigo.org/svn/trunk@2229 68402e56-0260-453c-a942-63ccdbb3a9ee