Skip to content

Commit

Permalink
Optimization.
Browse files Browse the repository at this point in the history
icza committed Feb 5, 2010
1 parent 7a56693 commit 24a7e44
Showing 2 changed files with 4 additions and 2 deletions.
5 changes: 3 additions & 2 deletions hackerdb/src/hu/belicza/andras/hackerdb/HackerDbServlet.java
Original file line number Diff line number Diff line change
@@ -816,11 +816,11 @@ private void serveDownload( final String agentVersion, final String authorizatio
// We might deny the download based on the authorization key...

statement = connection.createStatement();
resultSet = statement.executeQuery( "SELECT DISTINCT gateway, name from hacker JOIN report on report.hacker=hacker.id JOIN key on report.key=key.id WHERE hacker.guarded=FALSE AND key.revocated=FALSE AND report.revocated=FALSE" );
resultSet = statement.executeQuery( "SELECT DISTINCT hacker.id, gateway, name from hacker JOIN report on report.hacker=hacker.id JOIN key on report.key=key.id WHERE hacker.guarded=FALSE AND key.revocated=FALSE AND report.revocated=FALSE" );
outputWriter = response.getWriter();

while ( resultSet.next() )
outputWriter.println( resultSet.getInt( 1 ) + "," + resultSet.getString( 2 ) );
outputWriter.println( resultSet.getInt( 2 ) + "," + resultSet.getString( 3 ) );

outputWriter.flush();

@@ -1175,6 +1175,7 @@ private static void renderHeader( final PrintWriter outputWriter, final String p

outputWriter.println( getCurrentTimeCode() );
outputWriter.println( "<h2>BWHF Hacker Database</h2>" );
outputWriter.println( "<div class='note'>The World's largest StarCrfat Broodwar hacker, game and player database</div>" );

outputWriter.println( HACKER_LIST_MENU_HTML );
outputWriter.println( GOOGLE_AD_HTML_HEADER );
Original file line number Diff line number Diff line change
@@ -1730,6 +1730,7 @@ private static void renderHeader( final HttpServletRequest request, final PrintW
outputWriter.println( "</head><body><center>" );
outputWriter.println( getCurrentTimeCode() );
outputWriter.println( "<h2>BWHF Players' Network</h2>" );
outputWriter.println( "<div class='note'>The World's largest StarCrfat Broodwar hacker, game and player database</div>" );
outputWriter.println( MENU_HTML );
outputWriter.println( GOOGLE_AD_HTML_HEADER );
}

0 comments on commit 24a7e44

Please sign in to comment.