Hmm you can try to buy a new one. This method works perfectly !
That said, you can try :
As your drive is not detected in bios, put a working one in Secondary Master (That is port Number 3) Just before using Mtkflash, swap the working one with the dead one (sorry really) and pray and launch Mtkflash.
You can also try other ide port. Don’t forget to put your drive’s jumper into correct position (Not cable Select, either Master or slave)
Double check the version on Mtkflash too, you must use the correct version as some earlier versions didn’t worked with dvd writer.
Hmm did I mention that you can also buy another one, it’s a fair solution, you’ve played and you’ve lost (well try the above methods first)