View Full Version : Make all images from one user sticky
February 10th, 2008, 07:16 AM
This would be cool if there would be an option to make all images of user x sticky or unsticky. If not, is it possible to do this by a sql query Zach?
March 23rd, 2008, 07:19 AM
Because only 1 view of this thread (by myself?) I may bump this?
Anybody know how I can do this by an sql query?
March 23rd, 2008, 11:43 AM
1 - yes
0 - no
- by username
UPDATE ppgal_images SET sticky = '1' WHERE username = 'Zachariah';
- by userid
UPDATE ppgal_images SET sticky = '1' WHERE userid = '1';
- by userid in category 2 only
UPDATE ppgal_images SET sticky = '1' WHERE userid = '1' AND catid = '2';
March 23rd, 2008, 12:06 PM
Great, this helps me a lot. Thank you very much Zachariah
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.