Bugzilla – Attachment 25972 Details for
Bug 11889
Option to keep public or shared lists when deleting patron
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
Example code
disown_example_code.txt (text/plain), 831 bytes, created by
Marcel de Rooy
on 2014-03-10 08:25:42 UTC
(
hide
)
Description:
Example code
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2014-03-10 08:25:42 UTC
Size:
831 bytes
patch
obsolete
>#Delete private lists without owner that now have no shares anymore >$query="DELETE vs.* FROM virtualshelves vs LEFT JOIN virtualshelfshares sh USING (shelfnumber) WHERE category=1 AND vs.owner IS NULL AND sh.shelfnumber IS NULL"; >$dbh->do($query); > >#Change owner for private lists which have shares >$query="UPDATE virtualshelves LEFT JOIN virtualshelfshares sh USING (shelfnumber) SET owner=NULL where owner=? AND category=1 AND sh.borrowernumber IS NOT NULL"; >$dbh->do($query,undef,($borrower)); > > >#Handle public lists owned by borrower >$query="UPDATE virtualshelves SET owner=NULL WHERE owner=? AND category=2"; >$dbh->do($query,undef,($borrower)); > >#Niet nodig vanwege table constraint.. >$query="UPDATE virtualshelfcontents SET borrowernumber=NULL WHERE borrowernumber=?"; >$dbh->do($query,undef,($borrower));
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Raw
Actions:
View
Attachments on
bug 11889
:
25972
|
60224
|
60306
|
60307
|
60308
|
60481
|
61319
|
61320
|
61321
|
61322
|
61451
|
61452
|
61453
|
61454
|
108244
|
108245
|
108246
|
108247
|
135808
|
135809
|
135810
|
135811
|
135812
|
135813
|
135814
|
135815
|
135816
|
135817
|
135818
|
135819
|
135820
|
135821
|
135857
|
135858
|
135859
|
135860
|
135861
|
135862
|
135863
|
135864
|
135865
|
135866
|
135867
|
135868
|
135869
|
135870
|
135871
|
135872
|
135873
|
135874
|
135875
|
135876
|
135891
|
135892
|
135893
|
135894
|
135895
|
135896
|
135897
|
135898
|
135899
|
135900
|
135901