diff options
| author | root | 2014-06-19 12:21:24 +0200 |
|---|---|---|
| committer | root | 2014-06-19 12:21:24 +0200 |
| commit | 1b54f67fb2bc065c9e9dbb66d1e00e407d30456d (patch) | |
| tree | 8f873c8bb00e6cc520cd07c943eab5680f08d747 /track-comments.php | |
| parent | a3e435a558392908a3c91f796042668fa10bb33f (diff) | |
| download | scilab_cloud_interface-1b54f67fb2bc065c9e9dbb66d1e00e407d30456d.tar.gz scilab_cloud_interface-1b54f67fb2bc065c9e9dbb66d1e00e407d30456d.tar.bz2 scilab_cloud_interface-1b54f67fb2bc065c9e9dbb66d1e00e407d30456d.zip | |
started propoer github maintainence
Diffstat (limited to 'track-comments.php')
| -rwxr-xr-x | track-comments.php | 96 |
1 files changed, 96 insertions, 0 deletions
diff --git a/track-comments.php b/track-comments.php new file mode 100755 index 0000000..f2c51e1 --- /dev/null +++ b/track-comments.php @@ -0,0 +1,96 @@ +<html> +<head> + <title>Comments | Scilab on Cloud</title> + <style> + h3{ color: #4E3519; } + body{ + background: url("http://scilab.in/sites/all/themes/scilab/images/content_line.png"); + } + #comments-wrapper{ + padding: 25px 100px; + background: #ffffff; + max-width: 800px; + margin: 0 auto; + -moz-box-shadow: 1px 1px 10px #cccccc; + -webkit-box-shadow: 1px 1px 10px #cccccc; + -o-box-shadow: 1px 1px 10px #cccccc; + box-shadow: 1px 1px 10px #cccccc; + } + .comment{ + margin: 25px 0; + padding: 25px; + background: #f5f5f5; + border-left: 3px solid #4E3519; + } + .from, .type, .book, .chapter, .example, .category{ + display: block; + } + .from{ + font-weight: bolder; + color: #424242; + } + .type{ + color: #4E3519; + } + .comment p{ + text-align: justify; + } + .comment p b{ + color: #4E3519; + } + </style> +</head> +<body> +<div id="comments-wrapper"> +<h3 align="center"><u>Scilab on Cloud - Comments</u></h3> +<?php + require_once('db-connect.php'); + $query = "select * from scilab_cloud_comment"; + $result = mysql_query($query); + $types = array( + "None", + "Blank Code / Incorrect code", + "Output error", + "Execution error", + "Missing example(s)", + "None", + "Blank output", + "Any other" + ); + $categories = array( + "Others", + "Fluid Mechanics", + "Control Theory & Control Systems", + "Chemical Engineering", + "Thermodynamics", + "Mechanical Engineering", + "Signal Processing", + "Digital Communications", + "Electrical Technology", + "Mathematics & Pure Science", + "Analog Electronics", + "Digital Electronics", + "Computer Programming", + "Others" + ); + while($row = mysql_fetch_array($result)){ + echo '<div class="comment">'; + echo '<span class="from">From: ' . $row["email"] . '</span>'; + echo '<span class="type">Issue type: ' . $types[$row["type"]] . '</span>'; + $book = mysql_result(mysql_query("select book from textbook_companion_preference where id=".$row["books"]), 0); + echo '<span class="book">Book: ' . $book . '</span>'; + echo '<span class="category"> Category: ' . $categories[$row["category"]] . '</span>'; + $chapter = mysql_result(mysql_query("select name from textbook_companion_chapter where id=".$row["chapter"]), 0); + echo '<span class="chapter"> Chapter: ' . $chapter . '</span>'; + $example = mysql_result(mysql_query("select caption from textbook_companion_example where id=".$row["example"]), 0); + echo '<span class="example"> Example: <a href="http://cloud.scilab.in/index.php?eid=' . $row["example"] . '" target="_blank">' . $example . '</a>' . '</span>'; + echo '<p><b>Comment:</b> <br>' . $row["comment"] . '</p>'; + echo '<a class="reply" href="#">Reply</a>'; + echo '</div> <!-- /comment -->'; + } + + +?> +</div> <!-- /comments-wrapper --> +</body> +</html> |