Need help about delete items received

Results 1 to 14 of 14
  1. #1
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Need help about delete items received

    Hi,

    I use SerusUriel v15 files.

    We automatically receive items in the inventory at lvl 20 40 60 80 100 and 120 and I wanna change them or delete it..

    I searched in the database but didn't found anything..

    Can somebody help me please ?

    Thanx ^^


  2. #2
    [R8]ℓσℓ32 caja is offline
    Grand MasterRank
    Oct 2008 Join Date
    Here!Location
    1,502Posts

    Re: Need help about delete items received

    It's not in database. Search in resource files, I think it's an event.

  3. #3
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts
    Oh ok ty I'll search this side ^^

    Hum I Don't find anything in ressources files...

    Someone can help me ?

    Thanx

    Bump ^^
    Last edited by CrashOveride; 21-06-10 at 09:09 PM.

  4. #4
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Re: Need help about delete items received

    Bump, plz help ^^

  5. #5
    Member Jeremey is offline
    MemberRank
    Jul 2009 Join Date
    27Posts

    Re: Need help about delete items received

    Be patient like everyone is supposed to be.. But, I have the same files I'll look around to see if I can find it.

  6. #6
    Sorcerer Supreme killerdog is offline
    Member +Rank
    Apr 2009 Join Date
    HellLocation
    293Posts

    Re: Need help about delete items received

    its in Event.lua

    AddEvent( "Event Name" )
    --{
    SetTime( "2009-02-23 00:00", "2011-02-25 23:59" )//TIME
    SetExpFactor( 30 )//EXP RATE
    SetItemDropRate( 30 )// DROP RATE
    SetPieceItemDropRate( 50 )//ANOTHER DROP RATE??
    SetGoldDropFactor( 50 )//PENYA RATE
    SetLevelUpGift( 20, "all", ITEM_NAME, 1, 2 )// Level, Who-Receives, Item-name How Many, IDK
    SetLevelUpGift( 40, "all", ITEM_NAME, 1, 2 )
    SetLevelUpGift( 60, "all", ITEM_NAME, 1, 2 )
    SetLevelUpGift( 80, "all", ITEM_NAME, 1, 2 )
    SetLevelUpGift( 100, "all", ITEM_NAME, 1, 2 )
    SetLevelUpGift( 120, "all", ITEM_NAME, 1, 2 )
    --}
    Last edited by killerdog; 22-06-10 at 01:13 AM.

  7. #7
    Member Jeremey is offline
    MemberRank
    Jul 2009 Join Date
    27Posts

    Re: Need help about delete items received

    Yes in that file find this line "---- 11. SetLevelUpGift( nLevel, "all", ItemId, nNum, byFlag ) -- ·¹º§¾÷ ¼±¹°( nLevel´Þ¼º½Ã ¾ÆÀÌÅÛ Áö±Þ, "all" ºÎºÐ¿¡ ƯÁ¤ °èÁ¤ ÁöÁ¤ °¡´É(¿¹. "__bu" - ¹öµð, "__an" - ¿£Á© )" I believe that is it.. Delete it, if its not come back and copy the code and put it back in the file.

  8. #8
    Sorcerer Supreme killerdog is offline
    Member +Rank
    Apr 2009 Join Date
    HellLocation
    293Posts

    Re: Need help about delete items received

    Quote Originally Posted by Jeremey View Post
    Yes in that file find this line "---- 11. SetLevelUpGift( nLevel, "all", ItemId, nNum, byFlag ) -- ·¹º§¾÷ ¼±¹°( nLevel´Þ¼º½Ã ¾ÆÀÌÅÛ Áö±Þ, "all" ºÎºÐ¿¡ ƯÁ¤ °èÁ¤ ÁöÁ¤ °¡´É(¿¹. "__bu" - ¹öµð, "__an" - ¿£Á© )" I believe that is it.. Delete it, if its not come back and copy the code and put it back in the file.
    Put what i said below Begin Script

  9. #9
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Re: Need help about delete items received

    I alrealdy search this side but no event that corresponds...

    This is my event.lua :

    Spoiler:
    ----------------------------------------------------------------------
    ---- À̺¥Æ® °ü·Ã ·ç¾Æ ÇÔ¼ö ·Îµù --------------------------------------
    ----------------------------------------------------------------------
    dofile(".\\LuaFunc\\EventFunc.lua")

    ----------------------------------------------------------------------
    -- ÀÚµ¿ °øÁö (°¢ ¼­¹ö±º TRANS Server ¸¸ ¼öÁ¤ÇÏ¸é µÅ¿ä ^^) ------------
    ----------------------------------------------------------------------
    bNotice = true -- ÀÚµ¿ °øÁö ½ÇÇà ¿©ºÎ(true or false)
    Notice( "Tue 08:44", 5, 10 ) -- ÀÚµ¿°øÁö½Ã°£, °øÁö°£°Ý(MIN), °øÁö Ƚ¼ö
    --{
    AddMessage( "¾È³çÇϼ¼¿ä. Flyff ÀÔ´Ï´Ù." )
    AddMessage( "¿ÀÀü 9½ÃºÎÅÍ ¿øÈ°ÇÑ ¼­ºñ½º¸¦ À§ÇÑ" )
    AddMessage( "Á¤±â Á¡°ËÀÌ ÁøÇà µÉ ¿¹Á¤ ÀÔ´Ï´Ù." )
    AddMessage( "¾ÈÀüÇÑ Àå¼Ò¿¡¼­ Á¢¼Ó Á¾·á¸¦ ÇØ Áֽñ⠹ٶø´Ï´Ù." )
    --}

    ----------------------------------------------------------------------
    ---- ÃʱâÈ­ ----------------------------------------------------------
    ----------------------------------------------------------------------

    -- ½Ã°£´ëº° ¾ÆÀÌÅÛ µå·Ó °¡ÁßÄ¡
    tHour = { 505, 409, 324, 280, 220, 203, 202, 212,
    227, 261, 302, 349, 571, 701, 764, 803,
    790, 789, 754, 849, 936, 940, 919, 720 }
    ----------------------------------------------------------------------


    ----------------------------------------------------------------------------------------------------------------
    ---- 1. AddEvent( strDesc ) -- À̺¥Æ® Ãß°¡ ¹× ¼³¸í µî·Ï
    ---- 2. SetTime( strStartTime, strEndTime ) -- ÇØ´ç À̺¥Æ®ÀÇ ½ÃÀÛ ½Ã°£, Á¾·á ½Ã°£ µî·Ï(¿©·¯°³ ¼³Á¤ °¡´É)
    ---- ( ½Ã°£ Çü½Ä -- "2007-05-03 17:53" )
    ---- 3. SetItem( ItemId, nMax, nNum, nLevel ) -- À̺¥Æ®¿ë µå·Ó ¾ÆÀÌÅÛ, ÀÏÀÏ ÃÖ´ë·®, µå·Ó °¹¼ö(·£´ý),
    ---- ¾ÆÀÌÅÛÀ» µå·ÓÇÒ ¸ó½ºÅÍÀÇ ÃÖ¼Ò ·¹º§ - ¿©·¯°³ °¡´É
    ---- 4. SetExpFactor( fFactor ) -- °æÇèÁö Áõ°¡ ¹è¼ö
    ---- 5. SetItemDropRate( fFactor ) -- ¾ÆÀÌÅÛ µå·Ó·ü Áõ°¡ ¹è¼ö
    ---- 6. SetPieceItemDropRate( fFactor ) -- ¸ó½ºÅͰ¡ °¡Áö°í ÀÖ´Â ³¹°³ ¾ÆÀÌÅÛÀÇ µå¶ø·ü Áõ°¡ ¹è¼ö
    ---- 7. SetGoldDropFactor( fFactor ) -- Æä³Ä µå·Ó ¹è¼ö
    ---- 8. SetAttackPower( nAttackPower ) -- °ø°Ý·Â Áõ°¡
    ---- 9. SetDefensePower( nDefensePower ) -- ¹æ¾î·Â Áõ°¡
    ---- 10. SetCouponEvent( SEC(n) ) -- ÄíÆù À̺¥Æ®( Á¢¼Ó½Ã°£ - SEC(n) ¶Ç´Â MIN(n) )
    ---- 11. SetLevelUpGift( nLevel, "all", ItemId, nNum, byFlag ) -- ·¹º§¾÷ ¼±¹°( nLevel´Þ¼º½Ã ¾ÆÀÌÅÛ Áö±Þ, "all" ºÎºÐ¿¡ ƯÁ¤ °èÁ¤ ÁöÁ¤ °¡´É(¿¹. "__bu" - ¹öµð, "__an" - ¿£Á© )
    ---- 12. SetCheerExpFactor( fFactor ) -- ÀÀ¿ø °æÇèÄ¡ ¼³Á¤
    ---- 13. SetSpawn( TYPE, strId, nNum ) -- ½ºÆùÀ̺¥Æ® : Type - ITEM ¶Ç´Â MONSTER, ID, 1ÀÏ ½ºÆù·®
    ---- 14. SetKeepConnectEvent( nTime, strItemId, nItemNum ) -- ´©Àû Á¢¼Ó ¾ÆÀÌÅÛ Áö±Þ À̺¥Æ®( Á¢¼Ó½Ã°£, ¾ÆÀÌÅÛ ID, ¾ÆÀÌÅÛ °³¼ö )
    ---- 15. SetRainEvent( fExpFactor, strTitle ) -- À帶À̺¥Æ®(°æÇèÄ¡ Áõ°¡ ¹è¼ö, ºñ¿Ã¶§ Ãß·Â Á¦¸ñ) : 15Â÷¿¡ Ãß°¡µÊ
    ---- 16. SetSnowEvent( fExpFactor, strTitle ) -- °­¼³À̺¥Æ®(°æÇèÄ¡ Áõ°¡ ¹è¼ö, ´«¿Ã¶§ Ãß·Â Á¦¸ñ)
    ---- *** À̺¥Æ® Ãß°¡ µî·Ï½Ã 1¹øºÎÅÍ ¹Ýº¹Çϰí 3~16¹øÀº Çʿ信 µû¶ó »ý·«°¡´ÉÇÏ´Ù.
    ----------------------------------------------------------------------------------------------------------------
    --[[ SAMPLE
    AddEvent( "EVENT TEST 01" )
    --{
    SetTime( "2007-06-08 14:23", "2007-06-08 16:11" )
    SetTime( "2007-06-09 14:23", "2007-06-10 00:00" )

    SetItem( "II_SYS_SYS_EVE_HAPPYMONEY01", 30000, 5, 15 )
    SetItem( "II_SYS_SYS_EVE_PUMPKIN01", 2000, 3, 15 )
    SetExpFactor( 2 )
    SetItemDropRate( 2 )
    SetPieceItemDropRate( 2 )
    SetGoldDropFactor( 2 )
    SetAttackPower( 150 )
    SetDefensePower( 100 )
    SetCouponEvent( MIN(120) )
    SetLevelUpGift( 15, "__bu", "II_SYS_SYS_SCR_BX_PET_LAWOLF7", 1, 2 )
    SetCheerExpFactor( 1.3 )
    SetSpawn( ITEM, "II_SYS_SYS_EVE_HAPPYMONEY01", 10000 )
    SetSpawn( MONSTER, "MI_AIBATT1", 2000 )
    SetSpawn( MONSTER, "MI_AIBATT4", 2000 )
    SetKeepConnectEvent( MIN(60), "II_SYS_SYS_SCR_BXTREASURE01", 1 )
    SetRainEvent( 2, "ºñ°¡¿À¸é °æÇèÄ¡°¡ 2¹è~!" )
    SetSnowEvent( 2, "´«ÀÌ¿À¸é °æÇèÄ¡°¡ 2¹è~!" )
    --}
    --]]

    -------------------------------------------------------------------------
    ---- Begin Script -------------------------------------------------------
    -------------------------------------------------------------------------

    AddEvent( "Mochikochi" )
    --{
    SetTime( "2010-05-25 20:00", "2010-02-25 23:59" )

    SetSpawn( MONSTER, "MI_MOCOMOCHI1", 500 )
    --}

    AddEvent( "Rain Event : Exp X2" )
    --{
    SetTime( "2010-05-25 20:00", "2010-02-25 23:59" )

    SetRainEvent( 10, "Sauve qui pleut !" )

    SetSnowEvent( 10, "Sauve qui neige !" )
    --}


    AddEvent( "Evenement de Bienvenue" )
    --{
    SetTime( "2010-05-25 20:00", "2019-02-25 23:59" )

    SetLevelUpGift( 20, "all", "II_SYS_SYS_SCR_AMPESB", 3 )
    SetLevelUpGift( 61, "all", "II_SYS_SYS_SCR_AMPESC", 3 )
    --}

    AddEvent( "Il était temps !" )
    --{
    SetTime( "2010-05-25 20:00", "2010-02-25 23:59" )

    SetKeepConnectEvent( MIN(60), "II_SYS_SYS_SCR_BXTREASURE01", 1 )
    --}

    bNotice = true -- ÀÚµ¿ °øÁö ½ÇÇà ¿©ºÎ(true or false)
    Notice( "Thu 18:20", 30, 50 ) -- ÀÚµ¿°øÁö½Ã°£, °øÁö°£°Ý(MIN), °øÁö Ƚ¼ö
    --{
    AddMessage( "N'oubliez pas, vos ids de connexion vous sont propres : Ne les donnez à personne !" )
    AddMessage( "Retrouvez 'Le Quart d'heure De Losha' du Lundi au vendredi aux environs de 20h. Soyez tous au rdv : Des cadeaux et d'autres surprises à gagner ^^ (Plus d'infos sur notre site!) " )
    AddMessage( "Découvrez le panel de Donation sur notre site : Il vous donnera accès aux exclusivités Fly4Seasons !" )
    --}

  10. #10
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Re: Need help about delete items received

    Someone can help me ?

    Please and thanx :s

  11. #11
    Sorcerer Supreme Aries is offline
    Member +Rank
    Aug 2008 Join Date
    on your CPULocation
    336Posts

    Re: Need help about delete items received

    what items do you get at these levels?
    are they going straight into your Inventory?

    cause i found a passage inside the MAIL_STR_REALTIME but not sure if it could be this

    Code:
              IF( @nLevel = 20 ) BEGIN
                            SET @ItemID = 26112
                    END
                    ELSE IF( @nLevel = 40 ) BEGIN
                            SET @ItemID = 26211
                    END
                    ELSE IF( @nLevel = 60 ) BEGIN
                            SET @ItemID = 26103
                    END
                    ELSE IF( @nLevel = 80 ) BEGIN
                            SET @ItemID = 30135
                    END
                    ELSE IF( @nLevel = 100 ) BEGIN
                            SET @ItemID = 5800
                            SET @bBinds = 0
                    END
                    ELSE IF( @nLevel = 120 ) BEGIN
                            SET @ItemID = 4703
                            SET @bBinds = 0

  12. #12
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Re: Need help about delete items received

    Hi and thanx for your answer,

    I remember at lvl 120 I receive a dragon cloak.

    I thought about the query you give me, I tried to change items on it but in game I still receive the old items (dragon cloak ..)

    And yes, I reveive items in my inventory, not mail..

  13. #13
    Sorcerer Supreme Aries is offline
    Member +Rank
    Aug 2008 Join Date
    on your CPULocation
    336Posts

    Re: Need help about delete items received

    dragon cloak has the ID 4703 which is the last of this query

    did you restart the server after changing the ID?

  14. #14
    Sorcerer Supreme amylesia is offline
    Member +Rank
    Apr 2009 Join Date
    257Posts

    Re: Need help about delete items received

    Yes, I did :s

    Could you tell me where is the table to find items and change them manually or check them? Or help me another way ^^

    Thanx for your help :)

    Edit : I found is in stored procedure.. I deleted lines with items to send and else : command is ok but still receive items in game..
    Last edited by amylesia; 24-06-10 at 02:56 PM.



Advertisement