");
out.println("
");
out.println("
");
diff --git a/src/java/com/juick/http/www/PageTemplates.java b/src/java/com/juick/http/www/PageTemplates.java
index a6d278bf..88366ce0 100644
--- a/src/java/com/juick/http/www/PageTemplates.java
+++ b/src/java/com/juick/http/www/PageTemplates.java
@@ -52,9 +52,9 @@ public class PageTemplates {
out.println("");
out.print("");
out.print("");
- out.print("
");
+ out.print("
");
out.print("");
- out.print("");
+ out.print("");
if (headers != null) {
out.print(headers);
}
@@ -201,7 +201,7 @@ public class PageTemplates {
PreparedStatement stmt = null;
ResultSet rs = null;
try {
- stmt = sql.prepareStatement("SELECT users.id,users.nick,COUNT(users_refs.user_id) AS cnt FROM users INNER JOIN users_refs ON users.id=users_refs.ref GROUP BY users_refs.ref ORDER BY cnt DESC LIMIT 10");
+ stmt = sql.prepareStatement("SELECT users.id,users.nick,COUNT(users_refs.user_id) AS cnt FROM users INNER JOIN users_refs ON users.id=users_refs.ref WHERE users.id>2 GROUP BY users_refs.ref ORDER BY cnt DESC LIMIT 10");
rs = stmt.executeQuery();
rs.beforeFirst();
while (rs.next()) {
@@ -501,7 +501,7 @@ public class PageTemplates {
out.println("
");
out.println(" ");
out.println(" ");
- out.println(" ");
+ out.println(" ");
if (msg.AttachmentType != null) {
String fname = msg.MID + "." + msg.AttachmentType;
out.println(" ![\"\"/](\"//i.juick.com/photos-512/")
");
--
cgit v1.2.3