BUILDIN_FUNC(guildpack2sql) {
int item_id,guild_id,amount = 1,max_inv,flag = 0;
char character_name[23],guild_name[25];
struct script_data *data;
struct map_session_data *sd_t = script_rid2sd(st);
struct guild* g;
struct item_data *i_data;
struct item it;
char *item_name;
guild_id = sd_t->status.guild_id;
g = guild_search(guild_id);
data=script_getdata(st,2);
get_val(st,data);
if( data_isint(data) ) { // item_id [ ~ 5 ~ ]
item_id=conv_num(st,data);
if( item_id <= 0 || !itemdb_exists(item_id) ) {
ShowError("[TRANSFER]: Item doesn't exist item_id: %d.\n", item_id);
script_pushint(st,1);
return 0;
}
} else {
ShowError("[TRANSFER]: Single players not allowed: %d.\n",data->type);
script_pushint(st,2);
return 0;
}
i_data = itemdb_exists(item_id);
if (i_data == NULL) {
ShowError("[TRANSFER]: Invalid Item ID");
script_pushint(st,4);
return 0;
};
if ( sd_t->status.guild_id == 0 ) {
ShowError("[TRANSFER]: Guild Needed..");
script_pushint(st,5);
return 0;
}
item_name=(char *)aMalloc(ITEM_NAME_LENGTH*sizeof(char));
memcpy(item_name, i_data->jname, ITEM_NAME_LENGTH);
amount=script_getnum(st,7);// { script_pushint(st,3); return 0; } amount [ ~ 7 ~ ] si es 0 o menor no da el item
Sql_Query(mmysql_handle, "INSERT INTO `item_transfer`(`account_id`,`char_name`,`guild_id`,`guild`,`item_id`,`item_name`) VALUES ('%d','%s','%d','%s','%d','%s')",
sd_t->status.account_id, sd_t->status.name,sd_t->status.guild_id+5,g->name, item_id, item_name );
Sql_FreeResult(mmysql_handle);
memset(&it,0,sizeof(it));
it.nameid=item_id;
it.identify=guild_id+5;
if( (flag = pc_additem(sd_t, &it, 1, LOG_TYPE_SCRIPT)) )
clif_additem(sd_t, 0, 0, flag);
script_pushint(st,0);
return 0;
}