From 9adb555fe41f6322310be1fea406d9d8d44acafe Mon Sep 17 00:00:00 2001
From: Ugnich Anton
Date: Wed, 26 Dec 2012 14:30:03 +0700
Subject: New tags URLs

---
 src/java/com/juick/http/www/Tags.java | 87 -----------------------------------
 1 file changed, 87 deletions(-)
 delete mode 100644 src/java/com/juick/http/www/Tags.java

(limited to 'src/java/com/juick/http/www/Tags.java')

diff --git a/src/java/com/juick/http/www/Tags.java b/src/java/com/juick/http/www/Tags.java
deleted file mode 100644
index 534ca8ef..00000000
--- a/src/java/com/juick/http/www/Tags.java
+++ /dev/null
@@ -1,87 +0,0 @@
-/*
- * To change this template, choose Tools | Templates
- * and open the template in the editor.
- */
-package com.juick.http.www;
-
-import java.io.IOException;
-import java.io.PrintWriter;
-import java.io.UnsupportedEncodingException;
-import java.net.URLEncoder;
-import java.sql.Connection;
-import java.sql.PreparedStatement;
-import java.sql.ResultSet;
-import java.sql.SQLException;
-import java.util.Arrays;
-import java.util.Locale;
-import java.util.ResourceBundle;
-import javax.servlet.ServletException;
-import javax.servlet.http.HttpServletRequest;
-import javax.servlet.http.HttpServletResponse;
-
-/**
- *
- * @author ugnich
- */
-public class Tags {
-
-    protected void doGetTags(Connection sql, HttpServletRequest request, HttpServletResponse response, com.juick.User visitor) throws ServletException, IOException {
-        Locale locale = request.getLocale();
-        ResourceBundle rbnm = ResourceBundle.getBundle("Blogs", locale);
-
-        response.setContentType("text/html; charset=UTF-8");
-        PrintWriter out = response.getWriter();
-        try {
-            PageTemplates.pageHead(out, rbnm.getString("Tags"), null);
-            PageTemplates.pageNavigation(out, locale, visitor);
-
-            int cnt = 30;
-            com.juick.Tag tags[] = new com.juick.Tag[cnt];
-            int maxUsageCnt = 0;
-            PreparedStatement stmt = null;
-            ResultSet rs = null;
-            try {
-                stmt = sql.prepareStatement("SELECT tags.name AS name,COUNT(DISTINCT messages.user_id) AS cnt FROM (messages INNER JOIN messages_tags ON (messages.ts>TIMESTAMPADD(DAY,-3,NOW()) AND messages.message_id=messages_tags.message_id)) INNER JOIN tags ON messages_tags.tag_id=tags.tag_id WHERE tags.tag_id NOT IN (SELECT tag_id FROM tags_ignore) GROUP BY tags.tag_id ORDER BY cnt DESC LIMIT ?");
-                stmt.setInt(1, cnt);
-                rs = stmt.executeQuery();
-                rs.beforeFirst();
-                cnt = 0;
-                while (rs.next()) {
-                    tags[cnt] = new com.juick.Tag();
-                    tags[cnt].Name = rs.getString(1);
-                    tags[cnt].UsageCnt = rs.getInt(2);
-                    if (tags[cnt].UsageCnt > maxUsageCnt) {
-                        maxUsageCnt = tags[cnt].UsageCnt;
-                    }
-                    cnt++;
-                }
-            } catch (SQLException e) {
-                System.err.println(e);
-            } finally {
-                Utils.finishSQL(rs, stmt);
-            }
-
-            Arrays.sort(tags, 0, cnt);
-
-            for (int i = 0; i < cnt; i++) {
-                String tag = Utils.encodeHTML(tags[i].Name);
-                try {
-                    tag = "<a href=\"/?tag=" + URLEncoder.encode(tags[i].Name, "UTF-8") + "\">" + tag + "</a>";
-                } catch (UnsupportedEncodingException e) {
-                }
-
-                if (tags[i].UsageCnt > maxUsageCnt / 3 * 2) {
-                    out.print("<big>" + tag + "</big> ");
-                } else if (tags[i].UsageCnt > maxUsageCnt / 3) {
-                    out.print("<small>" + tag + "</small> ");
-                } else {
-                    out.print(tag + " ");
-                }
-            }
-
-            PageTemplates.pageFooter(request, out, locale, visitor);
-        } finally {
-            out.close();
-        }
-    }
-}
-- 
cgit v1.2.3