Just to verify....2 of your own computers (wired and wireless) in your home network will not connect to the router. Your friend's laptop is connecting to your network. All correct?
Both wired and wireless ipconfig /all are showing good connection to the router, something must be blocking.
From your friend's laptop, can pls. try accessing the router's page, please click here http://192.168.0.1
, are you able to access it? If yes, see if there's any MAC filtering setup, remove it if found.