March, 2008 » Archiv


31

Go with the flow joe! New CommentLuv version started

March
30

CommentLuv first flowchart

It seems CommentLuv is enjoying an upsurge of installs again, this usually happens when a big blogger like The Brown Baron, Revellian, Howtospoter or John Cow installs it and gives it a mention so I thought I had better address some (small) issues with it and give it a rewrite.

I’ve sketched out the first draft of the flow chart which is a good reminder in my own mind of how things link together. It’s a chart that will expand further and take up more and more space, from experience I think it will take another 4 or 5 sketches to get the full flow down on paper and then I can take that and refine and expand it to take into account the individual functions and then I can start on the coding proper!

Some things I am going to put in this new version…

  • Options Page
    • Change displayed text under comment area
    • Change styling options for last blog post display
    • Change message for last blog post display
    • Option to use external script for blogs with no curl support
    • Setting for how hard the plugin should look for the feed
    • Setting for enable CommentLuv by default
    • Timeout setting for MAGPIE
  • AJAX support for background fetching during comment entry*
  • Include MAGPIE library in plugin directory**
  • Tidy up WP_OPTIONS function for older versions of CommentLuv

* Use jquery to call the function after the comment author URL field loses focus, this will store the authors feed in the cache so when the user submits the comment, the feed in the cache will be used. This will prevent any hanging around after the comment has been submitted while the plugin searches for the feed location.

** Currently, there are some cases of the default include of MAGPIE saving each and every feed cache to the WP database in WP_OPTIONS/OPTION_NAME which tends to make it grow quite large, also some users have reported it being set to “autoload on” which can have an effect on load times. This wont happen if I use a separate MAGPIE include.

So, that’s it, those are my ideas for the new version of CommentLuv. Do you have any suggestions for things you’d like to see?

Blog News, Blog Tools, Code, PHP, Social Networking


9

The rollover simple comment to win contest…

March
29

Euromillions
Hurrah! another Euromillions rollover which means there’s an easy peasy way for you to win a set of iPod portable speakers just by leaving a comment on this post…(retail value 59.99GBP / 120USD)

Give me your guess for the two lucky star numbers in a comment here and if you guess the two correct numbers between 1 and 9 for this Fridays’ Euromillions draw, you win!

Check out these awesome speakers…

iMaingo Speakers backiMaingo Speakers open

The contest is open to everyone worldwide and finishes on Friday 4th April so get your guesses in now…(you don’t even have to pay for postage)

About Euromillions

A rollover happens quite regularly on the Euromillions and is worth millions of tax free lump sum money!, you’ll have a much better chance to win a prize if you play in a syndicate with elottery because we guarantee that your syndicate will match both lucky star numbers on every single draw!!! Have a browse of my elottery site to see how we can make this promise…

VWD elottery, contests


14

How to extract names and email addresses from your WP database

March
28

I had to do some playing around with my wordpress database when I wanted to move my install from a shared hosting to a dedicated server (which turned out to be quite easy!) and I went in a bit further to phpmyadmin to see what other things I could do.

With the current release of my new contest game, Aqua Craft, I wanted to let everyone that has visited here know about it and rather than wait for every single commenter to come back and see the post, I thought it might be easier to extract the email addresses of all commenters from the database and send them all a message. (luckily, only one person replied saying it was spam!).

I checked my wp_comments table and it had a few thousand entries, yey! I thought. I’ll send them all a message! I extracted the table into a csv file and was disappointed to see literally hundreds and hundreds of spammer email addresses in there…

wp_comments table with spam addresses

Not being a mysql database geek, I did some searching and found a way to extract all the addresses of the commenters that had been approved… here’s how…

1.) Log in to phpmyadmin
2.) select the wp_comments table on the left and click the “browse” button on comment_author_email

phpmyadmin wp_comments table

3.) Click “edit” on the mysql statment at the top of the page and change it to the following

edit mysql statement

SELECT * FROM `wp_comments` WHERE `comment_approved` = ‘1′

That will show you a list of all the comments made that have been approved.

4.) Click on the “export” tab and select these options..

export approved comments

This will give you a large .csv file ready to be opened by Excel

5.) Open the file in excel which will give you this..

raw csv file

This is a lot more than we need, so delete the columns for comment id, comment content etc so you’re left with comment_author, comment_author_email and comment_author_url

6.) Your excel file should look like this…

Fixed csv file

Now there will be a lot of duplicate email addresses from multiple commenters but if you have a decent newsletter or mass email program, you should be able to import this file and let it filter out all the dupes and discard the trackbacks and pings.

Easy peasy! I ended up with a few hundred email addresses who I could tell about my latest contest.. awesome…

Code, PHP, Wordpress


23

CommentLuvvers – Interesting sites that use CommentLuv

March
27

commentluv
Another round of great blogs that use CommentLuv, now there’s even more chance to see CommentLuv blogs because Paul from imafish.co.uk has converted my code into a Drupal version. Nice one Paul!

http://www.kidazy.com/ is a great looking site that provides reviews on toys and games for children age 0 and up. I like what Amy has done with the layout and the attention she gives to each product. Much more than a “whack up a product picture and affiliate” blog. Worth checking out if you have kids (and money!)

http://www.thenetfool.com is an up and coming John Cow/Chow blog with some quite in-depth reviews of marketing and advertising products, see his post on Project Wonderful

http://menstrualpoetry.com/ is a blog that caught my eye because of it’s URL. Menstrual poetry! lol. On further inspection, the blog is definitely one for the ladies with posts such as The truth about prostitution and Voting for Hillary just because she is a woman (which turns out to be a balanced and sensible read..”Feminism is a movement that is based on equality and being granted the same rights and freedoms that men have, so by voting for a woman candidate just because she’s a woman, aren’t we taking a step in the wrong direction?”)

http://www.untwistedvortex.com/ is a fantastically useful site to visit, check out Richards excellent post about how to combat splogs and get your pagerank back after being penalized by google.

http://www.johncow.com/ is a blog I am sure you know, he’s just started using CommentLuv to encourage people to jump from a feed reader to his posts to leave their opinion. Show you care and leave him a (relevant) comment!

Blog News, Reviews, Social Networking


9

Coming soon to a weekend near you…

March
18

Oooo, I have exciting news! what started with a ponder on a wander by the river months ago has turned into something that has kept me up late at night for the past week. You see, I really like to run contests. I like the excitement it causes and I really like the interaction it creates. I want to take it to the next level. Just you wait until you see what I have got in store this weekend!

All I can say now is that real prizes and real money will be available to anyone and everyone who can use a mouse or cursor keys. All you need is a browser and internet connection. Hell, you don’t even need to register to enter. You will even have the chance to win real prizes by giving your own readers something really fun to do while they’re still on your blog, they can win prizes too and here’s the thing… if they win, so do you!

The site is called imgames.co.uk and it’s all ready to rock and roll, I’m just waiting for the nameservers around the globe to catch up with the change and it’ll be all on a dedicated server ready for the weekend. I hope you get a chance to see what I’ve got in store and come and pay a visit here or there on Saturday to see what has made me so red-eyed for the past week!

imgames


16

My O2 customer service story (with happy ending)

March
16

02

7th March 2008
I had an inkling to change my phone from a 35+ quid contract to a Three contract, I talked to the nice chaps at the local 3 store and was all ready to leave o2 and port my number to Three. That was a good idea until I phoned o2 to get my PAC code to transfer the phone number..

I talk to a specialist “retention team member” called Scott who told me his system said I was on an 18 month contract.. grr, all phone companies do this and I know I was out of contract. He did say that he could drop me down a tariff to £30 a month and that still had the same amount of minutes… tick tick BOOM! I exploded! how can I get the same thing for a fiver less, why have I been paying 35 all this time?

lol, I lost it a bit and demanded to speak to customer service so I can get a refund for all the months that I’ve been paying 35 for something that costs 30… A nice lady answered and ‘got to the bottom of it’ and gave me a £10 credit on my next bill (still nowhere near leaving and getting a PAC number).. back I go to the ‘retention team member’ who happens to be Scott again (from t’ north by the sounds of his accent (at least it was a UK accent!)). I tell Scott that the nice girly tells me I’m on a 12 month contract… he looks on his system and says, “nope, yer on an 18 month contract according to this”.

haha, all boom gone, left with quiet seething…

Somehow in my red mist of calm collective, a half an hour of conversation later and suddenly I’m on a new 30 day rolling contract with more minutes that my records show I use and added to that, I’ve got free broadband! all I have to do is leave Bulldog who control my line and go back to BT.. only then can I get the broadband fitted
8-)
it turns out that BT don’t have a record of my number after it was changed to Bulldog;

“there is no record of a phone at that address”

“but I’m talking on it now! there must be”

“no sir, there is no phone connected at your address”

“(sigh)”

As with all customer service places, if you’re not getting what you want, phone again and you get to speak to someone new!

“hi, this is jacky how can I help?”

“I need to come back to BT from bulldog”

“ok, what is the number?”

“it’s ……..”

(a few minutes later)

“Yes we can do that, I just did the test on the line and we will connect you on 11 march”

no line at this address indeed…

A few days later Scott called me up to check if everything was ok.. lol, I was obnoxious as hell on the line last time (as only people that call customer service can know) and to be fair, he stayed calm and polite the whole way through last time and this time I was in a better mood! He tells me he’ll phone me back on the 12th to get the broadband sorted.

11th March 2008

Existing broadband goes off! halfway through a download… no matter though, I used my PAYG Three skype phone as a USB modem and had a decent enough connection to doofernow.

12th March 2008
New line is back to BT. I call up o2 to see if I can speak to Scott so I can get the ball rolling as soon as possible. He was busy so I talked to a barry white soundalike who was able to read what had gone on before and within a few minutes told me my order was under way. yey! now the horrid wait for the actual connection to happen. will it be quick? will it take a bleedin age like that time once way back?

Text messages galore from o2.. your username is this, your details are that etc…. your router has been dispatched…

14th March 2008
Router arrives! yey! I check the DSL status on my current router and it doesn’t show anything, boohoo. It was too much to wish for anyway

15th March 2008
I noticed the dsl status lights were doing something when I got up but I was too busy this Saturday and I promptly forgot about it

16th March 2008
Sitting at my PC browsing at not super broadband speeds (but still not horrendously bad like the stone age of dialup) I suddenly remembered to check the line again. Lo and behold, a dsl line exists, it’s trained and it’s clocking in at a supposed 10MB

I didn’t have a BB access username so I phoned customer service (after office hours) and was quickly told that I should use my o2 router first because the access doesn’t need a username.

clunk click – bloody quick!!

sorted with Broadband for free. I did a few small tests and was able to get a stable 1.6mb/s for some things and a 60kb upload speed. did I mention, for free? lol. I drop £20 a month off my mobile phone bill, I go to a 30 day rolling contract so I am not tied in. My previous broadband and phone bill of £37 a month gets replaced by one for 0.00 and a tenner for BT .hahahaha.

All because I wanted to leave my mobile phone company and migrate to another. Thanks to the quick wits of Scott and his Jedi mind trick training from o2, I am saving nearly 600 quid a year and have actually got a faster fatter internet!

My advice is to phone your mobile phone carrier and tell them you want to leave, you see how many hoops they’ll jump through to keep you in!

Blog News


2

Important additions to uVme – oh yeah

March
14

Some major additions to uVme have been made recently! There are now two more payment options for players to add to their playing account – Paypal and Netteller. This should make things a lot easier for those wanting to wager on games when they get good enough (or sending a challange to FiddyP and beating me!)

Another great thing is, you can now challenge for free. Signup to the site for free and you can send challenges to me or other folk you know by searching for their name on the pre-game screen and then send a challenge worth 0.00 .

If you haven’t seen it yet and you enjoy playing games, register for free by clicking the image on my imgames site and choose any game, once you see the game preview page you can select to play for free or put FiddyP in the search box and challenge me to a free game. (be gentle with me!)

I have some fantastic plans for imgames that are so nearly ready for action, I have the coding mostly done and the support site nearly ready. All that will be left will be the launch! (this is still top secret! I’ve pumped some serious cash into these plans, you are going to be blown away when you see it! there’s going to be prizes galore for readers here and a chance for you to get something for you and your own readers)

Subscribe to the Fiddyp feed and be the first to find out what’s in store for Fiddyp and imgames

Blog News, Making / Made Money, Social Networking, contests, uVme - Social Marketing


12

OMG I just formatted my server!

March
11

I can’t believe what I just did….. I mistakenly restored an old backup of fiddyp… grrrrr.

I have just moved to a dedicated server and its really helped the load times, I got everything working and then did a backup. “sweet” thought I…. let’s set up a scheduled backup… two wrong clicks later and I realise that it’s restoring the old back up. dammnit all to hell on a bicycle!!!!

Luckily, I managed to retrieve the last two posts I made by copying the source of the feed in google feedreader, amazingly, that still held the last two posts I made. Shame I missed the comments though, I’ll have to see if I can find a list of the entries of the Euromillions rollover contest in a history somewhere and get it from offline mode….

silly silly me!

edit: I just realised that I can reconstruct the comments from my email notifications. I just got all the entries back on the euromillions contest post from a page view in the history, i’ll put the remainder up when I get over my heart attack!

newedit: I tried to change this hosting to exclusive IP on a dedicated server and I lost another couple of comments (sorry Sharon). I have had the most frustrating day playing with this server. I feel an indepth rant coming!….

even newer edit: I think I’m changing too many things and not giving it time to work! I am now going to leave the nameservers as they are, leave the IP of the hosting the same and just sit back and wait for a few days for everything to settle. sorry for any interuptions to normal service.. I’m trying to get everything up and secure on a fast host so I can get my new plans in to gear and not worry about bandwidth affecting download times and other schtuff..

seeya soon!

Blog News


26

CommentLuvvers – Interesting sites that use CommentLuv

March
11

commentluv here
I keep a track of who installs commentluv by monitoring pings that come in to the plugin page when a new blog activates CommentLuv. I do try and make a comment on each one but some slip through the net due to immense workloads that take priority.
I am taking a bit of advice from Revellian about blogging karma and having a regular spot for linking out to blogs I have seen. What better way to promote CommentLuv and reward those that use it?

The first blog on this list will be Kens Trees, he has a photo blog about his effort to grow bonsai trees from seed. This looks like a blog that has some longevity, it takes bloody ages for a tree to grow so I hope that Ken will keep his blog going for some time while he documents how Willard the Dawn Redwood grows.

Another blog I know you will enjoy is Stephen Hopsons blog, he’s a qualified deaf pilot! Among his posts are some real thought provokers like this one about not giving when you know you should

A great Philippino blog to check out is BendzG, a blog for juicy oriental gossip and much more besides! It’s great to see CommentLuv being used on so many international blogs!

If you have a blog that uses CommentLuv and want a mention, leave me a comment somewhere on any of my posts and I’ll give you a mention in the next CommentLuvvers post. If you want to see more blogs that use CommentLuv, be sure to check the sidebar for the latest people to activate the plugin.

Blog News


10

New Contest runs until Friday for Euromillions Rollover

March
11

Euromillions

edit: contest is over, the lucky star numbers were 4 and 8. no one won this time! keep coming back whenever you hear there is a euromillions rollover because I run this contest for every one!

Due to the Euromillions rollover there’s a chance for you to win these great headphones from Vmoda.
Bass Frequency Headphones

Just leave a comment with your guess for the lucky star numbers to be revealed this Friday 14th March. You need to give two different numbers between 1 and 9. If you match your guess with the lucky star numbers drawn on the Euromillions then you win!

Good Luck!

p.s.There’s a way you can be guaranteed to match both lucky stars on the Euromillions draw, it’s called elottery and I win a prize every week because I’m a member (who happens to get extra entries just for being a good affiliate!)

p.p.s This is a regular contest for whenever there is a rollover on the Euromillions. Subscribe to my feed and keep up to date on all the contests happening at Fiddyp!

VWD elottery, contests