Help with upgrading PC

This is my computer:

Motherboard: Intel Rock Lake D865PERL
Motherboard chipset: Intel springdale i865PE
Motherboard bios: AMI
CPU: Pentium 4, 3.00 GHz, 2992MHz
Zalman Quiet CPU cooler
PSU: Tagan TG580-U22 580W ATX2.01
Memory: 768 MB
Graphics: NVIDIA GeForce 6 series
Sound Card: SB Live! Wave Device
OS: Win XP Professional SP2

I want to upgrade it so I can play the Last Remnant whose min requirements are:
processor: Intel Core 2 duo (2GHz) or AMD Athlon X2 (2GHz)
memory: 1.5 GB
video card: NVIDIA GeForce 8600 VRAM 256MB or better
sound card: 100% DirectSound compatible sound card

So I need a new CPU, more RAM, new video card, possibly a new motherboard and sound card?

Can anyone give me suggestions to what to get? And please don't say buy a new computer, I have sentimental attachments to this one and prefer to upgrade even if it ends up being more expensive that way.

Help would be loved.

Yup, thank you.

Eh...That video card is not "very good". It's actually very bad for any sort of gaming.

For a budget gamer, you're going to want at least a 9600GT. I'd suggest an HD4770, it's one of the best budget cards around.

what are you talkin about rewindlabs?
I agree that the gfx card wasn't very good after a second look but that is just one thing. All the other specs are good, i just ried to help using my limited knowledge.

So if you have anything better then suggest it to the OP, not me, this is a thread for advice not commenting in other people.

And we don't need a critical loser who likes to insult people and worsen the situation by starting an argument instead of solving the problem by giving a better suggestion.