rate.php 3.68 KB
Newer Older
1 2 3 4 5 6 7 8
<html>
<head>
  <style type="text/css">
    #slider {
      margin: 10px;
      width: 250px;
      display: inline-block;
    }
David Morley's avatar
David Morley committed
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
    #rating {
      height: 35px;
      width: 35px;
    }
  </style>
  <script>
    $(document).ready(function () {
      $('#addrating').click(function () {
        $('#commentform').show('slow');
        $('#ratings').hide('slow');
      });
      $('#submitrating').click(function () {
        var domain = '<?php echo $_GET['domain']; ?>';
        $.ajax({
          type: 'POST',
          url: 'db/saverating.php',
          data: 'username=' + $('#username').val() + '&userurl=' + $('#userurl').val() + '&comment=' + $('#comment').val() + '&rating=' + $('#rating').val() + '&domain=' + domain,
          success: function (msg) {
            $('#submitrating').unbind('click');
            if (msg == 1) {
              $('#commentform').replaceWith('<h3>Your comment was saved, Thank You!</h3>');
            } else {
              $('#errortext').html(msg);
              $('#error').slideDown(633).delay(2500).slideUp(633);
            }
          }
        });
      });

      $('#slider').slider({
        animate: true, max: 10, min: 1, step: 1, value: 10, stop: function (event, ui) {
          var value = $('#slider').slider('option', 'value');
          $('#rating').prop('value', value)
        }
      });
    });
  </script>
47 48
</head>
<body>
David Morley's avatar
David Morley committed
49
<div style="height:500px;width:900px;">
50 51
  <?php
  require_once __DIR__ . '/config.php';
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
  $dbh = pg_connect("dbname=$pgdb user=$pguser password=$pgpass");
  if (!$dbh) {
    die('Error in connection: ' . pg_last_error());
  }
  if (is_null($_GET['domain'])) {
    die('domain not specified');
  }
  $sql    = "SELECT * FROM rating_comments WHERE domain = $1";
  $result = pg_query_params($dbh, $sql, [$_GET['domain']]);
  if (!$result) {
    die('Error in SQL query: ' . pg_last_error());
  }
  $numrows = pg_num_rows($result);
  echo '<input id="addrating" class="btn primary" style="float:right;margin-right:15px;" type="submit" value="Add a Rating"><h3>Podupti.me ratings for ' . $_GET['domain'] . ' pod</h3><div id="ratings"><hr>';
  if (!$numrows) {
    echo '<b>This pod has no rating yet!</b>';
  }
  while ($row = pg_fetch_array($result)) {
    if ($row['admin'] == 1) {
      echo 'Poduptime Approved Comment - User: <b>' . $row['username'] . '</b> Url: <a href="' . $row['userurl'] . '">' . $row['userurl'] . '</a> Rating: <b>' . $row['rating'] . '</b> <br>';
      echo '<i>' . $row['comment'] . '</i><span class="label" title="id: ' . $row['id'] . '" style="float:right;margin-right:115px;">' . $row['date'] . '</span><hr>';
    } elseif ($row['admin'] == 0) {
      echo 'User Comment - User: <b>' . $row['username'] . '</b> Url: <a href="' . $row['userurl'] . '">' . $row['userurl'] . '</a> Rating: <b>' . $row['rating'] . '</b> <br>';
      echo '<i>' . $row['comment'] . '</i><span class="label" title="id: ' . $row['id'] . '" style="float:right;margin-right:115px;">' . $row['date'] . '</span><hr style="margin-top:0;margin-bottom:15px;">';
    }
dmorley's avatar
cleanup  
dmorley committed
78
  }
79
  echo <<<EOF
David Morley's avatar
David Morley committed
80 81
</div>
<div id="commentform" style="display:none">
dmorley's avatar
cleanup  
dmorley committed
82
Would you like to add a comment?<br>
David Morley's avatar
David Morley committed
83 84 85
Your Name (or Diaspora handle)?<br><input id="username" name="username"><br>
Your Profile URL?<br><input id="userurl" name="userurl"><br>
Comment<br><textarea id="comment" name="comment"></textarea><br>
86
Rating (1-10 scale, 10 high)<br><div id="slider"></div><input class="disabled" disabled="" id="rating" name="rating" value="10">
David Morley's avatar
David Morley committed
87
<br><input class="btn primary" id="submitrating" type="submit" value="Submit your Rating">
David Morley's avatar
David Morley committed
88
<div class="alert-message warning" id="error" style="display:none"><span id="errortext">Some Error</span></div>
89 90 91
</div>
EOF;

92 93 94
  pg_free_result($result);
  pg_close($dbh);
  ?>
root's avatar
root committed
95
</div>