/*
* Juick
* Copyright (C) 2008-2011, Ugnich Anton
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU Affero General Public License as
* published by the Free Software Foundation, either version 3 of the
* License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Affero General Public License for more details.
*
* You should have received a copy of the GNU Affero General Public License
* along with this program. If not, see " + title + " ");
out.println(" ");
out.println("
" + title + " ");
out.println("");
}
public static void pageUserTitle(PrintWriter out, Connection sql, Locale loc, com.juick.User user, com.juick.User visitor) {
ResourceBundle rb = ResourceBundle.getBundle("User", loc);
// Full name and description
String fullname = null;
String description = null;
PreparedStatement stmt = null;
ResultSet rs = null;
try {
stmt = sql.prepareStatement("SELECT fullname,descr FROM usersinfo WHERE user_id=?");
stmt.setInt(1, user.UID);
rs = stmt.executeQuery();
if (rs.first()) {
fullname = rs.getString(1) + " (" + user.UName + ")";
description = rs.getString(2);
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
if (fullname == null) {
fullname = user.UName;
}
if (description == null) {
description = "";
}
// I read
int iread = 0;
try {
stmt = sql.prepareStatement("SELECT COUNT(*) FROM subscr_users WHERE suser_id=?");
stmt.setInt(1, user.UID);
rs = stmt.executeQuery();
if (rs.first()) {
iread = rs.getInt(1);
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
// My readers
int myreaders = 0;
try {
stmt = sql.prepareStatement("SELECT COUNT(*) FROM subscr_users WHERE user_id=?");
stmt.setInt(1, user.UID);
rs = stmt.executeQuery();
if (rs.first()) {
myreaders = rs.getInt(1);
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
// Messages
int messages = 0;
try {
stmt = sql.prepareStatement("SELECT COUNT(*) FROM messages WHERE user_id=?");
stmt.setInt(1, user.UID);
rs = stmt.executeQuery();
if (rs.first()) {
messages = rs.getInt(1);
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
// Replies
int replies = 0;
try {
stmt = sql.prepareStatement("SELECT COUNT(*) FROM replies WHERE user_id=?");
stmt.setInt(1, user.UID);
rs = stmt.executeQuery();
if (rs.first()) {
replies = rs.getInt(1);
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
out.println("");
out.println("
");
out.println("
");
out.println(" " + rb.getString("(Stats) I read") + ": " + iread + " ");
out.println(" " + rb.getString("(Stats) My readers") + ": " + myreaders + " ");
out.println(" " + rb.getString("(Stats) Messages") + ": " + messages + " ");
out.println(" " + rb.getString("(Stats) Replies") + ": " + replies + " ");
out.println(" ");
out.println("
" + fullname + " " + description + "
");
out.println("
");
}
public static String formatTags(String tags) {
String ret = "";
String tagsarr[] = tags.split(" ");
for (int i = 0; i < tagsarr.length; i++) {
String tag = tagsarr[i];
tag = tag.replaceAll("<", "<");
tag = tag.replaceAll(">", ">");
try {
ret += " *" + tag + " ";
} catch (UnsupportedEncodingException e) {
}
}
return ret;
}
public static String formatDate(int minsago, String fulldate, Locale loc) {
if (minsago < 1) {
return "now";
} else if (minsago < 60) {
return minsago + " minute" + ((minsago % 10 == 1) ? "" : "s") + " ago";
} else if (minsago < 1440) {
int hours = (minsago / 60);
return hours + " hour" + ((hours % 10 == 1) ? "" : "s") + " ago";
} else if (minsago < 20160) {
int days = (minsago / 1440);
return days + " day" + ((days % 10 == 1) ? "" : "s") + " ago";
} else {
return fulldate;
}
}
public static String formatReplies(int replies, Locale loc) {
return replies + " repl" + (replies % 10 == 1 ? "y" : "ies");
}
private static Pattern regexLinks2 = Pattern.compile("((?<=\\s)|(?<=\\A))([\\[\\{]|<)((?:ht|f)tps?://(?:www\\.)?([^\\/\\s\\\"\\)\\!]+)/?(?:[^\\]\\}](?", ">");
// --
// —
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))\\-\\-?((?=\\s)|(?=\\Z))", "$1—$2");
// http://juick.com/last?page=2
// juick.com
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))((?:ht|f)tps?://(?:www\\.)?([^\\/\\s\\n\\\"]+)/?[^\\s\\n\\\"]*)", "$1$3 ");
// #12345
// #12345
msg = msg.replaceAll("((?<=\\s)|(?<=\\A)|(?<=\\p{Punct}))#(\\d+)((?=\\s)|(?=\\Z)|(?=\\))|(?=\\.)|(?=\\,))", "$1#$2 $3");
// #12345/65
// #12345/65
msg = msg.replaceAll("((?<=\\s)|(?<=\\A)|(?<=\\p{Punct}))#(\\d+)/(\\d+)((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1#$2/$3 $4");
// *bold*
// bold
msg = msg.replaceAll("((?<=\\s)|(?<=\\A)|(?<=\\p{Punct}))\\*([^\\*\\n<>]+)\\*((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1$2 $3");
// /italic/
// italic
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))/([^\\/\\n<>]+)/((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1$2 $3");
// _underline_
// underline
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))_([^\\_\\n<>]+)_((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1$2 $3");
// /12
// /12
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))\\/(\\d+)((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1/$2 $3");
// @username@jabber.org
// @username@jabber.org
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))@([\\w\\-\\.]+@[\\w\\-\\.]+)((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1@$2 $3");
// @username
// @username
msg = msg.replaceAll("((?<=\\s)|(?<=\\A))@([\\w\\-]{2,16})((?=\\s)|(?=\\Z)|(?=\\p{Punct}))", "$1@$2 $3");
// (http://juick.com/last?page=2)
// (juick.com )
Matcher m = regexLinks2.matcher(msg);
StringBuffer sb = new StringBuffer();
while (m.find()) {
String url = m.group(3).replace(" ", "%20").replaceAll("\\s", "");
m.appendReplacement(sb, "$1$2$4 $5");
}
m.appendTail(sb);
msg = sb.toString();
// > citate
msg = msg.replaceAll("(?:(?<=\\n)|(?<=\\A))>\\s*(.*)(\\n|(?=\\Z))", "$1 ");
msg = msg.replaceAll("", "\n");
msg = msg.replaceAll("\n", " mids, Locale locale) {
ResourceBundle rb = ResourceBundle.getBundle("Global", locale);
PreparedStatement stmt = null;
ResultSet rs = null;
try {
stmt = sql.prepareStatement("SELECT STRAIGHT_JOIN messages.message_id,messages.user_id,users.nick,messages_txt.tags,messages.readonly,messages.privacy,messages_txt.txt,TIMESTAMPDIFF(MINUTE,messages.ts,NOW()),messages.ts,messages.replies,messages_txt.repliesby,messages.attach,messages.place_id,places.name,messages.lat,messages.lon FROM ((messages INNER JOIN messages_txt ON messages.message_id=messages_txt.message_id) INNER JOIN users ON messages.user_id=users.id) LEFT JOIN places ON messages.place_id=places.place_id WHERE messages.message_id IN (" + Utils.convertArray2String(mids) + ") ORDER BY messages.message_id DESC");
rs = stmt.executeQuery();
rs.beforeFirst();
while (rs.next()) {
int mid = rs.getInt(1);
int uid = rs.getInt(2);
String uname = rs.getString(3);
String tags = rs.getString(4);
String txt = rs.getString(7);
// timediff
// timestamp
// replies
// 11 repliesby
// attach
// pid
// pname
// lat
// lon
boolean cancomment = true;
tags = (tags != null) ? formatTags(tags) : "";
if (rs.getInt(5) == 1) {
tags += " *readonly";
cancomment = false;
}
switch (rs.getInt(6)) {
case 2:
tags += " *public";
break;
case -1:
tags += " *friends";
break;
case -2:
tags += " *private";
break;
}
txt = formatMessage(txt);
out.print(" ");
if (rs.getString(12) != null) {
if (rs.getString(12).equals("jpg")) {
out.println(" ");
} else {
out.println(" ");
out.println(" ");
}
}
out.println(" ");
out.println(" ");
out.println(" ");
out.println(" " + txt + "
");
if (rs.getInt(10) > 0) {
String repliesby = rs.getString(11);
if (repliesby == null) {
repliesby = "...";
}
out.println(" ");
} else if (cancomment) {
out.println(" ");
}
out.println(" ");
}
} catch (SQLException e) {
System.err.println(e);
} finally {
Utils.finishSQL(rs, stmt);
}
}
}
![\"Juick\"/](\"http://static.juick.com/logo3.png\"){kind=logo}
" + user.UName + "
");
} else {
out.println(" ![](\"http://static.juick.com/message-menu-icon.png\"){kind=icon}