Hi all, I hope I'm posting in the right area here.
I run a fanvids database, using the newest version of eFiction, which I have hacked to include a couple of new fields (vid_artist and vid_url). I inherited the site from someone else. They used to run it on a hacked version of Shallot's AutoArchive, but when I took over, I wanted the vidders to be able to log in and manage their entries in the database without the admins having to manually change the database. Hence the change of script.
One of the features of the old script was that when ever a vid was entered into the database, the vidder had the option of posting to the site mailing list as well. I'm not too bothered about the vidder making the choice to copy their entry to the mailing list or not. I know I could make a dummy account with the mailing list's email address and have it favourite every vidder in the database (all 300+ of them), but that still wouldn't catch the new entries from vidders who had not previously registered.
In short, how do I get the site to send out an alert to the mailing list every time someone posts a new vid? I want to keep the alert function working normally as well as this. It's part of what I love about the script.
Also, I would like to expand the alerts to include characters, pairings and so forth, so any tips on that? Ditto the RSS, if possible.
If I've not managed to fully explain what my site does, the site is up at a temporary domain at http://vidding.inthemoonlight.net/
Sorry for posing so many questions at once, and thank you in advance of any replies.
There's a hook in the script when a story is added that you could use. How much PHP and mySQL do you know?
Very little. I know enough to create things like an updates blog, where it's nice and simple, info in, info out, but using more than one table, arrays and functions... all of that is beyond what I'm capable of.
