rate.php 3.7 KB
Newer Older
1 2
<?php
$_GET['domain'] || die('domain not specified');
noplanman's avatar
noplanman committed
3
$domain = $_GET['domain'];
4
?>
5 6 7 8 9 10 11 12
<html>
<head>
  <style type="text/css">
    #slider {
      margin: 10px;
      width: 250px;
      display: inline-block;
    }
David Morley's avatar
David Morley committed
13

14 15 16 17 18 19 20 21 22 23 24 25
    #rating {
      height: 35px;
      width: 35px;
    }
  </style>
  <script>
    $(document).ready(function () {
      $('#addrating').click(function () {
        $('#commentform').show('slow');
        $('#ratings').hide('slow');
      });
      $('#submitrating').click(function () {
noplanman's avatar
noplanman committed
26
        var domain = '<?php echo $domain; ?>';
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
        $.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>
51 52
</head>
<body>
David Morley's avatar
David Morley committed
53
<div style="height:500px;width:900px;">
54 55
  <?php
  require_once __DIR__ . '/config.php';
56

57
  $dbh = pg_connect("dbname=$pgdb user=$pguser password=$pgpass");
58 59
  $dbh || die('Error in connection: ' . pg_last_error());

60
  $sql    = "SELECT * FROM rating_comments WHERE domain = $1";
noplanman's avatar
noplanman committed
61
  $result = pg_query_params($dbh, $sql, [$domain]);
62 63
  $result || die('Error in SQL query: ' . pg_last_error());

64
  $numrows = pg_num_rows($result);
noplanman's avatar
noplanman committed
65
  echo '<input id="addrating" class="btn primary" style="float:right;margin-right:15px;" type="submit" value="Add a Rating"><h3>Podupti.me ratings for ' . $domain . ' pod</h3><div id="ratings"><hr>';
66 67 68 69
  if (!$numrows) {
    echo '<b>This pod has no rating yet!</b>';
  }
  while ($row = pg_fetch_array($result)) {
noplanman's avatar
noplanman committed
70
    if ($row['admin'] === '1') {
71 72
      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>';
noplanman's avatar
noplanman committed
73
    } elseif ($row['admin'] === '0') {
74 75 76
      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
77
  }
noplanman's avatar
noplanman committed
78
  ?>
David Morley's avatar
David Morley committed
79 80
</div>
<div id="commentform" style="display:none">
noplanman's avatar
noplanman committed
81 82 83 84 85 86 87 88 89 90 91
  Would you like to add a comment?<br>
  <label>Your Name (or Diaspora handle)?<br><input id="username" name="username"></label><br>
  <label>Your Profile URL?<br><input id="userurl" name="userurl"></label><br>
  <label>Comment<br><textarea id="comment" name="comment"></textarea></label><br>
  Rating (1-10 scale, 10 high)<br>
  <div id="slider"></div>
  <input class="disabled" disabled="" id="rating" name="rating" value="10"><br>
  <input class="btn primary" id="submitrating" type="submit" value="Submit your Rating">
  <div class="alert-message warning" id="error" style="display:none">
    <span id="errortext">Some Error</span>
  </div>
root's avatar
root committed
92
</div>
noplanman's avatar
noplanman committed
93 94 95
<?php
pg_free_result($result);
pg_close($dbh);