cvs: php-gtk-web /include shared-manual.inc /manual note.sql

cmv		Fri Aug 10 15:09:12 2001 EDT

  Added files:                 
    /php-gtk-web/manual	note.sql 

  Modified files:              
    /php-gtk-web/include	shared-manual.inc 
  Log:
  trying user-rated comments
  
  
  
Index: php-gtk-web/include/shared-manual.inc
diff -u php-gtk-web/include/shared-manual.inc:1.16 php-gtk-web/include/shared-manual.inc:1.17
--- php-gtk-web/include/shared-manual.inc:1.16	Thu Aug  9 17:03:55 2001
+++ php-gtk-web/include/shared-manual.inc	Fri Aug 10 15:09:11 2001
@@ -164,7 +164,7 @@
 }
 
 
-function makeEntry($date,$name,$blurb,$id=0) {
+function makeEntry($date,$name,$blurb,$rating=0,$id=0,) {
 	global $MAGIC_COOKIE;
 
 	echo '<tr valign="top">';
@@ -181,7 +181,7 @@
 	}
 	echo date("d-M-Y h:i", $date);
 	echo '<br></td>';
-	echo '<td align="right">';
+	echo '<td align="right"><small>';
 	if (isset($MAGIC_COOKIE) && $id) {
 
 		print_link('/manual/admin-notes.php?action=edit+' . $id . '&brief=1',
@@ -198,9 +198,11 @@
 			'admin'
 		);
 	}
+	echo '<br>';
 
-	echo '<br></td>';
-	echo '</tr>';
+	printf('rating: <B>%.02f<B>', $rating );
+
+	echo '<br></small></td></tr>';
 	echo '<tr bgcolor="#f0f0f0"><td colspan="2">';
 	echo clean_note($blurb). '<br>';
 	echo '</td></tr>';
@@ -222,7 +224,9 @@
 		$user = 'nobody';
 		$pass = '';
 		$db_id = @mysql_pconnect($host, $user, $pass);
-		$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen FROM note WHERE sect = '$title' OR sect = '$id' ORDER BY id";
+#		$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen FROM note WHERE sect = '$title' OR sect = '$id' ORDER BY id";
+		$query = "SELECT *, UNIX_TIMESTAMP(ts) AS xwhen, if(votes=0, 0, rating/votes) AS rate FROM note " .
+				"WHERE sect='$title' OR sect='$id' ORDER BY rate DESC, id";
 		if ($db_id) {
 			$result_id = mysql_db_query("gtk", $query, $db_id);
 		}

Index: php-gtk-web/manual/note.sql
+++ php-gtk-web/manual/note.sql
#
# Table structure for table 'note'
#

CREATE TABLE note (
  id mediumint(9) NOT NULL auto_increment,
  sect varchar(80),
  user varchar(80),
  note text,
  ts datetime,
  status varchar(16),
  lang varchar(16),
  votes mediumint(9) DEFAULT '0' NOT NULL,
  rating mediumint(9) DEFAULT '0' NOT NULL,
  PRIMARY KEY (id),
  KEY sect (sect)
);