[Arianne-commits] marauroa/src/marauroa/server/game/db LoginEventDAO.java, 1.13, 1.14

[Hendrik B. <nh...@us...>]

Update of /cvsroot/arianne/marauroa/src/marauroa/server/game/db
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv1785/src/marauroa/server/game/db

Modified Files:
	LoginEventDAO.java 
Log Message:
fixed sql statements

Index: LoginEventDAO.java
===================================================================
RCS file: /cvsroot/arianne/marauroa/src/marauroa/server/game/db/LoginEventDAO.java,v
retrieving revision 1.13
retrieving revision 1.14
diff -C2 -d -r1.13 -r1.14
*** LoginEventDAO.java	24 Sep 2009 06:48:03 -0000	1.13
--- LoginEventDAO.java	11 Nov 2009 20:11:14 -0000	1.14
***************
*** 211,215 ****
  		String query = "SELECT count(*) as amount FROM loginEvent, account"
  				+ " WHERE loginEvent.player_id=account.id"
! 				+ " AND username='[username']"
  		        + " AND loginEvent.result=0 and (now()-loginEvent.timedate)<"
  		        + TimeoutConf.FAILED_LOGIN_BLOCKTIME;
--- 211,215 ----
  		String query = "SELECT count(*) as amount FROM loginEvent, account"
  				+ " WHERE loginEvent.player_id=account.id"
! 				+ " AND username='[username]'"
  		        + " AND loginEvent.result=0 and (now()-loginEvent.timedate)<"
  		        + TimeoutConf.FAILED_LOGIN_BLOCKTIME;
***************
*** 223,227 ****
  	public boolean isAddressBlocked(DBTransaction transaction, String address) throws SQLException {
  		String query = "SELECT count(*) as amount FROM loginEvent"
! 				+ " WHERE address='[address']"
  		        + " AND result=0 and (now()-timedate)<"
  		        + TimeoutConf.FAILED_LOGIN_BLOCKTIME;
--- 223,227 ----
  	public boolean isAddressBlocked(DBTransaction transaction, String address) throws SQLException {
  		String query = "SELECT count(*) as amount FROM loginEvent"
! 				+ " WHERE address='[address]'"
  		        + " AND result=0 and (now()-timedate)<"
  		        + TimeoutConf.FAILED_LOGIN_BLOCKTIME;