GLEEEEEEEE!!
Because I can do some plugging even on vacations!!
the TFL fanlisting for the TV series, GLEE.
Integrating phpBB and phpList
I've been procrastinating on a project because I was waiting for someone to finally make a modification for phpBB that would automatically subscribe a user to a phpList newsletter. I couldn't wait anymore so I just went ahead and did some tinkering around. Please be warned that this is a rough hack and isn't validated by the phpBB mod team.
This hack works for phpList 2.10.10 and phpBB 3.0.5.
Download this file and rename it to functions_phplist.php. If you edit the file with notepad or any text editor, you would find this part:
$database_host = "localhost"; $database_name = "database"; $database_user = "username"; $database_password = "password"; $table_prefix = "phplist_"; $usertable_prefix = "phplist_user_";
Fill those in with your phpList credentials which you could get from your phpList config.php file. I didn't want to include the phpList file as there might be global variables that could be overwritten. That's the only thing you have to alter in that file. After editing it, upload it to the /includes folder inside your phpBB folder.
Now to integrate that function into phpBB core, you have to edit the /includes/ucp/ucp_register.php file in your phpBB folder. Look for these lines:
$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
trigger_error($message);
and insert the following lines before it:
//Include phplist functions include($phpbb_root_path . 'includes/functions_phplist.' . $phpEx); //Subscribe user to phplist $phplist_user_id = phplist_subscribeuser($data['email'], 1);
Notice the "1" in that last line? Change that to the id of the newsletter you want your users to be subscribed to. You could get that from your phpList admin page. After editing, upload it to your server overwriting the original ucp_register.php file. And that's it!
Once a user registers in your forums, they will be automatically subscribed to your newsletter as well. But take note that this is very limited. For one, it won't send a welcome message to the user's email. Also, the subscribing process happens during registration. If you have validation of email addresses in your boards and you want the subscribing process to occur once a user validates his/her email address, you will have to tinker with a different file instead of ucp_register.php. Maybe ucp_activate.php, I'm not sure since I didn't tinker with anything else. Also, since I didn't provide the user with an unsubscribe option in their profile, they can only unsubscribe to the newsletter via phpList's unsubscribe page.
Now, if you already have users in your boards and want to import them to your phpList newsletter, save this file as a php file and edit these lines to reflect the paths to your phpBB and phpList config files.
require("/path/to/phplist/config/config.php");
and
require("/path/to/phpbb/config.php");
Then find this line
phplist_subscribeuser($row['user_email'], 1);
and replace "1" with the id of the newsletter you want your users to be subscribed to. Upload the file to your server and access it via your browser and wait for the script to finish running. When I imported 16,000 users it roughly took me less than 5 minutes to finish.
That's it. Feel free to tinker it to your heart's content. I just wanted to share this because making this work gave me a headache.
Fall TV Season
Months have come and by and haven't really blogged.
It's almost the end of August already. September is so near. You know what that means? New fall season on TV! OMG! I'm looking forward to a lot of stuff.
First and foremost, of course. Supernatural's fifth season. Season four was so-so for me. Unlike other fans, I wasn't really that hooked with the angels storyline. Castiel was okay in my book but Anna bothered the heck out of me. I loved Katie!Ruby from season 3 and Gen!Ruby irked me with her blase acting. But I still liked the season four ender. Kripke always delivers his season openers and enders. And that's why I'm looking forward to season five. Supernatural is just supposed to run for five seasons and that's fine with me. I'm scared that if Kripke extends this it might end like Smallville, dragging everything through filth and then it ends up being a fucked up series. But whatever happens, Kripke, please end it with a big bang.
Two other series that I'm looking forward too (maybe even more than Supernatural) is GLEE and Merlin season two. I was able to watch both the director's cut and the preview of GLEE. The director's cut was more cohesive than the preview. And I love it from the very start when they were performing That's the Way I Like It. The director's cut numerous VOs made me like it better than the preview. I think that added to my love for this series too. And also of course the music and songs and choreography. XD Oh and Cory. ♥
As for Merlin, I was and still am waiting for season two since December last year! OMG! That's such a long wait! I mean, I know that there's a season two for it but why won't they give a specific official date?! Even it's return on September isn't really official yet since I haven't read it anywhere but from several fan places only. I want my Arthur already. And Merlin. And their cheesy and slashy goodness.
I marathoned Law & Order: Special Victims Unit last summer. Yes, all ten seasons within three weeks. And now that's added to my current watch list too. I started it since I am obsessed with J.D. Robb's In Death series and Olivia reminded me of Eve so much. But as the seasons went on, I started to really like this series a lot. I'm glad that Mariska Hargitay and Chris Meloni's back for season eleven because I don't know if my love for Munch will make me watch this series if Olivia and Stabler won't be back.
Now the other series I'm also placing in my to-be-watched list: Fringe, How I Met Your Mother, Survivor and The Amazing Race. I wanna add Chuck to it too but won't it be back mid-season.. so that's like sometime January next year? I'm definitely not adding Heroes already, haven't been watching that for a little less than a season now. I'm on the fence if I should still watch Gossip Girl but haven't also touched that too for half a season. The same for Dollhouse, haven't watched the season ender and the unaired pilot. So what I have isn't really a long list for now , but more than likely it'll grow as I add some of the series that'll premiere. I wanna try Vampire Diaries because of Somerhalder so I'll definitely be watching the premiere for that but I don't know if he could make me watch the whole season. As for the shows that are already airing, I only have one and that's Psych. And yes, it is still hilarious.
With my current list, I think I have almost a series or two to watch almost all the days of the week. That's good for me. :D