You need a new motherboard which can support a modern GPU which will require you to move to atleast DDR2 RAM and a new CPU. If you have about 400 to spend on the upgrade you can get a decent system out of it but the only parts you should keep are your optical drive, hard drive, and maybe your case.
I suggest if you are flat broke to just buy a new board that does feature at least a agp slot while a few but very rare 478 boards do feature a pci-e slot but regardless you are going to get very poor performance. If you got the pockets its time to upgrade.
Buddy, sorry for the bad news, but you ain't gonna be able to play the above games on your current setup! The processor "MAY" be able to struggle through, but you GPU and RAM definitely need to be upgraded....which means upgrading the bobo as well! Oh, and don't forget, a new PSU to power the GPU. Your RAM will have to be minimum DDR2 (3 recommended). GPU, at least the nVidia 9800GT/ Radeon 5750