AutoNET/DHCP-D.php at master · toghraee/AutoNET · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
<?php
echo "<html>";
echo "<head>";
echo "<title>AutoNet\\ DCHP Scope Generator</title>";
echo "</head>";
echo "<body bgcolor=#009999 lang=EN-US style='tab-interval:.5in'>";
echo "<P fontsize=15 align=center>";
echo " AutoNet\\ DCHP Scope Generator for FTR </p>";
echo "<br>";


$host="127.0.0.1";
$user="root";
$password="rezasql";
# Connect to MySQL server
$conn = mysql_connect($host,$user,$password)
   or die(mysql_error());
# Select the database
mysql_select_db("", $conn)
   or die(mysql_error());
# Send SQL query
$sql="select bld_newname,new_name, left(new_name,1) as flr, lo , right(lo,1) as my_id";
$sql=$sql." from ftr where ";
$sql=$sql."bld_newname like 'D%'  order by 1";

//    echo "<BR> $sql<BR>";
$result = mysql_query($sql)
or die(mysql_error());

while ($row=mysql_fetch_assoc($result)) {

		$bld=$row['bld_newname'];
		$flr=$row['flr'];
		$new_name=$row['new_name'];
		$lo=$row['lo'];
		$supernet=substr($lo,0,7);
		//$my_id=$row['my_id'];
		//10.111.99.1
		$my_id=substr($lo,10,2);
//		echo "<BR> SubStr is " . substr($bld,0,1) . "!<BR>";
//		echo "<BR> SuperNet is $supernet!<BR>";
//		echo "<BR> MY ID  is $my_id!<BR>";


		if (substr($bld,0,1)=='A')  $type='HOSTEL';
		if (substr($bld,0,1)=='B')  $type='VILLAGE';
		if (substr($bld,0,1)=='C')  $type='ACADEMICS';
		if (substr($bld,0,1)=='E')  $type='LABS';


		/*  Fixing Wireless Controller Domains */
		if (substr($bld,0,2)=='A1') $wlc='a.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='A2') $wlc='a.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='A3') $wlc='a.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='A4') $wlc='a.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='A5') $wlc='a.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='A6') $wlc='a.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='A7') $wlc='a.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='A8') $wlc='a.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='A9') $wlc='a.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='A10') $wlc='a.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='A11') $wlc='a.wlc2.ap..ac.ae';

		if (substr($bld,0,1)=='B') $wlc='b.wlc1.ap..ac.ae';

		if (substr($bld,0,2)=='C1') $wlc='c.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='C5') $wlc='c.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='C4') $wlc='c.wlc3.ap..ac.ae';
		if (substr($bld,0,2)=='C6') $wlc='c.wlc3.ap..ac.ae';


		if (substr($bld,0,2)=='E2') $wlc='e.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='E3') $wlc='e.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='E4') $wlc='e.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='E5') $wlc='e.wlc2.ap..ac.ae';
		if (substr($bld,0,2)=='E6') $wlc='e.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='E7') $wlc='e.wlc2.ap..ac.ae';

		if (substr($bld,0,2)=='D1') $wlc='d.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='D3') $wlc='d.wlc1.ap..ac.ae';
		if (substr($bld,0,2)=='D4') $wlc='d.wlc1.ap..ac.ae';

//		echo "<BR><font color=green size=10> Working on  Building $bld  FTR $new_name  ,  Floor: $flr</font><BR>";
//		echo "<BR>";


//		echo "<BR><B> Wireless AP POOL </B><BR>";
		echo "Dhcp Server 10.90.192.100 add scope ".$supernet.$my_id."1.0  255.255.255.0 B_".$bld."_L$flr-".$type."_AP-MANAGER_FTR$new_name";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."1.0 Add iprange ".$supernet.$my_id."1.11  ".$supernet.$my_id."1.254";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."1.0 set optionvalue 3 IPADDRESS ".$supernet.$my_id."1.1";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."1.0 set optionvalue 51 DWORD 2592000";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."1.0 set optionvalue 6 IPADDRESS 10.90.5.74";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."1.0 set optionvalue 15 STRING $wlc";
		echo "<BR>";
		echo "<BR>";

//		echo "<BR><B> DATA POOL </B><BR>";
		echo "Dhcp Server 10.90.192.100 add scope ".$supernet.$my_id."2.0  255.255.254.0 B_".$bld."_L$flr-".$type."_WIRED_FTR$new_name";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."2.0 Add iprange ".$supernet.$my_id."2.11  ".$supernet.$my_id."3.254";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."2.0 set optionvalue 3 IPADDRESS ".$supernet.$my_id."2.1";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."2.0 set optionvalue 51 DWORD 691200";
		echo "<BR>";
		echo "<BR>";


//		echo "<BR><B> Services POOL </B><BR>";
		echo "Dhcp Server 10.90.192.100 add scope ".$supernet.$my_id."4.0  255.255.255.0 B_".$bld."_L$flr-".$type."_SERVICES_FTR$new_name";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."4.0 Add iprange ".$supernet.$my_id."4.11  ".$supernet.$my_id."4.254";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."4.0 set optionvalue 3 IPADDRESS ".$supernet.$my_id."4.1";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."4.0 set optionvalue 51 DWORD 2592000";
		echo "<BR>";
		echo "<BR>";

//		echo "<BR><B> VOIP POOL </B><BR>";
		echo "Dhcp Server 10.90.192.100 add scope ".$supernet.$my_id."5.0  255.255.255.0 B_".$bld."_L$flr-".$type."_VOIP_FTR$new_name";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."5.0 Add iprange ".$supernet.$my_id."5.11  ".$supernet.$my_id."5.254";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."5.0 set optionvalue 3 IPADDRESS ".$supernet.$my_id."5.1";
		echo "<BR>";
		echo "Dhcp Server 10.90.192.100 Scope ".$supernet.$my_id."5.0 set optionvalue 51 DWORD 2592000";
		echo "<BR>";
		echo "<BR>";


		echo "<BR>";


}// While


?>