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
|
<?php
global $pro_mysql_raduser_table;
global $pro_mysql_dedicated_table;
if(isset($_REQUEST["action"]) && ($_REQUEST["action"] == "set_dedicated_ip_rdns")){
checkLoginPass($adm_login,$adm_pass);
if(!isIP($_REQUEST["ip_addr"])){
$submit_err = _("This is not a correct IP line ") .__LINE__. _(" file ") .__FILE__;
}else{
if(!isHostnameOrIP($_REQUEST["rdns"])){
$submit_err = _("This is not a correct hostname or IP line ") .__LINE__. _(" file ") .__FILE__;
}else{
$q = "SELECT $pro_mysql_dedicated_ips_table.ip_addr
FROM $pro_mysql_dedicated_ips_table,$pro_mysql_dedicated_table
WHERE $pro_mysql_dedicated_ips_table.ip_addr='".$_REQUEST["ip_addr"]."'
AND $pro_mysql_dedicated_ips_table.dedicated_server_hostname=$pro_mysql_dedicated_table.server_hostname
AND $pro_mysql_dedicated_table.owner='".$adm_login."';";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
$n = mysql_num_rows($r);
if($n != 1){
$submit_err = _("This IP doesn't belong to you - cannot change RDNS entry.");
}else{
$q = "UPDATE $pro_mysql_dedicated_ips_table SET rdns_addr='".$_REQUEST["rdns"]."',rdns_regen='yes' WHERE ip_addr='".$_REQUEST["ip_addr"]."';";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
updateUsingCron("gen_named='yes',reload_named='yes'");
$q = "SELECT $pro_mysql_ip_pool_table.zone_type
FROM $pro_mysql_dedicated_ips_table,$pro_mysql_ip_pool_table
WHERE $pro_mysql_dedicated_ips_table.ip_addr='".$_REQUEST["ip_addr"]."'
AND $pro_mysql_ip_pool_table.id=$pro_mysql_dedicated_ips_table.ip_pool_id;";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
$n = mysql_num_rows($r);
if($n != 1){
$submit_err = _("Could not find the corresponding IP pool");
}else{
$a = mysql_fetch_array($r);
if($a["zone_type"] == "support_ticket"){
$submit_err = _("This IP pool can't be changed automatically, because our upstream network provider doesn't support it. Please open a support ticket to request this RDNS request.");
}
}
}
}
}
}
if(isset($_REQUEST["action"]) && ($_REQUEST["action"] == "set_radius_user")){
checkLoginPass($adm_login,$adm_pass);
if (!isRandomNum($_REQUEST["dedicated_id"])){
$submit_err = _("The dedicated server parameter is not correct.");
}else{
if(!is_string($_REQUEST["radius_user"])){
$submit_err = _("The Radius Username is not correct.");
}else{
if(!is_string($_REQUEST["radius_password"])){
$submit_err = _("The Radius Password is not correct.");
}else{
$q = "SELECT * from $pro_mysql_dedicated_table where id='".$_REQUEST["dedicated_id"]."' and owner='".$_REQUEST["adm_login"]."';";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
$n = mysql_num_rows($r);
if($n != 1){
$submit_err = _("The Dedicated Server is not owned by you or don't have an already assigned Radius User.");
}else{
$dedicated = mysql_fetch_array($r);
$q = "SELECT * FROM $pro_mysql_raduser_table WHERE dedicated_id='".$dedicated["id"]."';";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
$n = mysql_num_rows($r);
if($n != 1){
$q = "INSERT INTO $pro_mysql_raduser_table (dedicated_id) VALUES ('".$dedicated["id"]."');";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
}
$q = "UPDATE $pro_mysql_raduser_table SET UserName ='".$_REQUEST["radius_user"]."',Password='".$_REQUEST["radius_password"]."' WHERE dedicated_id='".$dedicated["id"]."';";
$r = mysql_query($q)or die("Cannot query $q line ".__LINE__." file ".__FILE__." sql said: ".mysql_error());
}
}
}
}
}
?>
|
