From afe7ff2701d4940a0413557ff03379779c47750c Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Mon, 17 Mar 2014 07:03:13 +0700
Subject: Page width 1024px; small improvements
---
src/java/com/juick/http/www/PageTemplates.java | 8 ++++----
1 file changed, 4 insertions(+), 4 deletions(-)
(limited to 'src/java/com/juick/http/www/PageTemplates.java')
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