My MYSQL cherry has been popped! rok on CommentLuv options site


I’ve been too lazy to transfer my holiday photos from my camera since I cam back (because then everyone will crowd around my computer and ooh and ahh at every.single.picture – even the ones of a thumb obscuring the lens) instead though, I have bitten the bullet and finally got around to creating some Mysql tables for the remote script that does the fetching of the last blog post for commentluv plugin users.

What does this mean? ..
it means that I can create a site for people to register their blog url and with that :

  • set a default cache timeout for speedier processing of their comments on blogs that use the plugin.
  • define a default RSS feed url to be used for their domain
    (will also make retrieving a little quicker)
  • define a default link and anchor text to be used
    (useful for pointing to a particular post in the past on comments you make on commentluv sites or if your feed has an error)
  • choose to use default link and anchor text instead of your feeds last entry
    (useful for when you go on a comment campaign)
  • make your last blog post links open in a new window
    (on sites you comment on)

Other things I will be able to do with the upcoming commentluv site now I’m using a database to store data..

  • Show you the last 10 blogs with commentluv that you commented on
  • Show you the last 10 comments with a last blog post made on your blog
  • Show the top 10 blogs that comment on your blog
  • Show the top 10 blogs that you comment on (that have commentluv)
  • Show which blogs have commented on you that you haven’t commented on
    (thanks to Bobby Revellian who requested something to keep a track of which blogs he has commented on and which blogs he needs to comment on. I know it was literally half a year ago bobby but it’s taken me until now to learn enough stuff to make it possible!)
  • probably a lot more…:-)

If there’s more things you’d like to be able to do with commentluv on your blog or features you’d like to see for a commentluv site please leave a comment here and let me know… (btw.. I am using a new version of commentluv on this site that uses the new remote script and database, if you get any issues with comments going funny please let me know on the contact page)

..oh, one more thing… ajax commentluv is a little more improved, it can now work with almost any blog that allows you to edit the header of your theme! .. it’s still a little way off from a release but it seems to be working well … stay tuned!

Blog News, Code, PHP, Wordpress

11 Comments zu “My MYSQL cherry has been popped! rok on CommentLuv options site”

  1. Nicole Price
    29.07.08 5:05 pm

    That is an impressive array of things that you can do with your new gizmo. I can not think of anything else that I would like to suggest. Looking forward to the photos though!

    Nicole Prices last blog post..Free Online Language Resources


  2. Andy Bailey
    29.07.08 6:14 pm

    nicole: they’ll get here.. I’m much more interested in playing with mysql at the moment!


  3. Tim J
    29.07.08 10:38 pm

    I really like the option of:
    “Show which blogs have commented on you that you haven’t commented on”

    I guess my thanks goes out to “Bobby Revellian” (a fellow Armenian?). Keep up the good work Andy!


  4. Susan
    30.07.08 4:41 am

    I love all of the suggestions for the commentluv site – they all sound great! :)

    Susans last blog post..What are Short Sales?


  5. Sharon
    02.08.08 12:12 am

    Andy, sounds so fabulous. I do hope that you also enjoyed your holidays without thinking too much about the extra icing on commentluv…

    Oh, and I still WANT to see the photos. I’d love to take the same cruise you went on someday.

    Sharons last blog post..August Magazines at Newstands Now


  6. My MYSQL cherry has been popped! rok on CommentLuv... [ Fiddyp ]
    02.08.08 12:48 am

    [...] 29th 2008 12:07pm [-] From: [...]


  7. witchypoo
    02.08.08 3:52 pm

    We all have our cherries in some area. MySQL cherry popped about five years ago. I haven’t been the same since.

    witchypoos last blog post..Drinker With a Running Problem


  8. Louise
    07.08.08 4:18 pm

    I’m waiting on pins and needles for the chance to have a default post/anchor text for linking campaigns. CommentLuv has become so integral to my deep linking campaigns that I hold off putting up a new post until I have had a chance to spread it around using CommentLuv. Would love to be able to just post whenever I want and pick the post to use for CommentLuv.

    Louises last blog post..Chocolate Bread Pudding with Bourbon Caramel Sauce Dessert


  9. Andy Bailey
    07.08.08 4:39 pm

    Louise: it’s not long coming! I have successfully got the database storing things like defaut feed and default link and can bring them up for a particular url. Let me get the membership site sorted and working and you’ll be able to do much more too


  10. Harry
    11.12.08 1:22 pm

    It a nice site collecting all info about Cruise.
    I need this information.
    Thanks for your time to post this article.


  11. oprina
    29.04.09 1:51 pm

    ColoredContact Lens can be very scary. You can visit and save yourself a lot of time and pain . Get a lot of good advice on removing your contacts safely and caring for lenses too .