With what you got there, not a hope in hell mate, to be frank!
Your ram would have to be at least 1 gig or more, better graphics card, which in the computer you have probably wouldnt except a card thats capable of playing top games because it would be pci express you need and your computer is more than likely agp which restricts you ALOT
Games these days rely alot on a graphics card, if you pc isnt up to scratch it wont be able to take the lastest hardware, which in turn screws you, obviously!
Take my pc for example, its a 3 year old emachines celeron 2.6ghz, 1gig ram, its lighening quick for sufing the net, playing little online games, downloading etc, but it would never be able to play top games because my motherboard only takes agp cards which are yesterdays news now, and i can probably only get 128mb card and thats no where near the requirments for new games, which i except because i dont game on my machine.
If you REALLY want to play top games AND at a decent frame rate then id surgest getting a new computer

or find out if your pc has agp or pci express, if its pci express then you might be able to get a fairly decent card and upgrade your ram aswell and you can play new-ish games then, but you will never be up there with the big boys, put it that way