CharSQL: fixed the 0x2b05 packet, now the multi mapservers works ...

Login/LoginSQL: fixed the version check finaly :) now the servers can connect XD


git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/branches/stable@1110 54d463be-8e91-2dee-dedb-b68131a5f0ec

3 files changed, 31 insertions, 15 deletions

diff --git a/src/char_sql/char.c b/src/char_sql/char.c
index de28fea34..0521a21bc 100644
--- a/src/char_sql/char.c
+++ b/src/char_sql/char.c
@@ -2105,12 +2105,29 @@ int parse_frommap(int fd) {
 			auth_fifo[auth_fifo_pos].sex = RFIFOB(fd,44);
 			auth_fifo[auth_fifo_pos].ip = RFIFOL(fd,45);
 
-			sprintf(tmp_sql, "SELECT count(*) FROM `%s` WHERE `account_id` = '%d' AND `char_id`='%d'", char_db, RFIFOL(fd,2), RFIFOL(fd,14));
+			sprintf(tmp_sql, "SELECT `char_id` FROM `%s` WHERE `account_id` = '%d' AND `char_id`='%d'", char_db, RFIFOL(fd,2), RFIFOL(fd,14));
 			if (mysql_query(&mysql_handle, tmp_sql)) {
 				printf("DB server Error - %s\n", mysql_error(&mysql_handle));
 			}
 			sql_res = mysql_store_result(&mysql_handle);
-
+			if(sql_res){
+				i = atoi(sql_row[0]);
+				mysql_free_result(sql_res);
+				auth_fifo[auth_fifo_pos].char_pos = auth_fifo[auth_fifo_pos].char_id;
+				auth_fifo_pos++;
+				WFIFOL(fd,6) = 0;
+			}else{
+				return 0;
+			}
+			
+			if(i == 0){
+				WFIFOW(fd, 6) = 0;
+			}
+			
+			WFIFOSET(fd, 44);
+			RFIFOSKIP(fd, 49);
+			
+			/*
 			if (( sql_row = mysql_fetch_row(sql_res))) {
 				i = atoi(sql_row[0]);
 				mysql_free_result(sql_res);
@@ -2127,7 +2144,10 @@ int parse_frommap(int fd) {
 			WFIFOSET(fd,44);
 			RFIFOSKIP(fd,49);
 			break;
+			*/
 
+		break;
+		
 		// char name check
 		case 0x2b08:
 			if (RFIFOREST(fd) < 6)
diff --git a/src/login/login.c b/src/login/login.c
index 95b0cc349..f925f5e2a 100644
--- a/src/login/login.c
+++ b/src/login/login.c
@@ -1122,12 +1122,10 @@ int mmo_auth(struct mmo_account* account, int fd) {
 	}
 	
 	//EXE Version check [Sirius]
-	if(account->sex != 0){
-	        if(check_client_version == 1){
+	if(check_client_version == 1 && account->version != 0){
         		if(account->version != client_version_to_connect){
         			return 5;
 			}
-		}
 	}
 	
 	// Strict account search
diff --git a/src/login_sql/login.c b/src/login_sql/login.c
index 3aae267b0..f387e32c1 100644
--- a/src/login_sql/login.c
+++ b/src/login_sql/login.c
@@ -437,16 +437,6 @@ int mmo_auth( struct mmo_account* account , int fd){
 	jstrescapecpy(t_pass, account->passwd);
 
 
-	//check for lasted version (exe version check) [Sirius]
-	if(account->sex != 0){
-        	if(check_client_version == 1){
-			if(account->version != client_version_to_connect){
-				return 6;
-			}
-		}
-	}
-                                                                        
-
 	// make query
 	sprintf(tmpsql, "SELECT `%s`,`%s`,`%s`,`lastlogin`,`logincount`,`sex`,`connect_until`,`last_ip`,`ban_until`,`state`,`%s`"
 	                " FROM `%s` WHERE %s `%s`='%s'", login_db_account_id, login_db_userid, login_db_user_pass, login_db_level, login_db, case_sensitive ? "BINARY" : "", login_db_userid, t_uid);
@@ -469,6 +459,14 @@ int mmo_auth( struct mmo_account* account , int fd){
 		printf("mmo_auth DB result error ! \n");
 		return 0;
 	}
+	
+	//Client Version check[Sirius]
+        if(check_client_version == 1 && account->version != 0){
+        	if(account->version != client_version_to_connect){
+			mysql_free_result(sql_res);
+			return 6;
+		}
+	}           
 	                                                                        
 	// Documented by CLOWNISIUS || LLRO || Gunstar lead this one with me
 	// IF changed to diferent returns~ you get diferent responses from your msgstringtable.txt