Advertisement
jmginer

SolusVM - Get all IPs of a customer

Sep 23rd, 2015
278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.19 KB | None | 0 0
  1. <?php
  2. $dn = exec("grep -m1 $1: /usr/local/solusvm/includes/solusvm.conf | cut -d ':' -f 1");
  3. $du = exec("grep -m1 $1: /usr/local/solusvm/includes/solusvm.conf | cut -d ':' -f 2");
  4. $dp = exec("grep -m1 $1: /usr/local/solusvm/includes/solusvm.conf | cut -d ':' -f 3");
  5. $dh = exec("grep -m1 $1: /usr/local/solusvm/includes/solusvm.conf | cut -d ':' -f 4");
  6. $ec = exec("grep -m1 $1: /usr/local/solusvm/includes/solusvm.conf | cut -d ':' -f 5");
  7.  
  8. mysql_connect($dh, $du, $dp) or die(mysql_error());
  9. mysql_select_db($dn) or die(mysql_error());
  10.  
  11. // Run your queries here. i.e:
  12.  
  13. $email = $_GET['email'];
  14.  
  15. $result = mysql_query("SELECT clientid FROM clients WHERE emailaddress='$email'");
  16. while ($row = mysql_fetch_array($result)){
  17.     $clientid = $row["clientid"];
  18.     echo "ClientID: $clientid<br>";
  19. }
  20.  
  21. $a = mysql_query("SELECT vserverid FROM vservers WHERE clientid='$clientid'");
  22. while ($row = mysql_fetch_array($a)){
  23.     $vserverid = $row["vserverid"];
  24.     echo "vserverID: ";
  25.     echo $row['vserverid'];
  26.     echo " > ";
  27.    
  28.     $b = mysql_query("SELECT ipaddress FROM ipaddresses WHERE vserverid='$vserverid'");
  29.     while ($row = mysql_fetch_array($b)){
  30.         echo $row['ipaddress'];
  31.         echo ",";
  32.     }
  33.     echo "<br>";
  34. }
  35.  
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement