PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > General Forums > General Discussion

General Discussion General use discussion forum for PhotoPost products.

Reply
 
Thread Tools Rate Thread Display Modes
Old October 16th, 2012, 06:28 AM   #1
b6gm6n
Senior Member
 
Join Date: Mar 2003
Posts: 1,319
Talking remove subscriptions to categories for all members?

i need to remove all category subscriptions for uploads notifications etc for all members, can i do this with some sql? please advise, cheers
b6gm6n is offline   Reply With Quote
Old October 16th, 2012, 07:29 AM   #2
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,239
If you want to remove all subscriptions you would just delete all the records under the notify table.

Othwerwise say to remove all category subscriptions not photo descriptions from say category 502 as an example the query would look like this

Code:
Content visible to verified customers only.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old October 16th, 2012, 06:31 PM   #3
b6gm6n
Senior Member
 
Join Date: Mar 2003
Posts: 1,319
Thanks Chuck.. my host changed something or i just went over a 1000 emails an hour... i got 144 back non-delivered and seeing them all they were just photo upload notifications... i needed to stop that as i removed the subscribe to gallery option on my gallery-pages, anyhew cheers
b6gm6n is offline   Reply With Quote
Old October 16th, 2012, 07:51 PM   #4
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,239
Yeah if you want to remove notifications then it is as simple as

DELETE FROM pp_notify
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Old October 17th, 2012, 01:11 PM   #5
Chuck S
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 75,239
By the way you can also turn off globally the notification to users in your Admin Options.

There is also in the users photopost profile the ability to where you can remove a specific users notifications subscriptions you as admin would see those just like the user would.

We just do not have a global delete all notifications switch in the app. That is kinda like a delete all photos or comments link no real reason thus far to have one.
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:30 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.