just updated pi-hole, and saw that DHCP server allows for DHCP with assignement of static IP address to specific MAC address (and give same IP to multiple MAC addresses, hich is cool for who has extenders in the network sincer they give virtual MAC addressses to devices, and that can cause problems).
My problem is that I have lots of devices, like 150, and I like to have all static IP address, is it possible to give a file, instead of punching them one by one in the front end?
This is already possible, although not from the web interface. I suggest you create some few reservations on the web interface and open the file /etc/dnsmasq.d/04-pihole-static-dhcp.conf in your favorite editor, afterwards.
You can put in the allocations in the shown format here. It may be that you have to restart the DHCP server afterwards,
My QNAP has two MAC address
My TV (also notebook and so on) has Ethrnet and Wifi (I would rather have one IP address because either connects Ethernet OR Wifi)
A DHCP server gives out addresses to devices that don't have a static address.
A DHCP server has a range of addresses that it is permitted to hand out to devices. You can make the range however small you want, but I believe that the range can be limited to how large it can be.
Static IP addresses do not need to be within the DHCP range.
You could have a range of 192.168.1.105 to 192.168.1.160. Then use The static IP address of a home server as 192.168.1.100.
There are two ways to set a static IP address.
Manually on the device itself
Via the DHCP server.
If you want the same IP, I would set it manually on your computer, and make sure you always switch wifi off when you use ethernet. I don't think you can have it switch automatically.