Hi :) I looked at the spriters resourse, but they didn't have the style of pixel art I wanted.
Also I dont really have the money to buy the art either.
But I am nterested in that tutorial you mentioned, I looked in the forum but didnt find it, could you post a link please?
To be honest, you can't really be picky when looking for 'free' art for something like this. I see a lot of people asking for free stuff but when presented with solutions or resources they say things like "nah, I need something more" or something like that. That luxury is kind of void without either doing it yourself or paying for it.
Unless of course you're fortunate enough to come across an artist that likes what you're working on or just has the time and wants to work with you in creating the art that you would like.
With that said, I think that your best bet would be to look for the 'style' that you want which in your case is Habbo related. You can just gather some reference sprites for the style and then practice trying to recreate them yourself, editing along the way. Animating them will require more time and a little more effort though and finding all of what you asked for for free will be tough and chances are the art might not match up, but I'm sure you can find some nice free assets as placeholders to get your project going.
I would post some links to a few places but I can't post links until 500rep and if you just Google'd a few things the first couple of links would most likely be what I was going to post anyhow.
Search through DeviantArt for Pixel Art tutorials, you will find almost if not all of the information you need to get started on creating your own pixel art and if you want to get a more visual/audio learning experience then there is a pixel art course by CGCookie under the ConceptCookie section. Which I think is the one that you were already linked to.
Try looking at some platformer sprites too when searching on Google instead of just typing RPG because for your battle scenes they should be very usable and using them as reference for your attacks will yield a nicer set of moves and or specials. Just a suggestion for someone new, just getting into it. I hope you find what you're looking for or at least find what you need to be able to make your own!