My only advice is if you are making a strategy game like StarCraft...play StarCraft while making it. If you are making Diblo style RPG , play Diablo. Playing games (similar to what you want to make) can give you ideas and motivation to continue your project.
And be patient. When something doesnt work , leave it in the forums with a question for 1-2 days and someone will help you fix it.(I often abandon projects because I get to a point where I can not continue alone,but thats mainly a modeling issue(lack of animations in free models))

PS.: I also abandon projects because of no motivation. I just cant play games on my computer(because of some stupid thermal control,it shuts down my computer) but the ideas keep flowing
And , btw , music is the perfect motivation ("muse").I like the sound tracks from WoW , Unreal Tournament and The I of the dragon , and my winamp never stops playing them. This leads to imagination and motivation to continue something (In my case,to see the game I wanned to create created , without bothering will I publish it or will someone else see it ever!)