As I await your kind reply
, I'm still trying to whip up my SQL command to do this in one fell sweep. I pretty much have it ready..
Presuming you don't have an easy way to do this, could you just confirm with me that if I manufacture the proper sql code in the format:
Content visible to verified customers only.
where 242 = unique ID,
101 = user id,
2924 = photo id,
and 0 indicates this is an image, not a category,
If I get a nice text file / spreadsheet created with this format across every photo, and I insert it, would that be all I must do to solve my problem?
I did set new photos to default notify instead of default don't notify, so moving forward is no problem, but for these, if I do this, that's all that must be done?
To rephrase that
, when a photo is set to notify the member of comments, is this the only table that is affected? If I insert my whipped up INSERT INTO commands, am I all set for what I want to accomplish?
I would of course make sure there are no duplicates...
PS, a bit off topic, but still on topic so to speak.. for all those people that want to do this themselves, to generate the unique ID's when I'm stuck in this situation, a quick visit to http://www.random.org/sequences
(not my site) gets a lot of the dirty work done. You specify 1 then the highest number, submit, and there you have your numbers. You can then sort that ascending in excel.. sure beats typing out each number by hand or writing some script to do it.