rate.php 3.35 KB
Newer Older
1 2 3 4 5 6 7
<html><head>
  <style type="text/css">
    #slider { margin: 10px;width:250px;display:inline-block; }
    #rating { height: 30px;width:30px; }
  </style>
  <script>
  $(document).ready(function() {
David Morley's avatar
David Morley committed
8 9 10 11
  $('#addrating').click(function() {
    $('#commentform').show('slow'); $('#ratings').hide('slow');
  });
$('#submitrating').click(function() {
dmorley's avatar
cleanup  
dmorley committed
12

David Morley's avatar
David Morley committed
13 14 15 16 17
<?php
echo "var domain = \"{$_GET['domain']}\";";
?>
$.ajax({
   type: "POST",
root's avatar
root committed
18
   url: "db/saverating.php",
David Morley's avatar
David Morley committed
19 20
   data: "username="+$('#username').val()+"&userurl="+$('#userurl').val()+"&comment="+$('#comment').val()+"&rating="+$('#rating').val()+"&domain="+domain,
   success: function(msg){
dmorley's avatar
cleanup  
dmorley committed
21
          $('#submitrating').unbind('click');
David Morley's avatar
David Morley committed
22 23 24 25 26 27 28
          if (msg == 1) {
	 $("#commentform").replaceWith("<h3>Your comment was saved, Thank You!</h3>");
   } else {$('#errortext').html(msg);$('#error').slideDown(633).delay(2500).slideUp(633);} 
          }
 });
});

29 30 31 32 33 34 35 36 37
    $("#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>
</head>
<body>
David Morley's avatar
David Morley committed
38
<div style="height:500px;width:900px;">
39
<?php
40 41 42 43 44 45 46 47 48 49 50 51 52 53
 include('db/config.php');
 $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, array($_GET['domain']));
 if (!$result) {
     die("Error in SQL query: " . pg_last_error());
 }   
 $numrows = pg_num_rows($result); 
David Morley's avatar
David Morley committed
54
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 (beta feature)</h3><div id='ratings'><hr>"; 
55
if (!$numrows) {echo "<b>This pod has no rating yet!</b>";}
56 57 58 59 60 61 62 63
 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;'>";
 }
64 65
}
echo <<<EOF
David Morley's avatar
David Morley committed
66 67
</div>
<div id="commentform" style="display:none">
68
Would you like to add a comment? (diaspora login comming)<br>
David Morley's avatar
David Morley committed
69 70 71
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>
72
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
73 74
<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>
75 76 77
</div>
EOF;

78 79 80
 
 pg_free_result($result);       
 pg_close($dbh);
81
?>
root's avatar
root committed
82
</div>