- Massive EOL normalization & 'svn:eol-style native' flag setting for all txt/conf/h/c files.

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

1 files changed, 372 insertions, 372 deletions

diff --git a/src/char_sql/int_pet.c b/src/char_sql/int_pet.c
index 69eb4ec02..ff4f0edb9 100644
--- a/src/char_sql/int_pet.c
+++ b/src/char_sql/int_pet.c
@@ -1,372 +1,372 @@
-// Copyright (c) Athena Dev Teams - Licensed under GNU GPL

-// For more information, see LICENCE in the main folder

-

-// original code from athena

-// SQL conversion by Jioh L. Jung

-

-#include <stdio.h>

-#include <stdlib.h>

-#include <string.h>

-

-#include "char.h"

-#include "../common/strlib.h"

-#include "../common/showmsg.h"

-

-struct s_pet *pet_pt;

-

-#ifndef SQL_DEBUG

-

-#define mysql_query(_x, _y) mysql_real_query(_x, _y, strlen(_y)) //supports ' in names and runs faster [Kevin]

-

-#else 

-

-#define mysql_query(_x, _y) debug_mysql_query(__FILE__, __LINE__, _x, _y)

-

-#endif

-

-//---------------------------------------------------------

-int inter_pet_tosql(int pet_id, struct s_pet *p) {

-	//`pet` (`pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`)

-	char t_name[NAME_LENGTH*2];

-

-	jstrescapecpy(t_name, p->name);

-

-	if(p->hungry < 0)

-		p->hungry = 0;

-	else if(p->hungry > 100)

-		p->hungry = 100;

-	if(p->intimate < 0)

-		p->intimate = 0;

-	else if(p->intimate > 1000)

-		p->intimate = 1000;

-	if (pet_id == -1) //New pet.

-		sprintf(tmp_sql,"INSERT INTO `%s` "

-			"(`class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`) "

-			"VALUES ('%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d')",

-			pet_db, p->class_, t_name, p->account_id, p->char_id, p->level, p->egg_id,

-			p->equip, p->intimate, p->hungry, p->rename_flag, p->incuvate);

-

-	else	//Update pet.

-		sprintf(tmp_sql, "UPDATE `%s` SET `class`='%d',`name`='%s',`account_id`='%d',`char_id`='%d',`level`='%d',`egg_id`='%d',`equip`='%d',`intimate`='%d',`hungry`='%d',`rename_flag`='%d',`incuvate`='%d' WHERE `pet_id`='%d'",

-			pet_db, p->class_, t_name, p->account_id, p->char_id, p->level, p->egg_id,

-			p->equip, p->intimate, p->hungry, p->rename_flag, p->incuvate, p->pet_id);

-	if(mysql_query(&mysql_handle, tmp_sql) ) {

-		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));

-		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

-		return 0;

-	} else if (pet_id == -1) { //New pet inserted.

-		if(mysql_field_count(&mysql_handle) == 0 &&

-			mysql_insert_id(&mysql_handle) != 0) {

-			p->pet_id = pet_id = (int)mysql_insert_id(&mysql_handle);

-		} else {

-			ShowError("inter_pet_tosql: Failed to retrieve new pet_id for '%s'. Pet creation aborted.\n", p->name);

-			return 0;

-		}

-	}

-

-	if (save_log)

-		ShowInfo("Pet saved %d - %s.\n", pet_id, p->name);

-	return 1;

-}

-#ifndef TXT_SQL_CONVERT

-int inter_pet_fromsql(int pet_id, struct s_pet *p){

-

-#ifdef NOISY

-	ShowInfo("Loading pet (%d)...\n",pet_id);

-#endif

-	memset(p, 0, sizeof(struct s_pet));

-

-	//`pet` (`pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`)

-

-	sprintf(tmp_sql,"SELECT `pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate` FROM `%s` WHERE `pet_id`='%d'",pet_db, pet_id);

-	if(mysql_query(&mysql_handle, tmp_sql) ) {

-		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));

-		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

-		return 0;

-	}

-	sql_res = mysql_store_result(&mysql_handle) ;

-	if (sql_res!=NULL && mysql_num_rows(sql_res)>0) {

-		sql_row = mysql_fetch_row(sql_res);

-

-		p->pet_id = pet_id;

-		p->class_ = atoi(sql_row[1]);

-		memcpy(p->name, sql_row[2],NAME_LENGTH-1);

-		p->account_id = atoi(sql_row[3]);

-		p->char_id = atoi(sql_row[4]);

-		p->level = atoi(sql_row[5]);

-		p->egg_id = atoi(sql_row[6]);

-		p->equip = atoi(sql_row[7]);

-		p->intimate = atoi(sql_row[8]);

-		p->hungry = atoi(sql_row[9]);

-		p->rename_flag = atoi(sql_row[10]);

-		p->incuvate = atoi(sql_row[11]);

-	}

-	if(p->hungry < 0)

-		p->hungry = 0;

-	else if(p->hungry > 100)

-		p->hungry = 100;

-	if(p->intimate < 0)

-		p->intimate = 0;

-	else if(p->intimate > 1000)

-		p->intimate = 1000;

-

-	mysql_free_result(sql_res);

-

-	if (save_log)

-		ShowInfo("Pet loaded (%d - %s).\n", pet_id, p->name);

-	return 0;

-}

-//----------------------------------------------

-

-int inter_pet_sql_init(void){

-	//memory alloc

-	pet_pt = (struct s_pet*)aCalloc(sizeof(struct s_pet), 1);

-	return 0;

-}

-void inter_pet_sql_final(void){

-	if (pet_pt) aFree(pet_pt);

-	return;

-}

-//----------------------------------

-int inter_pet_delete(int pet_id){

-	ShowInfo("delete pet request: %d...\n",pet_id);

-

-	sprintf(tmp_sql,"DELETE FROM `%s` WHERE `pet_id`='%d'",pet_db, pet_id);

-	if(mysql_query(&mysql_handle, tmp_sql) ) {

-		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));

-		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);

-	}

-	return 0;

-}

-//------------------------------------------------------

-int mapif_pet_created(int fd, int account_id, struct s_pet *p)

-{

-	WFIFOHEAD(fd, 11);

-	WFIFOW(fd, 0) =0x3880;

-	WFIFOL(fd, 2) =account_id;

-	if(p!=NULL){

-		WFIFOB(fd, 6)=0;

-		WFIFOL(fd, 7) =p->pet_id;

-		ShowInfo("int_pet: created pet %d - %s\n", p->pet_id, p->name);

-	}else{

-		WFIFOB(fd, 6)=1;

-		WFIFOL(fd, 7)=0;

-	}

-	WFIFOSET(fd, 11);

-

-	return 0;

-}

-

-int mapif_pet_info(int fd, int account_id, struct s_pet *p){

-	WFIFOHEAD(fd, sizeof(struct s_pet) + 9);

-	WFIFOW(fd, 0) =0x3881;

-	WFIFOW(fd, 2) =sizeof(struct s_pet) + 9;

-	WFIFOL(fd, 4) =account_id;

-	WFIFOB(fd, 8)=0;

-	memcpy(WFIFOP(fd, 9), p, sizeof(struct s_pet));

-	WFIFOSET(fd, WFIFOW(fd, 2));

-

-	return 0;

-}

-

-int mapif_pet_noinfo(int fd, int account_id){

-	WFIFOHEAD(fd, sizeof(struct s_pet) + 9);

-	WFIFOW(fd, 0) =0x3881;

-	WFIFOW(fd, 2) =sizeof(struct s_pet) + 9;

-	WFIFOL(fd, 4) =account_id;

-	WFIFOB(fd, 8)=1;

-	memset(WFIFOP(fd, 9), 0, sizeof(struct s_pet));

-	WFIFOSET(fd, WFIFOW(fd, 2));

-

-	return 0;

-}

-

-int mapif_save_pet_ack(int fd, int account_id, int flag){

-	WFIFOHEAD(fd, 7);

-	WFIFOW(fd, 0) =0x3882;

-	WFIFOL(fd, 2) =account_id;

-	WFIFOB(fd, 6) =flag;

-	WFIFOSET(fd, 7);

-

-	return 0;

-}

-

-int mapif_delete_pet_ack(int fd, int flag){

-	WFIFOHEAD(fd, 3);

-	WFIFOW(fd, 0) =0x3883;

-	WFIFOB(fd, 2) =flag;

-	WFIFOSET(fd, 3);

-

-	return 0;

-}

-

-int mapif_rename_pet_ack(int fd, int account_id, int char_id, int flag, char *name){

-	WFIFOHEAD(fd, NAME_LENGTH+12);

-	WFIFOW(fd, 0) =0x3884;

-	WFIFOL(fd, 2) =account_id;

-	WFIFOL(fd, 6) =char_id;

-	WFIFOB(fd, 10) =flag;

-	memcpy(WFIFOP(fd, 11), name, NAME_LENGTH);

-	WFIFOSET(fd, NAME_LENGTH+12);

-

-	return 0;

-}

-

-

-int mapif_create_pet(int fd, int account_id, int char_id, short pet_class, short pet_lv, short pet_egg_id,

-	short pet_equip, short intimate, short hungry, char rename_flag, char incuvate, char *pet_name){

-

-	memset(pet_pt, 0, sizeof(struct s_pet));

-	memcpy(pet_pt->name, pet_name, NAME_LENGTH-1);

-	if(incuvate == 1)

-		pet_pt->account_id = pet_pt->char_id = 0;

-	else {

-		pet_pt->account_id = account_id;

-		pet_pt->char_id = char_id;

-	}

-	pet_pt->class_ = pet_class;

-	pet_pt->level = pet_lv;

-	pet_pt->egg_id = pet_egg_id;

-	pet_pt->equip = pet_equip;

-	pet_pt->intimate = intimate;

-	pet_pt->hungry = hungry;

-	pet_pt->rename_flag = rename_flag;

-	pet_pt->incuvate = incuvate;

-

-	if(pet_pt->hungry < 0)

-		pet_pt->hungry = 0;

-	else if(pet_pt->hungry > 100)

-		pet_pt->hungry = 100;

-	if(pet_pt->intimate < 0)

-		pet_pt->intimate = 0;

-	else if(pet_pt->intimate > 1000)

-		pet_pt->intimate = 1000;

-

-	pet_pt->pet_id = -1; //Signal NEW pet.

-	if (inter_pet_tosql(pet_pt->pet_id,pet_pt))

-		mapif_pet_created(fd, account_id, pet_pt);

-	else	//Failed...

-		mapif_pet_created(fd, account_id, NULL);

-

-	return 0;

-}

-

-int mapif_load_pet(int fd, int account_id, int char_id, int pet_id){

-	memset(pet_pt, 0, sizeof(struct s_pet));

-

-	inter_pet_fromsql(pet_id, pet_pt);

-

-	if(pet_pt!=NULL) {

-		if(pet_pt->incuvate == 1) {

-			pet_pt->account_id = pet_pt->char_id = 0;

-			mapif_pet_info(fd, account_id, pet_pt);

-		}

-		else if(account_id == pet_pt->account_id && char_id == pet_pt->char_id)

-			mapif_pet_info(fd, account_id, pet_pt);

-		else

-			mapif_pet_noinfo(fd, account_id);

-	}

-	else

-		mapif_pet_noinfo(fd, account_id);

-

-	return 0;

-}

-

-int mapif_save_pet(int fd, int account_id, struct s_pet *data) {

-	//here process pet save request.

-	int len;

-	RFIFOHEAD(fd);

-	len=RFIFOW(fd, 2);

-	if(sizeof(struct s_pet)!=len-8) {

-		ShowError("inter pet: data size error %d %d\n", sizeof(struct s_pet), len-8);

-	}

-

-	else{

-		if(data->hungry < 0)

-			data->hungry = 0;

-		else if(data->hungry > 100)

-			data->hungry = 100;

-		if(data->intimate < 0)

-			data->intimate = 0;

-		else if(data->intimate > 1000)

-			data->intimate = 1000;

-		inter_pet_tosql(data->pet_id,data);

-		mapif_save_pet_ack(fd, account_id, 0);

-	}

-

-	return 0;

-}

-

-int mapif_delete_pet(int fd, int pet_id){

-	mapif_delete_pet_ack(fd, inter_pet_delete(pet_id));

-

-	return 0;

-}

-

-int mapif_rename_pet(int fd, int account_id, int char_id, char *name){

-	int i;

-

-	// Check Authorised letters/symbols in the name of the pet

-	if (char_name_option == 1) { // only letters/symbols in char_name_letters are authorised

-		for (i = 0; i < NAME_LENGTH && name[i]; i++)

-		if (strchr(char_name_letters, name[i]) == NULL) {

-			mapif_rename_pet_ack(fd, account_id, char_id, 0, name);

-			return 0;

-		}

-	} else if (char_name_option == 2) { // letters/symbols in char_name_letters are forbidden

-		for (i = 0; i < NAME_LENGTH && name[i]; i++)

-		if (strchr(char_name_letters, name[i]) != NULL) {

-			mapif_rename_pet_ack(fd, account_id, char_id, 0, name);

-			return 0;

-		}

-	}

-

-	mapif_rename_pet_ack(fd, account_id, char_id, 1, name);

-	return 0;

-}

-

-int mapif_parse_CreatePet(int fd){

-	RFIFOHEAD(fd);

-	mapif_create_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOW(fd, 10), RFIFOW(fd, 12), RFIFOW(fd, 14), RFIFOW(fd, 16), RFIFOW(fd, 18),

-		RFIFOW(fd, 20), RFIFOB(fd, 22), RFIFOB(fd, 23), (char*)RFIFOP(fd, 24));

-	return 0;

-}

-

-int mapif_parse_LoadPet(int fd){

-	RFIFOHEAD(fd);

-	mapif_load_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOL(fd, 10));

-	return 0;

-}

-

-int mapif_parse_SavePet(int fd){

-	RFIFOHEAD(fd);

-	mapif_save_pet(fd, RFIFOL(fd, 4), (struct s_pet *) RFIFOP(fd, 8));

-	return 0;

-}

-

-int mapif_parse_DeletePet(int fd){

-	RFIFOHEAD(fd);

-	mapif_delete_pet(fd, RFIFOL(fd, 2));

-	return 0;

-}

-

-int mapif_parse_RenamePet(int fd){

-	RFIFOHEAD(fd);

-	mapif_rename_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOP(fd, 10));

-	return 0;

-}

-

-int inter_pet_parse_frommap(int fd){

-	RFIFOHEAD(fd);

-	switch(RFIFOW(fd, 0)){

-	case 0x3080: mapif_parse_CreatePet(fd); break;

-	case 0x3081: mapif_parse_LoadPet(fd); break;

-	case 0x3082: mapif_parse_SavePet(fd); break;

-	case 0x3083: mapif_parse_DeletePet(fd); break;

-	case 0x3084: mapif_parse_RenamePet(fd); break;

-	default:

-		return 0;

-	}

-	return 1;

-}

-#endif //TXT_SQL_CONVERT

+// Copyright (c) Athena Dev Teams - Licensed under GNU GPL
+// For more information, see LICENCE in the main folder
+
+// original code from athena
+// SQL conversion by Jioh L. Jung
+
+#include <stdio.h>
+#include <stdlib.h>
+#include <string.h>
+
+#include "char.h"
+#include "../common/strlib.h"
+#include "../common/showmsg.h"
+
+struct s_pet *pet_pt;
+
+#ifndef SQL_DEBUG
+
+#define mysql_query(_x, _y) mysql_real_query(_x, _y, strlen(_y)) //supports ' in names and runs faster [Kevin]
+
+#else 
+
+#define mysql_query(_x, _y) debug_mysql_query(__FILE__, __LINE__, _x, _y)
+
+#endif
+
+//---------------------------------------------------------
+int inter_pet_tosql(int pet_id, struct s_pet *p) {
+	//`pet` (`pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`)
+	char t_name[NAME_LENGTH*2];
+
+	jstrescapecpy(t_name, p->name);
+
+	if(p->hungry < 0)
+		p->hungry = 0;
+	else if(p->hungry > 100)
+		p->hungry = 100;
+	if(p->intimate < 0)
+		p->intimate = 0;
+	else if(p->intimate > 1000)
+		p->intimate = 1000;
+	if (pet_id == -1) //New pet.
+		sprintf(tmp_sql,"INSERT INTO `%s` "
+			"(`class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`) "
+			"VALUES ('%d', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d', '%d')",
+			pet_db, p->class_, t_name, p->account_id, p->char_id, p->level, p->egg_id,
+			p->equip, p->intimate, p->hungry, p->rename_flag, p->incuvate);
+
+	else	//Update pet.
+		sprintf(tmp_sql, "UPDATE `%s` SET `class`='%d',`name`='%s',`account_id`='%d',`char_id`='%d',`level`='%d',`egg_id`='%d',`equip`='%d',`intimate`='%d',`hungry`='%d',`rename_flag`='%d',`incuvate`='%d' WHERE `pet_id`='%d'",
+			pet_db, p->class_, t_name, p->account_id, p->char_id, p->level, p->egg_id,
+			p->equip, p->intimate, p->hungry, p->rename_flag, p->incuvate, p->pet_id);
+	if(mysql_query(&mysql_handle, tmp_sql) ) {
+		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));
+		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);
+		return 0;
+	} else if (pet_id == -1) { //New pet inserted.
+		if(mysql_field_count(&mysql_handle) == 0 &&
+			mysql_insert_id(&mysql_handle) != 0) {
+			p->pet_id = pet_id = (int)mysql_insert_id(&mysql_handle);
+		} else {
+			ShowError("inter_pet_tosql: Failed to retrieve new pet_id for '%s'. Pet creation aborted.\n", p->name);
+			return 0;
+		}
+	}
+
+	if (save_log)
+		ShowInfo("Pet saved %d - %s.\n", pet_id, p->name);
+	return 1;
+}
+#ifndef TXT_SQL_CONVERT
+int inter_pet_fromsql(int pet_id, struct s_pet *p){
+
+#ifdef NOISY
+	ShowInfo("Loading pet (%d)...\n",pet_id);
+#endif
+	memset(p, 0, sizeof(struct s_pet));
+
+	//`pet` (`pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate`)
+
+	sprintf(tmp_sql,"SELECT `pet_id`, `class`,`name`,`account_id`,`char_id`,`level`,`egg_id`,`equip`,`intimate`,`hungry`,`rename_flag`,`incuvate` FROM `%s` WHERE `pet_id`='%d'",pet_db, pet_id);
+	if(mysql_query(&mysql_handle, tmp_sql) ) {
+		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));
+		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);
+		return 0;
+	}
+	sql_res = mysql_store_result(&mysql_handle) ;
+	if (sql_res!=NULL && mysql_num_rows(sql_res)>0) {
+		sql_row = mysql_fetch_row(sql_res);
+
+		p->pet_id = pet_id;
+		p->class_ = atoi(sql_row[1]);
+		memcpy(p->name, sql_row[2],NAME_LENGTH-1);
+		p->account_id = atoi(sql_row[3]);
+		p->char_id = atoi(sql_row[4]);
+		p->level = atoi(sql_row[5]);
+		p->egg_id = atoi(sql_row[6]);
+		p->equip = atoi(sql_row[7]);
+		p->intimate = atoi(sql_row[8]);
+		p->hungry = atoi(sql_row[9]);
+		p->rename_flag = atoi(sql_row[10]);
+		p->incuvate = atoi(sql_row[11]);
+	}
+	if(p->hungry < 0)
+		p->hungry = 0;
+	else if(p->hungry > 100)
+		p->hungry = 100;
+	if(p->intimate < 0)
+		p->intimate = 0;
+	else if(p->intimate > 1000)
+		p->intimate = 1000;
+
+	mysql_free_result(sql_res);
+
+	if (save_log)
+		ShowInfo("Pet loaded (%d - %s).\n", pet_id, p->name);
+	return 0;
+}
+//----------------------------------------------
+
+int inter_pet_sql_init(void){
+	//memory alloc
+	pet_pt = (struct s_pet*)aCalloc(sizeof(struct s_pet), 1);
+	return 0;
+}
+void inter_pet_sql_final(void){
+	if (pet_pt) aFree(pet_pt);
+	return;
+}
+//----------------------------------
+int inter_pet_delete(int pet_id){
+	ShowInfo("delete pet request: %d...\n",pet_id);
+
+	sprintf(tmp_sql,"DELETE FROM `%s` WHERE `pet_id`='%d'",pet_db, pet_id);
+	if(mysql_query(&mysql_handle, tmp_sql) ) {
+		ShowSQL("DB error - %s\n",mysql_error(&mysql_handle));
+		ShowDebug("at %s:%d - %s\n", __FILE__,__LINE__,tmp_sql);
+	}
+	return 0;
+}
+//------------------------------------------------------
+int mapif_pet_created(int fd, int account_id, struct s_pet *p)
+{
+	WFIFOHEAD(fd, 11);
+	WFIFOW(fd, 0) =0x3880;
+	WFIFOL(fd, 2) =account_id;
+	if(p!=NULL){
+		WFIFOB(fd, 6)=0;
+		WFIFOL(fd, 7) =p->pet_id;
+		ShowInfo("int_pet: created pet %d - %s\n", p->pet_id, p->name);
+	}else{
+		WFIFOB(fd, 6)=1;
+		WFIFOL(fd, 7)=0;
+	}
+	WFIFOSET(fd, 11);
+
+	return 0;
+}
+
+int mapif_pet_info(int fd, int account_id, struct s_pet *p){
+	WFIFOHEAD(fd, sizeof(struct s_pet) + 9);
+	WFIFOW(fd, 0) =0x3881;
+	WFIFOW(fd, 2) =sizeof(struct s_pet) + 9;
+	WFIFOL(fd, 4) =account_id;
+	WFIFOB(fd, 8)=0;
+	memcpy(WFIFOP(fd, 9), p, sizeof(struct s_pet));
+	WFIFOSET(fd, WFIFOW(fd, 2));
+
+	return 0;
+}
+
+int mapif_pet_noinfo(int fd, int account_id){
+	WFIFOHEAD(fd, sizeof(struct s_pet) + 9);
+	WFIFOW(fd, 0) =0x3881;
+	WFIFOW(fd, 2) =sizeof(struct s_pet) + 9;
+	WFIFOL(fd, 4) =account_id;
+	WFIFOB(fd, 8)=1;
+	memset(WFIFOP(fd, 9), 0, sizeof(struct s_pet));
+	WFIFOSET(fd, WFIFOW(fd, 2));
+
+	return 0;
+}
+
+int mapif_save_pet_ack(int fd, int account_id, int flag){
+	WFIFOHEAD(fd, 7);
+	WFIFOW(fd, 0) =0x3882;
+	WFIFOL(fd, 2) =account_id;
+	WFIFOB(fd, 6) =flag;
+	WFIFOSET(fd, 7);
+
+	return 0;
+}
+
+int mapif_delete_pet_ack(int fd, int flag){
+	WFIFOHEAD(fd, 3);
+	WFIFOW(fd, 0) =0x3883;
+	WFIFOB(fd, 2) =flag;
+	WFIFOSET(fd, 3);
+
+	return 0;
+}
+
+int mapif_rename_pet_ack(int fd, int account_id, int char_id, int flag, char *name){
+	WFIFOHEAD(fd, NAME_LENGTH+12);
+	WFIFOW(fd, 0) =0x3884;
+	WFIFOL(fd, 2) =account_id;
+	WFIFOL(fd, 6) =char_id;
+	WFIFOB(fd, 10) =flag;
+	memcpy(WFIFOP(fd, 11), name, NAME_LENGTH);
+	WFIFOSET(fd, NAME_LENGTH+12);
+
+	return 0;
+}
+
+
+int mapif_create_pet(int fd, int account_id, int char_id, short pet_class, short pet_lv, short pet_egg_id,
+	short pet_equip, short intimate, short hungry, char rename_flag, char incuvate, char *pet_name){
+
+	memset(pet_pt, 0, sizeof(struct s_pet));
+	memcpy(pet_pt->name, pet_name, NAME_LENGTH-1);
+	if(incuvate == 1)
+		pet_pt->account_id = pet_pt->char_id = 0;
+	else {
+		pet_pt->account_id = account_id;
+		pet_pt->char_id = char_id;
+	}
+	pet_pt->class_ = pet_class;
+	pet_pt->level = pet_lv;
+	pet_pt->egg_id = pet_egg_id;
+	pet_pt->equip = pet_equip;
+	pet_pt->intimate = intimate;
+	pet_pt->hungry = hungry;
+	pet_pt->rename_flag = rename_flag;
+	pet_pt->incuvate = incuvate;
+
+	if(pet_pt->hungry < 0)
+		pet_pt->hungry = 0;
+	else if(pet_pt->hungry > 100)
+		pet_pt->hungry = 100;
+	if(pet_pt->intimate < 0)
+		pet_pt->intimate = 0;
+	else if(pet_pt->intimate > 1000)
+		pet_pt->intimate = 1000;
+
+	pet_pt->pet_id = -1; //Signal NEW pet.
+	if (inter_pet_tosql(pet_pt->pet_id,pet_pt))
+		mapif_pet_created(fd, account_id, pet_pt);
+	else	//Failed...
+		mapif_pet_created(fd, account_id, NULL);
+
+	return 0;
+}
+
+int mapif_load_pet(int fd, int account_id, int char_id, int pet_id){
+	memset(pet_pt, 0, sizeof(struct s_pet));
+
+	inter_pet_fromsql(pet_id, pet_pt);
+
+	if(pet_pt!=NULL) {
+		if(pet_pt->incuvate == 1) {
+			pet_pt->account_id = pet_pt->char_id = 0;
+			mapif_pet_info(fd, account_id, pet_pt);
+		}
+		else if(account_id == pet_pt->account_id && char_id == pet_pt->char_id)
+			mapif_pet_info(fd, account_id, pet_pt);
+		else
+			mapif_pet_noinfo(fd, account_id);
+	}
+	else
+		mapif_pet_noinfo(fd, account_id);
+
+	return 0;
+}
+
+int mapif_save_pet(int fd, int account_id, struct s_pet *data) {
+	//here process pet save request.
+	int len;
+	RFIFOHEAD(fd);
+	len=RFIFOW(fd, 2);
+	if(sizeof(struct s_pet)!=len-8) {
+		ShowError("inter pet: data size error %d %d\n", sizeof(struct s_pet), len-8);
+	}
+
+	else{
+		if(data->hungry < 0)
+			data->hungry = 0;
+		else if(data->hungry > 100)
+			data->hungry = 100;
+		if(data->intimate < 0)
+			data->intimate = 0;
+		else if(data->intimate > 1000)
+			data->intimate = 1000;
+		inter_pet_tosql(data->pet_id,data);
+		mapif_save_pet_ack(fd, account_id, 0);
+	}
+
+	return 0;
+}
+
+int mapif_delete_pet(int fd, int pet_id){
+	mapif_delete_pet_ack(fd, inter_pet_delete(pet_id));
+
+	return 0;
+}
+
+int mapif_rename_pet(int fd, int account_id, int char_id, char *name){
+	int i;
+
+	// Check Authorised letters/symbols in the name of the pet
+	if (char_name_option == 1) { // only letters/symbols in char_name_letters are authorised
+		for (i = 0; i < NAME_LENGTH && name[i]; i++)
+		if (strchr(char_name_letters, name[i]) == NULL) {
+			mapif_rename_pet_ack(fd, account_id, char_id, 0, name);
+			return 0;
+		}
+	} else if (char_name_option == 2) { // letters/symbols in char_name_letters are forbidden
+		for (i = 0; i < NAME_LENGTH && name[i]; i++)
+		if (strchr(char_name_letters, name[i]) != NULL) {
+			mapif_rename_pet_ack(fd, account_id, char_id, 0, name);
+			return 0;
+		}
+	}
+
+	mapif_rename_pet_ack(fd, account_id, char_id, 1, name);
+	return 0;
+}
+
+int mapif_parse_CreatePet(int fd){
+	RFIFOHEAD(fd);
+	mapif_create_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOW(fd, 10), RFIFOW(fd, 12), RFIFOW(fd, 14), RFIFOW(fd, 16), RFIFOW(fd, 18),
+		RFIFOW(fd, 20), RFIFOB(fd, 22), RFIFOB(fd, 23), (char*)RFIFOP(fd, 24));
+	return 0;
+}
+
+int mapif_parse_LoadPet(int fd){
+	RFIFOHEAD(fd);
+	mapif_load_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOL(fd, 10));
+	return 0;
+}
+
+int mapif_parse_SavePet(int fd){
+	RFIFOHEAD(fd);
+	mapif_save_pet(fd, RFIFOL(fd, 4), (struct s_pet *) RFIFOP(fd, 8));
+	return 0;
+}
+
+int mapif_parse_DeletePet(int fd){
+	RFIFOHEAD(fd);
+	mapif_delete_pet(fd, RFIFOL(fd, 2));
+	return 0;
+}
+
+int mapif_parse_RenamePet(int fd){
+	RFIFOHEAD(fd);
+	mapif_rename_pet(fd, RFIFOL(fd, 2), RFIFOL(fd, 6), RFIFOP(fd, 10));
+	return 0;
+}
+
+int inter_pet_parse_frommap(int fd){
+	RFIFOHEAD(fd);
+	switch(RFIFOW(fd, 0)){
+	case 0x3080: mapif_parse_CreatePet(fd); break;
+	case 0x3081: mapif_parse_LoadPet(fd); break;
+	case 0x3082: mapif_parse_SavePet(fd); break;
+	case 0x3083: mapif_parse_DeletePet(fd); break;
+	case 0x3084: mapif_parse_RenamePet(fd); break;
+	default:
+		return 0;
+	}
+	return 1;
+}
+#endif //TXT_SQL_CONVERT