Changeset 1028
- Timestamp:
- Feb 6, 2006, 11:59:30 PM (18 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/include/functions.php
r1006 r1028 3 3 // | PhpWebGallery - a PHP based picture gallery | 4 4 // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | 5 // | Copyright (C) 2003-200 5PhpWebGallery Team - http://phpwebgallery.net |5 // | Copyright (C) 2003-2006 PhpWebGallery Team - http://phpwebgallery.net | 6 6 // +-----------------------------------------------------------------------+ 7 7 // | branch : BSF (Best So Far) … … 275 275 // - all the links to any group 276 276 // - all the favorites linked to this user 277 // - all sessions linked to this user278 277 // - calculated permissions linked to the user 278 // - all datas about notifications for the user 279 279 function delete_user($user_id) 280 280 { … … 288 288 pwg_query($query); 289 289 290 // destruction of data notification by mail for this user 291 $query = ' 292 DELETE FROM '.USER_MAIL_NOTIFICATION_TABLE.' 293 WHERE user_id = '.$user_id.' 294 ;'; 295 pwg_query($query); 296 297 // destruction of data RSS notification for this user 298 $query = ' 299 DELETE FROM '.USER_FEED_TABLE.' 300 WHERE user_id = '.$user_id.' 301 ;'; 302 pwg_query($query); 303 290 304 // destruction of the group links for this user 291 305 $query = ' … … 298 312 $query = ' 299 313 DELETE FROM '.FAVORITES_TABLE.' 300 WHERE user_id = '.$user_id.'301 ;';302 pwg_query($query);303 304 // destruction of the sessions linked with the user305 $query = '306 DELETE FROM '.SESSIONS_TABLE.'307 314 WHERE user_id = '.$user_id.' 308 315 ;'; … … 1193 1200 $tables = 1194 1201 array( 1202 USER_MAIL_NOTIFICATION_TABLE, 1195 1203 USER_FEED_TABLE, 1196 1204 USER_INFOS_TABLE, -
trunk/include/constants.php
r1008 r1028 3 3 // | PhpWebGallery - a PHP based picture gallery | 4 4 // | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net | 5 // | Copyright (C) 2003-200 5PhpWebGallery Team - http://phpwebgallery.net |5 // | Copyright (C) 2003-2006 PhpWebGallery Team - http://phpwebgallery.net | 6 6 // +-----------------------------------------------------------------------+ 7 7 // | branch : BSF (Best So Far) … … 62 62 define('UPGRADE_TABLE', $prefixeTable.'upgrade'); 63 63 define('SEARCH_TABLE', $prefixeTable.'search'); 64 define('USER_MAIL_NOTIFICATION_TABLE', $prefixeTable.'user_mail_notification'); 65 64 66 ?> -
trunk/install/phpwebgallery_structure.sql
r1020 r1028 325 325 ) TYPE=MyISAM; 326 326 327 -- 328 -- Table structure for table `phpwebgallery_user_mail_notification` 329 -- 330 331 DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`; 332 CREATE TABLE `phpwebgallery_user_mail_notification` 333 ( 334 `user_id` smallint(5) NOT NULL default '0', 335 `check_key` varchar(128) binary NOT NULL, 336 `enabled` enum('true','false') NOT NULL default 'false', 337 `last_send` datetime default NULL, 338 PRIMARY KEY (`user_id`), 339 UNIQUE KEY `uidx_check_key` (`check_key`) 340 ) TYPE=MyISAM;
Note: See TracChangeset
for help on using the changeset viewer.