Ejemplo n.º 1
0
// Save guild_storage data to sql
int guild_storage_tosql(int guild_id, struct guild_storage *p) {
    int i,j;
//	int eqcount=1;
//	int noteqcount=1;
    int count=0;
    struct itemtmp mapitem[MAX_GUILD_STORAGE];
    for(i=0; i<MAX_GUILD_STORAGE; i++) {
        if(p->storage_[i].nameid>0) {
            mapitem[count].flag=0;
            mapitem[count].id = p->storage_[i].id;
            mapitem[count].nameid=p->storage_[i].nameid;
            mapitem[count].amount = p->storage_[i].amount;
            mapitem[count].equip = p->storage_[i].equip;
            mapitem[count].identify = p->storage_[i].identify;
            mapitem[count].refine = p->storage_[i].refine;
            mapitem[count].attribute = p->storage_[i].attribute;
            for (j=0; j<MAX_SLOTS; j++)
                mapitem[count].card[j] = p->storage_[i].card[j];
            count++;
        }
    }

    memitemdata_to_sql(mapitem, count, guild_id,TABLE_GUILD_STORAGE);

    ShowInfo ("guild storage save to DB - id: %d (total: %d)\n", guild_id,i);
    return 0;
}
Ejemplo n.º 2
0
// storage data -> DB conversion
int storage_tosql(int account_id,struct storage *p) {
    int i,j;
//	int eqcount=1;
//	int noteqcount=1;
    int count=0;
    struct itemtmp mapitem[MAX_STORAGE];
    for(i=0; i<MAX_STORAGE; i++) {
        if(p->storage_[i].nameid>0) {
            mapitem[count].flag=0;
            mapitem[count].id = p->storage_[i].id;
            mapitem[count].nameid=p->storage_[i].nameid;
            mapitem[count].amount = p->storage_[i].amount;
            mapitem[count].equip = p->storage_[i].equip;
            mapitem[count].identify = p->storage_[i].identify;
            mapitem[count].refine = p->storage_[i].refine;
            mapitem[count].attribute = p->storage_[i].attribute;
            for(j=0; j<MAX_SLOTS; j++)
                mapitem[count].card[j] = p->storage_[i].card[j];
            count++;
        }
    }

    memitemdata_to_sql(mapitem, count, account_id,TABLE_STORAGE);

    //printf ("storage dump to DB - id: %d (total: %d)\n", account_id, j);
    return 0;
}
Ejemplo n.º 3
0
// storage data -> DB conversion
int storage_tosql(int account_id,struct storage *p) {
    int i;
    int eqcount=1;
    int noteqcount=1;
    struct itemtemp mapitem;
    for(i=0; i<MAX_INVENTORY; i++) {
        if(p->storage[i].nameid>0) {
            if(itemdb_isequip(p->storage[i].nameid)==1) {
                mapitem.equip[eqcount].flag=0;
                mapitem.equip[eqcount].id = p->storage[i].id;
                mapitem.equip[eqcount].nameid=p->storage[i].nameid;
                mapitem.equip[eqcount].amount = p->storage[i].amount;
                mapitem.equip[eqcount].equip = p->storage[i].equip;
                mapitem.equip[eqcount].identify = p->storage[i].identify;
                mapitem.equip[eqcount].refine = p->storage[i].refine;
                mapitem.equip[eqcount].attribute = p->storage[i].attribute;
                mapitem.equip[eqcount].card[0] = p->storage[i].card[0];
                mapitem.equip[eqcount].card[1] = p->storage[i].card[1];
                mapitem.equip[eqcount].card[2] = p->storage[i].card[2];
                mapitem.equip[eqcount].card[3] = p->storage[i].card[3];
                eqcount++;
            }
            else if(itemdb_isequip(p->storage[i].nameid)==0) {
                mapitem.notequip[noteqcount].flag=0;
                mapitem.notequip[noteqcount].id = p->storage[i].id;
                mapitem.notequip[noteqcount].nameid=p->storage[i].nameid;
                mapitem.notequip[noteqcount].amount = p->storage[i].amount;
                mapitem.notequip[noteqcount].equip = p->storage[i].equip;
                mapitem.notequip[noteqcount].identify = p->storage[i].identify;
                mapitem.notequip[noteqcount].refine = p->storage[i].refine;
                mapitem.notequip[noteqcount].attribute = p->storage[i].attribute;
                mapitem.notequip[noteqcount].card[0] = p->storage[i].card[0];
                mapitem.notequip[noteqcount].card[1] = p->storage[i].card[1];
                mapitem.notequip[noteqcount].card[2] = p->storage[i].card[2];
                mapitem.notequip[noteqcount].card[3] = p->storage[i].card[3];
                noteqcount++;
            }
        }
    }

    memitemdata_to_sql(mapitem, eqcount, noteqcount, account_id,TABLE_STORAGE);

    //printf ("storage dump to DB - id: %d (total: %d)\n", account_id, j);
    return 0;
}
Ejemplo n.º 4
0
/// Save guild_storage data to sql
int guild_storage_tosql(int guild_id, struct guild_storage* p)
{
	memitemdata_to_sql(p->items, MAX_GUILD_STORAGE, guild_id, TABLE_GUILD_STORAGE);
	ShowInfo ("guild storage save to DB - guild: %d\n", guild_id);
	return 0;
}
Ejemplo n.º 5
0
/// Save storage data to sql
int storage_tosql(int account_id, struct storage_data* p)
{
	memitemdata_to_sql(p->items, MAX_STORAGE, account_id, TABLE_STORAGE);
	return 0;
}
Ejemplo n.º 6
0
/// Save guild_storage data to sql
int storage_tosql(int account_id, struct storage* p)
{
	memitemdata_to_sql(p->storage_, MAX_STORAGE, account_id, TABLE_STORAGE);
	//ShowInfo ("storage save to DB - account: %d\n", account_id);
	return 0;
}
Ejemplo n.º 7
0
/// Save guild_storage data to sql
int guild_storage_tosql(int guild_id, struct guild_storage* p)
{
	memitemdata_to_sql(p->items, MAX_GUILD_STORAGE, guild_id, TABLE_GUILD_STORAGE);
	ShowInfo(read_message("Source.char.storage_gtosql"), guild_id);
	return 0;
}
Ejemplo n.º 8
0
/// Save guild_storage data to sql
int guild_storage_tosql(int guild_id, struct guild_storage* p)
{
	memitemdata_to_sql(p->items, MAX_GUILD_STORAGE, guild_id, TABLE_GUILD_STORAGE);
	ShowInfo ("Salvamento dos dados do armazem de guild completado! (GID:%d).\n", guild_id);
	return 0;
}