Well the issue you have is with DLNA and video streaming and not with network connectivity.
I would recommend downloading the PS3 media server
and see if you turn that on, if your ps3 can see it or not.
Don't mess with the IP address, I don't think you know what your trying to accomplish. If all your computers are on the 192.168.1.x subnet, then everything will work out fine. Leave it on DHCP and don't do static.