Yanc Mod Under Way Hello,
I have started working on a mod for YaNC and user. Some of the changes will be:
Frontend:
-users will be able to subscribe to any or all of the published newsletters during signup
-users who have already signed up will be able to change in their details section
-users with adequate permissions will be able to send newsletters from site (that way you can give someone permission to do newsletters but not change any other configuration)
Backend:
-all subscribers view which shows a check under each list the user is a member of and then be able to click their name and edit subscriptions
I have most of the database specific part finished and am just working on the administration and frontend parts.
Here is what I changed about the database:
-In #__newsletter_subscribers I got rid of the name and email fields (because it comes from the #__users database). I also changed id from an auto-increment to correspond with #__user id.
-Now when a new newsletter is created, a new field is added to #__newsletter_subscribers named with the id from #__newsletter_letters, this way all the subscriptions are under one line for eachuser, instead of a new line for each list they are a member of.
Then I just changed the code to use these facts.
Right now the mod is best used on a new site, but if there is enough need I will write a script to transfer existing users into the new database.
Oh yeah, I just thought I would say I have never written in PHP (I mostly know Java for school) or used mySQL, so I am learning a lot on the way. And also, since this changes the database structure, should it be a mod or another component?
-Schmalls |