add.php 3.8 KB
Newer Older
1
<!-- /* Copyright (c) 2011, David Morley. This file is licensed under the Affero General Public License version 3 or later. See the COPYRIGHT file. */ -->
David Morley's avatar
David Morley committed
2
<?php
3
$valid=0;
dmorley's avatar
cleanup  
dmorley committed
4 5
include('config.php');
include('../logging.php');
dmorley's avatar
dmorley committed
6 7
$log = new Logging();
$log->lfile($log_dir."/add.php.log");
8
if (!$_POST['url']){
dmorley's avatar
dmorley committed
9
  echo "no url given";$log->lwrite('no url given '.$_POST['domain']);
dmorley's avatar
cleanup  
dmorley committed
10
  die;
11 12
}
if (!$_POST['email']){
dmorley's avatar
dmorley committed
13
  echo "no email given";$log->lwrite('no email given '.$_POST['domain']);
dmorley's avatar
cleanup  
dmorley committed
14
  die;
15 16
}
if (!$_POST['domain']){
dmorley's avatar
dmorley committed
17
  echo "no pod domain given";$log->lwrite('no domain given '.$_POST['domain']);
dmorley's avatar
cleanup  
dmorley committed
18
  die;
19 20
}
if (!$_POST['url']){
dmorley's avatar
dmorley committed
21
  echo "no API key for your stats";$log->lwrite('no api given '.$_POST['domain']);
dmorley's avatar
cleanup  
dmorley committed
22
  die;
23 24
}
if (strlen($_POST['url']) < 14){
dmorley's avatar
dmorley committed
25
  echo "API key bad needs to be like m58978-80abdb799f6ccf15e3e3787ee";$log->lwrite('api key too short '.$_POST['domain']);
dmorley's avatar
cleanup  
dmorley committed
26
  die;
27
}
dmorley's avatar
cleanup  
dmorley committed
28 29 30
$dbh = pg_connect("dbname=$pgdb user=$pguser password=$pgpass");
if (!$dbh) {
  die("Error in connection: " . pg_last_error());
31
}
dmorley's avatar
cleanup  
dmorley committed
32 33 34 35 36 37 38 39 40 41 42 43
$sql = "SELECT domain,pingdomurl FROM pods";
$result = pg_query($dbh, $sql);
if (!$result) {
  die("Error in SQL query: " . pg_last_error());
}
while ($row = pg_fetch_array($result)) {
  if ($row["domain"] == $_POST['domain']) {
    echo "domain already exists";$log->lwrite('domain already exists '.$_POST['domain']);die;
  }
  if ($row["pingdomurl"] == $_POST['url']) {
    echo "API key already exists";$log->lwrite('API key already exists '.$_POST['domain']);die;
  }
44 45
}

dmorley's avatar
cleanup  
dmorley committed
46 47 48 49 50 51 52 53 54 55
//curl the header of pod with and without https
$chss = curl_init();
curl_setopt($chss, CURLOPT_URL, "https://".$_POST['domain']."/nodeinfo/1.0");
curl_setopt($chss, CURLOPT_POST, 0);
curl_setopt($chss, CURLOPT_HEADER, 0);
curl_setopt($chss, CURLOPT_CONNECTTIMEOUT, 5);
curl_setopt($chss, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($chss, CURLOPT_NOBODY, 0);
$outputssl = curl_exec($chss);
curl_close($chss);
56

dmorley's avatar
cleanup  
dmorley committed
57 58 59 60 61 62 63 64 65
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://".$_POST['domain']."/nodeinfo/1.0");
curl_setopt($ch, CURLOPT_POST, 0);
curl_setopt($ch, CURLOPT_HEADER, 0);
curl_setopt($ch, CURLOPT_CONNECTTIMEOUT, 5);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_NOBODY, 0);
$output = curl_exec($ch);
curl_close($ch);
66

67
if (stristr($outputssl, 'nodeName')) {
dmorley's avatar
dmorley committed
68
  echo "Your pod has ssl and is valid<br>";$log->lwrite('Your pod has ssl and is valid '.$_POST['domain']);
69 70
  $valid=1;
}
71
if (stristr($output, 'nodeName')) {
dmorley's avatar
dmorley committed
72
  echo "Your pod does not have ssl but is a valid pod<br>";$log->lwrite('Your pod does not have ssl but is a valid pod '.$_POST['domain']);
73 74 75
  $valid=1;
}
if ($valid=="1") {    
dmorley's avatar
cleanup  
dmorley committed
76 77 78 79 80 81 82 83 84 85 86 87
  $sql = "INSERT INTO pods (domain, pingdomurl, email) VALUES($1, $2, $3)";
  $result = pg_query_params($dbh, $sql, array($_POST['domain'], $_POST['url'], $_POST['email']));
  if (!$result) {
    die("Error in SQL query: " . pg_last_error());
  }
  $to = $adminemail;
  $cc = $_POST["email"];
  $subject = "New pod added to podupti.me ";
  $message.= "https://podupti.me\n\n Stats Url: https://api.uptimerobot.com/getMonitors?format=json&customUptimeRatio=7-30-60-90&apiKey=" . $_POST["url"] . "\n\n Pod: https://podupti.me/db/pull.php?debug=1&domain=" . $_POST["domain"] . "\n\n";
  $message.= "Your pod will not show right away, needs to pass a few checks, Give it a few hours!";
  $headers = "From: ".$_POST["email"]."\r\nReply-To: ".$_POST["email"]."\r\nCc: " . $_POST["email"] . "\r\n";
  @mail( $to, $subject, $message, $headers );    
88

dmorley's avatar
cleanup  
dmorley committed
89
  echo "Data successfully inserted! Your pod will be reviewed and live on the list in a few hours!";
90
    
dmorley's avatar
cleanup  
dmorley committed
91
  pg_free_result($result);
92
    
dmorley's avatar
cleanup  
dmorley committed
93
  pg_close($dbh);
94
} else {
dmorley's avatar
cleanup  
dmorley committed
95
  echo "Could not validate your pod on http or https, check your setup!<br>Take a look at <a href='https://".$_POST['domain']."/nodeinfo/1.0'>your /nodeinfo</a>";$log->lwrite('Could not validate your pod on http or https, check your setup! '.$_POST['domain']);
96
}
dmorley's avatar
dmorley committed
97
$log->lclose();
98
?>