Here is a tip for all those who applied the patch and are getting the "Please insert Civilization 3 Disc into the CD Drive" error.
1. Open up your registry
2. Go to HKEY_LOCAL_MACHINE\Software\Infrogrames Interactive\Civilazation III\
3. Find the key CD_PATH
4. Change it to the path of your CD-ROM drive
After waiting on Infrogrames to send me their "Safedisk recovery" patch I decided to do some reg hacking. My CD_PATH key was set to H: and I changed it back to the correct drive letter and it worked
Enjoy
1. Open up your registry
2. Go to HKEY_LOCAL_MACHINE\Software\Infrogrames Interactive\Civilazation III\
3. Find the key CD_PATH
4. Change it to the path of your CD-ROM drive
After waiting on Infrogrames to send me their "Safedisk recovery" patch I decided to do some reg hacking. My CD_PATH key was set to H: and I changed it back to the correct drive letter and it worked

Enjoy