Jump to content

Kreciok

Inactive Member
  • Posts

    17
  • Joined

  • Last visited

  • Days Won

    1
  • Feedback

    0%

Posts posted by Kreciok

  1. Make sure you load items in every windows. ClientManagerPlayer.cpp
     

    		#ifdef ENABLE_SPECIAL_STORAGE
    		snprintf(queryStr, sizeof(queryStr),
    			"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
    			"FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))",
    			GetTablePostfix(), packet->player_id);
    		#else
    		snprintf(queryStr, sizeof(queryStr),
    				"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
    				"FROM item%s WHERE owner_id=%d AND (window < %d or window = %d)",
    				GetTablePostfix(), packet->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY);
    		#endif
    
    		#ifdef ENABLE_SPECIAL_STORAGE
    			snprintf(szQuery, sizeof(szQuery),
    				"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
    				"FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))",
    				GetTablePostfix(), pTab->id);
    			#else
    			snprintf(szQuery, sizeof(szQuery), 
    					"SELECT id,window+0,pos,count,vnum,socket0,socket1,socket2,attrtype0,attrvalue0,attrtype1,attrvalue1,attrtype2,attrvalue2,attrtype3,attrvalue3,attrtype4,attrvalue4,attrtype5,attrvalue5,attrtype6,attrvalue6 "
    					"FROM item%s WHERE owner_id=%d AND (window < %d or window = %d)",
    					GetTablePostfix(), pTab->id, SAFEBOX, DRAGON_SOUL_INVENTORY);
    			#endif

    Also u should check a delete query:
     

    #ifdef ENABLE_SPECIAL_STORAGE
    		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window in ('INVENTORY','EQUIPMENT','DRAGON_SOUL_INVENTORY','BELT_INVENTORY','UPGRADE_INVENTORY','BOOK_INVENTORY','STONE_INVENTORY'))", GetTablePostfix(), pi->player_id);
    #else
    		snprintf(queryStr, sizeof(queryStr), "DELETE FROM item%s WHERE owner_id=%d AND (window < %d or window = %d)", GetTablePostfix(), pi->player_id, SAFEBOX, DRAGON_SOUL_INVENTORY);
    #endif

    You can also check it easier by changing just this lines in a query: SAFEBOX, DRAGON_SOUL_INVENTORY -> on a SAFEBOX, STONE_INVENTORY.

  2. M2 Download Center

    This is the hidden content, please
    ( Internal )

    Hello today i created a new dungeon map based on dawnmistwood zone and textures.

    To make this map work u need: property and zone of dawnmistwood dungeon ( new forest map ). You can find it on forum i wont upload it because this models are not mine.

    Hope u like it. :lol:

    https://mega.nz/file/bqJixIDC#UqAEq60PQg0oUGEvEovqaKGfH1vPCn9X2TWswqtwdzc

     

    • Metin2 Dev 27
    • Dislove 1
    • Sad 2
    • Confused 3
    • Lmao 1
    • Good 10
    • Love 3
    • Love 25
×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.