[Icemud-commits] IceMUD/src/mud/tools DBTools.java,1.6,1.7

[<jc...@us...>]

Update of /cvsroot/icemud/IceMUD/src/mud/tools
In directory sc8-pr-cvs1:/tmp/cvs-serv15952/tools

Modified Files:
	DBTools.java 
Log Message:
Windows doesn't respect capitalization - MySQL doesn't care: fixed
the tables names.

Index: DBTools.java
===================================================================
RCS file: /cvsroot/icemud/IceMUD/src/mud/tools/DBTools.java,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** DBTools.java	4 Dec 2003 16:32:41 -0000	1.6
--- DBTools.java	12 Dec 2003 18:42:36 -0000	1.7
***************
*** 64,69 ****
  
  		try {
! 			
! 				
  			Statement statement = sConnection.createStatement();
  			
--- 64,68 ----
  
  		try {
! 							
  			Statement statement = sConnection.createStatement();
  			
***************
*** 78,91 ****
  		        if(result != null)
  			        while(result.next()) {
! 			        	if (result.getString(1).equals("tblUsersEquipment")) bUserEquipment = true;
! 			        	else if (result.getString(1).equals("tblUsers")) bUsers = true;
! 			        	else if (result.getString(1).equals("tblSubItems")) bSubItems = true;
! 						else if (result.getString(1).equals("tblApplySavingThrow")) bApplySavingThrow = true;
! 						else if (result.getString(1).equals("tblSkills")) bSkills = true;
! 						else if (result.getString(1).equals("tblSettings")) bSettings = true;
! 						else if (result.getString(1).equals("tblNotes")) bNotes = true;
! 						else if (result.getString(1).equals("tblAliases")) bAliases = true;
! 						else if (result.getString(1).equals("tblBanned")) bBanned = true;
! 						else if (result.getString(1).equals("tblText")) bText = true;	
  					}         
  		        
--- 77,90 ----
  		        if(result != null)
  			        while(result.next()) {
! 			        	if (result.getString(1).toLowerCase().equals("tblusersequipment")) bUserEquipment = true;
! 			        	else if (result.getString(1).toLowerCase().equals("tblusers")) bUsers = true;
! 			        	else if (result.getString(1).toLowerCase().equals("tblsubitems")) bSubItems = true;
! 						else if (result.getString(1).toLowerCase().equals("tblapplysavingthrow")) bApplySavingThrow = true;
! 						else if (result.getString(1).toLowerCase().equals("tblskills")) bSkills = true;
! 						else if (result.getString(1).toLowerCase().equals("tblsettings")) bSettings = true;
! 						else if (result.getString(1).toLowerCase().equals("tblnotes")) bNotes = true;
! 						else if (result.getString(1).toLowerCase().equals("tblaliases")) bAliases = true;
! 						else if (result.getString(1).toLowerCase().equals("tblbanned")) bBanned = true;
! 						else if (result.getString(1).toLowerCase().equals("tbltext")) bText = true;	
  					}         
  		        
***************
*** 565,569 ****
  				ResultSet result = statement.getResultSet();
  				if(result != null)
! 					if (result.next()) {
  						String sIP = result.getString("sIP");
  						if (sIP.equals(inIP))
--- 564,568 ----
  				ResultSet result = statement.getResultSet();
  				if(result != null)
! 					while (result.next()) {
  						String sIP = result.getString("sIP");
  						if (sIP.equals(inIP))