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/Home.java | 2 +- src/java/com/juick/http/www/PageTemplates.java | 8 ++++---- 2 files changed, 5 insertions(+), 5 deletions(-) (limited to 'src/java/com/juick/http/www') diff --git a/src/java/com/juick/http/www/Home.java b/src/java/com/juick/http/www/Home.java index 41e85c0d..6d60bfaf 100644 --- a/src/java/com/juick/http/www/Home.java +++ b/src/java/com/juick/http/www/Home.java @@ -109,7 +109,7 @@ public class Home { if (visitor != null) { out.println("
"); out.println("
"); - out.println(" "); + out.println(" "); out.println("
"); 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("