#!/bin/sh
# Poznamky a informace:
# Konfiguracni soubor dhcp serveru.
# Cesta k daemonu dhcp serveru:  /etc/int.d/dhcpd

# Synchronizace dns:
ddns-update-style none;

# Priorita v siti:
authoritative;

ddns-update-style ad-hoc;
server-identifier 192.168.1.1;

# Nazev domeny:
option domain-name "INTR";

# Adresa routeru:
option routers 192.168.1.1;

# Nastaveni dns serveru:
option domain-name-servers 82.99.136.18, 81.0.237.227;

# Maska site:
option subnet-mask 255.255.255.0;

# Adresa broadcastu:
option broadcast-address 192.168.1.255;
# Podsit-maska:
subnet 192.168.1.0 netmask 255.255.255.0
    {
        deny unknown-clients;
        range 192.168.1.3 192.168.1.130;
    }

# Pridelena ip:
host dataserver         {hardware ethernet 00:30:4f:3c:eb:8a; fixed-address 192.168.1.2;}       #408



DB_USER="root"
DB_PASS="dm"
DB_HOST="localhost"
DATABASE="intr"
TABULKA="uzivatele"
MYSQL="mysql -h$DB_HOST -N -u$DB_USER -p$DB_PASS -D $DATABASE"

RADKU=$($MYSQL <<< "SELECT COUNT(*) AS id FROM $TABULKA")

for i in `seq 1 $RADKU`
do
   ID=$($MYSQL <<< "SELECT id FROM $TABULKA WHERE id=$i")
   IP=$($MYSQL <<< "SELECT ip FROM $TABULKA WHERE id=$i")
   MAC=$($MYSQL <<< "SELECT mac FROM $TABULKA WHERE id=$i")
   JMENO=$($MYSQL <<< "SELECT jmeno FROM $TABULKA WHERE id=$i")

   host $JMENO {hardware ethernet $MAC; fixed-address $IP;}       #408
done