[Linpha-cvs] SF.net SVN: linpha: [4473] trunk/linpha2
Status: Inactive
Brought to you by:
bzrudi
From: <fan...@us...> - 2006-04-02 13:11:37
|
Revision: 4473 Author: fangehrn Date: 2006-04-02 06:11:24 -0700 (Sun, 02 Apr 2006) ViewCVS: http://svn.sourceforge.net/linpha/?rev=4473&view=rev Log Message: ----------- * updated documentation, added todo list Modified Paths: -------------- trunk/linpha2/ChangeLog trunk/linpha2/linpha2.specs.txt Removed Paths: ------------- trunk/linpha2/db_data.sql Modified: trunk/linpha2/ChangeLog =================================================================== --- trunk/linpha2/ChangeLog 2006-04-02 12:51:42 UTC (rev 4472) +++ trunk/linpha2/ChangeLog 2006-04-02 13:11:24 UTC (rev 4473) @@ -1,5 +1,6 @@ 2006-04-02 flo * added integrity check (checks album, tmp and cache folder) + * updated documentation, added todo list 2006-04-01 flo * update several folder paths Deleted: trunk/linpha2/db_data.sql =================================================================== --- trunk/linpha2/db_data.sql 2006-04-02 12:51:42 UTC (rev 4472) +++ trunk/linpha2/db_data.sql 2006-04-02 13:11:24 UTC (rev 4473) @@ -1,66 +0,0 @@ --- --- Daten f?r Tabelle `linpha_photos` --- -use linpha2; -TRUNCATE `linpha_config`; -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_db_adodb_cache_path', 'var/tmp/adocache', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_db_adodb_caching', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_db_version', '1', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_im_bracket_support', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_im_convert_path', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_im_gd_version', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_im_use_convert', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_im_video_thumbnail', '1', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_import_autoimport', '1', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_image_exif', '1', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_image_iptc', '0', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_lang', 'German', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_lang_autolang', '1', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_path_album_dir', 'albums/', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_path_cache_dir', 'var/cache/', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_path_tmp_dir', 'var/tmp/', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_style_img_quality', '75', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_style_style', 'aqua', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_style_tn_size', '150', 0); -INSERT INTO `linpha_config` (`option_name`, `option_value`, `userid`) VALUES ('sys_user_autologin', '1', 0); - --- -------------------------------------------------------- - --- --- Daten f?r Tabelle `linpha_groups` --- -TRUNCATE `linpha_groups`; -INSERT INTO `linpha_groups` (`name`) VALUES ('gruppe1'); -INSERT INTO `linpha_groups` (`name`) VALUES ('gruppe2'); - --- -------------------------------------------------------- - --- --- Daten f?r Tabelle `linpha_permissions` --- -TRUNCATE `linpha_permissions`; -INSERT INTO `linpha_permissions` (`photos_id`, `perm_type`, `permission`) VALUES (0, 'read', ';public;'); - --- -------------------------------------------------------- - -TRUNCATE `linpha_photos`; - - --- --- Daten f?r Tabelle `linpha_meta_fields` --- -TRUNCATE `linpha_meta_fields`; -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (1, 'description', 1, 5); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (2, 'category', 2, 5); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (3, 'persons', 2, 5); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (4, 'date', 3, 5); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (6, 'filename', 0, 1); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (7, 'imagesize', 0, 1); -INSERT INTO `linpha_meta_fields` (`id`, `name`, `field_type`, `flags`) VALUES (8, 'dimension', 0, 1); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_6', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_7', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_8', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_1', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_2', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('id_3', 0, 10); -INSERT INTO `linpha_meta_fields` (`name`, `field_type`, `flags`) VALUES ('exif_datetimeoriginal', 0, 10); Modified: trunk/linpha2/linpha2.specs.txt =================================================================== --- trunk/linpha2/linpha2.specs.txt 2006-04-02 12:51:42 UTC (rev 4472) +++ trunk/linpha2/linpha2.specs.txt 2006-04-02 13:11:24 UTC (rev 4473) @@ -82,41 +82,7 @@ - Fenster ueberwachen http://de.selfhtml.org/javascript/beispiele/fensterueberwachen.htm - -Part 5: Folder Structure -============================================================================== -actions/ -admin/ -admin/actions -admin/docs -admin/lang -albums/ -install/ -install/docs -install/lang -lib/ -lib/adodb -lib/classes -lib/docs -lib/graphics -lib/include -lib/lang -lib/plugins -lib/themes -var/ -var/cache/ -var/cache/imgcache -var/cache/thumbcache -var/sql/ -var/tmp/ - -hints: -- /var need to be checked by new installer for rw access -- change perms to rwx owner and rwx group after install 770 for these folders - - - -Part 12. main menu +Part 5. main menu ============================================================================ - use a css only menu? - use something like this: http://www.milonic.com/mfa/2004-February/003609.html ? @@ -169,89 +135,4 @@ lets say i'm requesting an image between 800x600 and 1024x768 i will get the image 1024x768, between 1024x768 and 1310x983 i will get an image with 1310x983 we would have calculate a good value of the different image sizes handling thecompromise - between size of the image and difference in size - - -############################################################################ -TODOS 2.0 -############################################################################ -- check automatically if a file was changed by an external program and update md5sum etc. -- check how much faster it is to have thumbnails stored on filesystem and not in db -- use of get_ride_of_magicquotes() in all files - - - use of templates (smarty? css? (http://www.csszengarden.com/tr/deutsch)) - use one css file for global settings - different css files for layout settings - different css files for colour settings - use css files like this: - // font settings - body, td, ..., ..., ... { - font-family: Verdana, Arial, Helvetica, sans-serif; - font-size: 10pt; - color: #000033; - } - - // background color - body, td, .......... { - background-color: #002200; - } - - layout with header and footer written in css: - http://css.fractatulum.net/sample/layout7format.htm - - DONE - ==== - - store thumbnails in /var/cache/thumb? - - id or md5sum based? - /* edit bzrudi */ - (as discussed it should be id based...) - - - allow unlimited subfolders - - allow permissions set to all files and folders - - - complete rewrite of the install scripts - more steps: - 1. check requirements - 2. select db type - 3. enter db user/pass - 4. check connection - 5. create database or not (not needed with sqlite) - 6. create tables - 7. further settings (thumbnail size, admin account) - - - new folder structure: - actions/ - admin/ - admin/actions - admin/lang - albums/ - docs/ - docs/lang - graphics/ - install/ - install/lang - lang/ - lib/ - lib/adodb ? - lib/classes - lib/functions - lib/include - plugins/ - styles/layout/ - styles/format/ - - sql/ ? evtl. auch "tmp" "cache" oder etwas besseres ? - -- db design: - linpha_photos(id, name, md5sum, type, date_added) - linpha_permissions(id, photos_id, permissions, read_write) - linpha_stats(md5sum, downloads, views) - - todo: create sql query where it is possible with only one query to select only images - where i have permission to read like we have it with linpha 1.0: - SELECT linpha_photos.prev_path AS prev_path, linpha_photos.filename AS filename - FROM linpha_photos, linpha_first_lev_album - WHERE linpha_photos.prev_path LIKE CONCAT(linpha_first_lev_album.path,'%') - AND (linpha_first_lev_album.groups LIKE '%;public;%') - AND (linpha_photos.id='612'); - \ No newline at end of file + between size of the image and difference in size \ No newline at end of file This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |