Home
last modified time | relevance | path

Searched refs:user_no (Results 1 – 25 of 173) sorted by relevance

1234567

/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/testing/tests/regression-suite/
H A Dsample-data.sql6 INSERT INTO role_member (user_no, role_no) VALUES( 2, 1);
31 INSERT INTO role_member (user_no, role_no) VALUES( 100, 4);
34 INSERT INTO role_member (user_no, role_no) VALUES( 101, 4);
38 INSERT INTO role_member (user_no, role_no) VALUES( 200, 2);
55 FROM usr ORDER BY user_no;
63 FROM usr ORDER BY user_no;
70 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no;
75 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no;
80 … AND NOT EXISTS(SELECT 1 FROM principal WHERE principal.user_no = usr.user_no) ORDER BY user_no;
124 JOIN principal pby ON(t.user_no=pby.user_no)
[all …]
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/patches/
H A D1.2.3a.sql11 …ember ADD CONSTRAINT "role_member_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
14 …E session ADD CONSTRAINT "session_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
17 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
19 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
22 …tting ADD CONSTRAINT "usr_setting_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
25 …word ADD CONSTRAINT "tmp_password_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
28 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
30 … "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
33 …RAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no) ON UPDATE CASCAD…
36 …tem ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
H A D1.2.3.sql30 …ember ADD CONSTRAINT "role_member_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
33 …E session ADD CONSTRAINT "session_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
36 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
38 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
41 …tting ADD CONSTRAINT "usr_setting_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
44 …word ADD CONSTRAINT "tmp_password_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
47 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
49 … "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
52 …RAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no) ON UPDATE CASCAD…
55 …tem ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
H A D1.2.6.sql514 user_no INT8 NULL REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field
519 INSERT INTO principal (type_id, user_no, displayname, default_privileges)
521 …e_member JOIN roles USING(role_no) WHERE role_name = 'Group' AND role_member.user_no = usr.user_no)
522 …ber JOIN roles USING(role_no) WHERE role_name = 'Resource' AND role_member.user_no = usr.user_no) ;
524 INSERT INTO principal (type_id, user_no, displayname, default_privileges)
526 …mber JOIN roles USING(role_no) WHERE role_name = 'Resource' AND role_member.user_no = usr.user_no);
530 …_member JOIN roles USING(role_no) WHERE role_name = 'Group' AND role_member.user_no = usr.user_no);
560 FROM relationship r JOIN usr f ON(f.user_no=r.from_user)
561 JOIN usr t ON(t.user_no=r.to_user)
562 JOIN principal pby ON(t.user_no=pby.user_no)
[all …]
H A D1.2.5.sql10 …ndar_item ADD CONSTRAINT "calendar_item_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no)
14 …ata ADD CONSTRAINT "caldav_data_logged_user_fkey" FOREIGN KEY (logged_user) REFERENCES usr(user_no)
18 …INT "relationship_from_user_fkey" FOREIGN KEY (from_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
20 …STRAINT "relationship_to_user_fkey" FOREIGN KEY (to_user) REFERENCES usr(user_no) ON UPDATE CASCAD…
25 …property ADD CONSTRAINT "property_changed_by_fkey" FOREIGN KEY (changed_by) REFERENCES usr(user_no)
H A D1.2.1.sql59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name);
63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda…
64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h…
69 … (select collection.dav_name FROM collection WHERE collection.user_no = caldav_data.user_no limit …
H A D1.2.1a.sql59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name);
63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda…
64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h…
69 … (select collection.dav_name FROM collection WHERE collection.user_no = caldav_data.user_no limit …
H A D1.1.11.sql8 ALTER TABLE caldav_data ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE…
11 ALTER TABLE collection ADD CONSTRAINT "$1" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON UPDATE …
H A D1.1.11a.sql9 …_data ADD CONSTRAINT "caldav_data_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
12 …ection ADD CONSTRAINT "collection_user_no_fkey" FOREIGN KEY (user_no) REFERENCES usr(user_no) ON U…
H A D1.2.1b.sql59 ALTER TABLE collection ADD UNIQUE (user_no,dav_name);
63 INSERT INTO collection ( user_no, parent_container, dav_name, dav_etag, dav_displayname, is_calenda…
64 …SELECT user_no, '/'||username||'/', '/'||username||'/home/', md5(user_no::text||'/'||username||'/h…
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/scripts/
H A Dload_calendar.php66 var $user_no; variable in FakeSession
74 function __construct($user_no = null) { argument
75 if ( empty($user_no) ) {
76 $this->user_no = -1;
82 $this->user_no = $user_no;
83 $principal = new Principal('user_no',$user_no);
105 $session = new FakeSession($dest->user_no());
116 $user_no = $dest->user_no(); variable
120 controlRequestContainer( $session->username, $dest->user_no(), $target, false, ($dest->IsPublic() ?…
121 import_collection( $ics, $dest->user_no(), $target, $session->user_no, ($mode == 'append') );
H A Dexport_calendar.php36 var $user_no; variable in FakeSession
44 function __construct($user_no = null) { argument
45 if ( empty($user_no) ) {
46 $this->user_no = -1;
52 $this->user_no = $user_no;
53 $principal = new Principal('user_no',$user_no);
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/views/
H A Ddav_principal.sql7 SELECT user_no, usr.active AS user_active, joined AS created, updated AS modified,
17 FROM usr JOIN principal USING(user_no);
22 …INSERT INTO usr ( user_no, active, joined, updated, username, password, fullname, email, email_ok,…
24 COALESCE( NEW.user_no, nextval('usr_user_no_seq')),
34 INSERT INTO principal ( user_no, principal_id, type_id, displayname, default_privileges )
36 COALESCE( NEW.user_no, currval('usr_user_no_seq')),
50 user_no=NEW.user_no,
60 WHERE user_no=OLD.user_no;
74 DELETE FROM usr WHERE user_no=OLD.user_no;
/dports/devel/php-libawl/awl-827fbfed7dab0ca339998ca6cdcffb328246d83b/inc/
H A DUser.php42 var $user_no; variable in User
65 $this->user_no = 0;
72 $this->user_no = $id;
83 if ( $this->user_no == 0 ) {
116 $rc = ( $this->user_no > 0 && $session->user_no == $this->user_no );
120 $rc = ( $this->user_no > 0 && $session->user_no == $this->user_no );
124 $rc = ( ($this->user_no > 0 && $session->user_no == $this->user_no)
173 if ( $this->user_no > 0 ) $html .= $ef->HiddenField( "user_no", $this->user_no );
357 $this->user_no = $sequence_value[0];
360 …if ( $this->user_no == $session->user_no && $this->Get("date_format_type") != $session->date_forma…
[all …]
H A DSession.php33 * @param int $user_no Which user is attempting to log on.
36 function check_temporary_passwords( $they_sent, $user_no ) { argument
38 $qry = new AwlQuery( $sql, $user_no, $they_sent );
45 $qry = new AwlQuery( $sql, $user_no );
75 var $user_no; variable in Session
346 $user_no = ( method_exists( $usr, 'user_no' ) ? $usr->user_no() : $usr->user_no );
354 dbg_error_log( "Login", " Login: Valid username/password for $username ($user_no)" );
357 …n.user_no = ? ORDER BY session_id DESC LIMIT 1) WHERE user_no = ?;', $usr->user_no, $usr->user_no);
362 $qry = new AwlQuery( $sql, $session_id, $user_no, $session_key );
371 … dbg_error_log( "Login", " Login: New session $session_id started for $username ($user_no)" );
[all …]
/dports/devel/php-libawl/awl-827fbfed7dab0ca339998ca6cdcffb328246d83b/dba/
H A Dawl-tables.sql13 user_no SERIAL PRIMARY KEY, field
31 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE, field
34 PRIMARY KEY ( user_no, setting_name )
52 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE field
58 user_no INT4 REFERENCES usr ( user_no ) ON DELETE CASCADE, field
67 user_no INT4 REFERENCES usr ( user_no ), field
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/dba/
H A Ddavical.sql99 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field
116 UNIQUE(user_no,dav_name)
124 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field
136 PRIMARY KEY ( user_no, dav_name )
144 user_no INT references usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE, field
178 PRIMARY KEY ( user_no, dav_name )
232 user_no integer NOT NULL REFERENCES usr(user_no) ON UPDATE CASCADE ON DELETE CASCADE, field
253 OR OLD.user_no != NEW.user_no OR OLD.dav_name != NEW.dav_name THEN
254 UPDATE calendar_item SET dav_id = NEW.dav_id, user_no = NEW.user_no,
261 UPDATE calendar_item SET dav_id = NEW.dav_id, user_no = NEW.user_no,
[all …]
H A Dbase-data.sql17 INSERT INTO usr ( user_no, active, email_ok, updated, username, password, fullname, email )
19 INSERT INTO principal ( principal_id, type_id, user_no, displayname, default_privileges )
22 INSERT INTO role_member (user_no, role_no) VALUES(1, 1);
/dports/www/davical/davical-9da21ad116a2913bf788bd4b0b8c58c0de83d9da/inc/
H A Dcaldav-PUT-functions.php67 * @param int $user_no The user making the change
118 ':user_no' => $user_no,
121 ':dav_etag' => md5($user_no. $request_container),
150 function public_events_only( $user_no, $dav_name ) { argument
837 ':session_user' => $session->user_no,
885 $dav_data_params[':user_no'] = $user_no;
1072 $dav_data_params[':user_no'] = $user_no;
1380 $user_no = $collection->user_no();
1534 if ( public_events_only($user_no, $path) ) {
1622 $dav_params[':user_no'] = $user_no;
[all …]
H A Dlog_caldav_action.php22 * @param integer $user_no The user owning the containing collection.
26 function log_caldav_action( $action_type, $uid, $user_no, $collection_id, $dav_name ) { argument
35 …$logline = sprintf( '%s, %s, %s, %s, %s, %s', $action_type, $uid, $user_no, $collection_id, $dav_n…
42 function post_commit_action( $action_type, $uid, $user_no, $collection_id, $dav_name ) { argument
51 …$logline = sprintf( '%s, %s, %s, %s, %s, %s', $action_type, $uid, $user_no, $collection_id, $dav_n…
H A Dauth-functions.php63 function getUserByID( $user_no, $use_cache = true ) { argument
65 return new Principal('user_no', $user_no, $use_cache);
117 $params[':user_no'] = $principal->user_no();
151 $params2[':user_no'] = $principal->user_no();
250 if ( !isset($usr->user_no) || intval($usr->user_no) == 0 ) {
254 $usr->user_no = $sequence_value[0];
257 … = new AwlQuery('SELECT * FROM usr WHERE user_no = :user_no', array(':user_no' => $usr->user_no) );
283 if ( $type != 'INSERT' ) $params[':user_no'] = $usr->user_no;
302 array(':new_display' => $usr->fullname, ':user_no' => $usr->user_no)
H A DPublicSession.php30 * @var user_no int
32 public $user_no; variable in PublicSession
73 $this->user_no = $principal->user_no();
H A DWritableCollection.php42 $user_no = $this->user_no();
47 …rollback_on_error( $caldav_context, $user_no, $this->dav_name.'/'.$segment_name, translate('No cal…
83 rollback_on_error( $caldav_context, $user_no, $path);
94 ':user_no' => $user_no,
102 ':session_user' => $session->user_no,
123 rollback_on_error( $caldav_context, $user_no, $path);
259 … log_caldav_action( $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path );
263 $put_action_type, $first->GetPValue('UID'), $user_no, $collection_id, $path );
269 rollback_on_error( $caldav_context, $user_no, $path);
275 dbg_error_log( 'PUT', 'User: %d, ETag: %s, Path: %s', $session->user_no, $etag, $path);
H A Dcaldav-PUT-vcard.php71 $user_no = $dest->GetProperty('user_no'); variable
114 ':user_no' => $user_no,
118 ':session_user' => $session->user_no,
130 import_collection($request->raw_post, $request->user_no, $request->path, true, $appending);
166 log_caldav_action( $put_action_type, $uid, $user_no, $collection_id, $request->path );
170 $put_action_type, $uid, $user_no, $collection_id, $request->path );
H A DPrincipal.php50 protected $user_no; variable in Principal
145 case 'user_no': $this->user_no = $value; break;
186 self::$byUserno[$row->user_no] = $row->username;
228 self::$byUserno[$row->user_no] = $row->username;
266 $this->user_no = -1;
352 function user_no() { function in Principal
353 return (isset($this->user_no)?$this->user_no:false);
414 …lQuery('SELECT * FROM collection WHERE user_no= :user_no', array(':user_no' => $this->user_no()) );
562 if ( isset($this->user_no) ) {
565 $sql_params[':user_no'] = $this->user_no;

1234567