Hmm given that wired and some devices work I'd direct my troubleshooting at the affected PCs. Check that the IP configuration is sane on both the router and affected PCs.
E.g. running ipconfig on Windows or ifconfig on Linux should give:
Code:
Connection-specific DNS Suffix . : <should match the PCs where Internet works>
Link-local IPv6 Address . . . . . : <don't worry about this one>
IPv4 Address. . . . . . . . . . . : <same IP as in the Router's DHCP page>
Subnet Mask . . . . . . . . . . . : <should match the PCs where Internet works>
Default Gateway . . . . . . . . . : <router's IP>
Also reboot (or power cycle) the router, modem, and affected PCs for good measure. If something's still wrong, make sure you don't have any overzealous access control (e.g. parental control or other), and that the computers don't have messed up network adaptor or custom DNS settings, VPN client / Hamachi, or virtual network adaptor messing with how the Internet connection is detected.
Edit: A good way to test this is to take one of the USB adaptors from a PC that "doesn't work" and test whether it can get a connection in one of your laptops that "does work". Preferably do this with the laptop in the same room as the "doesn't work" computer in case interference plays a role.
Try copy-pasting a giant video (several gigabytes) to one of the affected PCs and see if the USB wireless adaptor or drivers chokes. As an example I had an old D-LINK USB adaptor which would trigger a BSOD after about 3-4 GB of transfer.