public String getViewersOf(Integer photo_id) throws Exception {
Connection db;
Statement st;
String query, out = "";
try {
db = getDBConn();
} catch (Exception e) {
throw new Exception("Can't get database connection: " + e.getMessage());
}
query =
"select wwwusers.username, log.remote_addr,\n"
+ " user_agent.user_agent, log.cached, log.ts\n"
+ " from wwwusers, photo_log log, user_agent\n"
+ " where log.wwwuser_id = wwwusers.id and\n"
+ " log.photo_id = "
+ photo_id
+ " and\n"
+ " user_agent.user_agent_id = log.user_agent\n"
+ " order by log.ts\n";
try {
st = db.createStatement();
ResultSet rs = st.executeQuery(query);
Hashtable htmp = new Hashtable();
htmp.put("PHOTO_ID", photo_id.toString());
out = PhotoUtil.tokenize(photosession, "log/viewers_top.inc", htmp);
while (rs.next()) {
try {
Hashtable h = new Hashtable();
h.put("USERNAME", rs.getString(1));
h.put("REMOTE_ADDR", rs.getString(2));
h.put("USER_AGENT", rs.getString(3));
h.put("CACHED", rs.getString(4));
h.put("TS", rs.getString(5));
out += PhotoUtil.tokenize(photosession, "log/viewers_match.inc", h);
} catch (Exception e) {
log("Error reporting log entry for " + photo_id.toString() + " from " + rs.getString(5));
}
}
out += PhotoUtil.tokenize(photosession, "log/viewers_bottom.inc", new Hashtable());
} catch (Exception e) {
throw new Exception(e.getMessage());
} finally {
freeDBConn(db);
}
return (out);
}
public static void main(String args[]) {
try {
BufferedReader rd = new BufferedReader(new InputStreamReader(System.in));
PhotoConfig config = new PhotoConfig();
PhotoSecurity security = new PhotoSecurity();
String user = null;
if (args.length < 1) {
System.out.print("Enter username: "******"Enter password: "******"New password is " + newpw);
Class.forName(config.get("dbDriverName"));
Connection db =
DriverManager.getConnection(
config.get("dbSource"), config.get("dbUser"), config.get("dbPass"));
String query =
"update wwwusers set password='******'\n" + "\twhere username='******'";
Statement st = db.createStatement();
st.executeUpdate(query);
} catch (Exception e) {
System.out.println(e);
e.printStackTrace();
}
}